array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29914132 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23360
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23362
+post_id: "1538007"
+post_author: 1
+"ListingKey": "29914132"
+"ListingId": "40838042"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T04:40:05Z"
+"RFModificationTimestamp": "2026-06-17T06:44:26Z"
+"ListPrice": 1200000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2655.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0E3"
+"UnparsedAddress": "626 WILD RYE Street, Waterloo, Ontario N2V0E3"
+"Coordinates": array:2 [
0 => -80.6008015
1 => 43.4593743
]
+"Latitude": 43.4593743
+"Longitude": -80.6008015
+"YearBuilt": 2018
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 626 Wild Rye Street, a quintessential 4-bedroom, 3.5-bathroom home located in Waterloo's highly sought-after Vista Hills community. This exceptional property seamlessly blends comfort, functionality, and modern luxury. Pride of ownership is evident the moment you arrive and take in the home's outstanding curb appeal. This is far from your typical builder-basic home. Extensive upgrades and high-quality finishes can be found throughout. The thoughtfully designed mudroom entry from the garage has been meticulously planned with custom storage, benches, and hooks to keep everyday essentials organized and easily accessible. The main floor is the definition of open-concept living, anchored by a show-stopping kitchen featuring top-of-the-line appliances, premium finishes, and a dedicated bar area complete with an additional wine fridge. The built-in Sonos sound system throughout the home is a feature you'll quickly learn not to live without, setting the perfect atmosphere whether hosting guests or enjoying a quiet evening at home. Step outside to a professionally designed backyard retreat complete with outdoor dining, comfortable seating around a gas fire pit, a gas BBQ, and a dedicated outdoor television capable of showing the game in any Canadian season. For golf enthusiasts, a private putting green provides the perfect opportunity to work on those three-foot putts between rounds. The second floor offers four generously sized bedrooms, abundant storage, and three full bathrooms. The impressive primary suite features separate his-and-her walk-in closets and a private spa-inspired ensuite. Laundry day becomes effortless with the convenience of a dedicated second-floor laundry room. Located close to top-rated schools, scenic walking trails, parks, and all the amenities Waterloo has to offer. All furnishings are negotiable, creating a rare opportunity for buyers seeking a move-in-ready lifestyle. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Wine Fridge"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T06:44:18.154147+00:00"
+"Directions": "COLUMBIA ST W TOSUNDEW DR TO MAYAPPLE ST TO WOOD LILY ST TO WILD RYE ST"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1878141"
+"ListOfficeKey": "156288"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Southern exposure"
1 => "Paved driveway"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T04:31:52Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T04:31:52Z"
+"Stories": "2.0"
+"StreetName": "WILD RYE"
+"StreetNumber": "626"
+"StreetSuffix": "Street"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "7480"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1660983200"
"RoomType" => "Foyer"
"ListingId" => "40838042"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29914132"
"RoomLength" => null
"RoomDimensions" => "20'2'' x 9'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T04:31:52.36Z"
]
1 => array:11 [
"RoomKey" => "1660983201"
"RoomType" => "Full bathroom"
"ListingId" => "40838042"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29914132"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T04:31:52.36Z"
]
2 => array:11 [
"RoomKey" => "1660983202"
"RoomType" => "4pc Bathroom"
"ListingId" => "40838042"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29914132"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T04:31:52.36Z"
]
3 => array:11 [
"RoomKey" => "1660983203"
"RoomType" => "4pc Bathroom"
"ListingId" => "40838042"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29914132"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T04:31:52.36Z"
]
4 => array:11 [
"RoomKey" => "1660983204"
"RoomType" => "Primary Bedroom"
"ListingId" => "40838042"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29914132"
"RoomLength" => null
"RoomDimensions" => "15'3'' x 19'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T04:31:52.36Z"
]
5 => array:11 [
"RoomKey" => "1660983205"
"RoomType" => "Bedroom"
"ListingId" => "40838042"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29914132"
"RoomLength" => null
"RoomDimensions" => "9'8'' x 13'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T04:31:52.36Z"
]
6 => array:11 [
"RoomKey" => "1660983206"
"RoomType" => "Bedroom"
"ListingId" => "40838042"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29914132"
"RoomLength" => null
"RoomDimensions" => "10'11'' x 12'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T04:31:52.36Z"
]
7 => array:11 [
"RoomKey" => "1660983207"
"RoomType" => "Bedroom"
"ListingId" => "40838042"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29914132"
"RoomLength" => null
"RoomDimensions" => "10'10'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T04:31:52.36Z"
]
8 => array:11 [
"RoomKey" => "1660983208"
"RoomType" => "2pc Bathroom"
"ListingId" => "40838042"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29914132"
"RoomLength" => null
"RoomDimensions" => "2'11'' x 7'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T04:31:52.36Z"
]
9 => array:11 [
"RoomKey" => "1660983209"
"RoomType" => "Kitchen"
"ListingId" => "40838042"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29914132"
"RoomLength" => null
"RoomDimensions" => "12'4'' x 15'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T04:31:52.36Z"
]
10 => array:11 [
"RoomKey" => "1660983210"
"RoomType" => "Family room"
"ListingId" => "40838042"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29914132"
"RoomLength" => null
"RoomDimensions" => "20'11'' x 14'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T04:31:52.36Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29914132/626-wild-rye-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "NR"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 40.0
+"AboveGradeFinishedArea": 2655
+"OriginalEntryTimestamp": "2026-06-17T04:31:52.3Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1204909"
+"ListOfficeNationalAssociationId": "1112493"
+"Media": array:40 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29914132_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914132/b32bea1b5b9fbbc11623e74f1dcb4e35.webp"
"MediaSize" => 133070
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914132/thumbnail-b32bea1b5b9fbbc11623e74f1dcb4e35.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Contemporary two-story residence featuring a stone and siding facade"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40838042"
"ResourceRecordKey" => "29914132"
"ModificationTimestamp" => "2026-06-17T04:31:52.31Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29914132_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914132/cf0163f954995d00fd2276f750118265.webp"
"MediaSize" => 150037
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914132/thumbnail-cf0163f954995d00fd2276f750118265.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Stone facade entry with a dark paneled door and sidelights"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838042"
"ResourceRecordKey" => "29914132"
"ModificationTimestamp" => "2026-06-17T04:31:52.31Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29914132_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914132/275d9ed7547043f11ce29c484b41bbaa.webp"
"MediaSize" => 89501
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914132/thumbnail-275d9ed7547043f11ce29c484b41bbaa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entryway featuring a white double-door entrance with sidelights and transom, light-toned tile flooring, crown molding, a dark wood staircase with wrought iron balusters, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838042"
"ResourceRecordKey" => "29914132"
"ModificationTimestamp" => "2026-06-17T04:31:52.31Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29914132_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914132/be5d183c52887f1fec87840e22629c37.webp"
"MediaSize" => 99655
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914132/thumbnail-be5d183c52887f1fec87840e22629c37.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living space featuring wood-finish flooring, recessed lighting, and crown molding"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838042"
"ResourceRecordKey" => "29914132"
"ModificationTimestamp" => "2026-06-17T04:31:52.31Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29914132_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914132/5bde310d8e6f3b0996885a39c030029b.webp"
"MediaSize" => 77722
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914132/thumbnail-5bde310d8e6f3b0996885a39c030029b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entryway featuring built-in bench seating with cushion, overhead cabinetry, a horizontal window, and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838042"
"ResourceRecordKey" => "29914132"
"ModificationTimestamp" => "2026-06-17T04:31:52.31Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29914132_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914132/6787633d77c88acd3fa454ed3895f79d.webp"
"MediaSize" => 89710
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914132/thumbnail-6787633d77c88acd3fa454ed3895f79d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living space featuring a gourmet kitchen with white cabinetry, stainless steel appliances, and a large island with a waterfall countertop"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838042"
"ResourceRecordKey" => "29914132"
"ModificationTimestamp" => "2026-06-17T04:31:52.31Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29914132_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914132/1180d8f231c300dfc267cb9b2ec2f1e2.webp"
"MediaSize" => 84863
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914132/thumbnail-1180d8f231c300dfc267cb9b2ec2f1e2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious living area featuring light wood-finish flooring, a contemporary fireplace with a textured surround, recessed lighting, and crown molding"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838042"
"ResourceRecordKey" => "29914132"
"ModificationTimestamp" => "2026-06-17T04:31:52.31Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29914132_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914132/25bdeb07e4d3c2f0988a75ea84d7c66f.webp"
"MediaSize" => 83989
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914132/thumbnail-25bdeb07e4d3c2f0988a75ea84d7c66f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious kitchen featuring a large central island with a double sink, white cabinetry, integrated stainless steel appliances, and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838042"
"ResourceRecordKey" => "29914132"
"ModificationTimestamp" => "2026-06-17T04:31:52.31Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29914132_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914132/7cbbaee10ba170c846fdb15ba9e9c661.webp"
"MediaSize" => 66739
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914132/thumbnail-7cbbaee10ba170c846fdb15ba9e9c661.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern kitchen featuring white cabinetry, a large center island with a built-in double sink, stainless steel appliances, and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838042"
"ResourceRecordKey" => "29914132"
"ModificationTimestamp" => "2026-06-17T04:31:52.31Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29914132_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914132/a5c5c4263d6d8af8aa2793c624c625c0.webp"
"MediaSize" => 88296
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914132/thumbnail-a5c5c4263d6d8af8aa2793c624c625c0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept kitchen and dining area featuring a large center island with seating, stainless steel appliances, white cabinetry, and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838042"
"ResourceRecordKey" => "29914132"
"ModificationTimestamp" => "2026-06-17T04:31:52.31Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29914132_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914132/30960bb528b967a9878ee33b8663ab3c.webp"
"MediaSize" => 82088
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914132/thumbnail-30960bb528b967a9878ee33b8663ab3c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious kitchen featuring a large central island with seating, white shaker cabinetry, stainless steel appliances, and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838042"
"ResourceRecordKey" => "29914132"
"ModificationTimestamp" => "2026-06-17T04:31:52.31Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29914132_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914132/6abf26fe16b8cbd17cbe530eefca5200.webp"
"MediaSize" => 89354
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914132/thumbnail-6abf26fe16b8cbd17cbe530eefca5200.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern kitchen featuring white shaker cabinetry, stainless steel appliances, a tile backsplash, and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838042"
"ResourceRecordKey" => "29914132"
"ModificationTimestamp" => "2026-06-17T04:31:52.31Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29914132_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914132/be244efa86a96aa70469975964923be5.webp"
"MediaSize" => 77108
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914132/thumbnail-be244efa86a96aa70469975964923be5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive living space featuring wood-finish flooring, recessed lighting, and crown molding"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838042"
"ResourceRecordKey" => "29914132"
"ModificationTimestamp" => "2026-06-17T04:31:52.31Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29914132_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914132/69514d98863075cf0c279562003a57ae.webp"
"MediaSize" => 47431
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914132/thumbnail-69514d98863075cf0c279562003a57ae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838042"
"ResourceRecordKey" => "29914132"
"ModificationTimestamp" => "2026-06-17T04:31:52.31Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29914132_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914132/65a5d6fac67654815c618cc757f2380c.webp"
"MediaSize" => 84046
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914132/thumbnail-65a5d6fac67654815c618cc757f2380c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious room featuring a decorative accent wall, light grey carpeting, recessed lighting, and two windows with white plantation shutters"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838042"
"ResourceRecordKey" => "29914132"
"ModificationTimestamp" => "2026-06-17T04:31:52.31Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29914132_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914132/c7d4dbae5489a72d87763b5c735126f2.webp"
"MediaSize" => 77708
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914132/thumbnail-c7d4dbae5489a72d87763b5c735126f2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Carpeted bedroom with light gray walls, an open entryway to a closet, and a separate doorway to a vanity area"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838042"
"ResourceRecordKey" => "29914132"
"ModificationTimestamp" => "2026-06-17T04:31:52.31Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29914132_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914132/cbbd060b696e4656d6d9c9cf596e1bd0.webp"
"MediaSize" => 62512
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914132/thumbnail-cbbd060b696e4656d6d9c9cf596e1bd0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dual vanity with white cabinetry and integrated sinks set beneath a large mirror with overhead lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838042"
"ResourceRecordKey" => "29914132"
"ModificationTimestamp" => "2026-06-17T04:31:52.31Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29914132_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914132/1059d324f9d858d03e366a3f716f114d.webp"
"MediaSize" => 71836
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914132/thumbnail-1059d324f9d858d03e366a3f716f114d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dedicated laundry area featuring a built-in sink with a pull-down faucet, white cabinetry, and a countertop"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838042"
"ResourceRecordKey" => "29914132"
"ModificationTimestamp" => "2026-06-17T04:31:52.31Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29914132_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914132/b9ae685726f92f09fc51557f90287bba.webp"
"MediaSize" => 86338
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914132/thumbnail-b9ae685726f92f09fc51557f90287bba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Light-filled interior space featuring a window with white louvered shutters, light gray wall paint, and a neutral-toned carpet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838042"
"ResourceRecordKey" => "29914132"
"ModificationTimestamp" => "2026-06-17T04:31:52.31Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29914132_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914132/5ec48af6396a372dd38d72e1a339837b.webp"
"MediaSize" => 91273
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914132/thumbnail-5ec48af6396a372dd38d72e1a339837b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring a bold accent wall, neutral carpeting, and a window with white plantation shutters"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838042"
"ResourceRecordKey" => "29914132"
"ModificationTimestamp" => "2026-06-17T04:31:52.31Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29914132_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914132/2e141995959b2d204876704491a6491a.webp"
"MediaSize" => 55860
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914132/thumbnail-2e141995959b2d204876704491a6491a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom with dual under-mount sinks set into a light-toned countertop, white cabinetry with silver-tone hardware, and a large wall-mounted mirror"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838042"
"ResourceRecordKey" => "29914132"
"ModificationTimestamp" => "2026-06-17T04:31:52.31Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29914132_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914132/aa44029fe10f4fbe593bdbe91ec7d0ea.webp"
"MediaSize" => 47749
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914132/thumbnail-aa44029fe10f4fbe593bdbe91ec7d0ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Full bathroom with a white ceramic tile tub surround, a built-in bathtub, and a window featuring white plantation shutters"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838042"
"ResourceRecordKey" => "29914132"
"ModificationTimestamp" => "2026-06-17T04:31:52.31Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29914132_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914132/e0644b85b200d705bd457c2549aa216e.webp"
"MediaSize" => 95333
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914132/thumbnail-e0644b85b200d705bd457c2549aa216e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring a wood-finish bed frame with an integrated headboard, light gray carpeting, and a window with white plantation shutters"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838042"
"ResourceRecordKey" => "29914132"
"ModificationTimestamp" => "2026-06-17T04:31:52.31Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29914132_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914132/fac575ff674e80e42673413e80ecff75.webp"
"MediaSize" => 68933
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914132/thumbnail-fac575ff674e80e42673413e80ecff75.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Light gray walls and beige carpet flooring provide a neutral backdrop for a window featuring white plantation shutters"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838042"
"ResourceRecordKey" => "29914132"
"ModificationTimestamp" => "2026-06-17T04:31:52.31Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29914132_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914132/5e36556c96ad25c863f7cc3f1dc93b1d.webp"
"MediaSize" => 74276
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914132/thumbnail-5e36556c96ad25c863f7cc3f1dc93b1d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Recessed ceiling light illuminating a spacious room with light gray walls and white trim"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838042"
"ResourceRecordKey" => "29914132"
"ModificationTimestamp" => "2026-06-17T04:31:52.31Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29914132_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914132/f3c0672d7cc9d1e49fb85057d4f53518.webp"
"MediaSize" => 58253
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914132/thumbnail-f3c0672d7cc9d1e49fb85057d4f53518.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a white vanity with integrated sink, a rectangular mirror, a bathtub with white subway tile surround, and tile flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838042"
"ResourceRecordKey" => "29914132"
"ModificationTimestamp" => "2026-06-17T04:31:52.31Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29914132_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914132/1077de8b63ef0155832b8301cf86e48d.webp"
"MediaSize" => 160597
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914132/thumbnail-1077de8b63ef0155832b8301cf86e48d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Backyard featuring extensive paver stone patio, artificial turf area, and wood fencing"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838042"
"ResourceRecordKey" => "29914132"
"ModificationTimestamp" => "2026-06-17T04:31:52.31Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29914132_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914132/7abc747eae008a6baf75ececc40b66eb.webp"
"MediaSize" => 159329
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914132/thumbnail-7abc747eae008a6baf75ececc40b66eb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive paver patio with a decorative stone inlay"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838042"
"ResourceRecordKey" => "29914132"
"ModificationTimestamp" => "2026-06-17T04:31:52.31Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29914132_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914132/7f0de295d3e89ff5abf1db985f567ed2.webp"
"MediaSize" => 151222
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914132/thumbnail-7f0de295d3e89ff5abf1db985f567ed2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive patio featuring a built-in pergola with string lighting and privacy screens"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838042"
"ResourceRecordKey" => "29914132"
"ModificationTimestamp" => "2026-06-17T04:31:52.31Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29914132_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914132/58f4ef881174ac669279a439d786beae.webp"
"MediaSize" => 138726
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914132/thumbnail-58f4ef881174ac669279a439d786beae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive backyard featuring a paver patio with a pergola, stone retaining wall, and artificial turf putting green"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838042"
"ResourceRecordKey" => "29914132"
"ModificationTimestamp" => "2026-06-17T04:31:52.31Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29914132_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914132/d6c511b9714456b1ca8aa452cf99ac39.webp"
"MediaSize" => 136122
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914132/thumbnail-d6c511b9714456b1ca8aa452cf99ac39.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive backyard patio featuring paver stones, a wooden privacy fence, a built-in fire pit, and a dedicated dining area under a modern pergola"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838042"
"ResourceRecordKey" => "29914132"
"ModificationTimestamp" => "2026-06-17T04:31:52.31Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29914132_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914132/b1fa276925319c65a39c7e9109d3fc36.webp"
"MediaSize" => 138577
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914132/thumbnail-b1fa276925319c65a39c7e9109d3fc36.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive paver patio featuring a built-in pergola with string lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838042"
"ResourceRecordKey" => "29914132"
"ModificationTimestamp" => "2026-06-17T04:31:52.31Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29914132_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914132/bcdff50e8b422722258e1a71112bcc07.webp"
"MediaSize" => 142237
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914132/thumbnail-bcdff50e8b422722258e1a71112bcc07.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Exterior featuring gray brick and horizontal siding, a patio with pavers, multiple windows with white louvered shutters, an outdoor pergola structure, and exterior wall sconces"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838042"
"ResourceRecordKey" => "29914132"
"ModificationTimestamp" => "2026-06-17T04:31:52.31Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29914132_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914132/a75e9106b6d61084c767f383bd1f337f.webp"
"MediaSize" => 139939
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914132/thumbnail-a75e9106b6d61084c767f383bd1f337f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Patio area featuring a concrete fire pit, paver stone flooring, and a brick exterior wall"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838042"
"ResourceRecordKey" => "29914132"
"ModificationTimestamp" => "2026-06-17T04:31:52.31Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29914132_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914132/941f75439813477f24c1b968b40fcc62.webp"
"MediaSize" => 148335
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914132/thumbnail-941f75439813477f24c1b968b40fcc62.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Contemporary residence featuring a striking black and white facade with stone accents and dark trim"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838042"
"ResourceRecordKey" => "29914132"
"ModificationTimestamp" => "2026-06-17T04:31:52.31Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29914132_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914132/5bc6f740b36127ecf99ab389f3cf2586.webp"
"MediaSize" => 139969
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914132/thumbnail-5bc6f740b36127ecf99ab389f3cf2586.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Aerial perspective showcasing a residential neighborhood with a central park space featuring a walking path and playground area"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838042"
"ResourceRecordKey" => "29914132"
"ModificationTimestamp" => "2026-06-17T04:31:52.31Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29914132_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914132/58c7b70ea640bcb0809c8d6cb1eef127.webp"
"MediaSize" => 120927
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914132/thumbnail-58c7b70ea640bcb0809c8d6cb1eef127.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Aerial perspective showcasing a residential area bordered by expansive green spaces"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838042"
"ResourceRecordKey" => "29914132"
"ModificationTimestamp" => "2026-06-17T04:31:52.31Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29914132_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914132/e3fd78d88ac63c128c2441eb583d2168.webp"
"MediaSize" => 170472
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914132/thumbnail-e3fd78d88ac63c128c2441eb583d2168.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern residential development featuring a variety of architectural styles, uniform street layouts, and green spaces"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838042"
"ResourceRecordKey" => "29914132"
"ModificationTimestamp" => "2026-06-17T04:31:52.31Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29914132_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914132/1ba69b072baaed7d8602c14eb08278ca.webp"
"MediaSize" => 157700
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914132/thumbnail-1ba69b072baaed7d8602c14eb08278ca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Aerial perspective showcasing a structured residential development with multiple detached and semi-detached homes"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838042"
"ResourceRecordKey" => "29914132"
"ModificationTimestamp" => "2026-06-17T04:31:52.31Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29914132_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914132/d9affbc013102f07b5e9bb08a9aa72f7.webp"
"MediaSize" => 62992
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914132/thumbnail-d9affbc013102f07b5e9bb08a9aa72f7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Floor plan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838042"
"ResourceRecordKey" => "29914132"
"ModificationTimestamp" => "2026-06-17T04:31:52.31Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29914132')"
+"ID": "1538007"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 156288" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24725
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1878141" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24719
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29914132'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25124
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29914132'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25140
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29914132' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.6008015 43.4593743)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25213
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25206
+post_id: "1534852"
+post_author: 1
+"ListingKey": "29908777"
+"ListingId": "40839715"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T22:15:05Z"
+"RFModificationTimestamp": "2026-06-16T22:16:00Z"
+"ListPrice": 499000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1487.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2V2"
+"UnparsedAddress": "600 WHITE ELM Boulevard Unit# 9, Waterloo, Ontario N2V2V2"
+"Coordinates": array:2 [
0 => -80.5870471
1 => 43.4667674
]
+"Latitude": 43.4667674
+"Longitude": -80.5870471
+"YearBuilt": 2003
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully maintained carpet-free 3-bedroom, 2-bathroom townhome in the highly sought-after Laurelwood/Columbia Forest community of Waterloo. Featuring elegant oak hardwood flooring throughout the living area and the entire second floor, this home offers both timeless style and easy maintenance. The bright and functional open-concept main floor boasts spacious living and dining areas with large windows and sliding doors that flood the space with natural light and lead to a private deck and backyard—perfect for entertaining or relaxing outdoors. The well-appointed kitchen provides ample cabinetry and workspace, while the upper level offers three generous bedrooms, including a spacious primary bedroom with a walk-in closet and convenient access to a full bathroom. The basement includes a bathroom rough-in, presenting an excellent opportunity to add a future washroom and customize additional living space to meet your needs. Complete with an attached garage and driveway parking, this home is ideally located steps to parks, trails, public transit, and top-rated schools, and just minutes from the Boardwalk Shopping Centre, YMCA, both universities, and all major amenities. The condo fees provide exceptional value by covering major exterior components, including roof, windows, and exterior doors repair and replacement, offering added peace of mind and reduced long-term maintenance costs. An outstanding opportunity for families, first-time buyers, or investors to own in one of Waterloo’s most desirable neighbourhoods. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
6 => "Microwave"
7 => "Hood Fan"
8 => "Garage door opener"
]
+"AssociationFee": "713.32"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Property Management"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Partial"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T17:53:42.414855+00:00"
+"Directions": "Erbsville Rd"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2055634"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "0"
+"PhotosChangeTimestamp": "2026-06-16T13:30:50Z"
+"PhotosCount": 27
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T22:09:47Z"
+"Stories": "2.0"
+"StreetName": "WHITE ELM"
+"StreetNumber": "600"
+"StreetSuffix": "Boulevard"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "3308.52"
+"Utilities": array:1 [
0 => "Cable"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/9_600_white_elm_blvd_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1660780154"
"RoomType" => "Laundry room"
"ListingId" => "40839715"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29908777"
"RoomLength" => null
"RoomDimensions" => "10'10'' x 6'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T22:09:47.54Z"
]
1 => array:11 [
"RoomKey" => "1660780155"
"RoomType" => "4pc Bathroom"
"ListingId" => "40839715"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29908777"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T22:09:47.54Z"
]
2 => array:11 [
"RoomKey" => "1660780156"
"RoomType" => "Bedroom"
"ListingId" => "40839715"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29908777"
"RoomLength" => null
"RoomDimensions" => "9'3'' x 9'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T22:09:47.54Z"
]
3 => array:11 [
"RoomKey" => "1660780157"
"RoomType" => "Bedroom"
"ListingId" => "40839715"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29908777"
"RoomLength" => null
"RoomDimensions" => "9'8'' x 13'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T22:09:47.54Z"
]
4 => array:11 [
"RoomKey" => "1660780158"
"RoomType" => "Primary Bedroom"
"ListingId" => "40839715"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29908777"
"RoomLength" => null
"RoomDimensions" => "12'5'' x 13'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T22:09:47.55Z"
]
5 => array:11 [
"RoomKey" => "1660780159"
"RoomType" => "2pc Bathroom"
"ListingId" => "40839715"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29908777"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T22:09:47.55Z"
]
6 => array:11 [
"RoomKey" => "1660780160"
"RoomType" => "Dining room"
"ListingId" => "40839715"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29908777"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 10'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T22:09:47.55Z"
]
7 => array:11 [
"RoomKey" => "1660780161"
"RoomType" => "Kitchen"
"ListingId" => "40839715"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29908777"
"RoomLength" => null
"RoomDimensions" => "8'3'' x 9'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T22:09:47.55Z"
]
8 => array:11 [
"RoomKey" => "1660780162"
"RoomType" => "Living room"
"ListingId" => "40839715"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29908777"
"RoomLength" => null
"RoomDimensions" => "12'5'' x 21'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T22:09:47.55Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29908777/600-white-elm-boulevard-unit-9-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "R7"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1367
+"BelowGradeFinishedArea": 120
+"OriginalEntryTimestamp": "2026-06-16T13:30:49.96Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1330898"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:27 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29908777_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908777/e8f17a8c4e11da4ac887713b925a8225.webp"
"MediaSize" => 129831
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908777/thumbnail-e8f17a8c4e11da4ac887713b925a8225.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Multi-level townhome featuring light-colored siding and brick accents"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40839715"
"ResourceRecordKey" => "29908777"
"ModificationTimestamp" => "2026-06-16T13:30:49.97Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29908777_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908777/3b540c3e86cf2007ac5010ff7abad587.webp"
"MediaSize" => 58996
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908777/thumbnail-3b540c3e86cf2007ac5010ff7abad587.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839715"
"ResourceRecordKey" => "29908777"
"ModificationTimestamp" => "2026-06-16T13:30:49.97Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29908777_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908777/f3b231388ecd09abedbc2bffdbcb43fb.webp"
"MediaSize" => 63681
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908777/thumbnail-f3b231388ecd09abedbc2bffdbcb43fb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839715"
"ResourceRecordKey" => "29908777"
"ModificationTimestamp" => "2026-06-16T13:30:49.97Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29908777_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908777/978400e537a5e36aa043858340efb3f5.webp"
"MediaSize" => 67018
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908777/thumbnail-978400e537a5e36aa043858340efb3f5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious open-concept living area featuring dark wood-finish flooring, recessed lighting, and a built-in console with shelving"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839715"
"ResourceRecordKey" => "29908777"
"ModificationTimestamp" => "2026-06-16T13:30:49.97Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29908777_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908777/d7a602fd7110265e80707893cbaea753.webp"
"MediaSize" => 81911
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908777/thumbnail-d7a602fd7110265e80707893cbaea753.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining area featuring wood-finish flooring, recessed lighting, and a sliding glass door providing access to an outdoor deck"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839715"
"ResourceRecordKey" => "29908777"
"ModificationTimestamp" => "2026-06-16T13:30:49.97Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29908777_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908777/da9fb8d0aaff10b73fa44fb28102c1e8.webp"
"MediaSize" => 88580
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908777/thumbnail-da9fb8d0aaff10b73fa44fb28102c1e8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept interior featuring light wood-finish flooring, recessed lighting, and white walls"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839715"
"ResourceRecordKey" => "29908777"
"ModificationTimestamp" => "2026-06-16T13:30:49.97Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29908777_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908777/47f895b949c4915fd6ffc6ac90919a96.webp"
"MediaSize" => 72664
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908777/thumbnail-47f895b949c4915fd6ffc6ac90919a96.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring wood-finish flooring, dark wood cabinetry, light-toned countertops, and stainless steel appliances including a refrigerator and range"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839715"
"ResourceRecordKey" => "29908777"
"ModificationTimestamp" => "2026-06-16T13:30:49.97Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29908777_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908777/d00831c24a778da68afa653f89f0bd06.webp"
"MediaSize" => 82084
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908777/thumbnail-d00831c24a778da68afa653f89f0bd06.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring dark wood cabinetry, light countertops, a stainless steel gas range, a stainless steel dishwasher, and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839715"
"ResourceRecordKey" => "29908777"
"ModificationTimestamp" => "2026-06-16T13:30:49.97Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29908777_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908777/3b2ca784855785bf4dfc06be5bc7c581.webp"
"MediaSize" => 73829
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908777/thumbnail-3b2ca784855785bf4dfc06be5bc7c581.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen area featuring stainless steel refrigerator, dark wood-finish cabinetry, and a light-toned countertop"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839715"
"ResourceRecordKey" => "29908777"
"ModificationTimestamp" => "2026-06-16T13:30:49.97Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29908777_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908777/5c65bd6bc3e4e0e6d33c6c68c9f36aaa.webp"
…10
]
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29908777')"
+"ID": "1534852"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25209
+post_id: "1534853"
+post_author: 1
+"ListingKey": "29909265"
+"ListingId": "40840228"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T15:00:09Z"
+"RFModificationTimestamp": "2026-06-16T17:33:37Z"
+"ListPrice": 499900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1085.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0A8"
+"UnparsedAddress": "776 LAURELWOOD Drive Unit# 406, Waterloo, Ontario N2V0A8"
+"Coordinates": array:2 [
0 => -80.598513
1 => 43.4709788
]
+"Latitude": 43.4709788
+"Longitude": -80.598513
+"YearBuilt": 2012
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This Amazing condo in a popular neighbourhood - Laurelwood, facing South with a bright, open layout, 2 bedrooms, 2 full bathrooms and 2 Parking Spaces. Upgraded white cabinetry on black granite kitchen, upgraded beautiful backsplash, under-mount lighting, upgraded stainless steel appliances including bar/wine fridge, upgraded lighting throughout.Insuite laundry. Well-painted, ready to move in. Great common amenities include a pool table, bike room, Locker room, Lounge, party room with a kitchen, a media room for private movie nights, and a gazebo with gas BBQs. The house is close to schools, ideal for families with school-going children, families with grown-up children, or empty nesters. The house is also conveniently located close to grocery shops, bus stops, a YMCA, a library, the boardwalk, Costco, conservation areas, and Lots of walking trails! Both the University of Waterloo and Wilfrid Laurier University are just a 10-minute drive by bus #13 or car. A MUST-SEE House!!! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"AssociationFee": "451.89"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Landscaping"
1 => "Property Management"
2 => "Water"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T17:33:33.322457+00:00"
+"Directions": "Erbsville Rd to Laurelwood Dr"
+"ExteriorFeatures": array:4 [
0 => "Steel"
1 => "Brick"
2 => "Stone"
3 => "Stucco"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1955745"
+"ListOfficeKey": "295659"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Southern exposure"
1 => "Conservation/green belt"
2 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Open"
]
+"PhotosChangeTimestamp": "2026-06-16T14:52:23Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T14:52:23Z"
+"Stories": "1.0"
+"StreetName": "LAURELWOOD"
+"StreetNumber": "776"
+"StreetSuffix": "Drive"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "3796.16"
+"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=9ji1sHAZH4Y"
+"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/29909265/776-laurelwood-drive-unit-406-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Party Room"
]
+"ZoningDescription": "MR100"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1085
+"OriginalEntryTimestamp": "2026-06-16T14:50:59.81Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1247419"
+"ListOfficeNationalAssociationId": "1452740"
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29909265')"
+"ID": "1534853"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25186
+post_id: "1534194"
+post_author: 1
+"ListingKey": "29908429"
+"ListingId": "40839737"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T13:00:03Z"
+"RFModificationTimestamp": "2026-06-16T14:12:53Z"
+"ListPrice": 859900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2651.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2W8"
+"UnparsedAddress": "223 BUTTERCUP Court, Waterloo, Ontario N2V2W8"
+"Coordinates": array:2 [
0 => -80.5974582
1 => 43.4739662
]
+"Latitude": 43.4739662
+"Longitude": -80.5974582
+"YearBuilt": 2005
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "BACKING ONTO CREEKSIDE PARK! Welcome to 223 Buttercup Court, located on a quiet court in Waterloo's sought-after Columbia Forest-Laurelwood neighbourhood. Offering 1,920 sq. ft., plus a fully finished walkout basement, this beautifully updated 3-bedroom, 4-bathroom home provides the perfect blend of space, flexibility, and location. The bright, functional layout features a second-floor family room, a beautifully renovated primary ensuite, fresh paint, updated flooring, and plenty of room for everyday family living. The fully finished walkout basement includes a second kitchen and full bathroom, offering excellent in-law or multi-generational living potential. Step outside to enjoy the expansive deck overlooking the fenced backyard and parkland beyond. Families will love the proximity to walking trails, parks, shopping, and top-rated schools, including Abraham Erb Public School (JK-6), Laurelwood Public School (7-8), and Laurel Heights Secondary School. Recent updates include Roof Shingles (2021), Furnace and Air Conditioner (2017), remodelled Primary Ensuite (2026), updated Family Bathroom Vanity (2026), fresh paint on the main and upper levels (2026), new Flooring on the second floor and basement (2026), a new Refrigerator in the main floor kitchen (2026), and a new Cooktop in the basement kitchen (2026). A fantastic opportunity to own a move-in ready home in one of Waterloo's most desirable family communities. Homes backing onto greenspace in this location don't come along often. Book your private showing today and discover everything this home has to offer. (id:62783)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Dishwasher"
5 => "Dryer"
6 => "Microwave"
7 => "Hood Fan"
8 => "Window Coverings"
9 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T14:12:47.156696+00:00"
+"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": "2073668"
+"ListOfficeKey": "289890"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-16T12:50:25Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T12:50:24Z"
+"Stories": "2.0"
+"StreetName": "BUTTERCUP"
+"StreetNumber": "223"
+"StreetSuffix": "Court"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "5740"
+"VirtualTourURLUnbranded": "https://youriguide.com/223_buttercup_court_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29908429/223-buttercup-court-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R5"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 1920
+"BelowGradeFinishedArea": 731
+"OriginalEntryTimestamp": "2026-06-16T11:49:24.14Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1348841"
+"ListOfficeNationalAssociationId": "1382470"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29908429')"
+"ID": "1534194"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25210
+post_id: "1534854"
+post_author: 1
+"ListingKey": "29908518"
+"ListingId": "X13449038"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T13:20:06Z"
+"RFModificationTimestamp": "2026-06-16T13:48:24Z"
+"ListPrice": 859900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2W8"
+"UnparsedAddress": "223 BUTTERCUP COURT, Waterloo, Ontario N2V2W8"
+"Coordinates": array:2 [
0 => -80.5974666
1 => 43.4739527
]
+"Latitude": 43.4739527
+"Longitude": -80.5974666
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "BACKING ONTO CREEKSIDE PARK! Welcome to 223 Buttercup Court, located on a quiet court in Waterloo's sought-after Columbia Forest-Laurelwood neighbourhood. Offering 1,920 sq. ft., plus a fully finished walkout basement, this beautifully updated 3-bedroom, 4-bathroom home provides the perfect blend of space, flexibility, and location.The bright, functional layout features a second-floor family room, a beautifully renovated primary ensuite, fresh paint, updated flooring, and plenty of room for everyday family living. The fully finished walkout basement includes a second kitchen and full bathroom, offering excellent in-law or multi-generational living potential.Step outside to enjoy the expansive deck overlooking the fenced backyard and parkland beyond. Families will love the proximity to walking trails, parks, shopping, and top-rated schools, including Abraham Erb Public School (JK-6), Laurelwood Public School (7-8), and Laurel Heights Secondary School.Recent updates include Roof Shingles (2021), Furnace and Air Conditioner (2017), remodelled Primary Ensuite (2026), updated Family Bathroom Vanity (2026), fresh paint on the main and upper levels (2026), new Flooring on the second floor and basement (2026), a new Refrigerator in the main floor kitchen (2026), and a new Cooktop in the basement kitchen (2026). A fantastic opportunity to own a move-in ready home in one of Waterloo's most desirable family communities. Homes backing onto greenspace in this location don't come along often. Book your private showing today and discover everything this home has to offer. (id:62783)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Cooktop"
9 => "Hood Fan"
10 => "Window Coverings"
11 => "Garage door opener"
]
+"Basement": array:3 [
0 => "Finished"
1 => "Full"
2 => "Walk out"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T13:45:36.186679+00:00"
+"Directions": "Cross Streets: Creekside Drive. ** Directions: Erbsville Rd - Creekside Drive."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2213189"
+"ListOfficeKey": "284147"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Cul-de-sac"
1 => "Conservation/green belt"
]
+"LotSizeDimensions": "30 x 98.5 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-16T13:13:51Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T13:13:51Z"
+"Stories": "2.0"
+"StreetName": "Buttercup"
+"StreetNumber": "223"
+"StreetSuffix": "Court"
+"TaxAnnualAmount": "5740"
+"VirtualTourURLUnbranded": "https://youriguide.com/223_buttercup_court_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29908518/223-buttercup-court-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "R5"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 30.0
+"OriginalEntryTimestamp": "2026-06-16T12:14:08.01Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1458998"
+"ListOfficeNationalAssociationId": "1338998"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29908518')"
+"ID": "1534854"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25208
+post_id: "1529774"
+post_author: 1
+"ListingKey": "29902232"
+"ListingId": "40839651"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T00:00:04Z"
+"RFModificationTimestamp": "2026-06-15T01:36:47Z"
+"ListPrice": 499900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1086.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0A8"
+"UnparsedAddress": "776 LAURELWOOD Drive Unit# 302, Waterloo, Ontario N2V0A8"
+"Coordinates": array:2 [
0 => -80.5998272
1 => 43.4705199
]
+"Latitude": 43.4705199
+"Longitude": -80.5998272
+"YearBuilt": 2012
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this stunning two-bedroom, two-bathroom corner suite featuring a rare southwest exposure and an abundance of natural light throughout the day. This bright and spacious open-concept layout offers comfortable living and effortless entertaining. The modern kitchen is equipped with ample cabinetry, stainless steel appliances, and a functional center island, with sliding doors leading to a private balcony overlooking the expansive green space of the neighboring school grounds. The sun-filled living room is enhanced by two large windows, while the primary bedroom features a large window and a private ensuite with a walk-in glass shower. The generously sized second bedroom is conveniently located next to a full four-piece bathroom, making it ideal for family members or guests. Additional features include in-suite laundry with a stackable washer and dryer, one above-grade parking space (#111), and an oversized exclusive storage locker (#1707) located in Locker Room 1700 on the main floor. Situated in the highly sought-after Laurelwood community, this exceptional condo backs onto top-rated Waterloo Region schools, including Laurel Heights Secondary School and Abraham Erb Public School. Public transit provides direct access to the University of Waterloo and major shopping destinations, while supermarkets, shops, the YMCA, library, parks, playgrounds, nature trails, and Laurel Creek Conservation Area are all within walking distance. Residents enjoy excellent building amenities including a welcoming lobby, elevator, outdoor BBQ area, games room, theatre room, party room, visitor parking, and bicycle storage. This is a rare opportunity to own a beautiful, move-in-ready home in one of Waterloo's most desirable neighbourhoods. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Microwave Built-in"
]
+"AssociationFee": "446.94"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T01:36:47.407038+00:00"
+"Directions": "Erbsville Rd. turn to Laurelwood Dr."
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Stucco"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2139921"
+"ListOfficeKey": "291992"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Southern exposure"
1 => "Conservation/green belt"
2 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-06-14T23:50:36Z"
+"PhotosCount": 49
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-14T23:50:35Z"
+"Stories": "1.0"
+"StreetName": "LAURELWOOD"
+"StreetNumber": "776"
+"StreetSuffix": "Drive"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "3953.04"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29902232/776-laurelwood-drive-unit-302-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2247895"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "291992"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Party Room"
]
+"ZoningDescription": "RMU-20"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1086
+"OriginalEntryTimestamp": "2026-06-14T23:50:35.83Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1391697"
+"ListOfficeNationalAssociationId": "1407252"
+"CoListAgentNationalAssociationId": "1486775"
+"CoListOfficeNationalAssociationId": "1407252"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29902232')"
+"ID": "1529774"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25183
+post_id: "1526888"
+post_author: 1
+"ListingKey": "29899457"
+"ListingId": "40836979"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T20:40:11Z"
+"RFModificationTimestamp": "2026-06-15T20:42:32Z"
+"ListPrice": 849900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1178.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2R4"
+"UnparsedAddress": "545 LAURELWOOD Drive Unit# 8, Waterloo, Ontario N2V2R4"
+"Coordinates": array:2 [
0 => -80.5892362
1 => 43.472406
]
+"Latitude": 43.472406
+"Longitude": -80.5892362
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Luxury Condo Bungalow Townhome (Perfect for Carefree Living//Young Professionals/Downsizers or Empty Nesters) Experience elevated main-floor living nestled in the heart of one of Waterloo's most coveted and desirable neighbourhoods, Laurelwood. This executive bungalow offers the perfect blend of luxury and natural privacy, backing directly onto a mature, tree-lined woodlot.The lush landscaping and charming front porch create a warm and inviting first impression. Step inside to a welcoming foyer where this bungalow offers elegant and carpet-free space. The sweeping 9' ceiling heights and large, bright windows create an incredibly airy and inviting atmosphere drawing natural light from every angle. Enjoy the warmth of a gas fireplace in the living room, a bright eat-in kitchen with a spacious dinette with garden doors opening to a walk-out private two tier deck ideal for your morning coffee or evening unwind. This beautifully maintained, 2+1 bedroom offers effortless, main-floor living. The large primary suite has a walk-in closet and an en-suite with a walk-in shower. The versatile second bedroom, currently used as a den, caters to your exact lifestyle needs. A convenient main-floor laundry as well as direct access to the garage adds to the home's practicality. Downstairs, the fully finished basement offers an incredible rec room/family room with a second gas fireplace, perfectly suited for hosting gatherings, movie nights or simply relaxing with loved ones along with a 4pc bathroom and a generous legal third bedroom and plenty of storage. Best of all the condo corporation takes care of all exterior maintenance, lawn care, and snow removal - giving you a true lock-and-leave convenience. With easy access to the Laurel Creek Conservation Area, scenic walking trails, YMCA, public transit and all local amenities, this move-in-ready home is a standout. Don't miss your chance to own this beautiful bungalow townhome - schedule your private showing today! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"AssociationFee": "675"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-13T02:10:08.151035+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Heating": array:1 [
0 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2192927"
+"ListOfficeKey": "294394"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-13T01:09:43Z"
+"PhotosCount": 49
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T20:31:59Z"
+"Stories": "1.0"
+"StreetName": "LAURELWOOD"
+"StreetNumber": "545"
+"StreetSuffix": "Drive"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "5098.85"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/pfcza_545_laurelwood_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29899457/545-laurelwood-drive-unit-8-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "R7"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 0.0
+"AboveGradeFinishedArea": 1178
+"OriginalEntryTimestamp": "2026-06-13T01:09:43.87Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1441867"
+"ListOfficeNationalAssociationId": "1438749"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29899457')"
+"ID": "1526888"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23374
+post_id: "1526793"
+post_author: 1
+"ListingKey": "29899532"
+"ListingId": "X13440680"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-13T18:25:11Z"
+"RFModificationTimestamp": "2026-06-13T18:26:28Z"
+"ListPrice": 849900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2R4"
+"UnparsedAddress": "8 - 545 LAURELWOOD DRIVE, Waterloo, Ontario N2V2R4"
+"Coordinates": array:2 [
0 => -80.5888765
1 => 43.4720287
]
+"Latitude": 43.4720287
+"Longitude": -80.5888765
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Luxury Condo Bungalow Townhome (Perfect for Carefree Living//Young Professionals/Downsizers or Empty Nesters) Experience elevated main-floor living nestled in the heart of one of Waterloo's most coveted and desirable neighbourhoods, Laurelwood. This executive bungalow offers the perfect blend of luxury and natural privacy, backing directly onto a mature, tree-lined woodlot.The lush landscaping and charming front porch create a warm and inviting first impression. Step inside to a welcoming foyer where this bungalow offers elegant and carpet-free space. The sweeping 9' ceiling heights and large, bright windows create an incredibly airy and inviting atmosphere drawing natural light from every angle. Enjoy the warmth of a gas fireplace in the living room, a bright eat-in kitchen with a spacious dinette with garden doors opening to a walk-out private two tier deck ideal for your morning coffee or evening unwind. This beautifully maintained, 2+1 bedroom offers effortless, main-floor living. The large primary suite has a walk-in closet and an en-suite with a walk-in shower. The versatile second bedroom, currently used as a den, caters to your exact lifestyle needs. A convenient main-floor laundry as well as direct access to the garage adds to the home's practicality. Downstairs, the fully finished basement offers an incredible rec room/family room with a second gas fireplace, perfectly suited for hosting gatherings, movie nights or simply relaxing with loved ones along with a 4pc bathroom and a generous legal third bedroom and plenty of storage. Best of all the condo corporation takes care of all exterior maintenance, lawn care, and snow removal - giving you a true lock-and-leave convenience. With easy access to the Laurel Creek Conservation Area, scenic walking trails, YMCA, public transit and all local amenities, this move-in-ready home is a standout. Don't miss your chance to own this beautiful bungalow townhome - schedule your private showing today! (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
7 => "Garage door opener remote(s)"
8 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Common Area Maintenance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-13T02:04:46.105847+00:00"
+"Directions": "Cross Streets: Birchmount/Cedar Bend. ** Directions: Birchmount/Cedar Bend/Hollyview Place."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1406393"
+"ListOfficeKey": "280225"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-13T01:41:25Z"
+"PhotosCount": 49
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-13T18:19:20Z"
+"Stories": "1.0"
+"StreetName": "Laurelwood"
+"StreetNumber": "545"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "5098.85"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/pfcza_545_laurelwood_dr_waterloo_on/"
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29899532/8-545-laurelwood-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "CMC"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-06-13T01:41:25.63Z"
+"ListAgentNationalAssociationId": "1109349"
+"ListOfficeNationalAssociationId": "1310773"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29899532')"
+"ID": "1526793"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25211
+post_id: "1524682"
+post_author: 1
+"ListingKey": "29895200"
+"ListingId": "40838845"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-13T00:40:13Z"
+"RFModificationTimestamp": "2026-06-13T00:41:23Z"
+"ListPrice": 1179000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 3112.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2V4"
+"UnparsedAddress": "725 ZURICH Drive, Waterloo, Ontario N2V2V4"
+"Coordinates": array:2 [
0 => -80.58337
1 => 43.4566032
]
+"Latitude": 43.4566032
+"Longitude": -80.58337
+"YearBuilt": 2005
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Located in the highly desirable neighbourhood of Clair Hills in West Waterloo, 725 Zurich Drive is a rare opportunity for growing families seeking space, functionality, and an unbeatable location! Boasting over 3000 sq/ft of finished living space, this impressive 5 Bed/3 Bath home offers a thoughtfully designed open concept layout with incredible versatility throughout. The bright and welcoming main floor serves as the heart of the home, featuring spacious principal rooms ideal for everyday living and entertaining. Large windows provide an abundance of natural light while creating a warm and inviting atmosphere. Recent major updates including a new roof with solar panels (~5k/Yr ROI), new windows, new furnace, and new on-demand water heater provide exceptional value and peace of mind for years to come. Upstairs, the spacious primary bedroom offers a comfortable retreat with a large en-suite, while an additional bedroom and full bathroom complete the upper level with functionality and convenience. A true standout feature of this home is the fully finished basement, offering exceptional additional living space with *3 generously sized bedrooms, making it ideal for larger families, multi-generational living, overnight guests, or flexible work-from-home options. Complete with a full bathroom and ample space for recreation or additional family living, the lower level adds tremendous versatility and value rarely found in homes within this neighbourhood. Step outside to enjoy the fully fenced backyard featuring a private patio area and storage shed, the perfect setting for relaxing evenings, entertaining guests, or safe outdoor play for children and pets alike. Ideally located near top-rated schools including Vista Hills and Laurel Heights Secondary School, as well as the scenic GeoTime trails and surrounding forest, this family-friendly location offers the perfect balance of convenience and nature. Pride of ownership is evident throughout this beautifully maintained home! (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Satellite Dish"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Hood Fan"
9 => "Window Coverings"
10 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T19:48:03.419047+00:00"
+"ExteriorFeatures": array:3 [
0 => "Concrete"
1 => "Brick"
2 => "Stone"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceFeatures": array:1 [
0 => "Insert"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2052274"
+"ListOfficeKey": "76826"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Corner Site"
1 => "Paved driveway"
2 => "Sump Pump"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-12T15:31:43Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-13T00:31:49Z"
+"Stories": "1.0"
+"StreetName": "ZURICH"
+"StreetNumber": "725"
+"StreetSuffix": "Drive"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "6877"
+"VirtualTourURLUnbranded": "https://youriguide.com/725_zurich_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29895200/725-zurich-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R5"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 3
+"FrontageLengthNumeric": 45.0
+"AboveGradeFinishedArea": 1587
+"BelowGradeFinishedArea": 1525
+"OriginalEntryTimestamp": "2026-06-12T15:31:43.37Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1327496"
+"ListOfficeNationalAssociationId": "1004387"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29895200')"
+"ID": "1524682"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25212
+post_id: "1524092"
+post_author: 1
+"ListingKey": "29896571"
+"ListingId": "X13438200"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T22:55:09Z"
+"RFModificationTimestamp": "2026-06-12T22:58:47Z"
+"ListPrice": 719000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2P6"
+"UnparsedAddress": "635 ROYAL FERN STREET, Waterloo, Ontario N2V2P6"
+"Coordinates": array:2 [
0 => -80.589798
1 => 43.464848
]
+"Latitude": 43.464848
+"Longitude": -80.589798
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "RARE FIND! Prime location with amazing privacy and forest views! This fully finished detached 3 bedroom, 3 bathroom home offers an exceptional layout and an excellent finished basement. As you pull up to the home, you'll immediately notice its charming curb appeal. Step inside and you'll find a bright, welcoming space that feels just right. The care and updates throughout the home are evident at every turn. The main floor features an open-concept kitchen, dining, and living area with a vaulted ceiling and beautiful patio doors leading to your backyard paradise. The yard includes a new deck (2024) and a fenced yard, creating a beautiful, peaceful retreat that is still low maintenance. Upstairs, the spacious primary bedroom overlooks the backyard and offers plenty of room to relax. The stunning, spa-like primary ensuite, updated in 2023, is truly impressive. Two additional bedrooms complete the upper level. The basement features another full bathroom, plenty of storage space, a home office, and a large recreation room. The location is fantastic, close to top rated schools, beautiful walking trails, shopping, and more! Don't miss this rare opportunity to own a private, move-in-ready home in an outstanding location. ** SEE VIDEO FOR FULL TOUR!! ** WOW! (id:62650)"
+"Appliances": array:2 [
0 => "Water softener"
1 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T18:21:27.298705+00:00"
+"Directions": "Cross Streets: Erbville Rd and Columbia Forst Blvd. ** Directions: Erbsville Rd, West on Columbia Forest Blvd, right on Royal Fern St."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2246631"
+"ListOfficeKey": "286835"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "27.8 x 106.1 FT"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-06-12T22:49:11Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T22:49:11Z"
+"Stories": "2.0"
+"StreetName": "ROYAL FERN"
+"StreetNumber": "635"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4225.17"
+"VirtualTourURLUnbranded": "https://youtu.be/6ORw7Bao_3A"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29896571/635-royal-fern-street-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 27.9
+"OriginalEntryTimestamp": "2026-06-12T17:56:38.8Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1485484"
+"ListOfficeNationalAssociationId": "1364242"
+"Media": array:40 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29896571')"
+"ID": "1524092"
}
]
+success: true
+page_size: 9
+page_count: 12
+count: 101
+after_key: ""
}
"RF Response Time" => "0.22 seconds"
]
]