array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29915294 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23362
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23364
+post_id: "1538895"
+post_author: 1
+"ListingKey": "29915294"
+"ListingId": "E13455292"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T14:55:13Z"
+"RFModificationTimestamp": "2026-06-17T15:32:23Z"
+"ListPrice": 799000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Pickering (West Shore)"
+"PostalCode": "L1W2P5"
+"UnparsedAddress": "809 HILLCREST ROAD, Pickering (West Shore), Ontario L1W2P5"
+"Coordinates": array:2 [
0 => -79.108065
1 => 43.816322
]
+"Latitude": 43.816322
+"Longitude": -79.108065
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "There's a reason some homes stay in the same family for generations. Owned by the same family since 1968, this cherished home has been the backdrop to birthdays, holiday dinners, backyard gatherings, and the everyday moments that quietly become lifelong memories. Lovingly maintained throughout the years, it offers a rare opportunity to put down roots in Pickering's sought-after West Shore community. Known for its strong sense of community, proximity to the waterfront, parks, trails, schools, and convenient access to the GO Train and Highway 401, West Shore is a neighbourhood where families come to stay. Set on a generous 50 x 100-foot lot, the home offers room to grow and possibilities for the future. Sunlight pours through the large picture window in the living and dining room, creating a warm and inviting place to gather. The eat-in kitchen has served as the heart of the home for generations, while three well-sized bedrooms provide comfort and practicality for everyday living. Meticulously maintained throughout the years, the home reflects a level of pride of ownership that is increasingly uncommon. Whether you choose to enjoy its enduring character or thoughtfully make it your own over time, the foundation is already here. The finished lower level expands the living space with a large recreation room featuring a gas fireplace, an additional kitchen, bedroom, and separate entrance. Ideal for multi-generational living, extended family, guests, or future possibilities, the layout offers flexibility to suit a variety of lifestyles. Outside, the fully fenced backyard has been thoughtfully tended over the years, with fruit trees, established gardens, herbs, and plenty of green space to enjoy. It's the kind of yard that invites gardening, play, and summer evenings spent outdoors. The best homes aren't defined by how long they've stood, but by the lives lived within them. Now, it's ready to welcome its next chapter. (id:62783)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Dryer"
2 => "Two stoves"
3 => "Window Coverings"
4 => "Two Refrigerators"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:4 [
0 => "Finished"
1 => "Separate entrance"
2 => "N/A"
3 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T15:32:15.362776+00:00"
+"Directions": "Eyer and Hillcrest"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"Flooring": array:3 [
0 => "Tile"
1 => "Hardwood"
2 => "Carpeted"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1893793"
+"ListOfficeKey": "50631"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "50 x 100 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T14:49:15Z"
+"PhotosCount": 37
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T14:49:15Z"
+"Stories": "1.0"
+"StreetName": "Hillcrest"
+"StreetNumber": "809"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "6106"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [
"RoomKey" => "1661155867"
"RoomType" => "Living room"
"ListingId" => "E13455292"
"RoomLevel" => "Main level"
"RoomWidth" => 3.44
"ListingKey" => "29915294"
"RoomLength" => 4.95
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T14:49:15.66Z"
]
1 => array:11 [
"RoomKey" => "1661155868"
"RoomType" => "Dining room"
"ListingId" => "E13455292"
"RoomLevel" => "Main level"
"RoomWidth" => 2.63
"ListingKey" => "29915294"
"RoomLength" => 3.79
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T14:49:15.66Z"
]
2 => array:11 [
"RoomKey" => "1661155869"
"RoomType" => "Kitchen"
"ListingId" => "E13455292"
"RoomLevel" => "Main level"
"RoomWidth" => 3.58
"ListingKey" => "29915294"
"RoomLength" => 2.97
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T14:49:15.66Z"
]
3 => array:11 [
"RoomKey" => "1661155870"
"RoomType" => "Primary Bedroom"
"ListingId" => "E13455292"
"RoomLevel" => "Main level"
"RoomWidth" => 4.73
"ListingKey" => "29915294"
"RoomLength" => 2.96
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T14:49:15.66Z"
]
4 => array:11 [
"RoomKey" => "1661155871"
"RoomType" => "Bedroom 2"
"ListingId" => "E13455292"
"RoomLevel" => "Main level"
"RoomWidth" => 2.77
"ListingKey" => "29915294"
"RoomLength" => 3.79
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T14:49:15.66Z"
]
5 => array:11 [
"RoomKey" => "1661155872"
"RoomType" => "Bedroom 3"
"ListingId" => "E13455292"
"RoomLevel" => "Main level"
"RoomWidth" => 2.57
"ListingKey" => "29915294"
"RoomLength" => 2.68
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T14:49:15.66Z"
]
6 => array:11 [
"RoomKey" => "1661155873"
"RoomType" => "Recreational, Games room"
"ListingId" => "E13455292"
"RoomLevel" => "Basement"
"RoomWidth" => 6.19
"ListingKey" => "29915294"
"RoomLength" => 3.43
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T14:49:15.66Z"
]
7 => array:11 [
"RoomKey" => "1661155874"
"RoomType" => "Kitchen"
"ListingId" => "E13455292"
"RoomLevel" => "Basement"
"RoomWidth" => 3.92
"ListingKey" => "29915294"
"RoomLength" => 3.39
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T14:49:15.66Z"
]
8 => array:11 [
"RoomKey" => "1661155875"
"RoomType" => "Bedroom"
"ListingId" => "E13455292"
"RoomLevel" => "Basement"
"RoomWidth" => 3.99
"ListingKey" => "29915294"
"RoomLength" => 4.61
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T14:49:15.66Z"
]
9 => array:11 [
"RoomKey" => "1661155876"
"RoomType" => "Foyer"
"ListingId" => "E13455292"
"RoomLevel" => "Basement"
"RoomWidth" => 3.93
"ListingKey" => "29915294"
"RoomLength" => 3.44
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T14:49:15.66Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "West Shore"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29915294/809-hillcrest-road-pickering-west-shore-west-shore"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1766692"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "50631"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 50.0
+"OriginalEntryTimestamp": "2026-06-17T14:49:15.63Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1213139"
+"ListOfficeNationalAssociationId": "1002152"
+"CoListAgentNationalAssociationId": "1185566"
+"CoListOfficeNationalAssociationId": "1002152"
+"Media": array:37 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29915294_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915294/a4a49ec9cf7b5edcb3f0866fc815dfc7.webp"
"MediaSize" => 241756
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915294/thumbnail-a4a49ec9cf7b5edcb3f0866fc815dfc7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "E13455292"
"ResourceRecordKey" => "29915294"
"ModificationTimestamp" => "2026-06-17T14:49:15.64Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29915294_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915294/f37c9f0c5fab0cf2b25ba7a4bec21aa1.webp"
"MediaSize" => 266159
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915294/thumbnail-f37c9f0c5fab0cf2b25ba7a4bec21aa1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13455292"
"ResourceRecordKey" => "29915294"
"ModificationTimestamp" => "2026-06-17T14:49:15.64Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29915294_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915294/a5c77f1039720bbae81d3d5f835de790.webp"
"MediaSize" => 245599
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915294/thumbnail-a5c77f1039720bbae81d3d5f835de790.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13455292"
"ResourceRecordKey" => "29915294"
"ModificationTimestamp" => "2026-06-17T14:49:15.64Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29915294_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915294/f60bdc06ec2eaef05b5721abb5e891ee.webp"
"MediaSize" => 265648
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915294/thumbnail-f60bdc06ec2eaef05b5721abb5e891ee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13455292"
"ResourceRecordKey" => "29915294"
"ModificationTimestamp" => "2026-06-17T14:49:15.64Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29915294_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915294/1de0f0c9f01e8465763c71aa333d289d.webp"
"MediaSize" => 175318
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915294/thumbnail-1de0f0c9f01e8465763c71aa333d289d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13455292"
"ResourceRecordKey" => "29915294"
"ModificationTimestamp" => "2026-06-17T14:49:15.64Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29915294_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915294/845999881c5d668690b14fcd389381db.webp"
"MediaSize" => 166864
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915294/thumbnail-845999881c5d668690b14fcd389381db.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13455292"
"ResourceRecordKey" => "29915294"
"ModificationTimestamp" => "2026-06-17T14:49:15.64Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29915294_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915294/5470c3b1a5e521b466e95bbacc556363.webp"
"MediaSize" => 182522
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915294/thumbnail-5470c3b1a5e521b466e95bbacc556363.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13455292"
"ResourceRecordKey" => "29915294"
"ModificationTimestamp" => "2026-06-17T14:49:15.64Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29915294_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915294/cee9a24992e0c0a3f1c646f3dd079379.webp"
"MediaSize" => 177018
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915294/thumbnail-cee9a24992e0c0a3f1c646f3dd079379.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13455292"
"ResourceRecordKey" => "29915294"
"ModificationTimestamp" => "2026-06-17T14:49:15.64Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29915294_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915294/219d3e9b1b68350f526806bc90d29a25.webp"
"MediaSize" => 159320
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915294/thumbnail-219d3e9b1b68350f526806bc90d29a25.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13455292"
"ResourceRecordKey" => "29915294"
"ModificationTimestamp" => "2026-06-17T14:49:15.64Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29915294_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915294/b364a8942f2c732ca7d3ccdf9e415ce6.webp"
"MediaSize" => 174300
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915294/thumbnail-b364a8942f2c732ca7d3ccdf9e415ce6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13455292"
"ResourceRecordKey" => "29915294"
"ModificationTimestamp" => "2026-06-17T14:49:15.64Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29915294_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915294/5ddd30b940852a657410c89c09069b1e.webp"
"MediaSize" => 139023
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915294/thumbnail-5ddd30b940852a657410c89c09069b1e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13455292"
"ResourceRecordKey" => "29915294"
"ModificationTimestamp" => "2026-06-17T14:49:15.64Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29915294_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915294/4f642838ae6e024fa973b9e1f3117478.webp"
"MediaSize" => 173724
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915294/thumbnail-4f642838ae6e024fa973b9e1f3117478.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13455292"
"ResourceRecordKey" => "29915294"
"ModificationTimestamp" => "2026-06-17T14:49:15.64Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29915294_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915294/d2d250d8ba841661cbf64892768d9b61.webp"
"MediaSize" => 212059
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915294/thumbnail-d2d250d8ba841661cbf64892768d9b61.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13455292"
"ResourceRecordKey" => "29915294"
"ModificationTimestamp" => "2026-06-17T14:49:15.64Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29915294_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915294/2c790d7f259793d6e0edcdaef1d01512.webp"
"MediaSize" => 200147
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915294/thumbnail-2c790d7f259793d6e0edcdaef1d01512.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13455292"
"ResourceRecordKey" => "29915294"
"ModificationTimestamp" => "2026-06-17T14:49:15.64Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29915294_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915294/04d20e1fa0d58f64340cd98d56a17147.webp"
"MediaSize" => 109036
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915294/thumbnail-04d20e1fa0d58f64340cd98d56a17147.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13455292"
"ResourceRecordKey" => "29915294"
"ModificationTimestamp" => "2026-06-17T14:49:15.64Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29915294_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915294/fa2239c33587f9ee203f8dabbecebbe1.webp"
"MediaSize" => 105394
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915294/thumbnail-fa2239c33587f9ee203f8dabbecebbe1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13455292"
"ResourceRecordKey" => "29915294"
"ModificationTimestamp" => "2026-06-17T14:49:15.64Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29915294_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915294/1f378f027208d8b85bf7a57a7323e6c8.webp"
"MediaSize" => 123408
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915294/thumbnail-1f378f027208d8b85bf7a57a7323e6c8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13455292"
"ResourceRecordKey" => "29915294"
"ModificationTimestamp" => "2026-06-17T14:49:15.64Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29915294_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915294/82a764086fae36dfba54718846772098.webp"
"MediaSize" => 118735
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915294/thumbnail-82a764086fae36dfba54718846772098.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13455292"
"ResourceRecordKey" => "29915294"
"ModificationTimestamp" => "2026-06-17T14:49:15.64Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29915294_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915294/cdd603720a136f377724307444f9ec15.webp"
"MediaSize" => 116704
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915294/thumbnail-cdd603720a136f377724307444f9ec15.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13455292"
"ResourceRecordKey" => "29915294"
"ModificationTimestamp" => "2026-06-17T14:49:15.64Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29915294_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915294/70bfa15bcbfc04bf8167f44426bf8adb.webp"
"MediaSize" => 139894
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915294/thumbnail-70bfa15bcbfc04bf8167f44426bf8adb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13455292"
"ResourceRecordKey" => "29915294"
"ModificationTimestamp" => "2026-06-17T14:49:15.64Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29915294_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915294/fa580965cd9353be22691b7ec07dfdb2.webp"
"MediaSize" => 120206
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915294/thumbnail-fa580965cd9353be22691b7ec07dfdb2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13455292"
"ResourceRecordKey" => "29915294"
"ModificationTimestamp" => "2026-06-17T14:49:15.64Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29915294_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915294/48d26e3ba59eec2316e1b0f9f4a648ea.webp"
"MediaSize" => 154011
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915294/thumbnail-48d26e3ba59eec2316e1b0f9f4a648ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13455292"
"ResourceRecordKey" => "29915294"
"ModificationTimestamp" => "2026-06-17T14:49:15.64Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29915294_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915294/b20407b497642c8723848183b98af99e.webp"
"MediaSize" => 167081
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915294/thumbnail-b20407b497642c8723848183b98af99e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13455292"
"ResourceRecordKey" => "29915294"
"ModificationTimestamp" => "2026-06-17T14:49:15.64Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29915294_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915294/0218ad8d0b44c32897932348abd9936c.webp"
"MediaSize" => 186895
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915294/thumbnail-0218ad8d0b44c32897932348abd9936c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13455292"
"ResourceRecordKey" => "29915294"
"ModificationTimestamp" => "2026-06-17T14:49:15.64Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29915294_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915294/6b49e62b38319d7cb4b9a5048b22f732.webp"
"MediaSize" => 185711
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915294/thumbnail-6b49e62b38319d7cb4b9a5048b22f732.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13455292"
"ResourceRecordKey" => "29915294"
"ModificationTimestamp" => "2026-06-17T14:49:15.64Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29915294_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915294/a20d5a2c78213be85089cff3b50ceb75.webp"
"MediaSize" => 185477
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915294/thumbnail-a20d5a2c78213be85089cff3b50ceb75.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13455292"
"ResourceRecordKey" => "29915294"
"ModificationTimestamp" => "2026-06-17T14:49:15.64Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29915294_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915294/8d5dd37d2c6e06f72ebb7fef5c530fba.webp"
"MediaSize" => 176766
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915294/thumbnail-8d5dd37d2c6e06f72ebb7fef5c530fba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13455292"
"ResourceRecordKey" => "29915294"
"ModificationTimestamp" => "2026-06-17T14:49:15.64Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29915294_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915294/414b3c029d6496244087743e5b8f5e62.webp"
"MediaSize" => 98155
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915294/thumbnail-414b3c029d6496244087743e5b8f5e62.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13455292"
"ResourceRecordKey" => "29915294"
"ModificationTimestamp" => "2026-06-17T14:49:15.64Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29915294_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915294/dfc275bc07a89a3aca5990497b0498ba.webp"
"MediaSize" => 114818
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915294/thumbnail-dfc275bc07a89a3aca5990497b0498ba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13455292"
"ResourceRecordKey" => "29915294"
"ModificationTimestamp" => "2026-06-17T14:49:15.64Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29915294_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915294/f831332ff5f36233628180d9a81b744e.webp"
"MediaSize" => 138014
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915294/thumbnail-f831332ff5f36233628180d9a81b744e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13455292"
"ResourceRecordKey" => "29915294"
"ModificationTimestamp" => "2026-06-17T14:49:15.64Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29915294_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915294/1e389aeb20b33953d174f3568ffc0fc9.webp"
"MediaSize" => 132758
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915294/thumbnail-1e389aeb20b33953d174f3568ffc0fc9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13455292"
"ResourceRecordKey" => "29915294"
"ModificationTimestamp" => "2026-06-17T14:49:15.64Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29915294_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915294/e2ad9b15f0ce3c0fc4b892febe1222be.webp"
"MediaSize" => 156967
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915294/thumbnail-e2ad9b15f0ce3c0fc4b892febe1222be.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13455292"
"ResourceRecordKey" => "29915294"
"ModificationTimestamp" => "2026-06-17T14:49:15.64Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29915294_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915294/a021a0ea31265d1e48c8395ceb4ab333.webp"
"MediaSize" => 278202
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915294/thumbnail-a021a0ea31265d1e48c8395ceb4ab333.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13455292"
"ResourceRecordKey" => "29915294"
"ModificationTimestamp" => "2026-06-17T14:49:15.64Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29915294_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915294/bbc34b638889b788bfade42bdda0a51c.webp"
"MediaSize" => 262722
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915294/thumbnail-bbc34b638889b788bfade42bdda0a51c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13455292"
"ResourceRecordKey" => "29915294"
"ModificationTimestamp" => "2026-06-17T14:49:15.64Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29915294_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915294/95a8ef454063696ad5fcfce13a18d6c2.webp"
"MediaSize" => 276582
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915294/thumbnail-95a8ef454063696ad5fcfce13a18d6c2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13455292"
"ResourceRecordKey" => "29915294"
"ModificationTimestamp" => "2026-06-17T14:49:15.64Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29915294_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915294/eefd6c351e44a18d1007071033bb2fdc.webp"
"MediaSize" => 284187
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915294/thumbnail-eefd6c351e44a18d1007071033bb2fdc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13455292"
"ResourceRecordKey" => "29915294"
"ModificationTimestamp" => "2026-06-17T14:49:15.64Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29915294_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915294/a5fe56fcaf250d44b2bb86182489de49.webp"
"MediaSize" => 279213
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915294/thumbnail-a5fe56fcaf250d44b2bb86182489de49.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13455292"
"ResourceRecordKey" => "29915294"
"ModificationTimestamp" => "2026-06-17T14:49:15.64Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29915294')"
+"ID": "1538895"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 50631" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24771
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1893793" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24856
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29915294'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25170
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29915294'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25186
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29915294' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.108065 43.816322)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25258
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25233
+post_id: "1540581"
+post_author: 1
+"ListingKey": "29918411"
+"ListingId": "E13458158"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T20:50:10Z"
+"RFModificationTimestamp": "2026-06-17T21:10:55Z"
+"ListPrice": 1495000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Pickering (Bay Ridges)"
+"PostalCode": "L1W1M7"
+"UnparsedAddress": "819 FAIRVIEW AVENUE, Pickering (Bay Ridges), Ontario L1W1M7"
+"Coordinates": array:2 [
0 => -79.088204
1 => 43.820753
]
+"Latitude": 43.820753
+"Longitude": -79.088204
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "A must see! With panoramic views of Frenchman's Bay, a private rooftop terrace, and a 4-stop elevator connecting all levels, this custom-built detached home offers a turn-key lifestyle unlike anything else currently available in Pickering! Designed with multigenerational living in mind, this exceptional residence features thoughtfully crafted living space, soaring 9-ft ceilings, white oak hardwood flooring, multiple fireplaces, and spectacular water views from multiple levels. The chef's kitchen is the heart of the home, complete with quartz countertops, custom cabinetry, a large centre island, walk-in pantry, beverage fridge, and multiple entertaining spaces. Open-concept living and dining areas flow seamlessly to the backyard through oversized sliding glass doors. Retreat to the luxurious primary suite featuring vaulted ceilings, a fireplace, spa-inspired ensuite with heated floors and soaker tub. The showpiece rooftop terrace offers approximately 450 sq. ft. of outdoor living space with a fireplace, covered TV lounge, gas BBQ hookup, and unforgettable sunset views of Frenchman's Bay. The versatile walkout lower level includes a full bathroom and flexible space ideal for a fourth bedroom, in-law suite, gym, office, or recreation room. Just steps from the waterfront, Nautical Village, Beachfront Park, Millennium Square, restaurants, shops, Pickering GO Station, and Highway 401. (id:62650)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Alarm System"
7 => "Hood Fan"
8 => "Blinds"
9 => "Window Coverings"
10 => "Water Heater - Tankless"
11 => "Water Heater"
]
+"Basement": array:3 [
0 => "Finished"
1 => "Walk out"
2 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T21:10:49.076609+00:00"
+"Directions": "Cross Streets: Liverpool & Bayly St. ** Directions: South on Douglas Ave, West on Fairview Avenue."
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"Fencing": array:2 [
0 => "Fenced yard"
1 => "Fully Fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "4"
+"Flooring": array:1 [
0 => "Hardwood"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2132995"
+"ListOfficeKey": "68202"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Lighting"
1 => "Carpet Free"
2 => "Sump Pump"
]
+"LotSizeDimensions": "25 x 127.3 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T20:41:13Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T20:41:13Z"
+"Stories": "3.0"
+"StreetName": "Fairview"
+"StreetNumber": "819"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "9146"
+"View": "Lake view,View,View of water"
+"VirtualTourURLUnbranded": "https://www.819fairviewave.com/unbranded"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1661470495"
"RoomType" => "Dining room"
"ListingId" => "E13458158"
"RoomLevel" => "Main level"
"RoomWidth" => 5.95
"ListingKey" => "29918411"
"RoomLength" => 3.56
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T20:41:13.33Z"
]
1 => array:11 [
"RoomKey" => "1661470496"
"RoomType" => "Kitchen"
"ListingId" => "E13458158"
"RoomLevel" => "Main level"
"RoomWidth" => 6.0
"ListingKey" => "29918411"
"RoomLength" => 5.28
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T20:41:13.33Z"
]
2 => array:11 [
"RoomKey" => "1661470497"
"RoomType" => "Living room"
"ListingId" => "E13458158"
"RoomLevel" => "Main level"
"RoomWidth" => 4.98
"ListingKey" => "29918411"
"RoomLength" => 5.27
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T20:41:13.34Z"
]
3 => array:11 [
"RoomKey" => "1661470498"
"RoomType" => "Primary Bedroom"
"ListingId" => "E13458158"
"RoomLevel" => "Second level"
"RoomWidth" => 6.07
"ListingKey" => "29918411"
"RoomLength" => 4.64
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T20:41:13.34Z"
]
4 => array:11 [
"RoomKey" => "1661470499"
"RoomType" => "Bedroom 2"
"ListingId" => "E13458158"
"RoomLevel" => "Second level"
"RoomWidth" => 3.26
"ListingKey" => "29918411"
"RoomLength" => 2.86
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T20:41:13.34Z"
]
5 => array:11 [
"RoomKey" => "1661470500"
"RoomType" => "Bedroom 3"
"ListingId" => "E13458158"
"RoomLevel" => "Second level"
"RoomWidth" => 3.66
"ListingKey" => "29918411"
"RoomLength" => 3.16
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T20:41:13.34Z"
]
6 => array:11 [
"RoomKey" => "1661470501"
"RoomType" => "Laundry room"
"ListingId" => "E13458158"
"RoomLevel" => "Second level"
"RoomWidth" => 1.78
"ListingKey" => "29918411"
"RoomLength" => 0.85
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T20:41:13.34Z"
]
7 => array:11 [
"RoomKey" => "1661470502"
"RoomType" => "Bedroom 4"
"ListingId" => "E13458158"
"RoomLevel" => "Basement"
"RoomWidth" => 3.56
"ListingKey" => "29918411"
"RoomLength" => 5.05
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T20:41:13.34Z"
]
8 => array:11 [
"RoomKey" => "1661470503"
"RoomType" => "Utility room"
"ListingId" => "E13458158"
"RoomLevel" => "Basement"
"RoomWidth" => 2.02
"ListingKey" => "29918411"
"RoomLength" => 2.63
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T20:41:13.34Z"
]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"CityRegion": "Bay Ridges"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29918411/819-fairview-avenue-pickering-bay-ridges-bay-ridges"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1973959"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "68202"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:3 [
0 => "Alarm system"
1 => "Security system"
2 => "Smoke Detectors"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 25.0
+"OriginalEntryTimestamp": "2026-06-17T20:41:13.29Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1385603"
+"ListOfficeNationalAssociationId": "1132238"
+"CoListAgentNationalAssociationId": "1260740"
+"CoListOfficeNationalAssociationId": "1132238"
+"Media": array:50 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29918411_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918411/5924a0dbbc1df2b655d4e79e29ccec39.webp"
"MediaSize" => 435047
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918411/thumbnail-5924a0dbbc1df2b655d4e79e29ccec39.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "E13458158"
"ResourceRecordKey" => "29918411"
"ModificationTimestamp" => "2026-06-17T20:41:13.3Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29918411_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918411/66ff8c01394c2d7805455da1dd730473.webp"
"MediaSize" => 454049
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918411/thumbnail-66ff8c01394c2d7805455da1dd730473.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13458158"
"ResourceRecordKey" => "29918411"
"ModificationTimestamp" => "2026-06-17T20:41:13.3Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29918411_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918411/9d566692ea5cdcf2a30909256427c0fb.webp"
"MediaSize" => 353734
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918411/thumbnail-9d566692ea5cdcf2a30909256427c0fb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13458158"
"ResourceRecordKey" => "29918411"
"ModificationTimestamp" => "2026-06-17T20:41:13.3Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29918411_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918411/25393961f41172bbb63309f74ff605cf.webp"
"MediaSize" => 118658
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918411/thumbnail-25393961f41172bbb63309f74ff605cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13458158"
"ResourceRecordKey" => "29918411"
"ModificationTimestamp" => "2026-06-17T20:41:13.3Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29918411_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918411/72765c63210ad57f3a774f57e3b6d308.webp"
"MediaSize" => 141568
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918411/thumbnail-72765c63210ad57f3a774f57e3b6d308.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13458158"
"ResourceRecordKey" => "29918411"
"ModificationTimestamp" => "2026-06-17T20:41:13.3Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29918411_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918411/dc15d41734baae3abdf12eacf9e053a1.webp"
"MediaSize" => 156476
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918411/thumbnail-dc15d41734baae3abdf12eacf9e053a1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13458158"
"ResourceRecordKey" => "29918411"
"ModificationTimestamp" => "2026-06-17T20:41:13.3Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29918411_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918411/f003f97928a5e6b86726217d93fda7e9.webp"
"MediaSize" => 159050
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918411/thumbnail-f003f97928a5e6b86726217d93fda7e9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13458158"
"ResourceRecordKey" => "29918411"
"ModificationTimestamp" => "2026-06-17T20:41:13.3Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29918411_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918411/d19f971ab62ed2c5b4637cfe46acb9bf.webp"
"MediaSize" => 147179
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918411/thumbnail-d19f971ab62ed2c5b4637cfe46acb9bf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13458158"
"ResourceRecordKey" => "29918411"
"ModificationTimestamp" => "2026-06-17T20:41:13.3Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29918411_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918411/54429c54a8eab001eff32e5842a3c3f9.webp"
"MediaSize" => 127264
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918411/thumbnail-54429c54a8eab001eff32e5842a3c3f9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13458158"
"ResourceRecordKey" => "29918411"
"ModificationTimestamp" => "2026-06-17T20:41:13.3Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29918411_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918411/8295eb971c53b3b8f8dacb4962cd088a.webp"
"MediaSize" => 167052
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918411/thumbnail-8295eb971c53b3b8f8dacb4962cd088a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13458158"
"ResourceRecordKey" => "29918411"
"ModificationTimestamp" => "2026-06-17T20:41:13.3Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29918411_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918411/dea00b08e8ecdd1ef0bed5872c796fb8.webp"
"MediaSize" => 150409
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918411/thumbnail-dea00b08e8ecdd1ef0bed5872c796fb8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13458158"
"ResourceRecordKey" => "29918411"
"ModificationTimestamp" => "2026-06-17T20:41:13.3Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29918411_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918411/e33e2f7e3452410a39a2ac605b53f1eb.webp"
"MediaSize" => 139084
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918411/thumbnail-e33e2f7e3452410a39a2ac605b53f1eb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13458158"
"ResourceRecordKey" => "29918411"
"ModificationTimestamp" => "2026-06-17T20:41:13.3Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29918411_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918411/e62b862d4bd04c5dbb8740eb22836e9c.webp"
"MediaSize" => 162923
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918411/thumbnail-e62b862d4bd04c5dbb8740eb22836e9c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13458158"
"ResourceRecordKey" => "29918411"
"ModificationTimestamp" => "2026-06-17T20:41:13.3Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29918411_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918411/98cded16c2e0665d763c48ec90289e8c.webp"
"MediaSize" => 137095
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918411/thumbnail-98cded16c2e0665d763c48ec90289e8c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13458158"
"ResourceRecordKey" => "29918411"
"ModificationTimestamp" => "2026-06-17T20:41:13.3Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29918411_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918411/b613e32dcf9ab2dc46f29761503075a8.webp"
"MediaSize" => 111355
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918411/thumbnail-b613e32dcf9ab2dc46f29761503075a8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13458158"
"ResourceRecordKey" => "29918411"
"ModificationTimestamp" => "2026-06-17T20:41:13.3Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29918411_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918411/467381503ab2686c385ccfd3630395fd.webp"
"MediaSize" => 156007
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918411/thumbnail-467381503ab2686c385ccfd3630395fd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13458158"
"ResourceRecordKey" => "29918411"
"ModificationTimestamp" => "2026-06-17T20:41:13.3Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29918411_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918411/427e57179cddf7fb1a06a3a99bb7981f.webp"
"MediaSize" => 180829
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918411/thumbnail-427e57179cddf7fb1a06a3a99bb7981f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13458158"
"ResourceRecordKey" => "29918411"
"ModificationTimestamp" => "2026-06-17T20:41:13.3Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29918411_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918411/f78072f9426eec545c68882414d06d27.webp"
"MediaSize" => 171017
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918411/thumbnail-f78072f9426eec545c68882414d06d27.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13458158"
"ResourceRecordKey" => "29918411"
"ModificationTimestamp" => "2026-06-17T20:41:13.3Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29918411_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918411/488411992b7481d326698f8a797cd0c5.webp"
"MediaSize" => 160579
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918411/thumbnail-488411992b7481d326698f8a797cd0c5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13458158"
"ResourceRecordKey" => "29918411"
"ModificationTimestamp" => "2026-06-17T20:41:13.3Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29918411_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918411/79504235a78b8d79321e200c8d28305b.webp"
"MediaSize" => 168216
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918411/thumbnail-79504235a78b8d79321e200c8d28305b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13458158"
"ResourceRecordKey" => "29918411"
"ModificationTimestamp" => "2026-06-17T20:41:13.3Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29918411_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918411/adbc8b5af90fcb1ceb65e30aeaeee680.webp"
"MediaSize" => 407107
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918411/thumbnail-adbc8b5af90fcb1ceb65e30aeaeee680.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13458158"
"ResourceRecordKey" => "29918411"
"ModificationTimestamp" => "2026-06-17T20:41:13.3Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29918411_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918411/356c7bce6e9f8821ddc85f7480dcee1a.webp"
"MediaSize" => 121315
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918411/thumbnail-356c7bce6e9f8821ddc85f7480dcee1a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13458158"
"ResourceRecordKey" => "29918411"
"ModificationTimestamp" => "2026-06-17T20:41:13.3Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29918411_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918411/66cdab514ee1b9a8cfa8e94855682877.webp"
"MediaSize" => 97651
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918411/thumbnail-66cdab514ee1b9a8cfa8e94855682877.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13458158"
"ResourceRecordKey" => "29918411"
"ModificationTimestamp" => "2026-06-17T20:41:13.3Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29918411_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918411/9363df559ccdd4b56e2c386f7cf780aa.webp"
"MediaSize" => 99868
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918411/thumbnail-9363df559ccdd4b56e2c386f7cf780aa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13458158"
"ResourceRecordKey" => "29918411"
"ModificationTimestamp" => "2026-06-17T20:41:13.3Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29918411_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918411/272662a77bd855451d19be5c51684b43.webp"
"MediaSize" => 171823
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918411/thumbnail-272662a77bd855451d19be5c51684b43.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13458158"
…2
]
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('29918411')"
+"ID": "1540581"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25235
+post_id: "1540596"
+post_author: 1
+"ListingKey": "29917985"
+"ListingId": "E13457702"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T19:55:12Z"
+"RFModificationTimestamp": "2026-06-17T20:39:02Z"
+"ListPrice": 1100000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Pickering (Rosebank)"
+"PostalCode": "L1W3M5"
+"UnparsedAddress": "520 MCLEOD CRESCENT, Pickering (Rosebank), Ontario L1W3M5"
+"Coordinates": array:2 [
0 => -79.122915
1 => 43.804132
]
+"Latitude": 43.804132
+"Longitude": -79.122915
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome To The Prestigious Rosebank Community, One Of Pickering's Most Sought-After Neighbourhoods Known For Its Mature Tree-Lined Streets, Excellent Schools, Waterfront Access & Convenient Commute To Downtown Toronto. Located Within The Highly Desirable Rosebank Road Public School, Father Fenelon C.S., Dunbarton High School & St. Mary's Catholic Secondary School Districts. Rarely Offered, This Custom Built Chiavatti Home Is The Perfect Multi-Generational Residence. The Unique Layout Offers Exceptional Flexibility For Extended Families With A Main Floor Bedroom, Full Bathroom & Separate Side Entrance Leading To A Private Living Area. Complete With Spacious Family Room Featuring Custom Gas Fireplace & Built-In Shelving. Ideal For In-Laws, Adult Children, Guests Or A Home Office. Situated On A Premium 64-Ft Corner Lot, This Meticulously Maintained Home Offers Over 4,000 Sq. Ft. Of Potential Living Space. The Inviting Front Foyer Leads To Elegant Principal Rooms Featuring Crown Moulding & Rich Hardwood Flooring. The Renovated Gourmet Kitchen Showcases Maple Cabinetry, Centre Island/Breakfast Bar, Pantry, Backsplash, High-End Appliances & Premium WOLF Gas Stove With Walk-Out To The Yard. The Upper Level Features 3 Generous Bedrooms & 2 Beautifully Renovated Full Bathrooms. The Primary Suite Offers A Walk-In Closet & Stunning Updated 3-Piece Ensuite. The Partially Finished Basement Provides Incredible Future Potential With Plenty Of Space To Create An Additional Kitchen, Living Area & Up To 2 Additional Bedrooms, Making It An Excellent Opportunity For Extended Family Living. An Exceptional Opportunity To Own A Custom-Built Home In One Of Pickering's Finest Neighbourhoods, Also Walking Distance To The Blaisdale Montessori Campus. Minutes To Highway 401, GO Transit, Parks, Shopping & The Waterfront. (id:62783)"
+"Appliances": array:8 [
0 => "All"
1 => "Washer"
2 => "Refrigerator"
3 => "Water softener"
4 => "Central Vacuum"
5 => "Dishwasher"
6 => "Dryer"
7 => "Garage door opener remote(s)"
]
+"Basement": array:4 [
0 => "Partially finished"
1 => "Separate entrance"
2 => "N/A"
3 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T20:38:51.301893+00:00"
+"Directions": "Cross Streets: Kingston & Rougemount. ** Directions: .."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:1 [
0 => "Hardwood"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1894260"
+"ListOfficeKey": "275283"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "63.8 x 115 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T19:45:36Z"
+"PhotosCount": 26
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T19:45:36Z"
+"Stories": "2.0"
+"StreetName": "McLeod"
+"StreetNumber": "520"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "8760"
+"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": "Toronto"
+"CityRegion": "Rosebank"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29917985/520-mcleod-crescent-pickering-rosebank-rosebank"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 63.9
+"OriginalEntryTimestamp": "2026-06-17T19:45:36.64Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1213404"
+"ListOfficeNationalAssociationId": "1263501"
+"Media": array:26 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29917985')"
+"ID": "1540596"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25232
+post_id: "1540185"
+post_author: 1
+"ListingKey": "29917542"
+"ListingId": "E13457506"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T18:50:08Z"
+"RFModificationTimestamp": "2026-06-17T19:12:27Z"
+"ListPrice": 634900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Pickering (West Shore)"
+"PostalCode": "L1W3C9"
+"UnparsedAddress": "4 - 765 OKLAHOMA DRIVE, Pickering (West Shore), Ontario L1W3C9"
+"Coordinates": array:2 [
0 => -79.107481
1 => 43.812281
]
+"Latitude": 43.812281
+"Longitude": -79.107481
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this well-maintained condo townhouse in Pickering's sought-after West Shore community, just minutes from Frenchman's Bay, the Waterfront Trail, parks, schools, shopping, and convenient transit options. Offering a bright and functional layout, this home is ideal for first-time buyers, downsizers, and investors alike. Fresh paint, updated flooring, and renovated bathrooms provide a clean, modern feel throughout, while leaving opportunities for future customization to suit your personal style. The spacious living and dining areas offer plenty of room for everyday living and entertaining, enhanced by large windows that fill the home with natural light. The kitchen is practical and well-appointed with stainless steel appliances, including a fridge and stove, and offers excellent potential for future updates. Upstairs, you'll find three generously sized bedrooms with ample closet space and a functional family-friendly layout. The renovated bathrooms add value and convenience, while the finished lower level provides additional living space with a walkout to a private outdoor area. Located in a well-managed complex within a sought-after waterfront community, this move-in-ready home offers the perfect balance of comfort, location, and value. Enjoy easy access to Frenchman's Bay, the Waterfront Trail, GO Transit, Highway 401, schools, parks, and everyday amenities. A fantastic opportunity to own in one of Pickering's most desirable neighbourhoods. Gas heater in the dining room does not work, never worked, and is as-is. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Window Coverings"
5 => "Garage door opener remote(s)"
]
+"AssociationFee": "589.03"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Cable TV"
2 => "Water"
3 => "Insurance"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-06-17T19:12:18.723483+00:00"
+"Directions": "Whites/Oklahoma"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"Heating": array:2 [
0 => "Baseboard heaters"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2016618"
+"ListOfficeKey": "50351"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T18:44:04Z"
+"PhotosCount": 24
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T18:44:04Z"
+"Stories": "2.0"
+"StreetName": "Oklahoma"
+"StreetNumber": "765"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "3723.01"
+"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": "Toronto"
+"CityRegion": "West Shore"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29917542/4-765-oklahoma-drive-pickering-west-shore-west-shore"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Guardian Property Management Services"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1399
+"LivingAreaMinimum": 1200
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2026-06-17T18:44:04.61Z"
+"ListAgentNationalAssociationId": "1297846"
+"ListOfficeNationalAssociationId": "1003097"
+"Media": array:24 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29917542')"
+"ID": "1540185"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25236
+post_id: "1539358"
+post_author: 1
+"ListingKey": "29916896"
+"ListingId": "E13456974"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T17:50:04Z"
+"RFModificationTimestamp": "2026-06-17T18:12:19Z"
+"ListPrice": 759000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Pickering (Bay Ridges)"
+"PostalCode": "L1W0A2"
+"UnparsedAddress": "108 - 1250 ST MARTINS DRIVE, Pickering (Bay Ridges), Ontario L1W0A2"
+"Coordinates": array:2 [
0 => -79.090753
1 => 43.826815
]
+"Latitude": 43.826815
+"Longitude": -79.090753
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this stylish and modern 2-bedroom plus den residence, perfectly designed for today's young professionals seeking comfort, convenience, and lifestyle. Featuring 3 bathrooms, bright open-concept living space, a private balcony, and an impressive rooftop terrace of approximately 37 sq. m., this home offers the ideal balance of indoor elegance and outdoor enjoyment. The versatile den is perfect for a home office, creative studio, or guest space, making it ideal for remote work and modern living. Enjoy a sophisticated layout with room to entertain, relax, and take in fresh air from your own private outdoor spaces. Located in a highly connected Pickering community, this home places you close to everything: Pickering Town Centre, GO Train station, shops, transit, schools, and everyday amenities. For an active lifestyle, walk or bike to Frenchman's Bay, waterfront trails, lakefront parks, and scenic green spaces. Perfect for professionals, couples, or first-time buyers looking for a stylish home with urban convenience and outdoor lifestyle by the lake. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"Basement": array:3 [
0 => "Finished"
1 => "Walk out"
2 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T18:12:07.176947+00:00"
+"Directions": "Cross Streets: Liverpool / Bayly. ** Directions: LIVERPOOL BAYLY TO LIVERPOOL TO ST MARTINS."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1421597"
+"ListOfficeKey": "284787"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "20.5 x 47.9 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T17:42:33Z"
+"PhotosCount": 15
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T17:42:33Z"
+"Stories": "3.0"
+"StreetName": "St Martins"
+"StreetNumber": "1250"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "5068.32"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Bay Ridges"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29916896/108-1250-st-martins-drive-pickering-bay-ridges-bay-ridges"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 20.6
+"OriginalEntryTimestamp": "2026-06-17T17:42:33.89Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1105775"
+"ListOfficeNationalAssociationId": "1344854"
+"Media": array:15 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29916896')"
+"ID": "1539358"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25234
+post_id: "1540186"
+post_author: 1
+"ListingKey": "29916073"
+"ListingId": "E13456206"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T17:00:15Z"
+"RFModificationTimestamp": "2026-06-17T17:13:40Z"
+"ListPrice": 999000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Pickering (West Shore)"
+"PostalCode": "L1W3W7"
+"UnparsedAddress": "611 ATWOOD CRESCENT, Pickering (West Shore), Ontario L1W3W7"
+"Coordinates": array:2 [
0 => -79.113084
1 => 43.810254
]
+"Latitude": 43.810254
+"Longitude": -79.113084
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Beautifully updated gem on a premium pie-shaped lot in West Shore's highly sought-after Petticoat Creek Conservation Park pocket! This turnkey home checks every single box, boasting stylish modern finishes and a rare 4-bathroom layout. The sun-filled main floor showcases brand new hardwood flooring, a refinished hardwood staircase with sleek metal spindles, and an updated kitchen complete with a porcelain backsplash, quartz countertops, and a spacious peninsula. Step from the adjoining family room straight out to a massive entertaining deck and an expansive private backyard, fully secured by a newer fence (2023) and equipped with a handy garden shed. The second floor offers three bedrooms with matching new hardwood floors, a fully renovated common bath, and a beautifully upgraded private ensuite in the primary bedroom. The fully finished basement serves as the ultimate bonus space for recreation, a home office, or hosting guests, featuring a luxury wet bar and another fully renovated full bath. Parking is a breeze with a 3-car driveway plus a spacious single-car garage featuring anew door and smart opener. Location is everything: you are minutes from Hwy 401/407, the GO Station, and major shopping, while being just steps from hiking trails, Dunmoore Park's kids play area, leash-free dog area, baseball diamonds, soccer field and tennis courts, West Shore's scenic waterfront, and a short 10-minute stroll to Petticoat Creek Conservation Area. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Gas stove(s)"
3 => "Dishwasher"
4 => "Dryer"
5 => "Garage door opener"
6 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T17:13:31.043068+00:00"
+"Directions": "Cross Streets: Whites & Hwy 401. ** Directions: Whites, South of Hwy 401."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"Flooring": array:2 [
0 => "Hardwood"
1 => "Laminate"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1420879"
+"ListOfficeKey": "51273"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "24 x 120.2 FT ; 53 Ft. Wide Rear"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T16:52:39Z"
+"PhotosCount": 48
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T16:52:39Z"
+"Stories": "2.0"
+"StreetName": "Atwood"
+"StreetNumber": "611"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "6699.82"
+"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": "Toronto"
+"CityRegion": "West Shore"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29916073/611-atwood-crescent-pickering-west-shore-west-shore"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 24.0
+"OriginalEntryTimestamp": "2026-06-17T16:24:18.77Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1046229"
+"ListOfficeNationalAssociationId": "1002255"
+"Media": array:48 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29916073')"
+"ID": "1540186"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25229
+post_id: "1538846"
+post_author: 1
+"ListingKey": "29915998"
+"ListingId": "40840690"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T16:25:15Z"
+"RFModificationTimestamp": "2026-06-17T16:33:42Z"
+"ListPrice": 759000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1667.0
+"BuildingAreaTotal": 0
+"City": "Pickering"
+"PostalCode": "L1W0A2"
+"UnparsedAddress": "1250 ST MARTINS Drive Unit# 108, Pickering, Ontario L1W0A2"
+"Coordinates": array:2 [
0 => -79.091956
1 => 43.8268714
]
+"Latitude": 43.8268714
+"Longitude": -79.091956
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this stylish and modern 2-bedroom plus den residence, perfectly designed for today’s young professionals seeking comfort, convenience, and lifestyle. Featuring 3 bathrooms, bright open-concept living space, a private balcony, and an impressive rooftop terrace of approximately 37 sq. m., this home offers the ideal balance of indoor elegance and outdoor enjoyment. The versatile den is perfect for a home office, creative studio, or guest space, making it ideal for remote work and modern living. Enjoy a sophisticated layout with room to entertain, relax, and take in fresh air from your own private outdoor spaces. Located in a highly connected Pickering community, this home places you close to everything: Pickering Town Centre, GO Train station, shops,transit, schools, and everyday amenities. For an active lifestyle, walk or bike to Frenchman’s Bay, waterfront trails, lakefront parks, and scenic green spaces. Perfect for professionals, couples, or first-time buyers looking for a stylish home with urban convenience and outdoor lifestyle by the lake. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"AssociationFeeIncludes": array:3 [
0 => "Landscaping"
1 => "Water"
2 => "Insurance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T16:33:29.036092+00:00"
+"Directions": "LIVERPOOL BAYLY TO LIVERPOOL TO ST MARTINS"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1988878"
+"ListOfficeKey": "284641"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-17T16:11:21Z"
+"PhotosCount": 16
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T16:11:21Z"
+"Stories": "3.0"
+"StreetName": "ST MARTINS"
+"StreetNumber": "1250"
+"StreetSuffix": "Drive"
+"SubdivisionName": "Pickering"
+"TaxAnnualAmount": "5068"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29915998/1250-st-martins-drive-unit-108-pickering"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "C2"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 21.0
+"AboveGradeFinishedArea": 1166
+"BelowGradeFinishedArea": 501
+"OriginalEntryTimestamp": "2026-06-17T16:11:21.84Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1273011"
+"ListOfficeNationalAssociationId": "1344650"
+"Media": array:16 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29915998')"
+"ID": "1538846"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23376
+post_id: "1536942"
+post_author: 1
+"ListingKey": "29912779"
+"ListingId": "E13453196"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T01:15:03Z"
+"RFModificationTimestamp": "2026-06-17T01:16:06Z"
+"ListPrice": 688000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Pickering (Bay Ridges)"
+"PostalCode": "L1W0A2"
+"UnparsedAddress": "1250 ST. MARTINS DRIVE, Pickering (Bay Ridges), Ontario L1W0A2"
+"Coordinates": array:2 [
0 => -79.090753
1 => 43.826815
]
+"Latitude": 43.826815
+"Longitude": -79.090753
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to one of Pickering's best-kept secrets. Nestled within an exclusive enclave of executive townhomes, this highly sought-after community offers a lifestyle that many GTA buyers don't realize exists; a rare blend of waterfront living, walkable amenities, effortless commuting, and modern, low-maintenance luxury. Perfectly positioned just moments from the Pickering GO Station and Highway 401, this is an ideal opportunity for those seeking more space without sacrificing convenience. Enjoy an easy commute to the city, then come home to a vibrant lakeside community where evening walks along Frenchman's Bay, waterfront dining, charming boutiques, local cafés, the marina, beach, and lighthouse become part of everyday life. Inside, the home offers a thoughtfully designed open concept layout that feels both stylish and inviting. The updated kitchen anchors the main living space, while tasteful finishes throughout create a warm, contemporary atmosphere. Direct garage access provides everyday convenience, and the private rooftop terrace is a true standout feature, offering an exceptional outdoor retreat for entertaining, dining al fresco, summer barbecues, or simply unwinding above it all. This is more than just a townhouse. It's an opportunity to enjoy the best of both worlds: the energy and accessibility of the city paired with the charm, waterfront beauty, and sense of community that make this pocket one of Pickering's most desirable places to call home. (id:62650)"
+"Appliances": array:1 [
0 => "Garage door opener remote(s)"
]
+"AssociationFee": "108.94"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Parcel of Tied Land"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T22:38:59.566833+00:00"
+"Directions": "Cross Streets: Liverpool and Bayly. ** Directions: South of 401 and Liverpool."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1419937"
+"ListOfficeKey": "275900"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "6.3 x 13.6 M"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T00:07:02Z"
+"PhotosCount": 17
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T01:07:15Z"
+"Stories": "3.0"
+"StreetName": "St. Martins"
+"StreetNumber": "1250"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "4728"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"CityRegion": "Bay Ridges"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29912779/85-1250-st-martins-drive-pickering-bay-ridges-bay-ridges"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1999217"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "275900"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 2
+"FrontageLengthNumeric": 6.25
+"OriginalEntryTimestamp": "2026-06-16T21:42:28.57Z"
+"FrontageLengthNumericUnits": "meters"
+"ListAgentNationalAssociationId": "1056017"
+"ListOfficeNationalAssociationId": "1269109"
+"CoListAgentNationalAssociationId": "1281530"
+"CoListOfficeNationalAssociationId": "1269109"
+"Media": array:17 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29912779')"
+"ID": "1536942"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25237
+post_id: "1531840"
+post_author: 1
+"ListingKey": "29904466"
+"ListingId": "E13445632"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T17:00:14Z"
+"RFModificationTimestamp": "2026-06-15T20:10:05Z"
+"ListPrice": 919000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Pickering (West Shore)"
+"PostalCode": "L1W2H8"
+"UnparsedAddress": "971 OKLAHOMA DRIVE, Pickering (West Shore), Ontario L1W2H8"
+"Coordinates": array:2 [
0 => -79.098155
1 => 43.814111
]
+"Latitude": 43.814111
+"Longitude": -79.098155
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Fabulous location around the corner from Frenchman's Bay Yacht Club! Beautiful 3 Bedroom, 3 Bathroom Detached Backsplit with Large Lot Size 50 x 100 Ft! Great Layout with a Spacious Living Room Combined with Dining. Super Functional Kitchen with Lots of Cabinets and Counter Space. Family Room Located on Lower Level. Freshly Fully Painted Walls, Ceilings and Baseboards! Enjoy your Summers in the Beautiful Backyard Surrounded by Gardens and a Deck for Outdoor Entertaining. Solarium for cozy nights! Fully Fenced Backyard. Private Wide Driveway That Can Fit Up to 4 Cars. Join the Very Popular West Shore Community and Enjoy Frenchman's Bay, Waterfront Trail and Beach Point Promenade! 5 Minutes to 401 via Whites Rd S, Catholic and Public Schools, Pickering City Centre, Shops, Casino, Restaurants, Pickering Go Station and More! (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T20:09:55.347114+00:00"
+"Directions": "Whites Road S & Oklahoma Drive"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1990790"
+"ListOfficeKey": "287099"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "50 x 100 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T16:48:41Z"
+"PhotosCount": 43
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T16:48:41Z"
+"StreetName": "Oklahoma"
+"StreetNumber": "971"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "5938"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=x34FcaSag32"
+"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": "Toronto"
+"CityRegion": "West Shore"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29904466/971-oklahoma-drive-pickering-west-shore-west-shore"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 50.0
+"OriginalEntryTimestamp": "2026-06-15T16:48:41.12Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1274510"
+"ListOfficeNationalAssociationId": "1366574"
+"Media": array:43 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29904466')"
+"ID": "1531840"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25238
+post_id: "1523436"
+post_author: 1
+"ListingKey": "29894300"
+"ListingId": "E13435964"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T12:20:36Z"
+"RFModificationTimestamp": "2026-06-15T12:22:24Z"
+"ListPrice": 899900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Pickering (West Shore)"
+"PostalCode": "L1W2K9"
+"UnparsedAddress": "861 BOXWORTH PLACE, Pickering (West Shore), Ontario L1W2K9"
+"Coordinates": array:2 [
0 => -79.101143
1 => 43.819699
]
+"Latitude": 43.819699
+"Longitude": -79.101143
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 861 Boxworth Place, tucked away on a quiet private court in one of West Shore Pickering's most sought-after family communities. This spacious 4-bedroom backsplit offers an ideal layout for growing families, featuring three bedrooms on the upper level and a bright main-floor bedroom currently used as a home office. The open-concept main living area flows seamlessly into the kitchen as well as a second living space on the lower-level creating multiple gathering areas to enjoy family time, entertain friends, and make lasting memories. Thoughtful updates throughout add warmth and style, while large windows fill the home with natural light. Situated on an incredible oversized pie-shaped lot, the possibilities are endless-whether you envision a backyard oasis, play area, garden retreat, or future outdoor entertaining space. The enclosed carport provides additional functionality and storage, while the extended driveway offers ample parking for family and guests. Located just steps from the waterfront, beach, marina, parks, walking trails, and excellent schools, this home delivers the perfect balance of lifestyle and convenience. Quick access to Highway 401, GO Transit, shopping, recreation, and all essential amenities makes commuting effortless. If you know West Shore, you know opportunities on quiet courts like Boxworth Place are rare. A fantastic family home on an exceptional lot in a highly desirable neighbourhood where community, convenience, and outdoor living come together. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Oven"
4 => "Dryer"
5 => "Cooktop"
6 => "Blinds"
7 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T14:50:37.045048+00:00"
+"Directions": "Bayly/W Shore"
+"ExteriorFeatures": array:1 [
0 => "Wood"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:3 [
0 => "Hardwood"
1 => "Carpeted"
2 => "Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1964545"
+"ListOfficeKey": "50570"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "37.3 x 101.3 FT"
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Carport"
]
+"PhotosChangeTimestamp": "2026-06-12T13:36:34Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T12:08:22Z"
+"StreetName": "Boxworth"
+"StreetNumber": "861"
+"StreetSuffix": "Place"
+"TaxAnnualAmount": "6525.97"
+"VirtualTourURLUnbranded": "https://player.vimeo.com/video/1200795596?title=0&byline=0&portrait=0&badge=0&autopause=0&player_id=0&app_id=58479"
+"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": "Toronto"
+"TaxYear": 2025
+"CityRegion": "West Shore"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29894300/861-boxworth-place-pickering-west-shore-west-shore"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 37.3
+"OriginalEntryTimestamp": "2026-06-12T13:36:33.99Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1253232"
+"ListOfficeNationalAssociationId": "1002989"
+"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": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29894300')"
+"ID": "1523436"
}
]
+success: true
+page_size: 9
+page_count: 11
+count: 96
+after_key: ""
}
"RF Response Time" => "0.22 seconds"
]
]