array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29063666/Property?$select=ALL&$top=20&$filter=ListingKey eq 29063666&$expand=Office,Member,Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29063666/Property?$select=ALL&$top=20&$filter=ListingKey eq 29063666&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23660
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23662
+post_id: "386018"
+post_author: 1
+"ListingKey": "29063666"
+"ListingId": "X12505876"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-09T18:26:03Z"
+"RFModificationTimestamp": "2025-12-09T18:27:25Z"
+"ListPrice": 1029900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Welland (Hwy 406/Welland)"
+"PostalCode": "L3B0L8"
+"UnparsedAddress": "G - 304 PERTH TRAIL, Welland (Hwy 406/Welland), Ontario L3B0L8"
+"Coordinates": array:2 [
0 => -79.216554
1 => 43.026464
]
+"Latitude": 43.026464
+"Longitude": -79.216554
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Niagara Association of REALTORS®"
+"PublicRemarks": "Welcome to WaterCrest at Hunters Pointe - an exclusive 55+ active adult community in north Welland, in the heart of Niagara. This is one of the final releases from Lucchetta Homes, known for thoughtful design, bold architecture, and high-quality finishes that stand the test of time. Enjoy resort-style living with monthly fees of $265 that include full access to a private clubhouse featuring a saltwater indoor pool, fitness centre, hot tub, sauna, games room, library, banquet hall, tennis and pickleball courts. Lawn care, driveway snow removal, and monitored security are also included - offering unmatched lifestyle value. This exterior model, the Haven, delivers 2,169 sq ft of finished living space with 2+1 bedrooms, 3 bathrooms, and a double garage. The layout is open and airy with 9 ft ceilings, a cathedral great room, and oversized windows that flood the space with light. A covered rear deck extends your living space outdoors. Built to Energy Star standards, this home exceeds Ontario Building Code performance by 20% with efficient mechanicals, smart insulation, and premium materials. Outside, the brick, stone, and stucco façade is paired with an asphalt driveway, irrigation system, and clean landscape design. Interior finishes mirror the completed "Model I" (see listing photos): hardwood flooring, quartz counters, pot lights, tiled shower surrounds, and a stunning kitchen with full custom cabinetry, dovetail drawers, under-cab lighting, and tile backsplash. The great room centres around a gas fireplace with 24x24" tile surround and white oak mantel. White oak railings with glass inserts, flush vents, and elevated trim details complete the space. The primary suite features crown moulding, a wallpaper accent wall, pendant lighting, and a luxurious ensuite with heated tile floors, tiled niche, and bold black shower base. The finished basement offers vinyl plank floors, a large rec room (optional wet bar), an additional bedroom, and a full bath. Schedule a tour tod (id:62650)"
+"Appliances": array:1 [
0 => "Water meter"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-04T05:27:00.212994+00:00"
+"Directions": "Cross Streets: Woodlawn / Highway 406. ** Directions: Woodlawn Rd, to Daimler Parkway."
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2027376"
+"ListOfficeKey": "291529"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-11-04T02:57:33Z"
+"PhotosCount": 35
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-09T17:55:33Z"
+"Stories": "1.0"
+"StreetName": "Perth"
+"StreetNumber": "304"
+"StreetSuffix": "Trail"
+"VirtualTourURLUnbranded": "https://youtu.be/Juo2PWDz0_8"
+"WaterBodyName": "Welland Canal"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1547174632"
"RoomType" => "Kitchen"
"ListingId" => "X12505876"
"RoomLevel" => "Main level"
"RoomWidth" => 2.7
"ListingKey" => "29063666"
"RoomLength" => 3.5
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-09T17:55:33.62Z"
]
1 => array:11 [
"RoomKey" => "1547174633"
"RoomType" => "Recreational, Games room"
"ListingId" => "X12505876"
"RoomLevel" => "Basement"
"RoomWidth" => 6.7
"ListingKey" => "29063666"
"RoomLength" => 7.6
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-09T17:55:33.63Z"
]
2 => array:11 [
"RoomKey" => "1547174634"
"RoomType" => "Den"
"ListingId" => "X12505876"
"RoomLevel" => "Main level"
"RoomWidth" => 2.7
"ListingKey" => "29063666"
"RoomLength" => 5.5
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-09T17:55:33.64Z"
]
3 => array:11 [
"RoomKey" => "1547174635"
"RoomType" => "Bathroom"
"ListingId" => "X12505876"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "29063666"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-09T17:55:33.64Z"
]
4 => array:11 [
"RoomKey" => "1547174636"
"RoomType" => "Dining room"
"ListingId" => "X12505876"
"RoomLevel" => "Main level"
"RoomWidth" => 2.7
"ListingKey" => "29063666"
"RoomLength" => 3.5
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-09T17:55:33.64Z"
]
5 => array:11 [
"RoomKey" => "1547174637"
"RoomType" => "Great room"
"ListingId" => "X12505876"
"RoomLevel" => "Main level"
"RoomWidth" => 3.6
"ListingKey" => "29063666"
"RoomLength" => 6.4
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-09T17:55:33.64Z"
]
6 => array:11 [
"RoomKey" => "1547174638"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12505876"
"RoomLevel" => "Main level"
"RoomWidth" => 3.5
"ListingKey" => "29063666"
"RoomLength" => 5.4
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-09T17:55:33.65Z"
]
7 => array:11 [
"RoomKey" => "1547174639"
"RoomType" => "Bathroom"
"ListingId" => "X12505876"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "29063666"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-09T17:55:33.65Z"
]
8 => array:11 [
"RoomKey" => "1547174640"
"RoomType" => "Laundry room"
"ListingId" => "X12505876"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "29063666"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-09T17:55:33.66Z"
]
9 => array:11 [
"RoomKey" => "1547174641"
"RoomType" => "Bedroom 3"
"ListingId" => "X12505876"
"RoomLevel" => "Basement"
"RoomWidth" => 2.7
"ListingKey" => "29063666"
"RoomLength" => 3.6
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-09T17:55:33.67Z"
]
10 => array:11 [
"RoomKey" => "1547174642"
"RoomType" => "Bathroom"
"ListingId" => "X12505876"
"RoomLevel" => "Basement"
"RoomWidth" => 0.0
"ListingKey" => "29063666"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-09T17:55:33.67Z"
]
]
+"ListAOR": "Niagara"
+"CityRegion": "766 - Hwy 406/Welland"
+"ListAORKey": "114"
+"ListingURL": "www.realtor.ca/real-estate/29063666/g-304-perth-trail-welland-hwy-406welland-766-hwy-406welland"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Security system"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2025-11-04T02:57:33.5Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:35 [
0 => array:13 [
"Order" => 1
"MediaKey" => "6295027901"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29063666/fa8725dfe1c42f4c7b0c7d5ae7abbcdc.webp"
"MediaSize" => 216850
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29063666/thumbnail-fa8725dfe1c42f4c7b0c7d5ae7abbcdc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Welcome to WaterCrest!"
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12505876"
"ResourceRecordKey" => "29063666"
"ModificationTimestamp" => "2025-11-04T02:57:33.51Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "6295027911"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29063666/77cd876ec1cb4d7adcf2ab92972e8c94.webp"
"MediaSize" => 325452
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29063666/thumbnail-77cd876ec1cb4d7adcf2ab92972e8c94.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12505876"
"ResourceRecordKey" => "29063666"
"ModificationTimestamp" => "2025-11-04T02:57:33.51Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "6295027921"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29063666/9bb364743e32e1792b41ede03b019344.webp"
"MediaSize" => 345785
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29063666/thumbnail-9bb364743e32e1792b41ede03b019344.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Grass has been virtually enhanced"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12505876"
"ResourceRecordKey" => "29063666"
"ModificationTimestamp" => "2025-11-04T02:57:33.51Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "6295027933"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29063666/167b96bf9f19616130a0bd96ce995d38.webp"
"MediaSize" => 391497
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29063666/thumbnail-167b96bf9f19616130a0bd96ce995d38.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Large Covered Rear Porch"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12505876"
"ResourceRecordKey" => "29063666"
"ModificationTimestamp" => "2025-11-04T02:57:33.51Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "6295027941"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29063666/ab49f86d5dc7a02e7fba46a77e87f29f.webp"
"MediaSize" => 299834
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29063666/thumbnail-ab49f86d5dc7a02e7fba46a77e87f29f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Interior to be completed soon!"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12505876"
"ResourceRecordKey" => "29063666"
"ModificationTimestamp" => "2025-11-04T02:57:33.51Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "6295027954"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29063666/0753cbf4bcb27359bc4fb611e1618f95.webp"
"MediaSize" => 252036
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29063666/thumbnail-0753cbf4bcb27359bc4fb611e1618f95.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Interior to be completed soon!"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12505876"
"ResourceRecordKey" => "29063666"
"ModificationTimestamp" => "2025-11-04T02:57:33.51Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "6295027957"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29063666/abded33adb00d72b02b120a0b47b6074.webp"
"MediaSize" => 333074
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29063666/thumbnail-abded33adb00d72b02b120a0b47b6074.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Interior to be completed soon!"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12505876"
"ResourceRecordKey" => "29063666"
"ModificationTimestamp" => "2025-11-04T02:57:33.51Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "6295027969"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29063666/557034d2b27ed70c4c7ee1cdfc44a2b0.webp"
"MediaSize" => 330306
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29063666/thumbnail-557034d2b27ed70c4c7ee1cdfc44a2b0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Interior to be completed soon!"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12505876"
"ResourceRecordKey" => "29063666"
"ModificationTimestamp" => "2025-11-04T02:57:33.51Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "6295027985"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29063666/481c54d8e5125419b48d48adf3721f6f.webp"
"MediaSize" => 78394
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29063666/thumbnail-481c54d8e5125419b48d48adf3721f6f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12505876"
"ResourceRecordKey" => "29063666"
"ModificationTimestamp" => "2025-11-04T02:57:33.51Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "6295027994"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29063666/c98c5196b9422a1ea0b76f04cd7e6d89.webp"
"MediaSize" => 132080
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29063666/thumbnail-c98c5196b9422a1ea0b76f04cd7e6d89.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12505876"
"ResourceRecordKey" => "29063666"
"ModificationTimestamp" => "2025-11-04T02:57:33.51Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "6295028000"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29063666/4479b0bbab5039eeabf666e5ea44bbf1.webp"
"MediaSize" => 193576
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29063666/thumbnail-4479b0bbab5039eeabf666e5ea44bbf1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12505876"
"ResourceRecordKey" => "29063666"
"ModificationTimestamp" => "2025-11-04T02:57:33.51Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "6295028007"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29063666/24b9a96eda6074dd20543e35167f31fe.webp"
"MediaSize" => 200468
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29063666/thumbnail-24b9a96eda6074dd20543e35167f31fe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12505876"
"ResourceRecordKey" => "29063666"
"ModificationTimestamp" => "2025-11-04T02:57:33.51Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "6295028013"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29063666/7dad9cddaa2c516d7e06f4677f70cdd0.webp"
"MediaSize" => 130855
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29063666/thumbnail-7dad9cddaa2c516d7e06f4677f70cdd0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12505876"
"ResourceRecordKey" => "29063666"
"ModificationTimestamp" => "2025-11-04T02:57:33.51Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "6295028018"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29063666/eca1c37fc04657d34c9fc5a9dc476173.webp"
"MediaSize" => 139048
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29063666/thumbnail-eca1c37fc04657d34c9fc5a9dc476173.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12505876"
"ResourceRecordKey" => "29063666"
"ModificationTimestamp" => "2025-11-04T02:57:33.51Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "6295028025"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29063666/f7d59c73da3144951fa80720ec82c3ff.webp"
"MediaSize" => 147417
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29063666/thumbnail-f7d59c73da3144951fa80720ec82c3ff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12505876"
"ResourceRecordKey" => "29063666"
"ModificationTimestamp" => "2025-11-04T02:57:33.51Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "6295028031"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29063666/943c259642d2c53a9828bf9330a63c64.webp"
"MediaSize" => 143650
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29063666/thumbnail-943c259642d2c53a9828bf9330a63c64.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12505876"
"ResourceRecordKey" => "29063666"
"ModificationTimestamp" => "2025-11-04T02:57:33.51Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "6295028040"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29063666/e987a5db2a6b38e199829d3bbe2fe3cd.webp"
"MediaSize" => 218719
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29063666/thumbnail-e987a5db2a6b38e199829d3bbe2fe3cd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12505876"
"ResourceRecordKey" => "29063666"
"ModificationTimestamp" => "2025-11-04T02:57:33.51Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "6295028047"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29063666/74b1f476761769fffa969767f3cb2e3a.webp"
"MediaSize" => 198296
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29063666/thumbnail-74b1f476761769fffa969767f3cb2e3a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12505876"
"ResourceRecordKey" => "29063666"
"ModificationTimestamp" => "2025-11-04T02:57:33.51Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "6295028052"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29063666/5942a6568e6612321b3bcbc8bd4feb6f.webp"
"MediaSize" => 162324
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29063666/thumbnail-5942a6568e6612321b3bcbc8bd4feb6f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12505876"
"ResourceRecordKey" => "29063666"
"ModificationTimestamp" => "2025-11-04T02:57:33.51Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "6295028059"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29063666/673aabad7235c2e8ee88fb2ec7fb9ac5.webp"
"MediaSize" => 209923
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29063666/thumbnail-673aabad7235c2e8ee88fb2ec7fb9ac5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12505876"
"ResourceRecordKey" => "29063666"
"ModificationTimestamp" => "2025-11-04T02:57:33.51Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "6295028067"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29063666/b3dda85dcdaf90ab252ef0dcf1f4d467.webp"
"MediaSize" => 183387
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29063666/thumbnail-b3dda85dcdaf90ab252ef0dcf1f4d467.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12505876"
"ResourceRecordKey" => "29063666"
"ModificationTimestamp" => "2025-11-04T02:57:33.51Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "6295028072"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29063666/129dac420cde1e8513f5c143d2862253.webp"
"MediaSize" => 176700
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29063666/thumbnail-129dac420cde1e8513f5c143d2862253.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Primary Bedroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12505876"
"ResourceRecordKey" => "29063666"
"ModificationTimestamp" => "2025-11-04T02:57:33.51Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "6295028088"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29063666/03683b50a4271580fbc7fefcbec4aeb5.webp"
"MediaSize" => 128864
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29063666/thumbnail-03683b50a4271580fbc7fefcbec4aeb5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12505876"
"ResourceRecordKey" => "29063666"
"ModificationTimestamp" => "2025-11-04T02:57:33.51Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "6295028097"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29063666/5b818e7f749bbd2e8ca06f4c7be74fd9.webp"
"MediaSize" => 122486
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29063666/thumbnail-5b818e7f749bbd2e8ca06f4c7be74fd9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12505876"
"ResourceRecordKey" => "29063666"
"ModificationTimestamp" => "2025-11-04T02:57:33.51Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "6295028106"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29063666/cc2c96c82f75c8c7bc851845874b42e4.webp"
"MediaSize" => 146868
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29063666/thumbnail-cc2c96c82f75c8c7bc851845874b42e4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12505876"
"ResourceRecordKey" => "29063666"
"ModificationTimestamp" => "2025-11-04T02:57:33.51Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "6295028113"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29063666/39bbd410cb18f11dcc222d95a7a18f43.webp"
"MediaSize" => 185604
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29063666/thumbnail-39bbd410cb18f11dcc222d95a7a18f43.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12505876"
"ResourceRecordKey" => "29063666"
"ModificationTimestamp" => "2025-11-04T02:57:33.51Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "6295028117"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29063666/7e3e7f6403b88fdd29ab0517eba43ce8.webp"
"MediaSize" => 181298
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29063666/thumbnail-7e3e7f6403b88fdd29ab0517eba43ce8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12505876"
"ResourceRecordKey" => "29063666"
"ModificationTimestamp" => "2025-11-04T02:57:33.51Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "6295028126"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29063666/e30a182fa73f24fa38d2270554feafae.webp"
"MediaSize" => 146241
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29063666/thumbnail-e30a182fa73f24fa38d2270554feafae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Basement Bathroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12505876"
"ResourceRecordKey" => "29063666"
"ModificationTimestamp" => "2025-11-04T02:57:33.51Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "6295028134"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29063666/1b7c0a9cbc8b116c7c81b9c75702ef8f.webp"
"MediaSize" => 250135
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29063666/thumbnail-1b7c0a9cbc8b116c7c81b9c75702ef8f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12505876"
"ResourceRecordKey" => "29063666"
"ModificationTimestamp" => "2025-11-04T02:57:33.51Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "6295028141"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29063666/ab6a81e70c4431953694596f8f43b025.webp"
"MediaSize" => 353990
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29063666/thumbnail-ab6a81e70c4431953694596f8f43b025.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12505876"
"ResourceRecordKey" => "29063666"
"ModificationTimestamp" => "2025-11-04T02:57:33.51Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "6295028149"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29063666/e98f75ddd2f8a5bf7c04d97fea9586ef.webp"
"MediaSize" => 226053
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29063666/thumbnail-e98f75ddd2f8a5bf7c04d97fea9586ef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12505876"
"ResourceRecordKey" => "29063666"
"ModificationTimestamp" => "2025-11-04T02:57:33.51Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "6295028157"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29063666/3edaf6f8934f0912a25faf5792e5d690.webp"
"MediaSize" => 318828
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29063666/thumbnail-3edaf6f8934f0912a25faf5792e5d690.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12505876"
"ResourceRecordKey" => "29063666"
"ModificationTimestamp" => "2025-11-04T02:57:33.51Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "6295028165"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29063666/cc16c4319aafa2900a5beda1a11aaa96.webp"
"MediaSize" => 374227
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29063666/thumbnail-cc16c4319aafa2900a5beda1a11aaa96.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12505876"
"ResourceRecordKey" => "29063666"
"ModificationTimestamp" => "2025-11-04T02:57:33.51Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "6295028172"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29063666/57431ab572445ffd630469ec5d70f8e3.webp"
"MediaSize" => 366520
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29063666/thumbnail-57431ab572445ffd630469ec5d70f8e3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12505876"
"ResourceRecordKey" => "29063666"
"ModificationTimestamp" => "2025-11-04T02:57:33.51Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "6295028179"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29063666/08e57c38f6df5aec23147383aabdbcae.webp"
"MediaSize" => 302452
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29063666/thumbnail-08e57c38f6df5aec23147383aabdbcae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12505876"
"ResourceRecordKey" => "29063666"
"ModificationTimestamp" => "2025-11-04T02:57:33.51Z"
]
]
+"Member": array:1 [
0 => array:22 [
"MemberFullName" => "Andrew Kulakowsky"
"MemberFirstName" => "Andrew"
"MemberLastName" => "Kulakowsky"
"MemberMlsId" => "9640583"
"OriginatingSystemName" => 26
"MemberKey" => "2027376"
"ModificationTimestamp" => "2025-01-23T21:18:41Z"
"MemberStatus" => "Active"
"OfficeKey" => "291529"
"Media" => array:1 [ …1]
"JobTitle" => "Salesperson"
"MemberAOR" => "Niagara"
"MemberType" => "Salesperson"
"MemberAORKey" => "114"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberLanguages" => array:1 [ …1]
"MemberOfficePhone" => "289-241-9095"
"MemberStateOrProvince" => "Ontario"
"OriginalEntryTimestamp" => "2017-03-07T14:05:00Z"
"MemberNationalAssociationId" => "1306761"
"OfficeNationalAssociationId" => "1399537"
]
]
+"Office": array:1 [
0 => array:20 [
"OfficeName" => "EXP REALTY"
"OfficePhone" => "866-530-7737"
"OfficeMlsId" => "285439"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "291529"
"ModificationTimestamp" => "2025-12-08T05:24:40Z"
"OfficeAddress1" => "386 ST. PAUL STREET - UNIT 102"
"OfficeCity" => "ST. CATHARINES"
"OfficePostalCode" => "L2R3N"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Niagara"
"OfficeType" => "Firm"
"OfficeAORKey" => "114"
"OfficeCountry" => "Canada"
"OfficeSocialMedia" => array:1 [ …1]
"OriginalEntryTimestamp" => "2021-10-19T13:47:00Z"
"OfficeNationalAssociationId" => "1399537"
"OfficeBrokerNationalAssociationId" => "1407579"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29063666')"
+"ID": "386018"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 291529/Office?$select=ALL&$top=10&$filter=OfficeKey eq 291529&$expand=Office,Member,Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 291529/Office?$select=ALL&$top=10&$filter=OfficeKey eq 291529&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25503
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25505
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "EXP REALTY"
+"OfficeEmail": null
+"OfficePhone": "866-530-7737"
+"OfficeMlsId": "285439"
+"ModificationTimestamp": "2025-12-08T05:24:40Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "291529"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "386 ST. PAUL STREET - UNIT 102"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "ST. CATHARINES"
+"OfficePostalCode": "L2R3N"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Niagara"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1399537"
+"OriginalEntryTimestamp": "2021-10-19T13:47:00Z"
+"OfficeAORKey": "114"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "377941"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "291529"
"SocialMediaUrlOrId" => "http://exprealty.ca/"
"ModificationTimestamp" => "2025-12-08T04:23:00Z"
]
]
+"OfficeBrokerNationalAssociationId": "1407579"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('291529')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2027376/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2027376&$expand=Office,Member,Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2027376/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2027376&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25508
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq 29063666" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25099
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.26 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29063666/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29063666&$expand=Office,Member,Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29063666/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29063666&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25081
+items: array:5 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24966
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "29223241"
+"ListingKey": "29063666"
+"ListingId": "X12505876"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2025-11-28"
+"OpenHouseStartTime": "2025-11-28T13:00:00Z"
+"OpenHouseEndTime": "2025-11-28T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2025-11-29T04:14:30Z"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/OpenHouse('29223241')"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25052
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "29223242"
+"ListingKey": "29063666"
+"ListingId": "X12505876"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2025-11-29"
+"OpenHouseStartTime": "2025-11-29T12:00:00Z"
+"OpenHouseEndTime": "2025-11-29T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2025-11-29T12:54:06Z"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/OpenHouse('29223242')"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25080
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "29243581"
+"ListingKey": "29063666"
+"ListingId": "X12505876"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2025-11-29"
+"OpenHouseStartTime": "2025-11-29T12:00:00Z"
+"OpenHouseEndTime": "2025-11-29T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2025-11-30T01:57:53Z"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/OpenHouse('29243581')"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25050
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "29322161"
+"ListingKey": "29063666"
+"ListingId": "X12505876"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2025-12-13"
+"OpenHouseStartTime": "2025-12-13T12:00:00Z"
+"OpenHouseEndTime": "2025-12-13T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2025-12-10T16:42:30Z"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/OpenHouse('29322161')"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25010
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "29322160"
+"ListingKey": "29063666"
+"ListingId": "X12505876"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2025-12-12"
+"OpenHouseStartTime": "2025-12-12T13:00:00Z"
+"OpenHouseEndTime": "2025-12-12T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2025-12-10T16:42:30Z"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/OpenHouse('29322160')"
}
]
+success: true
+page_size: 5
+page_count: 1
+count: 5
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29063666 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.216554 43.026464)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29063666 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.216554 43.026464)) le 2000m&$expand=Office,Member,Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29063666 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.216554 43.026464)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29063666 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.216554 43.026464)) le 2000m&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25374
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25357
+post_id: "471299"
+post_author: 1
+"ListingKey": "29174369"
+"ListingId": "40792886"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-09T18:30:53Z"
+"RFModificationTimestamp": "2025-12-09T19:55:40Z"
+"ListPrice": 879000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2567.0
+"BuildingAreaTotal": 0
+"City": "Thorold"
+"PostalCode": "L3C7M5"
+"UnparsedAddress": "51 ALICIA Crescent, Thorold, Ontario L3C7M5"
+"Coordinates": array:2 [
0 => -79.2374319
1 => 43.0271897
]
+"Latitude": 43.0271897
+"Longitude": -79.2374319
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This 2,567 sq. ft. 4-bed, 2.5-bath home blends modern design with quality craftsmanship, offering a bright, elevated feel from the moment you step inside. Ten-foot ceilings on the main floor, nine-foot ceilings upstairs, and eight-foot interior doors give the home an impressive sense of scale and openness. The chef-inspired kitchen stands out with marble-look quartz counters, sleek white cabinetry, an over-the-range stainless steel microwave, black pendant lighting, and an oversized island with seating. Flooded with natural light, the open-concept dining and living area creates a seamless space for relaxing or entertaining, highlighted by premium finishes such as CAT5 wiring, pot lights, and oversized modern trim.Upstairs, four generous bedrooms provide comfort and flexibility for families, guests, or work-from-home needs. The second-floor laundry room is a practical bonus, complete with a deep utility sink and brand-new washer/dryer. The exterior combines stone, brick, stucco, and siding for bold curb appeal, highlighted by a custom engraved address stone. At the back, a new deck and concrete patio overlook open green space with no direct rear neighbours-ideal for quiet mornings or outdoor gatherings.The basement is thoughtfully designed for future potential, featuring a separate side entrance, full egress windows, and a double sill plate offering increased ceiling height-making it perfect for an in-law suite, rental unit, or expanded living area. Located in a quiet, established subdivision on the Thorold/Welland border, the home offers quick access to highways, shopping, schools, parks, and everyday amenities. It's a modern, move-in-ready home with room to grow, room to entertain, and room to add long-term value. (id:62650)"
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-09T19:55:36.124108+00:00"
+"Directions": "Off Hansler"
+"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": "2239332"
+"ListOfficeKey": "299787"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-12-09T18:08:40Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-09T18:08:40Z"
+"Stories": "2.0"
+"StreetName": "ALICIA"
+"StreetNumber": "51"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "562 - Hurricane/Merrittville"
+"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=8e8d9hOFhog"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1547176105"
"RoomType" => "Bedroom"
"ListingId" => "40792886"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29174369"
"RoomLength" => null
"RoomDimensions" => "12'12'' x 11'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-09T18:08:40.09Z"
]
1 => array:11 [
"RoomKey" => "1547176106"
"RoomType" => "4pc Bathroom"
"ListingId" => "40792886"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29174369"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-09T18:08:40.09Z"
]
2 => array:11 [
"RoomKey" => "1547176107"
"RoomType" => "5pc Bathroom"
"ListingId" => "40792886"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29174369"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-09T18:08:40.09Z"
]
3 => array:11 [
"RoomKey" => "1547176108"
"RoomType" => "2pc Bathroom"
"ListingId" => "40792886"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29174369"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-09T18:08:40.09Z"
]
4 => array:11 [
"RoomKey" => "1547176109"
"RoomType" => "Dining room"
"ListingId" => "40792886"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29174369"
"RoomLength" => null
"RoomDimensions" => "12'12'' x 12'12''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-09T18:08:40.09Z"
]
5 => array:11 [
"RoomKey" => "1547176110"
"RoomType" => "Bedroom"
"ListingId" => "40792886"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29174369"
"RoomLength" => null
"RoomDimensions" => "14'2'' x 11'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-09T18:08:40.09Z"
]
6 => array:11 [
"RoomKey" => "1547176111"
"RoomType" => "Laundry room"
"ListingId" => "40792886"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29174369"
"RoomLength" => null
"RoomDimensions" => "5'6'' x 11'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-09T18:08:40.09Z"
]
7 => array:11 [
"RoomKey" => "1547176112"
"RoomType" => "Bedroom"
"ListingId" => "40792886"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29174369"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 11'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-09T18:08:40.09Z"
]
8 => array:11 [
"RoomKey" => "1547176113"
"RoomType" => "Primary Bedroom"
"ListingId" => "40792886"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29174369"
"RoomLength" => null
"RoomDimensions" => "14'8'' x 17'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-09T18:08:40.1Z"
]
9 => array:11 [
"RoomKey" => "1547176114"
"RoomType" => "Kitchen"
"ListingId" => "40792886"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29174369"
"RoomLength" => null
"RoomDimensions" => "11'2'' x 12'12''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-09T18:08:40.1Z"
]
10 => array:11 [
"RoomKey" => "1547176115"
"RoomType" => "Living room"
"ListingId" => "40792886"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29174369"
"RoomLength" => null
"RoomDimensions" => "17'10'' x 13'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-09T18:08:40.1Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29174369/51-alicia-crescent-thorold"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1C"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 40.0
+"AboveGradeFinishedArea": 2567
+"OriginalEntryTimestamp": "2025-12-09T18:08:39.99Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"Media": array:40 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6362903336"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174369/81753793df48d6e93cc3ce973ecc161a.webp"
"MediaSize" => 117950
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174369/thumbnail-81753793df48d6e93cc3ce973ecc161a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40792886"
"ResourceRecordKey" => "29174369"
"ModificationTimestamp" => "2025-12-09T18:08:40.01Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6362903361"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174369/1a3ef0ccacd0c6ae8995ba7630d3b056.webp"
"MediaSize" => 113164
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174369/thumbnail-1a3ef0ccacd0c6ae8995ba7630d3b056.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792886"
"ResourceRecordKey" => "29174369"
"ModificationTimestamp" => "2025-12-09T18:08:40.01Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6362903443"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174369/276158e9625c9139ee10e5f3bc522860.webp"
"MediaSize" => 59804
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174369/thumbnail-276158e9625c9139ee10e5f3bc522860.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792886"
"ResourceRecordKey" => "29174369"
"ModificationTimestamp" => "2025-12-09T18:08:40.01Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6362903470"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174369/63e9a0396661b5e8a54e71b1f8caa286.webp"
"MediaSize" => 64039
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174369/thumbnail-63e9a0396661b5e8a54e71b1f8caa286.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792886"
"ResourceRecordKey" => "29174369"
"ModificationTimestamp" => "2025-12-09T18:08:40.01Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6362903505"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174369/560f935733bd208e0beaef4d7e744c9e.webp"
"MediaSize" => 84310
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174369/thumbnail-560f935733bd208e0beaef4d7e744c9e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792886"
"ResourceRecordKey" => "29174369"
"ModificationTimestamp" => "2025-12-09T18:08:40.01Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6362903521"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174369/f593e47f5c1388f9f722bd4da76b3f35.webp"
"MediaSize" => 77090
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174369/thumbnail-f593e47f5c1388f9f722bd4da76b3f35.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792886"
"ResourceRecordKey" => "29174369"
"ModificationTimestamp" => "2025-12-09T18:08:40.01Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6362903581"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174369/4023e1302d3f4fe0f6246ebb49f0e048.webp"
"MediaSize" => 65456
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174369/thumbnail-4023e1302d3f4fe0f6246ebb49f0e048.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
…4
]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29174369')"
+"ID": "471299"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25359
+post_id: "469843"
+post_author: 1
+"ListingKey": "29172129"
+"ListingId": "X12610722"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-08T21:00:17Z"
+"RFModificationTimestamp": "2025-12-08T22:58:56Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Thorold (Hurricane/Merrittville)"
+"PostalCode": "L3B5N5"
+"UnparsedAddress": "155 MELODY LANE, Thorold (Hurricane/Merrittville), Ontario L3B5N5"
+"Coordinates": array:2 [
0 => -79.227347
1 => 43.040105
]
+"Latitude": 43.040105
+"Longitude": -79.227347
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Built in 2024, this immaculate 3-storey townhouse offers 3 bedrooms and 1.5 washrooms, presenting a wonderful opportunity to settle into a modern home. Situated in a quiet, family friendly neighborhood, the property features a versatile ground-level office ideal for remote work or study. The contemporary kitchen serves as the focal point of the home, complete with a center island, a comfortable breakfast area, and sliding doors that open to a private terrace. Conveniently located just minutes from Seaway Mall, Walmart, Canadian Tire, Rona, Niagara College, Brock University, and the General Hospital, this home provides exceptional accessibility to essential amenities. An excellent option for a small family seeking the comfort and convenience of a newly built home at an affordable price. Do not miss the chance to make this beautiful property your new home. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-08T22:57:19.208588+00:00"
+"Directions": "HIGHWAY 406 & KOTTMEIER RD"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:2 [
0 => "Hardwood"
1 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2145327"
+"ListOfficeKey": "269129"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "16.4 x 78.2 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2025-12-08T20:53:19Z"
+"PhotosCount": 16
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-08T20:53:19Z"
+"Stories": "3.0"
+"StreetName": "Melody"
+"StreetNumber": "155"
+"StreetSuffix": "Lane"
+"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/29172129/155-melody-lane-thorold-hurricanemerrittville-562-hurricanemerrittville"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 2250
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 16.4
+"OriginalEntryTimestamp": "2025-12-08T20:53:19.39Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:16 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:24 [ …24]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29172129')"
+"ID": "469843"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25355
+post_id: "469198"
+post_author: 1
+"ListingKey": "29172126"
+"ListingId": "X12610660"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-08T21:21:05Z"
+"RFModificationTimestamp": "2025-12-08T21:25:08Z"
+"ListPrice": 639000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Thorold (Hurricane/Merrittville)"
+"PostalCode": "L3B5N5"
+"UnparsedAddress": "17 BEATTY AVENUE, Thorold (Hurricane/Merrittville), Ontario L3B5N5"
+"Coordinates": array:2 [
0 => -79.230218
1 => 43.038362
]
+"Latitude": 43.038362
+"Longitude": -79.230218
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to your modern family haven. Bright, stylish, and thoughtfully upgraded from top to bottom. This 4-bedroom home checks every box with an open-concept living and dining area, upgraded 9-ft ceilings, oak stairs, and a convenient door to the garage. The kitchen shines with premium finishes, including a Fisher & Paykel refrigerator, Bosch oven, and an Express Water RO filtration system - everyday luxury, built right in. You'll love the finished laundry room, featuring cabinetry and a countertop conveniently located on the second floor, along with upgraded light fixtures that add a designer touch. A professional-grade Husky central vac system adds practical convenience, and custom window blinds are installed on every window in the home, so you can just move in and enjoy. Upstairs, the primary suite is an inviting retreat. Spacious enough for a king bed, complete with his-and-her walk-in closets. Three additional bedrooms offer flexible space for family, guests, or work-from-home living. The garage features epoxy floors, built-in wood shelving, and a garage door opener already installed. Thoughtfully designed and ready to call home. (id:62650)"
+"Appliances": array:6 [
0 => "Refrigerator"
1 => "Central Vacuum"
2 => "Oven"
3 => "Water Treatment"
4 => "Blinds"
5 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-08T21:24:54.805859+00:00"
+"Directions": "Seanesy Dr / Beatty Ave"
+"ExteriorFeatures": array:2 [
0 => "Stucco"
1 => "Aluminum siding"
]
+"Flooring": array:1 [
0 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2128170"
+"ListOfficeKey": "238732"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"LotSizeDimensions": "30.3 x 92 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-12-08T21:06:54Z"
+"PhotosCount": 39
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-08T21:06:54Z"
+"Stories": "2.0"
+"StreetName": "Beatty"
+"StreetNumber": "17"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "6254"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "562 - Hurricane/Merrittville"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29172126/17-beatty-avenue-thorold-hurricanemerrittville-562-hurricanemerrittville"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 30.3
+"OriginalEntryTimestamp": "2025-12-08T20:53:18.15Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:39 [
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]
]
+"Member": array:1 [
0 => array:4 [ …4]
]
+"Office": array:1 [
0 => array:20 [ …20]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29172126')"
+"ID": "469198"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25360
+post_id: "469035"
+post_author: 1
+"ListingKey": "29171401"
+"ListingId": "40792860"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-10T13:01:02Z"
+"RFModificationTimestamp": "2025-12-10T13:04:17Z"
+"ListPrice": 999900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.31
+"LivingArea": 2143.0
+"BuildingAreaTotal": 0
+"City": "Welland"
+"PostalCode": "L3B0B7"
+"UnparsedAddress": "115 TURNBERRY Trail, Welland, Ontario L3B0B7"
+"Coordinates": array:2 [
0 => -79.2147721
1 => 43.023478
]
+"Latitude": 43.023478
+"Longitude": -79.2147721
+"YearBuilt": 2013
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Stellar, open plan WALKOUT BUNGALOW on a PREMIUM sized CANAL LOT! No more grass cutting or snow shovelling here at Hunters Pointe. Built by Ballantra Homes; A RARE opportunity & must be seen. This bright, SPACIOUS 2+1 bedroom, 3 bathroom with fully FINISHED WALKOUT basement will impress. Features 9’ Main flr ceilings, hardwood flooring, granite counter tops and 2 separate patios to enjoy the canal views; upper and lower patios offer the ultimate serenity. This Niagara beauty is move-in ready with flexible closing possible here! Hunters Pointe is Niagara’s award winning Premier active adult lifestyle community; plenty of amazing amenities! The Highland Association monthly fee of $300 covers grass cutting, snow shovelling, home monitored alarm system and access to the community Clubhouse. Activities include dances, Zumba, darts & so much more! Prefer quiet retirement? You can savour the silence of no rear neighbours with canal views from this gorgeous home! The Clubhouse features many options including pickle ball, tennis, an extensive gym, heated salt water indoor pool, hot tub & sauna. Enjoy cards, shuffleboard or darts? How about reading in the library or games room? Short walk to coffee or big retail stores. Short drive to local shops, restaurants & just minutes to downtown concerts at Merritt Island Park. Convenient, Safe & Quiet location with Hwy 406 at your doorstep. Near all amenities including Walmart, Canadian Tire, Dollar Tree, Seaway Mall & MORE! Easy access to Hwy 406, minutes to QEW Highway, excellent restaurants & MORE! North Welland is 15 minutes to Niagara Falls & less than 1 hr to Oakville. Enjoy morning coffee or wine star gazing while you enjoy the world famous canal views! Welcome home to a healthy lifestyle & new friendships at Hunters Pointe. (id:62650)"
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Landscaping"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-08T19:56:43.786656+00:00"
+"Directions": "Highway 406, to Daimler Parkway, to Perth Trail, to Turnberry Trail"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524896"
+"ListOfficeKey": "55053"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Balcony"
1 => "Paved driveway"
2 => "Recreational"
3 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.31"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-12-08T23:31:17Z"
+"PhotosCount": 46
+"PoolFeatures": array:1 [
0 => "Indoor pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-10T12:49:36Z"
+"Stories": "1.0"
+"StreetName": "TURNBERRY"
+"StreetNumber": "115"
+"StreetSuffix": "Trail"
+"SubdivisionName": "766 - Hwy 406/Welland"
+"TaxAnnualAmount": "7530"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"View": "View (panoramic)"
+"VirtualTourURLUnbranded": "https://docs.google.com/videos/d/1QRT7HW_odwX8XOa_Y31ZkTkJ6Z5sXCHUytYqCMvyzBI/edit?scene=id.p#scene=id.p"
+"WaterBodyName": "Welland Canal"
+"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": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29171401/115-turnberry-trail-welland"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"SecurityFeatures": array:1 [
0 => "Alarm system"
]
+"ZoningDescription": "01, RL1-25, RM-63"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"WaterfrontFeatures": array:1 [
0 => "Waterfront on canal"
]
+"FrontageLengthNumeric": 26.0
+"AboveGradeFinishedArea": 1361
+"BelowGradeFinishedArea": 782
+"OriginalEntryTimestamp": "2025-12-08T18:19:16.64Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"BelowGradeFinishedAreaSource": "Listing Brokerage"
+"Media": array:46 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:24 [ …24]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29171401')"
+"ID": "469035"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25358
+post_id: "469088"
+post_author: 1
+"ListingKey": "29170799"
+"ListingId": "X12609552"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-08T16:40:55Z"
+"RFModificationTimestamp": "2025-12-08T19:37:12Z"
+"ListPrice": 879000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Thorold (Hurricane/Merrittville)"
+"PostalCode": "L3C7M5"
+"UnparsedAddress": "51 ALICIA CRESCENT, Thorold (Hurricane/Merrittville), Ontario L3C7M5"
+"Coordinates": array:2 [
0 => -79.237072
1 => 43.026906
]
+"Latitude": 43.026906
+"Longitude": -79.237072
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Niagara Association of REALTORS®"
+"PublicRemarks": "This 2,567 sq. ft. 4-bed, 2.5-bath home blends modern design with quality craftsmanship, offering a bright, elevated feel from the moment you step inside. Ten-foot ceilings on the main floor, nine-foot ceilings upstairs, and eight-foot interior doors give the home an impressive sense of scale and openness. The chef-inspired kitchen stands out with marble-look quartz counters, sleek white cabinetry, an over-the-range stainless steel microwave, black pendant lighting, and an oversized island with seating. Flooded with natural light, the open-concept dining and living area creates a seamless space for relaxing or entertaining, highlighted by premium finishes such as CAT5 wiring, pot lights, and oversized modern trim.Upstairs, four generous bedrooms provide comfort and flexibility for families, guests, or work-from-home needs. The second-floor laundry room is a practical bonus, complete with a deep utility sink and brand-new washer/dryer. The exterior combines stone, brick, stucco, and siding for bold curb appeal, highlighted by a custom engraved address stone. At the back, a new deck and concrete patio overlook open green space with no direct rear neighbours-ideal for quiet mornings or outdoor gatherings.The basement is thoughtfully designed for future potential, featuring a separate side entrance, full egress windows, and a double sill plate offering increased ceiling height-making it perfect for an in-law suite, rental unit, or expanded living area. Located in a quiet, established subdivision on the Thorold/Welland border, the home offers quick access to highways, shopping, schools, parks, and everyday amenities. It's a modern, move-in-ready home with room to grow, room to entertain, and room to add long-term value. (id:62650)"
+"Appliances": array:2 [
0 => "All"
1 => "Water Heater"
]
+"Basement": array:4 [
0 => "Unfinished"
1 => "Separate entrance"
2 => "N/A"
3 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-08T19:36:48.323255+00:00"
+"Directions": "Off Hansler"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1525977"
+"ListOfficeKey": "299775"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "40.5 x 107.6 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-12-08T16:27:15Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-08T16:27:15Z"
+"Stories": "2.0"
+"StreetName": "Alicia"
+"StreetNumber": "51"
+"StreetSuffix": "Crescent"
+"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=8e8d9hOFhog"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Niagara"
+"CityRegion": "562 - Hurricane/Merrittville"
+"ListAORKey": "114"
+"ListingURL": "www.realtor.ca/real-estate/29170799/51-alicia-crescent-thorold-hurricanemerrittville-562-hurricanemerrittville"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"ZoningDescription": "R1C-61"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 40.6
+"OriginalEntryTimestamp": "2025-12-08T16:27:15.23Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:40 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:20 [ …20]
]
+"Office": array:1 [
0 => array:19 [ …19]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29170799')"
+"ID": "469088"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25352
+post_id: "467830"
+post_author: 1
+"ListingKey": "29169052"
+"ListingId": "40792714"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-06T19:35:04Z"
+"RFModificationTimestamp": "2025-12-06T22:53:24Z"
+"ListPrice": 620000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1279.0
+"BuildingAreaTotal": 0
+"City": "Thorold"
+"PostalCode": "L2V0G3"
+"UnparsedAddress": "16 BOWMAN Crescent, Thorold, Ontario L2V0G3"
+"Coordinates": array:2 [
0 => -79.2378133
1 => 43.0289719
]
+"Latitude": 43.0289719
+"Longitude": -79.2378133
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this exceptional detached 3-bedroom, 3-bath residence, where refined craftsmanship, high-end finishes, and a thoughtfully designed layout come together to create an elevated living experience. Nestled in a desirable neighbourhood, this meticulously presented home offers an impressive blend of comfort, style, and modern convenience. The main floor features a seamless flow through the beautifully appointed living spaces, enhanced by quality finishes and natural light, along with a stylish 2-piece powder room for added functionality. The second level hosts three spacious bedrooms, including a private primary retreat complete with an elegant ensuite showcasing a glass shower and a generous walk-in closet. Two additional bedrooms are accompanied by their own well-designed 4-piece bathroom, offering comfort for family and guests alike. The unfinished lower level, equipped with a separate entrance, presents outstanding potential, ideal for future expansion, an in-law suite, or a custom space tailored to your needs. With its premium features, versatile layout, and enduring appeal, this home delivers exceptional value and a lifestyle of comfort in a sought-after setting. Taxes estimated as per city’s website. Property is being sold under Power of Sale. Sold as is, where is. RSA (id:62650)"
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-06T22:53:19.790386+00:00"
+"Directions": "Grisdale Rd / Towpath Rd"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2142382"
+"ListOfficeKey": "288562"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-12-06T19:29:07Z"
+"PhotosCount": 44
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-06T19:29:06Z"
+"Stories": "2.0"
+"StreetName": "BOWMAN"
+"StreetNumber": "16"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "562 - Hurricane/Merrittville"
+"TaxAnnualAmount": "5035"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29169052/16-bowman-crescent-thorold"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "LI-17"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 36.0
+"AboveGradeFinishedArea": 1279
+"OriginalEntryTimestamp": "2025-12-06T19:29:06.86Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"Media": array:44 [
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]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29169052')"
+"ID": "467830"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23674
+post_id: "467084"
+post_author: 1
+"ListingKey": "29168512"
+"ListingId": "X12606860"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-08T13:10:32Z"
+"RFModificationTimestamp": "2025-12-08T13:13:36Z"
+"ListPrice": 799900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Welland (Hwy 406/Welland)"
+"PostalCode": "L3B6G7"
+"UnparsedAddress": "6 MUIRFIELD TRAIL, Welland (Hwy 406/Welland), Ontario L3B6G7"
+"Coordinates": array:2 [
0 => -79.2167726
1 => 43.0219073
]
+"Latitude": 43.0219073
+"Longitude": -79.2167726
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Niagara Association of REALTORS®"
+"PublicRemarks": "Welcome to 6 Muirfield Trail in Welland's premier adult lifestyle community, The Highlands. Perfectly located steps from the Welland Canal Parkway Trail, the Recreational Waterway, and minutes to Merritt Island, parks, Seaway Mall, healthcare services, restaurants, and Hwy 406 with quick access to the QEW. Enjoy a maintenance-free lifestyle with snow removal and lawn care included, plus full access to the community clubhouse with saltwater pool, fitness centre, tennis/pickleball courts, and organized activities.This custom-built Luchetta Homes bungalow-formerly the original model home- sits on a desirable southwest-facing lot with peaceful pond views. The main floor offers an open-concept layout with vaulted ceilings, hardwood floors, gas fireplace, formal dining room, and a kitchen with granite counters and walkout to the raised deck. The primary suite includes dual closets, a luxury ensuite, and private deck access. A second bedroom, 4-piece bath, and laundry with inside entry to the double garage complete the level. The bright walkout lower level is ideal for an in-law setup, caregiver suite, or possible two-family living, featuring a large bedroom, full bathroom, office nook, full-size windows, kitchen, and a private patio with separate entrance. Extra storage includes a cedar closet, cold room, and a second kitchen (appliances included). Professionally landscaped with stamped concrete, in-ground irrigation, two patios, and deck access from both the kitchen and primary bedroom. A rare opportunity to own the former Luchetta model home truly priced to sell. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Garage door opener remote(s)"
7 => "Water Heater - Tankless"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:5 [
0 => "Finished"
1 => "Separate entrance"
2 => "Walk out"
3 => "N/A"
4 => "N/A"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-06T06:46:26.318926+00:00"
+"Directions": "Cross Streets: Daimler Pkwy. ** Directions: 406 to Daimler Pkwy, Turn left on Perth. Home is on the corner of Perth and Muirfield."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2237350"
+"ListOfficeKey": "75325"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Irregular lot size"
1 => "Sloping"
2 => "Sump Pump"
]
+"LotSizeDimensions": "61.5 x 134 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-12-06T19:59:13Z"
+"PhotosCount": 39
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-08T12:56:19Z"
+"Stories": "1.0"
+"StreetName": "Muirfield"
+"StreetNumber": "6"
+"StreetSuffix": "Trail"
+"TaxAnnualAmount": "8519"
+"View": "View"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
]
+"ListAOR": "Niagara"
+"TaxYear": 2025
+"CityRegion": "766 - Hwy 406/Welland"
+"ListAORKey": "114"
+"ListingURL": "www.realtor.ca/real-estate/29168512/6-muirfield-trail-welland-hwy-406welland-766-hwy-406welland"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"SecurityFeatures": array:1 [
0 => "Security system"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "RL2-23"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 61.6
+"OriginalEntryTimestamp": "2025-12-06T04:26:45.03Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:39 [
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]
]
+"Member": array:1 [
0 => array:4 [ …4]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29168512')"
+"ID": "467084"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25362
+post_id: "466814"
+post_author: 1
+"ListingKey": "29168059"
+"ListingId": "X12606424"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-10T18:45:56Z"
+"RFModificationTimestamp": "2025-12-10T18:51:12Z"
+"ListPrice": 629999.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Welland (Hwy 406/Welland)"
+"PostalCode": "L3B0H3"
+"UnparsedAddress": "9 ADMIRAL ROAD, Welland (Hwy 406/Welland), Ontario L3B0H3"
+"Coordinates": array:2 [
0 => -79.215334
1 => 43.015375
]
+"Latitude": 43.015375
+"Longitude": -79.215334
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Step inside and fall in love! This beautifully upgraded newly-built townhome in the highly coveted Eastview Estate is filled with natural light and modern charm. Nestled next to the beautiful Welland Canal, near parks, great schools, hwy access, this development combines modern family living and nature. Offering 3 spacious bedrooms and 2.5 baths, this home welcomes you with an airy, open-concept main floor featuring wide-plank flooring, a stunning hardwood staircase, and an inviting living and dining area perfect for everyday living and entertaining. The sleek and luxurious kitchen upgraded counter tops, extra cabinet space. It also has easy inside access to the garage, along with a convenient main-level powder room. Upstairs, the impressive primary suite offers a walk-in closet and a luxurious 3-piece ensuite with a glass shower. Two additional bedrooms, a stylish 4-piece family bath, and laundry right on the bedroom level add everyday convenience. The unfinished lower level-with oversized windows-provides endless possibilities for customization along with abundant storage. With 7-year Tarion Home Warranty, you can live there with confidence and peace of mind. Create the dream space you've always wanted! (id:62650)"
+"Basement": array:1 [
0 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2025-12-06T00:52:23.435226+00:00"
+"Directions": "Cross Streets: -. ** Directions: Admiral Road & Shoreview Dr."
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2093886"
+"ListOfficeKey": "284792"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "19.9 x 98.4 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-12-05T23:50:58Z"
+"PhotosCount": 40
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-10T18:29:49Z"
+"Stories": "2.0"
+"StreetName": "Admiral"
+"StreetNumber": "9"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "5250"
+"VirtualTourURLUnbranded": "https://show.tours/v/qFR85zv"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "766 - Hwy 406/Welland"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29168059/9-admiral-road-welland-hwy-406welland-766-hwy-406welland"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 19.1
+"OriginalEntryTimestamp": "2025-12-05T23:50:58.6Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:40 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:24 [ …24]
]
+"Office": []
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29168059')"
+"ID": "466814"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25376
+post_id: "466815"
+post_author: 1
+"ListingKey": "29167988"
+"ListingId": "40792664"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-10T17:45:58Z"
+"RFModificationTimestamp": "2025-12-10T17:50:33Z"
+"ListPrice": 629999.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1504.0
+"BuildingAreaTotal": 0
+"City": "Welland"
+"PostalCode": "L3B0H3"
+"UnparsedAddress": "9 ADMIRAL Road, Welland, Ontario L3B0H3"
+"Coordinates": array:2 [
0 => -79.2153327
1 => 43.0153384
]
+"Latitude": 43.0153384
+"Longitude": -79.2153327
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Step inside and fall in love! This beautifully upgraded newly-built townhome in the highly coveted Eastview Estate is filled with natural light and modern charm. Nestled next to the beautiful Welland Canal, near parks, great schools, hwy access, this development combines modern family living and nature. Offering 3 spacious bedrooms and 2.5 baths, this home welcomes you with an airy, open-concept main floor featuring wide-plank flooring, a stunning hardwood staircase, and an inviting living and dining area perfect for everyday living and entertaining. The sleek and luxurious kitchen upgraded counter tops, extra cabinet space. It also has easy inside access to the garage, along with a convenient main-level powder room. Upstairs, the impressive primary suite offers a walk-in closet and a luxurious 3-piece ensuite with a glass shower. Two additional bedrooms, a stylish 4-piece family bath, and laundry right on the bedroom level add everyday convenience. The unfinished lower level—with oversized windows—provides endless possibilities for customization along with abundant storage. With 7-year Tarion Home Warranty, you can live there with confidence and peace of mind. Create the dream space you’ve always wanted! (id:62650)"
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "High Traffic Area"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2025-12-05T23:47:34.954950+00:00"
+"Directions": "Admiral Road & Shoreview Dr"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Vinyl siding"
]
+"Heating": array:1 [
0 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2026178"
+"ListOfficeKey": "54949"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-12-05T23:29:32Z"
+"PhotosCount": 40
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-10T17:30:38Z"
+"Stories": "2.0"
+"StreetName": "ADMIRAL"
+"StreetNumber": "9"
+"StreetSuffix": "Road"
+"SubdivisionName": "766 - Hwy 406/Welland"
+"TaxAnnualAmount": "1"
+"VirtualTourURLUnbranded": "https://show.tours/v/qFR85zv"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29167988/9-admiral-road-welland"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "RM-20"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 20.0
+"AboveGradeFinishedArea": 1504
+"OriginalEntryTimestamp": "2025-12-05T23:29:31.65Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"Media": array:40 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29167988')"
+"ID": "466815"
}
]
+success: true
+page_size: 9
+page_count: 8
+count: 72
+after_key: ""
}
"RF Response Time" => "0.17 seconds"
]
]