array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29870543 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23338
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23340
+post_id: "1507008"
+post_author: 1
+"ListingKey": "29870543"
+"ListingId": "40836542"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-08T17:35:40Z"
+"RFModificationTimestamp": "2026-06-08T19:11:24Z"
+"ListPrice": 1400000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 2658.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0B4"
+"UnparsedAddress": "239 BUTTONBUSH Street, Waterloo, Ontario N2V0B4"
+"Coordinates": array:2 [
0 => -80.5915277
1 => 43.4499496
]
+"Latitude": 43.4499496
+"Longitude": -80.5915277
+"YearBuilt": 2014
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 239 Buttonbush Street, a stunning executive home in Waterloo’s desirable Vista Hills neighbourhood. This home offers the perfect blend of elegance, comfort, and everyday family functionality. Bright, and inviting, the main floor features beautiful new hardwood flooring and an open-concept layout designed for connection. Whether you’re hosting friends or gathering for a family meal, the spacious living and dining area brings everyone together. The elegant kitchen is the heart of the home, with stone countertops and a custom pantry. For added convenience, the main floor includes a large, dedicated laundry room and a powder room. Upstairs, five large bedrooms offer great flexibility for growing families and can also serve as a home office. The primary bedroom feels like a private retreat, with a large walk-in closet and a spa-like ensuite. You'll appreciate the stand-up shower on hectic mornings, and the soaker tub will be your sanctuary for relaxation following a strenuous day. This finished basement provides versatility for a fitness space, rec room, or guest suite and includes a full bathroom. You will appreciate the opportunity to customize this lower level to your needs. Step outside to your private backyard oasis! An incredible lot like this is difficult to find in the city! Perfect for lounging, dining, and entertaining, you will enjoy hot summer days cooling off in the spa pool or crisp, Fall mornings sipping coffee. The electric awning feature gives you the choice to have more shade or sun. Located in the prestigious and quiet Vista Hills neighbourhood, this home is close to excellent schools, parks, and amenities. Just minutes away, you will love the convenient proximity to Costco and all the dining, shopping and daily essentials of the bustling Boardwalk. This is a wonderful opportunity to own a thoughtfully designed family home in one of Waterloo’s most sought-after communities. Your home search stops here! Book your private showing today! (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Gas stove(s)"
3 => "Dishwasher"
4 => "Dryer"
5 => "Central Vacuum - Roughed In"
6 => "Hood Fan"
]
+"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-08T19:10:25.408971+00:00"
+"Directions": "Ladyslipper Drive / Buttonbush Street"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2025082"
+"ListOfficeKey": "291822"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Sump Pump"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-08T17:02:41Z"
+"PhotosCount": 45
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-08T17:02:41Z"
+"Stories": "2.0"
+"StreetName": "BUTTONBUSH"
+"StreetNumber": "239"
+"StreetSuffix": "Street"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "7879.08"
+"VirtualTourURLUnbranded": "https://youtu.be/7S_lr6SQODU"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [
"RoomKey" => "1655099866"
"RoomType" => "3pc Bathroom"
"ListingId" => "40836542"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29870543"
"RoomLength" => null
"RoomDimensions" => "9'7'' x 4'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-08T17:02:41.21Z"
]
1 => array:11 [
"RoomKey" => "1655099867"
"RoomType" => "Recreation room"
"ListingId" => "40836542"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29870543"
"RoomLength" => null
"RoomDimensions" => "27'4'' x 28'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-08T17:02:41.21Z"
]
2 => array:11 [
"RoomKey" => "1655099868"
"RoomType" => "4pc Bathroom"
"ListingId" => "40836542"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29870543"
"RoomLength" => null
"RoomDimensions" => "5'5'' x 9'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-08T17:02:41.21Z"
]
3 => array:11 [
"RoomKey" => "1655099869"
"RoomType" => "Bedroom"
"ListingId" => "40836542"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29870543"
"RoomLength" => null
"RoomDimensions" => "13'1'' x 16'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-08T17:02:41.21Z"
]
4 => array:11 [
"RoomKey" => "1655099870"
"RoomType" => "Bedroom"
"ListingId" => "40836542"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29870543"
"RoomLength" => null
"RoomDimensions" => "14'6'' x 13'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-08T17:02:41.21Z"
]
5 => array:11 [
"RoomKey" => "1655099871"
"RoomType" => "Bedroom"
"ListingId" => "40836542"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29870543"
"RoomLength" => null
"RoomDimensions" => "11'5'' x 9'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-08T17:02:41.22Z"
]
6 => array:11 [
"RoomKey" => "1655099872"
"RoomType" => "Bedroom"
"ListingId" => "40836542"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29870543"
"RoomLength" => null
"RoomDimensions" => "11'2'' x 12'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-08T17:02:41.22Z"
]
7 => array:11 [
"RoomKey" => "1655099873"
"RoomType" => "Full bathroom"
"ListingId" => "40836542"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29870543"
"RoomLength" => null
"RoomDimensions" => "9'2'' x 12'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-08T17:02:41.22Z"
]
8 => array:11 [
"RoomKey" => "1655099874"
"RoomType" => "Primary Bedroom"
"ListingId" => "40836542"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29870543"
"RoomLength" => null
"RoomDimensions" => "17'8'' x 15'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-08T17:02:41.22Z"
]
9 => array:11 [
"RoomKey" => "1655099875"
"RoomType" => "Laundry room"
"ListingId" => "40836542"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29870543"
"RoomLength" => null
"RoomDimensions" => "7'8'' x 13'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-08T17:02:41.22Z"
]
10 => array:11 [
"RoomKey" => "1655099876"
"RoomType" => "2pc Bathroom"
"ListingId" => "40836542"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29870543"
"RoomLength" => null
"RoomDimensions" => "8'0'' x 4'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-08T17:02:41.22Z"
]
11 => array:11 [
"RoomKey" => "1655099877"
"RoomType" => "Breakfast"
"ListingId" => "40836542"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29870543"
"RoomLength" => null
"RoomDimensions" => "10'4'' x 13'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-08T17:02:41.22Z"
]
12 => array:11 [
"RoomKey" => "1655099878"
"RoomType" => "Kitchen"
"ListingId" => "40836542"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29870543"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 14'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-08T17:02:41.23Z"
]
13 => array:11 [
"RoomKey" => "1655099879"
"RoomType" => "Dining room"
"ListingId" => "40836542"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29870543"
"RoomLength" => null
"RoomDimensions" => "13'7'' x 14'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-08T17:02:41.23Z"
]
14 => array:11 [
"RoomKey" => "1655099880"
"RoomType" => "Living room"
"ListingId" => "40836542"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29870543"
"RoomLength" => null
"RoomDimensions" => "14'5'' x 15'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-08T17:02:41.23Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29870543/239-buttonbush-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1989189"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "292624"
+"GeocodeManualYN": true
+"ZoningDescription": "R6-S"
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 34.0
+"AboveGradeFinishedArea": 2658
+"OriginalEntryTimestamp": "2026-06-08T17:02:41.15Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1304786"
+"ListOfficeNationalAssociationId": "1405037"
+"CoListAgentNationalAssociationId": "1273184"
+"CoListOfficeNationalAssociationId": "1414872"
+"Media": array:45 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29870543_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29870543/a5cc010407c0719d8b1dfd4c251fc2dd.webp"
"MediaSize" => 107575
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29870543/thumbnail-a5cc010407c0719d8b1dfd4c251fc2dd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40836542"
"ResourceRecordKey" => "29870543"
"ModificationTimestamp" => "2026-06-08T17:02:41.16Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29870543_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29870543/a4438fb5a3d50f6bd88a8a000f1164d2.webp"
"MediaSize" => 155068
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29870543/thumbnail-a4438fb5a3d50f6bd88a8a000f1164d2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "The boundary seen is an estimated representation of lot dimensions derived from Geowarehouse, intended solely for visualization purposes. Please note that it is not obtained from a survey and should n"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836542"
"ResourceRecordKey" => "29870543"
"ModificationTimestamp" => "2026-06-08T17:02:41.16Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29870543_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29870543/5570e14f1c52cc0d9a733a82c09520af.webp"
"MediaSize" => 77027
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29870543/thumbnail-5570e14f1c52cc0d9a733a82c09520af.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836542"
"ResourceRecordKey" => "29870543"
"ModificationTimestamp" => "2026-06-08T17:02:41.16Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29870543_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29870543/477124eab42208dcd9c783774b117bf6.webp"
"MediaSize" => 82618
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29870543/thumbnail-477124eab42208dcd9c783774b117bf6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836542"
"ResourceRecordKey" => "29870543"
"ModificationTimestamp" => "2026-06-08T17:02:41.16Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29870543_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29870543/505608a869992c272f39e3cef1705428.webp"
"MediaSize" => 85318
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29870543/thumbnail-505608a869992c272f39e3cef1705428.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836542"
"ResourceRecordKey" => "29870543"
"ModificationTimestamp" => "2026-06-08T17:02:41.16Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29870543_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29870543/ebc2855db95b0d67b961c4f0de6a2ceb.webp"
"MediaSize" => 88745
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29870543/thumbnail-ebc2855db95b0d67b961c4f0de6a2ceb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836542"
"ResourceRecordKey" => "29870543"
"ModificationTimestamp" => "2026-06-08T17:02:41.16Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29870543_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29870543/ec7ced089e1b8bfc3047175091bf3d3e.webp"
"MediaSize" => 93601
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29870543/thumbnail-ec7ced089e1b8bfc3047175091bf3d3e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836542"
"ResourceRecordKey" => "29870543"
"ModificationTimestamp" => "2026-06-08T17:02:41.16Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29870543_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29870543/9d302074eaeb45827e3e9ca7137a608f.webp"
"MediaSize" => 74155
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29870543/thumbnail-9d302074eaeb45827e3e9ca7137a608f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836542"
"ResourceRecordKey" => "29870543"
"ModificationTimestamp" => "2026-06-08T17:02:41.16Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29870543_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29870543/cbca4b5591bac54d61dade07ab1ff7d9.webp"
"MediaSize" => 85539
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29870543/thumbnail-cbca4b5591bac54d61dade07ab1ff7d9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836542"
"ResourceRecordKey" => "29870543"
"ModificationTimestamp" => "2026-06-08T17:02:41.16Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29870543_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29870543/b155da02cf373b8a0beca0363f477789.webp"
"MediaSize" => 76927
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29870543/thumbnail-b155da02cf373b8a0beca0363f477789.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836542"
"ResourceRecordKey" => "29870543"
"ModificationTimestamp" => "2026-06-08T17:02:41.16Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29870543_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29870543/449a663bb7a72f3077bad6cdd4234846.webp"
"MediaSize" => 72617
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29870543/thumbnail-449a663bb7a72f3077bad6cdd4234846.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836542"
"ResourceRecordKey" => "29870543"
"ModificationTimestamp" => "2026-06-08T17:02:41.16Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29870543_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29870543/2a175c4a21a9e9114c0d5c5f44f33cbf.webp"
"MediaSize" => 56675
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29870543/thumbnail-2a175c4a21a9e9114c0d5c5f44f33cbf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836542"
"ResourceRecordKey" => "29870543"
"ModificationTimestamp" => "2026-06-08T17:02:41.16Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29870543_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29870543/c8fad1da0a64124db7d9646f0b042689.webp"
"MediaSize" => 53873
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29870543/thumbnail-c8fad1da0a64124db7d9646f0b042689.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836542"
"ResourceRecordKey" => "29870543"
"ModificationTimestamp" => "2026-06-08T17:02:41.16Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29870543_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29870543/237eec15f4a0f359042a6ea895745325.webp"
"MediaSize" => 65343
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29870543/thumbnail-237eec15f4a0f359042a6ea895745325.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836542"
"ResourceRecordKey" => "29870543"
"ModificationTimestamp" => "2026-06-08T17:02:41.16Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29870543_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29870543/ad59a9f416edf5773184b599b88ecd0b.webp"
"MediaSize" => 79031
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29870543/thumbnail-ad59a9f416edf5773184b599b88ecd0b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836542"
"ResourceRecordKey" => "29870543"
"ModificationTimestamp" => "2026-06-08T17:02:41.16Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29870543_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29870543/3c630cebdbe2fbac6b054d800930233a.webp"
"MediaSize" => 67191
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29870543/thumbnail-3c630cebdbe2fbac6b054d800930233a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836542"
"ResourceRecordKey" => "29870543"
"ModificationTimestamp" => "2026-06-08T17:02:41.16Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29870543_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29870543/134658930d896664dcb72c96d69f31a1.webp"
"MediaSize" => 76332
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29870543/thumbnail-134658930d896664dcb72c96d69f31a1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836542"
"ResourceRecordKey" => "29870543"
"ModificationTimestamp" => "2026-06-08T17:02:41.16Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29870543_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29870543/4ec7da1b525ec121d0c513a040f9abdd.webp"
"MediaSize" => 57082
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29870543/thumbnail-4ec7da1b525ec121d0c513a040f9abdd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836542"
"ResourceRecordKey" => "29870543"
"ModificationTimestamp" => "2026-06-08T17:02:41.16Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29870543_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29870543/236265c4b74f2aafde7a0b5e5fd430ad.webp"
"MediaSize" => 75595
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29870543/thumbnail-236265c4b74f2aafde7a0b5e5fd430ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836542"
"ResourceRecordKey" => "29870543"
"ModificationTimestamp" => "2026-06-08T17:02:41.16Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29870543_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29870543/a0a25670a7a202632513a1fddf7493ae.webp"
"MediaSize" => 73060
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29870543/thumbnail-a0a25670a7a202632513a1fddf7493ae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836542"
"ResourceRecordKey" => "29870543"
"ModificationTimestamp" => "2026-06-08T17:02:41.16Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29870543_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29870543/2a79f2515da4787c06884eb76ab900ed.webp"
"MediaSize" => 73509
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29870543/thumbnail-2a79f2515da4787c06884eb76ab900ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836542"
"ResourceRecordKey" => "29870543"
"ModificationTimestamp" => "2026-06-08T17:02:41.16Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29870543_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29870543/da7b45f14a34fb0ec86a9e6affc53c0d.webp"
"MediaSize" => 73695
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29870543/thumbnail-da7b45f14a34fb0ec86a9e6affc53c0d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836542"
"ResourceRecordKey" => "29870543"
"ModificationTimestamp" => "2026-06-08T17:02:41.16Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29870543_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29870543/c30b778ff734b1eeccae6592e968a05e.webp"
"MediaSize" => 63704
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29870543/thumbnail-c30b778ff734b1eeccae6592e968a05e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836542"
"ResourceRecordKey" => "29870543"
"ModificationTimestamp" => "2026-06-08T17:02:41.16Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29870543_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29870543/e7481d047508268f1b7b62ac74b246bf.webp"
"MediaSize" => 97115
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29870543/thumbnail-e7481d047508268f1b7b62ac74b246bf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836542"
"ResourceRecordKey" => "29870543"
"ModificationTimestamp" => "2026-06-08T17:02:41.16Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29870543_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29870543/c322cd54290a4c9fe4e5bdd8f14b08af.webp"
"MediaSize" => 67174
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29870543/thumbnail-c322cd54290a4c9fe4e5bdd8f14b08af.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Items in photo are for visualization purposes only and may not be present at the time of visit."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836542"
"ResourceRecordKey" => "29870543"
"ModificationTimestamp" => "2026-06-08T17:02:41.16Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29870543_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29870543/c8f4bfca9b4a6146a4a98e7f7db58956.webp"
"MediaSize" => 69393
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29870543/thumbnail-c8f4bfca9b4a6146a4a98e7f7db58956.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Items in photo are for visualization purposes only and may not be present at the time of visit."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836542"
"ResourceRecordKey" => "29870543"
"ModificationTimestamp" => "2026-06-08T17:02:41.16Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29870543_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29870543/7b96567c44b18837b1c05dc0f1a91595.webp"
"MediaSize" => 53253
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29870543/thumbnail-7b96567c44b18837b1c05dc0f1a91595.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836542"
"ResourceRecordKey" => "29870543"
"ModificationTimestamp" => "2026-06-08T17:02:41.16Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29870543_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29870543/793b8607b3a0a4714bd48342d1f73a1b.webp"
"MediaSize" => 137245
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29870543/thumbnail-793b8607b3a0a4714bd48342d1f73a1b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836542"
"ResourceRecordKey" => "29870543"
"ModificationTimestamp" => "2026-06-08T17:02:41.16Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29870543_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29870543/41947df22e6815de917de03425fc18fe.webp"
"MediaSize" => 135042
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29870543/thumbnail-41947df22e6815de917de03425fc18fe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836542"
"ResourceRecordKey" => "29870543"
"ModificationTimestamp" => "2026-06-08T17:02:41.16Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29870543_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29870543/0e78e2ad56524b415725802b368f4907.webp"
"MediaSize" => 143406
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29870543/thumbnail-0e78e2ad56524b415725802b368f4907.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836542"
"ResourceRecordKey" => "29870543"
"ModificationTimestamp" => "2026-06-08T17:02:41.16Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29870543_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29870543/1cadf00bf3d4fe617f2aa01fc432838b.webp"
"MediaSize" => 138340
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29870543/thumbnail-1cadf00bf3d4fe617f2aa01fc432838b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836542"
"ResourceRecordKey" => "29870543"
"ModificationTimestamp" => "2026-06-08T17:02:41.16Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29870543_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29870543/bc3ef645844e62a25c8e87536c106c13.webp"
"MediaSize" => 136801
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29870543/thumbnail-bc3ef645844e62a25c8e87536c106c13.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836542"
"ResourceRecordKey" => "29870543"
"ModificationTimestamp" => "2026-06-08T17:02:41.16Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29870543_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29870543/3ea8c167b816fa8ae1d753c86188eb01.webp"
"MediaSize" => 134771
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29870543/thumbnail-3ea8c167b816fa8ae1d753c86188eb01.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836542"
"ResourceRecordKey" => "29870543"
"ModificationTimestamp" => "2026-06-08T17:02:41.16Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29870543_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29870543/fe5d97d78c54ad71ce8bf57739e9ea31.webp"
"MediaSize" => 101820
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29870543/thumbnail-fe5d97d78c54ad71ce8bf57739e9ea31.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836542"
"ResourceRecordKey" => "29870543"
"ModificationTimestamp" => "2026-06-08T17:02:41.16Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29870543_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29870543/073fdd6384020cbd04981425278c6691.webp"
"MediaSize" => 155665
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29870543/thumbnail-073fdd6384020cbd04981425278c6691.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836542"
"ResourceRecordKey" => "29870543"
"ModificationTimestamp" => "2026-06-08T17:02:41.16Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29870543_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29870543/082ba32fb1d7c16e1dadfd612279ddaa.webp"
"MediaSize" => 138629
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29870543/thumbnail-082ba32fb1d7c16e1dadfd612279ddaa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836542"
"ResourceRecordKey" => "29870543"
"ModificationTimestamp" => "2026-06-08T17:02:41.16Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29870543_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29870543/ace8e415d11a0fa3653bd359998965d6.webp"
"MediaSize" => 172503
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29870543/thumbnail-ace8e415d11a0fa3653bd359998965d6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836542"
"ResourceRecordKey" => "29870543"
"ModificationTimestamp" => "2026-06-08T17:02:41.16Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29870543_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29870543/9b43c93d12aa6edc921c12f6eb0d99eb.webp"
"MediaSize" => 147437
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29870543/thumbnail-9b43c93d12aa6edc921c12f6eb0d99eb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836542"
"ResourceRecordKey" => "29870543"
"ModificationTimestamp" => "2026-06-08T17:02:41.16Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29870543_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29870543/e2e454adf1b865e6556f3b461a9e1ef4.webp"
"MediaSize" => 176216
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29870543/thumbnail-e2e454adf1b865e6556f3b461a9e1ef4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836542"
"ResourceRecordKey" => "29870543"
"ModificationTimestamp" => "2026-06-08T17:02:41.16Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29870543_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29870543/cfc8fc6b0f1a0d023dab040d74174acb.webp"
"MediaSize" => 184543
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29870543/thumbnail-cfc8fc6b0f1a0d023dab040d74174acb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836542"
"ResourceRecordKey" => "29870543"
"ModificationTimestamp" => "2026-06-08T17:02:41.16Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29870543_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29870543/1d582414597df8cf4deb5c3f1588d722.webp"
"MediaSize" => 192229
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29870543/thumbnail-1d582414597df8cf4deb5c3f1588d722.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836542"
"ResourceRecordKey" => "29870543"
"ModificationTimestamp" => "2026-06-08T17:02:41.16Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29870543_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29870543/31a782eb8e02ef85232400d07486b89c.webp"
"MediaSize" => 134968
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29870543/thumbnail-31a782eb8e02ef85232400d07486b89c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836542"
"ResourceRecordKey" => "29870543"
"ModificationTimestamp" => "2026-06-08T17:02:41.16Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29870543_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29870543/7e94066c50da4eecf0f675187c11e750.webp"
"MediaSize" => 22343
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29870543/thumbnail-7e94066c50da4eecf0f675187c11e750.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836542"
"ResourceRecordKey" => "29870543"
"ModificationTimestamp" => "2026-06-08T17:02:41.16Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "29870543_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29870543/06306321bda41a55de15c4d53d242932.webp"
"MediaSize" => 25150
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29870543/thumbnail-06306321bda41a55de15c4d53d242932.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836542"
"ResourceRecordKey" => "29870543"
"ModificationTimestamp" => "2026-06-08T17:02:41.16Z"
]
44 => array:13 [
"Order" => 45
"MediaKey" => "29870543_4890_45"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29870543/b67593003cb9d6310db1362bd92091e3.webp"
"MediaSize" => 18035
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29870543/thumbnail-b67593003cb9d6310db1362bd92091e3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836542"
"ResourceRecordKey" => "29870543"
"ModificationTimestamp" => "2026-06-08T17:02:41.16Z"
]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29870543')"
+"ID": "1507008"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 291822" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24714
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2025082" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24707
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29870543'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25120
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29870543'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25135
+items: array:2 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25136
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31387354"
+"ListingKey": "29870543"
+"ListingId": "40836542"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-14"
+"OpenHouseStartTime": "2026-06-14T14:00:00Z"
+"OpenHouseEndTime": "2026-06-14T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-12T13:15:30Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31387354')"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25138
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31387355"
+"ListingKey": "29870543"
+"ListingId": "40836542"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-13"
+"OpenHouseStartTime": "2026-06-13T14:00:00Z"
+"OpenHouseEndTime": "2026-06-13T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-12T13:15:30Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31387355')"
}
]
+success: true
+page_size: 2
+page_count: 1
+count: 2
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29870543' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5915277 43.4499496)) 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 {#25207
+post_id: "1520602"
+post_author: 1
+"ListingKey": "29889823"
+"ListingId": "40838151"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T17:30:21Z"
+"RFModificationTimestamp": "2026-06-11T20:31:11Z"
+"ListPrice": 749900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2301.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2V4"
+"UnparsedAddress": "729 BRANDENBURG Boulevard, Waterloo, Ontario N2T2V4"
+"Coordinates": array:2 [
0 => -80.5790115
1 => 43.4569573
]
+"Latitude": 43.4569573
+"Longitude": -80.5790115
+"YearBuilt": 2001
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 729 Brandenburg Boulevard, a beautifully maintained and thoughtfully updated 3-bedroom, 3-bathroom detached home in one of Waterloo’s most sought-after family-friendly neighbourhoods. Offering the perfect blend of comfort, functionality, and convenience, this move-in-ready home is ideal for growing families and busy professionals alike. The main floor features a bright and inviting layout, where a central staircase creates distinct living spaces while maintaining an open and connected feel. Spacious principal rooms provide plenty of room for everyday living and entertaining, while direct access to the backyard seamlessly extends your living space outdoors. Upstairs, you'll find three generously sized bedrooms and a well-appointed main bathroom designed for everyday family living. The finished basement adds valuable additional space with a large rec room, versatile den, full bathroom, cold cellar, and utility room—perfect for a home office, guest space, or recreation area. A rare detached double-car garage accessed from the rear laneway, along with direct gated access to the backyard, offers exceptional convenience, privacy, and flexibility. Ideally located just minutes from shopping, restaurants, The Boardwalk, Costco, Laurel Creek Conservation Area, parks, and excellent schools, this home offers an outstanding lifestyle in a highly desirable Waterloo community. Meticulously cared for and perfectly situated, this is a home you won't want to miss. (id:62783)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T20:31:02.889440+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2011048"
+"ListOfficeKey": "76789"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T17:10:34Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T17:10:33Z"
+"Stories": "2.0"
+"StreetName": "BRANDENBURG"
+"StreetNumber": "729"
+"StreetSuffix": "Boulevard"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "4644"
+"VirtualTourURLUnbranded": "https://youriguide.com/729_brandenburg_blvd_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [
"RoomKey" => "1657188000"
"RoomType" => "2pc Bathroom"
"ListingId" => "40838151"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29889823"
"RoomLength" => null
"RoomDimensions" => "7'5'' x 3'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T17:10:33.97Z"
]
1 => array:11 [
"RoomKey" => "1657188001"
"RoomType" => "Bonus Room"
"ListingId" => "40838151"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29889823"
"RoomLength" => null
"RoomDimensions" => "9'9'' x 8'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T17:10:33.97Z"
]
2 => array:11 [
"RoomKey" => "1657188002"
"RoomType" => "Bonus Room"
"ListingId" => "40838151"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29889823"
"RoomLength" => null
"RoomDimensions" => "9'9'' x 10'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T17:10:33.97Z"
]
3 => array:11 [
"RoomKey" => "1657188003"
"RoomType" => "3pc Bathroom"
"ListingId" => "40838151"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29889823"
"RoomLength" => null
"RoomDimensions" => "7'11'' x 6'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T17:10:33.97Z"
]
4 => array:11 [
"RoomKey" => "1657188004"
"RoomType" => "Utility room"
"ListingId" => "40838151"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29889823"
"RoomLength" => null
"RoomDimensions" => "11'5'' x 7'6''"
"RoomDescription" => null
…2
]
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/29889823/729-brandenburg-boulevard-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 1549
+"BelowGradeFinishedArea": 752
+"OriginalEntryTimestamp": "2026-06-11T17:10:33.94Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1292484"
+"ListOfficeNationalAssociationId": "1004357"
+"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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29889823')"
+"ID": "1520602"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25209
+post_id: "1521937"
+post_author: 1
+"ListingKey": "29891240"
+"ListingId": "X13433662"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T20:15:13Z"
+"RFModificationTimestamp": "2026-06-11T20:20:04Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2X4"
+"UnparsedAddress": "462 LAUSANNE CRESCENT, Waterloo, Ontario N2T2X4"
+"Coordinates": array:2 [
0 => -80.5749644
1 => 43.453304
]
+"Latitude": 43.453304
+"Longitude": -80.5749644
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "OnePoint Association of REALTORS®"
+"PublicRemarks": "Rarely does a home offer the perfect combination of privacy, convenience, and natural surroundings quite like this. Welcome to 462 Lausanne Crescent, a beautifully maintained FREEHOLD townhouse in Waterloo's highly desirable Clair Hills neighbourhood - providing the freedom of homeownership with no condo fees and backing directly onto open park-like space. Inside, you'll find a thoughtfully designed layout featuring two spacious bedrooms, each complete with its own private 4-piece ensuite bathroom - an ideal setup for professionals, downsizers, guests, or those seeking comfortable multi-generational living. The bright and functional main living areas provide an inviting space for everyday life, while the fully finished basement expands your options with a generous recreation room and versatile den, perfect for a home office or hobby room. One of the home's standout features is its exceptional setting. Backing onto expansive open park-like space with no rear neighbours, you'll enjoy peaceful views, added privacy, and direct access to trails and the outdoors. Located in the sought-after Clair Hills community and nearby Boardwalk shopping district, you'll enjoy close proximity to shopping, restaurants, public transit, and everyday amenities making this a favourite neighbourhood for professionals, families, and active adults alike. Offering flexible living space, a fully finished basement, two private ensuites, no condo fees, and a premium park-side location, this is a wonderful opportunity to enjoy all that Clair Hills has to offer. (id:66098)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Sauna"
4 => "Central Vacuum"
5 => "Dishwasher"
6 => "Stove"
7 => "Dryer"
8 => "Freezer"
9 => "Window Coverings"
10 => "Garage door opener"
11 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T20:19:52.553690+00:00"
+"Directions": "Cross Streets: Erbsville Road. ** Directions: Erbsville Road to Keats Way to Brandenburg Blvd to Lausanne Cres."
+"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": "1555372"
+"ListOfficeKey": "85457"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "16 x 99.8 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T19:31:56Z"
+"PhotosCount": 47
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T20:04:17Z"
+"Stories": "2.0"
+"StreetName": "Lausanne"
+"StreetNumber": "462"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "3766.84"
+"VirtualTourURLUnbranded": "https://youriguide.com/lmi4y_462_lausanne_crescent_waterloo_on/"
+"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": "OnePoint"
+"ListAORKey": "47"
+"ListingURL": "www.realtor.ca/real-estate/29891240/462-lausanne-crescent-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2088761"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "85457"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 2
+"FrontageLengthNumeric": 16.0
+"OriginalEntryTimestamp": "2026-06-11T19:31:56.5Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1147383"
+"ListOfficeNationalAssociationId": "1002051"
+"CoListAgentNationalAssociationId": "1362076"
+"CoListOfficeNationalAssociationId": "1002051"
+"Media": array:47 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29891240')"
+"ID": "1521937"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25206
+post_id: "1520603"
+post_author: 1
+"ListingKey": "29890553"
+"ListingId": "40838621"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T01:15:04Z"
+"RFModificationTimestamp": "2026-06-12T01:18:56Z"
+"ListPrice": 2350000.0
+"BathroomsTotalInteger": 6.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0.374
+"LivingArea": 6672.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2E7"
+"UnparsedAddress": "336 BUSHWOOD Court, Waterloo, Ontario N2T2E7"
+"Coordinates": array:2 [
0 => -80.5744606
1 => 43.4627013
]
+"Latitude": 43.4627013
+"Longitude": -80.5744606
+"YearBuilt": 1989
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to The Woods' of Upper Beechwood. Bushwood Court is one of the premier cul-de-sacs in the subdivision. Built by Bushview Homes, this grand Georgian style brick home with stone accents, offers 5 bedrooms, 6 bathrooms, 3 gas fireplaces, triple car garage & a fully finished walkout basement level plus walk-up stairs to the garage. Fabulous 4,780 sq feet above grade plus the finished lower level with about an additional 1,891 sq feet ensures your family will enjoy the extensive livability of this home. Wonderful opportunity for a generational family to live comfortably here with modifications. Vestibule entry leads to an impressive foyer introducing you to a centre hall plan. The main floor features 9' ceilings with layered molding, Brazilian cherry hardwood floors, 18 travertine tile, wide baseboard trim, multiple windows in each room with French doors to open or close off the rooms while entertaining. Elegant oversized dining room. Gather in the kitchen featuring granite counters, bubble tile backsplash, stainless appliances, centre island with sitting peninsula plus multiple ceiling pot lights. The bright vaulted dinette has overhead skylights with views to the deck & mature yard. Your office can be on the main floor or one of the upper bedrooms. The Primary suite fits king sized furniture with a private den/nursery/sitting area plus has 3 closets & a 5 pc Ensuite. Each upper bathroom has its own linen closet. Bright basement level ready for recreation activities. Known for its great community spirit, families enjoy the neighbourhood for the greenspace trails that lead up to the Recreational facility which has a supervised oversized inground pool, basketball court & two tennis courts. Fun programs for the whole family to participate in throughout the Summer season. Minutes to shopping, Library, Laurelwood Conservation area plus Universities of Waterloo & Laurier. Amazing space in a wonderful location...Bushwood Court in Upper Beechwood! (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "Tudor"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T19:13:13.411100+00:00"
+"Directions": "Columbia Street West to roundabout at Bennington Gate, turn right on Clair Creek, right on Bushwood Court"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Brick Veneer"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "3"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564125"
+"ListOfficeKey": "76836"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Cul-de-sac"
1 => "Conservation/green belt"
2 => "Skylight"
3 => "Sump Pump"
4 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.374"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T18:31:42Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T01:09:56Z"
+"Stories": "2.0"
+"StreetName": "BUSHWOOD"
+"StreetNumber": "336"
+"StreetSuffix": "Court"
+"SubdivisionName": "440 - Upper Beechwood/Beechwood W."
+"TaxAnnualAmount": "18947.94"
+"VirtualTourURLUnbranded": "https://youriguide.com/336_bushwood_court_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:22 [
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]
17 => array:11 [ …11]
18 => array:11 [ …11]
19 => array:11 [ …11]
20 => array:11 [ …11]
21 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29890553/336-bushwood-court-waterloo"
+"ParkingTotal": 9
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 140.0
+"AboveGradeFinishedArea": 4781
+"BelowGradeFinishedArea": 1891
+"OriginalEntryTimestamp": "2026-06-11T18:31:42.07Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Measurement follows RMS"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1070169"
+"ListOfficeNationalAssociationId": "1004398"
+"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('29890553')"
+"ID": "1520603"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25210
+post_id: "1520604"
+post_author: 1
+"ListingKey": "29890254"
+"ListingId": "X13432602"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T18:05:11Z"
+"RFModificationTimestamp": "2026-06-11T18:50:56Z"
+"ListPrice": 749900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2V4"
+"UnparsedAddress": "729 BRANDENBURG BOULEVARD, Waterloo, Ontario N2T2V4"
+"Coordinates": array:2 [
0 => -80.57901
1 => 43.456959
]
+"Latitude": 43.456959
+"Longitude": -80.57901
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 729 Brandenburg Boulevard, a beautifully maintained and thoughtfully updated 3-bedroom, 3-bathroom detached home in one of Waterloo's most sought-after family-friendly neighbourhoods. Offering the perfect blend of comfort, functionality, and convenience, this move-in-ready home is ideal for growing families and busy professionals alike. The main floor features a bright and inviting layout, where a central staircase creates distinct living spaces while maintaining an open and connected feel. Spacious principal rooms provide plenty of room for everyday living and entertaining, while direct access to the backyard seamlessly extends your living space outdoors. Upstairs, you'll find three generously sized bedrooms and a well-appointed main bathroom designed for everyday family living. The finished basement adds valuable additional space with a large rec room, versatile den, full bathroom, cold cellar, and utility room-perfect for a home office, guest space, or recreation area. A rare detached double-car garage accessed from the rear laneway, along with direct gated access to the backyard, offers exceptional convenience, privacy, and flexibility. Ideally located just minutes from shopping, restaurants, The Boardwalk, Costco, Laurel Creek Conservation Area, parks, and excellent schools, this home offers an outstanding lifestyle in a highly desirable Waterloo community. Meticulously cared for and perfectly situated, this is a home you won't want to miss. (id:62783)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Wine Fridge"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Freezer"
9 => "Water Treatment"
10 => "Window Coverings"
11 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T18:50:49.899890+00:00"
+"Directions": "Cross Streets: Erbsville Rd and Keats Way. ** Directions: Erbsville Rd to Brandenburg Blvd."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2138804"
+"ListOfficeKey": "290246"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "30.2 x 115.6 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T17:59:58Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T17:59:58Z"
+"Stories": "2.0"
+"StreetName": "Brandenburg"
+"StreetNumber": "729"
+"StreetSuffix": "Boulevard"
+"TaxAnnualAmount": "4644"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/729_brandenburg_blvd_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29890254/729-brandenburg-boulevard-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 30.2
+"OriginalEntryTimestamp": "2026-06-11T17:59:58.77Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1390596"
+"ListOfficeNationalAssociationId": "1385020"
+"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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29890254')"
+"ID": "1520604"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25208
+post_id: "1518667"
+post_author: 1
+"ListingKey": "29888538"
+"ListingId": "40838818"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T01:55:13Z"
+"RFModificationTimestamp": "2026-06-12T02:01:24Z"
+"ListPrice": 719000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1746.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2P6"
+"UnparsedAddress": "635 ROYAL FERN Street, Waterloo, Ontario N2V2P6"
+"Coordinates": array:2 [
0 => -80.5898653
1 => 43.4648243
]
+"Latitude": 43.4648243
+"Longitude": -80.5898653
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"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:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave Built-in"
]
+"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-11T15:39:38.270491+00:00"
+"Directions": "Erbsville Road, west onto Columbia Forest Blvd, right onto Royal Fern, house on the left near top of the street."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1921681"
+"ListOfficeKey": "289848"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-12T01:49:36Z"
+"PhotosCount": 22
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T01:49:36Z"
+"Stories": "2.0"
+"StreetName": "ROYAL FERN"
+"StreetNumber": "635"
+"StreetSuffix": "Street"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"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": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29888538/635-royal-fern-street-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 28.0
+"AboveGradeFinishedArea": 1333
+"BelowGradeFinishedArea": 413
+"OriginalEntryTimestamp": "2026-06-11T15:11:24.95Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1227128"
+"ListOfficeNationalAssociationId": "1381908"
+"Media": array:22 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29888538')"
+"ID": "1518667"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25203
+post_id: "1517955"
+post_author: 1
+"ListingKey": "29884895"
+"ListingId": "40838570"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-10T20:15:15Z"
+"RFModificationTimestamp": "2026-06-10T20:43:37Z"
+"ListPrice": 675000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1952.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2L2"
+"UnparsedAddress": "704 STAR FLOWER Avenue, Waterloo, Ontario N2V2L2"
+"Coordinates": array:2 [
0 => -80.5876117
1 => 43.4653582
]
+"Latitude": 43.4653582
+"Longitude": -80.5876117
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Stunning 2 story home with a HUGE LOFT in a desirable family neighbourhood. Brand new kitchen with quartz countertops and new stainless appliances. Lovely living room with multiple windows that provide lots of natural light--such a great family space. Sunny dinette with slider walk-out to the deck. Amazing 3rd floor loft is fabulous bonus space for multipurpose--so many options: family room, workout area, office, den, playroom, etc! Good sized primary bedroom with vaulted ceiling and walk-in closet. The 2 other bedrooms are also large with good size closets. Finished basement with a walk out to the large private fenced yard. The home just received multiple updates which include New Kitchen, Appliances, Bathrooms, Paint, Carpet-Free Flooring, Lighting and much more! Amazing location: close to top rated schools, parks, shopping, Costco, kilometres of walking trails (also great for running, biking, walking the dog, etc.) (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-10T20:41:07.698967+00:00"
+"Directions": "Erbsville Rd & Columbia Forest Blvd."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1768640"
+"ListOfficeKey": "76807"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-10T20:09:55Z"
+"PhotosCount": 43
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-10T20:09:55Z"
+"Stories": "2.0"
+"StreetName": "STAR FLOWER"
+"StreetNumber": "704"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "4864"
+"VirtualTourURLUnbranded": "https://youriguide.com/704_star_flower_ave_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29884895/704-star-flower-avenue-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 32.0
+"AboveGradeFinishedArea": 1952
+"OriginalEntryTimestamp": "2026-06-10T20:09:55.55Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Measurement follows RMS"
+"ListAgentNationalAssociationId": "1185878"
+"ListOfficeNationalAssociationId": "1004370"
+"Media": array:43 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29884895')"
+"ID": "1517955"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23352
+post_id: "1514019"
+post_author: 1
+"ListingKey": "29880472"
+"ListingId": "40837748"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-10T04:10:38Z"
+"RFModificationTimestamp": "2026-06-10T06:47:30Z"
+"ListPrice": 569000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1147.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0G9"
+"UnparsedAddress": "142 FOAMFLOWER Place Unit# A036, Waterloo, Ontario N2V0G9"
+"Coordinates": array:2 [
0 => -80.5903782
1 => 43.4498871
]
+"Latitude": 43.4498871
+"Longitude": -80.5903782
+"YearBuilt": 2024
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to luxury living in the highly sought-after Vista Hills community of West Waterloo. This stunning executive stacked townhouse offers the perfect blend of modern design, comfort, and convenience. Featuring 3 spacious bedrooms and 2.5 bathrooms, this beautifully maintained home boasts an open-concept layout designed for today's lifestyle. The bright and inviting main floor is carpet-free and showcases a stylish kitchen complete with elegant quartz countertops, abundant cabinetry, a large center island with breakfast bar seating, and plenty of workspace for entertaining or everyday living. The spacious living and dining areas flow seamlessly to private outdoor spaces, with two balconies providing the perfect setting to enjoy your morning coffee or unwind after a long day. Upstairs, the primary retreat offers a luxurious ensuite bathroom featuring a sleek glass-enclosed shower, creating a spa-like experience in the comfort of your own home. Located in one of Waterloo's most desirable neighborhoods, Vista Hills is known for its top-rated schools, scenic walking trails, parks, and close proximity to shopping, dining, universities, and major commuter routes. xWhether you're a professional, growing family, or savvy investor, this exceptional home delivers the perfect combination of style, functionality, and an unbeatable location. Don't miss your opportunity to own in one of West Waterloo's premier communities. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Window Coverings"
]
+"AssociationFee": "363.87"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-10T06:47:20.432400+00:00"
+"Directions": "Columbia to Ladyslipper to Foamflower Place"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1878382"
+"ListOfficeKey": "283125"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Paved driveway"
]
+"PhotosChangeTimestamp": "2026-06-10T04:00:56Z"
+"PhotosCount": 36
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-10T04:00:56Z"
+"Stories": "2.0"
+"StreetName": "FOAMFLOWER"
+"StreetNumber": "142"
+"StreetSuffix": "Place"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "3329"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29880472/142-foamflower-place-unit-a036-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "R9 R6-FT"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1147
+"OriginalEntryTimestamp": "2026-06-10T04:00:56.55Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1205009"
+"ListOfficeNationalAssociationId": "1324759"
+"Media": array:36 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29880472')"
+"ID": "1514019"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25211
+post_id: "1511255"
+post_author: 1
+"ListingKey": "29877772"
+"ListingId": "X13421192"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T15:15:09Z"
+"RFModificationTimestamp": "2026-06-11T15:23:48Z"
+"ListPrice": 989900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2X4"
+"UnparsedAddress": "444 LAUSANNE CRESCENT, Waterloo, Ontario N2T2X4"
+"Coordinates": array:2 [
0 => -80.574006
1 => 43.452858
]
+"Latitude": 43.452858
+"Longitude": -80.574006
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 444 Lausanne Crescent! This well-maintained detached home offers an exceptional opportunity for growing families seeking space, comfort, and versatility. Featuring 3 spacious bedrooms plus a dedicated office space, this bright and functional home provides plenty of room for today's lifestyle. The main floor boasts a practical layout with generous living and dining areas, a well-appointed kitchen with ample cabinetry, and abundant natural light throughout.The upper level features three generously sized bedrooms and a separate office space, perfect for working from home, studying, or creating a dedicated hobby area. The fully finished basement adds valuable living space with two additional bedrooms, a kitchen, a living area, and its own dedicated laundry, providing excellent flexibility for extended family, guests, or multi-generational living. Enjoy a private backyard with no rear neighbours, offering added privacy and an ideal setting for entertaining, relaxing, and family gatherings. Located in a family-friendly neighbourhood close to schools, parks, shopping, restaurants, public transit, and major amenities. Just minutes from both the University of Waterloo and Wilfrid Laurier University, this move-in-ready home combines space, convenience, and an unbeatable location in one of Waterloo's most desirable communities. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-09T19:22:40.554775+00:00"
+"Directions": "Erbsville Rd To Brandenburg"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1896837"
+"ListOfficeKey": "51498"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "36 x 105.8 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-09T18:56:32Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T15:02:18Z"
+"StreetName": "Lausanne"
+"StreetNumber": "444"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "5571.35"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29877772/444-lausanne-crescent-waterloo"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 36.0
+"OriginalEntryTimestamp": "2026-06-09T18:56:32.71Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1214984"
+"ListOfficeNationalAssociationId": "1124039"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29877772')"
+"ID": "1511255"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25212
+post_id: "1511676"
+post_author: 1
+"ListingKey": "29877136"
+"ListingId": "X13420892"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-09T18:01:04Z"
+"RFModificationTimestamp": "2026-06-09T18:46:38Z"
+"ListPrice": 1049000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2V0B8"
+"UnparsedAddress": "541 SUNDEW DRIVE, Kitchener, Ontario N2V0B8"
+"Coordinates": array:2 [
0 => -80.596797
1 => 43.457194
]
+"Latitude": 43.457194
+"Longitude": -80.596797
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "(STEP INSIDE) 4-bdrm detached 2-storey in Vista Hills, Waterloo. Open-concept main floor built around a fully equipped gas kitchen, walk-out dining rm with built-in wine cooler & a family rm that overlooks the backyard. Primary bdrm has his & her walk-in closets & a private 4pc en suite with soaker tub & standup shower. Full-width unfinished basement rec room. Vacant & available with flexible closing. (MAIN LEVEL) Ceramic-tiled foyer leads to a generous laminate landing before the living areas open up. Kitchen has a full stainless steel appliance package - gas stove, range hood, fridge, dishwasher & microwave - double sink & laminate floors, all open to the family rm with clear backyard views. Dining area has a wine cooler & walk-out to the back deck - a practical extension of the space on warmer evenings. 2pc powder rm off the main hall. Dedicated laundry rm with GE washer/dryer, blue cabinetry & direct inside access to the garage. (UPPER LEVEL) Primary bdrm has his & her walk-in closets & a private 4pc en suite with separate standup shower & large soaker tub. Bdrms 2, 3 & 4 are each well-proportioned with double closets, large windows & laminate floors. Main 4pc bath serves the secondary bdrms. (BASEMENT) Full-width open rec room - unfinished & ready for your own layout. Utility rm has hot water tank, water treatment system & HRV, all in one organized space. Additional dedicated storage rm. (LOCATION) Vista Hills at the northwest edge of Waterloo, backed by Laurel Creek Conservation Area to the west. Sundew Park is steps from the door - playground & community garden with direct trail access. Geo-Time Trail network connects the neighbourhood to the largest protected woodland in Waterloo. The Boardwalk at Ira Needles is ~10 min by car for grocery, dining, retail & Costco. Laurel Heights SS 1.5 km north. University of Waterloo & Wilfrid Laurier University a short drive east. (id:62650)"
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-09T18:46:25.888979+00:00"
+"Directions": "Cross Streets: Platinum Dr and Columbia St W. ** Directions: At Platinum Dr and Columbia St W, head northwest on Platinum Dr; At the roundabout, take the 3rd exit onto Columbia St W for 400 m; At the roundabout, take the 1st exit onto Sundew Dr; Destination will be on the left."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Flooring": array:2 [
0 => "Laminate"
1 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1922276"
+"ListOfficeKey": "238732"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "38 x 98.4 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-09T17:50:25Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-09T17:50:25Z"
+"Stories": "2.0"
+"StreetName": "Sundew"
+"StreetNumber": "541"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "6686"
+"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": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29877136/541-sundew-drive-kitchener"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 38.0
+"OriginalEntryTimestamp": "2026-06-09T17:50:25.54Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1227436"
+"ListOfficeNationalAssociationId": "1200762"
+"Media": array:47 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29877136')"
+"ID": "1511676"
}
]
+success: true
+page_size: 9
+page_count: 9
+count: 77
+after_key: ""
}
"RF Response Time" => "0.21 seconds"
]
]
