array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29687954 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23362
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23364
+post_id: "1376403"
+post_author: 1
+"ListingKey": "29687954"
+"ListingId": "40823730"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-09T23:56:15Z"
+"RFModificationTimestamp": "2026-06-10T00:07:11Z"
+"ListPrice": 549900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 1400.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8L2K4"
+"UnparsedAddress": "46 MAYFLOWER Avenue, Hamilton, Ontario L8L2K4"
+"Coordinates": array:2 [
0 => -79.8256896
1 => 43.2500127
]
+"Latitude": 43.2500127
+"Longitude": -79.8256896
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this impressive 2-story home, ideally situated on a quiet street in the heart of the family-oriented Crown Point neighbourhood. This community is characterized by a diverse blend of hard-working families and a grounded, resilient lifestyle centered on shared experiences and routine. Fully renovated from top to bottom in 2023, offering modern efficiency and peace of mind. Renovations include upgraded electrical throughout, including a new 200A panel, all-new plumbing, new air conditioner, new shingles, new windows and doors throughout, comprehensive waterproofing featuring an internal weeping tile system and a primary sump pump with a battery-powered backup. New lighting fixtures installed throughout and the addition of smart home technology to control lights and the thermostat. Close to a wealth of local amenities and just steps from the Hamilton Stadium. Easy highway access and a location that puts you just minutes from the energy of downtown, allowing you to enjoy local entertainment and community sports events. This is an ideal match for the active, family-focused lifestyle, combining new-home reliability with the charm of an established urban neighborhood. Sellers are moving due to military relocation. **SELLER WILL PAY ONE FULL YEAR'S PROPERTY TAX T THE SUCCESSFUL BUYER** (id:62783)"
+"Appliances": array:2 [
0 => "Dishwasher"
1 => "Microwave"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-01T21:02:58.286441+00:00"
+"Directions": "Gage Avenue N to east on Mayflower Avenue"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2054759"
+"ListOfficeKey": "289276"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Paved driveway"
1 => "Sump Pump"
]
+"PhotosChangeTimestamp": "2026-05-01T20:20:48Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-09T23:46:46Z"
+"Stories": "2.0"
+"StreetName": "MAYFLOWER"
+"StreetNumber": "46"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "201 - Crown Point"
+"TaxAnnualAmount": "2853"
+"VirtualTourURLUnbranded": "https://youriguide.com/46_mayflower_ave_hamilton_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [
"RoomKey" => "1655980862"
"RoomType" => "Laundry room"
"ListingId" => "40823730"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29687954"
"RoomLength" => null
"RoomDimensions" => "6'6'' x 19'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T23:46:46.4Z"
]
1 => array:11 [
"RoomKey" => "1655980863"
"RoomType" => "Recreation room"
"ListingId" => "40823730"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29687954"
"RoomLength" => null
"RoomDimensions" => "12'4'' x 23'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T23:46:46.4Z"
]
2 => array:11 [
"RoomKey" => "1655980864"
"RoomType" => "Utility room"
"ListingId" => "40823730"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29687954"
"RoomLength" => null
"RoomDimensions" => "11'6'' x 10'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T23:46:46.4Z"
]
3 => array:11 [
"RoomKey" => "1655980865"
"RoomType" => "4pc Bathroom"
"ListingId" => "40823730"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29687954"
"RoomLength" => null
"RoomDimensions" => "8'2'' x 8'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T23:46:46.4Z"
]
4 => array:11 [
"RoomKey" => "1655980866"
"RoomType" => "4pc Bathroom"
"ListingId" => "40823730"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29687954"
"RoomLength" => null
"RoomDimensions" => "7'1'' x 7'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T23:46:46.4Z"
]
5 => array:11 [
"RoomKey" => "1655980867"
"RoomType" => "Bedroom"
"ListingId" => "40823730"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29687954"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 10'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T23:46:46.41Z"
]
6 => array:11 [
"RoomKey" => "1655980868"
"RoomType" => "Bedroom"
"ListingId" => "40823730"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29687954"
"RoomLength" => null
"RoomDimensions" => "6'7'' x 9'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T23:46:46.41Z"
]
7 => array:11 [
"RoomKey" => "1655980869"
"RoomType" => "Bedroom"
"ListingId" => "40823730"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29687954"
"RoomLength" => null
"RoomDimensions" => "9'8'' x 11'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T23:46:46.41Z"
]
8 => array:11 [
"RoomKey" => "1655980870"
"RoomType" => "Primary Bedroom"
"ListingId" => "40823730"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29687954"
"RoomLength" => null
"RoomDimensions" => "9'1'' x 13'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T23:46:46.41Z"
]
9 => array:11 [
"RoomKey" => "1655980871"
"RoomType" => "2pc Bathroom"
"ListingId" => "40823730"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29687954"
"RoomLength" => null
"RoomDimensions" => "2'6'' x 5'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T23:46:46.41Z"
]
10 => array:11 [
"RoomKey" => "1655980872"
"RoomType" => "Dining room"
"ListingId" => "40823730"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29687954"
"RoomLength" => null
"RoomDimensions" => "9'3'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T23:46:46.41Z"
]
11 => array:11 [
"RoomKey" => "1655980873"
"RoomType" => "Eat in kitchen"
"ListingId" => "40823730"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29687954"
"RoomLength" => null
"RoomDimensions" => "13'6'' x 15'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T23:46:46.41Z"
]
12 => array:11 [
"RoomKey" => "1655980874"
"RoomType" => "Bedroom"
"ListingId" => "40823730"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29687954"
"RoomLength" => null
"RoomDimensions" => "9'9'' x 11'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T23:46:46.41Z"
]
13 => array:11 [
"RoomKey" => "1655980875"
"RoomType" => "Bedroom"
"ListingId" => "40823730"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29687954"
"RoomLength" => null
"RoomDimensions" => "8'0'' x 9'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T23:46:46.41Z"
]
14 => array:11 [
"RoomKey" => "1655980876"
"RoomType" => "Foyer"
"ListingId" => "40823730"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29687954"
"RoomLength" => null
"RoomDimensions" => "7'7'' x 9'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T23:46:46.41Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29687954/46-mayflower-avenue-hamilton"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "D"
+"BedroomsAboveGrade": 6
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 1400
+"OriginalEntryTimestamp": "2026-05-01T20:20:48.25Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1330054"
+"ListOfficeNationalAssociationId": "1376254"
+"Media": array:50 [
0 => array:13 [
"Order" => 1
"MediaKey" => "6644297229"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687954/17405588f418a3f855509ad01c141bb5.webp"
"MediaSize" => 132198
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687954/thumbnail-17405588f418a3f855509ad01c141bb5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Welcome to 46 Mayflower Ave"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40823730"
"ResourceRecordKey" => "29687954"
"ModificationTimestamp" => "2026-05-01T20:20:48.26Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "6644297323"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687954/6837dad96e971eddc7c21dabbf0c1bfe.webp"
"MediaSize" => 139145
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687954/thumbnail-6837dad96e971eddc7c21dabbf0c1bfe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823730"
"ResourceRecordKey" => "29687954"
"ModificationTimestamp" => "2026-05-01T20:20:48.26Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "6644297424"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687954/509c23e6e4926ddf61d01322f04e7ea8.webp"
"MediaSize" => 137183
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687954/thumbnail-509c23e6e4926ddf61d01322f04e7ea8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "On property parking"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823730"
"ResourceRecordKey" => "29687954"
"ModificationTimestamp" => "2026-05-01T20:20:48.26Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "6644297469"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687954/a377de329e389a9fbcf19254134044f3.webp"
"MediaSize" => 96752
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687954/thumbnail-a377de329e389a9fbcf19254134044f3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Relax on your front patio"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823730"
"ResourceRecordKey" => "29687954"
"ModificationTimestamp" => "2026-05-01T20:20:48.26Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "6644297579"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687954/fce9b204d87ae2a9fa601d3c1ff394d3.webp"
"MediaSize" => 66097
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687954/thumbnail-fce9b204d87ae2a9fa601d3c1ff394d3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "All new doors - 2023"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823730"
"ResourceRecordKey" => "29687954"
"ModificationTimestamp" => "2026-05-01T20:20:48.26Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "6644297609"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687954/af5b945e2fa092d52e1b30c387f499e8.webp"
"MediaSize" => 68123
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687954/thumbnail-af5b945e2fa092d52e1b30c387f499e8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Large eat-in kitchen"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823730"
"ResourceRecordKey" => "29687954"
"ModificationTimestamp" => "2026-05-01T20:20:48.26Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "6644297759"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687954/179386e83f2a97169eeb0c54f329adda.webp"
"MediaSize" => 78172
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687954/thumbnail-179386e83f2a97169eeb0c54f329adda.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "New flooring throughout - 2023"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823730"
"ResourceRecordKey" => "29687954"
"ModificationTimestamp" => "2026-05-01T20:20:48.26Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "6644297814"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687954/3128aafce73e887d15cdee946b119fef.webp"
"MediaSize" => 61041
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687954/thumbnail-3128aafce73e887d15cdee946b119fef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823730"
"ResourceRecordKey" => "29687954"
"ModificationTimestamp" => "2026-05-01T20:20:48.26Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "6644297929"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687954/30f6680cc3b0b728d5322dea379c511d.webp"
"MediaSize" => 72188
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687954/thumbnail-30f6680cc3b0b728d5322dea379c511d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Main floor bedroom set up as office"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823730"
"ResourceRecordKey" => "29687954"
"ModificationTimestamp" => "2026-05-01T20:20:48.26Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "6644298011"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687954/14bca378b6a8f0f8268c28e149d3409b.webp"
"MediaSize" => 74643
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687954/thumbnail-14bca378b6a8f0f8268c28e149d3409b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "All new windows - 2023"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823730"
"ResourceRecordKey" => "29687954"
"ModificationTimestamp" => "2026-05-01T20:20:48.26Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "6644298078"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687954/e8ebde27509e5f4959d7b2f2a5061357.webp"
"MediaSize" => 39233
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687954/thumbnail-e8ebde27509e5f4959d7b2f2a5061357.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Main floor powder room - 2023"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823730"
"ResourceRecordKey" => "29687954"
"ModificationTimestamp" => "2026-05-01T20:20:48.26Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "6644298089"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687954/270eafc88efe9e9a71b349d18cd95336.webp"
"MediaSize" => 67211
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687954/thumbnail-270eafc88efe9e9a71b349d18cd95336.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823730"
"ResourceRecordKey" => "29687954"
"ModificationTimestamp" => "2026-05-01T20:20:48.26Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "6644298203"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687954/c70a35246bb0df22ade4eeb32fd269a9.webp"
"MediaSize" => 61878
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687954/thumbnail-c70a35246bb0df22ade4eeb32fd269a9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "2nd main floor bedroom set up as living room"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823730"
"ResourceRecordKey" => "29687954"
"ModificationTimestamp" => "2026-05-01T20:20:48.26Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "6644298242"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687954/3493d7e912e849d9481bc78c6686d370.webp"
"MediaSize" => 61731
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687954/thumbnail-3493d7e912e849d9481bc78c6686d370.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823730"
"ResourceRecordKey" => "29687954"
"ModificationTimestamp" => "2026-05-01T20:20:48.26Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "6644298279"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687954/00e5f800647c4698f5badd5f1d8a1368.webp"
"MediaSize" => 70065
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687954/thumbnail-00e5f800647c4698f5badd5f1d8a1368.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Floating island can be moved or removed"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823730"
"ResourceRecordKey" => "29687954"
"ModificationTimestamp" => "2026-05-01T20:20:48.26Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "6644298389"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687954/de7393ba8347caa4eb120625265f5020.webp"
"MediaSize" => 57577
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687954/thumbnail-de7393ba8347caa4eb120625265f5020.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Lots of counter space"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823730"
"ResourceRecordKey" => "29687954"
"ModificationTimestamp" => "2026-05-01T20:20:48.26Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "6644298468"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687954/4ffb04175f2408f7a14ca75d19a4cf97.webp"
"MediaSize" => 55941
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687954/thumbnail-4ffb04175f2408f7a14ca75d19a4cf97.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Recessed storage throughout kitchen"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823730"
"ResourceRecordKey" => "29687954"
"ModificationTimestamp" => "2026-05-01T20:20:48.26Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "6644298562"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687954/ec175f931fcc887d90a947955988dbae.webp"
"MediaSize" => 54841
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687954/thumbnail-ec175f931fcc887d90a947955988dbae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Stainless steel appliances included"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823730"
"ResourceRecordKey" => "29687954"
"ModificationTimestamp" => "2026-05-01T20:20:48.26Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "6644298627"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687954/d80f19b16ed06874900554927f73cc05.webp"
"MediaSize" => 69342
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687954/thumbnail-d80f19b16ed06874900554927f73cc05.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823730"
"ResourceRecordKey" => "29687954"
"ModificationTimestamp" => "2026-05-01T20:20:48.26Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "6644298688"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687954/5eec83592311bd64a1dbbe7f9ae2cd3d.webp"
"MediaSize" => 64180
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687954/thumbnail-5eec83592311bd64a1dbbe7f9ae2cd3d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Coffee nook"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823730"
"ResourceRecordKey" => "29687954"
"ModificationTimestamp" => "2026-05-01T20:20:48.26Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "6644298768"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687954/15b355f2fa394e13c103e292e5c6c067.webp"
"MediaSize" => 58886
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687954/thumbnail-15b355f2fa394e13c103e292e5c6c067.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Stairway to 2nd floor"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823730"
"ResourceRecordKey" => "29687954"
"ModificationTimestamp" => "2026-05-01T20:20:48.26Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "6644298819"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687954/5d2317085f10347ee724bec523337ae8.webp"
"MediaSize" => 74358
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687954/thumbnail-5d2317085f10347ee724bec523337ae8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Good sized bedrooms"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823730"
"ResourceRecordKey" => "29687954"
"ModificationTimestamp" => "2026-05-01T20:20:48.26Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "6644298883"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687954/bea1eaac87bedb3319c129774d105d04.webp"
"MediaSize" => 53242
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687954/thumbnail-bea1eaac87bedb3319c129774d105d04.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Hidden nook"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823730"
"ResourceRecordKey" => "29687954"
"ModificationTimestamp" => "2026-05-01T20:20:48.26Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "6644298945"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687954/2e15c8a84ed3284608d3a6f6b3c24bc1.webp"
"MediaSize" => 71011
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687954/thumbnail-2e15c8a84ed3284608d3a6f6b3c24bc1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823730"
"ResourceRecordKey" => "29687954"
"ModificationTimestamp" => "2026-05-01T20:20:48.26Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "6644299019"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687954/b4bff243334ea8bd8115b05f9d6ba70c.webp"
"MediaSize" => 45884
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687954/thumbnail-b4bff243334ea8bd8115b05f9d6ba70c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823730"
"ResourceRecordKey" => "29687954"
"ModificationTimestamp" => "2026-05-01T20:20:48.26Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "6644299038"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687954/78996e1741d79c655fa380fd7866dec7.webp"
"MediaSize" => 59134
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687954/thumbnail-78996e1741d79c655fa380fd7866dec7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "New flooring - 2023"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823730"
"ResourceRecordKey" => "29687954"
"ModificationTimestamp" => "2026-05-01T20:20:48.26Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "6644299095"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687954/acc6ca378b428deaccfbe7d7e5f9a427.webp"
"MediaSize" => 65141
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687954/thumbnail-acc6ca378b428deaccfbe7d7e5f9a427.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823730"
"ResourceRecordKey" => "29687954"
"ModificationTimestamp" => "2026-05-01T20:20:48.26Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "6644299145"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687954/d6ff9b74a972dc0f9a629374533a9f15.webp"
"MediaSize" => 64818
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687954/thumbnail-d6ff9b74a972dc0f9a629374533a9f15.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823730"
"ResourceRecordKey" => "29687954"
"ModificationTimestamp" => "2026-05-01T20:20:48.26Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "6644299181"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687954/e609940d1ee73495a5dc7e472254fcf4.webp"
"MediaSize" => 73992
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687954/thumbnail-e609940d1ee73495a5dc7e472254fcf4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823730"
"ResourceRecordKey" => "29687954"
"ModificationTimestamp" => "2026-05-01T20:20:48.26Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "6644299198"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687954/9570e4714b914cb9237e46ffdd3c5db1.webp"
"MediaSize" => 66088
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687954/thumbnail-9570e4714b914cb9237e46ffdd3c5db1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Completely renovated bedroom - 2023"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823730"
"ResourceRecordKey" => "29687954"
"ModificationTimestamp" => "2026-05-01T20:20:48.26Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "6644299230"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687954/14838cb47643961b2f93643809ef6f31.webp"
"MediaSize" => 58657
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687954/thumbnail-14838cb47643961b2f93643809ef6f31.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823730"
"ResourceRecordKey" => "29687954"
"ModificationTimestamp" => "2026-05-01T20:20:48.26Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "6644299284"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687954/66a1d6d1a0e168c3aec5f940f676ea81.webp"
"MediaSize" => 33655
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687954/thumbnail-66a1d6d1a0e168c3aec5f940f676ea81.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823730"
"ResourceRecordKey" => "29687954"
"ModificationTimestamp" => "2026-05-01T20:20:48.26Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "6644299321"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687954/c18e4fce2650e2f6f33670111f31ada0.webp"
"MediaSize" => 61120
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687954/thumbnail-c18e4fce2650e2f6f33670111f31ada0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Family time"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823730"
"ResourceRecordKey" => "29687954"
"ModificationTimestamp" => "2026-05-01T20:20:48.26Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "6644299345"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687954/ff917ebb5003133aa48417f57c3a119f.webp"
"MediaSize" => 53239
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687954/thumbnail-ff917ebb5003133aa48417f57c3a119f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "TV, TV mount and electric fireplace included"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823730"
"ResourceRecordKey" => "29687954"
"ModificationTimestamp" => "2026-05-01T20:20:48.26Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "6644299360"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687954/b15f4ba7bccd8f6b68a98d167cc7dfde.webp"
"MediaSize" => 63914
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687954/thumbnail-b15f4ba7bccd8f6b68a98d167cc7dfde.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823730"
"ResourceRecordKey" => "29687954"
"ModificationTimestamp" => "2026-05-01T20:20:48.26Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "6644299416"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687954/df8b8e7700e13cabe1ee9011c0b2c648.webp"
"MediaSize" => 32363
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687954/thumbnail-df8b8e7700e13cabe1ee9011c0b2c648.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Relax in your 5 piece bath!"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823730"
"ResourceRecordKey" => "29687954"
"ModificationTimestamp" => "2026-05-01T20:20:48.26Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "6644299432"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687954/25d61d6f641b0f1341426db7eac0e14e.webp"
"MediaSize" => 42665
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687954/thumbnail-25d61d6f641b0f1341426db7eac0e14e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823730"
"ResourceRecordKey" => "29687954"
"ModificationTimestamp" => "2026-05-01T20:20:48.26Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "6644299441"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687954/c1e5b94fc71d0925660d566a02d03543.webp"
"MediaSize" => 132619
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687954/thumbnail-c1e5b94fc71d0925660d566a02d03543.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Enjoy the beautiful outdoors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823730"
"ResourceRecordKey" => "29687954"
"ModificationTimestamp" => "2026-05-01T20:20:48.26Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "6644299501"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687954/0eaec4ce50494db1fc693b404af08748.webp"
"MediaSize" => 139746
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687954/thumbnail-0eaec4ce50494db1fc693b404af08748.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Shed replacement parts and solar lights included"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823730"
"ResourceRecordKey" => "29687954"
"ModificationTimestamp" => "2026-05-01T20:20:48.26Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "6644299530"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687954/60aae073da5982500b448d468760c7bf.webp"
"MediaSize" => 123035
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687954/thumbnail-60aae073da5982500b448d468760c7bf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entertainment space awaits you"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823730"
"ResourceRecordKey" => "29687954"
"ModificationTimestamp" => "2026-05-01T20:20:48.26Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "6644299573"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687954/4608e32d4c3c4f06c00ca111b0c1a68d.webp"
"MediaSize" => 117021
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687954/thumbnail-4608e32d4c3c4f06c00ca111b0c1a68d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Exterior blocks newly painted"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823730"
"ResourceRecordKey" => "29687954"
"ModificationTimestamp" => "2026-05-01T20:20:48.26Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "6644299600"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687954/f3dc378b42ac4dd52869607f2267bd6b.webp"
"MediaSize" => 134384
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687954/thumbnail-f3dc378b42ac4dd52869607f2267bd6b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823730"
"ResourceRecordKey" => "29687954"
"ModificationTimestamp" => "2026-05-01T20:20:48.26Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "6644299629"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687954/d6eb831b4224f0c6d9e4958489b13f92.webp"
"MediaSize" => 122230
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687954/thumbnail-d6eb831b4224f0c6d9e4958489b13f92.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Fence lattice to be completed prior to closing"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823730"
"ResourceRecordKey" => "29687954"
"ModificationTimestamp" => "2026-05-01T20:20:48.26Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "6644299651"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687954/6fbd6229012a5df32e789c818c1c46ac.webp"
"MediaSize" => 140002
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687954/thumbnail-6fbd6229012a5df32e789c818c1c46ac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823730"
"ResourceRecordKey" => "29687954"
"ModificationTimestamp" => "2026-05-01T20:20:48.26Z"
]
44 => array:13 [
"Order" => 45
"MediaKey" => "6644299679"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687954/fab9eb75441275d429b249671d4a371b.webp"
"MediaSize" => 159858
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687954/thumbnail-fab9eb75441275d429b249671d4a371b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823730"
"ResourceRecordKey" => "29687954"
"ModificationTimestamp" => "2026-05-01T20:20:48.26Z"
]
45 => array:13 [
"Order" => 46
"MediaKey" => "6644299721"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687954/2ffe8f963a5ec96e6d441c3c9e8c11f0.webp"
"MediaSize" => 165715
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687954/thumbnail-2ffe8f963a5ec96e6d441c3c9e8c11f0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823730"
"ResourceRecordKey" => "29687954"
"ModificationTimestamp" => "2026-05-01T20:20:48.26Z"
]
46 => array:13 [
"Order" => 47
"MediaKey" => "6644299740"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687954/d548eab3cb2bfb43c528364938330697.webp"
"MediaSize" => 161024
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687954/thumbnail-d548eab3cb2bfb43c528364938330697.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Family friendly neighbourhood"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823730"
"ResourceRecordKey" => "29687954"
"ModificationTimestamp" => "2026-05-01T20:20:48.26Z"
]
47 => array:13 [
"Order" => 48
"MediaKey" => "6644299756"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687954/39ab93fdfe4d6d6f825f349a2c72dc90.webp"
"MediaSize" => 151810
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687954/thumbnail-39ab93fdfe4d6d6f825f349a2c72dc90.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Lots of amenities close by"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823730"
"ResourceRecordKey" => "29687954"
"ModificationTimestamp" => "2026-05-01T20:20:48.26Z"
]
48 => array:13 [
"Order" => 49
"MediaKey" => "6644299766"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687954/573be7bd970645f1b8a48b8e524d79a8.webp"
"MediaSize" => 149607
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687954/thumbnail-573be7bd970645f1b8a48b8e524d79a8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "2 minute walk to Hamilton Stadium"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823730"
"ResourceRecordKey" => "29687954"
"ModificationTimestamp" => "2026-05-01T20:20:48.26Z"
]
49 => array:13 [
"Order" => 50
"MediaKey" => "6644299783"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687954/9fc32ae28140cd923939716b636b8f38.webp"
"MediaSize" => 157722
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687954/thumbnail-9fc32ae28140cd923939716b636b8f38.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40823730"
"ResourceRecordKey" => "29687954"
"ModificationTimestamp" => "2026-05-01T20:20:48.26Z"
]
]
+"DaysOnMarket": 46
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29687954')"
+"ID": "1376403"
}
]
+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 289276" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24796
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2054759" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24881
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29687954'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25208
+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 '29687954'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25224
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29687954' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.8256896 43.2500127)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25297
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25291
+post_id: "1539922"
+post_author: 1
+"ListingKey": "29917454"
+"ListingId": "40840814"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T18:50:07Z"
+"RFModificationTimestamp": "2026-06-17T19:18:32Z"
+"ListPrice": 674900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 1918.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8K2R1"
+"UnparsedAddress": "148 HUXLEY Avenue S, Hamilton, Ontario L8K2R1"
+"Coordinates": array:2 [
0 => -79.8138917
1 => 43.2366261
]
+"Latitude": 43.2366261
+"Longitude": -79.8138917
+"YearBuilt": 1945
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to a truly unique opportunity in Hamilton’s charming east end. This versatile property features two fully separate living spaces, making it an ideal fit for growing families, multi-generational living, or savvy buyers looking to offset their mortgage. At the front, the bright and welcoming 1.5-storey home offers 4 bedrooms and 2 full bathrooms, with a functional layout designed for everyday family life. You’ll love the natural light, generous storage throughout, and the high, dry basement—complete with a separate laundry room, partially finished kids ’playroom, and a roughed-in 3-piece bathroom ready for your finishing touches. Tucked privately at the rear, the self-contained 1+1 bedroom unit provides incredible flexibility. With its own side entrance, this space includes a full kitchen, bedroom, and bathroom on the main level, plus a cozy lower level featuring a living room, additional bedroom or office, and its own laundry. Whether you’re looking to create space for extended family, generate rental income, or step into homeownership with added financial support, this property offers options that are hard to find. Set in a well-kept, established neighbourhood close to parks, schools, and everyday amenities, this is a home that combines character, flexibility, and long-term value. (id:62783)"
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T19:17:47.161683+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Other"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2005282"
+"ListOfficeKey": "289424"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In-Law Suite"
]
+"PhotosChangeTimestamp": "2026-06-17T18:40:13Z"
+"PhotosCount": 38
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T18:40:12Z"
+"Stories": "1.5"
+"StreetDirSuffix": "South"
+"StreetName": "HUXLEY"
+"StreetNumber": "148"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "222 - Delta"
+"TaxAnnualAmount": "5295"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:22 [
0 => array:11 [
"RoomKey" => "1661368165"
"RoomType" => "Laundry room"
"ListingId" => "40840814"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29917454"
"RoomLength" => null
"RoomDimensions" => "5'1'' x 14'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T18:40:12.95Z"
]
1 => array:11 [
"RoomKey" => "1661368166"
"RoomType" => "Bedroom"
"ListingId" => "40840814"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29917454"
"RoomLength" => null
"RoomDimensions" => "9'8'' x 10'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T18:40:12.95Z"
]
2 => array:11 [
"RoomKey" => "1661368167"
"RoomType" => "Family room"
"ListingId" => "40840814"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29917454"
"RoomLength" => null
"RoomDimensions" => "15'0'' x 24'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T18:40:12.95Z"
]
3 => array:11 [
"RoomKey" => "1661368168"
"RoomType" => "4pc Bathroom"
"ListingId" => "40840814"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29917454"
"RoomLength" => null
"RoomDimensions" => "5'0'' x 10'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T18:40:12.95Z"
]
4 => array:11 [
"RoomKey" => "1661368169"
"RoomType" => "Bedroom"
"ListingId" => "40840814"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29917454"
"RoomLength" => null
"RoomDimensions" => "10'2'' x 11'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T18:40:12.95Z"
]
5 => array:11 [
"RoomKey" => "1661368170"
"RoomType" => "Living room"
"ListingId" => "40840814"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29917454"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 11'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T18:40:12.96Z"
]
6 => array:11 [
"RoomKey" => "1661368171"
"RoomType" => "Kitchen"
"ListingId" => "40840814"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29917454"
"RoomLength" => null
"RoomDimensions" => "7'0'' x 7'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T18:40:12.96Z"
]
7 => array:11 [
"RoomKey" => "1661368172"
"RoomType" => "Storage"
"ListingId" => "40840814"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29917454"
"RoomLength" => null
"RoomDimensions" => "9'10'' x 10'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T18:40:12.96Z"
]
8 => array:11 [
"RoomKey" => "1661368173"
"RoomType" => "Storage"
"ListingId" => "40840814"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29917454"
"RoomLength" => null
"RoomDimensions" => "9'3'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T18:40:12.96Z"
]
9 => array:11 [
"RoomKey" => "1661368174"
"RoomType" => "Utility room"
"ListingId" => "40840814"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29917454"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 24'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T18:40:12.96Z"
]
10 => array:11 [
"RoomKey" => "1661368175"
"RoomType" => "Recreation room"
"ListingId" => "40840814"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29917454"
"RoomLength" => null
"RoomDimensions" => "15'9'' x 22'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T18:40:12.96Z"
]
11 => array:11 [
"RoomKey" => "1661368176"
"RoomType" => "4pc Bathroom"
"ListingId" => "40840814"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29917454"
"RoomLength" => null
"RoomDimensions" => "5'3'' x 6'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T18:40:12.96Z"
]
12 => array:11 [
"RoomKey" => "1661368177"
"RoomType" => "Bedroom"
"ListingId" => "40840814"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29917454"
"RoomLength" => null
"RoomDimensions" => "10'7'' x 11'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T18:40:12.96Z"
]
13 => array:11 [
"RoomKey" => "1661368178"
"RoomType" => "Bedroom"
"ListingId" => "40840814"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29917454"
"RoomLength" => null
"RoomDimensions" => "10'1'' x 15'9''"
"RoomDescription" => null
…2
]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
18 => array:11 [ …11]
19 => array:11 [ …11]
20 => array:11 [ …11]
21 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29917454/148-huxley-avenue-s-hamilton"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "C"
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 33.0
+"AboveGradeFinishedArea": 1918
+"OriginalEntryTimestamp": "2026-06-17T18:40:12.91Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1287615"
+"ListOfficeNationalAssociationId": "1377637"
+"Media": array:38 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29917454')"
+"ID": "1539922"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25293
+post_id: "1539058"
+post_author: 1
+"ListingKey": "29915832"
+"ListingId": "40840365"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T18:10:05Z"
+"RFModificationTimestamp": "2026-06-17T18:30:47Z"
+"ListPrice": 519900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0.05
+"LivingArea": 1049.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8H4Z1"
+"UnparsedAddress": "55 CAMERON Avenue N, Hamilton, Ontario L8H4Z1"
+"Coordinates": array:2 [
0 => -79.8064632
1 => 43.2418306
]
+"Latitude": 43.2418306
+"Longitude": -79.8064632
+"YearBuilt": 1930
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 55 Cameron Avenue North, a beautifully maintained home that is truly move-in ready. From the moment you arrive, you'll appreciate the pride of ownership evident throughout. The main level offers a bright and inviting formal living room and dining room, both featuring hardwood flooring. The living room is highlighted by an electric fireplace, while the dining room offers French doors leading to the covered rear deck, creating the perfect space for indoor-outdoor entertaining. The stunning kitchen was renovated in 2024 and boasts hardwood flooring, quartz countertops, an undermount sink, a gas stove, abundant counter space, and convenient access to the backyard. Upstairs, you'll find two spacious bedrooms, each featuring walk-in closets. The beautifully renovated 4-piece bathroom (2025) includes a thoughtful storage nook, while modern zebra blinds add a stylish touch to both bedrooms and the living room. The basement provides a blank canvas, offering endless potential for additional living space, a recreation room, home office, or gym. Step outside and discover your own private backyard retreat. Designed for relaxation and entertaining, the yard features a covered deck, a lower deck area, green space for children or pets, and an oversized shed built in 2024. A concrete parking pad at the rear of the property provides a valuable second parking space with convenient access from the rear alley. A wonderful opportunity to own a lovingly cared-for home with tasteful updates, functional living spaces, and a backyard oasis in a convenient Hamilton location. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Gas stove(s)"
3 => "Dishwasher"
4 => "Dryer"
5 => "Hood Fan"
6 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T16:46:19.140438+00:00"
+"Directions": "Main St to Cameron St N"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Vinyl siding"
2 => "Other"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1663135"
+"ListOfficeKey": "290604"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Paved driveway"
1 => "Private Yard"
]
+"LotSizeDimensions": "0.05"
+"PhotosChangeTimestamp": "2026-06-17T15:50:50Z"
+"PhotosCount": 48
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T18:01:27Z"
+"Stories": "1.5"
+"StreetDirSuffix": "North"
+"StreetName": "CAMERON"
+"StreetNumber": "55"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "231 - Homeside"
+"TaxAnnualAmount": "3000"
+"VirtualTourURLUnbranded": "https://youriguide.com/55_cameron_ave_n_hamilton_on/"
+"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/29915832/55-cameron-avenue-n-hamilton"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "C"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 25.0
+"AboveGradeFinishedArea": 1049
+"OriginalEntryTimestamp": "2026-06-17T15:50:49.96Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1168385"
+"ListOfficeNationalAssociationId": "1389565"
+"Media": array:48 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29915832')"
+"ID": "1539058"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25290
+post_id: "1537903"
+post_author: 1
+"ListingKey": "29914178"
+"ListingId": "40840345"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T04:55:11Z"
+"RFModificationTimestamp": "2026-06-17T06:43:13Z"
+"ListPrice": 349850.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1226.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8L7K8"
+"UnparsedAddress": "86 BELVIEW Avenue, Hamilton, Ontario L8L7K8"
+"Coordinates": array:2 [
0 => -79.8242923
1 => 43.2473745
]
+"Latitude": 43.2473745
+"Longitude": -79.8242923
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Attention renovators, handy buyers, and investors! This two-story home in the popular Crown Point neighbourhood offers a fantastic opportunity to renovate, personalize, and build sweat equity. Featuring a spacious layout with 3 bedrooms, an updated 4-piece bathroom, living room with fireplace, dining room, and a large eat-in kitchen, this home is ready for your vision. The main level includes convenient laundry in the enclosed rear porch, while outside you’ll find a front driveway and fenced yard. Notable updates include some newer windows, a newer kitchen, updated plumbing, 100-amp service on circuit breakers, and a furnace replaced in 2024. Ideally located just a short walk to Gage Park and splash pad, trendy Ottawa Street shops, restaurants, and boutiques, and close to Centre Mall, the Red Hill Valley Parkway, and QEW access. A solid investment opportunity in a sought-after area…cheaper than rent and full of potential! (id:62650)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T06:43:05.264234+00:00"
+"ExteriorFeatures": array:1 [
0 => "Aluminum siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524687"
+"ListOfficeKey": "284640"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-06-17T04:49:50Z"
+"PhotosCount": 29
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T04:49:50Z"
+"Stories": "2.0"
+"StreetName": "BELVIEW"
+"StreetNumber": "86"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "201 - Crown Point"
+"TaxAnnualAmount": "2583"
+"VirtualTourURLUnbranded": "https://www.myvisuallistings.com/vt/363970"
+"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": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29914178/86-belview-avenue-hamilton"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1628810"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "262629"
+"GeocodeManualYN": true
+"ZoningDescription": "D"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 20.0
+"AboveGradeFinishedArea": 1226
+"OriginalEntryTimestamp": "2026-06-17T04:49:50.63Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1063164"
+"ListOfficeNationalAssociationId": "1344651"
+"CoListAgentNationalAssociationId": "1161564"
+"CoListOfficeNationalAssociationId": "1223032"
+"Media": array:29 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29914178')"
+"ID": "1537903"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25294
+post_id: "1537636"
+post_author: 1
+"ListingKey": "29913998"
+"ListingId": "X13454008"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T03:50:00Z"
+"RFModificationTimestamp": "2026-06-17T03:54:18Z"
+"ListPrice": 765000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Delta)"
+"PostalCode": "L8K2C9"
+"UnparsedAddress": "25 OTTAWA STREET S, Hamilton (Delta), Ontario L8K2C9"
+"Coordinates": array:2 [
0 => -79.81975
1 => 43.241668
]
+"Latitude": 43.241668
+"Longitude": -79.81975
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this beautifully maintained 2.5-storey century home in Hamilton's highly desirable Delta neighbourhood. Blending timeless character with thoughtful updates, this spacious home offers 4 bedrooms above grade plus a bachelor suite in the basement.From the moment you step inside, you'll appreciate the original hardwood floors, stunning oak staircase, and charming pocket doors that showcase the craftsmanship and character the era. The bright and functional main floor features generous living and dining spaces, along with a cozy den that walks out to a private backyard oasis-perfect for entertaining, relaxing, or enjoying summer evenings with family and friends. Upstairs, you'll find four spacious bedrooms (including the loft) filled with natural light and a beautifully updated 4-piece bathroom that combines modern convenience with classic style. The fully finished basement offers a self-contained bachelor apartment, providing excellent flexibility for extended family, guests, or potential rental income.With two private parking spaces, additional street parking, and an unbeatable location within walking distance to parks, schools, shopping, transit, and some of Hamilton's most popular restaurants and cafes, this home offers the perfect combination of space, character, and lifestyle. A rare opportunity to own a piece of Hamilton history while enjoying all the comforts of modern living. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Wall unit"
]
+"CreationDate": "2026-06-17T03:20:17.793204+00:00"
+"Directions": "Cross Streets: Main Street E. ** Directions: Main St E to Ottawa St."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Radiant heat"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2024918"
+"ListOfficeKey": "292168"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "34.3 x 103.5 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T02:47:09Z"
+"PhotosCount": 36
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T03:41:01Z"
+"Stories": "2.5"
+"StreetDirSuffix": "South"
+"StreetName": "Ottawa"
+"StreetNumber": "25"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4722"
+"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"
+"TaxYear": 2026
+"CityRegion": "Delta"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29913998/25-ottawa-street-s-hamilton-delta-delta"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 34.3
+"OriginalEntryTimestamp": "2026-06-17T02:47:09.35Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1304615"
+"ListOfficeNationalAssociationId": "1408695"
+"Media": array:36 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29913998')"
+"ID": "1537636"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25292
+post_id: "1537581"
+post_author: 1
+"ListingKey": "29913830"
+"ListingId": "40838234"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T03:15:04Z"
+"RFModificationTimestamp": "2026-06-17T03:16:57Z"
+"ListPrice": 765000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.08
+"LivingArea": 2500.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8K2C9"
+"UnparsedAddress": "25 S OTTAWA Street S, Hamilton, Ontario L8K2C9"
+"Coordinates": array:2 [
0 => -79.8196336
1 => 43.2417753
]
+"Latitude": 43.2417753
+"Longitude": -79.8196336
+"YearBuilt": 1929
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully maintained 2.5-storey century home in Hamilton’s highly desirable Delta neighbourhood. Blending timeless character with thoughtful updates, this spacious home offers 4 bedrooms above grade plus a bachelor suite in the basement. From the moment you step inside, you'll appreciate the original hardwood floors, stunning oak staircase, and charming pocket doors that showcase the craftsmanship and character the era. The bright and functional main floor features generous living and dining spaces, along with a cozy den that walks out to a private backyard oasis—perfect for entertaining, relaxing, or enjoying summer evenings with family and friends. Upstairs, you'll find four spacious bedrooms (including the loft) filled with natural light and a beautifully updated 4-piece bathroom that combines modern convenience with classic style. The fully finished basement offers a self-contained bachelor apartment, providing excellent flexibility for extended family, guests, or potential rental income. With two private parking spaces, additional street parking, and an unbeatable location within walking distance to parks, schools, shopping, transit, and some of Hamilton’s most popular restaurants and cafes, this home offers the perfect combination of space, character, and lifestyle. A rare opportunity to own a piece of Hamilton history while enjoying all the comforts of modern living. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Dishwasher"
2 => "Stove"
3 => "Dryer"
4 => "Hood Fan"
5 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:2 [
0 => "Window air conditioner"
1 => "Ductless"
]
+"CreationDate": "2026-06-17T02:27:28.548147+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:1 [
0 => "Radiant heat"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1991807"
+"ListOfficeKey": "292150"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "0.08"
+"PhotosChangeTimestamp": "2026-06-17T01:50:52Z"
+"PhotosCount": 35
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T03:10:00Z"
+"Stories": "2.5"
+"StreetDirPrefix": "South"
+"StreetDirSuffix": "South"
+"StreetName": "OTTAWA"
+"StreetNumber": "25"
+"StreetSuffix": "Street"
+"SubdivisionName": "222 - Delta"
+"TaxAnnualAmount": "4722"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29913830/25-s-ottawa-street-s-hamilton"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "C"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 34.0
+"AboveGradeFinishedArea": 1900
+"BelowGradeFinishedArea": 600
+"OriginalEntryTimestamp": "2026-06-17T01:50:45.35Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"BelowGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1275275"
+"ListOfficeNationalAssociationId": "1408460"
+"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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29913830')"
+"ID": "1537581"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25287
+post_id: "1536803"
+post_author: 1
+"ListingKey": "29911530"
+"ListingId": "X13451952"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T19:05:06Z"
+"RFModificationTimestamp": "2026-06-16T19:43:47Z"
+"ListPrice": 588900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Gibson)"
+"PostalCode": "L8L6H2"
+"UnparsedAddress": "10 FAIRLEIGH AVENUE N, Hamilton (Gibson), Ontario L8L6H2"
+"Coordinates": array:2 [
0 => -79.84248
1 => 43.251688
]
+"Latitude": 43.251688
+"Longitude": -79.84248
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Exceptional opportunity to own a legal duplex with a separate basement apartment, offering strong income potential and immediate upside. This well-maintained multi-unit property features three self-contained residential units, with two units currently vacant, allowing the new owner to secure market rents immediately or occupy one unit while generating income from the others. Unit 1 (Main Floor): Bright and spacious 1-bedroom apartment. Unit 2 (Upper Level): Large 3-bedroom apartment featuring an expansive finished attic space, ideal for a home office, recreation room, additional living area, or storage. Unit 3 (Basement): Renovated 1-bedroom apartment, updated approximately one year ago. The property previously generated approximately $4,700/month in gross rental income, with rents of approximately $1,400/month (Unit 1), $2,100/month (Unit 2), and $1,250/month (Unit 3). Tenants pay their own utilities, helping minimize operating expenses, and the property benefits from two separate hydro meters. Ideal for investors seeking strong cash flow and long-term appreciation or owner-occupants looking for a mortgage helper, this property offers exceptional flexibility and income-generating potential. The vacant units provide an immediate opportunity to maximize returns based on current market conditions. Conveniently located just minutes from Hamilton General Hospital, the future LRT corridor along Highway 8/Main Street East, West Harbour GO Station, Downtown Hamilton, schools, parks, shopping, public transit, and major commuter routes. This central location provides excellent connectivity and access to Hamilton's growing employment, healthcare, and transportation hubs. A rare opportunity to acquire a versatile income-producing property with immediate leasing flexibility, strong rental demand, and outstanding long-term investment potential. (id:62783)"
+"Appliances": array:5 [
0 => "All"
1 => "Refrigerator"
2 => "Stove"
3 => "Range"
4 => "Dryer"
]
+"Basement": array:4 [
0 => "Finished"
1 => "Apartment in basement"
2 => "N/A"
3 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T19:42:25.009441+00:00"
+"Directions": "King St E & Sherman Ave S"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2006993"
+"ListOfficeKey": "296729"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "21 x 44.7 FT ; 21.04 X 42.58 X 29.06 X 44.80"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-16T18:59:00Z"
+"PhotosCount": 38
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T18:59:00Z"
+"Stories": "2.5"
+"StreetDirSuffix": "North"
+"StreetName": "Fairleigh"
+"StreetNumber": "10"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "3526.38"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Gibson"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29911530/10-fairleigh-avenue-n-hamilton-gibson-gibson"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1982306"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "296729"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "Toc-3"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 21.0
+"OriginalEntryTimestamp": "2026-06-16T18:59:00.82Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1289122"
+"ListOfficeNationalAssociationId": "1461559"
+"CoListAgentNationalAssociationId": "1267485"
+"CoListOfficeNationalAssociationId": "1461559"
+"Media": array:38 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29911530')"
+"ID": "1536803"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23376
+post_id: "1534863"
+post_author: 1
+"ListingKey": "29909082"
+"ListingId": "40840181"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T14:40:09Z"
+"RFModificationTimestamp": "2026-06-16T17:41:11Z"
+"ListPrice": 409000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 700.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8H4G6"
+"UnparsedAddress": "47 FRASER Avenue, Hamilton, Ontario L8H4G6"
+"Coordinates": array:2 [
0 => -79.813822
1 => 43.2497781
]
+"Latitude": 43.2497781
+"Longitude": -79.813822
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Fraser Ave located in the Crown Point neighbourhood. This charming 2 Storey home with 2 beds and 2 bath has a fully gated lot, a driveway where you can park 2 cars and good sized yard for family gatherings or relaxing. This move in ready home has a great layout with the main floor boasting a kitchen, Living Room and Dining Room and the Second Floor having two bed rooms and full bathroom. Located within walking distance to Ottawa Street and all its dining and shopping options as well as easy access to transit and close to major highways. (id:62650)"
+"Appliances": array:3 [
0 => "Refrigerator"
1 => "Stove"
2 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T17:41:09.632968+00:00"
+"Directions": "East of Ottawa Street, South of Barton"
+"ExteriorFeatures": array:1 [
0 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2032437"
+"ListOfficeKey": "283383"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"PhotosChangeTimestamp": "2026-06-16T14:31:37Z"
+"PhotosCount": 26
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T14:31:37Z"
+"Stories": "2.0"
+"StreetName": "FRASER"
+"StreetNumber": "47"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "201 - Crown Point"
+"TaxAnnualAmount": "3090"
+"VirtualTourURLUnbranded": "https://viralrealestate.media/47-fraser-ave-hamilton"
+"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/29909082/47-fraser-avenue-hamilton"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "D"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 19.0
+"AboveGradeFinishedArea": 700
+"OriginalEntryTimestamp": "2026-06-16T14:31:37.46Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1309685"
+"ListOfficeNationalAssociationId": "1328451"
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29909082')"
+"ID": "1534863"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25295
+post_id: "1534123"
+post_author: 1
+"ListingKey": "29908847"
+"ListingId": "X13449326"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T02:55:10Z"
+"RFModificationTimestamp": "2026-06-17T02:56:12Z"
+"ListPrice": 689000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Delta)"
+"PostalCode": "L8K2G7"
+"UnparsedAddress": "152 LONDON STREET S, Hamilton (Delta), Ontario L8K2G7"
+"Coordinates": array:2 [
0 => -79.820854
1 => 43.237821
]
+"Latitude": 43.237821
+"Longitude": -79.820854
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Who doesn't love a 2-storey century homes in Hamilton's highly sought-after Delta neighbourhood? From the classic covered front porch to the original hardwood floors and timeless details throughout, this home is a perfect combination of charm and style. Step inside to find bright and spacious living and dining rooms, complete with a stunning coffered ceiling that adds warmth and character to every gathering. The functional eat-in kitchen boasts plenty of space for daily living, meal prep and leads directly to a fully fenced, west-facing backyard-perfect for relaxing, entertaining, or simply soaking up some vitamin D. Upstairs, you'll find four bedrooms and a beautifully updated 4-piece bathroom, providing plenty of space for families, guests, or a home office setup. The partially finished basement adds even more versatility, offering abundant storage, laundry, a 3-piece bathroom, and the opportunity to create whatever bonus space suits your lifestyle. A detached garage provides parking for one vehicle, while the location truly steals the show. The Delta is loved for its tree-lined streets, beautiful character homes, great neighbours, and easy access to some of the city's best amenities. Enjoy weekends at Gage Park, grab coffee from a local favourite, explore the shops and restaurants of Ottawa Street. Character, space, updates, and one of Hamilton's most beloved neighbourhoods-this is a home you'll be proud to call your own. RSA (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dishwasher"
4 => "Stove"
5 => "Range"
6 => "Dryer"
7 => "Window Coverings"
8 => "Garage door opener"
9 => "Water Heater"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T15:16:26.528953+00:00"
+"Directions": "Cross Streets: London St S & Montclair Ave. ** Directions: South of King St E, on the corner of London St South and Montclair Ave."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2231170"
+"ListOfficeKey": "50984"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Flat site"
]
+"LotSizeDimensions": "20.9 x 100 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-16T13:46:26Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T02:47:04Z"
+"Stories": "2.0"
+"StreetDirSuffix": "South"
+"StreetName": "London"
+"StreetNumber": "152"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3877.58"
+"Utilities": array:2 [
0 => "Sewer"
1 => "Electricity"
]
+"VirtualTourURLUnbranded": "https://sites.nomorecowboys.media/mls/251859956"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Delta"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29908847/152-london-street-s-hamilton-delta-delta"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "R1a"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 20.1
+"OriginalEntryTimestamp": "2026-06-16T13:46:26.22Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1472274"
+"ListOfficeNationalAssociationId": "1001061"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29908847')"
+"ID": "1534123"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25296
+post_id: "1534000"
+post_author: 1
+"ListingKey": "29908621"
+"ListingId": "40839581"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T22:15:05Z"
+"RFModificationTimestamp": "2026-06-16T22:16:00Z"
+"ListPrice": 689000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2084.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8K2G7"
+"UnparsedAddress": "152 LONDON Street S, Hamilton, Ontario L8K2G7"
+"Coordinates": array:2 [
0 => -79.8208442
1 => 43.2378189
]
+"Latitude": 43.2378189
+"Longitude": -79.8208442
+"YearBuilt": 1926
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Who doesn’t love a 2-storey century homes in Hamilton's highly sought-after Delta neighbourhood? From the classic covered front porch to the original hardwood floors and timeless details throughout, this home is a perfect combination of charm and style. Step inside to find bright and spacious living and dining rooms, complete with a stunning coffered ceiling that adds warmth and character to every gathering. The functional eat-in kitchen boasts plenty of space for daily living, meal prep and leads directly to a fully fenced, west-facing backyard—perfect for relaxing, entertaining, or simply soaking up some vitamin D. Upstairs, you'll find four bedrooms and a beautifully updated 4-piece bathroom, providing plenty of space for families, guests, or a home office setup. The partially finished basement adds even more versatility, offering abundant storage, laundry, a 3-piece bathroom, and the opportunity to create whatever bonus space suits your lifestyle. A detached garage provides parking for one vehicle, while the location truly steals the show. The Delta is loved for its tree-lined streets, beautiful character homes, great neighbours, and easy access to some of the city's best amenities. Enjoy weekends at Gage Park, grab coffee from a local favourite, explore the shops and restaurants of Ottawa Street. Character, space, updates, and one of Hamilton's most beloved neighbourhoods—this is a home you'll be proud to call your own. RSA (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T14:12:26.334726+00:00"
+"Directions": "South of King St E, on the corner of London St South and Montclair Ave"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1899813"
+"ListOfficeKey": "287174"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-06-16T12:51:47Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T22:09:48Z"
+"Stories": "2.0"
+"StreetDirSuffix": "South"
+"StreetName": "LONDON"
+"StreetNumber": "152"
+"StreetSuffix": "Street"
+"SubdivisionName": "222 - Delta"
+"TaxAnnualAmount": "3877.58"
+"Utilities": array:3 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Telephone"
]
+"VirtualTourURLUnbranded": "https://sites.nomorecowboys.media/152londonstreetsouth"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29908621/152-london-street-s-hamilton"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1a"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 21.0
+"AboveGradeFinishedArea": 1365
+"BelowGradeFinishedArea": 719
+"OriginalEntryTimestamp": "2026-06-16T12:50:26.36Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1216680"
+"ListOfficeNationalAssociationId": "1373445"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29908621')"
+"ID": "1534000"
}
]
+success: true
+page_size: 9
+page_count: 33
+count: 295
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]