array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29507583 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23441
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23443
+post_id: "1249446"
+post_author: 1
+"ListingKey": "29507583"
+"ListingId": "X12913478"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-04T12:05:21Z"
+"RFModificationTimestamp": "2026-05-04T12:08:38Z"
+"ListPrice": 639900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Welland (Hwy 406/Welland)"
+"PostalCode": "L3B6G4"
+"UnparsedAddress": "50 AARON TRAIL, Welland (Hwy 406/Welland), Ontario L3B6G4"
+"Coordinates": array:2 [
0 => -79.2183551
1 => 43.02347
]
+"Latitude": 43.02347
+"Longitude": -79.2183551
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Niagara Association of REALTORS®"
+"PublicRemarks": "This END UNIT Bungalow townhome is sure to impress, with nine foot ceilings and an open concept design. Situated in the relaxed community of 'The Highlands', this home offers approximately 1800 sqft of finished living space on both levels and is tastefully decorated in neutral tones. The space provides loads of natural light, California shutters and a large sliding door with easy access to the covered patio for outdoor living. The generously sized primary bedroom has a 4 piece ensuite, walk-in closet, as well as two more closets in this exclusive space. The second bedroom, with double closet can also be used as a sitting room or office workspace. A second main floor bathroom with shower is conveniently located next to the main floor laundry closet. Inside access to the garage makes grocery day an easy task. A large kitchen peninsula and an abundance of cupboards will make food prep and entertaining a joy for you and your guests. Downstairs is a large bedroom with 4 pc ensuite and an additional large family room across the hall for movie night. There is no shortage of storage, two more (11x14) rooms with further development potential. There is a monthly homeowner's fee ($300/mo.) which includes lawn maintenance, snow removal, alarm monitoring and use of the community clubhouse that is private with exclusive use for 'The Highlands' neighbourhood members. The clubhouse has an indoor saltwater pool, hot tub, fitness center, pickleball courts and amenities to engage in social activities or host group events. Book your private viewing today! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:1 [
0 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-03-24T17:45:51.311986+00:00"
+"Directions": "Cross Streets: Perth Trail & Old Course Trail. ** Directions: East side of Woodlawn to Daimler Pky, left on Perth Trail and left on Aaron Trail."
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2052298"
+"ListOfficeKey": "296348"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Flat site"
1 => "Sump Pump"
]
+"LotSizeDimensions": "46.6 x 114.8 FT"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Tandem"
]
+"PhotosChangeTimestamp": "2026-03-24T14:26:28Z"
+"PhotosCount": 36
+"PoolFeatures": array:2 [
0 => "Inground pool"
1 => "Indoor pool"
]
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-05-04T11:58:05Z"
+"Stories": "1.0"
+"StreetName": "Aaron"
+"StreetNumber": "50"
+"StreetSuffix": "Trail"
+"TaxAnnualAmount": "5971"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://www.thebteam.ca/listings/308-50-aaron-trail-welland-l3b-6g4"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [
"RoomKey" => "1626951352"
"RoomType" => "Kitchen"
"ListingId" => "X12913478"
"RoomLevel" => "Main level"
"RoomWidth" => 4.2672
"ListingKey" => "29507583"
"RoomLength" => 3.048
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-05-04T11:58:05.06Z"
]
1 => array:11 [
"RoomKey" => "1626951353"
"RoomType" => "Family room"
"ListingId" => "X12913478"
"RoomLevel" => "Basement"
"RoomWidth" => 5.7912
"ListingKey" => "29507583"
"RoomLength" => 3.9624
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-05-04T11:58:05.06Z"
]
2 => array:11 [
"RoomKey" => "1626951354"
"RoomType" => "Utility room"
"ListingId" => "X12913478"
"RoomLevel" => "Basement"
"RoomWidth" => 4.2672
"ListingKey" => "29507583"
"RoomLength" => 3.3528
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-05-04T11:58:05.06Z"
]
3 => array:11 [
"RoomKey" => "1626951355"
"RoomType" => "Other"
"ListingId" => "X12913478"
"RoomLevel" => "Basement"
"RoomWidth" => 4.2672
"ListingKey" => "29507583"
"RoomLength" => 3.3528
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-05-04T11:58:05.07Z"
]
4 => array:11 [
"RoomKey" => "1626951356"
"RoomType" => "Dining room"
"ListingId" => "X12913478"
"RoomLevel" => "Main level"
"RoomWidth" => 4.2672
"ListingKey" => "29507583"
"RoomLength" => 2.7432
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-05-04T11:58:05.07Z"
]
5 => array:11 [
"RoomKey" => "1626951357"
"RoomType" => "Living room"
"ListingId" => "X12913478"
"RoomLevel" => "Main level"
"RoomWidth" => 4.2672
"ListingKey" => "29507583"
"RoomLength" => 3.6576
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-05-04T11:58:05.07Z"
]
6 => array:11 [
"RoomKey" => "1626951358"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12913478"
"RoomLevel" => "Main level"
"RoomWidth" => 3.9624
"ListingKey" => "29507583"
"RoomLength" => 3.6576
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-05-04T11:58:05.07Z"
]
7 => array:11 [
"RoomKey" => "1626951359"
"RoomType" => "Bathroom"
"ListingId" => "X12913478"
"RoomLevel" => "Main level"
"RoomWidth" => 2.7432
"ListingKey" => "29507583"
"RoomLength" => 2.1336
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-05-04T11:58:05.07Z"
]
8 => array:11 [
"RoomKey" => "1626951360"
"RoomType" => "Bedroom 2"
"ListingId" => "X12913478"
"RoomLevel" => "Main level"
"RoomWidth" => 3.9624
"ListingKey" => "29507583"
"RoomLength" => 3.048
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-05-04T11:58:05.07Z"
]
9 => array:11 [
"RoomKey" => "1626951361"
"RoomType" => "Bathroom"
"ListingId" => "X12913478"
"RoomLevel" => "Main level"
"RoomWidth" => 1.8288
"ListingKey" => "29507583"
"RoomLength" => 1.524
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-05-04T11:58:05.07Z"
]
10 => array:11 [
"RoomKey" => "1626951362"
"RoomType" => "Laundry room"
"ListingId" => "X12913478"
"RoomLevel" => "Main level"
"RoomWidth" => 1.2192
"ListingKey" => "29507583"
"RoomLength" => 1.2192
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-05-04T11:58:05.07Z"
]
11 => array:11 [
"RoomKey" => "1626951363"
"RoomType" => "Bedroom"
"ListingId" => "X12913478"
"RoomLevel" => "Basement"
"RoomWidth" => 5.4864
"ListingKey" => "29507583"
"RoomLength" => 3.048
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-05-04T11:58:05.07Z"
]
12 => array:11 [
"RoomKey" => "1626951364"
"RoomType" => "Bathroom"
"ListingId" => "X12913478"
"RoomLevel" => "Basement"
"RoomWidth" => 2.4384
"ListingKey" => "29507583"
"RoomLength" => 2.1336
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-05-04T11:58:05.07Z"
]
]
+"ListAOR": "Niagara"
+"CityRegion": "766 - Hwy 406/Welland"
+"ListAORKey": "114"
+"ListingURL": "www.realtor.ca/real-estate/29507583/50-aaron-trail-welland-hwy-406welland-766-hwy-406welland"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"SecurityFeatures": array:2 [
0 => "Security system"
1 => "Smoke Detectors"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 46.7
+"OriginalEntryTimestamp": "2026-03-24T14:26:28.05Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1327530"
+"ListOfficeNationalAssociationId": "1457435"
+"Media": array:36 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6538806114"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507583/9796dddbbbcb94ce50981de54ff29591.webp"
"MediaSize" => 229525
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507583/thumbnail-9796dddbbbcb94ce50981de54ff29591.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Front Entrance Foyer"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12913478"
"ResourceRecordKey" => "29507583"
"ModificationTimestamp" => "2026-03-24T14:26:28.06Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6538806150"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507583/3f84751db9e5a97a0b0db1ac39e39ed1.webp"
"MediaSize" => 166236
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507583/thumbnail-3f84751db9e5a97a0b0db1ac39e39ed1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "high ceilings"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12913478"
"ResourceRecordKey" => "29507583"
"ModificationTimestamp" => "2026-03-24T14:26:28.06Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6538806193"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507583/efff9280127de89a7d84a0638befd4ab.webp"
"MediaSize" => 172872
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507583/thumbnail-efff9280127de89a7d84a0638befd4ab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Walk in closet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12913478"
"ResourceRecordKey" => "29507583"
"ModificationTimestamp" => "2026-03-24T14:26:28.06Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6538806220"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507583/e58a2727227f44a06cb3c75f8a9998cc.webp"
"MediaSize" => 354374
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507583/thumbnail-e58a2727227f44a06cb3c75f8a9998cc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "private driveway"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12913478"
"ResourceRecordKey" => "29507583"
"ModificationTimestamp" => "2026-03-24T14:26:28.06Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6538806286"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507583/1928d26bf8cfa1326c996bcfb922ede3.webp"
"MediaSize" => 388160
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507583/thumbnail-1928d26bf8cfa1326c996bcfb922ede3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Community centre"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12913478"
"ResourceRecordKey" => "29507583"
"ModificationTimestamp" => "2026-03-24T14:26:28.06Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6538806350"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507583/efec98295c0f1208b65971d4d176a5dd.webp"
"MediaSize" => 339288
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507583/thumbnail-efec98295c0f1208b65971d4d176a5dd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Covered Patio"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12913478"
"ResourceRecordKey" => "29507583"
"ModificationTimestamp" => "2026-03-24T14:26:28.06Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6538806409"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507583/ab1ae82fe552f539718fc1d20e5b8690.webp"
"MediaSize" => 168207
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507583/thumbnail-ab1ae82fe552f539718fc1d20e5b8690.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Ensuite bathroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12913478"
"ResourceRecordKey" => "29507583"
"ModificationTimestamp" => "2026-03-24T14:26:28.06Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6538806501"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507583/f6cc9b3911a97446b6848b9e5c122d35.webp"
"MediaSize" => 174681
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507583/thumbnail-f6cc9b3911a97446b6848b9e5c122d35.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "2nd main floor bathroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12913478"
"ResourceRecordKey" => "29507583"
"ModificationTimestamp" => "2026-03-24T14:26:28.06Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6538806556"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507583/8bb0bca77a4fda503e11f72ba6db4d5b.webp"
"MediaSize" => 203838
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507583/thumbnail-8bb0bca77a4fda503e11f72ba6db4d5b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open Design"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12913478"
"ResourceRecordKey" => "29507583"
"ModificationTimestamp" => "2026-03-24T14:26:28.06Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6538806617"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507583/28c4cfbdac1f57e9bcba28023e832917.webp"
"MediaSize" => 251550
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507583/thumbnail-28c4cfbdac1f57e9bcba28023e832917.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Several windows"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12913478"
"ResourceRecordKey" => "29507583"
"ModificationTimestamp" => "2026-03-24T14:26:28.06Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6538806686"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507583/5e4169289cd14a591679ab3f306c892d.webp"
"MediaSize" => 232500
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507583/thumbnail-5e4169289cd14a591679ab3f306c892d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living room"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12913478"
"ResourceRecordKey" => "29507583"
"ModificationTimestamp" => "2026-03-24T14:26:28.06Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6538806708"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507583/32e3c86c64fbe6d30e5feebe427dc93e.webp"
"MediaSize" => 369557
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507583/thumbnail-32e3c86c64fbe6d30e5feebe427dc93e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "South views"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12913478"
"ResourceRecordKey" => "29507583"
"ModificationTimestamp" => "2026-03-24T14:26:28.06Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6538806727"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507583/e3f39a0e7a738fec719bedd873e4a366.webp"
"MediaSize" => 238476
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507583/thumbnail-e3f39a0e7a738fec719bedd873e4a366.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining room"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12913478"
"ResourceRecordKey" => "29507583"
"ModificationTimestamp" => "2026-03-24T14:26:28.06Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6538806760"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507583/0db5fc42dac0739f333bfc13213bbb1f.webp"
"MediaSize" => 245755
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507583/thumbnail-0db5fc42dac0739f333bfc13213bbb1f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Large Patio doors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12913478"
"ResourceRecordKey" => "29507583"
"ModificationTimestamp" => "2026-03-24T14:26:28.06Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6538806842"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507583/f49095c2b4c8c8914060634af05cf827.webp"
"MediaSize" => 209774
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507583/thumbnail-f49095c2b4c8c8914060634af05cf827.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Master bedroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12913478"
"ResourceRecordKey" => "29507583"
"ModificationTimestamp" => "2026-03-24T14:26:28.06Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6538806897"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507583/cf2f6de482a4c2fe58a240a214a39889.webp"
"MediaSize" => 357113
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507583/thumbnail-cf2f6de482a4c2fe58a240a214a39889.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Covered patio"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12913478"
"ResourceRecordKey" => "29507583"
"ModificationTimestamp" => "2026-03-24T14:26:28.06Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6538806952"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507583/7a1efbd5c6fb7a902853718e050db46d.webp"
"MediaSize" => 156245
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507583/thumbnail-7a1efbd5c6fb7a902853718e050db46d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "9ft ceilings"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12913478"
"ResourceRecordKey" => "29507583"
"ModificationTimestamp" => "2026-03-24T14:26:28.06Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6538807054"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507583/b388eb402570c572ab2daaa2dd6b4799.webp"
"MediaSize" => 201376
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507583/thumbnail-b388eb402570c572ab2daaa2dd6b4799.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Stainless Steel appliances"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12913478"
"ResourceRecordKey" => "29507583"
"ModificationTimestamp" => "2026-03-24T14:26:28.06Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6538807125"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507583/08d03fce31cf024ad4ff18c39b61f286.webp"
"MediaSize" => 241390
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507583/thumbnail-08d03fce31cf024ad4ff18c39b61f286.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Carpet free main space"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12913478"
"ResourceRecordKey" => "29507583"
"ModificationTimestamp" => "2026-03-24T14:26:28.06Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6538807200"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507583/e32d981df369fb5b0122c7ec165278d8.webp"
"MediaSize" => 342883
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507583/thumbnail-e32d981df369fb5b0122c7ec165278d8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Outdoor living space"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12913478"
"ResourceRecordKey" => "29507583"
"ModificationTimestamp" => "2026-03-24T14:26:28.06Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6538807273"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507583/843a0e03e885987f94ed5766435bef8c.webp"
"MediaSize" => 340714
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507583/thumbnail-843a0e03e885987f94ed5766435bef8c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "The Highlands aerial view"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12913478"
"ResourceRecordKey" => "29507583"
"ModificationTimestamp" => "2026-03-24T14:26:28.06Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6538807350"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507583/df5c02f36ae35f08a6f3b8297a26607d.webp"
"MediaSize" => 197586
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507583/thumbnail-df5c02f36ae35f08a6f3b8297a26607d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Loads of natural light"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12913478"
"ResourceRecordKey" => "29507583"
"ModificationTimestamp" => "2026-03-24T14:26:28.06Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6538807438"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507583/e5db19b3ebfb209d022ed37a800c38d6.webp"
"MediaSize" => 427140
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507583/thumbnail-e5db19b3ebfb209d022ed37a800c38d6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "END UNIT BUNGALOW"
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12913478"
"ResourceRecordKey" => "29507583"
"ModificationTimestamp" => "2026-03-24T14:26:28.06Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6538807492"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507583/985439588ea10257af0e3c734a3d81dc.webp"
"MediaSize" => 200368
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507583/thumbnail-985439588ea10257af0e3c734a3d81dc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom #2"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12913478"
"ResourceRecordKey" => "29507583"
"ModificationTimestamp" => "2026-03-24T14:26:28.06Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6538807561"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507583/66a613c1f7dc066d4b89779a1c457fca.webp"
"MediaSize" => 210489
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507583/thumbnail-66a613c1f7dc066d4b89779a1c457fca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Peninsula in kitchen"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12913478"
"ResourceRecordKey" => "29507583"
"ModificationTimestamp" => "2026-03-24T14:26:28.06Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6538807641"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507583/9c694f34d9345e4cb17e74a379480244.webp"
"MediaSize" => 227134
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507583/thumbnail-9c694f34d9345e4cb17e74a379480244.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "4 piece bathroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12913478"
"ResourceRecordKey" => "29507583"
"ModificationTimestamp" => "2026-03-24T14:26:28.06Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6538807689"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507583/87a3fdb6708ec8aefc1d3c7f59261c8c.webp"
"MediaSize" => 550644
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507583/thumbnail-87a3fdb6708ec8aefc1d3c7f59261c8c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "loads of privacy"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12913478"
"ResourceRecordKey" => "29507583"
"ModificationTimestamp" => "2026-03-24T14:26:28.06Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6538807753"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507583/8cbae2832fcaa7dafabdc5378d94b717.webp"
"MediaSize" => 386001
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507583/thumbnail-8cbae2832fcaa7dafabdc5378d94b717.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Courts at community centre"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12913478"
"ResourceRecordKey" => "29507583"
"ModificationTimestamp" => "2026-03-24T14:26:28.06Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6538807806"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507583/c7e1d420132f1400d3c4898d6b2a45f8.webp"
"MediaSize" => 332083
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507583/thumbnail-c7e1d420132f1400d3c4898d6b2a45f8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "North views"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12913478"
"ResourceRecordKey" => "29507583"
"ModificationTimestamp" => "2026-03-24T14:26:28.06Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6538807883"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507583/417df58af220c01d3a10321ba17e1ff9.webp"
"MediaSize" => 194225
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507583/thumbnail-417df58af220c01d3a10321ba17e1ff9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "large bedroom window"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12913478"
"ResourceRecordKey" => "29507583"
"ModificationTimestamp" => "2026-03-24T14:26:28.06Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6538807916"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507583/5937b3215167689767623f048e180849.webp"
"MediaSize" => 157610
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507583/thumbnail-5937b3215167689767623f048e180849.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "laundry closet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12913478"
"ResourceRecordKey" => "29507583"
"ModificationTimestamp" => "2026-03-24T14:26:28.06Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6538807942"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507583/d735f54c36f002cca728f75032b68aab.webp"
"MediaSize" => 176952
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507583/thumbnail-d735f54c36f002cca728f75032b68aab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Large bedroom #3"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12913478"
"ResourceRecordKey" => "29507583"
"ModificationTimestamp" => "2026-03-24T14:26:28.06Z"
]
32 => array:13 [
"Order" => 32
"MediaKey" => "6538807962"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507583/c5ba5e94c7445c3c83c05f9cc73da5d3.webp"
"MediaSize" => 170665
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507583/thumbnail-c5ba5e94c7445c3c83c05f9cc73da5d3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "walk in closet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12913478"
"ResourceRecordKey" => "29507583"
"ModificationTimestamp" => "2026-03-24T14:26:28.06Z"
]
33 => array:13 [
"Order" => 33
"MediaKey" => "6538808018"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507583/716869854e63601c58cd89a4ba3d8b8a.webp"
"MediaSize" => 215167
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507583/thumbnail-716869854e63601c58cd89a4ba3d8b8a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Recroom with double door entrance"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12913478"
"ResourceRecordKey" => "29507583"
"ModificationTimestamp" => "2026-03-24T14:26:28.06Z"
]
34 => array:13 [
"Order" => 34
"MediaKey" => "6538808044"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507583/1b9018347ba962104b05b5f3921d2928.webp"
"MediaSize" => 179959
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507583/thumbnail-1b9018347ba962104b05b5f3921d2928.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Ensuite for basement bedroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12913478"
"ResourceRecordKey" => "29507583"
"ModificationTimestamp" => "2026-03-24T14:26:28.06Z"
]
35 => array:13 [
"Order" => 35
"MediaKey" => "6538808078"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29507583/09e27233f779ae0c39715eae1a7598d3.webp"
"MediaSize" => 442259
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29507583/thumbnail-09e27233f779ae0c39715eae1a7598d3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Large bungalow"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12913478"
"ResourceRecordKey" => "29507583"
"ModificationTimestamp" => "2026-03-24T14:26:28.06Z"
]
]
+"DaysOnMarket": 97
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29507583')"
+"ID": "1249446"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 296348" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24860
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2052298" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24851
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29507583'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25250
+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 '29507583'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25266
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29507583' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.2183551 43.02347)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25338
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25313
+post_id: "1578256"
+post_author: 1
+"ListingKey": "29969373"
+"ListingId": "X13503494"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-30T05:35:12Z"
+"RFModificationTimestamp": "2026-06-30T06:43:09Z"
+"ListPrice": 969000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Thorold (Hurricane/Merrittville)"
+"PostalCode": "L3B0L2"
+"UnparsedAddress": "66 SUNFLOWER CRESCENT, Thorold (Hurricane/Merrittville), Ontario L3B0L2"
+"Coordinates": array:2 [
0 => -79.2284022
1 => 43.0388382
]
+"Latitude": 43.0388382
+"Longitude": -79.2284022
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Niagara Association of REALTORS®"
+"PublicRemarks": "Welcome to 66 Sunflower Crescent, an absolute masterpiece of modern luxury nestled in a thriving, highly sought-after Thorold community. This sun-drenched, double-car garage detached home spans more than 2,800 sq. ft. of pristine, carpet-free living space, boasting more than $75,000 in premium upgrades. As you step through the grand entrance-featuring soaring 9-feet ceiling and matching 8-feet doors on the Main level, you are greeted by gleaming hardwood flooring that flows seamlessly throughout the entire property. The Main floor is an entertainer's dream, illuminated by elegant pot-lights and anchored by an electric fireplace that adds a cozy ambiance to the Main living area. The chef-inspired kitchen is a true showstopper, complete with gas-stove, a stunning quartz waterfall countertop and custom under-mount lighting for the kitchen cabinets that creates an incredible evening vibe. Radiating with natural light , this home features huge windows in every room and enjoys the rare luxury of having no direct neighbours in front. Upstairs, convenience meets comfort with second-floor laundry. All 4 spacious bedrooms offer direct access to a bathroom, with 3 of them boasting their own private walk-in closets. Perfect for families, all 3 full bathrooms on the second floor are beautifully upgraded with sleek glass-door standing showers. For those looking for future potential, the home offers a separate side entrance, a 200 AMP electrical panel, a cold cellar, and a basement rough-in, ready to be customized to your exact needs. Backyard includes a gas line for a future BBQ. Outside, a massive driveway without any walkway offers an impressive capacity to park up to 6 cars. The location is truly unbeatable for families and commuters alike, you are steps away from local bus stops connecting directly to colleges, schools, and plazas, and just a minute's drive from Highway 406, whisking you away to major shopping centres, grocery stores and cities in no time. Pure Turnkey Bliss! (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Gas stove(s)"
3 => "Dishwasher"
4 => "Dryer"
5 => "Microwave"
6 => "Hood Fan"
7 => "Blinds"
8 => "Garage door opener"
]
+"Basement": array:4 [
0 => "Unfinished"
1 => "Separate entrance"
2 => "N/A"
3 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-30T06:43:00.890946+00:00"
+"Directions": "Cross Streets: Merritt Rd and Kottmeier Rd. ** Directions: From Hwy 406, take a left on Kottmeier Rd, then take right on Higgins Ave and left on Lavender Rd."
+"ExteriorFeatures": array:2 [
0 => "Aluminum siding"
1 => "Brick Veneer"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:1 [
0 => "Tile"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2210772"
+"ListOfficeKey": "75381"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "38 x 92 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-30T05:26:32Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-30T05:26:32Z"
+"Stories": "2.0"
+"StreetName": "Sunflower"
+"StreetNumber": "66"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "8497.21"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
0 => array:11 [
"RoomKey" => "1671740606"
"RoomType" => "Foyer"
"ListingId" => "X13503494"
"RoomLevel" => "Main level"
"RoomWidth" => 2.3
"ListingKey" => "29969373"
"RoomLength" => 2.2
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T05:26:32Z"
]
1 => array:11 [
"RoomKey" => "1671740607"
"RoomType" => "Bathroom"
"ListingId" => "X13503494"
"RoomLevel" => "Second level"
"RoomWidth" => 1.66
"ListingKey" => "29969373"
"RoomLength" => 2.74
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T05:26:32Z"
]
2 => array:11 [
"RoomKey" => "1671740608"
"RoomType" => "Bathroom"
"ListingId" => "X13503494"
"RoomLevel" => "Second level"
"RoomWidth" => 1.75
"ListingKey" => "29969373"
"RoomLength" => 3.29
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T05:26:32Z"
]
3 => array:11 [
"RoomKey" => "1671740609"
"RoomType" => "Bedroom"
"ListingId" => "X13503494"
"RoomLevel" => "Second level"
"RoomWidth" => 4.57
"ListingKey" => "29969373"
"RoomLength" => 5.7
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T05:26:32.01Z"
]
4 => array:11 [
"RoomKey" => "1671740610"
"RoomType" => "Bedroom 2"
"ListingId" => "X13503494"
"RoomLevel" => "Second level"
"RoomWidth" => 3.35
"ListingKey" => "29969373"
"RoomLength" => 3.35
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T05:26:32.01Z"
]
5 => array:11 [
"RoomKey" => "1671740611"
"RoomType" => "Bedroom 3"
"ListingId" => "X13503494"
"RoomLevel" => "Second level"
"RoomWidth" => 3.96
"ListingKey" => "29969373"
"RoomLength" => 4.26
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T05:26:32.01Z"
]
6 => array:11 [
"RoomKey" => "1671740612"
"RoomType" => "Partial bathroom"
"ListingId" => "X13503494"
"RoomLevel" => "Main level"
"RoomWidth" => 1.65
"ListingKey" => "29969373"
"RoomLength" => 1.92
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T05:26:32.01Z"
]
7 => array:11 [
"RoomKey" => "1671740613"
"RoomType" => "Bedroom 4"
"ListingId" => "X13503494"
"RoomLevel" => "Second level"
"RoomWidth" => 3.23
"ListingKey" => "29969373"
"RoomLength" => 3.54
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T05:26:32.01Z"
]
8 => array:11 [
"RoomKey" => "1671740614"
"RoomType" => "Mud room"
"ListingId" => "X13503494"
"RoomLevel" => "Main level"
"RoomWidth" => 2.09
"ListingKey" => "29969373"
"RoomLength" => 2.18
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T05:26:32.01Z"
]
9 => array:11 [
"RoomKey" => "1671740615"
"RoomType" => "Pantry"
"ListingId" => "X13503494"
"RoomLevel" => "Main level"
"RoomWidth" => 1.35
"ListingKey" => "29969373"
"RoomLength" => 1.51
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T05:26:32.01Z"
]
10 => array:11 [
"RoomKey" => "1671740616"
"RoomType" => "Kitchen"
"ListingId" => "X13503494"
"RoomLevel" => "Main level"
"RoomWidth" => 2.87
"ListingKey" => "29969373"
"RoomLength" => 4.45
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T05:26:32.01Z"
]
11 => array:11 [
"RoomKey" => "1671740617"
"RoomType" => "Dining room"
"ListingId" => "X13503494"
"RoomLevel" => "Main level"
"RoomWidth" => 4.57
"ListingKey" => "29969373"
"RoomLength" => 3.23
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T05:26:32.01Z"
]
12 => array:11 [
"RoomKey" => "1671740618"
"RoomType" => "Great room"
"ListingId" => "X13503494"
"RoomLevel" => "Main level"
"RoomWidth" => 4.26
"ListingKey" => "29969373"
"RoomLength" => 5.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T05:26:32.01Z"
]
13 => array:11 [
"RoomKey" => "1671740619"
"RoomType" => "Eating area"
"ListingId" => "X13503494"
"RoomLevel" => "Main level"
"RoomWidth" => 3.72
"ListingKey" => "29969373"
"RoomLength" => 4.45
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T05:26:32.02Z"
]
14 => array:11 [
"RoomKey" => "1671740620"
"RoomType" => "Laundry room"
"ListingId" => "X13503494"
"RoomLevel" => "Second level"
"RoomWidth" => 2.26
"ListingKey" => "29969373"
"RoomLength" => 2.95
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T05:26:32.02Z"
]
15 => array:11 [
"RoomKey" => "1671740621"
"RoomType" => "Bathroom"
"ListingId" => "X13503494"
"RoomLevel" => "Second level"
"RoomWidth" => 3.04
"ListingKey" => "29969373"
"RoomLength" => 3.6
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T05:26:32.02Z"
]
]
+"ListAOR": "Niagara"
+"TaxYear": 2025
+"CityRegion": "562 - Hurricane/Merrittville"
+"ListAORKey": "114"
+"ListingURL": "www.realtor.ca/real-estate/29969373/66-sunflower-crescent-thorold-hurricanemerrittville-562-hurricanemerrittville"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 38.0
+"OriginalEntryTimestamp": "2026-06-30T05:26:31.94Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1456632"
+"ListOfficeNationalAssociationId": "1004013"
+"Media": array:50 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29969373_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29969373/95de9d6888521046b0c1f61a6302aa08.webp"
"MediaSize" => 163606
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29969373/thumbnail-95de9d6888521046b0c1f61a6302aa08.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13503494"
"ResourceRecordKey" => "29969373"
"ModificationTimestamp" => "2026-06-30T05:26:31.95Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29969373_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29969373/41d7b296dbbe122c36be7f8177dd5c9a.webp"
"MediaSize" => 276175
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29969373/thumbnail-41d7b296dbbe122c36be7f8177dd5c9a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13503494"
"ResourceRecordKey" => "29969373"
"ModificationTimestamp" => "2026-06-30T05:26:31.95Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29969373_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29969373/950ebd613991cde4e93b55f910c6a74f.webp"
"MediaSize" => 230164
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29969373/thumbnail-950ebd613991cde4e93b55f910c6a74f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13503494"
"ResourceRecordKey" => "29969373"
"ModificationTimestamp" => "2026-06-30T05:26:31.95Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29969373_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29969373/7ccebda4eaa45861b46015f2b09499fd.webp"
"MediaSize" => 201662
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29969373/thumbnail-7ccebda4eaa45861b46015f2b09499fd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13503494"
"ResourceRecordKey" => "29969373"
"ModificationTimestamp" => "2026-06-30T05:26:31.95Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29969373_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29969373/99bdad402202cd7c543df43bac75e118.webp"
"MediaSize" => 164823
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29969373/thumbnail-99bdad402202cd7c543df43bac75e118.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13503494"
"ResourceRecordKey" => "29969373"
"ModificationTimestamp" => "2026-06-30T05:26:31.95Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29969373_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29969373/d620bf555f88dd89494e8a36c6f582e1.webp"
"MediaSize" => 134119
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29969373/thumbnail-d620bf555f88dd89494e8a36c6f582e1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13503494"
"ResourceRecordKey" => "29969373"
"ModificationTimestamp" => "2026-06-30T05:26:31.95Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29969373_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29969373/95c0f4c466069ab95797a6266507e41f.webp"
"MediaSize" => 218091
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29969373/thumbnail-95c0f4c466069ab95797a6266507e41f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13503494"
"ResourceRecordKey" => "29969373"
"ModificationTimestamp" => "2026-06-30T05:26:31.95Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29969373_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29969373/6265082cd8cc4e2302566137ae9595a7.webp"
"MediaSize" => 178883
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29969373/thumbnail-6265082cd8cc4e2302566137ae9595a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13503494"
"ResourceRecordKey" => "29969373"
"ModificationTimestamp" => "2026-06-30T05:26:31.95Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29969373_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29969373/0c4bd016a09b5e01c9cbb42d14be618c.webp"
"MediaSize" => 188634
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29969373/thumbnail-0c4bd016a09b5e01c9cbb42d14be618c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13503494"
"ResourceRecordKey" => "29969373"
"ModificationTimestamp" => "2026-06-30T05:26:31.95Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29969373_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29969373/fd9a7e133776dc4cf52d9af794f3c8c1.webp"
"MediaSize" => 143441
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29969373/thumbnail-fd9a7e133776dc4cf52d9af794f3c8c1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13503494"
"ResourceRecordKey" => "29969373"
"ModificationTimestamp" => "2026-06-30T05:26:31.95Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29969373_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29969373/f424636ff6c2a9dc660e84ad3621ba89.webp"
"MediaSize" => 145601
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29969373/thumbnail-f424636ff6c2a9dc660e84ad3621ba89.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13503494"
"ResourceRecordKey" => "29969373"
"ModificationTimestamp" => "2026-06-30T05:26:31.95Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29969373_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29969373/008f1935d83196bab4b1b2f280a4d9c9.webp"
"MediaSize" => 106234
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29969373/thumbnail-008f1935d83196bab4b1b2f280a4d9c9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13503494"
"ResourceRecordKey" => "29969373"
"ModificationTimestamp" => "2026-06-30T05:26:31.95Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29969373_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29969373/12fb6d6cff0bedd77b149d6de799c73a.webp"
"MediaSize" => 125758
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29969373/thumbnail-12fb6d6cff0bedd77b149d6de799c73a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13503494"
"ResourceRecordKey" => "29969373"
"ModificationTimestamp" => "2026-06-30T05:26:31.95Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29969373_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29969373/639ceb7d0f3666149ab011441b3ec77b.webp"
"MediaSize" => 161520
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29969373/thumbnail-639ceb7d0f3666149ab011441b3ec77b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13503494"
"ResourceRecordKey" => "29969373"
"ModificationTimestamp" => "2026-06-30T05:26:31.95Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29969373_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29969373/7ba3ca01aa7a44f0986dc02154714d84.webp"
"MediaSize" => 183776
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29969373/thumbnail-7ba3ca01aa7a44f0986dc02154714d84.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
…3
]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29969373')"
+"ID": "1578256"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25315
+post_id: "1577589"
+post_author: 1
+"ListingKey": "29968445"
+"ListingId": "X13502864"
+"PropertyType": "Residential"
+"PropertySubType": "Vacant Land"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T22:35:12Z"
+"RFModificationTimestamp": "2026-06-30T01:02:49Z"
+"ListPrice": 699000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Welland (Cooks Mills)"
+"PostalCode": "L0S1K0"
+"UnparsedAddress": "428 BIGGAR ROAD, Welland (Cooks Mills), Ontario L0S1K0"
+"Coordinates": array:2 [
0 => -79.201604
1 => 43.032781
]
+"Latitude": 43.032781
+"Longitude": -79.201604
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Niagara Association of REALTORS®"
+"PublicRemarks": "Build your dream home on this stunning 26-acre parcel featuring over 1,000 feet of frontage along Chippawa Creek. Offering the perfect balance of privacy and convenience, this beautiful property provides a peaceful country setting while remaining just minutes from shopping, schools, and other essential amenities. Whether you're envisioning a custom estate, hobby farm, or private retreat, this exceptional property offers endless potential. Buyers are advised to complete their own due diligence regarding zoning, permitted uses, and building opportunities. (id:62650)"
+"CreationDate": "2026-06-30T01:02:40.257661+00:00"
+"Directions": "Cross Streets: Moyer. ** Directions: Moyer/Biggar."
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1816780"
+"ListOfficeKey": "283409"
+"LotFeatures": array:2 [
0 => "Hillside"
1 => "Partially cleared"
]
+"LotSizeDimensions": "2132.67 x 913.8 FT"
+"PhotosChangeTimestamp": "2026-06-29T22:26:32Z"
+"PhotosCount": 14
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-29T22:26:32Z"
+"StreetName": "Biggar"
+"StreetNumber": "428"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "3385"
+"Utilities": array:1 [
0 => "Electricity"
]
+"View": "River view,View of water,Direct Water View"
+"WaterBodyName": "Welland River"
+"ListAOR": "Niagara"
+"TaxYear": 2025
+"CityRegion": "765 - Cooks Mills"
+"ListAORKey": "114"
+"ListingURL": "www.realtor.ca/real-estate/29968445/428-biggar-road-welland-cooks-mills-765-cooks-mills"
+"GeocodeManualYN": false
+"WaterfrontFeatures": array:1 [
0 => "Waterfront on river"
]
+"FrontageLengthNumeric": 2132.8
+"OriginalEntryTimestamp": "2026-06-29T22:26:32.07Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1192787"
+"ListOfficeNationalAssociationId": "1328620"
+"Media": array:14 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29968445')"
+"ID": "1577589"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25312
+post_id: "1576375"
+post_author: 1
+"ListingKey": "29966222"
+"ListingId": "X13500738"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T17:35:06Z"
+"RFModificationTimestamp": "2026-06-29T18:00:23Z"
+"ListPrice": 1110000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Welland (Hwy 406/Welland)"
+"PostalCode": "L3B0H4"
+"UnparsedAddress": "229 MIDLAND PLACE, Welland (Hwy 406/Welland), Ontario L3B0H4"
+"Coordinates": array:2 [
0 => -79.216442
1 => 43.013901
]
+"Latitude": 43.013901
+"Longitude": -79.216442
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Stunning custom home featuring a modern open-concept layout and over $200,000 in premium finishes. Striking exterior with oversized windows, stone detailing, and a stone portico entrance for exceptional curb appeal. Gourmet kitchen boasts quartz countertops, waterfall island, crown moulding, and upgraded fixtures. The primary suite offers his/her walk-in closets and a spa-inspired ensuite with full glass walk-in shower, quartz double vanity with LED mirrors, soaker tub, and modern finishes. Designed for families with convenient second-floor laundry and ensuite bathroom access for all bedrooms. Bedrooms 2 & 3 feature walk-in closets. Walk-out basement with separate entrance offers multi-generational living potential or space for a gym, theatre, or guest suite. Includes 3pc bathroom rough-in and cantina. Builder will entertain custom design & construction of finished basement at additional cost. A rare combination of style, function, and future flexibility don't miss this one! Limited time HST rebate program. (id:62783)"
+"Appliances": array:1 [
0 => "Water Heater - Tankless"
]
+"Basement": array:2 [
0 => "Walk out"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CreationDate": "2026-06-29T18:00:16.789214+00:00"
+"Directions": "Cross Streets: Daimler Pkwy/Midland. ** Directions: 406 South/Woodlawn Exit."
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Brick Facing"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2017532"
+"ListOfficeKey": "51015"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Irregular lot size"
1 => "Sloping"
]
+"LotSizeDimensions": "45.4 x 89.1 FT"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-06-29T16:59:52Z"
+"PhotosCount": 38
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-29T16:59:52Z"
+"Stories": "2.0"
+"StreetName": "Midland"
+"StreetNumber": "229"
+"StreetSuffix": "Place"
+"TaxAnnualAmount": "1"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"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": "Toronto"
+"CityRegion": "766 - Hwy 406/Welland"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29966222/229-midland-place-welland-hwy-406welland-766-hwy-406welland"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 45.4
+"OriginalEntryTimestamp": "2026-06-29T16:59:52.56Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1322406"
+"ListOfficeNationalAssociationId": "1095101"
+"Media": array:38 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29966222')"
+"ID": "1576375"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25316
+post_id: "1564693"
+post_author: 1
+"ListingKey": "29948384"
+"ListingId": "X13484780"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T19:25:05Z"
+"RFModificationTimestamp": "2026-06-26T00:50:11Z"
+"ListPrice": 990000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Thorold (Hurricane/Merrittville)"
+"PostalCode": "L2V0E6"
+"UnparsedAddress": "5 HOPKINS STREET, Thorold (Hurricane/Merrittville), Ontario L2V0E6"
+"Coordinates": array:2 [
0 => -79.242243
1 => 43.026931
]
+"Latitude": 43.026931
+"Longitude": -79.242243
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Upgraded and well-kept 4-bedroom detached home + extra bedroom/office and full washroom in the basement, featuring stone and stucco exterior for a modern architectural design, complemented by exterior pot lights that elevate the home's nighttime presence. Functional layout with exceptional living space throughout. Open-concept main floor with hardwood flooring, a modern kitchen featuring premium Frigidaire Professional appliances, gas stove, soft-close cabinetry, and a bright breakfast area overlooking the backyard through a spacious covered balcony. Large windows provide abundant natural light, while elegant Swarovski crystal chandeliers add a touch of luxury. Central vacuum system installed. The upper level offers well-proportioned bedrooms, all with walk-in closets, along with the convenience of second-floor laundry, ideal for family living.Builder-finished walkout basement designed for entertainment, featuring projector-ready setup with built-in ceiling speakers, a spacious recreation area with walkout to Patio, full washroom with shower, bedroom/office with closet, plus a large mechanical room and ample storage. Equipped with a high-efficiency Carrier HVAC system, HRV system, and tankless water heater (rented) for on-demand hot water. Enjoy a private backyard with covered seating area and a fully synthetic deck/balcony with privacy glass panels and natural gas BBQ connection, perfect for outdoor entertaining. Includes exterior sprinkler system for easy maintenance. Attached garage with parking for 2 vehicles plus driveway for up to 4. Conveniently located minutes from the Welland Sports Complex and Niagara Regional Exhibition Fairgrounds, along with major retailers and amenities including Walmart, Canadian Tire, RONA, LCBO, Mark's, and McDonald's, offering both convenience and a strong family-friendly location. (id:62783)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Central Vacuum"
2 => "Dryer"
3 => "Garage door opener remote(s)"
]
+"Basement": array:3 [
0 => "Finished"
1 => "Walk out"
2 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T00:48:57.929068+00:00"
+"Directions": "Cross Streets: HWY 406 & Merritt Rd. ** Directions: Take Highway 406 to the Merritt Road (Regional Rd 37) exit and head West. Turn South onto Eastman Gateway, then turn West onto McFerland. Follow the road as it transitions into Hopkins Street; the property will be located on your right."
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"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": "2040869"
+"ListOfficeKey": "279377"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "43.5 x 115 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-24T18:56:17Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T19:16:06Z"
+"Stories": "2.0"
+"StreetName": "Hopkins"
+"StreetNumber": "5"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "8317"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
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]
]
+"ListAOR": "Toronto"
+"CityRegion": "562 - Hurricane/Merrittville"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29948384/5-hopkins-street-thorold-hurricanemerrittville-562-hurricanemerrittville"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1930920"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "279377"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"ZoningDescription": "R1D-2"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 43.6
+"OriginalEntryTimestamp": "2026-06-24T18:56:17.54Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1316859"
+"ListOfficeNationalAssociationId": "1303783"
+"CoListAgentNationalAssociationId": "1231569"
+"CoListOfficeNationalAssociationId": "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": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29948384')"
+"ID": "1564693"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25314
+post_id: "1558763"
+post_author: 1
+"ListingKey": "29943376"
+"ListingId": "X13480256"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-28T19:50:01Z"
+"RFModificationTimestamp": "2026-06-28T19:51:20Z"
+"ListPrice": 809000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Thorold (Hurricane/Merrittville)"
+"PostalCode": "L0S1K0"
+"UnparsedAddress": "14 OVERHOLT DRIVE, Thorold (Hurricane/Merrittville), Ontario L0S1K0"
+"Coordinates": array:2 [
0 => -79.23774
1 => 43.030287
]
+"Latitude": 43.030287
+"Longitude": -79.23774
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "***BUILDER-FINISHED LEGAL BASEMENT *** ***CORNER HOUSE*** Welcome to this exceptional 4+2 bedroom detached home offering the perfect blend of family living and income potential. Featuring approximately 2,100 sq. ft. above grade plus a BUILDER-finished legal basement apartment with separate entrance, this property is ideal for investors, multi-generational families, or homeowners looking to offset their mortgage with rental income. Excellent Mortgage Helper with proven Rental History and potential for significant carrying-cost reduction. The thoughtfully designed main floor offers a spacious open-concept layout with a large Great Room, separate Dining Room, modern kitchen with centre island, breakfast area, and convenient mudroom with garage access. The second floor features four generous bedrooms, including a spacious primary retreat with walk-in closet and ensuite bath, an additional full bathroom, and the convenience of second-floor laundry. The legal basement apartment is fully self-contained and features 2 bedrooms, a full bathroom, kitchen rough-in, recreation/living area, separate laundry facilities, and private access, creating an excellent opportunity for additional rental income. Previously leased for approximately $2,500/month for the upper level and $1,600/month for the basement apartment in 2023, offering strong income-generating potential for investors and homeowners alike. Additional features include a double-car garage, central air conditioning, gas heating, separate laundry facilities for upper and basement occupants, and a functional layout designed for maximum flexibility and privacy. A rare opportunity to own a move-in-ready home with a legal secondary suite and excellent income potential in a desirable family-friendly neighborhood. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Gas stove(s)"
3 => "Dishwasher"
4 => "Dryer"
5 => "Microwave"
6 => "Hood Fan"
7 => "Garage door opener"
]
+"Basement": array:7 [
0 => "Finished"
1 => "Full"
2 => "Apartment in basement"
3 => "Separate entrance"
4 => "N/A"
5 => "N/A"
6 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:2 [
0 => "Central air conditioning"
1 => "Air exchanger"
]
+"CreationDate": "2026-06-23T21:31:30.916117+00:00"
+"Directions": "Cross Streets: Corner of Overholt Dr and Swart Ln. ** Directions: Map."
+"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": "2238056"
+"ListOfficeKey": "296729"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "51 x 98 FT ; 98.67 ft x 51.07 ft x 83.87 ft x 20.91ft"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-24T21:52:54Z"
+"PhotosCount": 45
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-28T19:42:43Z"
+"Stories": "2.0"
+"StreetName": "Overholt"
+"StreetNumber": "14"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "6633"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
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]
]
+"ListAOR": "Toronto"
+"CityRegion": "562 - Hurricane/Merrittville"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29943376/14-overholt-drive-thorold-hurricanemerrittville-562-hurricanemerrittville"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 51.0
+"OriginalEntryTimestamp": "2026-06-23T19:28:09.08Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1475967"
+"ListOfficeNationalAssociationId": "1461559"
+"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": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29943376')"
+"ID": "1558763"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25309
+post_id: "1542363"
+post_author: 1
+"ListingKey": "29920082"
+"ListingId": "X13459462"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T02:50:10Z"
+"RFModificationTimestamp": "2026-06-18T03:09:39Z"
+"ListPrice": 579000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Thorold (Hurricane/Merrittville)"
+"PostalCode": "L0S1K0"
+"UnparsedAddress": "226 MELODY LANE, Thorold (Hurricane/Merrittville), Ontario L0S1K0"
+"Coordinates": array:2 [
0 => -79.22818
1 => 43.03964
]
+"Latitude": 43.03964
+"Longitude": -79.22818
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 226 Melody Lane, a beautifully maintained full-brick freehold end-unit townhome offering the perfect blend of style, comfort, and functionality in a highly desirable family-friendly neighbourhood. This impressive 3-storey residence features 3 spacious bedrooms, 2.5 bathrooms, and a smart, modern layout designed for today's lifestyle.The ground level offers a versatile den/office space, ideal for working from home, a quiet study area, or additional flex space, along with convenient laundry and utility access. Hardwood stairs lead to the bright and inviting main living level, where you'll find an open-concept living and dining area filled with natural light. The modern kitchen is complete with stainless steel appliances, a centre island, ample cabinetry, and a practical layout perfect for everyday living and entertaining. Sliding doors open to a large private balcony, creating the ideal space to relax, enjoy morning coffee, or host family and friends. A convenient 2-piece powder room completes this level.The upper level features a spacious primary bedroom with a walk-in closet, private ensuite bathroom, and its own balcony for added comfort and privacy. Two additional well-sized bedrooms and a full 4-piece bathroom provide plenty of room for family, guests, or future growth.Move-in ready and thoughtfully designed throughout, this exceptional home offers modern finishes, functional living space, and the benefits of a completely freehold property with no condo fees. Ideally located close to schools, parks, shopping, transit, and major amenities, 226 Melody Lane is a fantastic opportunity for first-time buyers, growing families, and investors alike. (id:62783)"
+"Appliances": array:1 [
0 => "Water Heater"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T03:09:34.852412+00:00"
+"Directions": "Kottmeier Rd / Port Robinson Rd"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2193486"
+"ListOfficeKey": "292455"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "22.9 x 77.1 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T02:43:33Z"
+"PhotosCount": 29
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T02:43:33Z"
+"Stories": "3.0"
+"StreetName": "Melody"
+"StreetNumber": "226"
+"StreetSuffix": "Lane"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"CityRegion": "562 - Hurricane/Merrittville"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29920082/226-melody-lane-thorold-hurricanemerrittville-562-hurricanemerrittville"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2241169"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "292455"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 22.1
+"OriginalEntryTimestamp": "2026-06-18T02:43:33.13Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1442487"
+"ListOfficeNationalAssociationId": "1412201"
+"CoListAgentNationalAssociationId": "1479344"
+"CoListOfficeNationalAssociationId": "1412201"
+"Media": array:29 [
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]
]
+"DaysOnMarket": 12
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29920082')"
+"ID": "1542363"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23455
+post_id: "1532867"
+post_author: 1
+"ListingKey": "29907514"
+"ListingId": "X13448298"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-28T15:35:00Z"
+"RFModificationTimestamp": "2026-06-28T15:42:20Z"
+"ListPrice": 1175000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Welland (Hwy 406/Welland)"
+"PostalCode": "L3B6G7"
+"UnparsedAddress": "208 MUIRFIELD TRAIL, Welland (Hwy 406/Welland), Ontario L3B6G7"
+"Coordinates": array:2 [
0 => -79.2145044
1 => 43.020055
]
+"Latitude": 43.020055
+"Longitude": -79.2145044
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Niagara Association of REALTORS®"
+"PublicRemarks": "On a quiet cul-de-sac, nestled within the prestigious Highland Residences at Hunter's Pointe, this executive bungalow offers an unparalleled lifestyle defined by tranquillity and timeless design. Situated on a premium, pie-shaped lot, this home commands sweeping, panoramic views of the historic Welland Canal and the lush, natural landscapes that surround it. Inside, approximately 3,000 square feet of meticulously maintained living space unfolds across a thoughtfully designed 2+2 bedroom, 3 full bathroom layout. The main floor is anchored by an elegant living and dining area, where classic crown moulding, rich hardwood floors, and expansive windows frame the water views like living art. The bright kitchen features Corian countertops alongside a brand-new oven (2026) and a newly updated dishwasher (2024). Nearby, the primary suite offers a peaceful sanctuary overlooking the canal, finished with a generous walk-in closet and a private ensuite bath. The thoughtful layout extends into the fully finished walk-out lower level with 2 bedrooms, a full bathroom, a generous recreation space and a family room freshly carpeted in 2026. It provided an ideal, private haven for hosting extended family and weekend guests. Outside, a wraparound composite deck overlooks professionally landscaped, manicured grounds that roll gently toward the water, inviting quiet morning coffees or evening wine tastings as you watch the ships glide past. Living in Niagara's premier active adult community means your time is truly your own; with lawn maintenance and snow removal seamlessly taken care of right to your front door, you are granted full freedom to enjoy the community's award-winning clubhouse, indoor pool, and vibrant social calendar. Located just minutes from Highway 406, championship golf courses, and world-class wineries, this is more than just a home-it is a rare opportunity to secure a coveted waterfront lifestyle in one of Niagara's most sought-after communities. (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Whirlpool"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Cooktop"
9 => "Window Coverings"
10 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T23:50:07.856836+00:00"
+"Directions": "Cross Streets: Perth and Muirfield Trail. ** Directions: Perth to Muirfield Trail."
+"ExteriorFeatures": array:1 [
0 => "Stucco"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2161671"
+"ListOfficeKey": "294061"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "50.8 x 156 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-28T15:26:13Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-28T15:26:13Z"
+"Stories": "1.0"
+"StreetName": "Muirfield"
+"StreetNumber": "208"
+"StreetSuffix": "Trail"
+"TaxAnnualAmount": "11532.86"
+"View": "Direct Water View"
+"VirtualTourURLUnbranded": "https://youtu.be/Tz4frJ45sl0"
+"WaterBodyName": "Welland Canal"
+"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": "Niagara"
+"TaxYear": 2026
+"CityRegion": "766 - Hwy 406/Welland"
+"ListAORKey": "114"
+"ListingURL": "www.realtor.ca/real-estate/29907514/208-muirfield-trail-welland-hwy-406welland-766-hwy-406welland"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1586933"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "114884"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "O2, RL2-23"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 2
+"WaterfrontFeatures": array:1 [
0 => "Waterfront on canal"
]
+"FrontageLengthNumeric": 50.9
+"OriginalEntryTimestamp": "2026-06-15T23:26:41.23Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1412721"
+"ListOfficeNationalAssociationId": "1434902"
+"CoListAgentNationalAssociationId": "1152943"
+"CoListOfficeNationalAssociationId": "1167136"
+"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": 14
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29907514')"
+"ID": "1532867"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25317
+post_id: "1530574"
+post_author: 1
+"ListingKey": "29904802"
+"ListingId": "X13446174"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T15:15:22Z"
+"RFModificationTimestamp": "2026-06-29T15:20:40Z"
+"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:62650)"
+"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-29T15:09:20Z"
+"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 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
]
+"DaysOnMarket": 14
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29904802')"
+"ID": "1530574"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25318
+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": 17
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29898089')"
+"ID": "1525596"
}
]
+success: true
+page_size: 9
+page_count: 7
+count: 61
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]