array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29677814 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: "1369702"
+post_author: 1
+"ListingKey": "29677814"
+"ListingId": "40825314"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T13:40:03Z"
+"RFModificationTimestamp": "2026-06-17T13:43:30Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 1760.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8M3C3"
+"UnparsedAddress": "37 CONNAUGHT Avenue S, Hamilton, Ontario L8M3C3"
+"Coordinates": array:2 [
0 => -79.8296953
1 => 43.2471667
]
+"Latitude": 43.2471667
+"Longitude": -79.8296953
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 37 Connaught Avenue South, where timeless character meets one of Hamilton’s most connected, neighbourly communities. Set on a quiet, tree-lined street in Gibson/Stipley South, this is more than a home, it’s a place where neighbours know each other, kids play outside, and there’s a true sense of community. This beautifully updated 2.5-storey home offers 4 spacious bedrooms and 2.5 bathrooms, blending historic charm with thoughtful modern upgrades. Freshly painted and move-in ready, every space feels warm and refined. At the heart of the home is a stunning renovated kitchen with soaring ceilings, custom cabinetry, stainless steel appliances, granite countertops, and a functional peninsula perfect for everyday living and entertaining. It flows into a welcoming dining area with hardwood floors and an original beam ceiling. The cozy family room features pocket French doors, hardwood flooring, a gas fireplace with natural stone surround, and custom built-ins, the perfect place to unwind. Original character shines throughout with coffered ceilings, walnut trim, solid wood doors, antique hardware, inlay floors, and beautiful stained glass details. Location is everything. Just minutes to Ottawa Street’s vibrant shops, cafés, antique markets, and local dining, plus close to Gage Park where you can enjoy trails, the greenhouse, playgrounds, festivals, and year-round outdoor activities. 37 Connaught Avenue South isn’t just a home, it’s a lifestyle rooted in community, character, and convenience. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Wall unit"
]
+"CreationDate": "2026-04-30T17:16:06.414019+00:00"
+"Directions": "Main St. East to Connaught Ave. South"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Radiant heat"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1523741"
+"ListOfficeKey": "284640"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T13:30:49Z"
+"PhotosCount": 46
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T13:30:49Z"
+"Stories": "2.5"
+"StreetDirSuffix": "South"
+"StreetName": "CONNAUGHT"
+"StreetNumber": "37"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "202 - Gibson/Stipley South"
+"TaxAnnualAmount": "4540"
+"VirtualTourURLUnbranded": "https://youriguide.com/37_connaught_ave_s_hamilton_on"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [
"RoomKey" => "1655065325"
"RoomType" => "3pc Bathroom"
"ListingId" => "40825314"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29677814"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-08T16:22:35.34Z"
]
1 => array:11 [
"RoomKey" => "1655065326"
"RoomType" => "Office"
"ListingId" => "40825314"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29677814"
"RoomLength" => null
"RoomDimensions" => "12'8'' x 10'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-08T16:22:35.35Z"
]
2 => array:11 [
"RoomKey" => "1655065327"
"RoomType" => "Bedroom"
"ListingId" => "40825314"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29677814"
"RoomLength" => null
"RoomDimensions" => "18'5'' x 12'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-08T16:22:35.35Z"
]
3 => array:11 [
"RoomKey" => "1655065328"
"RoomType" => "4pc Bathroom"
"ListingId" => "40825314"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29677814"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-08T16:22:35.35Z"
]
4 => array:11 [
"RoomKey" => "1655065329"
"RoomType" => "Bedroom"
"ListingId" => "40825314"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29677814"
"RoomLength" => null
"RoomDimensions" => "7'11'' x 10'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-08T16:22:35.35Z"
]
5 => array:11 [
"RoomKey" => "1655065330"
"RoomType" => "Bedroom"
"ListingId" => "40825314"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29677814"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 10'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-08T16:22:35.35Z"
]
6 => array:11 [
"RoomKey" => "1655065331"
"RoomType" => "Bedroom"
"ListingId" => "40825314"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29677814"
"RoomLength" => null
"RoomDimensions" => "9'3'' x 10'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-08T16:22:35.35Z"
]
7 => array:11 [
"RoomKey" => "1655065332"
"RoomType" => "Bedroom"
"ListingId" => "40825314"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29677814"
"RoomLength" => null
"RoomDimensions" => "10'5'' x 10'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-08T16:22:35.35Z"
]
8 => array:11 [
"RoomKey" => "1655065333"
"RoomType" => "2pc Bathroom"
"ListingId" => "40825314"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29677814"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-08T16:22:35.35Z"
]
9 => array:11 [
"RoomKey" => "1655065334"
"RoomType" => "Kitchen"
"ListingId" => "40825314"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29677814"
"RoomLength" => null
"RoomDimensions" => "12'10'' x 9'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-08T16:22:35.35Z"
]
10 => array:11 [
"RoomKey" => "1655065335"
"RoomType" => "Dining room"
"ListingId" => "40825314"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29677814"
"RoomLength" => null
"RoomDimensions" => "11'7'' x 14'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-08T16:22:35.35Z"
]
11 => array:11 [
"RoomKey" => "1655065336"
"RoomType" => "Living room"
"ListingId" => "40825314"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29677814"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 15'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-08T16:22:35.36Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29677814/37-connaught-avenue-s-hamilton"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1524543"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "262629"
+"GeocodeManualYN": true
+"ZoningDescription": "C"
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 33.0
+"AboveGradeFinishedArea": 1760
+"OriginalEntryTimestamp": "2026-04-30T15:30:47.85Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Assessor"
+"ListAgentNationalAssociationId": "1134206"
+"ListOfficeNationalAssociationId": "1344651"
+"CoListAgentNationalAssociationId": "1123470"
+"CoListOfficeNationalAssociationId": "1223032"
+"Media": array:46 [
0 => array:13 [
"Order" => 1
"MediaKey" => "6639870672"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29677814/6608f468878d9e23eca422fba71ca746.webp"
"MediaSize" => 159211
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29677814/thumbnail-6608f468878d9e23eca422fba71ca746.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40825314"
"ResourceRecordKey" => "29677814"
"ModificationTimestamp" => "2026-04-30T15:30:47.85Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "6639870704"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29677814/408db2972be66f681141f1470dcfed4c.webp"
"MediaSize" => 88594
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29677814/thumbnail-408db2972be66f681141f1470dcfed4c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40825314"
"ResourceRecordKey" => "29677814"
"ModificationTimestamp" => "2026-04-30T15:30:47.85Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "6639870773"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29677814/4dbb7be9c33487fe84a18002084c7cc7.webp"
"MediaSize" => 169497
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29677814/thumbnail-4dbb7be9c33487fe84a18002084c7cc7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40825314"
"ResourceRecordKey" => "29677814"
"ModificationTimestamp" => "2026-04-30T15:30:47.85Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "6639870798"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29677814/bea27c0978debc151f4e8e7547d7d6b5.webp"
"MediaSize" => 115075
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29677814/thumbnail-bea27c0978debc151f4e8e7547d7d6b5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40825314"
"ResourceRecordKey" => "29677814"
"ModificationTimestamp" => "2026-04-30T15:30:47.85Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "6639870872"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29677814/fa43abdd292fa0055b363c0c4f322932.webp"
"MediaSize" => 67023
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29677814/thumbnail-fa43abdd292fa0055b363c0c4f322932.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40825314"
"ResourceRecordKey" => "29677814"
"ModificationTimestamp" => "2026-04-30T15:30:47.85Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "6639870901"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29677814/fb96498b03f25b292a83f1aa90a81f4d.webp"
"MediaSize" => 74680
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29677814/thumbnail-fb96498b03f25b292a83f1aa90a81f4d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40825314"
"ResourceRecordKey" => "29677814"
"ModificationTimestamp" => "2026-04-30T15:30:47.85Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "6639871000"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29677814/8cc1c4f81f0fb0f4f09e2b5bda7be7a4.webp"
"MediaSize" => 90419
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29677814/thumbnail-8cc1c4f81f0fb0f4f09e2b5bda7be7a4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40825314"
"ResourceRecordKey" => "29677814"
"ModificationTimestamp" => "2026-04-30T15:30:47.85Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "6639871040"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29677814/628370eb6dcbf25ced74ff392c0a5d70.webp"
"MediaSize" => 74744
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29677814/thumbnail-628370eb6dcbf25ced74ff392c0a5d70.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40825314"
"ResourceRecordKey" => "29677814"
"ModificationTimestamp" => "2026-04-30T15:30:47.85Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "6639871050"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29677814/acd6abc3d589782220c0fa2d39578749.webp"
"MediaSize" => 79954
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29677814/thumbnail-acd6abc3d589782220c0fa2d39578749.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40825314"
"ResourceRecordKey" => "29677814"
"ModificationTimestamp" => "2026-04-30T15:30:47.85Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "6639871156"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29677814/4769c0469d158ef4ee6991d98c5e4ed0.webp"
"MediaSize" => 101071
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29677814/thumbnail-4769c0469d158ef4ee6991d98c5e4ed0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40825314"
"ResourceRecordKey" => "29677814"
"ModificationTimestamp" => "2026-04-30T15:30:47.85Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "6639871224"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29677814/4b5910ed525182d87b3a3a39ce953dac.webp"
"MediaSize" => 109733
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29677814/thumbnail-4b5910ed525182d87b3a3a39ce953dac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40825314"
"ResourceRecordKey" => "29677814"
"ModificationTimestamp" => "2026-04-30T15:30:47.85Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "6639871326"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29677814/d1d0875d051e54976ee286fd085725a1.webp"
"MediaSize" => 91390
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29677814/thumbnail-d1d0875d051e54976ee286fd085725a1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40825314"
"ResourceRecordKey" => "29677814"
"ModificationTimestamp" => "2026-04-30T15:30:47.85Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "6639871439"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29677814/4bc15829ce19b7196981bedf08a22121.webp"
"MediaSize" => 72766
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29677814/thumbnail-4bc15829ce19b7196981bedf08a22121.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40825314"
"ResourceRecordKey" => "29677814"
"ModificationTimestamp" => "2026-04-30T15:30:47.85Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "6639871507"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29677814/5019ae70493739113b161b443acfa5e8.webp"
"MediaSize" => 81724
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29677814/thumbnail-5019ae70493739113b161b443acfa5e8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40825314"
"ResourceRecordKey" => "29677814"
"ModificationTimestamp" => "2026-04-30T15:30:47.85Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "6639871645"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29677814/3008855c16cf725a26cabb525bb95f7c.webp"
"MediaSize" => 73112
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29677814/thumbnail-3008855c16cf725a26cabb525bb95f7c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40825314"
"ResourceRecordKey" => "29677814"
"ModificationTimestamp" => "2026-04-30T15:30:47.85Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "6639871765"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29677814/9caf544a3d7596a4ad7524c425ed0a05.webp"
"MediaSize" => 43736
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29677814/thumbnail-9caf544a3d7596a4ad7524c425ed0a05.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40825314"
"ResourceRecordKey" => "29677814"
"ModificationTimestamp" => "2026-04-30T15:30:47.85Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "6639871892"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29677814/4e1e372f757b2de4d7e400961ca3c744.webp"
"MediaSize" => 71941
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29677814/thumbnail-4e1e372f757b2de4d7e400961ca3c744.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40825314"
"ResourceRecordKey" => "29677814"
"ModificationTimestamp" => "2026-04-30T15:30:47.85Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "6639871988"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29677814/7a34eadd94405819dba6c39dc0f2d600.webp"
"MediaSize" => 79108
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29677814/thumbnail-7a34eadd94405819dba6c39dc0f2d600.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40825314"
"ResourceRecordKey" => "29677814"
"ModificationTimestamp" => "2026-04-30T15:30:47.85Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "6639872088"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29677814/cc6ba430da82f1667c32bae49ef926b2.webp"
"MediaSize" => 80982
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29677814/thumbnail-cc6ba430da82f1667c32bae49ef926b2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40825314"
"ResourceRecordKey" => "29677814"
"ModificationTimestamp" => "2026-04-30T15:30:47.85Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "6639872193"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29677814/c93e720c9bdf34385a72bcc4648bec98.webp"
"MediaSize" => 69491
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29677814/thumbnail-c93e720c9bdf34385a72bcc4648bec98.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40825314"
"ResourceRecordKey" => "29677814"
"ModificationTimestamp" => "2026-04-30T15:30:47.85Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "6639872325"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29677814/c068f39abf7bd160e57d22182ccc8969.webp"
"MediaSize" => 65662
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29677814/thumbnail-c068f39abf7bd160e57d22182ccc8969.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40825314"
"ResourceRecordKey" => "29677814"
"ModificationTimestamp" => "2026-04-30T15:30:47.85Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "6639872370"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29677814/407bb2b3b599a880734fd5fee7a2090b.webp"
"MediaSize" => 74749
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29677814/thumbnail-407bb2b3b599a880734fd5fee7a2090b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40825314"
"ResourceRecordKey" => "29677814"
"ModificationTimestamp" => "2026-04-30T15:30:47.85Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "6639872471"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29677814/aa8170ff3a6b5897dd53480fbafc6d0d.webp"
"MediaSize" => 76990
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29677814/thumbnail-aa8170ff3a6b5897dd53480fbafc6d0d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40825314"
"ResourceRecordKey" => "29677814"
"ModificationTimestamp" => "2026-04-30T15:30:47.85Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "6639872561"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29677814/52f8359d38120a9bada4d2c81e1e4fca.webp"
"MediaSize" => 87594
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29677814/thumbnail-52f8359d38120a9bada4d2c81e1e4fca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40825314"
"ResourceRecordKey" => "29677814"
"ModificationTimestamp" => "2026-04-30T15:30:47.85Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "6639872667"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29677814/6e5aaec333703b882af340c2d02f0ac5.webp"
"MediaSize" => 64674
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29677814/thumbnail-6e5aaec333703b882af340c2d02f0ac5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40825314"
"ResourceRecordKey" => "29677814"
"ModificationTimestamp" => "2026-04-30T15:30:47.85Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "6639872771"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29677814/bae3d7fc373f6d24673b6bea7bad90a8.webp"
"MediaSize" => 92266
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29677814/thumbnail-bae3d7fc373f6d24673b6bea7bad90a8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40825314"
"ResourceRecordKey" => "29677814"
"ModificationTimestamp" => "2026-04-30T15:30:47.85Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "6639872874"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29677814/92f1eed1f48a3ab41e933cb474bd66d4.webp"
"MediaSize" => 106666
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29677814/thumbnail-92f1eed1f48a3ab41e933cb474bd66d4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40825314"
"ResourceRecordKey" => "29677814"
"ModificationTimestamp" => "2026-04-30T15:30:47.85Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "6639872984"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29677814/f8b67de3af82e87efcce90ee7338196d.webp"
"MediaSize" => 63744
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29677814/thumbnail-f8b67de3af82e87efcce90ee7338196d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40825314"
"ResourceRecordKey" => "29677814"
"ModificationTimestamp" => "2026-04-30T15:30:47.85Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "6639873089"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29677814/6e04c8ba391e1a7696cbeac11b591f00.webp"
"MediaSize" => 70949
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29677814/thumbnail-6e04c8ba391e1a7696cbeac11b591f00.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40825314"
"ResourceRecordKey" => "29677814"
"ModificationTimestamp" => "2026-04-30T15:30:47.85Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "6639873201"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29677814/d2f6660d5c55a41f5fd624e66bf23eed.webp"
"MediaSize" => 59950
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29677814/thumbnail-d2f6660d5c55a41f5fd624e66bf23eed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40825314"
"ResourceRecordKey" => "29677814"
"ModificationTimestamp" => "2026-04-30T15:30:47.85Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "6639873305"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29677814/28e20337a5e0034417052e95867da350.webp"
"MediaSize" => 70715
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29677814/thumbnail-28e20337a5e0034417052e95867da350.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40825314"
"ResourceRecordKey" => "29677814"
"ModificationTimestamp" => "2026-04-30T15:30:47.85Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "6639873449"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29677814/9af7585ad0611cc7fbe57a0bb646aebb.webp"
"MediaSize" => 75267
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29677814/thumbnail-9af7585ad0611cc7fbe57a0bb646aebb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40825314"
"ResourceRecordKey" => "29677814"
"ModificationTimestamp" => "2026-04-30T15:30:47.85Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "6639873554"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29677814/a5b8c9dff78469f24b673c9376546b06.webp"
"MediaSize" => 69106
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29677814/thumbnail-a5b8c9dff78469f24b673c9376546b06.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40825314"
"ResourceRecordKey" => "29677814"
"ModificationTimestamp" => "2026-04-30T15:30:47.85Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "6639873664"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29677814/26511614fa008d00543b8faa16f2bfad.webp"
"MediaSize" => 56777
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29677814/thumbnail-26511614fa008d00543b8faa16f2bfad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40825314"
"ResourceRecordKey" => "29677814"
"ModificationTimestamp" => "2026-04-30T15:30:47.85Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "6639873777"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29677814/393618222c3cb0e8857187070b70aac7.webp"
"MediaSize" => 70059
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29677814/thumbnail-393618222c3cb0e8857187070b70aac7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40825314"
"ResourceRecordKey" => "29677814"
"ModificationTimestamp" => "2026-04-30T15:30:47.85Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "6639873871"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29677814/c87dc9edf41bd00d15726944f437860e.webp"
"MediaSize" => 155929
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29677814/thumbnail-c87dc9edf41bd00d15726944f437860e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40825314"
"ResourceRecordKey" => "29677814"
"ModificationTimestamp" => "2026-04-30T15:30:47.85Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "6639873975"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29677814/51874ec7e527f1dd9a22ad96c7ce1f2a.webp"
"MediaSize" => 140789
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29677814/thumbnail-51874ec7e527f1dd9a22ad96c7ce1f2a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40825314"
"ResourceRecordKey" => "29677814"
"ModificationTimestamp" => "2026-04-30T15:30:47.85Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "6639874058"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29677814/5036d560c37df65780a7d48601737ce1.webp"
"MediaSize" => 174063
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29677814/thumbnail-5036d560c37df65780a7d48601737ce1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40825314"
"ResourceRecordKey" => "29677814"
"ModificationTimestamp" => "2026-04-30T15:30:47.85Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "6639874155"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29677814/3445973d6d699381675a80fa93123640.webp"
"MediaSize" => 183186
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29677814/thumbnail-3445973d6d699381675a80fa93123640.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40825314"
"ResourceRecordKey" => "29677814"
"ModificationTimestamp" => "2026-04-30T15:30:47.85Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "6639874237"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29677814/60263f3457948363bb411f8a9fbf6432.webp"
"MediaSize" => 100486
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29677814/thumbnail-60263f3457948363bb411f8a9fbf6432.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40825314"
"ResourceRecordKey" => "29677814"
"ModificationTimestamp" => "2026-04-30T15:30:47.85Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "6639874279"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29677814/3b6cc8c527ff0e37e6f61bf65122104f.webp"
"MediaSize" => 174941
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29677814/thumbnail-3b6cc8c527ff0e37e6f61bf65122104f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40825314"
"ResourceRecordKey" => "29677814"
"ModificationTimestamp" => "2026-04-30T15:30:47.85Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "6639874388"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29677814/5dca6e138efe32d9256efc5ffa6b4889.webp"
"MediaSize" => 164175
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29677814/thumbnail-5dca6e138efe32d9256efc5ffa6b4889.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40825314"
"ResourceRecordKey" => "29677814"
"ModificationTimestamp" => "2026-04-30T15:30:47.85Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "6639874478"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29677814/1e2acff880ac4f2e6533772d7f340bfa.webp"
"MediaSize" => 136414
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29677814/thumbnail-1e2acff880ac4f2e6533772d7f340bfa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40825314"
"ResourceRecordKey" => "29677814"
"ModificationTimestamp" => "2026-04-30T15:30:47.85Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "6639874552"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29677814/8161e1a959160230969c5910977f68c2.webp"
"MediaSize" => 155185
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29677814/thumbnail-8161e1a959160230969c5910977f68c2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40825314"
"ResourceRecordKey" => "29677814"
"ModificationTimestamp" => "2026-04-30T15:30:47.85Z"
]
44 => array:13 [
"Order" => 45
"MediaKey" => "6639874649"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29677814/404a970e658d5a917b8f39ce35d53838.webp"
"MediaSize" => 167661
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29677814/thumbnail-404a970e658d5a917b8f39ce35d53838.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40825314"
"ResourceRecordKey" => "29677814"
"ModificationTimestamp" => "2026-04-30T15:30:47.85Z"
]
45 => array:13 [
"Order" => 46
"MediaKey" => "6639874743"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29677814/f87794ccc1c16eb0b41acb4b5b5dfeb9.webp"
"MediaSize" => 162142
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29677814/thumbnail-f87794ccc1c16eb0b41acb4b5b5dfeb9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40825314"
"ResourceRecordKey" => "29677814"
"ModificationTimestamp" => "2026-04-30T15:30:47.85Z"
]
]
+"DaysOnMarket": 48
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29677814')"
+"ID": "1369702"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Cache Key: b5ccc3b593403067455942c5f1b964e3dc0bd4879cbba47da44af53292aa6cb5" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24558
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1523741" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24853
+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 '29677814'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25195
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29677814'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25212
+items: array:4 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25211
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31274481"
+"ListingKey": "29677814"
+"ListingId": "40825314"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-07"
+"OpenHouseStartTime": "2026-06-07T14:00:00Z"
+"OpenHouseEndTime": "2026-06-07T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-02T15:26:49Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31274481')"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25213
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31281531"
+"ListingKey": "29677814"
+"ListingId": "40825314"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-07"
+"OpenHouseStartTime": "2026-06-07T14:00:00Z"
+"OpenHouseEndTime": "2026-06-07T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-05T16:43:48Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31281531')"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25210
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31336419"
+"ListingKey": "29677814"
+"ListingId": "40825314"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-07"
+"OpenHouseStartTime": "2026-06-07T14:00:00Z"
+"OpenHouseEndTime": "2026-06-07T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-06T15:43:23Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31336419')"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25214
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31351214"
+"ListingKey": "29677814"
+"ListingId": "40825314"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-07"
+"OpenHouseStartTime": "2026-06-07T14:00:00Z"
+"OpenHouseEndTime": "2026-06-07T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-07T18:56:38Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31351214')"
}
]
+success: true
+page_size: 4
+page_count: 1
+count: 4
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29677814' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.8296953 43.2471667)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25312
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25286
+post_id: "1540942"
+post_author: 1
+"ListingKey": "29918407"
+"ListingId": "40840466"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T20:45:08Z"
+"RFModificationTimestamp": "2026-06-17T21:50:20Z"
+"ListPrice": 499900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1164.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8L7A3"
+"UnparsedAddress": "153 GAGE Avenue N, Hamilton, Ontario L8L7A3"
+"Coordinates": array:2 [
0 => -79.8268597
1 => 43.2528588
]
+"Latitude": 43.2528588
+"Longitude": -79.8268597
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Opportunity knocks at 153 Gage Ave N! This beautifully updated 3-bedroom home offers the perfect blend of timeless character, modern comfort, and unbeatable convenience in Hamilton's vibrant Central East neighbourhood. Walk to Tim Hortons Field, explore the trendy shops, cafés, restaurants, and local markets of the Ottawa Street North shopping district, or enjoy the gardens, trails, and year-round community events at nearby Gage Park. With quick access to the Red Hill Valley Parkway, Nikola Tesla Boulevard, the QEW, and public transit, commuting throughout Hamilton and the GTA is a breeze. Freshly painted from top to bottom, this move-in-ready home welcomes you with new tile flooring through the foyer, kitchen, and main floor powder room. The updated kitchen flows seamlessly into bright and inviting living and dining spaces, where original inlaid hardwood flooring, elegant coved ceilings, and beautiful stained-glass accents showcase the home's classic charm. The second floor has been completely refreshed with new luxury vinyl plank flooring throughout and features a spacious primary bedroom, two additional generously sized bedrooms, and a stunning brand-new 4-piece bathroom with a subway tile surround. Outside, you'll find a private backyard, detached single garage, and driveway parking for two additional vehicles. As an added bonus, the quiet church next door creates a uniquely peaceful setting rarely found in the city. Whether you're a first-time buyer, young family, or investor, this is an exceptional opportunity to own a beautifully updated home in one of Hamilton's most sought-after urban neighbourhoods. Don't miss your chance—schedule your private showing today and discover everything 153 Gage Ave N has to offer. (id:62783)"
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T21:50:13.575507+00:00"
+"Directions": "BEECHWOOD & GAGE"
+"ExteriorFeatures": array:5 [
0 => "Brick"
1 => "Aluminum siding"
2 => "Vinyl siding"
3 => "Metal"
4 => "Other"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2238484"
+"ListOfficeKey": "292003"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T20:39:46Z"
+"PhotosCount": 30
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T20:39:46Z"
+"Stories": "1.5"
+"StreetDirSuffix": "North"
+"StreetName": "GAGE"
+"StreetNumber": "153"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "200 - Gibson/Stipley"
+"TaxAnnualAmount": "2934.38"
+"Utilities": array:2 [
0 => "Natural Gas"
1 => "Cable"
]
+"VirtualTourURLUnbranded": "https://unbranded.iguidephotos.com/153_gage_ave_n_hamilton_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [
"RoomKey" => "1661470223"
"RoomType" => "Laundry room"
"ListingId" => "40840466"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29918407"
"RoomLength" => null
"RoomDimensions" => "1'1'' x 1'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T20:39:46.74Z"
]
1 => array:11 [
"RoomKey" => "1661470224"
"RoomType" => "4pc Bathroom"
"ListingId" => "40840466"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29918407"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T20:39:46.74Z"
]
2 => array:11 [
"RoomKey" => "1661470225"
"RoomType" => "Bedroom"
"ListingId" => "40840466"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29918407"
"RoomLength" => null
"RoomDimensions" => "9'0'' x 9'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T20:39:46.74Z"
]
3 => array:11 [
"RoomKey" => "1661470226"
"RoomType" => "Bedroom"
"ListingId" => "40840466"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29918407"
"RoomLength" => null
"RoomDimensions" => "9'11'' x 13'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T20:39:46.74Z"
]
4 => array:11 [
"RoomKey" => "1661470227"
"RoomType" => "Primary Bedroom"
"ListingId" => "40840466"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29918407"
"RoomLength" => null
"RoomDimensions" => "9'10'' x 14'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T20:39:46.74Z"
]
5 => array:11 [
"RoomKey" => "1661470228"
"RoomType" => "2pc Bathroom"
"ListingId" => "40840466"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29918407"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T20:39:46.74Z"
]
6 => array:11 [
"RoomKey" => "1661470229"
"RoomType" => "Living room/Dining room"
"ListingId" => "40840466"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29918407"
"RoomLength" => null
"RoomDimensions" => "10'2'' x 15'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T20:39:46.74Z"
]
7 => array:11 [
"RoomKey" => "1661470230"
"RoomType" => "Kitchen"
"ListingId" => "40840466"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29918407"
"RoomLength" => null
"RoomDimensions" => "7'2'' x 11'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T20:39:46.74Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29918407/153-gage-avenue-n-hamilton"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Alarm system"
]
+"ZoningDescription": "C"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 25.0
+"AboveGradeFinishedArea": 1164
+"OriginalEntryTimestamp": "2026-06-17T20:39:46.71Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1476314"
+"ListOfficeNationalAssociationId": "1407357"
+"Media": array:30 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29918407_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918407/0a00f4410027cf913e73aa6b77e41eb6.webp"
"MediaSize" => 152341
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918407/thumbnail-0a00f4410027cf913e73aa6b77e41eb6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40840466"
"ResourceRecordKey" => "29918407"
"ModificationTimestamp" => "2026-06-17T20:39:46.72Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29918407_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918407/cc9f99a649aa597e0b4c670a59724cae.webp"
"MediaSize" => 140388
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918407/thumbnail-cc9f99a649aa597e0b4c670a59724cae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840466"
"ResourceRecordKey" => "29918407"
"ModificationTimestamp" => "2026-06-17T20:39:46.72Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29918407_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918407/125af7d4fe28dca38cdf430d980a52f8.webp"
"MediaSize" => 169018
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918407/thumbnail-125af7d4fe28dca38cdf430d980a52f8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840466"
"ResourceRecordKey" => "29918407"
"ModificationTimestamp" => "2026-06-17T20:39:46.72Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29918407_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918407/9e479477490141645f5b3e1851b6efb9.webp"
"MediaSize" => 131795
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918407/thumbnail-9e479477490141645f5b3e1851b6efb9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840466"
"ResourceRecordKey" => "29918407"
"ModificationTimestamp" => "2026-06-17T20:39:46.72Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29918407_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918407/57ede431ba76d148c1cda0d8d9e2f133.webp"
"MediaSize" => 59218
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918407/thumbnail-57ede431ba76d148c1cda0d8d9e2f133.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840466"
"ResourceRecordKey" => "29918407"
"ModificationTimestamp" => "2026-06-17T20:39:46.72Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29918407_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918407/b6e5462f503d2e122a7cd55b7a50218c.webp"
"MediaSize" => 52660
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918407/thumbnail-b6e5462f503d2e122a7cd55b7a50218c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840466"
"ResourceRecordKey" => "29918407"
"ModificationTimestamp" => "2026-06-17T20:39:46.72Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29918407_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918407/2beb703cb2e5f987f2d53c9cf7db5aef.webp"
"MediaSize" => 74004
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918407/thumbnail-2beb703cb2e5f987f2d53c9cf7db5aef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840466"
"ResourceRecordKey" => "29918407"
"ModificationTimestamp" => "2026-06-17T20:39:46.72Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29918407_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918407/e20724d20620de5897e6f437344d278e.webp"
"MediaSize" => 64191
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918407/thumbnail-e20724d20620de5897e6f437344d278e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840466"
"ResourceRecordKey" => "29918407"
"ModificationTimestamp" => "2026-06-17T20:39:46.72Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29918407_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918407/5fcbab46eff986d568befc0bca373cd0.webp"
"MediaSize" => 59533
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29918407/thumbnail-5fcbab46eff986d568befc0bca373cd0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840466"
"ResourceRecordKey" => "29918407"
"ModificationTimestamp" => "2026-06-17T20:39:46.72Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29918407_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29918407/e51ac8704f7b46aeee84b207b3b00058.webp"
"MediaSize" => 66570
…9
]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29918407')"
+"ID": "1540942"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25288
+post_id: "1540758"
+post_author: 1
+"ListingKey": "29918518"
+"ListingId": "X13458494"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T21:05:10Z"
+"RFModificationTimestamp": "2026-06-17T21:32:22Z"
+"ListPrice": 499900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stipley)"
+"PostalCode": "L8L7A3"
+"UnparsedAddress": "153 GAGE AVENUE N, Hamilton (Stipley), Ontario L8L7A3"
+"Coordinates": array:2 [
0 => -79.826894
1 => 43.252865
]
+"Latitude": 43.252865
+"Longitude": -79.826894
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "The Oakville, Milton & District Real Estate Board"
+"PublicRemarks": "Opportunity knocks at 153 Gage Ave N! This beautifully updated 3-bedroom home offers the perfect blend of timeless character, modern comfort, and unbeatable convenience in Hamilton's vibrant Central East neighbourhood. Walk to Tim Hortons Field, explore the trendy shops, cafés, restaurants, and local markets of the Ottawa Street North shopping district, or enjoy the gardens, trails, and year-round community events at nearby Gage Park. With quick access to the Red Hill Valley Parkway, Nikola Tesla Boulevard, the QEW, and public transit, commuting throughout Hamilton and the GTA is a breeze.Freshly painted from top to bottom, this move-in-ready home welcomes you with new tile flooring through the foyer, kitchen, and main floor powder room. The updated kitchen flows seamlessly into bright and inviting living and dining spaces, where original inlaid hardwood flooring, elegant coved ceilings, and beautiful stained-glass accents showcase the home's classic charm.The second floor has been completely refreshed with new luxury vinyl plank flooring throughout and features a spacious primary bedroom, two additional generously sized bedrooms, and a stunning brand-new 4-piece bathroom with a subway tile surround. Outside, you'll find a private backyard, detached single garage, and driveway parking for two additional vehicles. As an added bonus, the quiet church next door creates a uniquely peaceful setting rarely found in the city.Whether you're a first-time buyer, young family, or investor, this is an exceptional opportunity to own a beautifully updated home in one of Hamilton's most sought-after urban neighbourhoods. Don't miss your chance-schedule your private showing today and discover everything 153 Gage Ave N has to offer. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T21:32:17.282341+00:00"
+"Directions": "Cross Streets: Barton & Gage. ** Directions: Beechwood & Gage."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:2 [
0 => "Hardwood"
1 => "Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2156692"
+"ListOfficeKey": "289818"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "25 x 83.5 FT ; + 25' X 9' Private Drive"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T20:56:55Z"
+"PhotosCount": 30
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T20:56:55Z"
+"Stories": "1.5"
+"StreetDirSuffix": "North"
+"StreetName": "Gage"
+"StreetNumber": "153"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "2934.38"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://unbranded.iguidephotos.com/153_gage_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": "Oakville-Milton"
+"CityRegion": "Stipley"
+"ListAORKey": "15"
+"ListingURL": "www.realtor.ca/real-estate/29918518/153-gage-avenue-n-hamilton-stipley-stipley"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1899457"
+"CommonInterest": "Freehold"
+"CoListAgentKey2": "1834162"
+"CoListOfficeKey": "292096"
+"GeocodeManualYN": false
+"CoListOfficeKey2": "293196"
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "Residential"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 25.0
+"OriginalEntryTimestamp": "2026-06-17T20:56:55.87Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1408090"
+"ListOfficeNationalAssociationId": "1381541"
+"CoListAgentNationalAssociationId": "1216506"
+"CoListAgentNationalAssociationId2": "1196633"
+"CoListOfficeNationalAssociationId": "1408169"
+"CoListOfficeNationalAssociationId2": "1423680"
+"Media": array:30 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29918518')"
+"ID": "1540758"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25285
+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 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
18 => array:11 [ …11]
19 => array:11 [ …11]
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"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25289
+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"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25287
+post_id: "1539331"
+post_author: 1
+"ListingKey": "29915829"
+"ListingId": "40840642"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T02:35:16Z"
+"RFModificationTimestamp": "2026-06-18T02:36:31Z"
+"ListPrice": 549000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1167.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8V3E7"
+"UnparsedAddress": "12 EAST 27TH Street, Hamilton, Ontario L8V3E7"
+"Coordinates": array:2 [
0 => -79.8469982
1 => 43.2390726
]
+"Latitude": 43.2390726
+"Longitude": -79.8469982
+"YearBuilt": 1949
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this 1 3/4 storey home across from Jurvavinski Hospital. 2 Car parking in your driveway is a pretty nice feature in this area! 3 Bedrooms and 4 piece bathroom upstairs, main floor living room, kitchen + separate dining room, while the lower level has a finished kitchenette, combined bathroom and laundry and a large bed/sitting area. All appliances and window treatments remain with the property. Did I mention central air? Furnace and roof done recently. Close to public transit, shopping and wonderful dining! For showings kindly park in the driveway. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T16:46:17.391947+00:00"
+"Directions": "Concession to south on East 27th."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524321"
+"ListOfficeKey": "55005"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-06-17T15:52:17Z"
+"PhotosCount": 26
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T02:20:24Z"
+"Stories": "2.0"
+"StreetName": "EAST 27TH"
+"StreetNumber": "12"
+"StreetSuffix": "Street"
+"SubdivisionName": "173 - Eastmount"
+"TaxAnnualAmount": "3447.03"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29915829/12-east-27th-street-hamilton"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1A"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 38.0
+"AboveGradeFinishedArea": 1167
+"OriginalEntryTimestamp": "2026-06-17T15:50:47.31Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1129763"
+"ListOfficeNationalAssociationId": "1003711"
+"Media": array:26 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29915829')"
+"ID": "1539331"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25282
+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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29914178')"
+"ID": "1537903"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23376
+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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29913998')"
+"ID": "1537636"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25290
+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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29913830')"
+"ID": "1537581"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25311
+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"
}
]
+success: true
+page_size: 9
+page_count: 39
+count: 347
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]