array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 28089973/Property?$select=ALL&$top=20&$filter=ListingKey eq 28089973&$expand=Office,Member,Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 28089973/Property?$select=ALL&$top=20&$filter=ListingKey eq 28089973&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23512
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23514
+post_id: "342736"
+post_author: 1
+"ListingKey": "28089973"
+"ListingId": "40711412"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-09-03T16:25:50Z"
+"RFModificationTimestamp": "2025-09-21T05:05:09Z"
+"ListPrice": 1888800.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 3400.0
+"BuildingAreaTotal": 0
+"City": "Niagara-on-the-Lake"
+"PostalCode": "L0S1J0"
+"UnparsedAddress": "915 QUEENSTON Road, Niagara-on-the-Lake, Ontario L0S1J0"
+"Coordinates": array:2 [
0 => -79.12814808
1 => 43.16479393
]
+"Latitude": 43.16479393
+"Longitude": -79.12814808
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of Realtors"
+"PublicRemarks": "Luxurious NOTL Estate Home with stunning features, discover your dream home in the exquisite 3400 sqft estate situated on and almost 1 acre lot. This remarkable property boasts a gourmet kitchen, a sunken family room with a cozy fireplace, and separate living and dining rooms adorned with built-in shelving and an additional fireplace. Enhance your entertaining experience with a chic bar area, while the office, complete with built-in bookshelves, offers a perfect space for work. Practicality meets elegance in the mudroom and laundry area. Retreat to the master bedroom, featuring a luxurioius 5pc ensuite and a spacious walk-in closet. The home also includes a guest room with an ensuite 4pc bathroom, and a third bedroom, providing ample space for family and friends. Outside enjoy the fenced inground pool and soak in the breathtaking views of the surrounding vineyards and wineries. Relax on the covered patio, complete with double sized hot-tub, and fully immerse yourself in the beauty and tranquility of this stunning estate. Walk to the village of St. David's and local wineries and a short drive to NOTL Old Town. Niagara Falls and St. Catharines nearby, US border minutes away. (id:62650)"
+"Appliances": array:2 [
0 => "Central Vacuum"
1 => "Oven - Built-In"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-03-29T13:17:51.560122+00:00"
+"Directions": "York Street to Queenston Road"
+"ExteriorFeatures": array:1 [
0 => "Other"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1618273"
+"ListOfficeKey": "55078"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Paved driveway"
1 => "Country residential"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-09-03T16:22:26Z"
+"PhotosCount": 46
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-09-03T16:22:26Z"
+"Stories": "2.0"
+"StreetName": "QUEENSTON"
+"StreetNumber": "915"
+"StreetSuffix": "Road"
+"SubdivisionName": "105 - St. Davids"
+"TaxAnnualAmount": "7018.44"
+"VirtualTourURLUnbranded": "https://youtu.be/IRQNJsLjCfw"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
0 => array:11 [
"RoomKey" => "1487132749"
"RoomType" => "4pc Bathroom"
"ListingId" => "40711412"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "28089973"
"RoomLength" => null
"RoomDimensions" => "9'8'' x 14'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-09-03T16:22:26.56Z"
]
1 => array:11 [
"RoomKey" => "1487132750"
"RoomType" => "Bedroom"
"ListingId" => "40711412"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "28089973"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 17'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-09-03T16:22:26.56Z"
]
2 => array:11 [
"RoomKey" => "1487132751"
"RoomType" => "4pc Bathroom"
"ListingId" => "40711412"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "28089973"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 6'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-09-03T16:22:26.56Z"
]
3 => array:11 [
"RoomKey" => "1487132752"
"RoomType" => "Bedroom"
"ListingId" => "40711412"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "28089973"
"RoomLength" => null
"RoomDimensions" => "13'1'' x 13'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-09-03T16:22:26.57Z"
]
4 => array:11 [
"RoomKey" => "1487132753"
"RoomType" => "5pc Bathroom"
"ListingId" => "40711412"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "28089973"
"RoomLength" => null
"RoomDimensions" => "14'4'' x 14'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-09-03T16:22:26.57Z"
]
5 => array:11 [
"RoomKey" => "1487132754"
"RoomType" => "Primary Bedroom"
"ListingId" => "40711412"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "28089973"
"RoomLength" => null
"RoomDimensions" => "14'2'' x 23'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-09-03T16:22:26.57Z"
]
6 => array:11 [
"RoomKey" => "1487132755"
"RoomType" => "Office"
"ListingId" => "40711412"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "28089973"
"RoomLength" => null
"RoomDimensions" => "13'0'' x 9'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-09-03T16:22:26.57Z"
]
7 => array:11 [
"RoomKey" => "1487132756"
"RoomType" => "Foyer"
"ListingId" => "40711412"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "28089973"
"RoomLength" => null
"RoomDimensions" => "11'10'' x 14'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-09-03T16:22:26.57Z"
]
8 => array:11 [
"RoomKey" => "1487132757"
"RoomType" => "2pc Bathroom"
"ListingId" => "40711412"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "28089973"
"RoomLength" => null
"RoomDimensions" => "7'4'' x 4'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-09-03T16:22:26.57Z"
]
9 => array:11 [
"RoomKey" => "1487132758"
"RoomType" => "Living room"
"ListingId" => "40711412"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "28089973"
"RoomLength" => null
"RoomDimensions" => "11'10'' x 15'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-09-03T16:22:26.57Z"
]
10 => array:11 [
"RoomKey" => "1487132759"
"RoomType" => "Dining room"
"ListingId" => "40711412"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "28089973"
"RoomLength" => null
"RoomDimensions" => "24'4'' x 18'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-09-03T16:22:26.57Z"
]
11 => array:11 [
"RoomKey" => "1487132760"
"RoomType" => "Kitchen"
"ListingId" => "40711412"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "28089973"
"RoomLength" => null
"RoomDimensions" => "10'11'' x 22'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-09-03T16:22:26.57Z"
]
12 => array:11 [
"RoomKey" => "1487132761"
"RoomType" => "Family room"
"ListingId" => "40711412"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "28089973"
"RoomLength" => null
"RoomDimensions" => "14'4'' x 20'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-09-03T16:22:26.57Z"
]
13 => array:11 [
"RoomKey" => "1487132762"
"RoomType" => "Other"
"ListingId" => "40711412"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "28089973"
"RoomLength" => null
"RoomDimensions" => "7'6'' x 13'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-09-03T16:22:26.57Z"
]
14 => array:11 [
"RoomKey" => "1487132763"
"RoomType" => "Laundry room"
"ListingId" => "40711412"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "28089973"
"RoomLength" => null
"RoomDimensions" => "8'0'' x 7'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-09-03T16:22:26.57Z"
]
15 => array:11 [
"RoomKey" => "1487132764"
"RoomType" => "3pc Bathroom"
"ListingId" => "40711412"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "28089973"
"RoomLength" => null
"RoomDimensions" => "8'0'' x 5'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-09-03T16:22:26.58Z"
]
16 => array:11 [
"RoomKey" => "1487132765"
"RoomType" => "Mud room"
"ListingId" => "40711412"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "28089973"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 21'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-09-03T16:22:26.58Z"
]
]
+"ListAOR": "Cornerstone - Hamilton-Burlington"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/28089973/915-queenston-road-niagara-on-the-lake"
+"ParkingTotal": 7
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"ZoningDescription": "A2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 200.0
+"AboveGradeFinishedArea": 3400
+"OriginalEntryTimestamp": "2025-03-28T21:16:24.49Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"Media": array:46 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6150417882"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28089973/83efd07c29bd5195caed85eec59c7e3a.webp"
"MediaSize" => 95839
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28089973/thumbnail-83efd07c29bd5195caed85eec59c7e3a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40711412"
"ResourceRecordKey" => "28089973"
"ModificationTimestamp" => "2025-09-03T16:12:15.48Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6150417923"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28089973/566073d19ffde0eb14fe0ec659eca6c0.webp"
"MediaSize" => 131987
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28089973/thumbnail-566073d19ffde0eb14fe0ec659eca6c0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40711412"
"ResourceRecordKey" => "28089973"
"ModificationTimestamp" => "2025-09-03T16:12:13.88Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6150417951"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28089973/0e5601ed22e1effd033ab49d034af56d.webp"
"MediaSize" => 128925
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28089973/thumbnail-0e5601ed22e1effd033ab49d034af56d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40711412"
"ResourceRecordKey" => "28089973"
"ModificationTimestamp" => "2025-09-03T16:12:15.48Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6150417970"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28089973/44698d7ad7472ad7e1f9b8ad50f54a79.webp"
"MediaSize" => 128887
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28089973/thumbnail-44698d7ad7472ad7e1f9b8ad50f54a79.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40711412"
"ResourceRecordKey" => "28089973"
"ModificationTimestamp" => "2025-09-03T16:12:16.55Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6150418018"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28089973/08e88537ff7945e95242cee8ca0b5cc9.webp"
"MediaSize" => 122343
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28089973/thumbnail-08e88537ff7945e95242cee8ca0b5cc9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40711412"
"ResourceRecordKey" => "28089973"
"ModificationTimestamp" => "2025-09-03T16:12:15.48Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6150418050"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28089973/39c6d37ef4fa824e2712a74acc891a32.webp"
"MediaSize" => 158143
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28089973/thumbnail-39c6d37ef4fa824e2712a74acc891a32.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40711412"
"ResourceRecordKey" => "28089973"
"ModificationTimestamp" => "2025-09-03T16:12:13.88Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6150418079"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28089973/aebdebef13029ceeaf297e71643242ae.webp"
"MediaSize" => 163484
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28089973/thumbnail-aebdebef13029ceeaf297e71643242ae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of yard with a view of vineyards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40711412"
"ResourceRecordKey" => "28089973"
"ModificationTimestamp" => "2025-09-03T16:12:15.47Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6150418117"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28089973/30e6f5275baca93d14954c172a512e6e.webp"
"MediaSize" => 136150
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28089973/thumbnail-30e6f5275baca93d14954c172a512e6e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40711412"
"ResourceRecordKey" => "28089973"
"ModificationTimestamp" => "2025-09-03T16:12:15.48Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6150418142"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28089973/04ed83fc3ea2f26927e550f733b28980.webp"
"MediaSize" => 143638
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28089973/thumbnail-04ed83fc3ea2f26927e550f733b28980.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40711412"
"ResourceRecordKey" => "28089973"
"ModificationTimestamp" => "2025-09-03T16:12:17.61Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6150418170"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28089973/f091a0d10fa65bd094f6f5138f154348.webp"
"MediaSize" => 162723
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28089973/thumbnail-f091a0d10fa65bd094f6f5138f154348.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40711412"
"ResourceRecordKey" => "28089973"
"ModificationTimestamp" => "2025-09-03T16:12:15.48Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6150418204"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28089973/e9ec83500d24b83a4d82fdc1c6687b3c.webp"
"MediaSize" => 117351
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28089973/thumbnail-e9ec83500d24b83a4d82fdc1c6687b3c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Porch with a lawn"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40711412"
"ResourceRecordKey" => "28089973"
"ModificationTimestamp" => "2025-09-03T16:12:16.56Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6150418229"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28089973/b68a6d6fc54e46e8d86bb1c23eab3a1c.webp"
"MediaSize" => 81198
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28089973/thumbnail-b68a6d6fc54e46e8d86bb1c23eab3a1c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40711412"
"ResourceRecordKey" => "28089973"
"ModificationTimestamp" => "2025-09-03T16:12:15.47Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6150418264"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28089973/1d20e4e3f1de32da17ce00f29b929331.webp"
"MediaSize" => 125777
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28089973/thumbnail-1d20e4e3f1de32da17ce00f29b929331.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40711412"
"ResourceRecordKey" => "28089973"
"ModificationTimestamp" => "2025-09-03T16:12:15.48Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6150418275"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28089973/a655dbf23f52e3199091526a659ab29a.webp"
"MediaSize" => 84862
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28089973/thumbnail-a655dbf23f52e3199091526a659ab29a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40711412"
"ResourceRecordKey" => "28089973"
"ModificationTimestamp" => "2025-09-03T16:12:17.61Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6150418306"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28089973/ac899a04ddf78d86e38ee1d33be54c82.webp"
"MediaSize" => 95486
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28089973/thumbnail-ac899a04ddf78d86e38ee1d33be54c82.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40711412"
"ResourceRecordKey" => "28089973"
"ModificationTimestamp" => "2025-09-03T16:12:17.61Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6150418332"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28089973/7445174924976e48827ae95283eb8394.webp"
"MediaSize" => 91881
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28089973/thumbnail-7445174924976e48827ae95283eb8394.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40711412"
"ResourceRecordKey" => "28089973"
"ModificationTimestamp" => "2025-09-03T16:12:17.61Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6150418355"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28089973/f710af8ee92a13b4a4747ae236d18f5d.webp"
"MediaSize" => 94124
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28089973/thumbnail-f710af8ee92a13b4a4747ae236d18f5d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40711412"
"ResourceRecordKey" => "28089973"
"ModificationTimestamp" => "2025-09-03T16:12:15.48Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6150418386"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28089973/4d8368e977d2b77dc083a2124da45b27.webp"
"MediaSize" => 102121
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28089973/thumbnail-4d8368e977d2b77dc083a2124da45b27.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40711412"
"ResourceRecordKey" => "28089973"
"ModificationTimestamp" => "2025-09-03T16:12:16.55Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6150418449"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28089973/625c149db8aa74a3098e922304ac303f.webp"
"MediaSize" => 106486
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28089973/thumbnail-625c149db8aa74a3098e922304ac303f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40711412"
"ResourceRecordKey" => "28089973"
"ModificationTimestamp" => "2025-09-03T16:12:13.88Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6150418478"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28089973/d8f4d6936eaaa118afafdc365a15563a.webp"
"MediaSize" => 101500
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28089973/thumbnail-d8f4d6936eaaa118afafdc365a15563a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40711412"
"ResourceRecordKey" => "28089973"
"ModificationTimestamp" => "2025-09-03T16:12:17.61Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6150418519"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28089973/bb8869e691c5f614b2d2def55e593844.webp"
"MediaSize" => 114569
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28089973/thumbnail-bb8869e691c5f614b2d2def55e593844.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40711412"
"ResourceRecordKey" => "28089973"
"ModificationTimestamp" => "2025-09-03T16:12:16.56Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6150418533"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28089973/66819069d85c3f7d460cbc7362bbb8b5.webp"
"MediaSize" => 90406
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28089973/thumbnail-66819069d85c3f7d460cbc7362bbb8b5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40711412"
"ResourceRecordKey" => "28089973"
"ModificationTimestamp" => "2025-09-03T16:12:15.48Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6150418549"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28089973/e62e5349365fe4010068d223a24da7dc.webp"
"MediaSize" => 85436
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28089973/thumbnail-e62e5349365fe4010068d223a24da7dc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area with wood-type flooring, a stone fireplace, french doors, ceiling fan, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40711412"
"ResourceRecordKey" => "28089973"
"ModificationTimestamp" => "2025-09-03T16:12:17.62Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6150418570"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28089973/4944e7be985cfd2999fffc7ca4f4a052.webp"
"MediaSize" => 83185
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28089973/thumbnail-4944e7be985cfd2999fffc7ca4f4a052.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area featuring plenty of natural light, wood finished floors, a fireplace, a tray ceiling, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40711412"
"ResourceRecordKey" => "28089973"
"ModificationTimestamp" => "2025-09-03T16:12:17.62Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6150418594"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28089973/0bf1a08c421deef49ee56d8709e46511.webp"
"MediaSize" => 75127
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28089973/thumbnail-0bf1a08c421deef49ee56d8709e46511.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40711412"
"ResourceRecordKey" => "28089973"
"ModificationTimestamp" => "2025-09-03T16:12:17.62Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6150418610"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28089973/27ad1fd4eecbaa0f6ecf75a0ffb69211.webp"
"MediaSize" => 72063
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28089973/thumbnail-27ad1fd4eecbaa0f6ecf75a0ffb69211.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40711412"
"ResourceRecordKey" => "28089973"
"ModificationTimestamp" => "2025-09-03T16:12:15.48Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6150418630"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28089973/b4626ee57f13b4d11e16bc670ced3272.webp"
"MediaSize" => 91943
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28089973/thumbnail-b4626ee57f13b4d11e16bc670ced3272.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40711412"
"ResourceRecordKey" => "28089973"
"ModificationTimestamp" => "2025-09-03T16:12:16.56Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6150418657"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28089973/704402f445b083dfa088bda3d7c72de2.webp"
"MediaSize" => 76329
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28089973/thumbnail-704402f445b083dfa088bda3d7c72de2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40711412"
"ResourceRecordKey" => "28089973"
"ModificationTimestamp" => "2025-09-03T16:12:16.56Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6150418691"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28089973/ccb2e01f67838f0a53cd149b72f1d6af.webp"
"MediaSize" => 113741
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28089973/thumbnail-ccb2e01f67838f0a53cd149b72f1d6af.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40711412"
"ResourceRecordKey" => "28089973"
"ModificationTimestamp" => "2025-09-03T16:12:17.61Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6150418705"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28089973/521ba1481b3fb2871d984451f245ea13.webp"
"MediaSize" => 99543
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28089973/thumbnail-521ba1481b3fb2871d984451f245ea13.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40711412"
"ResourceRecordKey" => "28089973"
"ModificationTimestamp" => "2025-09-03T16:12:16.55Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6150418718"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28089973/3a29f1476eacd820c8ccae9669147b69.webp"
"MediaSize" => 113125
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28089973/thumbnail-3a29f1476eacd820c8ccae9669147b69.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40711412"
"ResourceRecordKey" => "28089973"
"ModificationTimestamp" => "2025-09-03T16:12:17.61Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6150418740"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28089973/6849be3f93052ccd92ae9351bdc5adc7.webp"
"MediaSize" => 92303
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28089973/thumbnail-6849be3f93052ccd92ae9351bdc5adc7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40711412"
"ResourceRecordKey" => "28089973"
"ModificationTimestamp" => "2025-09-03T16:12:16.57Z"
]
32 => array:13 [
"Order" => 32
"MediaKey" => "6150418746"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28089973/d164497b0f2da7c066f5b3a8143fb962.webp"
"MediaSize" => 85550
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28089973/thumbnail-d164497b0f2da7c066f5b3a8143fb962.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40711412"
"ResourceRecordKey" => "28089973"
"ModificationTimestamp" => "2025-09-03T16:12:16.55Z"
]
33 => array:13 [
"Order" => 33
"MediaKey" => "6150418766"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28089973/29c98723017cf17414c0e361dc0680fb.webp"
"MediaSize" => 90827
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28089973/thumbnail-29c98723017cf17414c0e361dc0680fb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40711412"
"ResourceRecordKey" => "28089973"
"ModificationTimestamp" => "2025-09-03T16:12:17.61Z"
]
34 => array:13 [
"Order" => 34
"MediaKey" => "6150418772"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28089973/4ab8179079bf0ea6ab1a7a1e05e81799.webp"
"MediaSize" => 83940
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28089973/thumbnail-4ab8179079bf0ea6ab1a7a1e05e81799.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40711412"
"ResourceRecordKey" => "28089973"
"ModificationTimestamp" => "2025-09-03T16:12:16.55Z"
]
35 => array:13 [
"Order" => 35
"MediaKey" => "6150418785"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28089973/ddfb1cffcf86e4b040fe2ea3ba6d6aa6.webp"
"MediaSize" => 112110
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28089973/thumbnail-ddfb1cffcf86e4b040fe2ea3ba6d6aa6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40711412"
"ResourceRecordKey" => "28089973"
"ModificationTimestamp" => "2025-09-03T16:12:16.57Z"
]
36 => array:13 [
"Order" => 36
"MediaKey" => "6150418801"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28089973/41e5e15299e4db01e734940ce21225f6.webp"
"MediaSize" => 114529
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28089973/thumbnail-41e5e15299e4db01e734940ce21225f6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40711412"
"ResourceRecordKey" => "28089973"
"ModificationTimestamp" => "2025-09-03T16:12:17.63Z"
]
37 => array:13 [
"Order" => 37
"MediaKey" => "6150418827"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28089973/f6ac7f97dabb222881b3b8a585fb28e9.webp"
"MediaSize" => 63758
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28089973/thumbnail-f6ac7f97dabb222881b3b8a585fb28e9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40711412"
"ResourceRecordKey" => "28089973"
"ModificationTimestamp" => "2025-09-03T16:12:15.47Z"
]
38 => array:13 [
"Order" => 38
"MediaKey" => "6150418845"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28089973/e5cd5471f250a79332b3b52fb93a7300.webp"
"MediaSize" => 63929
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28089973/thumbnail-e5cd5471f250a79332b3b52fb93a7300.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40711412"
"ResourceRecordKey" => "28089973"
"ModificationTimestamp" => "2025-09-03T16:12:17.62Z"
]
39 => array:13 [
"Order" => 39
"MediaKey" => "6150418861"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28089973/64f173fb17babba29a15f21f47182c28.webp"
"MediaSize" => 55051
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28089973/thumbnail-64f173fb17babba29a15f21f47182c28.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40711412"
"ResourceRecordKey" => "28089973"
"ModificationTimestamp" => "2025-09-03T16:12:16.53Z"
]
40 => array:13 [
"Order" => 40
"MediaKey" => "6150418891"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28089973/c20a7b32f641f9351ae022be0992a823.webp"
"MediaSize" => 53013
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28089973/thumbnail-c20a7b32f641f9351ae022be0992a823.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40711412"
"ResourceRecordKey" => "28089973"
"ModificationTimestamp" => "2025-09-03T16:12:16.56Z"
]
41 => array:13 [
"Order" => 41
"MediaKey" => "6150418903"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28089973/a77425f409f4b30d0fc6d941c7a9c9c1.webp"
"MediaSize" => 187987
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28089973/thumbnail-a77425f409f4b30d0fc6d941c7a9c9c1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40711412"
"ResourceRecordKey" => "28089973"
"ModificationTimestamp" => "2025-09-03T16:12:16.57Z"
]
42 => array:13 [
"Order" => 42
"MediaKey" => "6150418917"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28089973/5b92a607a94e2be8d32454a7b9691d04.webp"
"MediaSize" => 201930
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28089973/thumbnail-5b92a607a94e2be8d32454a7b9691d04.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40711412"
"ResourceRecordKey" => "28089973"
"ModificationTimestamp" => "2025-09-03T16:12:16.56Z"
]
43 => array:13 [
"Order" => 43
"MediaKey" => "6150418931"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28089973/e233ab3aa62e9a437c7cfd42ed8df722.webp"
"MediaSize" => 180752
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28089973/thumbnail-e233ab3aa62e9a437c7cfd42ed8df722.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40711412"
"ResourceRecordKey" => "28089973"
"ModificationTimestamp" => "2025-09-03T16:12:17.61Z"
]
44 => array:13 [
"Order" => 44
"MediaKey" => "6150418946"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28089973/2bbf389b2051c2c658fc01f354800307.webp"
"MediaSize" => 184134
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28089973/thumbnail-2bbf389b2051c2c658fc01f354800307.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40711412"
"ResourceRecordKey" => "28089973"
"ModificationTimestamp" => "2025-09-03T16:12:17.61Z"
]
45 => array:13 [
"Order" => 45
"MediaKey" => "6150418957"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28089973/fe72413b03cc4a7534af57153687915a.webp"
"MediaSize" => 187377
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28089973/thumbnail-fe72413b03cc4a7534af57153687915a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40711412"
"ResourceRecordKey" => "28089973"
"ModificationTimestamp" => "2025-09-03T16:12:17.61Z"
]
]
+"Member": array:1 [
0 => array:23 [
"MemberFullName" => "John Bald"
"MemberFirstName" => "John"
"MemberLastName" => "Bald"
"MemberMlsId" => "HBBALDJO"
"OriginatingSystemName" => 26
"MemberKey" => "1618273"
"ModificationTimestamp" => "2025-10-28T23:10:12Z"
"MemberMiddleName" => "A"
"MemberStatus" => "Active"
"OfficeKey" => "55078"
"MemberAOR" => "Cornerstone - Hamilton-Burlington"
"Media" => array:1 [ …1]
"JobTitle" => "Broker"
"MemberCity" => "Grimsby"
"MemberType" => "Broker"
"MemberAORKey" => "14"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberOfficePhone" => "905-984-1110"
"MemberSocialMedia" => array:1 [ …1]
"MemberStateOrProvince" => "Ontario"
"MemberNationalAssociationId" => "1303889"
"OfficeNationalAssociationId" => "1003665"
]
]
+"Office": array:1 [
0 => array:21 [
"OfficeName" => "Royal LePage NRC Realty Inc."
"OfficePhone" => "905-945-1234"
"OfficeMlsId" => "HBRLPNRCRLTY"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "55078"
"ModificationTimestamp" => "2025-12-09T16:07:06Z"
"OfficeAddress1" => "41 Main Street West"
"OfficeCity" => "Grimsby"
"OfficePostalCode" => "L3R1R"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Cornerstone"
"Media" => array:1 [ …1]
"OfficeType" => "Firm"
"OfficeAORKey" => "14"
"OfficeCountry" => "Canada"
"OfficeSocialMedia" => array:1 [ …1]
"OfficeNationalAssociationId" => "1003665"
"FranchiseNationalAssociationId" => "1146708"
"OfficeBrokerNationalAssociationId" => "1245523"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('28089973')"
+"ID": "342736"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 55078/Office?$select=ALL&$top=10&$filter=OfficeKey eq 55078&$expand=Office,Member,Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 55078/Office?$select=ALL&$top=10&$filter=OfficeKey eq 55078&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25370
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25372
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "Royal LePage NRC Realty Inc."
+"OfficeEmail": null
+"OfficePhone": "905-945-1234"
+"OfficeMlsId": "HBRLPNRCRLTY"
+"ModificationTimestamp": "2025-12-09T16:07:06Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "55078"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "41 Main Street West"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Grimsby"
+"OfficePostalCode": "L3R1R"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1003665"
+"OriginalEntryTimestamp": null
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "452697"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "55078"
"SocialMediaUrlOrId" => "https://www.nrcrealty.ca/"
"ModificationTimestamp" => "2025-12-09T15:07:00Z"
]
]
+"FranchiseNationalAssociationId": "1146708"
+"OfficeBrokerNationalAssociationId": "1245523"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('55078')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1618273/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1618273&$expand=Office,Member,Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1618273/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1618273&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25375
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq 28089973" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24985
+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 28089973/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 28089973&$expand=Office,Member,Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 28089973/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 28089973&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24965
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 28089973 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.12814808 43.16479393)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 28089973 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.12814808 43.16479393)) le 2000m&$expand=Office,Member,Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 28089973 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.12814808 43.16479393)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 28089973 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.12814808 43.16479393)) le 2000m&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25219
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24907
+post_id: "486771"
+post_author: 1
+"ListingKey": "29192083"
+"ListingId": "X12638870"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-19T15:10:25Z"
+"RFModificationTimestamp": "2025-12-19T15:13:08Z"
+"ListPrice": 994900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Niagara-on-the-Lake (St. Davids)"
+"PostalCode": "L0S1J1"
+"UnparsedAddress": "17 STONERIDGE CRESCENT, Niagara-on-the-Lake (St. Davids), Ontario L0S1J1"
+"Coordinates": array:2 [
0 => -79.1059472
1 => 43.160704
]
+"Latitude": 43.160704
+"Longitude": -79.1059472
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Niagara Association of REALTORS®"
+"PublicRemarks": "A LUXURIOUS RETREAT! Pride of ownership definitely shows as you tour this previous "model home" owned by only one owner! Upon entering this exquisite freehold townhouse, you are struck by the high ceilings which help to create an airy & spacious atmosphere! Natural light is maximized by the 2 Velux skylights and solar tube. The open-concept floorplan encourages entertaining your guests or enjoying quiet evenings in front of the gas fireplace. High-end finishes reflect quality & craftsmanship throughout! The gourmet kitchen area is equipped with lots of storage in the upgraded cabinets with glass doors. The solar tube highlights the quartz counters & custom hood fan. The functional island incl a Bristol undermount sink & new dishwasher. The multi-functional kitchen overlooks the formal dining area & great rm which leads to a private deck to enjoy the island with fountain & clusters of beautiful decorative trees! The lot extends beyond the fenced area & backs onto the ravine & conservation area. Size of the yard allows owners to plant herbs or a vegetable garden! This oasis allows a total escape from everyday hustle! The primary bdrm suite offers a large bedroom with attractive shutters, walk-in closet & ensuite featuring double sinks & a linen closet. The den or 2nd bedroom features an upgrade to Geneva black leather plank flooring! The spacious lower level with lots of lighting could easily accommodate a family member in the potential "in-law suite". A uniquely designed contemporary unit is mounted below the TV. The 3rd large bedroom includes a walk in closet & is next to the 4pc bathroom. This stunning elegant townhouse is a lifestyle choice & offers luxury & FREEDOM! This home is ready to move into, close to resturants, shopping, hospitals, wine routes, trails, NOTL, Shaw Festival, St. Catharines, airports, and QEW. Make it your choice -------SOON !!!! (id:62650)"
+"Appliances": array:4 [
0 => "Water softener"
1 => "Garage door opener remote(s)"
2 => "Water Heater - Tankless"
3 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Partial"
]
+"Cooling": array:2 [
0 => "Central air conditioning"
1 => "Air exchanger"
]
+"CreationDate": "2025-12-17T19:41:36.329662+00:00"
+"Directions": "Cross Streets: York Road, Tanbark Road, Stoneridge Cres. ** Directions: Stoneridge."
+"ExteriorFeatures": array:1 [
0 => "Stone"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2235722"
+"ListOfficeKey": "75381"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Irregular lot size"
1 => "Backs on greenbelt"
2 => "Conservation/green belt"
3 => "Guest Suite"
4 => "Sump Pump"
]
+"LotSizeDimensions": "35.3 x 189.5 FT ; 35.32FT x 176' x 40.73' x 8.63' x 189'"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2025-12-17T18:30:49Z"
+"PhotosCount": 34
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-19T14:55:44Z"
+"Stories": "1.0"
+"StreetName": "Stoneridge"
+"StreetNumber": "17"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "5674.64"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [
"RoomKey" => "1551285731"
"RoomType" => "Kitchen"
"ListingId" => "X12638870"
"RoomLevel" => "Main level"
"RoomWidth" => 5.3
"ListingKey" => "29192083"
"RoomLength" => 3.6
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-19T14:55:44.68Z"
]
1 => array:11 [
"RoomKey" => "1551285732"
"RoomType" => "Great room"
"ListingId" => "X12638870"
"RoomLevel" => "Main level"
"RoomWidth" => 6.0
"ListingKey" => "29192083"
"RoomLength" => 7.4
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-19T14:55:44.68Z"
]
2 => array:11 [
"RoomKey" => "1551285733"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12638870"
"RoomLevel" => "Main level"
"RoomWidth" => 4.7
"ListingKey" => "29192083"
"RoomLength" => 3.5
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-19T14:55:44.68Z"
]
3 => array:11 [
"RoomKey" => "1551285734"
"RoomType" => "Bedroom 2"
"ListingId" => "X12638870"
"RoomLevel" => "Main level"
…7
]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Niagara"
+"CityRegion": "105 - St. Davids"
+"ListAORKey": "114"
+"ListingURL": "www.realtor.ca/real-estate/29192083/17-stoneridge-crescent-niagara-on-the-lake-st-davids-105-st-davids"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "RS"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 35.3
+"OriginalEntryTimestamp": "2025-12-17T18:30:49Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:34 [
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]
]
+"Member": array:1 [
0 => array:20 [ …20]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29192083')"
+"ID": "486771"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24901
+post_id: "476005"
+post_author: 1
+"ListingKey": "29180488"
+"ListingId": "X12627780"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-13T17:40:59Z"
+"RFModificationTimestamp": "2025-12-13T17:42:03Z"
+"ListPrice": 1499800.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Niagara-on-the-Lake (Rural)"
+"PostalCode": "L0S1S0"
+"UnparsedAddress": "430 CONCESSION 7 ROAD, Niagara-on-the-Lake (Rural), Ontario L0S1S0"
+"Coordinates": array:2 [
0 => -79.1451721
1 => 43.1667099
]
+"Latitude": 43.1667099
+"Longitude": -79.1451721
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Niagara Association of REALTORS®"
+"PublicRemarks": "Every greenhouse entrepreneur starts somewhere; here is your start! A 5-acre country property in Niagara on the Lake with town water and gas. Current owners are retiring from the industry. Presently it has ten connected polycarbonate/poly houses for a total of approximately 32,873 square feet of growing facility with lots of room for expansion. Private gravel laneway and large parking area. Front and back side vents and roof vents, twelve gas unit heaters, boiler and propagation benches, aluminum benches and troughs, separate hydro meter, cistern and city water, natural gas generator. All ready to grow the crop of your choice for 2026 season. Also, a modest 3 + 2 bedroom bungalow with full dry basement and separate driveway. Replacement windows and new roof shingles. Eat in country kitchen with built in oven and stovetop. Bright living room with hardwood floors. 4-piece bathroom. Basement also has a rec room area, laundry and storage. 100-amp breakers forced air gas furnace, central air, sump pump. This property lends itself to a great garden center/market or any agricultural related venture of your dreams. Just minutes to all amenities, the QEW, Niagara College, etc. Start growing today! (id:62650)"
+"Appliances": array:3 [
0 => "Water meter"
1 => "Range"
2 => "Oven - Built-In"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-11T19:42:58.703416+00:00"
+"Directions": "NIAGARA STONE ROAD TO CONCESSION 7"
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1501265"
+"ListOfficeKey": "75354"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:6 [
0 => "Partially cleared"
1 => "Flat site"
2 => "Lane"
3 => "Level"
4 => "Country residential"
5 => "Sump Pump"
]
+"LotSizeDimensions": "256 x 830.4 FT"
+"ParkingFeatures": array:2 [
0 => "No Garage"
1 => "RV"
]
+"PhotosChangeTimestamp": "2025-12-13T17:22:19Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-13T17:22:19Z"
+"Stories": "1.0"
+"StreetName": "Concession 7"
+"StreetNumber": "430"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "2247.15"
+"Utilities": array:1 [
0 => "Electricity"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/h0qca_430_concession_7_rd_niagara_on_the_lake_on/"
+"WaterSource": array:2 [
0 => "Municipal water"
1 => "Cistern"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Niagara"
+"CityRegion": "104 - Rural"
+"ListAORKey": "114"
+"ListingURL": "www.realtor.ca/real-estate/29180488/430-concession-7-road-niagara-on-the-lake-rural-104-rural"
+"ParkingTotal": 10
+"StructureType": array:1 [
0 => "House"
]
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Separate Electricity Meters"
]
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"ZoningDescription": "A"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 256.0
+"OriginalEntryTimestamp": "2025-12-11T18:27:29.25Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29180488')"
+"ID": "476005"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24913
+post_id: "471044"
+post_author: 1
+"ListingKey": "29173490"
+"ListingId": "X12611982"
+"PropertyType": "Residential"
+"PropertySubType": "Vacant Land"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-09T14:30:17Z"
+"RFModificationTimestamp": "2025-12-09T17:15:51Z"
+"ListPrice": 895000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Lambton Shores (Arkona)"
+"PostalCode": "N0M1B0"
+"UnparsedAddress": "PT LT 24 CONCESSION 5, Lambton Shores (Arkona), Ontario N0M1B0"
+"Coordinates": array:2 [
0 => -79.121459
1 => 43.156893
]
+"Latitude": 43.156893
+"Longitude": -79.121459
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "London and St. Thomas Association of REALTORS®"
+"PublicRemarks": "Located just outside Arkona, this 47-acre parcel offers a balanced mix of productive land and natural setting. The farm includes 34 systematically tiled workable acres, ideal for expanding your land base or generating rental income. The remaining approximately 13 acres of mixed hardwood and softwood bush provide privacy, habitat, and a quiet backdrop for anyone considering a rural build.Set back from the road with gently rolling terrain, the property offers several suitable building locations, each with scenic views and a sense of seclusion. Whether you're looking for farmland, a potential building site, or both, this property is worth a closer look.Be sure to view the property video, and feel free to reach out with questions or to arrange a showing. (id:62650)"
+"CreationDate": "2025-12-09T17:15:30.853536+00:00"
+"Directions": "Cross Streets: Arkona Road and Birnam Line. ** Directions: Located on Hwy 79, South of Arkona. Driveway located on the West side of Arkona Road."
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1895602"
+"ListOfficeKey": "47253"
+"LotSizeDimensions": "66.16 x 2001.73 FT"
+"PhotosChangeTimestamp": "2025-12-09T14:22:24Z"
+"PhotosCount": 27
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-09T14:22:23Z"
+"StreetName": "24 Concession 5"
+"StreetNumber": "PT LT"
+"TaxAnnualAmount": "1349.29"
+"VirtualTourURLUnbranded": "https://www.myvisuallistings.com/vt/360885"
+"ListAOR": "London and St. Thomas"
+"CityRegion": "Arkona"
+"ListAORKey": "13"
+"ListingURL": "www.realtor.ca/real-estate/29173490/pt-lt-24-concession-5-lambton-shores-arkona-arkona"
+"CoListAgentKey": "1882522"
+"CoListOfficeKey": "47253"
+"GeocodeManualYN": false
+"ZoningDescription": "A2A1HL1"
+"FrontageLengthNumeric": 66.1
+"OriginalEntryTimestamp": "2025-12-09T14:22:23.7Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:27 [
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]
]
+"Member": []
+"Office": array:1 [
0 => array:20 [ …20]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29173490')"
+"ID": "471044"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24903
+post_id: "461147"
+post_author: 1
+"ListingKey": "29159001"
+"ListingId": "X12597676"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-22T18:01:06Z"
+"RFModificationTimestamp": "2025-12-22T18:04:38Z"
+"ListPrice": 499990.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Niagara-on-the-Lake (Rural)"
+"PostalCode": "L0S1J0"
+"UnparsedAddress": "LOT 21 - 7 CONCESSION ROAD, Niagara-on-the-Lake (Rural), Ontario L0S1J0"
+"Coordinates": array:2 [
0 => -79.134079
1 => 43.153411
]
+"Latitude": 43.153411
+"Longitude": -79.134079
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Introducing the Tresca back-to-back townhome at Modero. This beautifully designed 3-storey home offers 1,453 sq. ft. of bright, thoughtfully designed living space. This 2-bed, 2.5-bath home comes with a welcoming entry level features a thoughtful foyer, utility room and a versatile den, perfect for a home office or reading space. A single-car attached garage with inside entry adds everyday convenience. The second floor showcases an open-concept layout, including a stylish kitchen with pantry, an inviting dinette area, a generous living room, a convenient 2-piece powder room, and a private balcony ideal for morning coffee or evening relaxation. On the third level, you'll find two well-appointed bedrooms, a charming Juliette balcony, and a 4-piece main bathroom. The primary suite offers a large walk-in closet and its own 3-piece ensuite, along with bedroom-level laundry for everyday use. Discover Modero - Niagara-on-the-Lake's newest and most captivating master-planned community. Offering remarkably designed townhomes, innovative attached singles, and future single detached homes, Modero pairs timeless style with modern functionality. Set against picturesque vineyard views and anchored by a 2-acre central park with planned on-site retail, this community delivers a lifestyle that is connected, convenient, and truly inspiring. Perfectly located close to major highways, shopping, schools, local vineyards and breweries, restaurants! Experience the charm of Niagara-on-the-Lake and the unmatched lifestyle of Modero-where thoughtful design meets inspired living. Images are Builders concept and for inspiration only. Closings anticipated 2027. (id:62650)"
+"AssociationFee": "97"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-03T19:11:25.270313+00:00"
+"Directions": "Cross Streets: York Rd & Concession Rd 7. ** Directions: QEW-Glendale-York Rd- Concession Rd 7."
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Aluminum siding"
]
+"Flooring": array:2 [
0 => "Tile"
1 => "Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2234697"
+"ListOfficeKey": "288936"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Balcony"
1 => "In suite Laundry"
2 => "Sump Pump"
]
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2025-12-22T17:47:59Z"
+"PhotosCount": 18
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-22T17:47:59Z"
+"Stories": "3.0"
+"StreetName": "Concession"
+"StreetNumber": "7"
+"StreetSuffix": "Road"
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "104 - Rural"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29159001/lot-21-7-concession-road-niagara-on-the-lake-rural-104-rural"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2236756"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "TBA"
+"CoListOfficeKey": "299519"
+"GeocodeManualYN": false
+"BuildingFeatures": array:2 [
0 => "Separate Electricity Meters"
1 => "Visitor Parking"
]
+"LivingAreaMaximum": 1599
+"LivingAreaMinimum": 1400
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2025-12-03T17:54:22.72Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:18 [
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]
]
+"Member": array:1 [
0 => array:4 [ …4]
]
+"Office": array:1 [
0 => array:20 [ …20]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29159001')"
+"ID": "461147"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24900
+post_id: "432612"
+post_author: 1
+"ListingKey": "29121397"
+"ListingId": "X12561870"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T23:10:42Z"
+"RFModificationTimestamp": "2025-11-26T23:13:41Z"
+"ListPrice": 1349000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Niagara-on-the-Lake (St. Davids)"
+"PostalCode": "L0S1J0"
+"UnparsedAddress": "2 TULIP TREE ROAD, Niagara-on-the-Lake (St. Davids), Ontario L0S1J0"
+"Coordinates": array:2 [
0 => -79.1097809
1 => 43.1547345
]
+"Latitude": 43.1547345
+"Longitude": -79.1097809
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Niagara Association of REALTORS®"
+"PublicRemarks": "Stunning Bungalow in the Heart of St. David's. Where every day feels like home. Welcome to St. David's, Niagara-on-the-Lake, a place where neighbors wave as they pass, the barista knows your order, and life moves at the perfect pace. Nestled in this highly sought-after community, this beautifully crafted 1,881 sq. ft. bungalow pairs timeless style with modern comfort. Step inside to discover a bright, open concept layout that seamlessly connects the living, dining, and kitchen spaces, ideal for entertaining or relaxing nights in. At the heart of the home, a striking 9 ft quartz island anchors the kitchen, offering the perfect hub for conversation, casual dining, or weekend baking sessions. Two spacious bedrooms provide comfort and privacy, including a serene primary retreat featuring a spa inspired ensuite with heated floors, granite counters, and a generous walk in closet. A second full bath also boasts elegant granite finishes, complementing the rich hardwood floors that carry throughout the main level. The fully finished lower level extends your living space, complete with a wet bar, expansive family room, additional bedroom, full bath, and abundant storage plus workshop area, perfect for hobbies or guests. Step outside to your covered deck and unwind with tranquil views of mature trees and natural surroundings, your private escape just moments from every local delight. From your doorstep, stroll to The Junction for morning coffee, enjoy dinner at The Grist, pick up fresh snacks from Avondale, or sip award winning wines at Ravine, Château des Charmes, and Colaneri. Spend sunny afternoons golfing at Eagle Valley or exploring the Bruce Trail. Here, you're not just buying a home, you're embracing a lifestyle, a community, and a sense of belonging (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Oven"
4 => "Dryer"
5 => "Cooktop"
6 => "Wet Bar"
7 => "Garage door opener remote(s)"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-20T16:33:00.666671+00:00"
+"Directions": "Cross Streets: Tanbark-Hickory-Chestnut. ** Directions: York-Tanbark-Chestnut-Tulip Tree."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2022523"
+"ListOfficeKey": "283409"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "59 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-11-20T15:29:14Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T22:57:35Z"
+"Stories": "1.0"
+"StreetName": "Tulip Tree"
+"StreetNumber": "2"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "6181"
+"VirtualTourURLUnbranded": "https://www.youtube.com/shorts/d9Tv4fBB6k0"
+"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": "Niagara"
+"TaxYear": 2025
+"CityRegion": "105 - St. Davids"
+"ListAORKey": "114"
+"ListingURL": "www.realtor.ca/real-estate/29121397/2-tulip-tree-road-niagara-on-the-lake-st-davids-105-st-davids"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2021039"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "300053"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 59.0
+"OriginalEntryTimestamp": "2025-11-20T15:29:14.54Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:47 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29121397')"
+"ID": "432612"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24892
+post_id: "315473"
+post_author: 1
+"ListingKey": "28986151"
+"ListingId": "X12460907"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-10-23T01:21:45Z"
+"RFModificationTimestamp": "2025-10-23T08:20:11Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Niagara-on-the-Lake (Rural)"
+"PostalCode": "L0S1J0"
+"UnparsedAddress": "613 QUEENSTON ROAD, Niagara-on-the-Lake (Rural), Ontario L0S1J0"
+"Coordinates": array:2 [
0 => -79.1481018
1 => 43.1644516
]
+"Latitude": 43.1644516
+"Longitude": -79.1481018
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Niagara Association of REALTORS®"
+"PublicRemarks": "Incredible potential for this diamond in the rough! Discover the perfect blend of country charm and modern potential in this captivating 4+1 bedroom, 2 bathroom farmhouse nestled in the heart of Niagara-on-the-Lake. This two-storey detached home spans over 2290 square feet, sitting on a large lot with the added privacy of no rear neighbours and backing onto a serene ravine. Step inside to find classic design elements thoughtfully preserved throughout, offering buyers the unique opportunity to embrace timeless character or customize with their own personal updates. The spacious living room welcomes you with abundant natural light streaming through large windows and centers around a stunning stone fireplace perfect for cozy evenings. The heart of the home features a generous kitchen brimming with potential, seamlessly connected to a separate formal dining room ideal for entertaining. The main floor's flexibility continues with an additional room that can serve as a den, home office, or extra bedroom to suit your lifestyle needs. A convenient two-piece powder room completes the main level. Upstairs, four spacious bedrooms provide comfortable accommodations with ample closet space, while a four-piece bathroom serves the second floor. This exceptional property offers the rare opportunity to enjoy peaceful rural living while remaining connected to urban conveniences, all within the prestigious and picturesque community of Niagara-on-the-Lake. Perfect for those seeking authentic country living or an exciting renovation project with endless possibilities. (id:62650)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
]
+"Basement": array:2 [
0 => "Partial"
1 => "Crawl space"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-10-14T19:51:31.139707+00:00"
+"Directions": "QUEENSTON RD - CONCESSION 7 RD"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1501246"
+"ListOfficeKey": "283840"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "64 x 222.8 FT"
+"ParkingFeatures": array:2 [
0 => "Carport"
1 => "No Garage"
]
+"PhotosChangeTimestamp": "2025-10-14T18:30:32Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-10-23T00:49:56Z"
+"Stories": "2.0"
+"StreetName": "Queenston"
+"StreetNumber": "613"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "3987.55"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Niagara"
+"CityRegion": "104 - Rural"
+"ListAORKey": "114"
+"ListingURL": "www.realtor.ca/real-estate/28986151/613-queenston-road-niagara-on-the-lake-rural-104-rural"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 64.0
+"OriginalEntryTimestamp": "2025-10-14T18:30:32.41Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:40 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('28986151')"
+"ID": "315473"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23526
+post_id: "244933"
+post_author: 1
+"ListingKey": "28910244"
+"ListingId": "X12425309"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-10-22T12:21:55Z"
+"RFModificationTimestamp": "2025-10-29T06:05:35Z"
+"ListPrice": 3388000.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Niagara-on-the-Lake (St. Davids)"
+"PostalCode": "L0S1P0"
+"UnparsedAddress": "26 SANDALWOOD CRESCENT, Niagara-on-the-Lake (St. Davids), Ontario L0S1P0"
+"Coordinates": array:2 [
0 => -79.110989145129
1 => 43.161584819777
]
+"Latitude": 43.161584819777
+"Longitude": -79.110989145129
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Niagara Association of REALTORS®"
+"PublicRemarks": "Welcome to this stunning custom-built two-story residence, offering over 6,000 sq. ft. of finished living space in the heart of wine country. This exceptional property blends timeless craftsmanship with modern luxury, creating a true masterpiece for refined living and entertaining. Step inside through the grand entry and be captivated by the 10-foot ceilings on both the main and second levels, accented with 8-foot doors and exquisite custom decorative mouldings. The 22-foot family room ceilings create an airy, impressive atmosphere, complemented by expansive windows that flood the space with natural light. At the heart of the home is a chef-inspired kitchen featuring professional-grade appliances, custom cabinetry, a large center island with seating, quartz countertops, a spacious walk-in pantry, and a butlers pantry for added convenience and storage. Designed with both function and style in mind, this space is perfect for everyday living and large gatherings.The home offers four spacious bedrooms and 4.5 baths, including a luxurious primary suite with spa-like ensuite.Finishes include hardwood floors and porcelain tiles throughout, enhancing both elegance and durability.Designed for hosting, the home boasts two fireplaces one indoors for cozy evenings and another outdoors for gatherings. The custom bar and finished basement provide a stylish entertainment hub, complete with a private theatre room for the ultimate cinematic experience.Step outside to your own backyard oasis featuring a large pool, hot tub, covered deck, fire pit area, and a full irrigation system, making outdoor living as effortless as it is enjoyable. (id:62650)"
+"Appliances": array:14 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Hot Tub"
4 => "Central Vacuum"
5 => "Dishwasher"
6 => "Stove"
7 => "Oven"
8 => "Dryer"
9 => "Microwave"
10 => "Blinds"
11 => "Window Coverings"
12 => "Garage door opener remote(s)"
13 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-09-25T07:41:52.747982+00:00"
+"Directions": "Cross Streets: Queenston Rd and York Rd. ** Directions: York Rd to Queenston Rd to Sandalwood Cres."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"Fencing": array:2 [
0 => "Fenced yard"
1 => "Fully Fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1896289"
+"ListOfficeKey": "75381"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Cul-de-sac"
1 => "Irregular lot size"
]
+"LotSizeDimensions": "45.6 x 217.1 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-09-25T04:56:52Z"
+"PhotosCount": 47
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-10-22T12:06:17Z"
+"Stories": "2.0"
+"StreetName": "Sandalwood"
+"StreetNumber": "26"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "16167.17"
+"VirtualTourURLUnbranded": "https://youtu.be/Dw_6_k_45bg"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
]
+"ListAOR": "Niagara"
+"TaxYear": 2025
+"CityRegion": "105 - St. Davids"
+"ListAORKey": "114"
+"ListingURL": "www.realtor.ca/real-estate/28910244/26-sandalwood-crescent-niagara-on-the-lake-st-davids-105-st-davids"
+"ParkingTotal": 9
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"BuildingFeatures": array:2 [
0 => "Canopy"
1 => "Fireplace(s)"
]
+"LivingAreaMaximum": 5000
+"LivingAreaMinimum": 3500
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 45.7
+"OriginalEntryTimestamp": "2025-09-25T04:56:51.88Z"
+"FrontageLengthNumericUnits": "feet"
+"Media": array:47 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('28910244')"
+"ID": "244933"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24896
+post_id: "193380"
+post_author: 1
+"ListingKey": "28863100"
+"ListingId": "40769864"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-09-15T16:55:53Z"
+"RFModificationTimestamp": "2025-09-17T14:44:36Z"
+"ListPrice": 2599000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 5415.0
+"BuildingAreaTotal": 0
+"City": "Niagara-on-the-Lake"
+"PostalCode": "L0S1P0"
+"UnparsedAddress": "7 SANDALWOOD Crescent, Niagara-on-the-Lake, Ontario L0S1P0"
+"Coordinates": array:2 [
0 => -79.11160604
1 => 43.16073123
]
+"Latitude": 43.16073123
+"Longitude": -79.11160604
+"YearBuilt": 2010
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of Realtors"
+"PublicRemarks": "Luxury Custom Build Large Bungalow! Located on Sandalwood Crescent, an exclusive enclave of distinguished homes in Niagara-on-the-Lake. Boasting 2800 sqft on the main level which includes 3 spacious bedrooms, stunning home office, living room with custom built-ins, family room, separate dining room, eat-in kitchen with extra large island, top of the line appliances, plus a gorgeous family room with floor to ceiling stone fireplace. The lower level is completely finished with an additional 2620 sqft consisting of 2 bedrooms, bathroom, entertainment centre with custom bar, and so much more. 14' ceilings are on the main level, lined with custom plaster crown mouldings and baseboards (on both levels), built ins, solid wood doors, custom draperies, in-home audio system, gas fireplace, and walk-out to large custom deck. The lot (73'x150') is lined with cedars for privacy and fully landscaped. There is so much more included in the stunning property. Please see the features list on page 2 of the photos. This exceptional residence offers luxury living at its finest in charming Niagara-on-the-Lake. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Gas stove(s)"
3 => "Dishwasher"
4 => "Dryer"
5 => "Wet Bar"
6 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-09-17T14:44:16.709058+00:00"
+"Directions": "York Rd to Queenston Rd to Sandalwood"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2020021"
+"ListOfficeKey": "283153"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Wet bar"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-09-15T16:48:06Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-09-15T16:48:05Z"
+"Stories": "1.0"
+"StreetName": "SANDALWOOD"
+"StreetNumber": "7"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "105 - St. Davids"
+"TaxAnnualAmount": "9700"
+"VirtualTourURLUnbranded": "https://youtu.be/yOQl8sBydHk?si=bplLh-KH2n0cgL9X"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:18 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
]
+"ListAOR": "Cornerstone - Hamilton-Burlington"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/28863100/7-sandalwood-crescent-niagara-on-the-lake"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 73.0
+"AboveGradeFinishedArea": 2795
+"BelowGradeFinishedArea": 2620
+"OriginalEntryTimestamp": "2025-09-15T16:48:05.94Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"BelowGradeFinishedAreaSource": "Builder"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:20 [ …20]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('28863100')"
+"ID": "193380"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24897
+post_id: "257145"
+post_author: 1
+"ListingKey": "28864007"
+"ListingId": "X12404133"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-10-28T02:00:48Z"
+"RFModificationTimestamp": "2025-11-08T18:34:27Z"
+"ListPrice": 2599000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Niagara-on-the-Lake (St. Davids)"
+"PostalCode": "L0S1P0"
+"UnparsedAddress": "7 SANDALWOOD CRESCENT, Niagara-on-the-Lake (St. Davids), Ontario L0S1P0"
+"Coordinates": array:2 [
0 => -79.110989145129
1 => 43.161584819777
]
+"Latitude": 43.161584819777
+"Longitude": -79.110989145129
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Luxury Custom Build Large Bungalow! Located on Sandalwood Crescent, an exclusive enclave of distinguished homes in Niagara-on-the-Lake. Boasting 2800 sqft on the main level which includes 3 spacious bedrooms, stunning home office, living room with custom built-ins, family room, separate dining room, eat-in kitchen with extra large island, top of the line appliances, plus a gorgeous family room with floor to ceiling stone fireplace. The lower level is completely finished with an additional 2620 sqft consisting of 2 bedrooms, bathroom, entertainment centre with custom bar, and so much more. 14' ceilings are on the main level, lined with custom plaster crown mouldings and baseboards (on both levels), built ins, solid wood doors, custom draperies, in-home audio system, gas fireplace, and walk-out to large custom deck. The lot (73'x150') is lined with cedars for privacy and fully landscaped. There is so much more included in the stunning property. Please see the features list on page 2 of the photos. This exceptional residence offers luxury living at its finest in charming Niagara-on-the-Lake. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-09-17T13:06:35.282875+00:00"
+"Directions": "Cross Streets: Queenston Rd. ** Directions: York Rd to Queenston Rd to Sandalwood."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2153000"
+"ListOfficeKey": "279033"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "73 x 150 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-09-15T18:07:59Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-10-28T01:42:57Z"
+"Stories": "1.0"
+"StreetName": "Sandalwood"
+"StreetNumber": "7"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "9700"
+"VirtualTourURLUnbranded": "https://youtu.be/yOQl8sBydHk?si=bplLh-KH2n0cgL9X"
+"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": "Toronto"
+"CityRegion": "105 - St. Davids"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/28864007/7-sandalwood-crescent-niagara-on-the-lake-st-davids-105-st-davids"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 73.0
+"OriginalEntryTimestamp": "2025-09-15T18:07:59.8Z"
+"FrontageLengthNumericUnits": "feet"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:20 [ …20]
]
+"Office": array:1 [
0 => array:20 [ …20]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('28864007')"
+"ID": "257145"
}
]
+success: true
+page_size: 9
+page_count: 2
+count: 10
+after_key: ""
}
"RF Response Time" => "0.16 seconds"
]
]