array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 30068661 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23528
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23530
+post_id: "1650965"
+post_author: 1
+"ListingKey": "30068661"
+"ListingId": "X13595776"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-23T01:05:41Z"
+"RFModificationTimestamp": "2026-07-23T01:16:39Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2M1"
+"UnparsedAddress": "518 BROOKMILL CRESCENT, Waterloo, Ontario N2V2M1"
+"Coordinates": array:2 [
0 => -80.583029
1 => 43.472566
]
+"Latitude": 43.472566
+"Longitude": -80.583029
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "OnePoint Association of REALTORS®"
+"PublicRemarks": "Welcome to the home that checks all the boxes-and then a few you didn't even know were on your list!** Located in Waterloo's ever-popular Laurelwood neighborhoods, this beautifully maintained 3-bedroom, 2.5-bathroom home is ready for its next chapter. From the moment you step inside, you'll appreciate the bright, carpet-free main floor that's perfect for busy families, muddy paws, and everyday life. The functional main floor offers plenty of space to gather, whether you're hosting friends for dinner, helping with homework at the kitchen table, or enjoying a quiet night in. Upstairs, you'll find three spacious bedrooms, including a relaxing primary retreat with its own ensuite-because everyone deserves a little space to escape. Need more room? The finished basement has you covered! With a large carpet-free rec room, it's ready to become your movie lounge, kids' playroom, home gym, office, games room...or maybe all of them! Plus, the extensive built-in storage means you can finally tuck away the holiday decorations, hockey equipment, and all those "I'll deal with it later" bins. Outside, the single-car garage and private driveway make coming and going a breeze, while the location is hard to beat. You're surrounded by parks, walking trails, top-rated schools, shopping, restaurants, the YMCA, and everything that makes Laurelwood one of Waterloo's most loved communities. This isn't just another house-it's the kind of home where birthday parties are celebrated, backyard BBQs become a summer tradition, and Friday night pizza tastes just a little bit better. Come see why so many people dream of calling Laurelwood home... and why 518 Brookmill Crescent might just be the one you've been waiting for. (id:66098)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Water softener"
2 => "Dryer"
3 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-23T01:16:28.826767+00:00"
+"Directions": "LAURELWOOD DR"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2127309"
+"ListOfficeKey": "275615"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Cul-de-sac"
1 => "Conservation/green belt"
2 => "Sump Pump"
]
+"LotSizeDimensions": "30.2 x 115 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-23T00:58:53Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-23T00:58:53Z"
+"Stories": "2.0"
+"StreetName": "Brookmill"
+"StreetNumber": "518"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "5430"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/518_brookmill_crescent_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "OnePoint"
+"TaxYear": 2026
+"ListAORKey": "47"
+"ListingURL": "www.realtor.ca/real-estate/30068661/518-brookmill-crescent-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 30.2
+"OriginalEntryTimestamp": "2026-07-23T00:58:53.87Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1380658"
+"ListOfficeNationalAssociationId": "1266850"
+"Media": array:47 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30068661_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30068661/6b152ecd60b667d93222d855cde442a3.webp"
"MediaSize" => 289926
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30068661/thumbnail-6b152ecd60b667d93222d855cde442a3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13595776"
"ResourceRecordKey" => "30068661"
"ModificationTimestamp" => "2026-07-23T00:58:53.88Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30068661_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30068661/77420170ce51875a0ba63b0886b8da95.webp"
"MediaSize" => 338250
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30068661/thumbnail-77420170ce51875a0ba63b0886b8da95.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13595776"
"ResourceRecordKey" => "30068661"
"ModificationTimestamp" => "2026-07-23T00:58:53.88Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30068661_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30068661/f4a48750c55beef9339329b35b1a8953.webp"
"MediaSize" => 244837
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30068661/thumbnail-f4a48750c55beef9339329b35b1a8953.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13595776"
"ResourceRecordKey" => "30068661"
"ModificationTimestamp" => "2026-07-23T00:58:53.88Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30068661_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30068661/584e60cd8a15785f2f17b1815063602c.webp"
"MediaSize" => 156836
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30068661/thumbnail-584e60cd8a15785f2f17b1815063602c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13595776"
"ResourceRecordKey" => "30068661"
"ModificationTimestamp" => "2026-07-23T00:58:53.88Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30068661_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30068661/8a35f7e14a9220624ec030a2183147b1.webp"
"MediaSize" => 143751
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30068661/thumbnail-8a35f7e14a9220624ec030a2183147b1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13595776"
"ResourceRecordKey" => "30068661"
"ModificationTimestamp" => "2026-07-23T00:58:53.88Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30068661_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30068661/680475dc1267d27b736d8fdcb87e8f92.webp"
"MediaSize" => 172865
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30068661/thumbnail-680475dc1267d27b736d8fdcb87e8f92.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13595776"
"ResourceRecordKey" => "30068661"
"ModificationTimestamp" => "2026-07-23T00:58:53.88Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30068661_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30068661/73b150f251bc7f2a27cdca1bb531d1ee.webp"
"MediaSize" => 174086
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30068661/thumbnail-73b150f251bc7f2a27cdca1bb531d1ee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13595776"
"ResourceRecordKey" => "30068661"
"ModificationTimestamp" => "2026-07-23T00:58:53.88Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30068661_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30068661/ec2bdfed33b7e74c4402c50559cd0cd0.webp"
"MediaSize" => 194453
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30068661/thumbnail-ec2bdfed33b7e74c4402c50559cd0cd0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13595776"
"ResourceRecordKey" => "30068661"
"ModificationTimestamp" => "2026-07-23T00:58:53.88Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30068661_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30068661/5d6419121bec342e8ee3f360a29e34f3.webp"
"MediaSize" => 162797
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30068661/thumbnail-5d6419121bec342e8ee3f360a29e34f3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13595776"
"ResourceRecordKey" => "30068661"
"ModificationTimestamp" => "2026-07-23T00:58:53.88Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30068661_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30068661/f73b132bb68a70f14233175fd893b583.webp"
"MediaSize" => 153770
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30068661/thumbnail-f73b132bb68a70f14233175fd893b583.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13595776"
"ResourceRecordKey" => "30068661"
"ModificationTimestamp" => "2026-07-23T00:58:53.88Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30068661_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30068661/3e05fd0ac273ee74b966a3415ec8ab44.webp"
"MediaSize" => 165047
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30068661/thumbnail-3e05fd0ac273ee74b966a3415ec8ab44.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13595776"
"ResourceRecordKey" => "30068661"
"ModificationTimestamp" => "2026-07-23T00:58:53.88Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30068661_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30068661/25e7a41f36ca6d46d0821cb854e31604.webp"
"MediaSize" => 151539
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30068661/thumbnail-25e7a41f36ca6d46d0821cb854e31604.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13595776"
"ResourceRecordKey" => "30068661"
"ModificationTimestamp" => "2026-07-23T00:58:53.88Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30068661_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30068661/47677db7fcf2caab7f3f8597c498c003.webp"
"MediaSize" => 151413
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30068661/thumbnail-47677db7fcf2caab7f3f8597c498c003.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13595776"
"ResourceRecordKey" => "30068661"
"ModificationTimestamp" => "2026-07-23T00:58:53.88Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30068661_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30068661/2ea4a3857c6340190f3f8d5b9ca1e002.webp"
"MediaSize" => 136284
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30068661/thumbnail-2ea4a3857c6340190f3f8d5b9ca1e002.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13595776"
"ResourceRecordKey" => "30068661"
"ModificationTimestamp" => "2026-07-23T00:58:53.88Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30068661_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30068661/ccc1b91bded16e640e42f549e1ec04cf.webp"
"MediaSize" => 153488
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30068661/thumbnail-ccc1b91bded16e640e42f549e1ec04cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13595776"
"ResourceRecordKey" => "30068661"
"ModificationTimestamp" => "2026-07-23T00:58:53.88Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30068661_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30068661/512a000d48e65b9c97e76b9882e344d7.webp"
"MediaSize" => 150862
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30068661/thumbnail-512a000d48e65b9c97e76b9882e344d7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13595776"
"ResourceRecordKey" => "30068661"
"ModificationTimestamp" => "2026-07-23T00:58:53.88Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30068661_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30068661/72103c7a6a2833a791cc7418173e98f9.webp"
"MediaSize" => 109033
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30068661/thumbnail-72103c7a6a2833a791cc7418173e98f9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13595776"
"ResourceRecordKey" => "30068661"
"ModificationTimestamp" => "2026-07-23T00:58:53.88Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30068661_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30068661/4fd074818987d6096f1f0c947a4e787b.webp"
"MediaSize" => 206745
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30068661/thumbnail-4fd074818987d6096f1f0c947a4e787b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13595776"
"ResourceRecordKey" => "30068661"
"ModificationTimestamp" => "2026-07-23T00:58:53.88Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30068661_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30068661/379e72ec967e910990fe9a364527d520.webp"
"MediaSize" => 158308
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30068661/thumbnail-379e72ec967e910990fe9a364527d520.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13595776"
"ResourceRecordKey" => "30068661"
"ModificationTimestamp" => "2026-07-23T00:58:53.88Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30068661_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30068661/44f5a2cc5ca750e6be147bd04c4eb490.webp"
"MediaSize" => 109896
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30068661/thumbnail-44f5a2cc5ca750e6be147bd04c4eb490.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13595776"
"ResourceRecordKey" => "30068661"
"ModificationTimestamp" => "2026-07-23T00:58:53.88Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30068661_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30068661/492232b8cfb985c8cd009c06c4735964.webp"
"MediaSize" => 140991
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30068661/thumbnail-492232b8cfb985c8cd009c06c4735964.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13595776"
"ResourceRecordKey" => "30068661"
"ModificationTimestamp" => "2026-07-23T00:58:53.88Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30068661_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30068661/66090e0e7988bfe2b1d5f25a1e6d21ab.webp"
"MediaSize" => 108086
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30068661/thumbnail-66090e0e7988bfe2b1d5f25a1e6d21ab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13595776"
"ResourceRecordKey" => "30068661"
"ModificationTimestamp" => "2026-07-23T00:58:53.88Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "30068661_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30068661/e43692f697f314393447fdb286140645.webp"
"MediaSize" => 132340
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30068661/thumbnail-e43692f697f314393447fdb286140645.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13595776"
"ResourceRecordKey" => "30068661"
"ModificationTimestamp" => "2026-07-23T00:58:53.88Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "30068661_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30068661/21cddd145d506e0b0b92d47066e83ae4.webp"
"MediaSize" => 110051
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30068661/thumbnail-21cddd145d506e0b0b92d47066e83ae4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13595776"
"ResourceRecordKey" => "30068661"
"ModificationTimestamp" => "2026-07-23T00:58:53.88Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "30068661_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30068661/d7b4527e1cb11009e8817fbfa84a668b.webp"
"MediaSize" => 132935
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30068661/thumbnail-d7b4527e1cb11009e8817fbfa84a668b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13595776"
"ResourceRecordKey" => "30068661"
"ModificationTimestamp" => "2026-07-23T00:58:53.88Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "30068661_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30068661/705aae87654310c9169dfdda47bcd948.webp"
"MediaSize" => 121650
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30068661/thumbnail-705aae87654310c9169dfdda47bcd948.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13595776"
"ResourceRecordKey" => "30068661"
"ModificationTimestamp" => "2026-07-23T00:58:53.88Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "30068661_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30068661/4d301436fb5c033aef8fc52a0305bf1b.webp"
"MediaSize" => 111962
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30068661/thumbnail-4d301436fb5c033aef8fc52a0305bf1b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13595776"
"ResourceRecordKey" => "30068661"
"ModificationTimestamp" => "2026-07-23T00:58:53.88Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "30068661_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30068661/1d453ec28e05b7581c7d57e17bc5c83f.webp"
"MediaSize" => 97485
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30068661/thumbnail-1d453ec28e05b7581c7d57e17bc5c83f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13595776"
"ResourceRecordKey" => "30068661"
"ModificationTimestamp" => "2026-07-23T00:58:53.88Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "30068661_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30068661/69a7718dea676c06751b44c25523e48c.webp"
"MediaSize" => 122826
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30068661/thumbnail-69a7718dea676c06751b44c25523e48c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13595776"
"ResourceRecordKey" => "30068661"
"ModificationTimestamp" => "2026-07-23T00:58:53.88Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "30068661_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30068661/052a4a5b01a5c5280a8e76b9de7f8301.webp"
"MediaSize" => 132779
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30068661/thumbnail-052a4a5b01a5c5280a8e76b9de7f8301.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13595776"
"ResourceRecordKey" => "30068661"
"ModificationTimestamp" => "2026-07-23T00:58:53.88Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "30068661_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30068661/749ae19d2fce9472776161b98bf9ff98.webp"
"MediaSize" => 165103
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30068661/thumbnail-749ae19d2fce9472776161b98bf9ff98.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13595776"
"ResourceRecordKey" => "30068661"
"ModificationTimestamp" => "2026-07-23T00:58:53.88Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "30068661_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30068661/11696e617751c4b0ed685519309130c0.webp"
"MediaSize" => 121457
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30068661/thumbnail-11696e617751c4b0ed685519309130c0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13595776"
"ResourceRecordKey" => "30068661"
"ModificationTimestamp" => "2026-07-23T00:58:53.88Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "30068661_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30068661/22c032680f747d1bdf4a0e76e9144712.webp"
"MediaSize" => 127278
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30068661/thumbnail-22c032680f747d1bdf4a0e76e9144712.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13595776"
"ResourceRecordKey" => "30068661"
"ModificationTimestamp" => "2026-07-23T00:58:53.88Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "30068661_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30068661/6093f0504ebbda1b2d5ed44be29d94f3.webp"
"MediaSize" => 352915
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30068661/thumbnail-6093f0504ebbda1b2d5ed44be29d94f3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13595776"
"ResourceRecordKey" => "30068661"
"ModificationTimestamp" => "2026-07-23T00:58:53.88Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "30068661_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30068661/667fab4b3961ffe4fb01f0916401dcb2.webp"
"MediaSize" => 319860
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30068661/thumbnail-667fab4b3961ffe4fb01f0916401dcb2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13595776"
"ResourceRecordKey" => "30068661"
"ModificationTimestamp" => "2026-07-23T00:58:53.88Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "30068661_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30068661/4999047fb2d82f7b74465b6a69e3a829.webp"
"MediaSize" => 322672
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30068661/thumbnail-4999047fb2d82f7b74465b6a69e3a829.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13595776"
"ResourceRecordKey" => "30068661"
"ModificationTimestamp" => "2026-07-23T00:58:53.88Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "30068661_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30068661/4bcebba51e9733351e44935910dd0c33.webp"
"MediaSize" => 312128
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30068661/thumbnail-4bcebba51e9733351e44935910dd0c33.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13595776"
"ResourceRecordKey" => "30068661"
"ModificationTimestamp" => "2026-07-23T00:58:53.88Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "30068661_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30068661/5417ef0402e7e08632b7838b2970e960.webp"
"MediaSize" => 325859
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30068661/thumbnail-5417ef0402e7e08632b7838b2970e960.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13595776"
"ResourceRecordKey" => "30068661"
"ModificationTimestamp" => "2026-07-23T00:58:53.88Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "30068661_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30068661/19173b05f7faf07896b2cc04ba9089c3.webp"
"MediaSize" => 332242
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30068661/thumbnail-19173b05f7faf07896b2cc04ba9089c3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13595776"
"ResourceRecordKey" => "30068661"
"ModificationTimestamp" => "2026-07-23T00:58:53.88Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "30068661_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30068661/5fd05fc305195b257277b42c25872f35.webp"
"MediaSize" => 365816
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30068661/thumbnail-5fd05fc305195b257277b42c25872f35.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13595776"
"ResourceRecordKey" => "30068661"
"ModificationTimestamp" => "2026-07-23T00:58:53.88Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "30068661_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30068661/32d3cce32ce4bf06d2b06ec2d9b99208.webp"
"MediaSize" => 291363
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30068661/thumbnail-32d3cce32ce4bf06d2b06ec2d9b99208.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13595776"
"ResourceRecordKey" => "30068661"
"ModificationTimestamp" => "2026-07-23T00:58:53.88Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "30068661_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30068661/d6bed95ad92f544a59d0c23c0fcfdd26.webp"
"MediaSize" => 357056
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30068661/thumbnail-d6bed95ad92f544a59d0c23c0fcfdd26.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13595776"
"ResourceRecordKey" => "30068661"
"ModificationTimestamp" => "2026-07-23T00:58:53.88Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "30068661_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30068661/a72df3e843f6c183f90962243f9036ff.webp"
"MediaSize" => 318987
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30068661/thumbnail-a72df3e843f6c183f90962243f9036ff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13595776"
"ResourceRecordKey" => "30068661"
"ModificationTimestamp" => "2026-07-23T00:58:53.88Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "30068661_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30068661/e7fb11d5eeca782a267927d896e34a79.webp"
"MediaSize" => 292736
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30068661/thumbnail-e7fb11d5eeca782a267927d896e34a79.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13595776"
"ResourceRecordKey" => "30068661"
"ModificationTimestamp" => "2026-07-23T00:58:53.88Z"
]
44 => array:13 [
"Order" => 45
"MediaKey" => "30068661_4890_45"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30068661/4f685bdd331cd6724ccf5e16126025a7.webp"
"MediaSize" => 287071
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30068661/thumbnail-4f685bdd331cd6724ccf5e16126025a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13595776"
"ResourceRecordKey" => "30068661"
"ModificationTimestamp" => "2026-07-23T00:58:53.88Z"
]
45 => array:13 [
"Order" => 46
"MediaKey" => "30068661_4890_46"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30068661/3ab59bffeba9d3c8fc13b581bf134542.webp"
"MediaSize" => 284439
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30068661/thumbnail-3ab59bffeba9d3c8fc13b581bf134542.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13595776"
"ResourceRecordKey" => "30068661"
"ModificationTimestamp" => "2026-07-23T00:58:53.88Z"
]
46 => array:13 [
"Order" => 47
"MediaKey" => "30068661_4890_47"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30068661/e86aeca818f94d60bc8783a4bf626261.webp"
"MediaSize" => 318893
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30068661/thumbnail-e86aeca818f94d60bc8783a4bf626261.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13595776"
"ResourceRecordKey" => "30068661"
"ModificationTimestamp" => "2026-07-23T00:58:53.88Z"
]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30068661')"
+"ID": "1650965"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.18 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 275615" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25041
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24984
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "Trilliumwest Real Estate Brokerage"
+"OfficeEmail": null
+"OfficePhone": "226-314-1600"
+"OfficeMlsId": "561000"
+"ModificationTimestamp": "2026-04-22T08:10:00Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "275615"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "292 STONE ROAD WEST UNIT 7"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "GUELPH"
+"OfficePostalCode": "N1G3C"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "OnePoint"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1266850"
+"OriginalEntryTimestamp": "2014-10-08T04:29:00Z"
+"OfficeFax": "226-314-1592"
+"OfficeAORKey": "47"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "262505"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "275615"
"SocialMediaUrlOrId" => "http://www.trilliumwest.com/"
"ModificationTimestamp" => "2026-04-22T05:27:00Z"
]
]
+"OfficeBrokerNationalAssociationId": "1425693"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('275615')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2127309" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25064
+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 '30068661'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25374
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '30068661' AND OpenHouseDate ge '2026-07-23'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25390
+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 '30068661' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.583029 43.472566)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25463
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25457
+post_id: "1654553"
+post_author: 1
+"ListingKey": "30073974"
+"ListingId": "X13600694"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-24T03:40:01Z"
+"RFModificationTimestamp": "2026-07-24T04:37:45Z"
+"ListPrice": 990000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2W4"
+"UnparsedAddress": "735 KARLSFELD ROAD, Waterloo, Ontario N2T2W4"
+"Coordinates": array:2 [
0 => -80.57791
1 => 43.456617
]
+"Latitude": 43.456617
+"Longitude": -80.57791
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Nestled in the heart of Clair Hills, this bright and spacious home offers the perfect blend ofcomfort, nature, and community. Located just steps from scenic walking trails and a charmingneighbourhood park, the area is known for a very friendly, respectful atmosphere and top-ratedschools.This well-designed two-story home features an open-concept layout with 4 bedrooms, 3 bathrooms,and a 2-car garage plus a double driveway accommodating up to 4 vehicles.The main floor is ideal for both everyday living and entertaining. A generous living and diningarea flows seamlessly into a warm and inviting family room with large windows and a cozy gasfireplace. The kitchen offers ample cabinetry, an open connection to the family room, and apleasant view right from the kitchen sink window.Step outside to enjoy a southwest-facing deck overlooking the open area - perfect for relaxingevenings and sunsets.Upstairs, you'll find four spacious bedrooms, each with a good size closets. The primary suite features abundant natural light, a walk-in closet, and a private ensuite bathroom complete with a tub, separate shower, and oversized vanity.Unfinished basement has big windows and walk-in backyard entry, good for storage or as a fitness equipment room.Conveniently located just minutes from major amenities including Costco and T&T Supermarket, as well as top institutions such as University of Waterloo and Wilfrid Laurier University.This home is ideal for families seeking space, comfort, and a peaceful, nature-connected lifestyle. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Garage door opener"
]
+"Basement": array:4 [
0 => "Unfinished"
1 => "Walk out"
2 => "N/A"
3 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-24T04:37:35.038256+00:00"
+"Directions": "Cross Streets: Keats Way and Erbsville Rd. ** Directions: Erbsville Rd to Keats Way to Karlsfeld Rd."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"Flooring": array:2 [
0 => "Tile"
1 => "Carpeted"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1623242"
+"ListOfficeKey": "300429"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "34 x 128 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-24T03:32:27Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-24T03:32:27Z"
+"Stories": "2.0"
+"StreetName": "Karlsfeld"
+"StreetNumber": "735"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "6359.23"
+"VirtualTourURLUnbranded": "https://view.tours4listings.com/cp/735-karlsfeld-road-waterloo/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1692223062"
"RoomType" => "Living room"
"ListingId" => "X13600694"
"RoomLevel" => "Main level"
"RoomWidth" => 3.81
"ListingKey" => "30073974"
"RoomLength" => 5.28
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T03:32:27.74Z"
]
1 => array:11 [
"RoomKey" => "1692223063"
"RoomType" => "Laundry room"
"ListingId" => "X13600694"
"RoomLevel" => "Basement"
"RoomWidth" => 0.0
"ListingKey" => "30073974"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T03:32:27.74Z"
]
2 => array:11 [
"RoomKey" => "1692223064"
"RoomType" => "Dining room"
"ListingId" => "X13600694"
"RoomLevel" => "Main level"
"RoomWidth" => 3.81
"ListingKey" => "30073974"
"RoomLength" => 5.28
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T03:32:27.74Z"
]
3 => array:11 [
"RoomKey" => "1692223065"
"RoomType" => "Family room"
"ListingId" => "X13600694"
"RoomLevel" => "Main level"
"RoomWidth" => 4.11
"ListingKey" => "30073974"
"RoomLength" => 5.24
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T03:32:27.74Z"
]
4 => array:11 [
"RoomKey" => "1692223066"
"RoomType" => "Kitchen"
"ListingId" => "X13600694"
"RoomLevel" => "Main level"
"RoomWidth" => 3.33
"ListingKey" => "30073974"
"RoomLength" => 3.84
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T03:32:27.74Z"
]
5 => array:11 [
"RoomKey" => "1692223067"
"RoomType" => "Bedroom"
"ListingId" => "X13600694"
"RoomLevel" => "Second level"
"RoomWidth" => 4.52
"ListingKey" => "30073974"
"RoomLength" => 5.89
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T03:32:27.74Z"
]
6 => array:11 [
"RoomKey" => "1692223068"
"RoomType" => "Bedroom 2"
"ListingId" => "X13600694"
"RoomLevel" => "Second level"
"RoomWidth" => 2.87
"ListingKey" => "30073974"
"RoomLength" => 3.91
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T03:32:27.74Z"
]
7 => array:11 [
"RoomKey" => "1692223069"
"RoomType" => "Bedroom 3"
"ListingId" => "X13600694"
"RoomLevel" => "Second level"
"RoomWidth" => 2.84
"ListingKey" => "30073974"
"RoomLength" => 3.94
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T03:32:27.75Z"
]
8 => array:11 [
"RoomKey" => "1692223070"
"RoomType" => "Bedroom 4"
"ListingId" => "X13600694"
"RoomLevel" => "Second level"
"RoomWidth" => 3.35
"ListingKey" => "30073974"
"RoomLength" => 3.78
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T03:32:27.75Z"
]
9 => array:11 [
"RoomKey" => "1692223071"
"RoomType" => "Bathroom"
"ListingId" => "X13600694"
"RoomLevel" => "Second level"
"RoomWidth" => 0.0
"ListingKey" => "30073974"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T03:32:27.75Z"
]
10 => array:11 [
"RoomKey" => "1692223072"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13600694"
"RoomLevel" => "Basement"
"RoomWidth" => 0.0
"ListingKey" => "30073974"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T03:32:27.75Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30073974/735-karlsfeld-road-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 34.0
+"OriginalEntryTimestamp": "2026-07-24T03:32:27.72Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1160967"
+"ListOfficeNationalAssociationId": "1487853"
+"Media": array:47 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30073974_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073974/4336044a1c92aaa36dbea58d7be186c3.webp"
"MediaSize" => 599059
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073974/thumbnail-4336044a1c92aaa36dbea58d7be186c3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13600694"
"ResourceRecordKey" => "30073974"
"ModificationTimestamp" => "2026-07-24T03:32:27.72Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30073974_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073974/c14e54afbc9bcd3e394ce3f894ed151b.webp"
"MediaSize" => 375022
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073974/thumbnail-c14e54afbc9bcd3e394ce3f894ed151b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600694"
"ResourceRecordKey" => "30073974"
"ModificationTimestamp" => "2026-07-24T03:32:27.72Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30073974_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073974/34c9406a351f1ac730ef4867a7ea73c7.webp"
"MediaSize" => 162392
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073974/thumbnail-34c9406a351f1ac730ef4867a7ea73c7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600694"
"ResourceRecordKey" => "30073974"
"ModificationTimestamp" => "2026-07-24T03:32:27.72Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30073974_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073974/0b85526263283391fa76117a81884e69.webp"
"MediaSize" => 104567
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073974/thumbnail-0b85526263283391fa76117a81884e69.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600694"
"ResourceRecordKey" => "30073974"
"ModificationTimestamp" => "2026-07-24T03:32:27.72Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30073974_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073974/841f9aa50155d06ba8a106d58c5b0075.webp"
"MediaSize" => 173970
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073974/thumbnail-841f9aa50155d06ba8a106d58c5b0075.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600694"
"ResourceRecordKey" => "30073974"
"ModificationTimestamp" => "2026-07-24T03:32:27.72Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30073974_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073974/bdcc5502309fd2bbdf89d75143181ec2.webp"
"MediaSize" => 152612
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073974/thumbnail-bdcc5502309fd2bbdf89d75143181ec2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600694"
"ResourceRecordKey" => "30073974"
"ModificationTimestamp" => "2026-07-24T03:32:27.72Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30073974_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073974/5dee4c5a188a905cd5288f986dbc032e.webp"
"MediaSize" => 176956
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073974/thumbnail-5dee4c5a188a905cd5288f986dbc032e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600694"
"ResourceRecordKey" => "30073974"
"ModificationTimestamp" => "2026-07-24T03:32:27.72Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30073974_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073974/adb4af0431bd584474ae808f64588b78.webp"
"MediaSize" => 171337
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073974/thumbnail-adb4af0431bd584474ae808f64588b78.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600694"
"ResourceRecordKey" => "30073974"
"ModificationTimestamp" => "2026-07-24T03:32:27.72Z"
]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30073974')"
+"ID": "1654553"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25459
+post_id: "1652382"
+post_author: 1
+"ListingKey": "30071321"
+"ListingId": "40849969"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-23T17:45:06Z"
+"RFModificationTimestamp": "2026-07-23T19:03:06Z"
+"ListPrice": 134900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 900.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J3Z4"
+"UnparsedAddress": "580 BEAVER CREEK Road Unit# 79, Waterloo, Ontario N2J3Z4"
+"Coordinates": array:2 [
0 => -80.5879324
1 => 43.4839118
]
+"Latitude": 43.4839118
+"Longitude": -80.5879324
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome home to 580 Beaver Creek Road, #79, tucked into the sought-after community of Green Acre Park near Laurel Creek Conservation Area in Waterloo. This bright, park model home offers 3 bedrooms and 1 bathroom, conveniently located just minutes from St. Jacobs and everyday conveniences. Picture quiet evenings on the covered front deck, string lights glowing overhead, just steps from the pool and the crackle of your own backyard fire pit beneath a canopy of mature trees. Step inside through the double glass doors and feel right at home in the bright, open-concept living space, where vaulted pine ceilings and generous windows fill every room with natural light. The living room invites you to curl up and relax, while the spacious kitchen, complete with a peninsula and room for a full dining table, is made for lazy morning coffees and easy weeknight dinners with family and friends. Three nice-sized bedrooms offer a peaceful retreat at the end of the day, and the bright, 3-piece bathroom rounds out a layout that feels larger than it looks. In-suite laundry keeps everyday life simple, so you can spend your days relaxing instead of running errands. Plenty of storage space throughout. Green Acre Park is where summer memories are made. Take a dip in the heated outdoor pool, soak in the hot tub, challenge the family to a round of mini golf, or cast a line at the catch-and-release pond. Wander the landscaped grounds, cross the covered bridge, or simply relax by the fire pit and watch the sun set over the countryside. This is a place where life slows down, the neighbours feel like family, and every season brings a new reason to fall in love with your home away from home. Enjoy 10-month seasonal living (park closed January and February) surrounded by mature trees and peaceful, well-kept grounds. Park approval required for all purchasers. Come see this property for yourself and book your showing today. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Window Coverings"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-23T19:02:56.281333+00:00"
+"Directions": "Westmount Road N to Conservation Drive to Beaver Creek Road"
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"Heating": array:1 [
0 => "Propane"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1900576"
+"ListOfficeKey": "76826"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"PhotosChangeTimestamp": "2026-07-23T17:42:23Z"
+"PhotosCount": 30
+"PoolFeatures": array:1 [
0 => "Pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-23T17:42:23Z"
+"Stories": "1.0"
+"StreetName": "BEAVER CREEK"
+"StreetNumber": "580"
+"StreetSuffix": "Road"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"VirtualTourURLUnbranded": "https://iguidephotos.com/79_580_beaver_creek_rd_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30071321/580-beaver-creek-road-unit-79-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Mobile Home"
]
+"CommonInterest": "Leasehold"
+"GeocodeManualYN": true
+"ZoningDescription": "FD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 900
+"OriginalEntryTimestamp": "2026-07-23T17:38:24.96Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1217074"
+"ListOfficeNationalAssociationId": "1004387"
+"Media": array:30 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30071321')"
+"ID": "1652382"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25456
+post_id: "1652383"
+post_author: 1
+"ListingKey": "30071331"
+"ListingId": "X13598432"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-23T17:45:06Z"
+"RFModificationTimestamp": "2026-07-23T19:03:00Z"
+"ListPrice": 899900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 7.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2V1"
+"UnparsedAddress": "519 YORKSHIRE DRIVE, Waterloo, Ontario N2T2V1"
+"Coordinates": array:2 [
0 => -80.572799
1 => 43.457509
]
+"Latitude": 43.457509
+"Longitude": -80.572799
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "RemarksPublic Remarks: Welcome to 519 Yorkshire Drive, Waterloo: Luxury Living in Prestigious Upper Beechwood! A beautifully updated detached 2-storey home, Nestled on a mature, tree-lined street in Upper Beechwood offers outstanding curb appeal with lush landscaping and parking for 4 vehicles (2 in oversized 13.5 ft high garage, 2 on concrete driveway. Step inside through a Grand porch to welcoming foyer leading to a thoughtfully renovated interior featuring updated flooring and pot lights throughout. The spacious living room is warm, airy and very bright. A rare main-floor bedroom offers incredible flexibility. The inviting family room creates the perfect setting for relaxing evenings, game nights or movie nights. The beautifully updated kitchen is fully equipped with stainless steel appliances, granite countertops, a chic tile backsplash and ample cabinetry. Adjacent is the spacious dining area, perfect for hosting dinner parties or creating lasting memories. A spacious Laundry room with ample storage and a convenient 2pc powder room completes the main level. Upstairs there are 4 generous bedrooms and 2 full bathrooms. The primary suite includes a walk-in closet and a luxurious ensuite with a Jacuzzi tub. Most windows in this house have been replaced. The fully finished basement adds exceptional living space with 2 additional bedrooms, 3pc bathroom and huge Rec area with kitchenette setup. Step outside to fully fenced backyard, featuring a spacious patio and charming gazebo, perfect for summer BBQs, entertaining or simply relaxing. Additional updates: Furnace and AC (2025) and a new water heater (2026). Located minutes from top-rated schools, University of Waterloo and Wilfrid Laurier, The Boardwalk Plaza, Costco, parks, Trails, public transit, restaurants and healthcare facilities, this location has it all. Offering 7 bedrooms, 4 bathrooms, this beautifully upgraded home is a rare opportunity, Book your private showing today and make it your forever home. (id:62650)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Freezer"
8 => "Window Coverings"
9 => "Garage door opener"
10 => "Garage door opener remote(s)"
11 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-23T19:02:42.717889+00:00"
+"Directions": "Cross Streets: Erbsville Rd/ Keatsway. ** Directions: Erbsville Road to Keatsway."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2130557"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "47.9 x 102 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-23T17:39:27Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-23T17:39:27Z"
+"Stories": "2.0"
+"StreetName": "Yorkshire"
+"StreetNumber": "519"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "6960"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/6d9ag_519_yorkshire_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30071331/519-yorkshire-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "Residential"
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 47.1
+"OriginalEntryTimestamp": "2026-07-23T17:39:27.54Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1389915"
+"ListOfficeNationalAssociationId": "1369645"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30071331')"
+"ID": "1652383"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25460
+post_id: "1652258"
+post_author: 1
+"ListingKey": "30070302"
+"ListingId": "40849801"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-23T15:45:05Z"
+"RFModificationTimestamp": "2026-07-23T16:58:27Z"
+"ListPrice": 899900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 7.0
+"LotSizeArea": 0
+"LivingArea": 3733.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2V1"
+"UnparsedAddress": "519 YORKSHIRE Drive, Waterloo, Ontario N2T2V1"
+"Coordinates": array:2 [
0 => -80.5727819
1 => 43.4575227
]
+"Latitude": 43.4575227
+"Longitude": -80.5727819
+"YearBuilt": 2001
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 519 Yorkshire Drive, Waterloo: Luxury Living in Prestigious Upper Beechwood! A beautifully updated detached 2-storey home, Nestled on a mature, tree-lined street in Upper Beechwood offers outstanding curb appeal with lush landscaping and parking for 4 vehicles (2 in oversized 13.5 ft high garage, 2 on concrete driveway. Step inside through a Grand porch to welcoming foyer leading to a thoughtfully renovated interior featuring updated flooring and pot lights throughout. The spacious living room is warm, airy and very bright. A rare main-floor bedroom offers incredible flexibility. The inviting family room creates the perfect setting for relaxing evenings, game nights or movie nights. The beautifully updated kitchen is fully equipped with stainless steel appliances, granite countertops, a chic tile backsplash and ample cabinetry. Adjacent is the spacious dining area, perfect for hosting dinner parties or creating lasting memories. A spacious Laundry room with ample storage and a convenient 2pc powder room completes the main level. Upstairs there are 4 generous bedrooms and 2 full bathrooms. The primary suite includes a walk-in closet and a luxurious ensuite with a Jacuzzi tub. Most windows in this house have been replaced. The fully finished basement adds exceptional living space with 2 additional bedrooms, 3pc bathroom and huge Rec area with kitchenette setup. Step outside to fully fenced backyard, featuring a spacious patio and charming gazebo, perfect for summer BBQs, entertaining or simply relaxing. Additional updates: Furnace and AC (2025) and a new water heater (2026). Located minutes from top-rated schools, University of Waterloo and Wilfrid Laurier, The Boardwalk Plaza, Costco, parks, Trails, public transit, restaurants and healthcare facilities, this location has it all. Offering 7 bedrooms, 4 bathrooms, this beautifully upgraded home is a rare opportunity, Book your private showing today and make it your forever home. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Freezer"
8 => "Window Coverings"
9 => "Garage door opener"
]
+"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-23T16:58:13.051179+00:00"
+"Directions": "Erbsville Road to Keatsway"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564507"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Sump Pump"
1 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-23T15:38:28Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-23T15:38:28Z"
+"Stories": "2.0"
+"StreetName": "YORKSHIRE"
+"StreetNumber": "519"
+"StreetSuffix": "Drive"
+"SubdivisionName": "440 - Upper Beechwood/Beechwood W."
+"TaxAnnualAmount": "6960"
+"VirtualTourURLUnbranded": "https://youriguide.com/6d9ag_519_yorkshire_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:18 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30070302/519-yorkshire-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SR2"
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 48.0
+"AboveGradeFinishedArea": 2447
+"BelowGradeFinishedArea": 1286
+"OriginalEntryTimestamp": "2026-07-23T15:38:28.07Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1123254"
+"ListOfficeNationalAssociationId": "1380559"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30070302')"
+"ID": "1652258"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25458
+post_id: "1649189"
+post_author: 1
+"ListingKey": "30066738"
+"ListingId": "40850366"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-23T03:35:25Z"
+"RFModificationTimestamp": "2026-07-23T03:39:04Z"
+"ListPrice": 949999.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1717.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2T4"
+"UnparsedAddress": "553 BLUE BEECH Boulevard, Waterloo, Ontario N2V2T4"
+"Coordinates": array:2 [
0 => -80.5942896
1 => 43.4684464
]
+"Latitude": 43.4684464
+"Longitude": -80.5942896
+"YearBuilt": 2003
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "*** For more information, please click Brochure button. *** This unique abode backs to the most vast scenic forest trails and fronts no direct house across the street so you never have to risk an awkward encounter with a peeping neighbor, truly the most exceptional privacy. Being on high ground is also very advantageous with how much flooding is seen through the region in early spring. The sump pump has never had to work a day in its life. A second private entrance to the house leads to an incredibly spacious and finished basement, just the right amount of segregation for lending provisions to a studying/working kin or renting to generate some side income. Finally, save more utilities with the addition of a newly installed, high efficiency heat pump (2024). All in all 100% carpet free, pet free, open concept, and turnkey. (id:62650)"
+"Appliances": array:13 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Freezer"
9 => "Central Vacuum - Roughed In"
10 => "Hood Fan"
11 => "Window Coverings"
12 => "Garage door opener"
]
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-22T20:02:18.021489+00:00"
+"ExteriorFeatures": array:1 [
0 => "Aluminum siding"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2220194"
+"ListOfficeKey": "296937"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Backs on greenbelt"
1 => "Conservation/green belt"
2 => "Sump Pump"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Open"
]
+"PhotosChangeTimestamp": "2026-07-22T23:03:22Z"
+"PhotosCount": 30
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-23T03:28:31Z"
+"Stories": "2.0"
+"StreetName": "BLUE BEECH"
+"StreetNumber": "553"
+"StreetSuffix": "Boulevard"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "5141.81"
+"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/30066738/553-blue-beech-boulevard-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 1717
+"OriginalEntryTimestamp": "2026-07-22T18:38:05.84Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1464325"
+"ListOfficeNationalAssociationId": "1464303"
+"Media": array:30 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30066738')"
+"ID": "1649189"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25433
+post_id: "1647467"
+post_author: 1
+"ListingKey": "30063939"
+"ListingId": "40847904"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-24T00:35:14Z"
+"RFModificationTimestamp": "2026-07-24T00:37:01Z"
+"ListPrice": 1900000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 3282.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2S7"
+"UnparsedAddress": "543 WERNI Court, Waterloo, Ontario N2V2S7"
+"Coordinates": array:2 [
0 => -80.595895
1 => 43.4744344
]
+"Latitude": 43.4744344
+"Longitude": -80.595895
+"YearBuilt": 2013
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "A home like this rarely comes along, tucked away in the highly sought-after Laurelwood neighbourhood. Built by Milla in 2013, this one-owner custom home is professionally designed and has a traditional layout seldomly found in newer neighbourhoods. Understated elegance and classic touches abound in the thoughtfully crafted cabinetry, built-ins and millwork, exquisite glass doorknobs, flooring selections along with other top-tier finishes curated for consistency throughout. French doors from Foyer to formal Living Room, which would also serve as an ideal home office. Chef’s kitchen by Barzotti features expansive countertops, planning centre, large centre-island, gas cooktop and custom range hood, built-in wall oven, a wall of pantry storage, and more. View of the private back yard from the adjacent breakfast room. Comfortable family room boasts vaulted ceilings and stately fireplace. Even the off-the-garage mud room and discreetly placed powder room are beautifully decorated. Upstairs are four spacious bedrooms, three with walk-in closets, and two full bathrooms. Primary suite is fit for royalty with its own intimate fireplace, a 150sqft walk-in closet, 5-piece ensuite with a soaker tub, walk-in shower and separate water closet. Centrally located laundry room features ample cabinets and counter space, sink and separate closet. The storage and built-ins in this home make a busy life much easier to manage. Unspoiled basement with walk-up to the garage has loads of space for storage and future development. Beautifully-landscaped yard front to back is great for outdoor entertaining. No back yard neighbours, and walk to some of the best schools in the city. Must see in person to fully appreciate the fine details of this incredible home at 543 Werni Court. Click on multi-media link to view more photos, 3D tour and video. (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
6 => "Oven - Built-In"
7 => "Hood Fan"
8 => "Window Coverings"
9 => "Garage door opener"
10 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-22T05:44:47.947046+00:00"
+"Directions": "Laurelwood Drive to Creekside Drive to Werni Court"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1867305"
+"ListOfficeKey": "76840"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Cul-de-sac"
1 => "Conservation/green belt"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-23T01:41:31Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-24T00:29:35Z"
+"Stories": "2.0"
+"StreetName": "WERNI"
+"StreetNumber": "543"
+"StreetSuffix": "Court"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "12560"
+"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=yYUx_jNTmn0"
+"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/30063939/543-werni-court-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1950229"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "76840"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Alarm system"
]
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 55.0
+"AboveGradeFinishedArea": 3282
+"OriginalEntryTimestamp": "2026-07-22T05:28:40.91Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1203626"
+"ListOfficeNationalAssociationId": "1004363"
+"CoListAgentNationalAssociationId": "1244423"
+"CoListOfficeNationalAssociationId": "1004363"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30063939')"
+"ID": "1647467"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23542
+post_id: "1647178"
+post_author: 1
+"ListingKey": "30063527"
+"ListingId": "40850032"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-22T13:20:03Z"
+"RFModificationTimestamp": "2026-07-22T13:22:02Z"
+"ListPrice": 149999.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 920.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J3Z4"
+"UnparsedAddress": "580 BEAVER CREEK Road Unit# 14, Waterloo, Ontario N2J3Z4"
+"Coordinates": array:2 [
0 => -80.5887301
1 => 43.4849269
]
+"Latitude": 43.4849269
+"Longitude": -80.5887301
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "A little piece of paradise. 10 month occupancy in this gorgeous park. Enjoy many amenities, and beautiful tree lined streets.Unit has had a complete renovation from top to bottom...too many to list. 2 bed, 1 bath, large dining room/ kitchen, with a brand new layout/ cupboards and quartz countertops. *For Additional Property Details Click The Brochure Icon Below* (id:62650)"
+"Appliances": array:7 [
0 => "Refrigerator"
1 => "Gas stove(s)"
2 => "Range - Gas"
3 => "Dryer"
4 => "Microwave"
5 => "Hood Fan"
6 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Window air conditioner"
]
+"CreationDate": "2026-07-22T01:40:02.991461+00:00"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Metal"
]
+"FoundationDetails": array:1 [
0 => "Piled"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Propane"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2156118"
+"ListOfficeKey": "292023"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Skylight"
1 => "Laundry- Coin operated"
]
+"PhotosChangeTimestamp": "2026-07-22T13:12:35Z"
+"PhotosCount": 40
+"PoolFeatures": array:1 [
0 => "Above ground pool"
]
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-22T13:12:35Z"
+"Stories": "1.0"
+"StreetName": "BEAVER CREEK"
+"StreetNumber": "580"
+"StreetSuffix": "Road"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"Utilities": array:1 [
0 => "Cable"
]
+"VirtualTourURLUnbranded": "https://listedbyseller-listings.ca/580-beavercreek-road-site-14-waterloo-on-landing/"
+"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/30063527/580-beaver-creek-road-unit-14-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Modular"
]
+"CommonInterest": "Leasehold"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Guest Suite"
1 => "Party Room"
]
+"ZoningDescription": "R"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 0.0
+"AboveGradeFinishedArea": 920
+"OriginalEntryTimestamp": "2026-07-22T00:38:06.36Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1407631"
+"ListOfficeNationalAssociationId": "1407633"
+"Media": array:40 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30063527')"
+"ID": "1647178"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25461
+post_id: "1644767"
+post_author: 1
+"ListingKey": "30059123"
+"ListingId": "X13586984"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-21T12:45:09Z"
+"RFModificationTimestamp": "2026-07-21T13:39:30Z"
+"ListPrice": 149999.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V3Z4"
+"UnparsedAddress": "SITE 14 - 580 BEAVER CREEK ROAD, Waterloo, Ontario N2V3Z4"
+"Coordinates": array:2 [
0 => -80.586343
1 => 43.484782
]
+"Latitude": 43.484782
+"Longitude": -80.586343
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "A little piece of paradise. 10 month occupancy in this gorgeous park. Enjoy many amenities, and beautiful tree lined streets.Unit has had a complete renovation from top to bottom...too many to list. 2 bed, 1 bath, large dining room/ kitchen, with a brand new layout/ cupboards and quartz countertops. *For Additional Property Details Click The Brochure Icon Below* (id:62650)"
+"Appliances": array:1 [
0 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Wall unit"
]
+"CreationDate": "2026-07-21T13:39:22.923188+00:00"
+"Directions": "Cross Streets: Conservation Dr. ** Directions: Conservation Rd & Beaver Creek."
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Propane"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1851727"
+"ListOfficeKey": "273408"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "38 x 57 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-21T12:37:55Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-21T12:37:55Z"
+"Stories": "1.0"
+"StreetName": "Beaver Creek"
+"StreetNumber": "580"
+"StreetSuffix": "Road"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30059123/site-14-580-beaver-creek-road-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Mobile Home"
]
+"CommonInterest": "Leasehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 2
+"FrontageLengthNumeric": 38.0
+"OriginalEntryTimestamp": "2026-07-21T12:37:55Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1199331"
+"ListOfficeNationalAssociationId": "1250460"
+"Media": array:40 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30059123')"
+"ID": "1644767"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25462
+post_id: "1643223"
+post_author: 1
+"ListingKey": "30057345"
+"ListingId": "X13585508"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-20T20:50:08Z"
+"RFModificationTimestamp": "2026-07-20T23:02:02Z"
+"ListPrice": 1050000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2V9"
+"UnparsedAddress": "610 VIOLET STREET, Waterloo, Ontario N2V2V9"
+"Coordinates": array:2 [
0 => -80.598103
1 => 43.468577
]
+"Latitude": 43.468577
+"Longitude": -80.598103
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Top 7 Reasons to Love 610 Violet Street, Waterloo 1. A RARE MULTI-LEVEL SPLIT IN COLUMBIA FOREST This is not your typical two-storey. With nearly six distinct levels, this home naturally separates living, cooking, sleeping, and entertaining spaces. Situated on a corner lot in Columbia Forest and Clair Hills, you are steps from top-rated schools, parks, conservation trails, and everyday amenities along Erbsville Road. 2. COMPLETELY UPDATED AND MOVE-IN READY Brand new flooring on every level, fresh neutral paint throughout, and modern pot lighting from top to bottom. This 2,048 sq ft home has been thoughtfully refreshed so the next owner can move in and enjoy from day one. 3. 14-FOOT CEILINGS IN THE LIVING ROOM Soaring 14-foot ceilings and oversized windows fill the main living area with natural light, creating a dramatic sense of space. Beautiful hardwood floors and an elegant railing detail complete the look. 4. A KITCHEN BUILT FOR GATHERING White shaker cabinetry, quartz countertops, a centre island with storage, and stainless steel appliances make this kitchen as functional as it is beautiful. The open layout flows into the dining area and a built-in entertainment nook. 5. THREE BEDROOMS AND A PRIMARY SUITE WORTH COMING HOME TO Three well-sized bedrooms and 2.5 bathrooms across the upper levels. The primary stands out with vaulted ceilings, a stunning arched window feature, ceiling fan, and a private ensuite. 6. CORNER LOT WITH A MULTI-LEVEL DECK The corner lot offers extra curb appeal and openness. Out back, a spacious multi-level wood deck overlooks a fully fenced yard with mature landscaping, perfect for barbecues or simply unwinding. 7. MAJOR UPGRADES ALREADY DONE Metal roof, 2020 high-efficiency furnace, central air, on-demand tankless water heater, and water softener. Double-car garage with auto remotes, wide driveway with room for four vehicles, and a lower-level basement with future finishing potential. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-20T23:01:57.898846+00:00"
+"Directions": "ERBSVILLE RD."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2235642"
+"ListOfficeKey": "285286"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "44 x 98 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-20T20:40:13Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-20T20:40:12Z"
+"Stories": "2.0"
+"StreetName": "Violet"
+"StreetNumber": "610"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "5628.78"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/610_violet_st_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30057345/610-violet-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "FR50"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 44.0
+"OriginalEntryTimestamp": "2026-07-20T20:40:12.91Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1473542"
+"ListOfficeNationalAssociationId": "1349912"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30057345')"
+"ID": "1643223"
}
]
+success: true
+page_size: 9
+page_count: 10
+count: 86
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]