array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29966152 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23441
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23443
+post_id: "1575474"
+post_author: 1
+"ListingKey": "29966152"
+"ListingId": "40843387"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T20:00:14Z"
+"RFModificationTimestamp": "2026-06-29T20:04:22Z"
+"ListPrice": 749900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 2529.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8G1Y8"
+"UnparsedAddress": "29 SECOND Street N, Stoney Creek, Ontario L8G1Y8"
+"Coordinates": array:2 [
0 => -79.7594199
1 => 43.2196123
]
+"Latitude": 43.2196123
+"Longitude": -79.7594199
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this stunning corner lot property in the heart of Battlefield offering the perfect blend of charm, modern updates and incredible versatility. This beautifully maintained 1.5 storey solid brick home features 4+2 bedrooms and 3 bathrooms across a thoughtfully designed layout ideal for large or multigenerational families. The main level impresses with a bright open living room showcasing a dramatic marble and gold feature wall with electric fireplace, hardwood floors and elegant arched entry. The renovated kitchen boasts quartz countertops, subway tile backsplash with mosaic accent, stainless steel appliances and a rose gold faucet. Upper level bedrooms offer vaulted ceilings with built in dressers and tons of added storage. The spa inspired upper bath features beautiful marble and gold tile with a modern vanity. The fully finished basement includes a completely separate in law suite with 2 bedrooms, a dedicated gym/flex room and recessed lighting throughout. Outside enjoy a massive fully fenced corner lot with a newer interlock patio, storage shed and a brand-new detached double garage built on a reinforced concrete slab with potential to add a second storey. 2 private doublewide driveways completes this exceptional package. Steps to shopping, top rated schools, downtown Stoney Creek and all major highways. The new GO Station just 5 minutes away making this the ultimate location for commuters and families alike. This one checks every box. Space, style, location and income potential all on one incredible lot. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Gas stove(s)"
3 => "Dishwasher"
4 => "Dryer"
5 => "Microwave"
6 => "Hood Fan"
7 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-29T17:44:38.948115+00:00"
+"Directions": "King & Second St N"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2176994"
+"ListOfficeKey": "275989"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Corner Site"
1 => "In-Law Suite"
]
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-06-29T16:51:42Z"
+"PhotosCount": 36
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-29T19:51:05Z"
+"Stories": "1.5"
+"StreetDirSuffix": "North"
+"StreetName": "SECOND"
+"StreetNumber": "29"
+"StreetSuffix": "Street"
+"SubdivisionName": "515 - Battlefield"
+"TaxAnnualAmount": "4584.25"
+"VirtualTourURLUnbranded": "https://youtu.be/cDS7B4yzZtQ"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:18 [
0 => array:11 [
"RoomKey" => "1671407579"
"RoomType" => "Utility room"
"ListingId" => "40843387"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29966152"
"RoomLength" => null
"RoomDimensions" => "6'9'' x 3'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T19:51:05.72Z"
]
1 => array:11 [
"RoomKey" => "1671407580"
"RoomType" => "Bonus Room"
"ListingId" => "40843387"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29966152"
"RoomLength" => null
"RoomDimensions" => "7'8'' x 11'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T19:51:05.73Z"
]
2 => array:11 [
"RoomKey" => "1671407581"
"RoomType" => "4pc Bathroom"
"ListingId" => "40843387"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29966152"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T19:51:05.73Z"
]
3 => array:11 [
"RoomKey" => "1671407582"
"RoomType" => "Recreation room"
"ListingId" => "40843387"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29966152"
"RoomLength" => null
"RoomDimensions" => "8'0'' x 13'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T19:51:05.74Z"
]
4 => array:11 [
"RoomKey" => "1671407583"
"RoomType" => "Bedroom"
"ListingId" => "40843387"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29966152"
"RoomLength" => null
"RoomDimensions" => "11'11'' x 10'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T19:51:05.74Z"
]
5 => array:11 [
"RoomKey" => "1671407584"
"RoomType" => "Bedroom"
"ListingId" => "40843387"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29966152"
"RoomLength" => null
"RoomDimensions" => "14'7'' x 10'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T19:51:05.74Z"
]
6 => array:11 [
"RoomKey" => "1671407585"
"RoomType" => "Kitchen"
"ListingId" => "40843387"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29966152"
"RoomLength" => null
"RoomDimensions" => "15'7'' x 18'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T19:51:05.75Z"
]
7 => array:11 [
"RoomKey" => "1671407586"
"RoomType" => "Attic"
"ListingId" => "40843387"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29966152"
"RoomLength" => null
"RoomDimensions" => "4'4'' x 21'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T19:51:05.75Z"
]
8 => array:11 [
"RoomKey" => "1671407587"
"RoomType" => "Attic"
"ListingId" => "40843387"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29966152"
"RoomLength" => null
"RoomDimensions" => "11'1'' x 5'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T19:51:05.76Z"
]
9 => array:11 [
"RoomKey" => "1671407588"
"RoomType" => "4pc Bathroom"
"ListingId" => "40843387"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29966152"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T19:51:05.76Z"
]
10 => array:11 [
"RoomKey" => "1671407589"
"RoomType" => "Bedroom"
"ListingId" => "40843387"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29966152"
"RoomLength" => null
"RoomDimensions" => "10'10'' x 10'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T19:51:05.77Z"
]
11 => array:11 [
"RoomKey" => "1671407590"
"RoomType" => "Bedroom"
"ListingId" => "40843387"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29966152"
"RoomLength" => null
"RoomDimensions" => "10'9'' x 14'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T19:51:05.77Z"
]
12 => array:11 [
"RoomKey" => "1671407591"
"RoomType" => "4pc Bathroom"
"ListingId" => "40843387"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29966152"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T19:51:05.77Z"
]
13 => array:11 [
"RoomKey" => "1671407592"
"RoomType" => "Bedroom"
"ListingId" => "40843387"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29966152"
"RoomLength" => null
"RoomDimensions" => "11'8'' x 11'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T19:51:05.78Z"
]
14 => array:11 [
"RoomKey" => "1671407593"
"RoomType" => "Primary Bedroom"
"ListingId" => "40843387"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29966152"
"RoomLength" => null
"RoomDimensions" => "11'3'' x 10'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T19:51:05.78Z"
]
15 => array:11 [
"RoomKey" => "1671407594"
"RoomType" => "Living room"
"ListingId" => "40843387"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29966152"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 18'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T19:51:05.79Z"
]
16 => array:11 [
"RoomKey" => "1671407595"
"RoomType" => "Dining room"
"ListingId" => "40843387"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29966152"
"RoomLength" => null
"RoomDimensions" => "8'8'' x 9'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T19:51:05.79Z"
]
17 => array:11 [
"RoomKey" => "1671407596"
"RoomType" => "Kitchen"
"ListingId" => "40843387"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29966152"
"RoomLength" => null
"RoomDimensions" => "14'9'' x 8'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T19:51:05.8Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29966152/29-second-street-n-stoney-creek"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 50.0
+"AboveGradeFinishedArea": 1494
+"BelowGradeFinishedArea": 1035
+"OriginalEntryTimestamp": "2026-06-29T16:51:42.37Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"BelowGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1448695"
+"ListOfficeNationalAssociationId": "1269881"
+"Media": array:36 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29966152_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966152/e912ee75829fb11c2f9481ea622186eb.webp"
"MediaSize" => 136216
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966152/thumbnail-e912ee75829fb11c2f9481ea622186eb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40843387"
"ResourceRecordKey" => "29966152"
"ModificationTimestamp" => "2026-06-29T16:51:42.39Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29966152_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966152/3bbfd301caf6b526a4b236ad5a945ef0.webp"
"MediaSize" => 162908
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966152/thumbnail-3bbfd301caf6b526a4b236ad5a945ef0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843387"
"ResourceRecordKey" => "29966152"
"ModificationTimestamp" => "2026-06-29T16:51:42.39Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29966152_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966152/c132fb31aa954c5fa88797f3dfc3fb97.webp"
"MediaSize" => 73057
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966152/thumbnail-c132fb31aa954c5fa88797f3dfc3fb97.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843387"
"ResourceRecordKey" => "29966152"
"ModificationTimestamp" => "2026-06-29T16:51:42.39Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29966152_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966152/bcb48768bb3c99e647c809837d976dee.webp"
"MediaSize" => 77633
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966152/thumbnail-bcb48768bb3c99e647c809837d976dee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843387"
"ResourceRecordKey" => "29966152"
"ModificationTimestamp" => "2026-06-29T16:51:42.39Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29966152_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966152/7a691b240de0cc5c5308242af4986635.webp"
"MediaSize" => 58807
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966152/thumbnail-7a691b240de0cc5c5308242af4986635.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843387"
"ResourceRecordKey" => "29966152"
"ModificationTimestamp" => "2026-06-29T16:51:42.39Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29966152_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966152/e8205bf56af2939971aec8786f7bbece.webp"
"MediaSize" => 63618
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966152/thumbnail-e8205bf56af2939971aec8786f7bbece.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843387"
"ResourceRecordKey" => "29966152"
"ModificationTimestamp" => "2026-06-29T16:51:42.39Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29966152_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966152/0c2425370e8c853997b0d7b188b0e713.webp"
"MediaSize" => 62914
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966152/thumbnail-0c2425370e8c853997b0d7b188b0e713.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843387"
"ResourceRecordKey" => "29966152"
"ModificationTimestamp" => "2026-06-29T16:51:42.39Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29966152_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966152/cf2bd2a5706cf27e6e04d36797fc23a9.webp"
"MediaSize" => 62208
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966152/thumbnail-cf2bd2a5706cf27e6e04d36797fc23a9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843387"
"ResourceRecordKey" => "29966152"
"ModificationTimestamp" => "2026-06-29T16:51:42.39Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29966152_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966152/341c75ee11f1cdc5b724b1996defa636.webp"
"MediaSize" => 79141
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966152/thumbnail-341c75ee11f1cdc5b724b1996defa636.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843387"
"ResourceRecordKey" => "29966152"
"ModificationTimestamp" => "2026-06-29T16:51:42.39Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29966152_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966152/7ff03c4741e200f51a3cf29d1e8fea89.webp"
"MediaSize" => 76146
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966152/thumbnail-7ff03c4741e200f51a3cf29d1e8fea89.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843387"
"ResourceRecordKey" => "29966152"
"ModificationTimestamp" => "2026-06-29T16:51:42.39Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29966152_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966152/019022bc534c75b43f9246b4c3363ae5.webp"
"MediaSize" => 57378
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966152/thumbnail-019022bc534c75b43f9246b4c3363ae5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843387"
"ResourceRecordKey" => "29966152"
"ModificationTimestamp" => "2026-06-29T16:51:42.39Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29966152_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966152/20fc284ed5cff4f35bc1ef03680173b3.webp"
"MediaSize" => 43120
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966152/thumbnail-20fc284ed5cff4f35bc1ef03680173b3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843387"
"ResourceRecordKey" => "29966152"
"ModificationTimestamp" => "2026-06-29T16:51:42.39Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29966152_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966152/323430752b22cbfb19b73c3637a3b609.webp"
"MediaSize" => 46579
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966152/thumbnail-323430752b22cbfb19b73c3637a3b609.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843387"
"ResourceRecordKey" => "29966152"
"ModificationTimestamp" => "2026-06-29T16:51:42.39Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29966152_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966152/eb4b80a8f17ea4c9d5f7090348ef724f.webp"
"MediaSize" => 51797
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966152/thumbnail-eb4b80a8f17ea4c9d5f7090348ef724f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843387"
"ResourceRecordKey" => "29966152"
"ModificationTimestamp" => "2026-06-29T16:51:42.39Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29966152_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966152/5de449719a80a347ffffc1957fc4697a.webp"
"MediaSize" => 56075
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966152/thumbnail-5de449719a80a347ffffc1957fc4697a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843387"
"ResourceRecordKey" => "29966152"
"ModificationTimestamp" => "2026-06-29T16:51:42.39Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29966152_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966152/e1a5e65d8e0741b99363e529381e2af1.webp"
"MediaSize" => 64370
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966152/thumbnail-e1a5e65d8e0741b99363e529381e2af1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843387"
"ResourceRecordKey" => "29966152"
"ModificationTimestamp" => "2026-06-29T16:51:42.39Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29966152_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966152/6ecac8bb60debd265ecf047ffb8708ec.webp"
"MediaSize" => 46492
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966152/thumbnail-6ecac8bb60debd265ecf047ffb8708ec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843387"
"ResourceRecordKey" => "29966152"
"ModificationTimestamp" => "2026-06-29T16:51:42.39Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29966152_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966152/9f7964c49b4df9d4b50724dac3eafccb.webp"
"MediaSize" => 52109
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966152/thumbnail-9f7964c49b4df9d4b50724dac3eafccb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843387"
"ResourceRecordKey" => "29966152"
"ModificationTimestamp" => "2026-06-29T16:51:42.39Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29966152_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966152/7437884edd048a34ebd910580c82a7fb.webp"
"MediaSize" => 64709
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966152/thumbnail-7437884edd048a34ebd910580c82a7fb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843387"
"ResourceRecordKey" => "29966152"
"ModificationTimestamp" => "2026-06-29T16:51:42.39Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29966152_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966152/4e3755f4f04c94d1e0811cf88e628f01.webp"
"MediaSize" => 67328
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966152/thumbnail-4e3755f4f04c94d1e0811cf88e628f01.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843387"
"ResourceRecordKey" => "29966152"
"ModificationTimestamp" => "2026-06-29T16:51:42.39Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29966152_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966152/ab0ce7e4675cf6ad75bf3ca7423ef2ca.webp"
"MediaSize" => 50868
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966152/thumbnail-ab0ce7e4675cf6ad75bf3ca7423ef2ca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843387"
"ResourceRecordKey" => "29966152"
"ModificationTimestamp" => "2026-06-29T16:51:42.39Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29966152_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966152/fa53547f3d3c50db1fc30fd0cedbe8e9.webp"
"MediaSize" => 64430
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966152/thumbnail-fa53547f3d3c50db1fc30fd0cedbe8e9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843387"
"ResourceRecordKey" => "29966152"
"ModificationTimestamp" => "2026-06-29T16:51:42.39Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29966152_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966152/1fa2e6a8f6058e886353c3e042d839b2.webp"
"MediaSize" => 53254
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966152/thumbnail-1fa2e6a8f6058e886353c3e042d839b2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843387"
"ResourceRecordKey" => "29966152"
"ModificationTimestamp" => "2026-06-29T16:51:42.39Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29966152_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966152/ea4919239276f2a4adac8bd94a424b14.webp"
"MediaSize" => 72720
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966152/thumbnail-ea4919239276f2a4adac8bd94a424b14.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843387"
"ResourceRecordKey" => "29966152"
"ModificationTimestamp" => "2026-06-29T16:51:42.39Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29966152_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966152/979dc7ae0bc8bf08c04d557959c1a326.webp"
"MediaSize" => 40434
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966152/thumbnail-979dc7ae0bc8bf08c04d557959c1a326.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843387"
"ResourceRecordKey" => "29966152"
"ModificationTimestamp" => "2026-06-29T16:51:42.39Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29966152_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966152/201d9051a3845c33d7ab6271971ffdf0.webp"
"MediaSize" => 52583
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966152/thumbnail-201d9051a3845c33d7ab6271971ffdf0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843387"
"ResourceRecordKey" => "29966152"
"ModificationTimestamp" => "2026-06-29T16:51:42.39Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29966152_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966152/938a846f6f725525c3e44115b60903e0.webp"
"MediaSize" => 31755
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966152/thumbnail-938a846f6f725525c3e44115b60903e0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843387"
"ResourceRecordKey" => "29966152"
"ModificationTimestamp" => "2026-06-29T16:51:42.39Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29966152_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966152/a136bdebc0b1587ed95c9e9d14bd19f6.webp"
"MediaSize" => 59771
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966152/thumbnail-a136bdebc0b1587ed95c9e9d14bd19f6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843387"
"ResourceRecordKey" => "29966152"
"ModificationTimestamp" => "2026-06-29T16:51:42.39Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29966152_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966152/1f28bb635965a0fa1eb8cac10bcb9670.webp"
"MediaSize" => 38552
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966152/thumbnail-1f28bb635965a0fa1eb8cac10bcb9670.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843387"
"ResourceRecordKey" => "29966152"
"ModificationTimestamp" => "2026-06-29T16:51:42.39Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29966152_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966152/f092defd23df316061e90eb296faa6fc.webp"
"MediaSize" => 136421
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966152/thumbnail-f092defd23df316061e90eb296faa6fc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843387"
"ResourceRecordKey" => "29966152"
"ModificationTimestamp" => "2026-06-29T16:51:42.39Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29966152_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966152/3e14a0ee2cc9b185b925e7cf4244fee6.webp"
"MediaSize" => 117834
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966152/thumbnail-3e14a0ee2cc9b185b925e7cf4244fee6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843387"
"ResourceRecordKey" => "29966152"
"ModificationTimestamp" => "2026-06-29T16:51:42.39Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29966152_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966152/a291b8d971181063a5e5bc45f3145ac5.webp"
"MediaSize" => 107223
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966152/thumbnail-a291b8d971181063a5e5bc45f3145ac5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843387"
"ResourceRecordKey" => "29966152"
"ModificationTimestamp" => "2026-06-29T16:51:42.39Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29966152_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966152/e23c388857a6bb0bbaa95097b35325b1.webp"
"MediaSize" => 138004
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966152/thumbnail-e23c388857a6bb0bbaa95097b35325b1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843387"
"ResourceRecordKey" => "29966152"
"ModificationTimestamp" => "2026-06-29T16:51:42.39Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29966152_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966152/e752f58463e684c8222ad48f13e8c699.webp"
"MediaSize" => 136949
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966152/thumbnail-e752f58463e684c8222ad48f13e8c699.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843387"
"ResourceRecordKey" => "29966152"
"ModificationTimestamp" => "2026-06-29T16:51:42.39Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29966152_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966152/7dd2ae7467c2c47bb72890745c7443c3.webp"
"MediaSize" => 137623
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966152/thumbnail-7dd2ae7467c2c47bb72890745c7443c3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843387"
"ResourceRecordKey" => "29966152"
"ModificationTimestamp" => "2026-06-29T16:51:42.39Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29966152_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966152/1c6ffe54822d51db35e61aa3050b6541.webp"
"MediaSize" => 143037
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966152/thumbnail-1c6ffe54822d51db35e61aa3050b6541.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843387"
"ResourceRecordKey" => "29966152"
"ModificationTimestamp" => "2026-06-29T16:51:42.39Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29966152')"
+"ID": "1575474"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 275989" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24858
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2176994" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24956
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24849
+post_id: ? mixed
+post_author: ? mixed
+"MemberMlsId": "2176994"
+"ModificationTimestamp": "2026-06-26T20:00:50Z"
+"OriginatingSystemName": "CREA"
+"MemberKey": "2176994"
+"MemberPreferredPhoneExt": null
+"MemberMlsSecurityClass": null
+"MemberNationalAssociationId": null
+"MemberAddress1": null
+"MemberType": null
+"MemberDesignation": null
+"MemberCity": null
+"MemberStateOrProvince": null
+"MemberPostalCode": null
+"OriginalEntryTimestamp": null
+"MemberOfficePhone": null
+"MemberOfficePhoneExt": null
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Member('2176994')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.25 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29966152'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25249
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29966152'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25337
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29966152' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.7594199 43.2196123)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25283
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25277
+post_id: "1577590"
+post_author: 1
+"ListingKey": "29968459"
+"ListingId": "40843990"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T22:40:09Z"
+"RFModificationTimestamp": "2026-06-30T01:01:10Z"
+"ListPrice": 859900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1957.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8G2N1"
+"UnparsedAddress": "57 NEIL Avenue, Stoney Creek, Ontario L8G2N1"
+"Coordinates": array:2 [
0 => -79.7622649
1 => 43.2256352
]
+"Latitude": 43.2256352
+"Longitude": -79.7622649
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Room to spread out and a view that stays with you. Set on a corner lot in a quiet Stoney Creek neighborhood, this full-brick two-storey residence pairs everyday comfort with escarpment views. A covered front porch sets the tone; the double concrete driveway parks four and the attached one-and-a-half-car garage is ready for projects with its workbench and shelving. Inside, a bright foyer opens to a formal living and dining room that run together for easy hosting, while the kitchen flows into a sun-filled dinette with a walkout to the back deck and private yard, an effortless link between indoors and out. A family room anchored by a gas fireplace and a three-piece bathroom complete the main floor. Upstairs, gleaming hardwood leads to four spacious bedrooms and a five-piece bathroom, and two of them - including the primary suite - open through walkouts onto a full-width front balcony. Downstairs, a fully finished basement adds a rec room, game room, a cedar storage closet, a big laundry/utility room and a spacious cantina with plenty of shelving. Outside, perennial gardens, a privacy hedge and a vegetable garden complete a beautifully landscaped yard, all under that escarpment backdrop. Walk to downtown Stoney Creek's cafés, restaurants and Battlefield Park; minutes to Eastgate Mall, Denninger's, schools and the Queen Elizabeth Way and Red Hill Valley Parkway, five minutes to the new Confederation GO station and seven to Confederation Park's beach and waterfront trail. Don’t be TOO LATE*! *REG TM. RSA. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-30T01:01:04.422498+00:00"
+"Directions": "Queenston Rd to Centennial Pkwy to Neil Ave"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1525426"
+"ListOfficeKey": "293261"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Southern exposure"
1 => "Corner Site"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-29T22:31:34Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-29T22:31:34Z"
+"Stories": "2.0"
+"StreetName": "NEIL"
+"StreetNumber": "57"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "515 - Battlefield"
+"TaxAnnualAmount": "5900"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [
"RoomKey" => "1671516898"
"RoomType" => "Laundry room"
"ListingId" => "40843990"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29968459"
"RoomLength" => null
"RoomDimensions" => "16'8'' x 13'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T22:31:34.35Z"
]
1 => array:11 [
"RoomKey" => "1671516899"
"RoomType" => "Recreation room"
"ListingId" => "40843990"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29968459"
"RoomLength" => null
"RoomDimensions" => "13'3'' x 21'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T22:31:34.35Z"
]
2 => array:11 [
"RoomKey" => "1671516900"
"RoomType" => "Storage"
"ListingId" => "40843990"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29968459"
"RoomLength" => null
"RoomDimensions" => "5'0'' x 28'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T22:31:34.36Z"
]
3 => array:11 [
"RoomKey" => "1671516901"
"RoomType" => "Games room"
"ListingId" => "40843990"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29968459"
"RoomLength" => null
"RoomDimensions" => "12'6'' x 24'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T22:31:34.37Z"
]
4 => array:11 [
"RoomKey" => "1671516902"
"RoomType" => "Bedroom"
"ListingId" => "40843990"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29968459"
"RoomLength" => null
"RoomDimensions" => "9'1'' x 10'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T22:31:34.37Z"
]
5 => array:11 [
"RoomKey" => "1671516903"
"RoomType" => "Bedroom"
"ListingId" => "40843990"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29968459"
"RoomLength" => null
"RoomDimensions" => "13'9'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T22:31:34.38Z"
]
6 => array:11 [
"RoomKey" => "1671516904"
"RoomType" => "5pc Bathroom"
"ListingId" => "40843990"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29968459"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T22:31:34.38Z"
]
7 => array:11 [
"RoomKey" => "1671516905"
"RoomType" => "Bedroom"
"ListingId" => "40843990"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29968459"
"RoomLength" => null
"RoomDimensions" => "13'3'' x 10'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T22:31:34.39Z"
]
8 => array:11 [
"RoomKey" => "1671516906"
"RoomType" => "Primary Bedroom"
"ListingId" => "40843990"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29968459"
"RoomLength" => null
"RoomDimensions" => "13'5'' x 14'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T22:31:34.39Z"
]
9 => array:11 [
"RoomKey" => "1671516907"
"RoomType" => "3pc Bathroom"
"ListingId" => "40843990"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29968459"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T22:31:34.4Z"
]
10 => array:11 [
"RoomKey" => "1671516908"
"RoomType" => "Family room"
"ListingId" => "40843990"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29968459"
"RoomLength" => null
"RoomDimensions" => "17'4'' x 13'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T22:31:34.4Z"
]
11 => array:11 [
"RoomKey" => "1671516909"
"RoomType" => "Dinette"
"ListingId" => "40843990"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29968459"
"RoomLength" => null
"RoomDimensions" => "17'6'' x 10'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T22:31:34.4Z"
]
12 => array:11 [
"RoomKey" => "1671516910"
"RoomType" => "Kitchen"
"ListingId" => "40843990"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29968459"
"RoomLength" => null
"RoomDimensions" => "13'5'' x 8'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T22:31:34.41Z"
]
13 => array:11 [
"RoomKey" => "1671516911"
"RoomType" => "Dining room"
"ListingId" => "40843990"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29968459"
"RoomLength" => null
"RoomDimensions" => "13'0'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T22:31:34.41Z"
]
14 => array:11 [
"RoomKey" => "1671516912"
"RoomType" => "Living room"
"ListingId" => "40843990"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29968459"
"RoomLength" => null
"RoomDimensions" => "13'5'' x 17'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T22:31:34.42Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29968459/57-neil-avenue-stoney-creek"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 42.0
+"AboveGradeFinishedArea": 1957
+"OriginalEntryTimestamp": "2026-06-29T22:31:34.12Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1063673"
+"ListOfficeNationalAssociationId": "1424570"
+"Media": array:50 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29968459_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29968459/f4cae83319bb45735e3a4637ca7ade9f.webp"
"MediaSize" => 163718
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29968459/thumbnail-f4cae83319bb45735e3a4637ca7ade9f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40843990"
"ResourceRecordKey" => "29968459"
"ModificationTimestamp" => "2026-06-29T22:31:34.14Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29968459_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29968459/178e5cf5a255224e1389d728b196a9df.webp"
"MediaSize" => 127941
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29968459/thumbnail-178e5cf5a255224e1389d728b196a9df.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843990"
"ResourceRecordKey" => "29968459"
"ModificationTimestamp" => "2026-06-29T22:31:34.14Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29968459_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29968459/2ca13b0409c3c9cc0508c48088f100f8.webp"
"MediaSize" => 185059
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29968459/thumbnail-2ca13b0409c3c9cc0508c48088f100f8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843990"
"ResourceRecordKey" => "29968459"
"ModificationTimestamp" => "2026-06-29T22:31:34.14Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29968459_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29968459/9fb37009fd2a0c3caab77020f42c4796.webp"
"MediaSize" => 157708
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29968459/thumbnail-9fb37009fd2a0c3caab77020f42c4796.webp"
"ResourceName" => "Property"
…6
]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29968459')"
+"ID": "1577590"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25279
+post_id: "1577324"
+post_author: 1
+"ListingKey": "29968874"
+"ListingId": "X13503100"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-30T00:20:05Z"
+"RFModificationTimestamp": "2026-06-30T00:43:31Z"
+"ListPrice": 859900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8G2N1"
+"UnparsedAddress": "57 NEIL AVENUE, Hamilton (Stoney Creek), Ontario L8G2N1"
+"Coordinates": array:2 [
0 => -79.762267
1 => 43.225596
]
+"Latitude": 43.225596
+"Longitude": -79.762267
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Room to spread out and a view that stays with you. Set on a corner lot in a quiet Stoney Creek neighborhood, this full-brick two-storey residence pairs everyday comfort with escarpment views. A covered front porch sets the tone; the double concrete driveway parks four and the attached one-and-a-half-car garage is ready for projects with its workbench and shelving. Inside, a bright foyer opens to a formal living and dining room that run together for easy hosting, while the kitchen flows into a sun-filled dinette with a walkout to the back deck and private yard, an effortless link between indoors and out. A family room anchored by a gas fireplace and a three-piece bathroom complete the main floor. Upstairs, gleaming hardwood leads to four spacious bedrooms and a five-piece bathroom, and two of them - including the primary suite - open through walkouts onto a full-width front balcony. Downstairs, a fully finished basement adds a rec room, game room, a cedar storage closet, a big laundry/utility room and a spacious cantina with plenty of shelving. Outside, perennial gardens, a privacy hedge and a vegetable garden complete a beautifully landscaped yard, all under that escarpment backdrop. Walk to downtown Stoney Creek's cafés, restaurants and Battlefield Park; minutes to Eastgate Mall, Groceries, schools and the Queen Elizabeth Way and Red Hill Valley Parkway, five minutes to the new Confederation GO station and seven to Confederation Park's beach and waterfront trail. RSA. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-30T00:43:22.410044+00:00"
+"Directions": "Cross Streets: Centennial Pkwy. ** Directions: QUEENSON RD TO CENTENNIAL PKWY TO NEIL AVE."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1979013"
+"ListOfficeKey": "293273"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Irregular lot size"
]
+"LotSizeDimensions": "41.5 x 100 FT"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-06-30T00:14:57Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-30T00:14:57Z"
+"Stories": "2.0"
+"StreetName": "NEIL"
+"StreetNumber": "57"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "5900"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29968874/57-neil-avenue-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 41.6
+"OriginalEntryTimestamp": "2026-06-30T00:14:57.08Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1264940"
+"ListOfficeNationalAssociationId": "1424812"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29968874')"
+"ID": "1577324"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25276
+post_id: "1571751"
+post_author: 1
+"ListingKey": "29960784"
+"ListingId": "X13496028"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T21:35:05Z"
+"RFModificationTimestamp": "2026-06-26T22:50:21Z"
+"ListPrice": 615000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8G1T3"
+"UnparsedAddress": "43 WYNGATE AVENUE E, Hamilton (Stoney Creek), Ontario L8G1T3"
+"Coordinates": array:2 [
0 => -79.764053
1 => 43.214905
]
+"Latitude": 43.214905
+"Longitude": -79.764053
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "The Oakville, Milton & District Real Estate Board"
+"PublicRemarks": "Heart of Stoney Creek! Located in the desirable Battlefield neighbourhood, this character-filled home offers beautiful escarpment views and sits on a mature, tree-lined street just steps from parks, shopping, and the charming downtown core. The spacious main level features a home office, updated 2-piece bathroom, bright open-concept living and dining areas, and a large eat-in kitchen. Sliding doors lead to the generous backyard, providing plenty of space to relax, entertain, or create your dream outdoor retreat. Upstairs, you'll find two large bedrooms, a full bathroom, and original hardwood flooring full of timeless charm. The basement offers excellent in-law suite potential with a separate walk-up entrance and impressive ceiling height. While the home could benefit from some TLC and cosmetic updates, it presents an incredible opportunity for buyers looking to add value and make a home their own in a highly sought-after neighbourhood. Bring your vision and unlock the potential of this Stoney Creek gem! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"Basement": array:7 [
0 => "Partial"
1 => "Separate entrance"
2 => "Walk out"
3 => "Walk-up"
4 => "N/A"
5 => "N/A"
6 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T22:50:10.114328+00:00"
+"Directions": "Cross Streets: Robb Ave. ** Directions: Robb Ave to Wyngate Ave."
+"ExteriorFeatures": array:1 [
0 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:3 [
0 => "Forced air"
1 => "Natural gas"
2 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2104041"
+"ListOfficeKey": "300343"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "50 x 100 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-26T21:26:34Z"
+"PhotosCount": 41
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-26T21:26:34Z"
+"Stories": "2.0"
+"StreetDirSuffix": "East"
+"StreetName": "Wyngate"
+"StreetNumber": "43"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "4416.47"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Oakville-Milton"
+"TaxYear": 2026
+"CityRegion": "Stoney Creek"
+"ListAORKey": "15"
+"ListingURL": "www.realtor.ca/real-estate/29960784/43-wyngate-avenue-e-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 2
+"FrontageLengthNumeric": 50.0
+"OriginalEntryTimestamp": "2026-06-26T21:26:34.3Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1373513"
+"ListOfficeNationalAssociationId": "1486945"
+"Media": array:41 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29960784')"
+"ID": "1571751"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25280
+post_id: "1570780"
+post_author: 1
+"ListingKey": "29959821"
+"ListingId": "40843435"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T20:00:08Z"
+"RFModificationTimestamp": "2026-06-26T20:01:31Z"
+"ListPrice": 665000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2538.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8G2L2"
+"UnparsedAddress": "18 PLEASANT Avenue, Stoney Creek, Ontario L8G2L2"
+"Coordinates": array:2 [
0 => -79.7682567
1 => 43.2235452
]
+"Latitude": 43.2235452
+"Longitude": -79.7682567
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Solid all-brick bungalow on a quiet cul-de-sac in sought-after Stoney Creek! This well-maintained home offers 2,294 sq ft of total living space and is perfect for multi-generational families or savvy investors. The main level features a bright spacious living room with hardwood floors, an updated kitchen with stainless steel appliances, separate dining area, 3 generous bedrooms, and a full bath. The fully self-contained in-law suite on the lower level boasts a separate side entrance, full kitchen, large recreation room, 1 bedroom, full bath, and in-suite laundry perfect for extended family or rental income. Brand new furnace for added peace of mind. Outside, enjoy a private backyard retreat with a concrete patio, mature trees, and beautifully maintained gardens. Single attached garage completes this incredible package. Steps to schools, parks, shopping, and all Stoney Creek amenities. A rare find don't miss out! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T20:01:25.765933+00:00"
+"Directions": "Centennial Parkway and west on Pleasant Avenue"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2176994"
+"ListOfficeKey": "275989"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Cul-de-sac"
1 => "Automatic Garage Door Opener"
2 => "In-Law Suite"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-26T19:10:37Z"
+"PhotosCount": 31
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-26T19:50:39Z"
+"Stories": "1.0"
+"StreetName": "PLEASANT"
+"StreetNumber": "18"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "515 - Battlefield"
+"TaxAnnualAmount": "4683"
+"VirtualTourURLUnbranded": "https://youtu.be/qc6YuVVdLUU"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29959821/18-pleasant-avenue-stoney-creek"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 50.0
+"AboveGradeFinishedArea": 1269
+"BelowGradeFinishedArea": 1269
+"OriginalEntryTimestamp": "2026-06-26T19:10:36.39Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"BelowGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1448695"
+"ListOfficeNationalAssociationId": "1269881"
+"Media": array:31 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29959821')"
+"ID": "1570780"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25278
+post_id: "1570501"
+post_author: 1
+"ListingKey": "29956998"
+"ListingId": "X13492532"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T13:55:01Z"
+"RFModificationTimestamp": "2026-06-26T17:35:05Z"
+"ListPrice": 968800.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Gershome)"
+"PostalCode": "L8G5B3"
+"UnparsedAddress": "137 NATIONAL DRIVE, Hamilton (Gershome), Ontario L8G5B3"
+"Coordinates": array:2 [
0 => -79.778911
1 => 43.214193
]
+"Latitude": 43.214193
+"Longitude": -79.778911
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Timeless and distinguised in a highly sought-after East Hamilton neighbourhood! This meticulously maintained 4-bedroom 2.5-bathroom corner residence with 2600 square feet of living space is being offered for the first time. Nestled within an enclave of executive detached homes, this one-owner property showcases classic charm, rich wood accents, and a warm, inviting atmosphere - ideal for family living. Designed for both formal entertaining and everyday comfort, the main level offers a bright living and dining room, a spacious eat-in kitchen, and an inviting family room with a brick-surround fireplace. A convenient main-floor laundry/mudroom and 2-piece powder room add to the home's functionality. A striking curved staircase makes a grant first impression, leading to the upper level where hardwood flooring continues throughout four spacious bedrooms. The primary suite features a walk-in closet and private ensuite, while the additional bedrooms share a well-appointed main bathroom. The lower level provides endless possibilities for customization along with ample storage space. Enjoy exceptional curb appeal with inside access to a convenient attached double car garage. Ideally located just minutes from Eastgate square, Queenston/Centennial amenities, St. Joseph's Hospital, and offering quick access to the Red Hill Parkway and QEW. A rare opportunity to own a cherished home in a prime location-perfect for growing families seeking space, comfort and convenience. (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"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T17:25:32.471072+00:00"
+"Directions": "Cross Streets: Tommar Place. ** Directions: Greenhill, Tommar Pl onto National Dr."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"Flooring": array:1 [
0 => "Hardwood"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2164018"
+"ListOfficeKey": "280315"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Irregular lot size"
1 => "Conservation/green belt"
]
+"LotSizeDimensions": "80.9 x 106.4 FT ; 47.70ftx69.83ft x 7.16ftx7.16ftx7.16ft"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-26T13:45:59Z"
+"PhotosCount": 46
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-26T13:45:59Z"
+"Stories": "2.0"
+"StreetName": "National"
+"StreetNumber": "137"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "7291.05"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Gershome"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29956998/137-national-drive-hamilton-gershome-gershome"
+"ParkingTotal": 8
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"ZoningDescription": "C/S-1045"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 80.1
+"OriginalEntryTimestamp": "2026-06-26T13:45:59.66Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1414953"
+"ListOfficeNationalAssociationId": "1312645"
+"Media": array:46 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29956998')"
+"ID": "1570501"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25273
+post_id: "1569636"
+post_author: 1
+"ListingKey": "29957210"
+"ListingId": "40843252"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T14:30:20Z"
+"RFModificationTimestamp": "2026-06-26T17:13:39Z"
+"ListPrice": 599900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1165.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8E1R4"
+"UnparsedAddress": "185 CEDARDALE Avenue, Stoney Creek, Ontario L8E1R4"
+"Coordinates": array:2 [
0 => -79.7399753
1 => 43.2263978
]
+"Latitude": 43.2263978
+"Longitude": -79.7399753
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this charming bungaloft nestled in the heart of Stoney Creek! Offering 3 bedrooms, 1 bathroom, and a dedicated home office, this lovingly maintained home blends comfort, character, and everyday functionality. Step inside to discover bright, inviting living spaces with a practical layout that makes the most of every square foot. The versatile home office is ideal for working from home, studying, or pursuing your favourite hobbies. Whether you're a first-time buyer, downsizer, or savvy investor, this home offers exceptional value in a sought-after neighbourhood. Step outside and enjoy the generous outdoor living space, perfect for entertaining, gardening, or relaxing with family and friends. The backyard provides plenty of room to enjoy the outdoors and make it your own. Located in one of Stoney Creek's most desirable neighbourhoods, you'll appreciate being surrounded by great neighbours and within walking distance to parks, schools, shopping, restaurants, public transit, and everyday amenities. Investors will also recognize the property's strong potential, with its desirable location, functional layout, and opportunity to personalize or add value over time. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Partial"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T17:13:33.574090+00:00"
+"Directions": "Gray Road to Cedardale Ave"
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2250743"
+"ListOfficeKey": "292301"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-06-26T14:20:55Z"
+"PhotosCount": 23
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-26T14:20:55Z"
+"Stories": "1.0"
+"StreetName": "CEDARDALE"
+"StreetNumber": "185"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "511 - Eastdale/Poplar Park/Industrial"
+"TaxAnnualAmount": "4131"
+"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/29957210/185-cedardale-avenue-stoney-creek"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 47.0
+"AboveGradeFinishedArea": 1165
+"OriginalEntryTimestamp": "2026-06-26T14:20:55.24Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1489653"
+"ListOfficeNationalAssociationId": "1410382"
+"Media": array:23 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29957210')"
+"ID": "1569636"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23455
+post_id: "1564992"
+post_author: 1
+"ListingKey": "29954356"
+"ListingId": "X13490278"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T20:30:15Z"
+"RFModificationTimestamp": "2026-06-26T00:32:03Z"
+"ListPrice": 769900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8G2X5"
+"UnparsedAddress": "36 GRAY ROAD, Hamilton (Stoney Creek), Ontario L8G2X5"
+"Coordinates": array:2 [
0 => -79.7476555
1 => 43.2139717
]
+"Latitude": 43.2139717
+"Longitude": -79.7476555
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 36 Gray Road S, a spacious raised ranch ideally situated in a beautiful Stoney Creek neighbourhood tucked beneath the Niagara Escarpment. Offering 3 bedrooms, 2 bathrooms, and a functional layout finished from top to bottom, this well-maintained home provides excellent space for families, downsizers, or anyone seeking a convenient location close to everyday amenities. The bright main level offers comfortable principal rooms, while the finished lower level features a welcoming family room complete with a gas fireplace-perfect for relaxing or entertaining. A double car garage adds everyday convenience, and numerous updates completed over the past 15 years include the electrical panel, furnace, select windows, and shingles. Enjoy the charm of an established neighbourhood with easy access to parks, schools, shopping, transit, highways, and the Escarpment's beautiful trails. (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Freezer"
9 => "Window Coverings"
10 => "Garage door opener remote(s)"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T00:31:27.880655+00:00"
+"Directions": "Cross Streets: King St E. ** Directions: King St E to Gray Rd, go south!."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Fencing": array:2 [
0 => "Fenced yard"
1 => "Fully Fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2038160"
+"ListOfficeKey": "280315"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "60 x 100 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-25T19:50:09Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T20:20:50Z"
+"Stories": "1.0"
+"StreetDirPrefix": "South"
+"StreetName": "Gray"
+"StreetNumber": "36"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "5282.4"
+"VirtualTourURLUnbranded": "https://sites.tylerdavies.ca/mls/253458126"
+"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": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29954356/36-gray-road-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2105745"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "280315"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 60.0
+"OriginalEntryTimestamp": "2026-06-25T19:50:08.69Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1314350"
+"ListOfficeNationalAssociationId": "1312645"
+"CoListAgentNationalAssociationId": "1374995"
+"CoListOfficeNationalAssociationId": "1312645"
+"Media": array:47 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29954356')"
+"ID": "1564992"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25281
+post_id: "1565316"
+post_author: 1
+"ListingKey": "29954820"
+"ListingId": "40843027"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T21:20:05Z"
+"RFModificationTimestamp": "2026-06-25T23:40:55Z"
+"ListPrice": 615000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0.11
+"LivingArea": 1395.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8G1T3"
+"UnparsedAddress": "43 WYNGATE Avenue, Stoney Creek, Ontario L8G1T3"
+"Coordinates": array:2 [
0 => -79.7633295
1 => 43.2146224
]
+"Latitude": 43.2146224
+"Longitude": -79.7633295
+"YearBuilt": 1955
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Heart of Stoney Creek! Located in the desirable Battlefield neighbourhood, this character-filled home offers beautiful escarpment views and sits on a mature, tree-lined street just steps from parks, shopping, and the charming downtown core. The spacious main level features a home office, updated 2-piece bathroom, bright open-concept living and dining areas, and a large eat-in kitchen. Sliding doors lead to the generous backyard, providing plenty of space to relax, entertain, or create your dream outdoor retreat. Upstairs, you'll find two large bedrooms, a full bathroom, and original hardwood flooring full of timeless charm. The basement offers excellent in-law suite potential with a separate walk-up entrance and impressive ceiling height. While the home could benefit from some TLC and cosmetic updates, it presents an incredible opportunity for buyers looking to add value and make a home their own in a highly sought-after neighbourhood. Bring your vision and unlock the potential of this Stoney Creek gem! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T23:40:42.954878+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1925166"
+"ListOfficeKey": "300344"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"LotSizeDimensions": "0.11"
+"PhotosChangeTimestamp": "2026-06-25T21:10:55Z"
+"PhotosCount": 42
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T21:10:55Z"
+"Stories": "1.5"
+"StreetName": "WYNGATE"
+"StreetNumber": "43"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "515 - Battlefield"
+"TaxAnnualAmount": "4416.47"
+"VirtualTourURLUnbranded": "https://www.venturehomes.ca/virtualtour.asp?tourid=70348"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29954820/43-wyngate-avenue-stoney-creek"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 50.0
+"AboveGradeFinishedArea": 1395
+"OriginalEntryTimestamp": "2026-06-25T20:50:20.37Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1228914"
+"ListOfficeNationalAssociationId": "1486985"
+"Media": array:42 [
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]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29954820')"
+"ID": "1565316"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25282
+post_id: "1564258"
+post_author: 1
+"ListingKey": "29955073"
+"ListingId": "40843079"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T16:20:15Z"
+"RFModificationTimestamp": "2026-06-26T16:24:21Z"
+"ListPrice": 849900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1700.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L9A1A5"
+"UnparsedAddress": "22-A ALPINE Avenue, Stoney Creek, Ontario L9A1A5"
+"Coordinates": array:2 [
0 => -79.769129
1 => 43.22157
]
+"Latitude": 43.22157
+"Longitude": -79.769129
+"YearBuilt": 2026
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This brand new family home offers approximately 1,700 sq. ft. of thoughtfully designed living space and is linked only at the double-car garage, providing the feel of a detached home. Located in a desirable family-friendly neighbourhood, this property is close to parks, schools, shopping, restaurants, and everyday amenities, making it an ideal choice for families and commuters alike. The bright open-concept main floor showcases quality finishes throughout, including engineered hardwood flooring, large 12 x 24 porcelain tile, and elegant crown mouldings. The stunning modern kitchen is designed for both style and functionality, featuring quartz countertops, stainless steel appliances, and soft-close cabinetry and hinges. A convenient 2-piece powder room completes the main level, while the spacious layout is perfect for everyday living and entertaining. Upstairs, you'll find three generously sized bedrooms and two full bathrooms, including a private primary suite with its own ensuite bath. An additional 4-piece main bathroom serves the remaining bedrooms, while quality Berber carpeting adds warmth and durability throughout the upper level. The attractive exterior combines brick, stone, and siding, creating excellent curb appeal. The lower level presents outstanding future potential with a separate side entrance leading to a wide-open basement complete with egress windows and bathroom rough-ins, providing an excellent opportunity for a custom recreation area, in-law suite, or additional living space. Additional features include a double-car garage with a 100-amp electrical service, ideal for hobbyists, workshop space, or future EV charging needs. Move-in ready and upgraded throughout, this home offers the perfect blend of quality craftsmanship, comfort, and future possibilities. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T23:19:41.491200+00:00"
+"Directions": "West of Centennial Parkway, between King and Queenston"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1944032"
+"ListOfficeKey": "288925"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-25T21:31:42Z"
+"PhotosCount": 29
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-26T16:11:07Z"
+"Stories": "2.0"
+"StreetName": "ALPINE"
+"StreetNumber": "22"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "515 - Battlefield"
+"TaxAnnualAmount": "1"
+"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/29955073/22-a-alpine-avenue-stoney-creek"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1944031"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "288925"
+"GeocodeManualYN": true
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 32.0
+"AboveGradeFinishedArea": 1700
+"OriginalEntryTimestamp": "2026-06-25T21:31:41.98Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1239947"
+"ListOfficeNationalAssociationId": "1372539"
+"CoListAgentNationalAssociationId": "1239946"
+"CoListOfficeNationalAssociationId": "1372539"
+"Media": array:29 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29955073')"
+"ID": "1564258"
}
]
+success: true
+page_size: 9
+page_count: 22
+count: 197
+after_key: ""
}
"RF Response Time" => "0.21 seconds"
]
]