array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29915998 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: "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 [
"RoomKey" => "1661246443"
"RoomType" => "4pc Bathroom"
"ListingId" => "40840690"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29915998"
"RoomLength" => null
"RoomDimensions" => "7'2'' x 13'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T16:11:21.87Z"
]
1 => array:11 [
"RoomKey" => "1661246444"
"RoomType" => "4pc Bathroom"
"ListingId" => "40840690"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29915998"
"RoomLength" => null
"RoomDimensions" => "7'3'' x 6'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T16:11:21.87Z"
]
2 => array:11 [
"RoomKey" => "1661246445"
"RoomType" => "2pc Bathroom"
"ListingId" => "40840690"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29915998"
"RoomLength" => null
"RoomDimensions" => "5'0'' x 5'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T16:11:21.87Z"
]
3 => array:11 [
"RoomKey" => "1661246446"
"RoomType" => "Bedroom"
"ListingId" => "40840690"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29915998"
"RoomLength" => null
"RoomDimensions" => "1'2'' x 9'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T16:11:21.87Z"
]
4 => array:11 [
"RoomKey" => "1661246447"
"RoomType" => "Primary Bedroom"
"ListingId" => "40840690"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29915998"
"RoomLength" => null
"RoomDimensions" => "18'8'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T16:11:21.87Z"
]
5 => array:11 [
"RoomKey" => "1661246448"
"RoomType" => "Living room"
"ListingId" => "40840690"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29915998"
"RoomLength" => null
"RoomDimensions" => "17'4'' x 20'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T16:11:21.87Z"
]
6 => array:11 [
"RoomKey" => "1661246449"
"RoomType" => "Dining room"
"ListingId" => "40840690"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29915998"
"RoomLength" => null
"RoomDimensions" => "9'2'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T16:11:21.87Z"
]
7 => array:11 [
"RoomKey" => "1661246450"
"RoomType" => "Kitchen"
"ListingId" => "40840690"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29915998"
"RoomLength" => null
"RoomDimensions" => "9'2'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T16:11:21.87Z"
]
8 => array:11 [
"RoomKey" => "1661246451"
"RoomType" => "Den"
"ListingId" => "40840690"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29915998"
"RoomLength" => null
"RoomDimensions" => "18'8'' x 12'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T16:11:21.87Z"
]
]
+"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 [
"Order" => 1
"MediaKey" => "29915998_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915998/b8d3256b680c36edc1aadde34f76fb40.webp"
"MediaSize" => 78483
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915998/thumbnail-b8d3256b680c36edc1aadde34f76fb40.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40840690"
"ResourceRecordKey" => "29915998"
"ModificationTimestamp" => "2026-06-17T16:11:21.85Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29915998_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915998/a2f4483623f0f77b5f3dbcc84678069c.webp"
"MediaSize" => 56861
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915998/thumbnail-a2f4483623f0f77b5f3dbcc84678069c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840690"
"ResourceRecordKey" => "29915998"
"ModificationTimestamp" => "2026-06-17T16:11:21.85Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29915998_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915998/f45f51c765d3caf6a0d6b30c59538551.webp"
"MediaSize" => 59929
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915998/thumbnail-f45f51c765d3caf6a0d6b30c59538551.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840690"
"ResourceRecordKey" => "29915998"
"ModificationTimestamp" => "2026-06-17T16:11:21.85Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29915998_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915998/15f715c1af17099f5f0c3c20866e1665.webp"
"MediaSize" => 50134
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915998/thumbnail-15f715c1af17099f5f0c3c20866e1665.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840690"
"ResourceRecordKey" => "29915998"
"ModificationTimestamp" => "2026-06-17T16:11:21.85Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29915998_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915998/3107ce24d1f26dfb7dd222094d07ab4a.webp"
"MediaSize" => 46412
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915998/thumbnail-3107ce24d1f26dfb7dd222094d07ab4a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840690"
"ResourceRecordKey" => "29915998"
"ModificationTimestamp" => "2026-06-17T16:11:21.85Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29915998_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915998/4de5401043438f9ba9615aa164942f36.webp"
"MediaSize" => 51644
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915998/thumbnail-4de5401043438f9ba9615aa164942f36.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840690"
"ResourceRecordKey" => "29915998"
"ModificationTimestamp" => "2026-06-17T16:11:21.85Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29915998_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915998/6e48e3f70976a45f989c2beb4b16a15a.webp"
"MediaSize" => 51253
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915998/thumbnail-6e48e3f70976a45f989c2beb4b16a15a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840690"
"ResourceRecordKey" => "29915998"
"ModificationTimestamp" => "2026-06-17T16:11:21.85Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29915998_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915998/137ac882cc4677c5407b7264897cf990.webp"
"MediaSize" => 50653
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915998/thumbnail-137ac882cc4677c5407b7264897cf990.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840690"
"ResourceRecordKey" => "29915998"
"ModificationTimestamp" => "2026-06-17T16:11:21.85Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29915998_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915998/e8c49bbefb43a27d27049312b807f469.webp"
"MediaSize" => 51320
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915998/thumbnail-e8c49bbefb43a27d27049312b807f469.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840690"
"ResourceRecordKey" => "29915998"
"ModificationTimestamp" => "2026-06-17T16:11:21.85Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29915998_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915998/adcb885f287a1411a87bb427c4b44132.webp"
"MediaSize" => 70639
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915998/thumbnail-adcb885f287a1411a87bb427c4b44132.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840690"
"ResourceRecordKey" => "29915998"
"ModificationTimestamp" => "2026-06-17T16:11:21.85Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29915998_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915998/1fbb3bc5dcb0b7113de523353e1f6d99.webp"
"MediaSize" => 54661
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915998/thumbnail-1fbb3bc5dcb0b7113de523353e1f6d99.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840690"
"ResourceRecordKey" => "29915998"
"ModificationTimestamp" => "2026-06-17T16:11:21.85Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29915998_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915998/b56161db659fea4407a6482d2910a70f.webp"
"MediaSize" => 51326
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915998/thumbnail-b56161db659fea4407a6482d2910a70f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840690"
"ResourceRecordKey" => "29915998"
"ModificationTimestamp" => "2026-06-17T16:11:21.85Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29915998_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915998/fdb02a31045988a44ddaab0a508b8206.webp"
"MediaSize" => 53360
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915998/thumbnail-fdb02a31045988a44ddaab0a508b8206.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840690"
"ResourceRecordKey" => "29915998"
"ModificationTimestamp" => "2026-06-17T16:11:21.85Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29915998_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915998/282751727de6310cd6af5f6d5ffe81d8.webp"
"MediaSize" => 48152
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915998/thumbnail-282751727de6310cd6af5f6d5ffe81d8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840690"
"ResourceRecordKey" => "29915998"
"ModificationTimestamp" => "2026-06-17T16:11:21.85Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29915998_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915998/df55198391324f5631e58a7da5b88bac.webp"
"MediaSize" => 57273
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915998/thumbnail-df55198391324f5631e58a7da5b88bac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840690"
"ResourceRecordKey" => "29915998"
"ModificationTimestamp" => "2026-06-17T16:11:21.85Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29915998_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915998/035052efad2e59e62639b03d5eb3a21c.webp"
"MediaSize" => 35992
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915998/thumbnail-035052efad2e59e62639b03d5eb3a21c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840690"
"ResourceRecordKey" => "29915998"
"ModificationTimestamp" => "2026-06-17T16:11:21.85Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29915998')"
+"ID": "1538846"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 284641" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24727
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1988878" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24812
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29915998'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25105
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29915998'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25123
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25121
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31515441"
+"ListingKey": "29915998"
+"ListingId": "40840690"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-21"
+"OpenHouseStartTime": "2026-06-21T14:00:00Z"
+"OpenHouseEndTime": "2026-06-21T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-17T16:50:14Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31515441')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29915998' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.091956 43.8268714)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25176
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25170
+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"
"ResourceRecordKey" => "29918411"
"ModificationTimestamp" => "2026-06-17T20:41:13.3Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29918411_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918411/2907b54d8d37dd9996a42fef262d860a.webp"
"MediaSize" => 155757
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918411/thumbnail-2907b54d8d37dd9996a42fef262d860a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13458158"
"ResourceRecordKey" => "29918411"
"ModificationTimestamp" => "2026-06-17T20:41:13.3Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29918411_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918411/715e60e23f23332cfd095e7c3534a7e6.webp"
"MediaSize" => 127172
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918411/thumbnail-715e60e23f23332cfd095e7c3534a7e6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13458158"
"ResourceRecordKey" => "29918411"
"ModificationTimestamp" => "2026-06-17T20:41:13.3Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29918411_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918411/8428a93ac757f1c943015dc7f06295b5.webp"
"MediaSize" => 109898
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918411/thumbnail-8428a93ac757f1c943015dc7f06295b5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13458158"
"ResourceRecordKey" => "29918411"
"ModificationTimestamp" => "2026-06-17T20:41:13.3Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29918411_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918411/d68a6f31c5b28077bf342ca7d8563500.webp"
"MediaSize" => 120248
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918411/thumbnail-d68a6f31c5b28077bf342ca7d8563500.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13458158"
"ResourceRecordKey" => "29918411"
"ModificationTimestamp" => "2026-06-17T20:41:13.3Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29918411_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918411/208ae495b5fd9af90f7e9472294c8c70.webp"
"MediaSize" => 107101
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918411/thumbnail-208ae495b5fd9af90f7e9472294c8c70.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13458158"
"ResourceRecordKey" => "29918411"
"ModificationTimestamp" => "2026-06-17T20:41:13.3Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29918411_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918411/638f4edf6fb160cde9f87bcfccda0593.webp"
"MediaSize" => 122821
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918411/thumbnail-638f4edf6fb160cde9f87bcfccda0593.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13458158"
"ResourceRecordKey" => "29918411"
"ModificationTimestamp" => "2026-06-17T20:41:13.3Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29918411_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918411/4262292e3fcb2f2fc405c5c7995439c2.webp"
"MediaSize" => 96986
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918411/thumbnail-4262292e3fcb2f2fc405c5c7995439c2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13458158"
"ResourceRecordKey" => "29918411"
"ModificationTimestamp" => "2026-06-17T20:41:13.3Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29918411_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918411/9b3f42c3dd5d925994f28b69a78c442c.webp"
"MediaSize" => 181078
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918411/thumbnail-9b3f42c3dd5d925994f28b69a78c442c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13458158"
"ResourceRecordKey" => "29918411"
"ModificationTimestamp" => "2026-06-17T20:41:13.3Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29918411_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918411/700371451b4c55789f31727a895eb5f9.webp"
"MediaSize" => 118182
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918411/thumbnail-700371451b4c55789f31727a895eb5f9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13458158"
"ResourceRecordKey" => "29918411"
"ModificationTimestamp" => "2026-06-17T20:41:13.3Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29918411_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918411/60022fdfdc88ecd71ad6e4b9a86bc8ef.webp"
"MediaSize" => 120292
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918411/thumbnail-60022fdfdc88ecd71ad6e4b9a86bc8ef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13458158"
"ResourceRecordKey" => "29918411"
"ModificationTimestamp" => "2026-06-17T20:41:13.3Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29918411_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918411/3784e1b0cacd821e887b49efdc23c9da.webp"
"MediaSize" => 258059
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918411/thumbnail-3784e1b0cacd821e887b49efdc23c9da.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13458158"
"ResourceRecordKey" => "29918411"
"ModificationTimestamp" => "2026-06-17T20:41:13.3Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29918411_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918411/99df2b35ac62f31fc581c2ed71635a74.webp"
"MediaSize" => 255002
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918411/thumbnail-99df2b35ac62f31fc581c2ed71635a74.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13458158"
"ResourceRecordKey" => "29918411"
"ModificationTimestamp" => "2026-06-17T20:41:13.3Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29918411_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918411/d060ba534a5eb71a731a0ce9b8c04633.webp"
"MediaSize" => 275575
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918411/thumbnail-d060ba534a5eb71a731a0ce9b8c04633.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13458158"
"ResourceRecordKey" => "29918411"
"ModificationTimestamp" => "2026-06-17T20:41:13.3Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29918411_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918411/b413c6abd9d886cf6da5014feeb732b0.webp"
"MediaSize" => 223094
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918411/thumbnail-b413c6abd9d886cf6da5014feeb732b0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13458158"
"ResourceRecordKey" => "29918411"
"ModificationTimestamp" => "2026-06-17T20:41:13.3Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29918411_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918411/12c4bbb638eda0bfc883e90124902118.webp"
"MediaSize" => 290452
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918411/thumbnail-12c4bbb638eda0bfc883e90124902118.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13458158"
"ResourceRecordKey" => "29918411"
"ModificationTimestamp" => "2026-06-17T20:41:13.3Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29918411_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918411/0fa94bdef4428a006ade61f4d3530165.webp"
"MediaSize" => 289600
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918411/thumbnail-0fa94bdef4428a006ade61f4d3530165.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13458158"
"ResourceRecordKey" => "29918411"
"ModificationTimestamp" => "2026-06-17T20:41:13.3Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29918411_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918411/55d540a8bf7812eb8f6585c3f76060e7.webp"
"MediaSize" => 226540
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918411/thumbnail-55d540a8bf7812eb8f6585c3f76060e7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "E13458158"
"ResourceRecordKey" => "29918411"
"ModificationTimestamp" => "2026-06-17T20:41:13.3Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29918411_4890_43"
…11
]
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 {#25172
+post_id: "1540275"
+post_author: 1
+"ListingKey": "29916397"
+"ListingId": "E13456322"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T16:55:15Z"
+"RFModificationTimestamp": "2026-06-17T20:02:15Z"
+"ListPrice": 540000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Pickering (Town Centre)"
+"PostalCode": "L1V6V2"
+"UnparsedAddress": "609 - 1400 THE ESPLANADE STREET N, Pickering (Town Centre), Ontario L1V6V2"
+"Coordinates": array:2 [
0 => -79.083479
1 => 43.839389
]
+"Latitude": 43.839389
+"Longitude": -79.083479
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "OFFERS ANYTIME! Welcome To Elevated Living In One Of Central Pickering's Most Sought-After Gated Communities. This Stylish 3-Storey Townhome Offers A Vibrant, Low-Maintenance Lifestyle Just Steps To All Amenities, Including Shopping, Dining, Transit, And The Go Train. The Open Concept Main Floor Is Bright And Inviting, Designed For Both Relaxing And Entertaining, With A Walkout To Your Private Balcony, Perfect For Morning Coffee, BBQing, Or Evening Unwinding. The 2nd Floor Primary Suite Offers A Comfortable Retreat With A Walk-In Closet And A Private 4-Piece Ensuite And Laundry. The Third Level Expands The Living Space With Two Additional Bedrooms, A Versatile Sitting Area Ideal For A Home Office Or Lounge, A Full 4-Piece Bathroom, And A Convenient Storage Room. Underground Parking Adds Ease And Security. Set Within A Gated Community And Surrounded By Amenities, This Home Delivers The Perfect Blend Of Convenience, Style, And Modern Living. (id:62650)"
+"AssociationFee": "894.49"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Water"
2 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T20:02:12.231583+00:00"
+"Directions": "Cross Streets: Kingston Rd & Glenanna Rd. ** Directions: Southeast on Glenanna Rd from Kingston Rd then Northeast on The Esplanade N."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:2 [
0 => "Tile"
1 => "Hardwood"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1416058"
+"ListOfficeKey": "268057"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-17T16:45:39Z"
+"PhotosCount": 31
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T16:45:39Z"
+"Stories": "3.0"
+"StreetDirSuffix": "North"
+"StreetName": "The Esplanade"
+"StreetNumber": "1400"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3697.25"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/1400_esplanade_609_pickering_on/"
+"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": "Town Centre"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29916397/609-1400-the-esplanade-street-n-pickering-town-centre-town-centre"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Newton-Trelawny"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1799
+"LivingAreaMinimum": 1600
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2026-06-17T16:45:39.86Z"
+"ListAgentNationalAssociationId": "1055685"
+"ListOfficeNationalAssociationId": "1229740"
+"Media": array:31 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29916397')"
+"ID": "1540275"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25169
+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"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25173
+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 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "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 [ …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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29915294')"
+"ID": "1538895"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25171
+post_id: "1536941"
+post_author: 1
+"ListingKey": "29912296"
+"ListingId": "E13452682"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T20:50:03Z"
+"RFModificationTimestamp": "2026-06-16T23:03:11Z"
+"ListPrice": 949800.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Pickering (Bay Ridges)"
+"PostalCode": "L1W1A4"
+"UnparsedAddress": "1304 WHARF STREET, Pickering (Bay Ridges), Ontario L1W1A4"
+"Coordinates": array:2 [
0 => -79.081109
1 => 43.81646
]
+"Latitude": 43.81646
+"Longitude": -79.081109
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Rare Opportunity to Own this Meticulously Maintained 4+1 Bedroom, 2.5 Bathroom Family-Sized Home Nestled in one of Pickerings most Sought-After Waterfront Communities!! Enjoy the Best of Lakeside Living with Frenchmans Bay! Waterfront Beach Park w/ New Boardwalks!! Ample Hiking and Bicycle Trails!! New Waterfront Restaurant!! Pickering Marina! Shops! and Restaurants Just a Short Walk Away. Commuters will Appreciate The Quick Access to Hwy 401, the GO Train, and Pickering Town Centre! Making Daily Travel and Errands a Breeze. This Spacious 4-Level Split Layout Offers Ample Room for Families of All Sizes, with Bright, Functional Living Spaces And Thoughtful Updates Throughout. The Large Custom Deck and Landscaped, Fully Fenced Yard Create a Private Outdoor Retreat Perfect for Entertaining or Relaxing In a Quiet Setting. Additional Features Include an Oversized 4-Car Driveway, a Finished Basement With an Extra Bedroom, and a Layout Designed for Comfortable Everyday Living. Dont Miss this Exclusive Opportunity to Own a Beautiful Home in a Prime Lakeside Location where Comfort, Convenience, And Natural Beauty Come Together! (id:62650)"
+"Appliances": array:2 [
0 => "Garage door opener remote(s)"
1 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T23:02:00.756326+00:00"
+"Directions": "Cross Streets: Liverpool / Bayly. ** Directions: South On Liverpool / East on Wharf."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:2 [
0 => "Tile"
1 => "Hardwood"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1591780"
+"ListOfficeKey": "255674"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Ravine"
]
+"LotSizeDimensions": "50.1 x 122.5 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-16T20:42:05Z"
+"PhotosCount": 30
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T20:42:05Z"
+"StreetName": "Wharf"
+"StreetNumber": "1304"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "6544"
+"WaterBodyName": "Lake Ontario"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Bay Ridges"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29912296/1304-wharf-street-pickering-bay-ridges-bay-ridges"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1413528"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "86922"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"PropertyCondition": array:1 [
0 => "Insulation upgraded"
]
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"WaterfrontFeatures": array:1 [
0 => "Waterfront"
]
+"FrontageLengthNumeric": 50.1
+"OriginalEntryTimestamp": "2026-06-16T20:42:05.01Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1154167"
+"ListOfficeNationalAssociationId": "1211511"
+"CoListAgentNationalAssociationId": "1048895"
+"CoListOfficeNationalAssociationId": "1148953"
+"Media": array:30 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29912296')"
+"ID": "1536941"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25166
+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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29912779')"
+"ID": "1536942"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23376
+post_id: "1534041"
+post_author: 1
+"ListingKey": "29908997"
+"ListingId": "E13449914"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T15:10:12Z"
+"RFModificationTimestamp": "2026-06-16T15:12:43Z"
+"ListPrice": 2499000.0
+"BathroomsTotalInteger": 6.0
+"BathroomsHalf": 1
+"BedroomsTotal": 8.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Pickering (Dunbarton)"
+"PostalCode": "L1V1T7"
+"UnparsedAddress": "1879 APPLEVIEW ROAD, Pickering (Dunbarton), Ontario L1V1T7"
+"Coordinates": array:2 [
0 => -79.1076799
1 => 43.8348
]
+"Latitude": 43.8348
+"Longitude": -79.1076799
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Central Lakes Association of REALTORS®"
+"PublicRemarks": "Rare opportunity to own a custom-built executive home in Pickering's highly sought-after Dunbarton community, offering over 5,000 sq. ft. of finished living space, exceptional flexibility, and outstanding income potential. Whether you're searching for a multigenerational home, an investment opportunity, or luxury living with space for the whole family, this property checks every box. The open-concept main level features a spectacular great room with soaring 20-foot ceilings, a gas fireplace, and expansive upper-level views that fill the home with natural light. The custom kitchen boasts granite countertops, quality cabinetry, and generous workspace, while the main-floor primary suite provides convenience rarely found in homes of this size. A spacious loft above the triple-car garage offers endless possibilities as a home office, gym, media room, or studio. Adding tremendous value are two self-contained basement apartments with separate entrances and walkout access. Offering one 1-bedroom suite and one 2-bedroom suite, both complete with kitchens and bathrooms, this home is perfectly suited for extended family, nanny accommodations, or significant rental income potential.Designed with accessibility in mind, the home features an elevator servicing every level, wider hallways and doorways, and ramp access, making it ideal for aging in place or mobility-conscious buyers. Situated on an impressive approximately 66 x 200 ft lot, the property offers a rare 3-car garage, parking for up to 13 vehicles, and a 50-amp exterior RV plug. Conveniently located close to top-rated schools, parks, shopping, transit, Highway 401, and GO Transit, this is a unique opportunity to own one of Pickering's most versatile luxury homes in one of its most desirable neighbourhoods. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Garage door opener"
]
+"Basement": array:8 [
0 => "Finished"
1 => "Apartment in basement"
2 => "Separate entrance"
3 => "Walk out"
4 => "N/A"
5 => "N/A"
6 => "N/A"
7 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T15:12:40.286098+00:00"
+"Directions": "Cross Streets: Appleview Rd & Fairport Rd. ** Directions: From Fairport Rd., head east on Appleview Rd. to #1879 (north side)."
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2242933"
+"ListOfficeKey": "280442"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Wheelchair access"
1 => "Carpet Free"
2 => "In-Law Suite"
]
+"LotSizeDimensions": "66 x 200 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-16T14:19:59Z"
+"PhotosCount": 26
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T15:01:27Z"
+"Stories": "2.0"
+"StreetName": "Appleview"
+"StreetNumber": "1879"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "13682"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:18 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
]
+"ListAOR": "Central Lakes"
+"CityRegion": "Dunbarton"
+"ListAORKey": "88"
+"ListingURL": "www.realtor.ca/real-estate/29908997/1879-appleview-road-pickering-dunbarton-dunbarton"
+"ParkingTotal": 13
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1480822"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "280442"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 3500
+"LivingAreaMinimum": 3000
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 3
+"FrontageLengthNumeric": 66.0
+"OriginalEntryTimestamp": "2026-06-16T14:19:59.09Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1481050"
+"ListOfficeNationalAssociationId": "1313917"
+"CoListAgentNationalAssociationId": "1132125"
+"CoListOfficeNationalAssociationId": "1313917"
+"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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29908997')"
+"ID": "1534041"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25174
+post_id: "1531888"
+post_author: 1
+"ListingKey": "29906907"
+"ListingId": "E13447910"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T22:15:05Z"
+"RFModificationTimestamp": "2026-06-15T22:20:34Z"
+"ListPrice": 749000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Pickering (Liverpool)"
+"PostalCode": "L1V0C9"
+"UnparsedAddress": "10 - 1299 GLENANNA ROAD, Pickering (Liverpool), Ontario L1V0C9"
+"Coordinates": array:2 [
0 => -79.092097
1 => 43.838355
]
+"Latitude": 43.838355
+"Longitude": -79.092097
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 1299 Glenanna Road Unit 10! This bright and well-maintained 3-bedroom, 3-bathroom freehold townhome sits in one of Pickering's best locations. One of the largest units in the complex at 1,954 square feet! Just minutes from Pickering Town Centre, Hwy 401, Pickering GO Station, grocery stores, restaurants, and everyday essentials, this home offers exceptional accessibility in a sought-after neighbourhood. Step inside to a welcoming foyer with soaring ceilings & a functional, open-concept layout that feels both spacious & inviting. The main level features a versatile living space with laminate flooring throughout, highlighted by a large front window that fills the home with natural light. A convenient main-floor powder room completes the space. The second floor features hardwood flooring throughout and serves as the heart of the home. It offers a spacious kitchen with stainless steel appliances and a walkout to a generous-sized deck-perfect for morning coffee, BBQs, or relaxing outdoors. An excellent balance of open space for entertaining and comfortable day-to-day living. Oversized windows throughout. On the top level, you'll find three spacious bedrooms, including a primary suite complete with a private 4-piece ensuite bath. Enjoy outdoor living with a charming rear garden space, featuring a small storage shed-ideal for keeping gardening tools & seasonal items neatly tucked away. Children's park located directly across from your unit-just steps from your front door. Single-car garage with direct entry to the house and shows true pride of ownership throughout. Spacious unfinished basement. Multiple front/back entrances. Central Vacuum rough-in. Where else can you find a spacious 1,954 square-foot townhome in one of the best pockets in Pickering for just $749,000? That's roughly $383 per square foot, which is exceptional value compared to many condo apartments and detached homes in the area. Perfect for anybody looking for a blend of comfort, space & value. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Oven"
5 => "Dryer"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Water Heater"
]
+"AssociationFee": "203.78"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Parcel of Tied Land"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T22:20:27.789973+00:00"
+"Directions": "Cross Streets: Kingston Road and Liverpool Road. ** Directions: North on Glenanna, Left into townhouse complex."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:4 [
0 => "Tile"
1 => "Hardwood"
2 => "Laminate"
3 => "Carpeted"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2098638"
+"ListOfficeKey": "50570"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Irregular lot size"
1 => "Sump Pump"
]
+"LotSizeDimensions": "20.5 x 78.9 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T21:42:03Z"
+"PhotosCount": 49
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T22:07:17Z"
+"Stories": "3.0"
+"StreetName": "Glenanna"
+"StreetNumber": "1299"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "5887.26"
+"VirtualTourURLUnbranded": "https://winsold.com/matterport/embed/454269/h387MoJWdib"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Liverpool"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29906907/10-1299-glenanna-road-pickering-liverpool-liverpool"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2078606"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "50570"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 20.6
+"OriginalEntryTimestamp": "2026-06-15T21:42:02.98Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1368953"
+"ListOfficeNationalAssociationId": "1002989"
+"CoListAgentNationalAssociationId": "1353484"
+"CoListOfficeNationalAssociationId": "1002989"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29906907')"
+"ID": "1531888"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25175
+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"
}
]
+success: true
+page_size: 9
+page_count: 17
+count: 148
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]