array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29875859 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23360
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23362
+post_id: "1510033"
+post_author: 1
+"ListingKey": "29875859"
+"ListingId": "X13419456"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T02:15:13Z"
+"RFModificationTimestamp": "2026-06-11T02:29:37Z"
+"ListPrice": 599900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Thorold (Hurricane/Merrittville)"
+"PostalCode": "L3B0H1"
+"UnparsedAddress": "250 ESTHER CRESCENT, Thorold (Hurricane/Merrittville), Ontario L3B0H1"
+"Coordinates": array:2 [
0 => -79.230769
1 => 43.035509
]
+"Latitude": 43.035509
+"Longitude": -79.230769
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "//2 Storey Fully Freehold End-Unit Townhouse** 3 Bedrooms & 3 Washrooms House With Backyard In Demanding Thorold Area! Enjoy Open-Concept Main Floor With Abundant Natural Light Throughout* Upgraded Family Size Kitchen Includes Ceramic Floor, Oak Cabinets & Stainless Steel Appliances, Perfect For Family Meals Or Entertaining! Step Out From The Dining Area Onto A Backyard Ideal For Relaxing Or Summer Bbqs. Laundry Is Conveniently Located In Main Floor & Direct Access To Garage! 3 Spacious Bedrooms, Primary Bedroom Comes With Walk-In Closet & Private Ensuite Bathroom! No Side Walk Driveway To Accomodate Extra Parking [3 Cars Parking] Whole House Is Freshly & Professionally Painted* Un-Finished Poviding A Blank Canvas For Your Future Plans. Conveniently Located Just Minutes From Brock University & Niagara College, Highway 406. Close To Schools, Shopping Centres, Public Transit, Parks, And Easy Highway Access Must View House! Shows 10/10* (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-09T16:05:00.325932+00:00"
+"Directions": "Cross Streets: Kottmeier & Port Robinson. ** Directions: ."
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"Flooring": array:3 [
0 => "Laminate"
1 => "Carpeted"
2 => "Ceramic"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1632894"
+"ListOfficeKey": "50932"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "25.6 x 123.3 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T02:06:47Z"
+"PhotosCount": 41
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T02:06:47Z"
+"Stories": "2.0"
+"StreetName": "Esther"
+"StreetNumber": "250"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "5070"
+"VirtualTourURLUnbranded": "https://unbranded.mediatours.ca/property/250-esther-crescent-thorold/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [
"RoomKey" => "1655912456"
"RoomType" => "Living room"
"ListingId" => "X13419456"
"RoomLevel" => "Ground level"
"RoomWidth" => 0.0
"ListingKey" => "29875859"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-09T22:19:18.28Z"
]
1 => array:11 [
"RoomKey" => "1655912457"
"RoomType" => "Dining room"
"ListingId" => "X13419456"
"RoomLevel" => "Ground level"
"RoomWidth" => 0.0
"ListingKey" => "29875859"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-09T22:19:18.28Z"
]
2 => array:11 [
"RoomKey" => "1655912458"
"RoomType" => "Kitchen"
"ListingId" => "X13419456"
"RoomLevel" => "Ground level"
"RoomWidth" => 0.0
"ListingKey" => "29875859"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-09T22:19:18.28Z"
]
3 => array:11 [
"RoomKey" => "1655912459"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13419456"
"RoomLevel" => "Second level"
"RoomWidth" => 0.0
"ListingKey" => "29875859"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-09T22:19:18.28Z"
]
4 => array:11 [
"RoomKey" => "1655912460"
"RoomType" => "Bedroom 2"
"ListingId" => "X13419456"
"RoomLevel" => "Second level"
"RoomWidth" => 0.0
"ListingKey" => "29875859"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-09T22:19:18.28Z"
]
5 => array:11 [
"RoomKey" => "1655912461"
"RoomType" => "Bedroom 3"
"ListingId" => "X13419456"
"RoomLevel" => "Second level"
"RoomWidth" => 0.0
"ListingKey" => "29875859"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-09T22:19:18.28Z"
]
6 => array:11 [
"RoomKey" => "1655912462"
"RoomType" => "Laundry room"
"ListingId" => "X13419456"
"RoomLevel" => "Ground level"
"RoomWidth" => 0.0
"ListingKey" => "29875859"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-09T22:19:18.28Z"
]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"CityRegion": "562 - Hurricane/Merrittville"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29875859/250-esther-crescent-thorold-hurricanemerrittville-562-hurricanemerrittville"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1939031"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "50932"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 25.7
+"OriginalEntryTimestamp": "2026-06-09T15:36:52.36Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1163076"
+"ListOfficeNationalAssociationId": "1002980"
+"CoListAgentNationalAssociationId": "1236868"
+"CoListOfficeNationalAssociationId": "1002980"
+"Media": array:41 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29875859_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875859/b0be0c54f91dfcdba41bdc1773ac3518.webp"
"MediaSize" => 277050
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875859/thumbnail-b0be0c54f91dfcdba41bdc1773ac3518.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13419456"
"ResourceRecordKey" => "29875859"
"ModificationTimestamp" => "2026-06-09T15:36:52.37Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29875859_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875859/95d3e583e253b5e51239543394b2cc89.webp"
"MediaSize" => 187609
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875859/thumbnail-95d3e583e253b5e51239543394b2cc89.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13419456"
"ResourceRecordKey" => "29875859"
"ModificationTimestamp" => "2026-06-09T15:36:52.37Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29875859_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875859/cd58fc6e10c3da82fcdd2a17f6369c38.webp"
"MediaSize" => 116157
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875859/thumbnail-cd58fc6e10c3da82fcdd2a17f6369c38.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13419456"
"ResourceRecordKey" => "29875859"
"ModificationTimestamp" => "2026-06-09T15:36:52.37Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29875859_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875859/83b08c81c81f9560524f93223e0ebfba.webp"
"MediaSize" => 115894
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875859/thumbnail-83b08c81c81f9560524f93223e0ebfba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13419456"
"ResourceRecordKey" => "29875859"
"ModificationTimestamp" => "2026-06-09T15:36:52.37Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29875859_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875859/57c130537d092db055131b7f5a5c8872.webp"
"MediaSize" => 168566
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875859/thumbnail-57c130537d092db055131b7f5a5c8872.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13419456"
"ResourceRecordKey" => "29875859"
"ModificationTimestamp" => "2026-06-09T15:36:52.37Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29875859_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875859/f22fdf7ae3f63792d10ca6dd5fb464f7.webp"
"MediaSize" => 165764
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875859/thumbnail-f22fdf7ae3f63792d10ca6dd5fb464f7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13419456"
"ResourceRecordKey" => "29875859"
"ModificationTimestamp" => "2026-06-09T15:36:52.37Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29875859_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875859/e77baf83f6b875781c8f3f4045f473d2.webp"
"MediaSize" => 180707
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875859/thumbnail-e77baf83f6b875781c8f3f4045f473d2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13419456"
"ResourceRecordKey" => "29875859"
"ModificationTimestamp" => "2026-06-09T15:36:52.37Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29875859_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875859/1ec5d2ab774e23fc3e866009840938db.webp"
"MediaSize" => 179843
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875859/thumbnail-1ec5d2ab774e23fc3e866009840938db.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13419456"
"ResourceRecordKey" => "29875859"
"ModificationTimestamp" => "2026-06-09T15:36:52.37Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29875859_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875859/4d9d94d96e16ae68ae20aa7d48346bf2.webp"
"MediaSize" => 147724
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875859/thumbnail-4d9d94d96e16ae68ae20aa7d48346bf2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13419456"
"ResourceRecordKey" => "29875859"
"ModificationTimestamp" => "2026-06-09T15:36:52.37Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29875859_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875859/b7b120c93115f1cd90881aa8fdb16a46.webp"
"MediaSize" => 151028
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875859/thumbnail-b7b120c93115f1cd90881aa8fdb16a46.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13419456"
"ResourceRecordKey" => "29875859"
"ModificationTimestamp" => "2026-06-09T15:36:52.37Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29875859_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875859/80a4ae2e00ff8cefe2684a9954801bca.webp"
"MediaSize" => 157795
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875859/thumbnail-80a4ae2e00ff8cefe2684a9954801bca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13419456"
"ResourceRecordKey" => "29875859"
"ModificationTimestamp" => "2026-06-09T15:36:52.37Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29875859_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875859/fcaaa4fb265fcb650dd1458ce08a8491.webp"
"MediaSize" => 176513
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875859/thumbnail-fcaaa4fb265fcb650dd1458ce08a8491.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13419456"
"ResourceRecordKey" => "29875859"
"ModificationTimestamp" => "2026-06-09T15:36:52.37Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29875859_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875859/516ec8433ee73645c10bbc8df1c7c8e8.webp"
"MediaSize" => 144166
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875859/thumbnail-516ec8433ee73645c10bbc8df1c7c8e8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13419456"
"ResourceRecordKey" => "29875859"
"ModificationTimestamp" => "2026-06-09T15:36:52.37Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29875859_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875859/4fac152892717556b82f3cf9769483e9.webp"
"MediaSize" => 170610
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875859/thumbnail-4fac152892717556b82f3cf9769483e9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13419456"
"ResourceRecordKey" => "29875859"
"ModificationTimestamp" => "2026-06-09T15:36:52.37Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29875859_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875859/5e99b24995bac23894f8fe7c4374dc23.webp"
"MediaSize" => 173949
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875859/thumbnail-5e99b24995bac23894f8fe7c4374dc23.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13419456"
"ResourceRecordKey" => "29875859"
"ModificationTimestamp" => "2026-06-09T15:36:52.37Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29875859_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875859/cd7e48e1deb886470b1ea653d95b8cb5.webp"
"MediaSize" => 166092
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875859/thumbnail-cd7e48e1deb886470b1ea653d95b8cb5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13419456"
"ResourceRecordKey" => "29875859"
"ModificationTimestamp" => "2026-06-09T15:36:52.37Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29875859_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875859/952e911d32956ab9b1eead96a5c7d797.webp"
"MediaSize" => 180403
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875859/thumbnail-952e911d32956ab9b1eead96a5c7d797.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13419456"
"ResourceRecordKey" => "29875859"
"ModificationTimestamp" => "2026-06-09T15:36:52.37Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29875859_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875859/911101cf8e3c2e268f619fca87a3227a.webp"
"MediaSize" => 148648
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875859/thumbnail-911101cf8e3c2e268f619fca87a3227a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13419456"
"ResourceRecordKey" => "29875859"
"ModificationTimestamp" => "2026-06-09T15:36:52.37Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29875859_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875859/153786341246bcf51485dbbb2fc668e3.webp"
"MediaSize" => 157754
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875859/thumbnail-153786341246bcf51485dbbb2fc668e3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13419456"
"ResourceRecordKey" => "29875859"
"ModificationTimestamp" => "2026-06-09T15:36:52.37Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29875859_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875859/5f7e45dcb4b3a540af6088d8e89d9122.webp"
"MediaSize" => 162998
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875859/thumbnail-5f7e45dcb4b3a540af6088d8e89d9122.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13419456"
"ResourceRecordKey" => "29875859"
"ModificationTimestamp" => "2026-06-09T15:36:52.37Z"
]
20 => array:13 [
"Order" => 22
"MediaKey" => "29875859_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875859/08a21b463b1560498838a06750c82494.webp"
"MediaSize" => 137404
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875859/thumbnail-08a21b463b1560498838a06750c82494.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13419456"
"ResourceRecordKey" => "29875859"
"ModificationTimestamp" => "2026-06-09T15:36:52.37Z"
]
21 => array:13 [
"Order" => 23
"MediaKey" => "29875859_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875859/88748233ae129dc69e0eaff5fdf0f0f0.webp"
"MediaSize" => 99728
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875859/thumbnail-88748233ae129dc69e0eaff5fdf0f0f0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13419456"
"ResourceRecordKey" => "29875859"
"ModificationTimestamp" => "2026-06-09T15:36:52.37Z"
]
22 => array:13 [
"Order" => 24
"MediaKey" => "29875859_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875859/adac78a4a6aa69eb94f375900d45ab5f.webp"
"MediaSize" => 169603
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875859/thumbnail-adac78a4a6aa69eb94f375900d45ab5f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13419456"
"ResourceRecordKey" => "29875859"
"ModificationTimestamp" => "2026-06-09T15:36:52.37Z"
]
23 => array:13 [
"Order" => 25
"MediaKey" => "29875859_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875859/080bbdbe6f0fa5a9eb62c0a4bd158523.webp"
"MediaSize" => 146169
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875859/thumbnail-080bbdbe6f0fa5a9eb62c0a4bd158523.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13419456"
"ResourceRecordKey" => "29875859"
"ModificationTimestamp" => "2026-06-09T15:36:52.37Z"
]
24 => array:13 [
"Order" => 26
"MediaKey" => "29875859_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875859/8a8014b98304b4d3f6d0dafa4818a432.webp"
"MediaSize" => 128596
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875859/thumbnail-8a8014b98304b4d3f6d0dafa4818a432.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13419456"
"ResourceRecordKey" => "29875859"
"ModificationTimestamp" => "2026-06-09T15:36:52.37Z"
]
25 => array:13 [
"Order" => 29
"MediaKey" => "29875859_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875859/1be2d87e134d9a3f313ba66859b70aba.webp"
"MediaSize" => 111248
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875859/thumbnail-1be2d87e134d9a3f313ba66859b70aba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13419456"
"ResourceRecordKey" => "29875859"
"ModificationTimestamp" => "2026-06-09T15:36:52.37Z"
]
26 => array:13 [
"Order" => 30
"MediaKey" => "29875859_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875859/cd602ed682922122d92d65c93346c60d.webp"
"MediaSize" => 104032
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875859/thumbnail-cd602ed682922122d92d65c93346c60d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13419456"
"ResourceRecordKey" => "29875859"
"ModificationTimestamp" => "2026-06-09T15:36:52.37Z"
]
27 => array:13 [
"Order" => 31
"MediaKey" => "29875859_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875859/2fa1986477b91c1e4639452f8b2e0c16.webp"
"MediaSize" => 133540
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875859/thumbnail-2fa1986477b91c1e4639452f8b2e0c16.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13419456"
"ResourceRecordKey" => "29875859"
"ModificationTimestamp" => "2026-06-09T15:36:52.37Z"
]
28 => array:13 [
"Order" => 32
"MediaKey" => "29875859_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875859/a1bdf91ee7e479b199fa5d34345fdfdf.webp"
"MediaSize" => 105044
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875859/thumbnail-a1bdf91ee7e479b199fa5d34345fdfdf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13419456"
"ResourceRecordKey" => "29875859"
"ModificationTimestamp" => "2026-06-09T15:36:52.37Z"
]
29 => array:13 [
"Order" => 33
"MediaKey" => "29875859_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875859/2623c653bc496d5332132e1e6f29e729.webp"
"MediaSize" => 128856
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875859/thumbnail-2623c653bc496d5332132e1e6f29e729.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13419456"
"ResourceRecordKey" => "29875859"
"ModificationTimestamp" => "2026-06-09T15:36:52.37Z"
]
30 => array:13 [
"Order" => 34
"MediaKey" => "29875859_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875859/189a6c9de6af2c1182aa7c21fbea8bbe.webp"
"MediaSize" => 117989
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875859/thumbnail-189a6c9de6af2c1182aa7c21fbea8bbe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13419456"
"ResourceRecordKey" => "29875859"
"ModificationTimestamp" => "2026-06-09T15:36:52.37Z"
]
31 => array:13 [
"Order" => 41
"MediaKey" => "29875859_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875859/7fc5fb4957e87d27ca83aa9a2ec6f7d0.webp"
"MediaSize" => 321093
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875859/thumbnail-7fc5fb4957e87d27ca83aa9a2ec6f7d0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13419456"
"ResourceRecordKey" => "29875859"
"ModificationTimestamp" => "2026-06-09T15:36:52.37Z"
]
32 => array:13 [
"Order" => 21
"MediaKey" => "29875859_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875859/189316107f3533339d5cb8a29c958a64.webp"
"MediaSize" => 106336
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875859/thumbnail-189316107f3533339d5cb8a29c958a64.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13419456"
"ResourceRecordKey" => "29875859"
"ModificationTimestamp" => "2026-06-11T02:06:47.17Z"
]
33 => array:13 [
"Order" => 27
"MediaKey" => "29875859_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875859/aa5b4c3e70dc6d8acb2a9b487c6d53d7.webp"
"MediaSize" => 131370
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875859/thumbnail-aa5b4c3e70dc6d8acb2a9b487c6d53d7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13419456"
"ResourceRecordKey" => "29875859"
"ModificationTimestamp" => "2026-06-11T02:06:47.27Z"
]
34 => array:13 [
"Order" => 28
"MediaKey" => "29875859_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875859/79aa3617f4fe68c9a733f9392036c1b9.webp"
"MediaSize" => 137921
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875859/thumbnail-79aa3617f4fe68c9a733f9392036c1b9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13419456"
"ResourceRecordKey" => "29875859"
"ModificationTimestamp" => "2026-06-11T02:06:46.73Z"
]
35 => array:13 [
"Order" => 35
"MediaKey" => "29875859_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875859/6759c8ae5ba439332cda8854c0758534.webp"
"MediaSize" => 83777
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875859/thumbnail-6759c8ae5ba439332cda8854c0758534.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13419456"
"ResourceRecordKey" => "29875859"
"ModificationTimestamp" => "2026-06-11T02:06:47.31Z"
]
36 => array:13 [
"Order" => 36
"MediaKey" => "29875859_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875859/06b4ecef05de02d460aa422506b393f4.webp"
"MediaSize" => 303567
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875859/thumbnail-06b4ecef05de02d460aa422506b393f4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13419456"
"ResourceRecordKey" => "29875859"
"ModificationTimestamp" => "2026-06-11T02:06:46.98Z"
]
37 => array:13 [
"Order" => 37
"MediaKey" => "29875859_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875859/43ae7c75eb448b00b86127d6f9db47fd.webp"
"MediaSize" => 358244
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875859/thumbnail-43ae7c75eb448b00b86127d6f9db47fd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13419456"
"ResourceRecordKey" => "29875859"
"ModificationTimestamp" => "2026-06-11T02:06:46.99Z"
]
38 => array:13 [
"Order" => 38
"MediaKey" => "29875859_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875859/bf0fbad84ac4e383ec476a6f9d12c5c7.webp"
"MediaSize" => 359297
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875859/thumbnail-bf0fbad84ac4e383ec476a6f9d12c5c7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13419456"
"ResourceRecordKey" => "29875859"
"ModificationTimestamp" => "2026-06-11T02:06:47.35Z"
]
39 => array:13 [
"Order" => 39
"MediaKey" => "29875859_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875859/98bc45bedfe2be9a09568883249b8805.webp"
"MediaSize" => 327773
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875859/thumbnail-98bc45bedfe2be9a09568883249b8805.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13419456"
"ResourceRecordKey" => "29875859"
"ModificationTimestamp" => "2026-06-11T02:06:46.76Z"
]
40 => array:13 [
"Order" => 40
"MediaKey" => "29875859_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875859/49da92bdd9e5e9cdfac76ef58232baa1.webp"
"MediaSize" => 321093
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875859/thumbnail-49da92bdd9e5e9cdfac76ef58232baa1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13419456"
"ResourceRecordKey" => "29875859"
"ModificationTimestamp" => "2026-06-11T02:06:47.2Z"
]
]
+"DaysOnMarket": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29875859')"
+"ID": "1510033"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Cache Key: 6594cd143cb3f9b73d36ac5cd2a99dfb40d1a6c2fdd90fa1ee36bc47c318c147" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24491
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1632894" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24807
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29875859'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25120
+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 '29875859'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25136
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29875859' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.230769 43.035509)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25209
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25183
+post_id: "1530574"
+post_author: 1
+"ListingKey": "29904802"
+"ListingId": "X13446174"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T17:35:29Z"
+"RFModificationTimestamp": "2026-06-15T17:52:17Z"
+"ListPrice": 694900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Thorold (Hurricane/Merrittville)"
+"PostalCode": "L3B0L1"
+"UnparsedAddress": "111 SUNFLOWER CRESCENT, Thorold (Hurricane/Merrittville), Ontario L3B0L1"
+"Coordinates": array:2 [
0 => -79.226898
1 => 43.038341
]
+"Latitude": 43.038341
+"Longitude": -79.226898
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Niagara Association of REALTORS®"
+"PublicRemarks": "Need more space without sacrificing convenience? 111 Sunflower Crescent offers the layout, functionality, and modern feel today's buyers are looking for. This 4-bedroom, 3-bathroom home features a bright, open-concept main floor designed for comfort and easy entertaining, with a stylish kitchen complete with upgraded tile and backsplash flowing into the living area with an electric fireplace. Upstairs, you'll find 4 well-sized bedrooms, including a huge primary suite with a walk-in closet and private ensuite featuring a glass shower, along with the added convenience of second-floor laundry. The unfinished basement presents a great opportunity to add value, offering a bathroom rough-in, oversized windows, and a 200-amp panel ideal for future income, multi-gen living or additional space. With a double-car garage, double-wide parking and a location just minutes to highways, shopping, and amenities, this home delivers the space and flexibility that's increasingly hard to find. (id:62783)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:3 [
0 => "Unfinished"
1 => "Full"
2 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T17:52:10.847280+00:00"
+"Directions": "Cross Streets: Kottmeier. ** Directions: Higgins to Lavender to Sunflower."
+"ExteriorFeatures": array:1 [
0 => "Aluminum siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2054879"
+"ListOfficeKey": "75354"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "33 x 92 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T17:28:31Z"
+"PhotosCount": 30
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T17:28:31Z"
+"Stories": "2.0"
+"StreetName": "Sunflower"
+"StreetNumber": "111"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "5700"
+"VirtualTourURLUnbranded": "https://youriguide.com/111_sunflower_cres_thorold_on"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Niagara"
+"CityRegion": "562 - Hurricane/Merrittville"
+"ListAORKey": "114"
+"ListingURL": "www.realtor.ca/real-estate/29904802/111-sunflower-crescent-thorold-hurricanemerrittville-562-hurricanemerrittville"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "Residential"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 33.0
+"OriginalEntryTimestamp": "2026-06-15T17:28:30.95Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1330156"
+"ListOfficeNationalAssociationId": "1004011"
+"Media": array:30 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29904802_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29904802/ca70f046b0e0a48afa960944b0f1f9fb.webp"
"MediaSize" => 253502
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29904802/thumbnail-ca70f046b0e0a48afa960944b0f1f9fb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13446174"
"ResourceRecordKey" => "29904802"
"ModificationTimestamp" => "2026-06-15T17:28:30.95Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29904802_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29904802/b8c9aad0a2031ba4abe47c87e8a89478.webp"
"MediaSize" => 260093
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29904802/thumbnail-b8c9aad0a2031ba4abe47c87e8a89478.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446174"
"ResourceRecordKey" => "29904802"
"ModificationTimestamp" => "2026-06-15T17:28:30.95Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29904802_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29904802/e3a0abcd9c2421ec1d84d86c6071e8bf.webp"
"MediaSize" => 245348
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29904802/thumbnail-e3a0abcd9c2421ec1d84d86c6071e8bf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446174"
"ResourceRecordKey" => "29904802"
"ModificationTimestamp" => "2026-06-15T17:28:30.95Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29904802_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29904802/7ae66c11c2a3a0a5a43d5d1bbb2e2234.webp"
"MediaSize" => 243570
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29904802/thumbnail-7ae66c11c2a3a0a5a43d5d1bbb2e2234.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446174"
"ResourceRecordKey" => "29904802"
"ModificationTimestamp" => "2026-06-15T17:28:30.95Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29904802_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29904802/ef72ccec9df65d84b8bb0edccd20c39e.webp"
"MediaSize" => 305134
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29904802/thumbnail-ef72ccec9df65d84b8bb0edccd20c39e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446174"
"ResourceRecordKey" => "29904802"
"ModificationTimestamp" => "2026-06-15T17:28:30.95Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29904802_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29904802/80b3c7b5fe326ae0a8cae5acd14954c4.webp"
"MediaSize" => 183655
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29904802/thumbnail-80b3c7b5fe326ae0a8cae5acd14954c4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446174"
"ResourceRecordKey" => "29904802"
"ModificationTimestamp" => "2026-06-15T17:28:30.95Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29904802_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29904802/499b599f5e5fb596a6482bfdb0f3141c.webp"
"MediaSize" => 141026
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29904802/thumbnail-499b599f5e5fb596a6482bfdb0f3141c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446174"
"ResourceRecordKey" => "29904802"
"ModificationTimestamp" => "2026-06-15T17:28:30.95Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29904802_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29904802/17501a41127ab6ef3afab122dab56f28.webp"
"MediaSize" => 83718
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29904802/thumbnail-17501a41127ab6ef3afab122dab56f28.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446174"
"ResourceRecordKey" => "29904802"
"ModificationTimestamp" => "2026-06-15T17:28:30.95Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29904802_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29904802/76c0901f491e7feec33f2fe7c18a8a03.webp"
"MediaSize" => 123396
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29904802/thumbnail-76c0901f491e7feec33f2fe7c18a8a03.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446174"
"ResourceRecordKey" => "29904802"
"ModificationTimestamp" => "2026-06-15T17:28:30.95Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29904802_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29904802/5f1e7f8890518dc3c8593460ea225adf.webp"
"MediaSize" => 145682
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29904802/thumbnail-5f1e7f8890518dc3c8593460ea225adf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446174"
"ResourceRecordKey" => "29904802"
"ModificationTimestamp" => "2026-06-15T17:28:30.95Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29904802_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29904802/ccdcdd23a17cc1fdc58a9a45f35b8010.webp"
"MediaSize" => 138332
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29904802/thumbnail-ccdcdd23a17cc1fdc58a9a45f35b8010.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446174"
"ResourceRecordKey" => "29904802"
"ModificationTimestamp" => "2026-06-15T17:28:30.95Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29904802_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29904802/eea0d2d5ed276a13509ec4eaea76a591.webp"
"MediaSize" => 148880
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29904802/thumbnail-eea0d2d5ed276a13509ec4eaea76a591.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446174"
"ResourceRecordKey" => "29904802"
"ModificationTimestamp" => "2026-06-15T17:28:30.95Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29904802_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29904802/927b6cae7dd588e0faf9351e47207723.webp"
"MediaSize" => 135652
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29904802/thumbnail-927b6cae7dd588e0faf9351e47207723.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446174"
"ResourceRecordKey" => "29904802"
"ModificationTimestamp" => "2026-06-15T17:28:30.95Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29904802_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29904802/5827b114ae5b581f4ec3e7526ce71767.webp"
"MediaSize" => 208962
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29904802/thumbnail-5827b114ae5b581f4ec3e7526ce71767.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446174"
"ResourceRecordKey" => "29904802"
"ModificationTimestamp" => "2026-06-15T17:28:30.95Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29904802_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29904802/f78bf4fc9f675c1f5d6b944b056eb32d.webp"
"MediaSize" => 214707
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29904802/thumbnail-f78bf4fc9f675c1f5d6b944b056eb32d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446174"
"ResourceRecordKey" => "29904802"
"ModificationTimestamp" => "2026-06-15T17:28:30.95Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29904802_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29904802/b76451909fe43ee88ee0dd2d5a83dbe0.webp"
"MediaSize" => 175118
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29904802/thumbnail-b76451909fe43ee88ee0dd2d5a83dbe0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446174"
"ResourceRecordKey" => "29904802"
"ModificationTimestamp" => "2026-06-15T17:28:30.95Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29904802_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29904802/346e3d68be278345425dda7019a5a170.webp"
"MediaSize" => 194442
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29904802/thumbnail-346e3d68be278345425dda7019a5a170.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446174"
"ResourceRecordKey" => "29904802"
"ModificationTimestamp" => "2026-06-15T17:28:30.95Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29904802_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29904802/350f3715762135c60c14c157f0ed0a6c.webp"
"MediaSize" => 213693
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29904802/thumbnail-350f3715762135c60c14c157f0ed0a6c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446174"
"ResourceRecordKey" => "29904802"
"ModificationTimestamp" => "2026-06-15T17:28:30.95Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29904802_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29904802/ba41e75ee6349feb6e272b66417f6115.webp"
"MediaSize" => 169930
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29904802/thumbnail-ba41e75ee6349feb6e272b66417f6115.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446174"
"ResourceRecordKey" => "29904802"
"ModificationTimestamp" => "2026-06-15T17:28:30.95Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29904802_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29904802/8232f93b096fafcb64ff473f958dc314.webp"
"MediaSize" => 150312
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29904802/thumbnail-8232f93b096fafcb64ff473f958dc314.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446174"
"ResourceRecordKey" => "29904802"
"ModificationTimestamp" => "2026-06-15T17:28:30.95Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29904802_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29904802/b91a6405c8730d8b4d4349f651ed5090.webp"
"MediaSize" => 170127
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29904802/thumbnail-b91a6405c8730d8b4d4349f651ed5090.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446174"
"ResourceRecordKey" => "29904802"
"ModificationTimestamp" => "2026-06-15T17:28:30.95Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29904802_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29904802/b2da271124093c57d894868c6ca24ef8.webp"
"MediaSize" => 172697
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29904802/thumbnail-b2da271124093c57d894868c6ca24ef8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13446174"
"ResourceRecordKey" => "29904802"
"ModificationTimestamp" => "2026-06-15T17:28:30.95Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29904802_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29904802/e8c5a8cdab68a72523c8b3ac0c7365b0.webp"
"MediaSize" => 164282
…9
]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29904802')"
+"ID": "1530574"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25185
+post_id: "1526535"
+post_author: 1
+"ListingKey": "29897624"
+"ListingId": "40836838"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T20:00:13Z"
+"RFModificationTimestamp": "2026-06-15T20:03:03Z"
+"ListPrice": 795000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2040.0
+"BuildingAreaTotal": 0
+"City": "Thorold"
+"PostalCode": "L3B0G7"
+"UnparsedAddress": "13 STEVEN Drive, Thorold, Ontario L3B0G7"
+"Coordinates": array:2 [
0 => -79.2333741
1 => 43.0389819
]
+"Latitude": 43.0389819
+"Longitude": -79.2333741
+"YearBuilt": 2020
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this stunning 4-bedroom detached home located in a sought-after newer neighborhood. Boasting over 2,000 square feet of living space, this property is designed to impress with its spacious layout and modern features. The master suite is a true retreat, offering a luxurious ensuite complete with a relaxing jacuzzi tub and a large walk-in closet. The bright, open-concept eat-in kitchen is perfect for both entertaining and everyday cooking, flowing seamlessly into the living room that is filled with natural light. With 2.5 bathrooms and generously sized bedrooms, there is plenty of space for the whole family. The home also includes a double car garage, providing ample parking and storage, as well as a full, unfinished basement. Situated in a quiet, family-friendly area with easy access to the406, school transit, and parks, this home is the perfect combination of comfort and convenience. Don't miss the opportunity to make this beautiful property your next home! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Freezer"
]
+"ArchitecturalStyle": array:1 [
0 => "Contemporary"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-13T00:10:51.942029+00:00"
+"Directions": "Kottmeier to Alexandra to Steven"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2071310"
+"ListOfficeKey": "300280"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T19:51:41Z"
+"PhotosCount": 46
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T19:51:41Z"
+"Stories": "2.0"
+"StreetName": "STEVEN"
+"StreetNumber": "13"
+"StreetSuffix": "Drive"
+"SubdivisionName": "562 - Hurricane/Merrittville"
+"TaxAnnualAmount": "6077.22"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29897624/13-steven-drive-thorold"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R3-11"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 36.0
+"AboveGradeFinishedArea": 2040
+"OriginalEntryTimestamp": "2026-06-12T19:52:03.88Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1346519"
+"ListOfficeNationalAssociationId": "1485444"
+"Media": array:46 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29897624')"
+"ID": "1526535"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25182
+post_id: "1525596"
+post_author: 1
+"ListingKey": "29898089"
+"ListingId": "X13439618"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T23:55:14Z"
+"RFModificationTimestamp": "2026-06-12T23:56:15Z"
+"ListPrice": 617900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Thorold (Hurricane/Merrittville)"
+"PostalCode": "L2V0G8"
+"UnparsedAddress": "27 LAMB CRESCENT, Thorold (Hurricane/Merrittville), Ontario L2V0G8"
+"Coordinates": array:2 [
0 => -79.235643
1 => 43.028314
]
+"Latitude": 43.028314
+"Longitude": -79.235643
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 27 Lamb Crescent! This spectacular freehold townhouse backs onto a breathtaking,serene pond, offering stunning nature views right from your backyard. The bright main floor features a convenient powder room. Upstairs, relax in three spacious bedrooms and two full washrooms. The ultimate highlight? A premium finished walk-out basement boasting a fourth bedroom, a recreation room, and a three-piece washroom-perfect for guests or a private retreat. Your dream home awaits! (id:62650)"
+"Appliances": array:3 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
]
+"Basement": array:3 [
0 => "Finished"
1 => "Walk out"
2 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T21:25:03.730814+00:00"
+"Directions": "Merritt Road and Niagara Street"
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2007055"
+"ListOfficeKey": "238732"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "21.7 x 105 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-12T23:45:21Z"
+"PhotosCount": 35
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T23:45:21Z"
+"Stories": "2.0"
+"StreetName": "Lamb"
+"StreetNumber": "27"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "4827"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "562 - Hurricane/Merrittville"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29898089/27-lamb-crescent-thorold-hurricanemerrittville-562-hurricanemerrittville"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 21.8
+"OriginalEntryTimestamp": "2026-06-12T20:56:42.52Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1289171"
+"ListOfficeNationalAssociationId": "1200762"
+"Media": array:35 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29898089')"
+"ID": "1525596"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25186
+post_id: "1524836"
+post_author: 1
+"ListingKey": "29897642"
+"ListingId": "X13439294"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T20:05:04Z"
+"RFModificationTimestamp": "2026-06-15T20:08:20Z"
+"ListPrice": 795000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Thorold (Hurricane/Merrittville)"
+"PostalCode": "L3B0G7"
+"UnparsedAddress": "13 STEVEN DRIVE, Thorold (Hurricane/Merrittville), Ontario L3B0G7"
+"Coordinates": array:2 [
0 => -79.233365
1 => 43.0389705
]
+"Latitude": 43.0389705
+"Longitude": -79.233365
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Niagara Association of REALTORS®"
+"PublicRemarks": "Welcome to this stunning 4-bedroom detached home located in a sought-after newer neighborhood. Boasting over 2,000 square feet of living space, this property is designed to impress with its spacious layout and modern features. The master suite is a true retreat, offering a luxurious ensuite complete with a relaxing jacuzzi tub and a large walk-in closet. The bright, open-concept eat-in kitchen is perfect for both entertaining and everyday cooking, flowing seamlessly into the living room that is filled with natural light. With 2.5 bathrooms and generously sized bedrooms, there is plenty of space for the whole family. The home also includes a double car garage, providing ample parking and storage, as well as a full, unfinished basement. Situated in a quiet, family-friendly area with easy access to the406, school transit, and parks, this home is the perfect combination of comfort and convenience. Don't miss the opportunity to make this beautiful property your next home! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Freezer"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T20:38:46.131578+00:00"
+"Directions": "Cross Streets: Alexandra. ** Directions: Kottmeier to Alexandra to Steven."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2071310"
+"ListOfficeKey": "292364"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "36.2 x 93.7 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T19:56:51Z"
+"PhotosCount": 45
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T19:56:51Z"
+"Stories": "2.0"
+"StreetName": "Steven"
+"StreetNumber": "13"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "6077.22"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Niagara"
+"CityRegion": "562 - Hurricane/Merrittville"
+"ListAORKey": "114"
+"ListingURL": "www.realtor.ca/real-estate/29897642/13-steven-drive-thorold-hurricanemerrittville-562-hurricanemerrittville"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2019760"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "292362"
+"GeocodeManualYN": true
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "R3-11"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 36.2
+"OriginalEntryTimestamp": "2026-06-12T19:57:02.54Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1346519"
+"ListOfficeNationalAssociationId": "1411645"
+"CoListAgentNationalAssociationId": "1299632"
+"CoListOfficeNationalAssociationId": "1410928"
+"Media": array:45 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29897642')"
+"ID": "1524836"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25184
+post_id: "1524461"
+post_author: 1
+"ListingKey": "29895194"
+"ListingId": "X13436780"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T14:25:03Z"
+"RFModificationTimestamp": "2026-06-16T14:25:47Z"
+"ListPrice": 725000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Thorold (Hurricane/Merrittville)"
+"PostalCode": "L3B0K8"
+"UnparsedAddress": "106 HIGGINS AVENUE, Thorold (Hurricane/Merrittville), Ontario L3B0K8"
+"Coordinates": array:2 [
0 => -79.226783
1 => 43.037652
]
+"Latitude": 43.037652
+"Longitude": -79.226783
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this stunning home in the growing community of Thorold-where modern comfort meets elegant design. This beautifully maintained 4-bedroom, 3-bathroom over 2300 sq ft & freshly painted home offers the perfect blend of space, style, and functionality for today's family living. Step inside to be greeted by a grand double-height foyer that creates an immediate semse of openness and luxury. The main level features a bright and airy layout with generous living and dining spaces, ideal for both everyday living and entertaining. Large windows fill the home with natural light, enhancing the warm and inviting atmosphere throughout. Upstairs, you'll find four spacious bedrooms, including a well-appointed primary suite designed for relaxation with separate laundry upstairs; this home ensures comfort and convenience for the entire family. Located in a desirable and fast-growing neighbourhood, this home offers easy access to schools, parks, shopping, and highways-making it a perfect choice for commuters and families alike. Don't miss your opportunity to own a beautiful home in one of Niagara's most promising communities! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Oven"
4 => "Dryer"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T19:48:32.215865+00:00"
+"Directions": "Kottmeier Rd & Higgins Ave"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Aluminum siding"
]
+"Flooring": array:3 [
0 => "Tile"
1 => "Hardwood"
2 => "Carpeted"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2169663"
+"ListOfficeKey": "50168"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "33.1 x 91.9 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-12T15:30:33Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T14:19:42Z"
+"Stories": "2.0"
+"StreetName": "Higgins"
+"StreetNumber": "106"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "6684.94"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "562 - Hurricane/Merrittville"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29895194/106-higgins-avenue-thorold-hurricanemerrittville-562-hurricanemerrittville"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "R1D-54"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 33.1
+"OriginalEntryTimestamp": "2026-06-12T15:30:32.89Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1420279"
+"ListOfficeNationalAssociationId": "1003101"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29895194')"
+"ID": "1524461"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25179
+post_id: "1518938"
+post_author: 1
+"ListingKey": "29887664"
+"ListingId": "X13430194"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T12:05:19Z"
+"RFModificationTimestamp": "2026-06-15T12:13:32Z"
+"ListPrice": 545000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Welland (N. Welland)"
+"PostalCode": "L3C3G3"
+"UnparsedAddress": "71 QUAKER ROAD, Welland (N. Welland), Ontario L3C3G3"
+"Coordinates": array:2 [
0 => -79.2452652
1 => 43.0219724
]
+"Latitude": 43.0219724
+"Longitude": -79.2452652
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Niagara Association of REALTORS®"
+"PublicRemarks": "North Welland | Large Fenced Yard | Detached Garage. From front to back, this charming 1.5-storey home has it all! Offering a functional and inviting layout, the main floor features a bright living room, separate dining room open to the kitchen, a spacious 5-piece bathroom, and a primary bedroom with garden doors leading directly to the backyard.Upstairs, you'll find a second bedroom along with a versatile bonus space, perfect for a home office, reading nook, or hobby area.Step outside to your own private backyard oasis. Whether you're unwinding in the hot tub, gathering with friends around the fire pit, or entertaining under the pergola, this fully fenced yard provides the perfect setting to relax and enjoy. Detached single car garage.Additional updates offer peace of mind, including siding (2023), furnace (2017), and roof (approximately 2014).This delightful North Welland home is full of character, comfort, and outdoor living space. Come see it for yourself and fall in love! (id:62650)"
+"Appliances": array:1 [
0 => "Water meter"
]
+"Basement": array:4 [
0 => "Unfinished"
1 => "Full"
2 => "Crawl space"
3 => "N/A"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T15:56:38.076932+00:00"
+"Directions": "Cross Streets: Niagara St. ** Directions: Quaker Road."
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"Fencing": array:2 [
0 => "Fenced yard"
1 => "Fully Fenced"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1951448"
+"ListOfficeKey": "290582"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Gazebo"
]
+"LotSizeDimensions": "50 x 200 FT"
+"ParkingFeatures": array:3 [
0 => "Detached Garage"
1 => "Garage"
2 => "RV"
]
+"PhotosChangeTimestamp": "2026-06-11T13:26:20Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T11:58:50Z"
+"Stories": "1.5"
+"StreetName": "Quaker"
+"StreetNumber": "71"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "3290"
+"VirtualTourURLUnbranded": "https://dl.dropboxusercontent.com/scl/fi/7usiqmh23gd6zfwchab0z/71-Quaker-Rd-Welland-Walkthrough.mp4?rlkey=y7ymtqo25m7resgbj792cm54q&raw=1"
+"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": "767 - N. Welland"
+"ListAORKey": "114"
+"ListingURL": "www.realtor.ca/real-estate/29887664/71-quaker-road-welland-n-welland-767-n-welland"
+"ParkingTotal": 7
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 2
+"FrontageLengthNumeric": 50.0
+"OriginalEntryTimestamp": "2026-06-11T13:26:20.27Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1245349"
+"ListOfficeNationalAssociationId": "1389351"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29887664')"
+"ID": "1518938"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23374
+post_id: "1510372"
+post_author: 1
+"ListingKey": "29876061"
+"ListingId": "X13419914"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-09T20:55:48Z"
+"RFModificationTimestamp": "2026-06-09T20:59:32Z"
+"ListPrice": 699000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Thorold (Hurricane/Merrittville)"
+"PostalCode": "L3B0G7"
+"UnparsedAddress": "6 DOREEN DRIVE, Thorold (Hurricane/Merrittville), Ontario L3B0G7"
+"Coordinates": array:2 [
0 => -79.231265
1 => 43.037416
]
+"Latitude": 43.037416
+"Longitude": -79.231265
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this 4-bedroom, 3-bathroom detached Empire Legacy home offering 2,027 sq.ft. of well-designed living space in a family-oriented neighbourhood in addition to around 914 sq.ft. of unfinished basement. The main floor features 9-foot ceilings, a practical open-concept layout, a kitchen with breakfast area, a great room, a powder room, and convenient main-floor laundry with direct access to the double-car garage. The second floor includes a primary bedroom with a walk-in closet and private ensuite featuring a soaker tub and separate shower, along with three additional bedrooms and a full bathroom. Additional features include an oak staircase, parking for up to four vehicles with a double-car garage and double driveway, and an unfinished basement with a bathroom rough-in providing ample storage space. Conveniently located just 5 minutes from Seaway Mall, Walmart, Canadian Tire, RONA, Niagara College, restaurants, and everyday amenities. Brock University, neighbourhood schools, parks, and major transportation routes are all within easy reach, with Niagara Falls and Niagara Health approximately 20 minutes away and Toronto less than 90 minutes away. A well-located home offering comfortable living with convenient access to shopping, education, healthcare, and commuter routes. (id:62783)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Dryer"
2 => "Blinds"
3 => "Garage door opener"
4 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-09T16:43:54.857185+00:00"
+"Directions": "Cross Streets: Kottmeier Rd & Merritt Rd. ** Directions: Turn West on Vaughn Drive from Kottmeier Rd, North on Legacy, West on Doreen Drive. Arrive at property on the right."
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:2 [
0 => "Tile"
1 => "Carpeted"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1930920"
+"ListOfficeKey": "279377"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "36.1 x 91.9 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-09T20:48:36Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-09T20:48:36Z"
+"Stories": "2.0"
+"StreetName": "Doreen"
+"StreetNumber": "6"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "6337"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "562 - Hurricane/Merrittville"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29876061/6-doreen-drive-thorold-hurricanemerrittville-562-hurricanemerrittville"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "R3-11"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 36.1
+"OriginalEntryTimestamp": "2026-06-09T15:54:06.12Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1231569"
+"ListOfficeNationalAssociationId": "1303783"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29876061')"
+"ID": "1510372"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25187
+post_id: "1508513"
+post_author: 1
+"ListingKey": "29871248"
+"ListingId": "40837370"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T17:30:14Z"
+"RFModificationTimestamp": "2026-06-12T17:33:17Z"
+"ListPrice": 674900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1800.0
+"BuildingAreaTotal": 0
+"City": "Welland"
+"PostalCode": "L3C7G3"
+"UnparsedAddress": "3 MADISON Court, Welland, Ontario L3C7G3"
+"Coordinates": array:2 [
0 => -79.2435791
1 => 43.0209822
]
+"Latitude": 43.0209822
+"Longitude": -79.2435791
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "First time ever offered on the market! This solid all-brick two-storey home has been lovingly maintained by its original owner and presents a rare opportunity to make it your own. Offering 3 bedrooms, 3 bathrooms, and a unique floor plan full of potential, this home is ideal for buyers looking to personalize a well-built property in an established neighbourhood. Situated on a desirable corner lot on a quiet court, you'll enjoy added privacy with no rear neighbours. The spacious layout offers generous principal rooms, plenty of natural light, and endless possibilities for updating to suit your style and needs. Close to schools, parks, shopping, and everyday amenities, this is a property you won't want to miss. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-08T19:56:32.292596+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2239332"
+"ListOfficeKey": "299787"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-12T17:01:42Z"
+"PhotosCount": 48
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T17:01:42Z"
+"Stories": "2.0"
+"StreetName": "MADISON"
+"StreetNumber": "3"
+"StreetSuffix": "Court"
+"SubdivisionName": "767 - N. Welland"
+"TaxAnnualAmount": "5400"
+"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=L17hP3btIzc"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29871248/3-madison-court-welland"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "O1, RL1-9"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 41.0
+"AboveGradeFinishedArea": 1800
+"OriginalEntryTimestamp": "2026-06-08T18:19:52.16Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1477234"
+"ListOfficeNationalAssociationId": "1476818"
+"Media": array:48 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
]
+"DaysOnMarket": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29871248')"
+"ID": "1508513"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25207
+post_id: "1504741"
+post_author: 1
+"ListingKey": "29867246"
+"ListingId": "X13411800"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-07T14:30:10Z"
+"RFModificationTimestamp": "2026-06-07T14:48:44Z"
+"ListPrice": 1175000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Welland (Hwy 406/Welland)"
+"PostalCode": "L3B0B7"
+"UnparsedAddress": "121 TURNBERRY TRAIL, Welland (Hwy 406/Welland), Ontario L3B0B7"
+"Coordinates": array:2 [
0 => -79.2134077
1 => 43.0235721
]
+"Latitude": 43.0235721
+"Longitude": -79.2134077
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "London and St. Thomas Association of REALTORS®"
+"PublicRemarks": "Welcome to your personal sanctuary at this breathtaking Luchetta-built walkout bungalow, perfectly situated on a rare, premium canal lot in an award-winning Niagara community. From the moment you arrive at this stunning 2+1 bedroom, 3-bathroom detached home, you will feel a sense of unparalleled tranquility. With over $200,000 invested in exquisite, high-end finishes, every inch of this roughly 2500 square foot gem has been thoughtfully designed to inspire. Imagine entertaining loved ones under beautiful vaulted ceilings, preparing meals on gorgeous Cambria quartz counters, and walking across rich hardwood and porcelain floors. The magic continues on the fully finished lower level, where a spectacular dream games room awaits, complete with a cozy fireplace and a bistro-style bar with a waterfall quartz countertop perfect for hosting unforgettable evenings. The true masterpiece lies just outside your door. Step out to your private main-floor sundeck or walk out from the lower recreation room to experience clear, panoramic views of majestic ships gently traveling the world-renowned Welland Canal. This extraordinary property is heavily defined by its breathtaking area influences, backing directly onto a serene ravine and lush greenbelt conservation area. This unique positioning provides an idyllic, peaceful, and indirect waterfront atmosphere. Embrace a life of ultimate leisure, community, and convenience. Your exclusive clubhouse center invites you to enjoy a heated indoor pool, gym, and pickleball courts. For ultimate peace of mind, the association takes care of the grass cutting, home security system, and snow removal right to your front door. More than just a gorgeous home, this is truly a lifestyle. (id:62783)"
+"Appliances": array:4 [
0 => "Central Vacuum"
1 => "Range"
2 => "Garage door opener remote(s)"
3 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:4 [
0 => "Finished"
1 => "Full"
2 => "Walk out"
3 => "N/A"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-07T14:48:41.840917+00:00"
+"Directions": "Cross Streets: Turnberry Trail and Perth Trail. ** Directions: From Hwy 406 Take Daimler Pkwy west. Then Left on Perth trail. Then right on Turnberry Trail."
+"ExteriorFeatures": array:2 [
0 => "Stucco"
1 => "Brick Veneer"
]
+"FireplaceFeatures": array:1 [
0 => "Insert"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2255891"
+"ListOfficeKey": "282722"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Hillside"
1 => "Sump Pump"
]
+"LotSizeDimensions": "32.1 x 166 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-07T14:21:30Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-07T14:21:30Z"
+"Stories": "1.0"
+"StreetName": "Turnberry"
+"StreetNumber": "121"
+"StreetSuffix": "Trail"
+"TaxAnnualAmount": "10402"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"View": "View of water,Direct Water View"
+"WaterBodyName": "Welland Canal"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "London and St. Thomas"
+"TaxYear": 2025
+"CityRegion": "766 - Hwy 406/Welland"
+"ListAORKey": "13"
+"ListingURL": "www.realtor.ca/real-estate/29867246/121-turnberry-trail-welland-hwy-406welland-766-hwy-406welland"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2093569"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "282722"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Alarm system"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"WaterfrontFeatures": array:1 [
0 => "Waterfront on canal"
]
+"FrontageLengthNumeric": 32.1
+"OriginalEntryTimestamp": "2026-06-07T13:22:19.61Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1494962"
+"ListOfficeNationalAssociationId": "1323007"
+"CoListAgentNationalAssociationId": "1366018"
+"CoListOfficeNationalAssociationId": "1323007"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 9
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29867246')"
+"ID": "1504741"
}
]
+success: true
+page_size: 9
+page_count: 9
+count: 76
+after_key: ""
}
"RF Response Time" => "0.22 seconds"
]
]