array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29895201 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23406
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23408
+post_id: "1526368"
+post_author: 1
+"ListingKey": "29895201"
+"ListingId": "40838563"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T18:50:05Z"
+"RFModificationTimestamp": "2026-06-17T18:52:37Z"
+"ListPrice": 549900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1064.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8J3Z4"
+"UnparsedAddress": "39 PINEWOODS Drive Unit# 35, Stoney Creek, Ontario L8J3Z4"
+"Coordinates": array:2 [
0 => -79.7748029
1 => 43.1802664
]
+"Latitude": 43.1802664
+"Longitude": -79.7748029
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Unit 35 at 39 Pinewoods Drive, a beautifully updated 3-bedroom, 1.5-bathroom townhome in a desirable Stoney Creek neighbourhood. This move-in-ready home features an updated kitchen with stainless steel appliances, stylish vinyl flooring, and pot lights throughout the main floor. The bright and functional layout offers open-concept living and dining spaces, while the upper level features three carpet-free bedrooms, including a large primary bedroom with a walk-in closet. An unfinished basement provides excellent storage and future potential. Enjoy peace of mind with a newer roof (2017), furnace (2026), washer and dryer (2026), and an attached garage with automatic garage door opener. Located close to schools, parks, shopping, restaurants, public transit, and community amenities. Commuters will appreciate easy access to the Red Hill Valley Parkway, LINC, QEW, and Highway 403. Whether you’re a first-time buyer, investor, or downsizer, this home offers exceptional value in a convenient, family-friendly location. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
7 => "Garage door opener"
]
+"AssociationFee": "195.92"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Insurance"
1 => "Parking"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T18:32:14.015373+00:00"
+"Directions": "HIGHBURY / HIGHLAND"
+"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": "2037792"
+"ListOfficeKey": "283457"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-12T18:11:54Z"
+"PhotosCount": 30
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T18:40:39Z"
+"Stories": "2.0"
+"StreetName": "PINEWOODS"
+"StreetNumber": "39"
+"StreetSuffix": "Drive"
+"SubdivisionName": "504 - Leckie Park/Highland"
+"TaxAnnualAmount": "3092.74"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1661368587"
"RoomType" => "4pc Bathroom"
"ListingId" => "40838563"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29895201"
"RoomLength" => null
"RoomDimensions" => "6'11'' x 8'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T18:40:39.83Z"
]
1 => array:11 [
"RoomKey" => "1661368588"
"RoomType" => "Bedroom"
"ListingId" => "40838563"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29895201"
"RoomLength" => null
"RoomDimensions" => "11'6'' x 8'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T18:40:39.83Z"
]
2 => array:11 [
"RoomKey" => "1661368589"
"RoomType" => "Bedroom"
"ListingId" => "40838563"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29895201"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 9'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T18:40:39.84Z"
]
3 => array:11 [
"RoomKey" => "1661368590"
"RoomType" => "Primary Bedroom"
"ListingId" => "40838563"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29895201"
"RoomLength" => null
"RoomDimensions" => "13'7'' x 15'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T18:40:39.84Z"
]
4 => array:11 [
"RoomKey" => "1661368591"
"RoomType" => "2pc Bathroom"
"ListingId" => "40838563"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29895201"
"RoomLength" => null
"RoomDimensions" => "7'6'' x 2'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T18:40:39.84Z"
]
5 => array:11 [
"RoomKey" => "1661368592"
"RoomType" => "Kitchen"
"ListingId" => "40838563"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29895201"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 9'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T18:40:39.84Z"
]
6 => array:11 [
"RoomKey" => "1661368593"
"RoomType" => "Living room"
"ListingId" => "40838563"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29895201"
"RoomLength" => null
"RoomDimensions" => "12'7'' x 9'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T18:40:39.84Z"
]
7 => array:11 [
"RoomKey" => "1661368594"
"RoomType" => "Foyer"
"ListingId" => "40838563"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29895201"
"RoomLength" => null
"RoomDimensions" => "20' x 4'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T18:40:39.84Z"
]
8 => array:11 [
"RoomKey" => "1661368595"
"RoomType" => "Other"
"ListingId" => "40838563"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29895201"
"RoomLength" => null
"RoomDimensions" => "32'7'' x 18'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T18:40:39.84Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29895201/39-pinewoods-drive-unit-35-stoney-creek"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "RM3"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 19.0
+"AboveGradeFinishedArea": 1064
+"OriginalEntryTimestamp": "2026-06-12T15:31:47.11Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1314146"
+"ListOfficeNationalAssociationId": "1330157"
+"Media": array:30 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29895201_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895201/8643f43f46231d95f05f13ded9276f02.webp"
"MediaSize" => 156645
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895201/thumbnail-8643f43f46231d95f05f13ded9276f02.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick facade townhouse with two white garage doors, a covered entry, and a mature tree with surrounding landscaping"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40838563"
"ResourceRecordKey" => "29895201"
"ModificationTimestamp" => "2026-06-12T18:11:52.72Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29895201_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895201/e72f3a8645859937e47b406669a9b3f8.webp"
"MediaSize" => 163749
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895201/thumbnail-e72f3a8645859937e47b406669a9b3f8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick facade townhome featuring a shingle roof, integrated garage, and a covered entry"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838563"
"ResourceRecordKey" => "29895201"
"ModificationTimestamp" => "2026-06-12T18:11:50.92Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29895201_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895201/336eaf393918d361ac2c085c65e549a7.webp"
"MediaSize" => 170483
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895201/thumbnail-336eaf393918d361ac2c085c65e549a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive aerial perspective showcasing a residential area with diverse housing types"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838563"
"ResourceRecordKey" => "29895201"
"ModificationTimestamp" => "2026-06-12T18:11:52.65Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29895201_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895201/61849011dc18773f291e78b718b9df5b.webp"
"MediaSize" => 56049
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895201/thumbnail-61849011dc18773f291e78b718b9df5b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entryway featuring a white door with a decorative leaded glass insert and a digital keypad lock"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838563"
"ResourceRecordKey" => "29895201"
"ModificationTimestamp" => "2026-06-12T18:11:52.65Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29895201_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895201/6cb11d14c0ebbb1489aeddb52adcbf5d.webp"
"MediaSize" => 58814
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895201/thumbnail-6cb11d14c0ebbb1489aeddb52adcbf5d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838563"
"ResourceRecordKey" => "29895201"
"ModificationTimestamp" => "2026-06-12T18:11:50.94Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29895201_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895201/1b364d11d6a78da77fac72e06c77fb77.webp"
"MediaSize" => 47730
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895201/thumbnail-1b364d11d6a78da77fac72e06c77fb77.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom vanity featuring a white cabinet base, undermount sink, and a stone countertop"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838563"
"ResourceRecordKey" => "29895201"
"ModificationTimestamp" => "2026-06-12T18:11:50.92Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29895201_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895201/5a69222aada75e8dd2e859fe69ed858f.webp"
"MediaSize" => 61874
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895201/thumbnail-5a69222aada75e8dd2e859fe69ed858f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Inviting entryway featuring neutral-toned tile flooring, a carpeted staircase with white balusters, and a recessed window in the background"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838563"
"ResourceRecordKey" => "29895201"
"ModificationTimestamp" => "2026-06-12T18:11:50.94Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29895201_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895201/994d42d41c540c988cfc58eb06e41edf.webp"
"MediaSize" => 84366
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895201/thumbnail-994d42d41c540c988cfc58eb06e41edf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area with recessed lighting, light gray wall paint, and a window featuring blinds"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838563"
"ResourceRecordKey" => "29895201"
"ModificationTimestamp" => "2026-06-12T18:11:53.28Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29895201_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895201/6d5bb4de1b21ae36ea692d786ae5f3db.webp"
"MediaSize" => 86498
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895201/thumbnail-6d5bb4de1b21ae36ea692d786ae5f3db.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area featuring neutral wall tones, recessed lighting, a corner-mounted fireplace, wood-finish flooring, and a large window with blinds"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838563"
"ResourceRecordKey" => "29895201"
"ModificationTimestamp" => "2026-06-12T18:11:52.63Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29895201_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895201/52074cc7a0b51eb5f06bd14f61624e25.webp"
"MediaSize" => 74111
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895201/thumbnail-52074cc7a0b51eb5f06bd14f61624e25.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area featuring light gray walls, recessed lighting, and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838563"
"ResourceRecordKey" => "29895201"
"ModificationTimestamp" => "2026-06-12T18:11:52.82Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29895201_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895201/bb696a27b06e4e40ff7162ab7384ef0a.webp"
"MediaSize" => 73408
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895201/thumbnail-bb696a27b06e4e40ff7162ab7384ef0a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Contemporary kitchen and dining area featuring white cabinetry, stainless steel appliances, and a gray subway tile backsplash"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838563"
"ResourceRecordKey" => "29895201"
"ModificationTimestamp" => "2026-06-12T18:11:50.94Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29895201_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895201/b12174f1feb8fa2ca2ec4d47abbe10f7.webp"
"MediaSize" => 80955
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895201/thumbnail-b12174f1feb8fa2ca2ec4d47abbe10f7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring white cabinetry, stainless steel appliances, a tile backsplash, recessed lighting, and tile flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838563"
"ResourceRecordKey" => "29895201"
"ModificationTimestamp" => "2026-06-12T18:11:53.28Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29895201_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895201/9192f2bbd6ec2f8d66261c57051aaee2.webp"
"MediaSize" => 84863
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895201/thumbnail-9192f2bbd6ec2f8d66261c57051aaee2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring white cabinetry, stainless steel appliances, a tiled backsplash, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838563"
"ResourceRecordKey" => "29895201"
"ModificationTimestamp" => "2026-06-12T18:11:50.92Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29895201_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895201/4cfac02077f13fdd19dcebc77c01863a.webp"
"MediaSize" => 79488
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895201/thumbnail-4cfac02077f13fdd19dcebc77c01863a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838563"
"ResourceRecordKey" => "29895201"
"ModificationTimestamp" => "2026-06-12T18:11:52.65Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29895201_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895201/fcab25efeb40d209d9ddc22331cf8aef.webp"
"MediaSize" => 47855
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895201/thumbnail-fcab25efeb40d209d9ddc22331cf8aef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Stairs"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838563"
"ResourceRecordKey" => "29895201"
"ModificationTimestamp" => "2026-06-12T18:11:54.43Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29895201_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895201/6f6ddd6c75f04adee35ed58d9e896e61.webp"
"MediaSize" => 75235
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895201/thumbnail-6f6ddd6c75f04adee35ed58d9e896e61.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838563"
"ResourceRecordKey" => "29895201"
"ModificationTimestamp" => "2026-06-12T18:11:52.75Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29895201_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895201/3795451bf9cd99a2446baca9bcd8f37d.webp"
"MediaSize" => 64862
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895201/thumbnail-3795451bf9cd99a2446baca9bcd8f37d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious room with wood-finish flooring, a contemporary chandelier, two built-in nightstands with dark hardware, and neutral wall tones"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838563"
"ResourceRecordKey" => "29895201"
"ModificationTimestamp" => "2026-06-12T18:11:52.72Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29895201_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895201/4d1971634ccab4ed3e2a396a58321d3f.webp"
"MediaSize" => 84400
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895201/thumbnail-4d1971634ccab4ed3e2a396a58321d3f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring wood-finish flooring, a white built-in fireplace, a ceiling-mounted light fixture, and a window with blinds"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838563"
"ResourceRecordKey" => "29895201"
"ModificationTimestamp" => "2026-06-12T18:11:50.92Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29895201_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895201/ef8df95a1ab4e1fdff232acf2a9f1b69.webp"
"MediaSize" => 64007
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895201/thumbnail-ef8df95a1ab4e1fdff232acf2a9f1b69.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring wood-finish flooring, neutral wall tones, a ceiling-mounted light fixture, and a window with white trim"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838563"
"ResourceRecordKey" => "29895201"
"ModificationTimestamp" => "2026-06-12T18:11:52.62Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29895201_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895201/8aa0c5f9b131dd42309e2f40366b1e6d.webp"
"MediaSize" => 52493
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895201/thumbnail-8aa0c5f9b131dd42309e2f40366b1e6d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom with wood-finish flooring, light grey painted walls, and a white six-panel door"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838563"
"ResourceRecordKey" => "29895201"
"ModificationTimestamp" => "2026-06-12T18:11:51.59Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29895201_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895201/aa85dc22f4d0582a6569fe357970f23a.webp"
"MediaSize" => 62596
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895201/thumbnail-aa85dc22f4d0582a6569fe357970f23a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Hardwood-finish flooring enhancing a room with a window featuring sheer patterned curtains"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838563"
"ResourceRecordKey" => "29895201"
"ModificationTimestamp" => "2026-06-12T18:11:50.94Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29895201_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895201/5ec1278b17bbe78fde7cf114a93ec386.webp"
"MediaSize" => 58677
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895201/thumbnail-5ec1278b17bbe78fde7cf114a93ec386.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Interior room featuring wood-finish flooring, light grey wall paint, and white trim"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838563"
"ResourceRecordKey" => "29895201"
"ModificationTimestamp" => "2026-06-12T18:11:52.84Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29895201_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895201/158ad986d2498446cb4d9e333b3563b6.webp"
"MediaSize" => 56679
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895201/thumbnail-158ad986d2498446cb4d9e333b3563b6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a white vanity with a light-toned countertop, a framed mirror, and contemporary sconce lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838563"
"ResourceRecordKey" => "29895201"
"ModificationTimestamp" => "2026-06-12T18:11:50.94Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29895201_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895201/07f6ed4055c306b246fca93c8046630c.webp"
"MediaSize" => 48320
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895201/thumbnail-07f6ed4055c306b246fca93c8046630c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "White vanity with an integrated sink and brushed nickel hardware"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838563"
"ResourceRecordKey" => "29895201"
"ModificationTimestamp" => "2026-06-12T18:11:50.92Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29895201_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895201/4c7048fe612bef3a99b54b6f2afc814b.webp"
"MediaSize" => 136794
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895201/thumbnail-4c7048fe612bef3a99b54b6f2afc814b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Deck"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838563"
"ResourceRecordKey" => "29895201"
"ModificationTimestamp" => "2026-06-12T18:11:50.92Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29895201_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895201/3c801bdc5e4aab387b08bc46802b9cf3.webp"
"MediaSize" => 163167
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895201/thumbnail-3c801bdc5e4aab387b08bc46802b9cf3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Private backyard space featuring a wood fence enclosure, a grassy lawn, and an exterior deck"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838563"
"ResourceRecordKey" => "29895201"
"ModificationTimestamp" => "2026-06-12T18:11:52.6Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29895201_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895201/c2f0f2e73fbf341e8cd7be10125884df.webp"
"MediaSize" => 173168
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895201/thumbnail-c2f0f2e73fbf341e8cd7be10125884df.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Rear exterior with private fenced yard, featuring a raised wood deck, a covered patio area, and mature perimeter trees"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838563"
"ResourceRecordKey" => "29895201"
"ModificationTimestamp" => "2026-06-12T18:11:52.65Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29895201_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895201/aab84f1ca2bf85c504982b7db2c95393.webp"
"MediaSize" => 160313
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895201/thumbnail-aab84f1ca2bf85c504982b7db2c95393.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Private fenced yard featuring a wood deck, a covered patio area, and a grass lawn"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838563"
"ResourceRecordKey" => "29895201"
"ModificationTimestamp" => "2026-06-12T18:11:53.22Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29895201_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895201/643c4ec371125fb7923873ac3e054ecc.webp"
"MediaSize" => 167207
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895201/thumbnail-643c4ec371125fb7923873ac3e054ecc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Aerial view"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838563"
"ResourceRecordKey" => "29895201"
"ModificationTimestamp" => "2026-06-12T18:11:52.65Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29895201_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895201/04a4c914f280a9b6ec2bfe9f5c6e19b3.webp"
"MediaSize" => 151734
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895201/thumbnail-04a4c914f280a9b6ec2bfe9f5c6e19b3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Aerial perspective showcasing multiple townhouse-style residential buildings with brown and gray shingle roofs"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838563"
"ResourceRecordKey" => "29895201"
"ModificationTimestamp" => "2026-06-12T18:11:53.24Z"
]
]
+"DaysOnMarket": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29895201')"
+"ID": "1526368"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 283457" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24886
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.23 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2037792" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24859
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29895201'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25188
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29895201'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25205
+items: array:4 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25204
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31445325"
+"ListingKey": "29895201"
+"ListingId": "40838563"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-14"
+"OpenHouseStartTime": "2026-06-15T02:00:00Z"
+"OpenHouseEndTime": "2026-06-15T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-12T18:00:30Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31445325')"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25206
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31448544"
+"ListingKey": "29895201"
+"ListingId": "40838563"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-14"
+"OpenHouseStartTime": "2026-06-14T14:00:00Z"
+"OpenHouseEndTime": "2026-06-14T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-14T20:01:00Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31448544')"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25203
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31518136"
+"ListingKey": "29895201"
+"ListingId": "40838563"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-21"
+"OpenHouseStartTime": "2026-06-21T14:00:00Z"
+"OpenHouseEndTime": "2026-06-21T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-20T00:01:57Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31518136')"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25207
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31518137"
+"ListingKey": "29895201"
+"ListingId": "40838563"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-20"
+"OpenHouseStartTime": "2026-06-20T14:00:00Z"
+"OpenHouseEndTime": "2026-06-20T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-20T00:01:57Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31518137')"
}
]
+success: true
+page_size: 4
+page_count: 1
+count: 4
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29895201' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.7748029 43.1802664)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25265
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25259
+post_id: "1549746"
+post_author: 1
+"ListingKey": "29931294"
+"ListingId": "X13469260"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T22:25:34Z"
+"RFModificationTimestamp": "2026-06-19T22:28:58Z"
+"ListPrice": 589999.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek Mountain)"
+"PostalCode": "L8J0M7"
+"UnparsedAddress": "4 - 19 PICARDY DRIVE, Hamilton (Stoney Creek Mountain), Ontario L8J0M7"
+"Coordinates": array:2 [
0 => -79.776303
1 => 43.182992
]
+"Latitude": 43.182992
+"Longitude": -79.776303
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this beautifully built 3-level townhouse offering modern living in an unbeatable location. Featuring a spacious and functional layout, this home boasts bright open-concept living spaces, stylish finishes, generous-sized bedrooms, and the added convenience of a private garage for parking and extra storage. Perfect for families, professionals, or investors, this property is situated in a fantastic area close to shopping, restaurants, schools, parks, transit, and major highways - truly close to everything you need. Move-in ready and thoughtfully designed, this is a wonderful opportunity to own a stylish home in a highly desirable community! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Water Heater - Tankless"
]
+"AssociationFee": "109.29"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Parcel of Tied Land"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T22:28:55.290329+00:00"
+"Directions": "Cross Streets: Highland and Picardy. ** Directions: Upper Centennial Pkwy to Highland Rd W to Picardy."
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Facing"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2188730"
+"ListOfficeKey": "284792"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "18.3 x 61.3 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-19T21:30:43Z"
+"PhotosCount": 42
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T21:52:49Z"
+"Stories": "3.0"
+"StreetName": "PICARDY"
+"StreetNumber": "19"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "3423"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1663330028"
"RoomType" => "Foyer"
"ListingId" => "X13469260"
"RoomLevel" => "Lower level"
"RoomWidth" => 0.0
"ListingKey" => "29931294"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T21:52:49.38Z"
]
1 => array:11 [
"RoomKey" => "1663330029"
"RoomType" => "Utility room"
"ListingId" => "X13469260"
"RoomLevel" => "Basement"
"RoomWidth" => 2.57
"ListingKey" => "29931294"
"RoomLength" => 0.99
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T21:52:49.39Z"
]
2 => array:11 [
"RoomKey" => "1663330030"
"RoomType" => "Living room"
"ListingId" => "X13469260"
"RoomLevel" => "Main level"
"RoomWidth" => 5.44
"ListingKey" => "29931294"
"RoomLength" => 5.28
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T21:52:49.39Z"
]
3 => array:11 [
"RoomKey" => "1663330031"
"RoomType" => "Dining room"
"ListingId" => "X13469260"
"RoomLevel" => "Main level"
"RoomWidth" => 2.67
"ListingKey" => "29931294"
"RoomLength" => 2.46
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T21:52:49.4Z"
]
4 => array:11 [
"RoomKey" => "1663330032"
"RoomType" => "Kitchen"
"ListingId" => "X13469260"
"RoomLevel" => "Main level"
"RoomWidth" => 2.67
"ListingKey" => "29931294"
"RoomLength" => 2.82
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T21:52:49.4Z"
]
5 => array:11 [
"RoomKey" => "1663330033"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13469260"
"RoomLevel" => "Second level"
"RoomWidth" => 3.63
"ListingKey" => "29931294"
"RoomLength" => 3.1
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T21:52:49.4Z"
]
6 => array:11 [
"RoomKey" => "1663330034"
"RoomType" => "Bathroom"
"ListingId" => "X13469260"
"RoomLevel" => "Second level"
"RoomWidth" => 0.0
"ListingKey" => "29931294"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T21:52:49.41Z"
]
7 => array:11 [
"RoomKey" => "1663330035"
"RoomType" => "Bedroom"
"ListingId" => "X13469260"
"RoomLevel" => "Second level"
"RoomWidth" => 2.57
"ListingKey" => "29931294"
"RoomLength" => 3.15
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T21:52:49.41Z"
]
8 => array:11 [
"RoomKey" => "1663330036"
"RoomType" => "Bathroom"
"ListingId" => "X13469260"
"RoomLevel" => "Second level"
"RoomWidth" => 0.0
"ListingKey" => "29931294"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T21:52:49.42Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Stoney Creek Mountain"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29931294/4-19-picardy-drive-hamilton-stoney-creek-mountain-stoney-creek-mountain"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 2
+"FrontageLengthNumeric": 18.3
+"OriginalEntryTimestamp": "2026-06-19T21:30:43.02Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1437783"
+"ListOfficeNationalAssociationId": "1344891"
+"Media": array:42 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29931294_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931294/e00c555b3d227fe5e2819154e638ef92.webp"
"MediaSize" => 322443
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931294/thumbnail-e00c555b3d227fe5e2819154e638ef92.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13469260"
"ResourceRecordKey" => "29931294"
"ModificationTimestamp" => "2026-06-19T21:30:43.03Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29931294_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931294/a87455e010a7850245b26e9c16a18136.webp"
"MediaSize" => 341144
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931294/thumbnail-a87455e010a7850245b26e9c16a18136.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13469260"
"ResourceRecordKey" => "29931294"
"ModificationTimestamp" => "2026-06-19T21:30:43.03Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29931294_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931294/2ac08d951fa1bc04593bb0870ca4238f.webp"
"MediaSize" => 321827
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931294/thumbnail-2ac08d951fa1bc04593bb0870ca4238f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13469260"
"ResourceRecordKey" => "29931294"
"ModificationTimestamp" => "2026-06-19T21:30:43.03Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29931294_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931294/673a8f05b77764b0f7a6ffc595b0a1a8.webp"
"MediaSize" => 291604
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931294/thumbnail-673a8f05b77764b0f7a6ffc595b0a1a8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13469260"
"ResourceRecordKey" => "29931294"
"ModificationTimestamp" => "2026-06-19T21:30:43.03Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29931294_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931294/21205b4285924dd16b60b01969f180a9.webp"
"MediaSize" => 128060
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931294/thumbnail-21205b4285924dd16b60b01969f180a9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13469260"
"ResourceRecordKey" => "29931294"
"ModificationTimestamp" => "2026-06-19T21:30:43.03Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29931294_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931294/c1cedd4492528f9b939c994875881a01.webp"
"MediaSize" => 157033
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931294/thumbnail-c1cedd4492528f9b939c994875881a01.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13469260"
"ResourceRecordKey" => "29931294"
"ModificationTimestamp" => "2026-06-19T21:30:43.03Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29931294_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931294/8b768accb8fedb063cb73e7ab33a7a58.webp"
"MediaSize" => 95027
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931294/thumbnail-8b768accb8fedb063cb73e7ab33a7a58.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13469260"
"ResourceRecordKey" => "29931294"
"ModificationTimestamp" => "2026-06-19T21:30:43.03Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29931294_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931294/7eb28f25534dbc6e8a455905a42eb258.webp"
"MediaSize" => 171611
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931294/thumbnail-7eb28f25534dbc6e8a455905a42eb258.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13469260"
"ResourceRecordKey" => "29931294"
"ModificationTimestamp" => "2026-06-19T21:30:43.03Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29931294_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931294/95912af6ed27ac95f11b7c4d10cd9108.webp"
"MediaSize" => 183061
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931294/thumbnail-95912af6ed27ac95f11b7c4d10cd9108.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13469260"
"ResourceRecordKey" => "29931294"
"ModificationTimestamp" => "2026-06-19T21:30:43.03Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29931294_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931294/7beb4a05a5f472914d5e099efe15d3eb.webp"
"MediaSize" => 165573
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931294/thumbnail-7beb4a05a5f472914d5e099efe15d3eb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13469260"
"ResourceRecordKey" => "29931294"
"ModificationTimestamp" => "2026-06-19T21:30:43.03Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29931294_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931294/bfe1e3332c51a5ccd54c4b3726133451.webp"
"MediaSize" => 175051
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931294/thumbnail-bfe1e3332c51a5ccd54c4b3726133451.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13469260"
"ResourceRecordKey" => "29931294"
"ModificationTimestamp" => "2026-06-19T21:30:43.03Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29931294_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931294/3336e256e1a973fe052e41e338d73845.webp"
"MediaSize" => 168818
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931294/thumbnail-3336e256e1a973fe052e41e338d73845.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13469260"
"ResourceRecordKey" => "29931294"
"ModificationTimestamp" => "2026-06-19T21:30:43.03Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29931294_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931294/7a2853d876e47f6cf11b3348c60e9c20.webp"
"MediaSize" => 164683
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931294/thumbnail-7a2853d876e47f6cf11b3348c60e9c20.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13469260"
"ResourceRecordKey" => "29931294"
"ModificationTimestamp" => "2026-06-19T21:30:43.03Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29931294_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931294/b813f17f6cbea68d8875004a587184e3.webp"
"MediaSize" => 165752
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931294/thumbnail-b813f17f6cbea68d8875004a587184e3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13469260"
"ResourceRecordKey" => "29931294"
"ModificationTimestamp" => "2026-06-19T21:30:43.03Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29931294_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931294/e09df4fe301c598537b4339ca712be0d.webp"
"MediaSize" => 179783
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931294/thumbnail-e09df4fe301c598537b4339ca712be0d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13469260"
"ResourceRecordKey" => "29931294"
"ModificationTimestamp" => "2026-06-19T21:30:43.03Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29931294_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931294/1f37343e8cfe1677fcee46499dfeb653.webp"
"MediaSize" => 182334
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931294/thumbnail-1f37343e8cfe1677fcee46499dfeb653.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13469260"
"ResourceRecordKey" => "29931294"
"ModificationTimestamp" => "2026-06-19T21:30:43.03Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29931294_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931294/9c7d5c3074cd2142d44174100b7edc98.webp"
"MediaSize" => 249108
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931294/thumbnail-9c7d5c3074cd2142d44174100b7edc98.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13469260"
"ResourceRecordKey" => "29931294"
"ModificationTimestamp" => "2026-06-19T21:30:43.03Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29931294_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931294/76926abc55dff8de6c331e03ee9c43c2.webp"
"MediaSize" => 170227
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931294/thumbnail-76926abc55dff8de6c331e03ee9c43c2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13469260"
"ResourceRecordKey" => "29931294"
"ModificationTimestamp" => "2026-06-19T21:30:43.03Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29931294_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931294/a81904eea02a4f0da753065c57ef6fa1.webp"
"MediaSize" => 168535
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931294/thumbnail-a81904eea02a4f0da753065c57ef6fa1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13469260"
"ResourceRecordKey" => "29931294"
…1
]
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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29931294')"
+"ID": "1549746"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25261
+post_id: "1549448"
+post_author: 1
+"ListingKey": "29930701"
+"ListingId": "40841580"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T20:30:01Z"
+"RFModificationTimestamp": "2026-06-19T21:04:37Z"
+"ListPrice": 589999.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1380.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8J0M7"
+"UnparsedAddress": "19 PICARDY Drive Unit# 4, Hamilton, Ontario L8J0M7"
+"Coordinates": array:2 [
0 => -79.7765846
1 => 43.1843905
]
+"Latitude": 43.1843905
+"Longitude": -79.7765846
+"YearBuilt": 2023
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully built 3-level townhouse offering modern living in an unbeatable location. Featuring a spacious and functional layout, this home boasts bright open-concept living spaces, stylish finishes, generous-sized bedrooms, and the added convenience of a private garage for parking and extra storage. Perfect for families, professionals, or investors, this property is situated in a fantastic area close to shopping, restaurants, schools, parks, transit, and major highways — truly close to everything you need. Move-in ready and thoughtfully designed, this is a wonderful opportunity to own a stylish home in a highly desirable community! (id:62783)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T21:04:30.708502+00:00"
+"Directions": "UPPER CENTENNIAL PKWY TO HIGHLAND RD W TO PICARDY"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2201906"
+"ListOfficeKey": "284635"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-19T20:11:28Z"
+"PhotosCount": 42
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T20:11:28Z"
+"Stories": "3.0"
+"StreetName": "PICARDY"
+"StreetNumber": "19"
+"StreetSuffix": "Drive"
+"SubdivisionName": "502 - Felker"
+"TaxAnnualAmount": "3423"
+"Utilities": array:1 [
0 => "Telephone"
]
+"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/29930701/19-picardy-drive-unit-4-hamilton"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "RM3-64"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 18.0
+"AboveGradeFinishedArea": 1380
+"OriginalEntryTimestamp": "2026-06-19T20:11:28.58Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1450381"
+"ListOfficeNationalAssociationId": "1344652"
+"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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29930701')"
+"ID": "1549448"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25258
+post_id: "1548755"
+post_author: 1
+"ListingKey": "29929497"
+"ListingId": "40840776"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T18:10:06Z"
+"RFModificationTimestamp": "2026-06-19T20:15:40Z"
+"ListPrice": 969900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 3088.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8J2T2"
+"UnparsedAddress": "111 AUBREY Avenue, Stoney Creek, Ontario L8J2T2"
+"Coordinates": array:2 [
0 => -79.7795153
1 => 43.1822947
]
+"Latitude": 43.1822947
+"Longitude": -79.7795153
+"YearBuilt": 1990
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Located on the prestigious Stoney Creek Mountain in one of the area's most exclusive neighbourhoods, this exceptional property is surrounded by luxury custom homes and stunning tear-down rebuilds. Offering incredible versatility and space, the main level features an updated kitchen and a functional layout with three spacious bedrooms upstairs. Step outside to a beautifully upgraded backyard complete with stamped concrete, creating the perfect setting for entertaining or relaxing. The fully finished lower level offers an ideal in-law suite with a separate entrance, featuring its own full kitchen, living room, and two bedrooms—perfect for multigenerational living, extended family, or additional flexibility. Complete with a two-car garage and parking for two additional vehicles in the private driveway, this is a rare opportunity to own in one of Stoney Creek Mountain's most sought-after communities. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T20:15:34.595236+00:00"
+"Directions": "Upper Cenntenial to Highland Rd to Aubrey Ave"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1623259"
+"ListOfficeKey": "275165"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-19T17:52:36Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T17:52:36Z"
+"Stories": "2.0"
+"StreetName": "AUBREY"
+"StreetNumber": "111"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "504 - Leckie Park/Highland"
+"TaxAnnualAmount": "6172.12"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:20 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
18 => array:11 [ …11]
19 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29929497/111-aubrey-avenue-stoney-creek"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 50.0
+"AboveGradeFinishedArea": 1983
+"BelowGradeFinishedArea": 1105
+"OriginalEntryTimestamp": "2026-06-19T17:52:36.27Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1161082"
+"ListOfficeNationalAssociationId": "1262401"
+"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('29929497')"
+"ID": "1548755"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25262
+post_id: "1532434"
+post_author: 1
+"ListingKey": "29905671"
+"ListingId": "X13446794"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T19:05:11Z"
+"RFModificationTimestamp": "2026-06-15T22:05:40Z"
+"ListPrice": 599900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L0R1P0"
+"UnparsedAddress": "53 AQUARIUS CRESCENT, Hamilton, Ontario L0R1P0"
+"Coordinates": array:2 [
0 => -79.7861225
1 => 43.1732547
]
+"Latitude": 43.1732547
+"Longitude": -79.7861225
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "The Oakville, Milton & District Real Estate Board"
+"PublicRemarks": "Welcome to this beautifully styled 3-bedroom townhome tucked away in a quiet, family-friendly community on sought-after Stoney Creek mountain. Freshly painted and filled with natural light, this move-in-ready home offers the perfect blend of style, function, and everyday comfort. The main floor features 9-foot ceilings, modern pot lights, and a thoughtfully designed kitchen with custom cabinetry, a breakfast bar, and plenty of prep space for busy mornings or entertaining friends and family. At the front of the home, a dedicated dining room provides the perfect setting for hosting holiday dinners or gathering with family and friends. From the kitchen, the spacious living area flows effortlessly to sliding doors leading to an elevated and private, southeast-facing deck - an ideal spot to enjoy your morning coffee or unwind at the end of the day. Upstairs, the generous primary suite offers double closets and a private ensuite, while two additional bedrooms provide flexible space for kids, guests, or a home office. The bright walkout lower level adds even more versatility with direct backyard access and endless possibilities for a rec room, fourth bedroom, or home gym. Just steps from the neighbourhood park and close to schools, shopping, restaurants, and every convenience, this home offers an exceptional lifestyle in one of Stoney Creek's most desirable locations. Whether you're a first-time buyer, downsizer, or investor, this is an opportunity you won't want to miss. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T22:05:30.694564+00:00"
+"Directions": "Cross Streets: Rymal Rd & Terryberry Rd. ** Directions: From Rymal Rd, turn onto Terryberry Rd., left on Dalgleish Trail, left on Canary Grass Blvd., left on Aquarius Cres."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1952102"
+"ListOfficeKey": "285151"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "15 x 86.2 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T18:56:14Z"
+"PhotosCount": 32
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T18:56:13Z"
+"Stories": "3.0"
+"StreetName": "Aquarius"
+"StreetNumber": "53"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "4026.64"
+"VirtualTourURLUnbranded": "https://youriguide.com/53_aquarius_cres_hamilton_on/https://youriguide.com/53_aquarius_cres_hamilton_on/"
+"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": "Oakville-Milton"
+"CityRegion": "Rural Glanbrook"
+"ListAORKey": "15"
+"ListingURL": "www.realtor.ca/real-estate/29905671/53-aquarius-crescent-hamilton-rural-glanbrook"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2050273"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "285151"
+"GeocodeManualYN": true
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 15.0
+"OriginalEntryTimestamp": "2026-06-15T18:56:13.69Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1245775"
+"ListOfficeNationalAssociationId": "1347969"
+"CoListAgentNationalAssociationId": "1325722"
+"CoListOfficeNationalAssociationId": "1347969"
+"Media": array:32 [
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]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29905671')"
+"ID": "1532434"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25260
+post_id: "1532435"
+post_author: 1
+"ListingKey": "29905461"
+"ListingId": "X13446472"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T19:05:04Z"
+"RFModificationTimestamp": "2026-06-16T19:09:10Z"
+"ListPrice": 1049900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek Mountain)"
+"PostalCode": "L8J0J7"
+"UnparsedAddress": "17 NARBONNE CRESCENT, Hamilton (Stoney Creek Mountain), Ontario L8J0J7"
+"Coordinates": array:2 [
0 => -79.77968
1 => 43.186331
]
+"Latitude": 43.186331
+"Longitude": -79.77968
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 17 Narbonne Crescent in desirable Stoney Creek! Situated on a premium oversized corner lot, this beautifully maintained home offers exceptional space, comfort, and potential for growing families. Inside, you'll find four generously sized bedrooms and an abundance of natural light that fills the home through large windows, creating a bright and inviting atmosphere throughout. Thoughtfully updated with numerous upgrades, this home blends functionality with modern appeal. The spacious layout provides plenty of room for everyday living and entertaining, while the unfinished basement offers a blank canvas to create additional living space, a home gym, recreation room, or in-law suite tailored to your needs. Step outside to enjoy the covered rear patio-perfect for relaxing, hosting guests, or extending your outdoor living season. The expansive corner lot provides excellent curb appeal, additional yard space, and added privacy. Located in a family-friendly neighbourhood close to parks, schools, shopping, and major commuter routes, this is a fantastic opportunity to own a move-in-ready home in one of Stoney Creek's most sought-after communities. Don't miss your chance to make this bright, spacious, and upgraded property your next home! (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Furniture"
7 => "Window Coverings"
8 => "Garage door opener remote(s)"
9 => "Water Heater - Tankless"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:2 [
0 => "Central air conditioning"
1 => "Air exchanger"
]
+"CreationDate": "2026-06-15T19:32:45.673191+00:00"
+"Directions": "Cross Streets: Narbonne Cres & Chaumont Dr. ** Directions: From First Rd W, Turn Onto Lormont Blvd, Right Onto Chaumont Dr, Left Onto Narbonne Cres, Property On Right."
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2027760"
+"ListOfficeKey": "299902"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "46.5 x 110.1 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T18:37:21Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T18:58:44Z"
+"Stories": "2.0"
+"StreetName": "Narbonne"
+"StreetNumber": "17"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "6246.48"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=NVdN9tD5o5b"
+"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": "Toronto"
+"CityRegion": "Stoney Creek Mountain"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29905461/17-narbonne-crescent-hamilton-stoney-creek-mountain-stoney-creek-mountain"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 46.6
+"OriginalEntryTimestamp": "2026-06-15T18:37:20.59Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1307105"
+"ListOfficeNationalAssociationId": "1478673"
+"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": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29905461')"
+"ID": "1532435"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25255
+post_id: "1532436"
+post_author: 1
+"ListingKey": "29905460"
+"ListingId": "X13446466"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T19:05:11Z"
+"RFModificationTimestamp": "2026-06-15T19:34:17Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek Mountain)"
+"PostalCode": "L8J0E8"
+"UnparsedAddress": "12 - 70 HIGHGATE DRIVE, Hamilton (Stoney Creek Mountain), Ontario L8J0E8"
+"Coordinates": array:2 [
0 => -79.7793009
1 => 43.1780002
]
+"Latitude": 43.1780002
+"Longitude": -79.7793009
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Stunning move-in ready freehold townhouse in desirable Stoney Creek featuring a spacious three-bedroom layout plus an upper-level loft perfect for home office. The home is highlighted by beautiful finishes throughout, including hardwood flooring throughout, a floating oak staircase, and a bright, open-concept main floor. The gourmet white kitchen is equipped with stainless steel appliances, granite countertops, a stylish tile backsplash with under cabinet lighting, and a breakfast bar. The living area flows seamlessly to a fully fenced backyard, perfect for outdoor relaxation. The large bright primary suite serves as a true retreat with a walk-in closet and a renovated three-piece ensuite. The finished basement adds significant value with hardwood floors, a beautiful electric fireplace set against a decorative stone wall, an oversized window, and a dedicated laundry area. Additional features include an interior garage entry, ample storage, and a convenient $95/month POTL fee. Please note that the Listing Agent is related to the seller. (id:62783)"
+"Appliances": array:5 [
0 => "Refrigerator"
1 => "Stove"
2 => "Blinds"
3 => "Window Coverings"
4 => "Garage door opener remote(s)"
]
+"AssociationFee": "95"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Parcel of Tied Land"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T19:32:33.922978+00:00"
+"Directions": "Cross Streets: Upper Pkwy & Highgate Dr. ** Directions: Upper Pkwy to Highgate Drive."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:2 [
0 => "Hardwood"
1 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2094277"
+"ListOfficeKey": "293485"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Level lot"
1 => "Level"
2 => "Carpet Free"
]
+"LotSizeDimensions": "20 x 82.9 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T18:37:20Z"
+"PhotosCount": 35
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T18:56:51Z"
+"Stories": "2.0"
+"StreetName": "Highgate"
+"StreetNumber": "70"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "4498"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://listing.at-photo.ca/videos/019e738a-43f1-705a-9028-950c806273d8"
+"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": "Stoney Creek Mountain"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29905460/12-70-highgate-drive-hamilton-stoney-creek-mountain-stoney-creek-mountain"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "RM3-35"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 20.0
+"OriginalEntryTimestamp": "2026-06-15T18:37:20.28Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1367911"
+"ListOfficeNationalAssociationId": "1427673"
+"Media": array:35 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29905460')"
+"ID": "1532436"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23420
+post_id: "1530992"
+post_author: 1
+"ListingKey": "29905376"
+"ListingId": "40839706"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T15:20:40Z"
+"RFModificationTimestamp": "2026-06-17T15:46:07Z"
+"ListPrice": 599900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1674.0
+"BuildingAreaTotal": 0
+"City": "Hannon"
+"PostalCode": "L0R1P0"
+"UnparsedAddress": "53 AQUARIUS Crescent, Hannon, Ontario L0R1P0"
+"Coordinates": array:2 [
0 => -79.7861384
1 => 43.1732572
]
+"Latitude": 43.1732572
+"Longitude": -79.7861384
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully styled 3-bedroom townhome tucked away in a quiet, family-friendly community on sought-after Stoney Creek mountain. Freshly painted and filled with natural light, this move-in-ready home offers the perfect blend of style, function, and everyday comfort. The main floor features 9-foot ceilings, modern pot lights, and a thoughtfully designed kitchen with custom cabinetry, a breakfast bar, and plenty of prep space for busy mornings or entertaining friends and family. At the front of the home, a dedicated dining room provides the perfect setting for hosting holiday dinners or gathering with family and friends. From the kitchen, the spacious living area flows effortlessly to sliding doors leading to an elevated and private, southeast-facing deck - an ideal spot to enjoy your morning coffee or unwind at the end of the day. Upstairs, the generous primary suite offers double closets and a private ensuite, while two additional bedrooms provide flexible space for kids, guests, or a home office. The bright walkout lower level adds even more versatility with direct backyard access and endless possibilities for a rec room, fourth bedroom, or home gym. Just steps from the neighbourhood park and close to schools, shopping, restaurants, and every convenience, this home offers an exceptional lifestyle in one of Stoney Creek’s most desirable locations. Whether you’re a first-time buyer, downsizer, or investor, this is an opportunity you won’t want to miss. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T19:17:44.147415+00:00"
+"Directions": "From Rymal Rd, turn onto Terryberry Rd., left on Dalgleish Trail, left on Canary Grass Blvd., left on Aquarius Cres."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2239450"
+"ListOfficeKey": "299790"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T15:12:36Z"
+"PhotosCount": 30
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T15:12:36Z"
+"Stories": "3.0"
+"StreetName": "AQUARIUS"
+"StreetNumber": "53"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "504 - Leckie Park/Highland"
+"TaxAnnualAmount": "4026.64"
+"VirtualTourURLUnbranded": "https://youriguide.com/53_aquarius_cres_hamilton_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29905376/53-aquarius-crescent-hannon"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2050273"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "299790"
+"GeocodeManualYN": true
+"ZoningDescription": "RM4 - 289"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 15.0
+"AboveGradeFinishedArea": 1674
+"OriginalEntryTimestamp": "2026-06-15T18:32:40.16Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1477386"
+"ListOfficeNationalAssociationId": "1476846"
+"CoListAgentNationalAssociationId": "1325722"
+"CoListOfficeNationalAssociationId": "1476846"
+"Media": array:30 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29905376')"
+"ID": "1530992"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25263
+post_id: "1530804"
+post_author: 1
+"ListingKey": "29905032"
+"ListingId": "40839409"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T18:00:09Z"
+"RFModificationTimestamp": "2026-06-16T18:28:03Z"
+"ListPrice": 1049900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2125.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8J0J7"
+"UnparsedAddress": "17 NARBONNE Crescent, Stoney Creek, Ontario L8J0J7"
+"Coordinates": array:2 [
0 => -79.7797008
1 => 43.1862603
]
+"Latitude": 43.1862603
+"Longitude": -79.7797008
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 17 Narbonne Crescent in desirable Stoney Creek! Situated on a premium oversized corner lot, this beautifully maintained home offers exceptional space, comfort, and potential for growing families. Inside, you'll find four generously sized bedrooms and an abundance of natural light that fills the home through large windows, creating a bright and inviting atmosphere throughout. Thoughtfully updated with numerous upgrades, this home blends functionality with modern appeal. The spacious layout provides plenty of room for everyday living and entertaining, while the unfinished basement offers a blank canvas to create additional living space, a home gym, recreation room, or in-law suite tailored to your needs. Step outside to enjoy the covered rear patio—perfect for relaxing, hosting guests, or extending your outdoor living season. The expansive corner lot provides excellent curb appeal, additional yard space, and added privacy. Located in a family-friendly neighbourhood close to parks, schools, shopping, and major commuter routes, this is a fantastic opportunity to own a move-in-ready home in one of Stoney Creek’s most sought-after communities. Don't miss your chance to make this bright, spacious, and upgraded property your next home! (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Hot Tub"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T18:34:36.517772+00:00"
+"Directions": "From First Rd W, Turn Onto Lormont Blvd, Right Onto Chaumont Dr, Left Onto Narbonne Cres, Property On Right"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Stucco"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1981716"
+"ListOfficeKey": "299866"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T17:51:43Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T17:52:41Z"
+"Stories": "2.0"
+"StreetName": "NARBONNE"
+"StreetNumber": "17"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "502 - Felker"
+"TaxAnnualAmount": "6246.48"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=NVdN9tD5o5b"
+"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/29905032/17-narbonne-crescent-stoney-creek"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2208479"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "299867"
+"GeocodeManualYN": true
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 47.0
+"AboveGradeFinishedArea": 2125
+"OriginalEntryTimestamp": "2026-06-15T17:51:43.56Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1267128"
+"ListOfficeNationalAssociationId": "1477944"
+"CoListAgentNationalAssociationId": "1454953"
+"CoListOfficeNationalAssociationId": "1477945"
+"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": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29905032')"
+"ID": "1530804"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25264
+post_id: "1524745"
+post_author: 1
+"ListingKey": "29895690"
+"ListingId": "X13437284"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T21:25:28Z"
+"RFModificationTimestamp": "2026-06-19T21:30:55Z"
+"ListPrice": 549900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek Mountain)"
+"PostalCode": "L8J3Z4"
+"UnparsedAddress": "35 - 39 PINEWOODS DRIVE, Hamilton (Stoney Creek Mountain), Ontario L8J3Z4"
+"Coordinates": array:2 [
0 => -79.774625
1 => 43.180455
]
+"Latitude": 43.180455
+"Longitude": -79.774625
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to Unit 35 at 39 Pinewoods Drive, a beautifully updated 3-bedroom, 1.5-bathroom townhome in a desirable Stoney Creek neighbourhood. This move-in-ready home features an updated kitchen with stainless steel appliances, stylish vinyl flooring, and pot lights throughout the main floor. The bright and functional layout offers comfortable living and dining spaces, while the upper level features three, carpet-free bedrooms, including a primary bedroom with a walk-in closet. An unfinished basement provides excellent storage and future potential. Enjoy peace of mind with a newer roof (2017), furnace (2026), washer and dryer (2026), and an attached garage with automatic garage door opener. Ideally located close to schools, parks, shopping, restaurants, public transit, and community amenities. Commuters will appreciate easy access to the Red Hill Valley Parkway, LINC, QEW, and Highway 403. Whether you're a first-time buyer, investor, or downsizer, this home offers exceptional value in a convenient, family-friendly location. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
7 => "Garage door opener remote(s)"
]
+"AssociationFee": "195.92"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Parking"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Community Centre"
1 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T19:36:29.664657+00:00"
+"Directions": "Cross Streets: Highland Rd W & Upper Centennial. ** Directions: Highland Rd W to Highbury, to Pinewoods."
+"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": "2094057"
+"ListOfficeKey": "269164"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-12T16:31:49Z"
+"PhotosCount": 37
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T20:55:26Z"
+"Stories": "2.0"
+"StreetName": "Pinewoods"
+"StreetNumber": "39"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "3092.74"
+"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"
+"CityRegion": "Stoney Creek Mountain"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29895690/35-39-pinewoods-drive-hamilton-stoney-creek-mountain-stoney-creek-mountain"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Arthex Property Management"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2026-06-12T16:31:49.6Z"
+"ListAgentNationalAssociationId": "1366548"
+"ListOfficeNationalAssociationId": "1243249"
+"Media": array:37 [
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]
]
+"DaysOnMarket": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29895690')"
+"ID": "1524745"
}
]
+success: true
+page_size: 9
+page_count: 11
+count: 93
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]