array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29975146 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23441
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23443
+post_id: "1582426"
+post_author: 1
+"ListingKey": "29975146"
+"ListingId": "40843757"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-01T15:00:07Z"
+"RFModificationTimestamp": "2026-07-01T16:49:13Z"
+"ListPrice": 1995000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 3951.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2G3"
+"UnparsedAddress": "585 REGAL Place, Waterloo, Ontario N2V2G3"
+"Coordinates": array:2 [
0 => -80.6020125
1 => 43.4785166
]
+"Latitude": 43.4785166
+"Longitude": -80.6020125
+"YearBuilt": 2018
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Positioned on a beautifully landscaped corner lot at the end of a quiet cul-de-sac, 585 Regal Place offers an exceptional blend of luxury, comfort, and everyday livability in one of Waterloo's most sought-after neighbourhoods. This former model home showcases over 4,300 sq. ft. of thoughtfully designed living space, including more than 3,500 sq. ft. on the main level, complemented by an oversized triple-car garage with soaring ceilings and a dedicated workshop area. A cobblestone driveway and covered front entrance introduce an impressive interior where 10-foot ceilings, expansive windows, and spacious principal rooms create an inviting atmosphere filled with natural light. The chef-inspired kitchen serves as the heart of the home, offering custom cabinetry, granite countertops, premium appliances, a large island, and seamless access to the breakfast area and covered outdoor living space, making entertaining effortless in every season. Elegant formal living and dining rooms provide refined spaces for hosting, accented by rich hardwood flooring, statement lighting, and walls perfectly suited for displaying artwork. The luxurious primary suite is a private sanctuary featuring a spa-inspired ensuite with a double-sided fireplace, soaker tub, and an expansive custom dressing room. Two additional bedrooms, including a private ensuite, a dedicated home office, main-floor laundry, and a beautifully finished lower level with recreation, fitness, and guest accommodations ensure flexibility for every stage of life. Professionally landscaped gardens, mature trees, and multiple outdoor seating areas create a peaceful setting to relax or entertain. Just minutes from championship golf, scenic walking trails, the St. Jacobs Farmers' Market, shopping, and highly regarded schools, this remarkable residence delivers the space, quality, and lifestyle today's discerning buyer is seeking. (id:62650)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Wine Fridge"
6 => "Stove"
7 => "Dryer"
8 => "Microwave"
9 => "Hood Fan"
10 => "Window Coverings"
11 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-01T16:49:07.978429+00:00"
+"Directions": "Erbsville Rd to Regal Place"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Stucco"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "3"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564461"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Cul-de-sac"
1 => "Conservation/green belt"
2 => "Paved driveway"
3 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-01T14:50:30Z"
+"PhotosCount": 44
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-01T14:50:30Z"
+"Stories": "1.0"
+"StreetName": "REGAL"
+"StreetNumber": "585"
+"StreetSuffix": "Place"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "18533"
+"VirtualTourURLUnbranded": "https://youriguide.com/585_regal_pl_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
0 => array:11 [
"RoomKey" => "1672685731"
"RoomType" => "Utility room"
"ListingId" => "40843757"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29975146"
"RoomLength" => null
"RoomDimensions" => "17'2'' x 8'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T14:50:30.72Z"
]
1 => array:11 [
"RoomKey" => "1672685732"
"RoomType" => "4pc Bathroom"
"ListingId" => "40843757"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29975146"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T14:50:30.73Z"
]
2 => array:11 [
"RoomKey" => "1672685733"
"RoomType" => "Storage"
"ListingId" => "40843757"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29975146"
"RoomLength" => null
"RoomDimensions" => "22'5'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T14:50:30.73Z"
]
3 => array:11 [
"RoomKey" => "1672685734"
"RoomType" => "Cold room"
"ListingId" => "40843757"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29975146"
"RoomLength" => null
"RoomDimensions" => "7'4'' x 8'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T14:50:30.73Z"
]
4 => array:11 [
"RoomKey" => "1672685735"
"RoomType" => "Bedroom"
"ListingId" => "40843757"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29975146"
"RoomLength" => null
"RoomDimensions" => "16'7'' x 11'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T14:50:30.73Z"
]
5 => array:11 [
"RoomKey" => "1672685736"
"RoomType" => "Laundry room"
"ListingId" => "40843757"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29975146"
"RoomLength" => null
"RoomDimensions" => "14'3'' x 8'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T14:50:30.73Z"
]
6 => array:11 [
"RoomKey" => "1672685737"
"RoomType" => "Full bathroom"
"ListingId" => "40843757"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29975146"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T14:50:30.73Z"
]
7 => array:11 [
"RoomKey" => "1672685738"
"RoomType" => "Primary Bedroom"
"ListingId" => "40843757"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29975146"
"RoomLength" => null
"RoomDimensions" => "19'5'' x 14'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T14:50:30.74Z"
]
8 => array:11 [
"RoomKey" => "1672685739"
"RoomType" => "3pc Bathroom"
"ListingId" => "40843757"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29975146"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T14:50:30.74Z"
]
9 => array:11 [
"RoomKey" => "1672685740"
"RoomType" => "Bedroom"
"ListingId" => "40843757"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29975146"
"RoomLength" => null
"RoomDimensions" => "15'6'' x 12'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T14:50:30.74Z"
]
10 => array:11 [
"RoomKey" => "1672685741"
"RoomType" => "2pc Bathroom"
"ListingId" => "40843757"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29975146"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T14:50:30.74Z"
]
11 => array:11 [
"RoomKey" => "1672685742"
"RoomType" => "Office"
"ListingId" => "40843757"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29975146"
"RoomLength" => null
"RoomDimensions" => "16'8'' x 11'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T14:50:30.74Z"
]
12 => array:11 [
"RoomKey" => "1672685743"
"RoomType" => "Living room"
"ListingId" => "40843757"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29975146"
"RoomLength" => null
"RoomDimensions" => "23'8'' x 29'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T14:50:30.74Z"
]
13 => array:11 [
"RoomKey" => "1672685744"
"RoomType" => "Dining room"
"ListingId" => "40843757"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29975146"
"RoomLength" => null
"RoomDimensions" => "15'11'' x 13'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T14:50:30.74Z"
]
14 => array:11 [
"RoomKey" => "1672685745"
"RoomType" => "Breakfast"
"ListingId" => "40843757"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29975146"
"RoomLength" => null
"RoomDimensions" => "12'8'' x 17'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T14:50:30.74Z"
]
15 => array:11 [
"RoomKey" => "1672685746"
"RoomType" => "Kitchen"
"ListingId" => "40843757"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29975146"
"RoomLength" => null
"RoomDimensions" => "14'7'' x 17'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T14:50:30.75Z"
]
16 => array:11 [
"RoomKey" => "1672685747"
"RoomType" => "Foyer"
"ListingId" => "40843757"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29975146"
"RoomLength" => null
"RoomDimensions" => "7'2'' x 8'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T14:50:30.75Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29975146/585-regal-place-waterloo"
+"ParkingTotal": 9
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:2 [
0 => "Alarm system"
1 => "Monitored Alarm"
]
+"ZoningDescription": "SR4"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 87.0
+"AboveGradeFinishedArea": 3181
+"BelowGradeFinishedArea": 770
+"OriginalEntryTimestamp": "2026-07-01T14:50:30.66Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1070059"
+"ListOfficeNationalAssociationId": "1384313"
+"Media": array:44 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29975146_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/4c9b3f1b7028ce5f31e9490e090ff8d9.webp"
"MediaSize" => 157422
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-4c9b3f1b7028ce5f31e9490e090ff8d9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29975146_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/79e71b694d192bc9867f88fed4297945.webp"
"MediaSize" => 129944
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-79e71b694d192bc9867f88fed4297945.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29975146_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/e76ebfa3ba9f6fc604ca9384a83c90d1.webp"
"MediaSize" => 146558
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-e76ebfa3ba9f6fc604ca9384a83c90d1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29975146_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/88dfddb51ef472fb3e74ac65c2e90860.webp"
"MediaSize" => 126567
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-88dfddb51ef472fb3e74ac65c2e90860.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29975146_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/e16ac9562baa1de9818e9a7df82669db.webp"
"MediaSize" => 105577
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-e16ac9562baa1de9818e9a7df82669db.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29975146_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/2c6a752ca0e19359f2e8d9d5ec56c8ec.webp"
"MediaSize" => 94021
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-2c6a752ca0e19359f2e8d9d5ec56c8ec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29975146_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/3c4140f226984726dd3da101e068673e.webp"
"MediaSize" => 98660
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-3c4140f226984726dd3da101e068673e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29975146_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/1264c4e672334c51e8c4294c0bd3c153.webp"
"MediaSize" => 94198
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-1264c4e672334c51e8c4294c0bd3c153.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29975146_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/9fec1388c8422ad4488b1f3fce8c5497.webp"
"MediaSize" => 138312
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-9fec1388c8422ad4488b1f3fce8c5497.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29975146_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/c41152dcc9cc981a7fb1368441d0fe9b.webp"
"MediaSize" => 128466
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-c41152dcc9cc981a7fb1368441d0fe9b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29975146_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/3b5107da635cca1b1f5630d4e4943c50.webp"
"MediaSize" => 95096
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-3b5107da635cca1b1f5630d4e4943c50.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29975146_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/2d211c78f0202481b3b76050ecafd1b1.webp"
"MediaSize" => 122086
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-2d211c78f0202481b3b76050ecafd1b1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29975146_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/8a5dc8cee311ab9767ff61fa06cd5af9.webp"
"MediaSize" => 106604
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-8a5dc8cee311ab9767ff61fa06cd5af9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29975146_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/c91596d6b2fd4f761e22a209f474892a.webp"
"MediaSize" => 128191
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-c91596d6b2fd4f761e22a209f474892a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29975146_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/e4798c57e18ded018f700eedf2a6b9e4.webp"
"MediaSize" => 142571
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-e4798c57e18ded018f700eedf2a6b9e4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29975146_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/e934e34eacaf7594428b9a4ed1cf7526.webp"
"MediaSize" => 157514
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-e934e34eacaf7594428b9a4ed1cf7526.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29975146_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/1f431697421281a7620d903e47b0924f.webp"
"MediaSize" => 143772
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-1f431697421281a7620d903e47b0924f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29975146_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/9a7dabdfb854891023175a675edbc7ad.webp"
"MediaSize" => 117750
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-9a7dabdfb854891023175a675edbc7ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29975146_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/c2d1172c3a64135941698174e6186428.webp"
"MediaSize" => 110498
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-c2d1172c3a64135941698174e6186428.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29975146_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/00ccf8757e62aa47d4a7ae15e92bb343.webp"
"MediaSize" => 74988
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-00ccf8757e62aa47d4a7ae15e92bb343.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29975146_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/23ecc0025e67da1bd956297984d9e989.webp"
"MediaSize" => 70948
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-23ecc0025e67da1bd956297984d9e989.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29975146_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/70d7a60e752744c2ebb9ed7dbb057edc.webp"
"MediaSize" => 125647
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-70d7a60e752744c2ebb9ed7dbb057edc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29975146_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/a3f7746f23bb972a85d6c1f1d5ac48c8.webp"
"MediaSize" => 91865
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-a3f7746f23bb972a85d6c1f1d5ac48c8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29975146_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/aa9a6db839ab3543579aa26fb7585d3a.webp"
"MediaSize" => 55914
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-aa9a6db839ab3543579aa26fb7585d3a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29975146_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/c1a74d66ba68a2e4e6eb563b34d9a600.webp"
"MediaSize" => 137910
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-c1a74d66ba68a2e4e6eb563b34d9a600.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29975146_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/f0037c19b27659c02141cbd4e7414264.webp"
"MediaSize" => 104684
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-f0037c19b27659c02141cbd4e7414264.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29975146_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/373a7e07ac994faaf3607e87da446bda.webp"
"MediaSize" => 88474
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-373a7e07ac994faaf3607e87da446bda.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29975146_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/834eb872e74d8adfac10f5c476fdb04d.webp"
"MediaSize" => 87990
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-834eb872e74d8adfac10f5c476fdb04d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29975146_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/174506f7696285107801c9e1be0dbe20.webp"
"MediaSize" => 84287
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-174506f7696285107801c9e1be0dbe20.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29975146_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/4e0a4a24f4742cf10f12208037ba7f1c.webp"
"MediaSize" => 114592
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-4e0a4a24f4742cf10f12208037ba7f1c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29975146_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/3fbf39ccc9ad6d7d83818d0ea99e5e08.webp"
"MediaSize" => 116450
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-3fbf39ccc9ad6d7d83818d0ea99e5e08.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29975146_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/7310faffca34923adc239018f970ff62.webp"
"MediaSize" => 148937
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-7310faffca34923adc239018f970ff62.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29975146_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/9f2086034e413b37138b18aace7cbf91.webp"
"MediaSize" => 151130
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-9f2086034e413b37138b18aace7cbf91.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29975146_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/3bd1d377dcfcd1f68b2d6a20b4a62009.webp"
"MediaSize" => 157679
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-3bd1d377dcfcd1f68b2d6a20b4a62009.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29975146_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/6acbb1f53d81cd3acc6021f9b00f016f.webp"
"MediaSize" => 157675
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-6acbb1f53d81cd3acc6021f9b00f016f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29975146_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/2cffdc5bda120005ddcd376034ff3de2.webp"
"MediaSize" => 173980
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-2cffdc5bda120005ddcd376034ff3de2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29975146_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/d932ca466369a8c78b3ac0bedf8e1aba.webp"
"MediaSize" => 132701
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-d932ca466369a8c78b3ac0bedf8e1aba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29975146_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/bf44d7d2068b85efb09d2dbc5f110229.webp"
"MediaSize" => 209268
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-bf44d7d2068b85efb09d2dbc5f110229.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29975146_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/6bd6be42a1f850d4caf6277c8d951886.webp"
"MediaSize" => 239971
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-6bd6be42a1f850d4caf6277c8d951886.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29975146_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/0ea8011f07a1c61f0216ad17b317eea5.webp"
"MediaSize" => 131910
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-0ea8011f07a1c61f0216ad17b317eea5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29975146_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/ce4777db8d1908fc49c3f46970c56298.webp"
"MediaSize" => 192135
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-ce4777db8d1908fc49c3f46970c56298.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29975146_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/363292e31e4761811df356772cdf1a06.webp"
"MediaSize" => 204436
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-363292e31e4761811df356772cdf1a06.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29975146_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/063423256ee00ed04f16dd38ade82a29.webp"
"MediaSize" => 54586
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-063423256ee00ed04f16dd38ade82a29.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "29975146_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/f05cb339102abb47e72f1aceafac0479.webp"
"MediaSize" => 43075
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-f05cb339102abb47e72f1aceafac0479.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29975146')"
+"ID": "1582426"
}
]
+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 290168" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24874
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1564461" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24865
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29975146'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25272
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29975146'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25288
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29975146' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.6020125 43.4785166)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25361
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25355
+post_id: "1582284"
+post_author: 1
+"ListingKey": "29974955"
+"ListingId": "40840178"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-01T17:00:10Z"
+"RFModificationTimestamp": "2026-07-01T17:11:48Z"
+"ListPrice": 649900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1929.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2W5"
+"UnparsedAddress": "980 CREEKSIDE Drive, Waterloo, Ontario N2V2W5"
+"Coordinates": array:2 [
0 => -80.5995972
1 => 43.4717177
]
+"Latitude": 43.4717177
+"Longitude": -80.5995972
+"YearBuilt": 2005
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 980 Creekside Drive, a move-in-ready freehold townhome in Waterloo’s highly sought-after Laurelwood community — an ideal starter home for young families looking to settle near top-rated schools, parks, shopping, and everyday conveniences. This well-maintained 3-bedroom, 3.5-bathroom two-storey home offers a bright and functional open-concept main floor with a carpet-free layout, laminate flooring, and sliding doors leading to a private deck and fully fenced backyard — perfect for children, pets, and outdoor family time. The kitchen features ample cabinetry, stainless steel appliances, and a sleek glass backsplash, creating a practical and inviting space for busy family living. Upstairs, the spacious primary bedroom includes a walk-in closet with organizer and private ensuite, while the additional bedrooms are well-sized for children, guests, or a home office. The fully finished lower level provides valuable extra living space with a recreation room, 3-piece bathroom, laundry area, and storage room — ideal for a playroom, family movie nights, or a flexible work-from-home setup. Located within walking distance to schools, shopping, public transit, and close to the YMCA, universities, The Boardwalk, St. Jacobs Farmers’ Market, and the Waterloo Costco, this home offers the perfect blend of comfort, convenience, and community. A fantastic opportunity for first-time buyers and young families to own a move-in-ready home in one of Waterloo’s most desirable family-friendly neighbourhoods. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Hood Fan"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-01T14:51:04.303021+00:00"
+"Directions": "Laurelwood Drive Erbsville Road"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2130071"
+"ListOfficeKey": "300812"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Paved driveway"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-01T16:40:42Z"
+"PhotosCount": 46
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-01T16:51:27Z"
+"Stories": "2.0"
+"StreetName": "CREEKSIDE"
+"StreetNumber": "980"
+"StreetSuffix": "Drive"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "3521"
+"VirtualTourURLUnbranded": "https://realty.pixsouls.com/980-Creekside-Dr"
+"WaterSource": array:2 [
0 => "Municipal water"
1 => "Unknown"
]
+"Rooms": array:13 [
0 => array:11 [
"RoomKey" => "1672758317"
"RoomType" => "Bonus Room"
"ListingId" => "40840178"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29974955"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T16:51:27.78Z"
]
1 => array:11 [
"RoomKey" => "1672758318"
"RoomType" => "Laundry room"
"ListingId" => "40840178"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29974955"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T16:51:27.79Z"
]
2 => array:11 [
"RoomKey" => "1672758319"
"RoomType" => "3pc Bathroom"
"ListingId" => "40840178"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29974955"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T16:51:27.79Z"
]
3 => array:11 [
"RoomKey" => "1672758320"
"RoomType" => "Recreation room"
"ListingId" => "40840178"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29974955"
"RoomLength" => null
"RoomDimensions" => "13'0'' x 11'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T16:51:27.8Z"
]
4 => array:11 [
"RoomKey" => "1672758321"
"RoomType" => "4pc Bathroom"
"ListingId" => "40840178"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29974955"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T16:51:27.8Z"
]
5 => array:11 [
"RoomKey" => "1672758322"
"RoomType" => "3pc Bathroom"
"ListingId" => "40840178"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29974955"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T16:51:27.81Z"
]
6 => array:11 [
"RoomKey" => "1672758323"
…10
]
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/29974955/980-creekside-drive-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "FR50"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 22.0
+"AboveGradeFinishedArea": 1408
+"BelowGradeFinishedArea": 521
+"OriginalEntryTimestamp": "2026-07-01T14:10:29.26Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"BelowGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1382995"
+"ListOfficeNationalAssociationId": "1493167"
+"Media": array:46 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29974955')"
+"ID": "1582284"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25357
+post_id: "1579538"
+post_author: 1
+"ListingKey": "29971250"
+"ListingId": "40842678"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-30T17:46:24Z"
+"RFModificationTimestamp": "2026-06-30T18:23:55Z"
+"ListPrice": 539900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1163.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0A8"
+"UnparsedAddress": "776 LAURELWOOD Drive Unit# 716, Waterloo, Ontario N2V0A8"
+"Coordinates": array:2 [
0 => -80.5986515
1 => 43.4706239
]
+"Latitude": 43.4706239
+"Longitude": -80.5986515
+"YearBuilt": 2012
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Fantastic opportunity to own this one-of-a-kind corner penthouse offering stunning southwest exposure in one of the area's most desirable neighbourhoods, surrounded by conservation lands and top-rated schools. This beautifully updated condo features a renovated kitchen, carpet free flooring, and numerous upgrades throughout. The impressive kitchen boasts an oversized island with white quartz countertops, a modern white subway tile backsplash, under-cabinet lighting, and a walkout to the private balcony, where you can enjoy unobstructed panoramic city views. One of only four units in the building with a cathedral ceiling, this penthouse offers an exceptionally bright, open, and airy living space, with natural light streaming in from windows on multiple sides. The spacious primary bedroom features large windows, a private walkout to the balcony, and an updated ensuite with a glass walk-in shower. The second bedroom is thoughtfully positioned on the opposite side of the unit for added privacy and is complemented by a full 4-piece bathroom. Additional highlights include upgraded interior doors, baseboards, lighting fixtures, two owned underground parking spaces, and an oversized storage locker. Simply move in and enjoy low-maintenance condo living in an exceptional location. Be sure to check out the 360-degree panoramas! (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Microwave"
5 => "Window Coverings"
6 => "Garage door opener"
]
+"AssociationFee": "477.11"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-30T18:23:23.421739+00:00"
+"Directions": "ERBSVILLE ROAD TO LAURELWOOD DRIVE"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1600658"
+"ListOfficeKey": "290620"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:6 [
0 => "Southern exposure"
1 => "Conservation/green belt"
2 => "Balcony"
3 => "Paved driveway"
4 => "Skylight"
5 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-30T17:11:48Z"
+"PhotosCount": 48
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-30T17:11:48Z"
+"Stories": "1.0"
+"StreetName": "LAURELWOOD"
+"StreetNumber": "776"
+"StreetSuffix": "Drive"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "4297"
+"View": "View (panoramic)"
+"VirtualTourURLUnbranded": "https://youriguide.com/716_776_laurelwood_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29971250/776-laurelwood-drive-unit-716-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2070594"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "76826"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Party Room"
]
+"ZoningDescription": "MR100"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1163
+"OriginalEntryTimestamp": "2026-06-30T17:11:48.13Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1153962"
+"ListOfficeNationalAssociationId": "1389824"
+"CoListAgentNationalAssociationId": "1345744"
+"CoListOfficeNationalAssociationId": "1004387"
+"Media": array:48 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29971250')"
+"ID": "1579538"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25354
+post_id: "1574246"
+post_author: 1
+"ListingKey": "29963571"
+"ListingId": "40840611"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-28T01:30:15Z"
+"RFModificationTimestamp": "2026-06-28T04:35:44Z"
+"ListPrice": 549000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1482.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2X1"
+"UnparsedAddress": "619 WILD GINGER Avenue Unit# H45, Waterloo, Ontario N2V2X1"
+"Coordinates": array:2 [
0 => -80.5941875
1 => 43.469623
]
+"Latitude": 43.469623
+"Longitude": -80.5941875
+"YearBuilt": 2006
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to easy living in this spacious four level townhome offering a thoughtful layout and plenty of flexible space. The main level features a bright kitchen and dining area with access to a front balcony, perfect for morning coffee or summer BBQs. A convenient two piece bathroom and inviting living room overlook the private backyard, creating a comfortable space for everyday living and entertaining. Upstairs, you'll find two generously sized bedrooms and a full bathroom. The lower level rec room provides additional living space and could easily serve as a third bedroom, home office, or family room. Step outside from this level onto the deck and enjoy the privacy of your own backyard retreat. Laundry is conveniently located just inside the attached garage, adjacent to the rec room. The fourth level offers plenty of storage in the utility room and includes a bathroom rough in, providing potential for future expansion. With an attached garage, multiple outdoor living spaces, and a versatile floor plan, this home is an excellent opportunity for first-time buyers, downsizers, or investors alike. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
]
+"AssociationFee": "258"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Property Management"
1 => "Water"
2 => "Insurance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-28T04:35:40.657011+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1978914"
+"ListOfficeKey": "283168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-28T01:21:05Z"
+"PhotosCount": 35
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-28T01:21:04Z"
+"Stories": "3.0"
+"StreetName": "WILD GINGER"
+"StreetNumber": "619"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "3685"
+"VirtualTourURLUnbranded": "https://youriguide.com/h45_619_wild_ginger_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/29963571/619-wild-ginger-avenue-unit-h45-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2161263"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "283168"
+"GeocodeManualYN": true
+"ZoningDescription": "70-RMU-20"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1482
+"OriginalEntryTimestamp": "2026-06-28T01:21:04.9Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1264841"
+"ListOfficeNationalAssociationId": "1325206"
+"CoListAgentNationalAssociationId": "1412362"
+"CoListOfficeNationalAssociationId": "1325206"
+"Media": array:35 [
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]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29963571')"
+"ID": "1574246"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25358
+post_id: "1571642"
+post_author: 1
+"ListingKey": "29961010"
+"ListingId": "X13496142"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T21:55:08Z"
+"RFModificationTimestamp": "2026-06-26T22:37:39Z"
+"ListPrice": 769000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0A3"
+"UnparsedAddress": "A3 - 795 LAURELWOOD DRIVE, Waterloo, Ontario N2V0A3"
+"Coordinates": array:2 [
0 => -80.600804
1 => 43.471001
]
+"Latitude": 43.471001
+"Longitude": -80.600804
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Beautiful family home offers spacious layout throughout with a extra large living area. Situated in a quiet cul-de-sac with privacy surrounded by mature trees and landscaping. Beautiful curve appeal complex. This unit really good size 3 bedrooms upstairs with a cozy study or a tv room. This home has extra large garage compared to other units in the complex with tall ceiling to create more storage. The laundry room spacious behind the kitchen and there is a spacious separate pantry. The kitchen has stainless steel appliances, a quartz counter top is a deep and large single sink. The island has a breakfast bar with a separate dining area. Large sliding glass doors lead to the deck, cozy for reading or entertaining during summer evenings. The basement is fully finished and very spacious that can be used as a suite or a large rec room.with a full bathroom and large open areas which can be separated into bedrooms. One of the most desired school zones, walking distance to highly rated Abraham Erb public school and Laurel Heights Secondary school, Food basics and Shoppers drug mart. Within 7 min drive to University of Waterloo, Costco, YMCA, and The Boardwalk. Many all season walking trails around the neighbourhood.. The complex is a close community with small number of units. Very safe and welcoming... Equally good for anyone downsizing or starting a new family. This unit is larger than some detached homes in the neighbourhood at 1925 sqft. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Blinds"
7 => "Garage door opener remote(s)"
8 => "Water Heater"
]
+"AssociationFee": "314"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Common Area Maintenance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T22:37:28.493792+00:00"
+"Directions": "Cross Streets: Laurelwood Drive. ** Directions: Erbsville Road to Laurelwood Drive."
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Vinyl siding"
]
+"Flooring": array:2 [
0 => "Tile"
1 => "Hardwood"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1412135"
+"ListOfficeKey": "280225"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-26T21:49:26Z"
+"PhotosCount": 25
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-26T21:49:26Z"
+"Stories": "2.0"
+"StreetName": "Laurelwood"
+"StreetNumber": "795"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "4642.04"
+"VirtualTourURLUnbranded": "https://unbranded.iguideradix.com/3_795_laurelwood_dr_waterloo_on/"
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29961010/a3-795-laurelwood-drive-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Self Managed"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1999
+"LivingAreaMinimum": 1800
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2026-06-26T21:49:26.34Z"
+"ListAgentNationalAssociationId": "1105043"
+"ListOfficeNationalAssociationId": "1310773"
+"Media": array:25 [
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]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29961010')"
+"ID": "1571642"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25356
+post_id: "1568039"
+post_author: 1
+"ListingKey": "29956203"
+"ListingId": "40843022"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T01:45:02Z"
+"RFModificationTimestamp": "2026-06-26T04:50:46Z"
+"ListPrice": 1130000.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2774.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0C3"
+"UnparsedAddress": "745 WOOD LILY Street, Waterloo, Ontario N2V0C3"
+"Coordinates": array:2 [
0 => -80.5998881
1 => 43.4612882
]
+"Latitude": 43.4612882
+"Longitude": -80.5998881
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Here is the 40ft Model, not 36ft. Nestled in the highly sought-after Vista Hills community, this stunning executive home offers modern living in one of Waterloo’s most desirable neighbourhoods. Conveniently located near Costco, The Boardwalk, Boardwalk Medical Centre, shopping plazas, restaurants, and everyday amenities, this home is also within the top-ranked school boundaries of Vista Hills Public School and Laurel Heights Secondary School. Offering nearly 2,800 sq. ft. of thoughtfully designed living space, this home features a double-car garage and a bright openconcept layout. The modern kitchen flows seamlessly into the spacious living room with hardwood floors and a cozy fireplace, creating the perfect space for entertaining and family living. Sliding doors from the breakfast area lead to a private backyard retreat, while the separate dining room can also serve as a home office. Upstairs, each bedroom features its own private ensuite bathroom, providing comfort and privacy for the whole family. A versatile loft area offers additional space for a family lounge, study, or reading nook. Surrounded by scenic greenbelt and nature trails, this exceptional property perfectly blends luxury, convenience, and tranquility. A rare opportunity to own in one of Vista Hills’ most prestigious enclaves. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Hood Fan"
8 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T04:49:23.213409+00:00"
+"Directions": "Rock Elm St. /Wood Lily"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Stucco"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2073939"
+"ListOfficeKey": "253316"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-26T01:39:29Z"
+"PhotosCount": 45
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-26T01:39:29Z"
+"Stories": "2.0"
+"StreetName": "WOOD LILY"
+"StreetNumber": "745"
+"StreetSuffix": "Street"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "8766.67"
+"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=kx_UbYopPFU"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29956203/745-wood-lily-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R6"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 51.0
+"AboveGradeFinishedArea": 2774
+"OriginalEntryTimestamp": "2026-06-26T01:39:29.53Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1349103"
+"ListOfficeNationalAssociationId": "1223329"
+"Media": array:45 [
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]
]
+"DaysOnMarket": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29956203')"
+"ID": "1568039"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25331
+post_id: "1565600"
+post_author: 1
+"ListingKey": "29947558"
+"ListingId": "40841264"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-30T16:25:09Z"
+"RFModificationTimestamp": "2026-06-30T16:30:46Z"
+"ListPrice": 829900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1841.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2Y4"
+"UnparsedAddress": "419 RIDEAU RIVER Street, Waterloo, Ontario N2V2Y4"
+"Coordinates": array:2 [
0 => -80.5885442
1 => 43.4909309
]
+"Latitude": 43.4909309
+"Longitude": -80.5885442
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 419 Rideau River Street, a beautifully maintained 4-bedroom, 3-bathroom home in a sought-after Waterloo neighbourhood. A charming brick exterior, double garage, and covered front porch offer an inviting first impression.Inside, the bright main floor features hardwood flooring, California shutters throughout, and a comfortable open-concept living and dining area. The kitchen offers warm cabinetry, upgraded counters, stainless steel appliances, a centre island with seating, and plenty of workspace. The primary bedroom includes a walk-in closet and private ensuite with a glass shower, while a second bedroom and full bathroom complete the main level.The finished basement adds exceptional living space with a spacious recreation room, gas fireplace, two legal bedrooms, and a full bathroom, ideal for family, guests, or a home office setup.Enjoy a fully fenced backyard with a patio, landscaped gardens, and a gas BBQ line. The included Broil King BBQ is new in 2026. Notable updates include a 50-year shingle roof (2021), water softener (2017), reverse osmosis system with filters changed in 2026, upgraded kitchen counters (2022), Maytag washer (2022), LG dishwasher (2023), Maytag dryer (2025), and KitchenAid 30 electric range (2026).Outdoor lovers will appreciate being just 150 ft from the entrance to Stamm Woodlot and its 3.5 km wooded walking trail. Conveniently located approximately 4.8 km from St. Jacobs Farmers' Market and 5.5 km from Hwy 7/8 via Northfield Drive. (id:62650)"
+"Appliances": array:1 [
0 => "Water softener"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T01:04:27.455329+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2238484"
+"ListOfficeKey": "292003"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-30T15:51:24Z"
+"PhotosCount": 31
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-30T16:11:50Z"
+"Stories": "1.0"
+"StreetName": "RIDEAU RIVER"
+"StreetNumber": "419"
+"StreetSuffix": "Street"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "5740"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29947558/419-rideau-river-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 40.0
+"AboveGradeFinishedArea": 1042
+"BelowGradeFinishedArea": 799
+"OriginalEntryTimestamp": "2026-06-24T17:11:26.5Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1476314"
+"ListOfficeNationalAssociationId": "1407357"
+"Media": array:31 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
]
+"DaysOnMarket": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29947558')"
+"ID": "1565600"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23455
+post_id: "1565003"
+post_author: 1
+"ListingKey": "29948730"
+"ListingId": "40842788"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-01T15:55:08Z"
+"RFModificationTimestamp": "2026-07-01T15:57:19Z"
+"ListPrice": 1139000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 3143.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2P1"
+"UnparsedAddress": "723 BROOKMILL Place, Waterloo, Ontario N2V2P1"
+"Coordinates": array:2 [
0 => -80.5842507
1 => 43.4746813
]
+"Latitude": 43.4746813
+"Longitude": -80.5842507
+"YearBuilt": 2001
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 723 Brookmill Place in the desirable neighbourhood of Laurelwood in Waterloo. Just steps from the Laurel Creek Conservation area, this expansive 4 bedroom 4 bathroom family home offers over 3,000 square feet of updated living space you can move right into and immediately enjoy. Step inside through the double door entry way and appreciate the bright, open concept layout with hardwood & porcelain floors, 9 ft ceiling heights and updated finishes throughout. The chef’s kitchen has been carefully designed to cater to a passion for cooking and hosting, featuring a 10 ft quartz island, gas stove, wine bar with wine fridge, and two stainless steel dishwashers. Host a dinner party in the formal dining area with friends and family, or curl up by the gas fireplace in the family room on a cold night. Upstairs, the spacious primary suite serves as a luxurious retreat, complete with a beautifully appointed double sink ensuite bathroom with a glass shower and a functional walk-in closet. Three more generously sized bedrooms with hardwood floors and a 4 pc bathroom complete the upper level. The basement features a bright, expansive layout with brand new custom-ordered carpet, a 4th bathroom, and plenty of storage space. Outside, your backyard oasis awaits! Landscaped with both privacy and functionality in mind, this peaceful outdoor space with new sodding, solar lighting and a 12 ft gazebo makes you feel like you’ve escaped the busy city. Steps away from conservation trails, public and Catholic schools, the YMCA, shopping, dining, universities, golf courses and so much more. New furnace with air hydration system, new kitchen appliances, new hot Water heater tank. With an array of luxurious features and thoughtful touches inside & out, this distinguished residence offers a lifestyle of unparalleled comfort and convenience thats perfect for your family’s next chapter. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Water softener"
4 => "Gas stove(s)"
5 => "Dishwasher"
6 => "Wine Fridge"
7 => "Dryer"
8 => "Microwave"
9 => "Hood Fan"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T00:27:20.571658+00:00"
+"Directions": "Laurelwood Dr/ Brookmill Ct"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2088817"
+"ListOfficeKey": "76789"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Cul-de-sac"
1 => "Conservation/green belt"
2 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-24T19:51:09Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-01T15:50:00Z"
+"Stories": "2.0"
+"StreetName": "BROOKMILL"
+"StreetNumber": "723"
+"StreetSuffix": "Place"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "6960.78"
+"Utilities": array:2 [
0 => "Natural Gas"
1 => "Electricity"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29948730/723-brookmill-place-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R 5"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 36.0
+"AboveGradeFinishedArea": 2459
+"BelowGradeFinishedArea": 684
+"OriginalEntryTimestamp": "2026-06-24T19:51:09.22Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1362124"
+"ListOfficeNationalAssociationId": "1004357"
+"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": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29948730')"
+"ID": "1565003"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25359
+post_id: "1565101"
+post_author: 1
+"ListingKey": "29946711"
+"ListingId": "X13483494"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T12:10:07Z"
+"RFModificationTimestamp": "2026-06-29T12:13:27Z"
+"ListPrice": 829900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2Y4"
+"UnparsedAddress": "419 RIDEAU RIVER STREET, Waterloo, Ontario N2V2Y4"
+"Coordinates": array:2 [
0 => -80.588549
1 => 43.49095
]
+"Latitude": 43.49095
+"Longitude": -80.588549
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "OnePoint Association of REALTORS®"
+"PublicRemarks": "Welcome to 419 Rideau River Street, a beautifully maintained 4-bedroom, 3-bathroom home in a sought-after Waterloo neighbourhood. A charming brick exterior, double garage, and covered front porch offer an inviting first impression.Inside, the bright main floor features hardwood flooring, California shutters throughout, and a comfortable open-concept living and dining area. The kitchen offers warm cabinetry, upgraded counters, stainless steel appliances, a centre island with seating, and plenty of workspace. The primary bedroom includes a walk-in closet and private ensuite with a glass shower, while a second bedroom and full bathroom complete the main level.The finished basement adds exceptional living space with a spacious recreation room, gas fireplace, two legal bedrooms, and a full bathroom, ideal for family, guests, or a home office setup.Enjoy a fully fenced backyard with a patio, landscaped gardens, and a gas BBQ line. The included Broil King BBQ is new in 2026. Notable updates include a 50-year shingle roof (2021), water softener (2017), reverse osmosis system with filters changed in 2026, upgraded kitchen counters (2022), Maytag washer (2022), LG dishwasher (2023), Maytag dryer (2025), and KitchenAid 30" electric range (2026).Outdoor lovers will appreciate being just 150 ft from the entrance to Stamm Woodlot and its 3.5 km wooded walking trail. Conveniently located approximately 4.8 km from St. Jacobs Farmers' Market and 5.5 km from Hwy 7/8 via Northfield Drive. (id:62650)"
+"Appliances": array:1 [
0 => "Water softener"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T20:21:03.319748+00:00"
+"Directions": "Conservation Dr & Rideau River St"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1962651"
+"ListOfficeKey": "293196"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "40 x 101.7 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-24T18:56:17Z"
+"PhotosCount": 31
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-29T12:01:32Z"
+"Stories": "1.0"
+"StreetName": "Rideau River"
+"StreetNumber": "419"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "5740"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
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]
]
+"ListAOR": "OnePoint"
+"TaxYear": 2025
+"ListAORKey": "47"
+"ListingURL": "www.realtor.ca/real-estate/29946711/419-rideau-river-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1834162"
+"CommonInterest": "Freehold"
+"CoListAgentKey2": "1899457"
+"CoListOfficeKey": "293196"
+"GeocodeManualYN": false
+"CoListOfficeKey2": "292096"
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 40.0
+"OriginalEntryTimestamp": "2026-06-24T15:34:32.99Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1252137"
+"ListOfficeNationalAssociationId": "1423680"
+"CoListAgentNationalAssociationId": "1196633"
+"CoListAgentNationalAssociationId2": "1216506"
+"CoListOfficeNationalAssociationId": "1423680"
+"CoListOfficeNationalAssociationId2": "1408169"
+"Media": array:31 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
]
+"DaysOnMarket": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29946711')"
+"ID": "1565101"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25360
+post_id: "1561838"
+post_author: 1
+"ListingKey": "29945897"
+"ListingId": "40842553"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-28T20:20:23Z"
+"RFModificationTimestamp": "2026-06-28T20:25:12Z"
+"ListPrice": 880000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.11
+"LivingArea": 2692.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2V6"
+"UnparsedAddress": "439 WOODROW Drive, Waterloo, Ontario N2T2V6"
+"Coordinates": array:2 [
0 => -80.5847961
1 => 43.4697644
]
+"Latitude": 43.4697644
+"Longitude": -80.5847961
+"YearBuilt": 1999
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully renovated backsplit nestled in the highly sought after Laurelwood neighbourhood! Updated from top to bottom, this exceptional home offers the perfect blend of style, comfort, and functionality. The stunning 2016 kitchen is the heart of the home, featuring a large centre island ideal for family gatherings and entertaining, while flowing seamlessly into the spacious dining area and bright living room. Just steps away, the inviting lower level family room showcases a beautifully updated gas fireplace with custom mantel (2021) and patio doors leading to your own private backyard retreat. Beautifully landscaped with mature perennial gardens, a charming gazebo, and an outdoor BBQ and prep station that stays with the home, this backyard is designed for relaxing and entertaining alike. The lower level also features a versatile fourth bedroom, an updated 3 piece bathroom (2018), convenient laundry area, and direct access to the side entrance. The fully finished basement provides an expansive recreation room, utility room, and an abundance of storage. Upstairs, you'll find three generous bedrooms, including the primary retreat, along with a beautifully renovated 4 piece bathroom (2020) complete with a luxurious soaker tub. Double car garage equipped with Ev charger rough in, plus parking for 4 in your concrete driveway. Situated in one of Waterloo's most desirable family friendly neighbourhoods, this move in ready home is close to top rated schools, parks, walking trails, shopping, universities, and every amenity. Simply unpack and enjoy everything this exceptional Laurelwood home has to offer! (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T19:10:22.497664+00:00"
+"Directions": "Laurelwood to Old Oak Dr., to Woodrow."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Forced air"
2 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1958320"
+"ListOfficeKey": "290620"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Conservation/green belt"
1 => "Gazebo"
2 => "Sump Pump"
3 => "Automatic Garage Door Opener"
4 => "Private Yard"
]
+"LotSizeDimensions": "0.11"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-24T13:30:38Z"
+"PhotosCount": 45
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-28T20:10:52Z"
+"Stories": "3.0"
+"StreetName": "WOODROW"
+"StreetNumber": "439"
+"StreetSuffix": "Drive"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "5946"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/439_woodrow_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29945897/439-woodrow-drive-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1564580"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "76826"
+"GeocodeManualYN": true
+"ZoningDescription": "SD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 40.0
+"AboveGradeFinishedArea": 2037
+"BelowGradeFinishedArea": 655
+"OriginalEntryTimestamp": "2026-06-24T13:30:38.71Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1249173"
+"ListOfficeNationalAssociationId": "1389824"
+"CoListAgentNationalAssociationId": "1069941"
+"CoListOfficeNationalAssociationId": "1004387"
+"Media": array:45 [
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]
]
+"DaysOnMarket": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29945897')"
+"ID": "1561838"
}
]
+success: true
+page_size: 9
+page_count: 8
+count: 67
+after_key: ""
}
"RF Response Time" => "0.33 seconds"
]
]