array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 30001665 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23449
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23451
+post_id: "1601942"
+post_author: 1
+"ListingKey": "30001665"
+"ListingId": "40845825"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-07T20:35:24Z"
+"RFModificationTimestamp": "2026-07-07T23:05:47Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1650.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2R6"
+"UnparsedAddress": "706 KEATSWOOD Crescent, Waterloo, Ontario N2T2R6"
+"Coordinates": array:2 [
0 => -80.5723904
1 => 43.4557678
]
+"Latitude": 43.4557678
+"Longitude": -80.5723904
+"YearBuilt": 1997
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 706 Keatswood Crescent, Waterloo! This well-maintained 3-bedroom detached home is available for lease and is ideally located in a quiet, family-friendly neighbourhood close to excellent schools, shopping, parks, and public transit. Offering a functional layout, spacious living areas, and excellent proximity to major amenities, this home is ideal for families and professionals seeking comfort and convenience. As you enter the home, you are greeted by a bright and welcoming foyer featuring a convenient powder room and direct access to the attached garage. The main floor boasts an open-concept design that creates a warm and inviting atmosphere for everyday living and entertaining. The spacious kitchen is thoughtfully designed with an abundance of cabinetry and ample counter space. Its open layout overlooks the living area, allowing you to stay connected with family and guests while preparing meals. Adjacent to the kitchen is a generous dining area enhanced by large windows that fill the space with natural light. The bright and airy living room offers plenty of room for relaxation and gatherings. Sliding patio doors provide easy access to a private deck, perfect for enjoying your morning coffee, summer barbecues, or outdoor entertaining. Upstairs, you'll find three spacious bedrooms featuring attractive carpet-free flooring for easy maintenance and a modern look. The upper level also includes a well-appointed Jack-and-Jill bathroom. A standout feature of this home is a versatile nook/office space with new flooring on second floor. Enjoy the convenience of an attached garage, a fully fenced backyard with a deck, a cold cellar for additional storage, and an unfinished basement providing ample storage space. Included for tenant use are the refrigerator, stove, microwave, washer, and dryer. The home is equipped with a high-efficiency furnace, central air conditioning, and a hot water tank. This is a smoke-free property. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-07T23:05:42.532619+00:00"
+"Directions": "ERBSVILLE ROAD/KEATS WAY"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2259465"
+"ListOfficeKey": "290392"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-07T20:29:23Z"
+"PhotosCount": 11
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-07T20:29:23Z"
+"Stories": "2.0"
+"StreetName": "KEATSWOOD"
+"StreetNumber": "706"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "440 - Upper Beechwood/Beechwood W."
+"TaxAnnualAmount": "4206"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [
"RoomKey" => "1677609064"
"RoomType" => "Family room"
"ListingId" => "40845825"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30001665"
"RoomLength" => null
"RoomDimensions" => "21'7'' x 15'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T20:29:23.89Z"
]
1 => array:11 [
"RoomKey" => "1677609065"
"RoomType" => "Laundry room"
"ListingId" => "40845825"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30001665"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T20:29:23.89Z"
]
2 => array:11 [
"RoomKey" => "1677609066"
"RoomType" => "3pc Bathroom"
"ListingId" => "40845825"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30001665"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T20:29:23.89Z"
]
3 => array:11 [
"RoomKey" => "1677609067"
"RoomType" => "Bedroom"
"ListingId" => "40845825"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30001665"
"RoomLength" => null
"RoomDimensions" => "14'4'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T20:29:23.89Z"
]
4 => array:11 [
"RoomKey" => "1677609068"
"RoomType" => "Bedroom"
"ListingId" => "40845825"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30001665"
"RoomLength" => null
"RoomDimensions" => "14'4'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T20:29:23.89Z"
]
5 => array:11 [
"RoomKey" => "1677609069"
"RoomType" => "Primary Bedroom"
"ListingId" => "40845825"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30001665"
"RoomLength" => null
"RoomDimensions" => "14'2'' x 15'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T20:29:23.89Z"
]
6 => array:11 [
"RoomKey" => "1677609070"
"RoomType" => "2pc Bathroom"
"ListingId" => "40845825"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30001665"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T20:29:23.89Z"
]
7 => array:11 [
"RoomKey" => "1677609071"
"RoomType" => "Dining room"
"ListingId" => "40845825"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30001665"
"RoomLength" => null
"RoomDimensions" => "8'2'' x 9'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T20:29:23.89Z"
]
8 => array:11 [
"RoomKey" => "1677609072"
"RoomType" => "Kitchen"
"ListingId" => "40845825"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30001665"
"RoomLength" => null
"RoomDimensions" => "7'0'' x 9'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T20:29:23.89Z"
]
9 => array:11 [
"RoomKey" => "1677609073"
"RoomType" => "Living room"
"ListingId" => "40845825"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30001665"
"RoomLength" => null
"RoomDimensions" => "15'9'' x 10'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T20:29:23.9Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30001665/706-keatswood-crescent-waterloo"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 2650
+"ZoningDescription": "MD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 1650
+"OriginalEntryTimestamp": "2026-07-07T20:29:23.86Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1499384"
+"ListOfficeNationalAssociationId": "1386847"
+"Media": array:11 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30001665_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001665/e772f55a5eace9ab6a887bd8e845820d.webp"
"MediaSize" => 118735
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001665/thumbnail-e772f55a5eace9ab6a887bd8e845820d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Two-story residence featuring a combination of brick and siding, an integrated garage with a white panel door, a white picket fence, and mature landscaping"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40845825"
"ResourceRecordKey" => "30001665"
"ModificationTimestamp" => "2026-07-07T20:29:23.87Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30001665_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001665/f0435a9c2be32c4fd07557878c6285e5.webp"
"MediaSize" => 41959
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001665/thumbnail-f0435a9c2be32c4fd07557878c6285e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive room featuring wood-finish flooring, neutral-toned walls, and white baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845825"
"ResourceRecordKey" => "30001665"
"ModificationTimestamp" => "2026-07-07T20:29:23.87Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30001665_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001665/8a1db98f0bd6e938d6b1e036aa5a8cc3.webp"
"MediaSize" => 69565
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001665/thumbnail-8a1db98f0bd6e938d6b1e036aa5a8cc3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring wood-finish cabinetry, a central island with a countertop, a window above the sink, white appliances, and tiled flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845825"
"ResourceRecordKey" => "30001665"
"ModificationTimestamp" => "2026-07-07T20:29:23.87Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30001665_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001665/631614f67ddcecd37217303c79d8bc41.webp"
"MediaSize" => 34339
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001665/thumbnail-631614f67ddcecd37217303c79d8bc41.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring tile flooring, a white window with horizontal blinds, a white toilet, and a vanity with a light wood-finish cabinet, integrated sink, and a light-colored countertop"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845825"
"ResourceRecordKey" => "30001665"
"ModificationTimestamp" => "2026-07-07T20:29:23.87Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30001665_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001665/a3aa31c05d850c50a7f072dddc6658eb.webp"
"MediaSize" => 53926
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001665/thumbnail-a3aa31c05d850c50a7f072dddc6658eb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Wood-finish flooring throughout the upper landing, complementing the light wood balusters and handrail"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845825"
"ResourceRecordKey" => "30001665"
"ModificationTimestamp" => "2026-07-07T20:29:23.87Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30001665_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001665/75cddc3f32172d76222a27e0e97ecf97.webp"
"MediaSize" => 40307
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001665/thumbnail-75cddc3f32172d76222a27e0e97ecf97.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious interior room featuring wood-finish flooring, a multi-pane window with an arched transom, and a ceiling fan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845825"
"ResourceRecordKey" => "30001665"
"ModificationTimestamp" => "2026-07-07T20:29:23.87Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30001665_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001665/0b4e2551fd0c9a0ef53674c2ab8d41de.webp"
"MediaSize" => 40197
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001665/thumbnail-0b4e2551fd0c9a0ef53674c2ab8d41de.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a vanity with a white oval sink, dark countertop, and wood-finish cabinetry"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845825"
"ResourceRecordKey" => "30001665"
"ModificationTimestamp" => "2026-07-07T20:29:23.87Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30001665_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001665/97f75f1fb9331dd75ce18bad86603b75.webp"
"MediaSize" => 44179
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001665/thumbnail-97f75f1fb9331dd75ce18bad86603b75.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Room featuring wood-finish flooring, neutral wall paint, and white trim"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845825"
"ResourceRecordKey" => "30001665"
"ModificationTimestamp" => "2026-07-07T20:29:23.87Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30001665_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001665/44204f160b30d52f82744f1ec325f393.webp"
"MediaSize" => 39436
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001665/thumbnail-44204f160b30d52f82744f1ec325f393.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Interior room featuring wood-finish flooring, neutral wall paint, white baseboards, a single window, and a ceiling-mounted light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845825"
"ResourceRecordKey" => "30001665"
"ModificationTimestamp" => "2026-07-07T20:29:23.87Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30001665_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001665/9ae345b1424759f89f006ceb8de72042.webp"
"MediaSize" => 118736
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001665/thumbnail-9ae345b1424759f89f006ceb8de72042.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick exterior with white patio sliding doors, a green raised garden bed, and a wooden fence surrounding a grass lawn"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845825"
"ResourceRecordKey" => "30001665"
"ModificationTimestamp" => "2026-07-07T20:29:23.87Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30001665_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001665/a6ba6e4ee3842eef52cea11902748c8b.webp"
"MediaSize" => 139757
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001665/thumbnail-a6ba6e4ee3842eef52cea11902748c8b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Wood-finish decking with a slatted wood railing overlooking mature trees and white-sided exterior properties"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845825"
"ResourceRecordKey" => "30001665"
"ModificationTimestamp" => "2026-07-07T20:29:23.87Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30001665')"
+"ID": "1601942"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 290392" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24848
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2259465" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24909
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24817
+post_id: ? mixed
+post_author: ? mixed
+"MemberMlsId": "2259465"
+"ModificationTimestamp": "2026-07-07T23:05:33Z"
+"OriginatingSystemName": "CREA"
+"MemberKey": "2259465"
+"MemberPreferredPhoneExt": null
+"MemberMlsSecurityClass": null
+"MemberNationalAssociationId": null
+"MemberAddress1": null
+"MemberType": null
+"MemberDesignation": null
+"MemberCity": null
+"MemberStateOrProvince": null
+"MemberPostalCode": null
+"OriginalEntryTimestamp": null
+"MemberOfficePhone": null
+"MemberOfficePhoneExt": null
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Member('2259465')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '30001665'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25180
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '30001665'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25196
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '30001665' AND (PropertyType eq 'Residential Lease' OR PropertyType eq 'Commercial Lease' OR PropertyType eq 'Rental') AND PropertyType eq 'Residential Lease' AND geo.distance(Coordinates, POINT(-80.5723904 43.4557678)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25249
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25243
+post_id: "1601938"
+post_author: 1
+"ListingKey": "30001418"
+"ListingId": "40846017"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-07T19:55:20Z"
+"RFModificationTimestamp": "2026-07-07T23:21:29Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1370.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T0C8"
+"UnparsedAddress": "86 ERBSVILLE Court Unit# 23, Waterloo, Ontario N2T0C8"
+"Coordinates": array:2 [
0 => -80.5706237
1 => 43.4527421
]
+"Latitude": 43.4527421
+"Longitude": -80.5706237
+"YearBuilt": 2023
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "EXECUTIVE TOWNHOME FOR LEASE! This unit offers over 1400sqft, located in this family-friendly neighbourhood, minutes to The Boardwalk shopping and entertainment centre, great schools, and easy access to HWY 7/8. The bright open main floor layout features a spacious kitchen with quartz counters and an island with seating, open to the living room with great natural light and a walkout. Sliders lead you to the rear deck – ideal for entertaining. The second floor offers 3 bedrooms and 2 full bathrooms in total – including the primary suite with a large walk-in closet and 3pc ensuite w/a sliding glass shower door. Convenient full-sized upper laundry. The unfinished basement offers plenty of room for storage. Single garage and driveway – allowing parking for 2. Notable features: air exchanger, a/c, Wi-Fi garage door opener, sump pump, and more! Heat, hydro, gas, water and tenant insurance are to be paid for by the tenant(s). Good credit is required, and a full application must be submitted. Available September 1st.*photos are a likeness before the tenant moved in, photos are also virtually staged* (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Garage door opener"
6 => "Microwave Built-in"
]
+"AssociationFeeIncludes": array:1 [
0 => "Other, See Remarks"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-07T23:21:27.650707+00:00"
+"Directions": "ERBSVILLE RD"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1750694"
+"ListOfficeKey": "285293"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-07T19:48:15Z"
+"PhotosCount": 10
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-07T19:48:15Z"
+"Stories": "2.0"
+"StreetName": "ERBSVILLE"
+"StreetNumber": "86"
+"StreetSuffix": "Court"
+"SubdivisionName": "440 - Upper Beechwood/Beechwood W."
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [
"RoomKey" => "1677577531"
"RoomType" => "Laundry room"
"ListingId" => "40846017"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30001418"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T19:48:15.89Z"
]
1 => array:11 [
"RoomKey" => "1677577532"
"RoomType" => "Bedroom"
"ListingId" => "40846017"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30001418"
"RoomLength" => null
"RoomDimensions" => "8'1'' x 11'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T19:48:15.89Z"
]
2 => array:11 [
"RoomKey" => "1677577533"
"RoomType" => "Bedroom"
"ListingId" => "40846017"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30001418"
"RoomLength" => null
"RoomDimensions" => "9'0'' x 14'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T19:48:15.89Z"
]
3 => array:11 [
"RoomKey" => "1677577534"
"RoomType" => "4pc Bathroom"
"ListingId" => "40846017"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30001418"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T19:48:15.9Z"
]
4 => array:11 [
"RoomKey" => "1677577535"
"RoomType" => "Full bathroom"
"ListingId" => "40846017"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30001418"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T19:48:15.9Z"
]
5 => array:11 [
"RoomKey" => "1677577536"
"RoomType" => "Primary Bedroom"
"ListingId" => "40846017"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30001418"
"RoomLength" => null
"RoomDimensions" => "12'3'' x 12'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T19:48:15.9Z"
]
6 => array:11 [
"RoomKey" => "1677577537"
"RoomType" => "Living room"
"ListingId" => "40846017"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30001418"
"RoomLength" => null
"RoomDimensions" => "17'8'' x 10'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T19:48:15.9Z"
]
7 => array:11 [
"RoomKey" => "1677577538"
"RoomType" => "Kitchen"
"ListingId" => "40846017"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30001418"
"RoomLength" => null
"RoomDimensions" => "10'2'' x 9'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T19:48:15.9Z"
]
8 => array:11 [
"RoomKey" => "1677577539"
"RoomType" => "Dining room"
"ListingId" => "40846017"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30001418"
"RoomLength" => null
"RoomDimensions" => "7'6'' x 7'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T19:48:15.9Z"
]
9 => array:11 [
"RoomKey" => "1677577540"
"RoomType" => "2pc Bathroom"
"ListingId" => "40846017"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30001418"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T19:48:15.9Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30001418/86-erbsville-court-unit-23-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2885
+"ZoningDescription": "R8"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 1370
+"OriginalEntryTimestamp": "2026-07-07T19:48:15.85Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1066261"
+"ListOfficeNationalAssociationId": "1349925"
+"Media": array:10 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30001418_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001418/6638070d3e1cfa5833c06158a8436e8c.webp"
"MediaSize" => 82231
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001418/thumbnail-6638070d3e1cfa5833c06158a8436e8c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40846017"
"ResourceRecordKey" => "30001418"
"ModificationTimestamp" => "2026-07-07T19:48:15.86Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30001418_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001418/3073d22b60c17ea449e72a5065308b4b.webp"
"MediaSize" => 124529
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001418/thumbnail-3073d22b60c17ea449e72a5065308b4b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846017"
"ResourceRecordKey" => "30001418"
"ModificationTimestamp" => "2026-07-07T19:48:15.86Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30001418_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001418/d26f6f8a1b96abceb046b90bfacedee5.webp"
"MediaSize" => 73268
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001418/thumbnail-d26f6f8a1b96abceb046b90bfacedee5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846017"
"ResourceRecordKey" => "30001418"
"ModificationTimestamp" => "2026-07-07T19:48:15.86Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30001418_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001418/f4caca46b214722cd7518769f0efc5c8.webp"
"MediaSize" => 57375
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001418/thumbnail-f4caca46b214722cd7518769f0efc5c8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846017"
"ResourceRecordKey" => "30001418"
"ModificationTimestamp" => "2026-07-07T19:48:15.86Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30001418_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001418/bac0b8aba8c5364398030d2f53f7475b.webp"
"MediaSize" => 69912
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001418/thumbnail-bac0b8aba8c5364398030d2f53f7475b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846017"
"ResourceRecordKey" => "30001418"
"ModificationTimestamp" => "2026-07-07T19:48:15.86Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30001418_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001418/026eb9466722b0cb729b66f04517608c.webp"
"MediaSize" => 46342
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001418/thumbnail-026eb9466722b0cb729b66f04517608c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846017"
"ResourceRecordKey" => "30001418"
"ModificationTimestamp" => "2026-07-07T19:48:15.86Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30001418_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001418/a1ee5d8d7aac3cc1a41b7ffaf62462b5.webp"
"MediaSize" => 69001
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001418/thumbnail-a1ee5d8d7aac3cc1a41b7ffaf62462b5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846017"
"ResourceRecordKey" => "30001418"
"ModificationTimestamp" => "2026-07-07T19:48:15.86Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30001418_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001418/b5ceda7f4be878339a8a64b7631ab904.webp"
"MediaSize" => 56150
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001418/thumbnail-b5ceda7f4be878339a8a64b7631ab904.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846017"
"ResourceRecordKey" => "30001418"
"ModificationTimestamp" => "2026-07-07T19:48:15.86Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30001418_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001418/efd86f2fb99c67799ce5f8eaaa24c5c0.webp"
"MediaSize" => 72122
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001418/thumbnail-efd86f2fb99c67799ce5f8eaaa24c5c0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846017"
"ResourceRecordKey" => "30001418"
"ModificationTimestamp" => "2026-07-07T19:48:15.86Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30001418_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001418/187566a3c27cb0eea54c71e781adaf12.webp"
"MediaSize" => 62808
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001418/thumbnail-187566a3c27cb0eea54c71e781adaf12.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846017"
"ResourceRecordKey" => "30001418"
"ModificationTimestamp" => "2026-07-07T19:48:15.86Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30001418')"
+"ID": "1601938"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25245
+post_id: "1600662"
+post_author: 1
+"ListingKey": "30000036"
+"ListingId": "X13532956"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-07T17:45:54Z"
+"RFModificationTimestamp": "2026-07-07T19:09:34Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0G9"
+"UnparsedAddress": "14 - 142 FOAMFLOWER PLACE, Waterloo, Ontario N2V0G9"
+"Coordinates": array:2 [
0 => -80.589669
1 => 43.44955
]
+"Latitude": 43.44955
+"Longitude": -80.589669
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 142 Foamflower Place Unit #14, a rare opportunity to lease a stunning brand new condo townhome in the highly desirable Vista Hills community of Waterloo. This beautifully designed "Viola" model offers approximately 1,300 sq. ft. of modern finished living space, perfectly blending style, comfort, and functionality. From the moment you step inside, you'll appreciate the bright open-concept layout, elegant laminate flooring, upgraded finishes, and thoughtfully selected details throughout. The contemporary kitchen features rich chocolate brown cabinetry, sleek quartz countertops, a spacious center island, and brand-new stainless steel appliances, making it ideal for both everyday living and entertaining. The inviting Great Room opens onto a private balcony, creating the perfect space to relax and unwind. The upper level offers two spacious bedrooms, including a luxurious primary retreat complete with a walk-in closet, private balcony access, and a spa-inspired 4-piece ensuite featuring an upgraded glass-enclosed shower. The second bedroom is generously sized and conveniently served by another full 4-piece bathroom, making this home ideal for families, professionals, or roommates. Additional conveniences include upper-level laundry with a stackable washer and dryer, linen storage, zebra blinds already installed, and one dedicated parking space. Located just minutes from top-rated schools, beautiful parks, Costco, shopping centers, restaurants, and both the University of Waterloo and Wilfrid Laurier University, this exceptional property offers unmatched convenience in one of Waterloo's fastest-growing communities. Owners prefer families or working professionals with strong credit and stable income. Utilities are extra. Don't miss your chance to enjoy upscale, stress-free living in this AAA+ location, schedule your private showing today! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-07T19:09:24.951939+00:00"
+"Directions": "Cross Streets: Columbia St. ** Directions: ERBSVILLE RD/ COLOMBIA ST W/LADYSLIPPER DR."
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2130557"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-07T17:11:08Z"
+"PhotosCount": 15
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-07T17:11:07Z"
+"StreetName": "FOAMFLOWER"
+"StreetNumber": "142"
+"StreetSuffix": "Place"
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1677461110"
"RoomType" => "Great room"
"ListingId" => "X13532956"
"RoomLevel" => "Main level"
"RoomWidth" => 3.81
"ListingKey" => "30000036"
"RoomLength" => 3.86
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T17:11:07.82Z"
]
1 => array:11 [
"RoomKey" => "1677461111"
"RoomType" => "Kitchen"
"ListingId" => "X13532956"
"RoomLevel" => "Main level"
"RoomWidth" => 3.07
"ListingKey" => "30000036"
"RoomLength" => 3.81
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T17:11:07.83Z"
]
2 => array:11 [
"RoomKey" => "1677461112"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13532956"
"RoomLevel" => "Main level"
"RoomWidth" => 3.07
"ListingKey" => "30000036"
"RoomLength" => 3.43
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T17:11:07.84Z"
]
3 => array:11 [
"RoomKey" => "1677461113"
"RoomType" => "Bedroom"
"ListingId" => "X13532956"
"RoomLevel" => "Main level"
"RoomWidth" => 2.9
"ListingKey" => "30000036"
"RoomLength" => 3.07
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T17:11:07.84Z"
]
4 => array:11 [
"RoomKey" => "1677461114"
"RoomType" => "Bedroom"
"ListingId" => "X13532956"
"RoomLevel" => "Main level"
"RoomWidth" => 2.87
"ListingKey" => "30000036"
"RoomLength" => 3.25
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T17:11:07.85Z"
]
5 => array:11 [
"RoomKey" => "1677461115"
"RoomType" => "Other"
"ListingId" => "X13532956"
"RoomLevel" => "Main level"
"RoomWidth" => 6.38
"ListingKey" => "30000036"
"RoomLength" => 3.25
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T17:11:07.86Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30000036/14-142-foamflower-place-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "1280"
+"GeocodeManualYN": false
+"TotalActualRent": 2450
+"BuildingFeatures": array:1 [
0 => "Visitor Parking"
]
+"LivingAreaMaximum": 1399
+"LivingAreaMinimum": 1200
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-07-07T17:11:07.71Z"
+"ListAgentNationalAssociationId": "1389915"
+"ListOfficeNationalAssociationId": "1369645"
+"Media": array:15 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30000036_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30000036/dac83d09181a4cd03b8cf80f528cc0ac.webp"
"MediaSize" => 74871
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30000036/thumbnail-dac83d09181a4cd03b8cf80f528cc0ac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13532956"
"ResourceRecordKey" => "30000036"
"ModificationTimestamp" => "2026-07-07T17:11:07.74Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30000036_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30000036/15ea90bd9b8d804eb2675c5bb4cdbe5e.webp"
"MediaSize" => 362138
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30000036/thumbnail-15ea90bd9b8d804eb2675c5bb4cdbe5e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532956"
"ResourceRecordKey" => "30000036"
"ModificationTimestamp" => "2026-07-07T17:11:07.74Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30000036_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30000036/10d2d93a58d70741693c42c101ca4c34.webp"
"MediaSize" => 147010
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30000036/thumbnail-10d2d93a58d70741693c42c101ca4c34.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532956"
"ResourceRecordKey" => "30000036"
"ModificationTimestamp" => "2026-07-07T17:11:07.74Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30000036_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30000036/ed010b7a959e7fe582bd296741a776f5.webp"
"MediaSize" => 158135
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30000036/thumbnail-ed010b7a959e7fe582bd296741a776f5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532956"
"ResourceRecordKey" => "30000036"
"ModificationTimestamp" => "2026-07-07T17:11:07.74Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30000036_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30000036/d44c3806ad58fe4d140844a1f8b4f948.webp"
"MediaSize" => 118876
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30000036/thumbnail-d44c3806ad58fe4d140844a1f8b4f948.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532956"
"ResourceRecordKey" => "30000036"
"ModificationTimestamp" => "2026-07-07T17:11:07.74Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30000036_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30000036/28efd5c88aad218b715c274a6b9a181b.webp"
"MediaSize" => 292147
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30000036/thumbnail-28efd5c88aad218b715c274a6b9a181b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532956"
"ResourceRecordKey" => "30000036"
"ModificationTimestamp" => "2026-07-07T17:11:07.74Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30000036_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30000036/116a5f8cb81f5260c625aad138b948b5.webp"
"MediaSize" => 139086
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30000036/thumbnail-116a5f8cb81f5260c625aad138b948b5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532956"
"ResourceRecordKey" => "30000036"
"ModificationTimestamp" => "2026-07-07T17:11:07.74Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30000036_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30000036/51e52c92bd6561ce8648fa74b334bb65.webp"
"MediaSize" => 64991
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30000036/thumbnail-51e52c92bd6561ce8648fa74b334bb65.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532956"
"ResourceRecordKey" => "30000036"
"ModificationTimestamp" => "2026-07-07T17:11:07.74Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30000036_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30000036/99b0604529894c085d4740f3674d1520.webp"
"MediaSize" => 102269
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30000036/thumbnail-99b0604529894c085d4740f3674d1520.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532956"
"ResourceRecordKey" => "30000036"
"ModificationTimestamp" => "2026-07-07T17:11:07.74Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30000036_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30000036/80133a4eaedf83c674af0e5afaccbb70.webp"
"MediaSize" => 158536
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30000036/thumbnail-80133a4eaedf83c674af0e5afaccbb70.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532956"
"ResourceRecordKey" => "30000036"
"ModificationTimestamp" => "2026-07-07T17:11:07.74Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30000036_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30000036/cc92df8d8de5219a3762aeaee7099c89.webp"
"MediaSize" => 139765
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30000036/thumbnail-cc92df8d8de5219a3762aeaee7099c89.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532956"
"ResourceRecordKey" => "30000036"
"ModificationTimestamp" => "2026-07-07T17:11:07.74Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30000036_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30000036/1f9b68d979cedc50ba456d754859492d.webp"
"MediaSize" => 145304
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30000036/thumbnail-1f9b68d979cedc50ba456d754859492d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532956"
"ResourceRecordKey" => "30000036"
"ModificationTimestamp" => "2026-07-07T17:11:07.74Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30000036_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30000036/c4fdd1678b4a0eb7a5daa4aa5ea7861a.webp"
"MediaSize" => 85077
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30000036/thumbnail-c4fdd1678b4a0eb7a5daa4aa5ea7861a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532956"
"ResourceRecordKey" => "30000036"
"ModificationTimestamp" => "2026-07-07T17:11:07.74Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30000036_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30000036/0f04bafbcd5fd2b37724b0deb7af7201.webp"
"MediaSize" => 225935
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30000036/thumbnail-0f04bafbcd5fd2b37724b0deb7af7201.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532956"
"ResourceRecordKey" => "30000036"
"ModificationTimestamp" => "2026-07-07T17:11:07.74Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30000036_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30000036/a5fc628c60ed1a997f0641d1a8f65d80.webp"
"MediaSize" => 210660
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30000036/thumbnail-a5fc628c60ed1a997f0641d1a8f65d80.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532956"
"ResourceRecordKey" => "30000036"
"ModificationTimestamp" => "2026-07-07T17:11:07.74Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30000036')"
+"ID": "1600662"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25242
+post_id: "1600664"
+post_author: 1
+"ListingKey": "29998714"
+"ListingId": "40845689"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-07T14:55:15Z"
+"RFModificationTimestamp": "2026-07-07T17:24:30Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1280.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0J1"
+"UnparsedAddress": "142 FOAMFLOWER Place Unit# 14, Waterloo, Ontario N2V0J1"
+"Coordinates": array:2 [
0 => -80.5894295
1 => 43.4498381
]
+"Latitude": 43.4498381
+"Longitude": -80.5894295
+"YearBuilt": 2024
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 142 Foamflower Place Unit #14, a rare opportunity to lease a stunning brand new condo townhome in the highly desirable Vista Hills community of Waterloo. This beautifully designed “Viola” model offers approximately 1,300 sq. ft. of modern finished living space, perfectly blending style, comfort, and functionality. From the moment you step inside, you’ll appreciate the bright open-concept layout, elegant laminate flooring, upgraded finishes, and thoughtfully selected details throughout. The contemporary kitchen features rich chocolate brown cabinetry, sleek quartz countertops, a spacious center island, and brand-new stainless steel appliances, making it ideal for both everyday living and entertaining. The inviting Great Room opens onto a private balcony, creating the perfect space to relax and unwind. The upper level offers two spacious bedrooms, including a luxurious primary retreat complete with a walk-in closet, private balcony access, and a spa-inspired 4-piece ensuite featuring an upgraded glass-enclosed shower. The second bedroom is generously sized and conveniently served by another full 4-piece bathroom, making this home ideal for families, professionals, or roommates. Additional conveniences include upper-level laundry with a stackable washer and dryer, linen storage, zebra blinds already installed, and one dedicated parking space. Located just minutes from top-rated schools, beautiful parks, Costco, shopping centers, restaurants, and both the University of Waterloo and Wilfrid Laurier University, this exceptional property offers unmatched convenience in one of Waterloo’s fastest-growing communities. Owners prefer families or working professionals with strong credit and stable income. Utilities are extra. Don’t miss your chance to enjoy upscale, stress-free living in this AAA+ location, schedule your private showing today! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-07T17:24:19.567729+00:00"
+"Directions": "ERBSVILLE RD/ COLOMBIA ST W/LADYSLIPPER DR"
+"ExteriorFeatures": array:3 [
0 => "Stucco"
1 => "Vinyl siding"
2 => "Brick Veneer"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564507"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-07-07T14:48:13Z"
+"PhotosCount": 15
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-07T14:48:13Z"
+"Stories": "2.0"
+"StreetName": "FOAMFLOWER"
+"StreetNumber": "142"
+"StreetSuffix": "Place"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [
"RoomKey" => "1677347029"
"RoomType" => "4pc Bathroom"
"ListingId" => "40845689"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29998714"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T14:48:13.31Z"
]
1 => array:11 [
"RoomKey" => "1677347030"
"RoomType" => "Bedroom"
"ListingId" => "40845689"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29998714"
"RoomLength" => null
"RoomDimensions" => "9'1'' x 10'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T14:48:13.32Z"
]
2 => array:11 [
"RoomKey" => "1677347031"
"RoomType" => "4pc Bathroom"
"ListingId" => "40845689"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29998714"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T14:48:13.32Z"
]
3 => array:11 [
"RoomKey" => "1677347032"
"RoomType" => "Primary Bedroom"
"ListingId" => "40845689"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29998714"
"RoomLength" => null
"RoomDimensions" => "11'2'' x 12'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T14:48:13.32Z"
]
4 => array:11 [
"RoomKey" => "1677347033"
"RoomType" => "2pc Bathroom"
"ListingId" => "40845689"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29998714"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T14:48:13.32Z"
]
5 => array:11 [
"RoomKey" => "1677347034"
"RoomType" => "Great room"
"ListingId" => "40845689"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29998714"
"RoomLength" => null
"RoomDimensions" => "13'1'' x 18'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T14:48:13.32Z"
]
6 => array:11 [
"RoomKey" => "1677347035"
"RoomType" => "Kitchen"
"ListingId" => "40845689"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29998714"
"RoomLength" => null
"RoomDimensions" => "8'5'' x 13'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T14:48:13.32Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29998714/142-foamflower-place-unit-14-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2450
+"ZoningDescription": "R6-FT"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 1280
+"OriginalEntryTimestamp": "2026-07-07T14:48:13.29Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1123254"
+"ListOfficeNationalAssociationId": "1380559"
+"Media": array:15 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29998714_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998714/b332e0df24f35c6f0312fe86101c2590.webp"
"MediaSize" => 69914
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998714/thumbnail-b332e0df24f35c6f0312fe86101c2590.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40845689"
"ResourceRecordKey" => "29998714"
"ModificationTimestamp" => "2026-07-07T14:48:13.29Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29998714_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998714/d64ea023116ab77ed972c6101c2a382d.webp"
"MediaSize" => 181471
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998714/thumbnail-d64ea023116ab77ed972c6101c2a382d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845689"
"ResourceRecordKey" => "29998714"
"ModificationTimestamp" => "2026-07-07T14:48:13.29Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29998714_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998714/060c57808a41b88eb06f45c36bd76722.webp"
"MediaSize" => 69477
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998714/thumbnail-060c57808a41b88eb06f45c36bd76722.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845689"
"ResourceRecordKey" => "29998714"
"ModificationTimestamp" => "2026-07-07T14:48:13.29Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29998714_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998714/2379477bf99fbae6e63e96fb25f748b6.webp"
"MediaSize" => 73646
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998714/thumbnail-2379477bf99fbae6e63e96fb25f748b6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845689"
"ResourceRecordKey" => "29998714"
"ModificationTimestamp" => "2026-07-07T14:48:13.29Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29998714_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998714/d5fee79164e41925bdfdb299398044ed.webp"
"MediaSize" => 57117
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998714/thumbnail-d5fee79164e41925bdfdb299398044ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845689"
"ResourceRecordKey" => "29998714"
"ModificationTimestamp" => "2026-07-07T14:48:13.29Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29998714_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998714/c7761590de27eb30a8f9ecb16a240405.webp"
"MediaSize" => 65530
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998714/thumbnail-c7761590de27eb30a8f9ecb16a240405.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845689"
"ResourceRecordKey" => "29998714"
"ModificationTimestamp" => "2026-07-07T14:48:13.29Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29998714_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998714/0573aa5c1577bbeffba8adc9795eb919.webp"
"MediaSize" => 26102
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998714/thumbnail-0573aa5c1577bbeffba8adc9795eb919.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845689"
"ResourceRecordKey" => "29998714"
"ModificationTimestamp" => "2026-07-07T14:48:13.29Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29998714_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998714/6e42c57a80e5696a99837080ea98beb7.webp"
"MediaSize" => 43505
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998714/thumbnail-6e42c57a80e5696a99837080ea98beb7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845689"
"ResourceRecordKey" => "29998714"
"ModificationTimestamp" => "2026-07-07T14:48:13.29Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29998714_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998714/1448f91796788679b153999d04c923f7.webp"
"MediaSize" => 69117
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998714/thumbnail-1448f91796788679b153999d04c923f7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845689"
"ResourceRecordKey" => "29998714"
"ModificationTimestamp" => "2026-07-07T14:48:13.29Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29998714_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998714/9e6a73f1e8b67bebceb5bde2285c60a7.webp"
"MediaSize" => 69352
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998714/thumbnail-9e6a73f1e8b67bebceb5bde2285c60a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845689"
"ResourceRecordKey" => "29998714"
"ModificationTimestamp" => "2026-07-07T14:48:13.29Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29998714_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998714/b15abb92be7044a80fad3f133b346ee3.webp"
"MediaSize" => 73307
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998714/thumbnail-b15abb92be7044a80fad3f133b346ee3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845689"
"ResourceRecordKey" => "29998714"
"ModificationTimestamp" => "2026-07-07T14:48:13.29Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29998714_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998714/631b44e98e276568fb0394dae47862ce.webp"
"MediaSize" => 71949
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998714/thumbnail-631b44e98e276568fb0394dae47862ce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845689"
"ResourceRecordKey" => "29998714"
"ModificationTimestamp" => "2026-07-07T14:48:13.29Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29998714_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998714/57700b1c828ab3d15363ef257e4f2b23.webp"
"MediaSize" => 74412
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998714/thumbnail-57700b1c828ab3d15363ef257e4f2b23.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845689"
"ResourceRecordKey" => "29998714"
"ModificationTimestamp" => "2026-07-07T14:48:13.29Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29998714_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998714/db8d65d8e8e75225956e3a28c2719cee.webp"
"MediaSize" => 152255
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998714/thumbnail-db8d65d8e8e75225956e3a28c2719cee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845689"
"ResourceRecordKey" => "29998714"
"ModificationTimestamp" => "2026-07-07T14:48:13.29Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29998714_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998714/2df033f1f7f7bcf5157b115dc6e1da11.webp"
"MediaSize" => 120353
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998714/thumbnail-2df033f1f7f7bcf5157b115dc6e1da11.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845689"
"ResourceRecordKey" => "29998714"
"ModificationTimestamp" => "2026-07-07T14:48:13.29Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29998714')"
+"ID": "1600664"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25246
+post_id: "1599647"
+post_author: 1
+"ListingKey": "29999792"
+"ListingId": "X13532634"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-07T18:20:07Z"
+"RFModificationTimestamp": "2026-07-07T18:36:08Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0H3"
+"UnparsedAddress": "285 RASPBERRY PLACE, Waterloo, Ontario N2V0H3"
+"Coordinates": array:2 [
0 => -80.58631
1 => 43.45061
]
+"Latitude": 43.45061
+"Longitude": -80.58631
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Brand New Never Lived Activa Home with finished Walkout Bsmt, over 3000 sqftof livable space, 2 CarGarages, 3 bed, 3.5 bath with Premium upgrades,Carpet free main floor, upgradedkitchen/Appliances/ceramic flooring in wet areas/quartz countertops throughout home. 9ft ceilingson main floor, Master bedroom ensuite with glass shower door/freestanding tub, larger Bsmt windows,Brick to main floor, siding to Bed,CAC,HRV,High Eff Furnace,Triple pane window. 2024 pictures attached (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Hood Fan"
]
+"Basement": array:3 [
0 => "Finished"
1 => "Walk out"
2 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-07T17:08:43.433792+00:00"
+"Directions": "Columbia St W/Ladyslipper Dr"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"Flooring": array:2 [
0 => "Tile"
1 => "Hardwood"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1948194"
+"ListOfficeKey": "65275"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "30 x 65 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-07T16:40:49Z"
+"PhotosCount": 32
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-07T18:11:19Z"
+"Stories": "2.0"
+"StreetName": "Raspberry"
+"StreetNumber": "285"
+"StreetSuffix": "Place"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [
"RoomKey" => "1677503244"
"RoomType" => "Great room"
"ListingId" => "X13532634"
"RoomLevel" => "Ground level"
"RoomWidth" => 3.77
"ListingKey" => "29999792"
"RoomLength" => 3.96
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T18:11:19.76Z"
]
1 => array:11 [
"RoomKey" => "1677503245"
"RoomType" => "Dining room"
"ListingId" => "X13532634"
"RoomLevel" => "Ground level"
"RoomWidth" => 3.04
"ListingKey" => "29999792"
"RoomLength" => 3.65
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T18:11:19.76Z"
]
2 => array:11 [
"RoomKey" => "1677503246"
"RoomType" => "Kitchen"
"ListingId" => "X13532634"
"RoomLevel" => "Ground level"
"RoomWidth" => 3.04
"ListingKey" => "29999792"
"RoomLength" => 3.65
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T18:11:19.76Z"
]
3 => array:11 [
"RoomKey" => "1677503247"
"RoomType" => "Eating area"
"ListingId" => "X13532634"
"RoomLevel" => "Ground level"
"RoomWidth" => 3.04
"ListingKey" => "29999792"
"RoomLength" => 3.65
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T18:11:19.76Z"
]
4 => array:11 [
"RoomKey" => "1677503248"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13532634"
"RoomLevel" => "Second level"
"RoomWidth" => 4.57
"ListingKey" => "29999792"
"RoomLength" => 3.9
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T18:11:19.76Z"
]
5 => array:11 [
"RoomKey" => "1677503249"
"RoomType" => "Bedroom 2"
"ListingId" => "X13532634"
…8
]
6 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29999792/285-raspberry-place-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2088046"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "65275"
+"GeocodeManualYN": false
+"TotalActualRent": 3499
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 3
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 30.0
+"OriginalEntryTimestamp": "2026-07-07T16:40:48.87Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1242784"
+"ListOfficeNationalAssociationId": "1260430"
+"CoListAgentNationalAssociationId": "1361355"
+"CoListOfficeNationalAssociationId": "1260430"
+"Media": array:32 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29999792')"
+"ID": "1599647"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25244
+post_id: "1597698"
+post_author: 1
+"ListingKey": "29996080"
+"ListingId": "40843001"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-06T21:55:25Z"
+"RFModificationTimestamp": "2026-07-06T22:46:57Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2060.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2L1"
+"UnparsedAddress": "365 BENNINGTON Gate Unit# 13, Waterloo, Ontario N2T2L1"
+"Coordinates": array:2 [
0 => -80.5756102
1 => 43.4640096
]
+"Latitude": 43.4640096
+"Longitude": -80.5756102
+"YearBuilt": 1991
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Discover exceptional living in prestigious Waterloo Upper Beechwood community with this spacious 2+1 bedroom, 3.5 bathroom townhome condo. $2450 plus hydro & gas. With a flexible move in date, available now or extending as late as September 1, 2026.\u{A0} Offering 1,500 sq ft of well-appointed living space, plus an additional 512 sq ft in the finished basement, this home combines style, functionality, and quiet living. The bright and open-concept main level features an eat-in kitchen, dining area, and a comfortable living space; perfect for family gatherings and entertaining. The upper level includes a generous primary bedroom with an en-suite bathroom and ample closet space, bonus living area for a home office or family room, along with a second bedroom and full bath. The finished basement offers endless possibilities, featuring a versatile layout ideal for an additional bedroom, a home gym, or a recreational room - complete with a 3-piece bathroom for added convenience. With an attached garage, a cozy backyard for outdoor relaxation, and access to a complex pool, this home provides everything you need for a balanced lifestyle. Situated in the desirable Upper Beechwood community, you'll enjoy the charm of this well-established neighborhood, with nearby parks, schools, shopping, and easy access to Waterloo's amenities. This townhome is perfect for families, professionals, and down-sizers seeking comfort, convenience, and community living. Don't miss your chance to make this sought-after address your new home! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
]
+"AssociationFeeIncludes": array:3 [
0 => "Landscaping"
1 => "Property Management"
2 => "Water"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-06T22:46:56.193345+00:00"
+"Directions": "Columbia St. W. to Bennington Gate"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2180308"
+"ListOfficeKey": "283397"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Cul-de-sac"
1 => "Southern exposure"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-06T21:18:40Z"
+"PhotosCount": 20
+"PoolFeatures": array:1 [
0 => "Pool"
]
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-06T21:48:39Z"
+"Stories": "2.0"
+"StreetName": "BENNINGTON"
+"StreetNumber": "365"
+"StreetSuffix": "Gate"
+"SubdivisionName": "440 - Upper Beechwood/Beechwood W."
+"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/29996080/365-bennington-gate-unit-13-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2450
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R8"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 0.0
+"AboveGradeFinishedArea": 1548
+"BelowGradeFinishedArea": 512
+"OriginalEntryTimestamp": "2026-07-06T21:18:40.43Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1430151"
+"ListOfficeNationalAssociationId": "1328541"
+"Media": array:20 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29996080')"
+"ID": "1597698"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25239
+post_id: "1593036"
+post_author: 1
+"ListingKey": "29989448"
+"ListingId": "X13522666"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-04T15:45:02Z"
+"RFModificationTimestamp": "2026-07-04T16:35:51Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2K8"
+"UnparsedAddress": "B - 630 PINEROW CRESCENT, Waterloo, Ontario N2T2K8"
+"Coordinates": array:2 [
0 => -80.569679
1 => 43.448631
]
+"Latitude": 43.448631
+"Longitude": -80.569679
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Spacious 3-Bedroom Semi-Detached in Beechwood, Waterloo! Located in one of Waterloo's best school districts, this home is perfect for families seeking top-rated schools.3 generous bedrooms, Bright living and dining areas, Functional kitchen. Finished Basement with a Private separate entrance. Ideal for Extended Family or Home Office: 2 additional rooms that are perfect for a playroom, guest suite, or remote work. Large sized Backyard, fully fenced, private, and ready for kids, pets, or summer entertaining. Walk to parks and trails. Minutes to universities (UW & WLU), transit, and shopping. Don't miss this rare rental - space, privacy, and top schools all in one! (id:62650)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
]
+"Basement": array:5 [
0 => "Finished"
1 => "None"
2 => "Separate entrance"
3 => "N/A"
4 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-04T16:35:49.103907+00:00"
+"Directions": "Erbsville /Erb St W"
+"ExteriorFeatures": array:1 [
0 => "Brick Facing"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1411041"
+"ListOfficeKey": "288626"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "32.5 x 116.8 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-04T15:39:25Z"
+"PhotosCount": 29
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-04T15:39:25Z"
+"Stories": "2.0"
+"StreetName": "Pinerow"
+"StreetNumber": "630"
+"StreetSuffix": "Crescent"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29989448/b-630-pinerow-crescent-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 2800
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 32.6
+"OriginalEntryTimestamp": "2026-07-04T15:39:25.26Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1113142"
+"ListOfficeNationalAssociationId": "1370159"
+"Media": array:29 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29989448')"
+"ID": "1593036"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23464
+post_id: "1592160"
+post_author: 1
+"ListingKey": "29988324"
+"ListingId": "40845172"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-06T20:20:07Z"
+"RFModificationTimestamp": "2026-07-06T20:33:23Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 773.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0E9"
+"UnparsedAddress": "244 LADYSLIPPER Drive Unit# LOWER, Waterloo, Ontario N2V0E9"
+"Coordinates": array:2 [
0 => -80.5918946
1 => 43.455862
]
+"Latitude": 43.455862
+"Longitude": -80.5918946
+"YearBuilt": 2020
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Step into modern living with this professionally finished (2025) 2-bedroom, 1-bathroom home. The stylish kitchen features beautiful cabinetry, elegant quartz countertops, abundant storage, stainless steel appliances, and a sleek over-the-range microwave. The spacious layout is filled with natural light thanks to large windows throughout, while window coverings (curtains) are included for added comfort and privacy. Durable subflooring has been installed throughout the unit, adding to its quality and longevity. Enjoy the convenience of a private garage with remote control access, plus even more storage space to keep everything organized. Located in a fantastic area of Waterloo, this home offers incredible convenience. You're just 5 minutes from Costco and other essential amenities. Enjoy added privacy with no backyard neighbours, and families will appreciate being just steps from great schools. Bright, stylish, and move-in ready, this is the perfect place to call home. Bonus: A 2% discount is available for tenants (terms and conditions apply). (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Hood Fan"
8 => "Window Coverings"
9 => "Garage door opener"
10 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-04T00:51:14.027472+00:00"
+"Directions": "Columbia St W / Ladyslipper Dr"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2190750"
+"ListOfficeKey": "76807"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-06T20:12:26Z"
+"PhotosCount": 17
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-06T20:12:26Z"
+"Stories": "2.0"
+"StreetName": "LADYSLIPPER"
+"StreetNumber": "244"
+"StreetSuffix": "Drive"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"Utilities": array:2 [
0 => "Natural Gas"
1 => "Electricity"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29988324/244-ladyslipper-drive-unit-lower-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 2050
+"SecurityFeatures": array:3 [
0 => "Security system"
1 => "Smoke Detectors"
2 => "Monitored Alarm"
]
+"ZoningDescription": "NR"
+"BedroomsAboveGrade": 0
+"BedroomsBelowGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 54.0
+"AboveGradeFinishedArea": 773
+"OriginalEntryTimestamp": "2026-07-03T23:48:10.91Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1439796"
+"ListOfficeNationalAssociationId": "1004370"
+"Media": array:17 [
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]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29988324')"
+"ID": "1592160"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25247
+post_id: "1590861"
+post_author: 1
+"ListingKey": "29987586"
+"ListingId": "40844583"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T21:35:14Z"
+"RFModificationTimestamp": "2026-07-03T22:56:26Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2958.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2P5"
+"UnparsedAddress": "461 COLUMBIA Street W Unit# 49, Waterloo, Ontario N2T2P5"
+"Coordinates": array:2 [
0 => -80.5662502
1 => 43.4667817
]
+"Latitude": 43.4667817
+"Longitude": -80.5662502
+"YearBuilt": 2003
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Rare found elegant bungalow/two-storey condo as your next dream home. much bigger inside than from appearance. prime location in Waterloo's Beechwood neighborhood. Clean and well maintained. Perfect for single families, multi-generational living, or downsizers, minutes to universities, shopping centers, public library, trails, the Laurel Creek Reservoir, COSTCO, hospitals, and YMCA. living room has vaulted ceilings, large windows, and abundant natural sunlight. two spacious bedrooms on main floor, large master bedroom has suite and walk in closet. Second floor offers extra bedroom, a bathroom, and a versatile loft-like space, perfect for relaxing or working from home. The finished basement has recreation room, den, a cozy gas fireplace, and a 2-piece bathroom. main floor laundry for your convenience. Detached double garage, and a very private cozy back yard for your family's quite enjoyment. carpet downstairs will be replaced with new vinyl flooring. won't last long! (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Garage door opener"
]
+"AssociationFee": "363"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Property Management"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T22:56:16.645439+00:00"
+"Directions": "Fischer-Hallman Rd. N. and Columbia St.W."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564082"
+"ListOfficeKey": "222711"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Southern exposure"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0"
+"ParkingFeatures": array:3 [
0 => "Detached Garage"
1 => "Covered"
2 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-07-03T21:29:30Z"
+"PhotosCount": 29
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T21:29:30Z"
+"Stories": "1.0"
+"StreetDirSuffix": "West"
+"StreetName": "COLUMBIA"
+"StreetNumber": "461"
+"StreetSuffix": "Street"
+"SubdivisionName": "440 - Upper Beechwood/Beechwood W."
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"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/29987586/461-columbia-street-w-unit-49-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 3100
+"ZoningDescription": "R9"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 1725
+"BelowGradeFinishedArea": 1233
+"OriginalEntryTimestamp": "2026-07-03T21:29:29.98Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1130381"
+"ListOfficeNationalAssociationId": "1197443"
+"Media": array:29 [
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]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29987586')"
+"ID": "1590861"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25248
+post_id: "1590612"
+post_author: 1
+"ListingKey": "29986609"
+"ListingId": "40844971"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T19:25:11Z"
+"RFModificationTimestamp": "2026-07-03T20:06:53Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2105.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N0V0B9"
+"UnparsedAddress": "502 SUNDEW Drive, Waterloo, Ontario N0V0B9"
+"Coordinates": array:2 [
0 => -80.5958568
1 => 43.4558155
]
+"Latitude": 43.4558155
+"Longitude": -80.5958568
+"YearBuilt": 2016
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully upgraded home offering modern finishes, quality craftsmanship, and an exceptional open-concept layout. The main floor features engineered hardwood flooring, smooth ceilings, pot lights, and a stunning great room with a 12-ft waffle ceiling, gas fireplace, and walkout to a composite deck with a gas BBQ hookup—perfect for everyday living and entertaining. The gourmet kitchen is thoughtfully designed with quartz countertops, stainless steel appliances, under-cabinet lighting, a pantry, pot and pan drawers, and ample cabinetry. A spacious foyer, convenient main-floor laundry, powder room, and direct access to the insulated double garage complete the main level. The upper level features a spacious primary suite with a spa-inspired ensuite offering a freestanding soaker tub, oversized glass shower, and double vanity. Two additional generously sized bedrooms and a full main bathroom provide ample space for families. Located in the highly sought-after Vista Hills community of Waterloo, close to excellent schools, parks, walking trails, Costco, The Boardwalk Shopping Centre, restaurants, universities, and with easy access to major highways. Upper level only. Basement is not included. Tenant is responsible for 70% of all utilities. (id:62650)"
+"Appliances": array:7 [
0 => "Refrigerator"
1 => "Gas stove(s)"
2 => "Dishwasher"
3 => "Wine Fridge"
4 => "Dryer"
5 => "Window Coverings"
6 => "Microwave Built-in"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T20:06:46.776818+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2241210"
+"ListOfficeKey": "76775"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T19:18:18Z"
+"PhotosCount": 39
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T19:18:18Z"
+"Stories": "2.0"
+"StreetName": "SUNDEW"
+"StreetNumber": "502"
+"StreetSuffix": "Drive"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"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/29986609/502-sundew-drive-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2249979"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "76775"
+"GeocodeManualYN": true
+"TotalActualRent": 3800
+"ZoningDescription": "NR-SL"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 34.0
+"AboveGradeFinishedArea": 2105
+"OriginalEntryTimestamp": "2026-07-03T19:18:18.66Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1479368"
+"ListOfficeNationalAssociationId": "1004341"
+"CoListAgentNationalAssociationId": "1488857"
+"CoListOfficeNationalAssociationId": "1004341"
+"Media": array:39 [
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]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29986609')"
+"ID": "1590612"
}
]
+success: true
+page_size: 9
+page_count: 3
+count: 23
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]