array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29928374 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23380
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23382
+post_id: "1547780"
+post_author: 1
+"ListingKey": "29928374"
+"ListingId": "40841344"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T19:20:39Z"
+"RFModificationTimestamp": "2026-06-19T19:28:59Z"
+"ListPrice": 539000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1625.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8L7E1"
+"UnparsedAddress": "21 EAST BEND Avenue, Hamilton, Ontario L8L7E1"
+"Coordinates": array:2 [
0 => -79.8268695
1 => 43.247562
]
+"Latitude": 43.247562
+"Longitude": -79.8268695
+"YearBuilt": 1920
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 21 East Bend Avenue N, a beautifully refreshed detached home in Hamilton’s sought-after Crown Point neighbourhood. Offering over 1600 sq. ft. of finished living space across 2.5 storeys, this move-in-ready property combines character, flexibility, and thoughtful updates throughout. The bright and inviting interior features a versatile main-floor bedroom, spacious living and dining areas, fresh paint throughout and new interior finishes. The eat-in kitchen offers abundant cabinetry, generous counter space, stainless steel appliances, and custom banquette seating. A bright main floor office overlooks the private backyard with mature trees. Upstairs, you’ll find two spacious bedrooms, convenient second-floor laundry, and a well-appointed 4-piece bathroom. The finished third floor loft/bonus room adds valuable living space, for a studio, playroom, office, fitness area, or guest retreat. Major improvements completed in 2026 include replacement of the lead water service line, new appliances, electrical upgrades, HVAC improvements, interior updates throughout the home, and a new front walkway. Outside, enjoy a fully fenced backyard with a deck, garden space, storage shed, and driveway parking. Ideally located just steps from Ottawa Street’s shops and restaurants, Gage Park, schools, and transit. This home offers an exceptional opportunity for first-time buyers, growing families, professionals, or investors. Come and take a look today! (id:62650)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T17:02:55.046577+00:00"
+"Directions": "From King Street East, North onto East Bend North"
+"ExteriorFeatures": array:2 [
0 => "Stucco"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Stone"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2006979"
+"ListOfficeKey": "284639"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-06-19T19:02:44Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T19:02:44Z"
+"Stories": "2.5"
+"StreetName": "EAST BEND"
+"StreetNumber": "21"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "201 - Crown Point"
+"TaxAnnualAmount": "3461.49"
+"VirtualTourURLUnbranded": "https://youriguide.com/21_east_bend_ave_n_hamilton_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [
"RoomKey" => "1663184573"
"RoomType" => "Recreation room"
"ListingId" => "40841344"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29928374"
"RoomLength" => null
"RoomDimensions" => "10'11'' x 28'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T18:50:48.38Z"
]
1 => array:11 [
"RoomKey" => "1663184574"
"RoomType" => "Primary Bedroom"
"ListingId" => "40841344"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29928374"
"RoomLength" => null
"RoomDimensions" => "9'10'' x 15'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T18:50:48.38Z"
]
2 => array:11 [
"RoomKey" => "1663184575"
"RoomType" => "Bedroom"
"ListingId" => "40841344"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29928374"
"RoomLength" => null
"RoomDimensions" => "9'1'' x 10'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T18:50:48.38Z"
]
3 => array:11 [
"RoomKey" => "1663184576"
"RoomType" => "4pc Bathroom"
"ListingId" => "40841344"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29928374"
"RoomLength" => null
"RoomDimensions" => "10'1'' x 10'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T18:50:48.38Z"
]
4 => array:11 [
"RoomKey" => "1663184577"
"RoomType" => "Laundry room"
"ListingId" => "40841344"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29928374"
"RoomLength" => null
"RoomDimensions" => "5'4'' x 6'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T18:50:48.38Z"
]
5 => array:11 [
"RoomKey" => "1663184578"
"RoomType" => "2pc Bathroom"
"ListingId" => "40841344"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29928374"
"RoomLength" => null
"RoomDimensions" => "4'0'' x 6'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T18:50:48.38Z"
]
6 => array:11 [
"RoomKey" => "1663184579"
"RoomType" => "Office"
"ListingId" => "40841344"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29928374"
"RoomLength" => null
"RoomDimensions" => "6'5'' x 10'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T18:50:48.39Z"
]
7 => array:11 [
"RoomKey" => "1663184580"
"RoomType" => "Dining room"
"ListingId" => "40841344"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29928374"
"RoomLength" => null
"RoomDimensions" => "8'2'' x 12'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T18:50:48.39Z"
]
8 => array:11 [
"RoomKey" => "1663184581"
"RoomType" => "Kitchen"
"ListingId" => "40841344"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29928374"
"RoomLength" => null
"RoomDimensions" => "7'9'' x 10'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T18:50:48.39Z"
]
9 => array:11 [
"RoomKey" => "1663184582"
"RoomType" => "Living room"
"ListingId" => "40841344"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29928374"
"RoomLength" => null
"RoomDimensions" => "12'9'' x 13'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T18:50:48.39Z"
]
10 => array:11 [
"RoomKey" => "1663184583"
"RoomType" => "Bedroom"
"ListingId" => "40841344"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29928374"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 11'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T18:50:48.39Z"
]
11 => array:11 [
"RoomKey" => "1663184584"
"RoomType" => "Foyer"
"ListingId" => "40841344"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29928374"
"RoomLength" => null
"RoomDimensions" => "4'10'' x 10'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T18:50:48.4Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29928374/21-east-bend-avenue-hamilton"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "D"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 25.0
+"AboveGradeFinishedArea": 1625
+"OriginalEntryTimestamp": "2026-06-19T15:50:30.34Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1289115"
+"ListOfficeNationalAssociationId": "1344653"
+"Media": array:49 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29928374_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/18837bc02e0b1713d9730071a5a4785c.webp"
"MediaSize" => 159369
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-18837bc02e0b1713d9730071a5a4785c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:39.44Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29928374_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/144d60a76a2ad0865454dda59e524755.webp"
"MediaSize" => 196664
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-144d60a76a2ad0865454dda59e524755.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:39.44Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29928374_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/10f7a251a8c7b6b6b264ad10354045cc.webp"
"MediaSize" => 172058
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-10f7a251a8c7b6b6b264ad10354045cc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:39.48Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29928374_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/3c18001db673812ab87b92fd9ea38e30.webp"
"MediaSize" => 159451
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-3c18001db673812ab87b92fd9ea38e30.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:39.45Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29928374_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/2a6cda344325f81abe3cd502f9968ae2.webp"
"MediaSize" => 146727
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-2a6cda344325f81abe3cd502f9968ae2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:39.11Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29928374_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/c4ad229a5271051028f6264bd14dba58.webp"
"MediaSize" => 51737
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-c4ad229a5271051028f6264bd14dba58.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:39.43Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29928374_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/d209adf5bea82b099b882b4c8f7f5a2c.webp"
"MediaSize" => 51881
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-d209adf5bea82b099b882b4c8f7f5a2c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:39.97Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29928374_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/5e2a078889979f2ba2158e05abf165ba.webp"
"MediaSize" => 78620
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-5e2a078889979f2ba2158e05abf165ba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:39.45Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29928374_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/4512830cfc3a7d64b3de419c6d4d5ea6.webp"
"MediaSize" => 50975
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-4512830cfc3a7d64b3de419c6d4d5ea6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:39.92Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29928374_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/de55cd21dd50a4048a3f9c8835ea2722.webp"
"MediaSize" => 40056
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-de55cd21dd50a4048a3f9c8835ea2722.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:39.49Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29928374_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/eac42b2e9f98c6a541272b96c9b7c8c8.webp"
"MediaSize" => 88824
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-eac42b2e9f98c6a541272b96c9b7c8c8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:39.92Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29928374_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/14b1f7ee994da041e5fe2928a17bfbca.webp"
"MediaSize" => 57870
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-14b1f7ee994da041e5fe2928a17bfbca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:39.45Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29928374_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/a2a6be3089e3db63372fd83b4320beaa.webp"
"MediaSize" => 49350
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-a2a6be3089e3db63372fd83b4320beaa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:39.44Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29928374_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/dd19d7be6093616becfee48600116fe4.webp"
"MediaSize" => 57433
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-dd19d7be6093616becfee48600116fe4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:39.46Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29928374_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/77193b6047b347cb62764c9157c1ea2d.webp"
"MediaSize" => 61795
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-77193b6047b347cb62764c9157c1ea2d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:39.44Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29928374_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/590494d60c749ec52b66f0e4c88d8237.webp"
"MediaSize" => 64225
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-590494d60c749ec52b66f0e4c88d8237.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:39.44Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29928374_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/e4de171717dfb7a62928609aa533d92a.webp"
"MediaSize" => 75500
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-e4de171717dfb7a62928609aa533d92a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:39.49Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29928374_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/0d26a73c5855151becec8eb48f741294.webp"
"MediaSize" => 64975
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-0d26a73c5855151becec8eb48f741294.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:39.44Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29928374_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/5ae5b25f304bab38eeaa86c8a44f08d5.webp"
"MediaSize" => 69808
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-5ae5b25f304bab38eeaa86c8a44f08d5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:39.99Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29928374_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/ef3daafce1907b3b640ef5f557f415bc.webp"
"MediaSize" => 56641
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-ef3daafce1907b3b640ef5f557f415bc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:39.96Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29928374_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/6b897914aca412086941e7190059f860.webp"
"MediaSize" => 59269
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-6b897914aca412086941e7190059f860.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:39.97Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29928374_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/5faa32d205ae4dee869b55d339c6b187.webp"
"MediaSize" => 64151
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-5faa32d205ae4dee869b55d339c6b187.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:40.26Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29928374_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/96791f57561261f399d8b8381b8928b3.webp"
"MediaSize" => 121765
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-96791f57561261f399d8b8381b8928b3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:39.96Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29928374_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/bcd858390b6c3db44c9b37b09e66c053.webp"
"MediaSize" => 81635
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-bcd858390b6c3db44c9b37b09e66c053.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:39.97Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29928374_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/d97c81d3736a7b10b964590a6256333c.webp"
"MediaSize" => 32719
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-d97c81d3736a7b10b964590a6256333c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:43.14Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29928374_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/f9e1177e413ecc748f1cf76debc33ec9.webp"
"MediaSize" => 44800
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-f9e1177e413ecc748f1cf76debc33ec9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:43.14Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29928374_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/0e5edff2be4b4b57d9e60a167884aceb.webp"
"MediaSize" => 73871
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-0e5edff2be4b4b57d9e60a167884aceb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:43.14Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29928374_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/e96c8af846a789cd7f4b97827657d0b0.webp"
"MediaSize" => 63849
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-e96c8af846a789cd7f4b97827657d0b0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:39.96Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29928374_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/a38a1614144b5f8a8c48f1a2690f83c8.webp"
"MediaSize" => 71515
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-a38a1614144b5f8a8c48f1a2690f83c8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:40.44Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29928374_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/77ddf90fb40735788214a7748f9d80ce.webp"
"MediaSize" => 54425
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-77ddf90fb40735788214a7748f9d80ce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:39.97Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29928374_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/c214915d93def2044fbfde7715522f06.webp"
"MediaSize" => 50273
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-c214915d93def2044fbfde7715522f06.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:40.26Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29928374_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/e5efb4857bffd7130ee1f2b01534b2e5.webp"
"MediaSize" => 52000
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-e5efb4857bffd7130ee1f2b01534b2e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:39.96Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29928374_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/8288e1de7cc25c762d4ab5a18fea46c6.webp"
"MediaSize" => 84889
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-8288e1de7cc25c762d4ab5a18fea46c6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:40.44Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29928374_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/997f0104e7584d8712d70fa4b6ffb45e.webp"
"MediaSize" => 69364
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-997f0104e7584d8712d70fa4b6ffb45e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:39.97Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29928374_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/1e40b99b5377c2d15d2a32da2bd6d224.webp"
"MediaSize" => 51356
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-1e40b99b5377c2d15d2a32da2bd6d224.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:40.26Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29928374_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/51b09ef296f1d9d6d462e209f2f0a2da.webp"
"MediaSize" => 51009
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-51b09ef296f1d9d6d462e209f2f0a2da.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:40.44Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29928374_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/24843e1704092d1384dc74fe7e389d81.webp"
"MediaSize" => 53198
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-24843e1704092d1384dc74fe7e389d81.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:40.26Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29928374_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/73466950c01c362918919bf1655ae76b.webp"
"MediaSize" => 39403
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-73466950c01c362918919bf1655ae76b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:39.96Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29928374_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/d5260ad3227e14075fab4c5de360c5ea.webp"
"MediaSize" => 79793
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-d5260ad3227e14075fab4c5de360c5ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:40.44Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29928374_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/8c482f621f44c00704bc91e428f05548.webp"
"MediaSize" => 68818
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-8c482f621f44c00704bc91e428f05548.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:40.46Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29928374_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/f4ce840d3e990627da8213da0645d02e.webp"
"MediaSize" => 62831
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-f4ce840d3e990627da8213da0645d02e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:40.44Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29928374_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/a764c47315fa95cc3e3cb43ade94f319.webp"
"MediaSize" => 48139
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-a764c47315fa95cc3e3cb43ade94f319.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:39.95Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29928374_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/a4c33a32742f934b5020c0508e396c52.webp"
"MediaSize" => 56143
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-a4c33a32742f934b5020c0508e396c52.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:39.96Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "29928374_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/7943590b4d81820b8d5cdb212ac3a23c.webp"
"MediaSize" => 55992
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-7943590b4d81820b8d5cdb212ac3a23c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:40.44Z"
]
44 => array:13 [
"Order" => 45
"MediaKey" => "29928374_4890_45"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/8ea45bfef78e25b13f06e6d05f24e657.webp"
"MediaSize" => 174135
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-8ea45bfef78e25b13f06e6d05f24e657.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:40.26Z"
]
45 => array:13 [
"Order" => 46
"MediaKey" => "29928374_4890_46"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/831fe90a09260f49954e1270bd546949.webp"
"MediaSize" => 202292
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-831fe90a09260f49954e1270bd546949.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:40.44Z"
]
46 => array:13 [
"Order" => 47
"MediaKey" => "29928374_4890_47"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/c2123eec59a322bf5a65384e5ac81272.webp"
"MediaSize" => 47063
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-c2123eec59a322bf5a65384e5ac81272.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T19:02:44.69Z"
]
47 => array:13 [
"Order" => 48
"MediaKey" => "29928374_4890_48"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/866e9dea482fdabe3fc0649565115adf.webp"
"MediaSize" => 43399
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-866e9dea482fdabe3fc0649565115adf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T19:02:44.68Z"
]
48 => array:13 [
"Order" => 49
"MediaKey" => "29928374_4890_49"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/93f8442eb3fab610b24a45c7df2eb540.webp"
"MediaSize" => 16003
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-93f8442eb3fab610b24a45c7df2eb540.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T19:02:44.68Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29928374')"
+"ID": "1547780"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 284639" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24896
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2006979" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24869
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29928374'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25217
+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 '29928374'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25233
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29928374' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.8268695 43.247562)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25306
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25300
+post_id: "1549407"
+post_author: 1
+"ListingKey": "29930555"
+"ListingId": "40841553"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T20:10:02Z"
+"RFModificationTimestamp": "2026-06-19T21:33:38Z"
+"ListPrice": 679850.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1775.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8K2M9"
+"UnparsedAddress": "101 HOUGHTON Avenue S, Hamilton, Ontario L8K2M9"
+"Coordinates": array:2 [
0 => -79.8149882
1 => 43.2384698
]
+"Latitude": 43.2384698
+"Longitude": -79.8149882
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "A fresh opportunity to own this beautifully renovated home in a sought-after, family-friendly Hamilton neighbourhood! Offering nearly 2,000 sq ft of finished living space, 101 Houghton Avenue South blends stylish updates, quality craftsmanship, and an ideal location just steps to A.M. Cunningham Elementary School, with Gage Park and the vibrant shops, restaurants, and boutiques of Ottawa Street North just a short stroll away. The inviting main floor features a new front porch, enclosed entry with leaded glass windows, spacious foyer, wide-plank flooring, pot lighting, and a bright open living room with picture window, shiplap feature wall, and linear fireplace. The dining area offers built-in cabinetry, a stained glass window, and walkout to a fully finished four-season sunroom overlooking the private rear yard. The updated open-concept kitchen is designed for everyday living and entertaining, featuring modern cabinetry, quartz counters, ceramic backsplash, stainless steel appliances, and a peninsula with seating. Upstairs offers two generous bedrooms and a 4-piece bath with convenient laundry. The finished lower level provides excellent additional living space with a rec room, bedroom, and 3-piece bath-ideal for guests, teens, or extended family. Private side drive leads to a detached garage with hydro and automatic opener. Extensive updates include flooring, trim, pot lights, fresh paint, electrical, plumbing, vinyl siding on house and garage, appliances, furnace, central air, 100-amp breakers, and professionally waterproofed basement with sump. Move-in ready, stylishly finished, and now offered at a new price-don't miss it! (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Garage door opener"
6 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T21:33:27.002869+00:00"
+"Directions": "Between Maple Ave and Central Ave"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524687"
+"ListOfficeKey": "284640"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Paved driveway"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-06-19T19:52:40Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T19:52:40Z"
+"Stories": "1.5"
+"StreetDirSuffix": "South"
+"StreetName": "HOUGHTON"
+"StreetNumber": "101"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "222 - Delta"
+"TaxAnnualAmount": "3883"
+"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=8sLUDBNRZG8"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [
"RoomKey" => "1663230775"
"RoomType" => "Utility room"
"ListingId" => "40841553"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29930555"
"RoomLength" => null
"RoomDimensions" => "16'8'' x 8'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T19:51:10.23Z"
]
1 => array:11 [
"RoomKey" => "1663230776"
"RoomType" => "Bedroom"
"ListingId" => "40841553"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29930555"
"RoomLength" => null
"RoomDimensions" => "9'7'' x 11'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T19:51:10.24Z"
]
2 => array:11 [
"RoomKey" => "1663230777"
"RoomType" => "3pc Bathroom"
"ListingId" => "40841553"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29930555"
"RoomLength" => null
"RoomDimensions" => "7'5'' x 5'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T19:51:10.24Z"
]
3 => array:11 [
"RoomKey" => "1663230779"
"RoomType" => "Recreation room"
"ListingId" => "40841553"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29930555"
"RoomLength" => null
"RoomDimensions" => "14'4'' x 20'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T19:51:10.25Z"
]
4 => array:11 [
"RoomKey" => "1663230780"
"RoomType" => "Bedroom"
"ListingId" => "40841553"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29930555"
"RoomLength" => null
"RoomDimensions" => "10'5'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T19:51:10.25Z"
]
5 => array:11 [
"RoomKey" => "1663230781"
"RoomType" => "4pc Bathroom"
"ListingId" => "40841553"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29930555"
"RoomLength" => null
"RoomDimensions" => "6'2'' x 8'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T19:51:10.25Z"
]
6 => array:11 [
"RoomKey" => "1663230782"
"RoomType" => "Primary Bedroom"
"ListingId" => "40841553"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29930555"
"RoomLength" => null
"RoomDimensions" => "11'1'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T19:51:10.25Z"
]
7 => array:11 [
"RoomKey" => "1663230783"
"RoomType" => "Sunroom"
"ListingId" => "40841553"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29930555"
"RoomLength" => null
"RoomDimensions" => "8'7'' x 14'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T19:51:10.25Z"
]
8 => array:11 [
"RoomKey" => "1663230785"
"RoomType" => "Living room"
"ListingId" => "40841553"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29930555"
"RoomLength" => null
"RoomDimensions" => "19'8'' x 11'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T19:51:10.25Z"
]
9 => array:11 [
"RoomKey" => "1663230787"
"RoomType" => "Dining room"
"ListingId" => "40841553"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29930555"
"RoomLength" => null
"RoomDimensions" => "13'5'' x 9'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T19:51:10.25Z"
]
10 => array:11 [
"RoomKey" => "1663230789"
"RoomType" => "Eat in kitchen"
"ListingId" => "40841553"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29930555"
"RoomLength" => null
"RoomDimensions" => "13'5'' x 11'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T19:51:10.25Z"
]
11 => array:11 [
"RoomKey" => "1663230791"
"RoomType" => "Foyer"
"ListingId" => "40841553"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29930555"
"RoomLength" => null
"RoomDimensions" => "5'0'' x 6'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T19:51:10.25Z"
]
12 => array:11 [
"RoomKey" => "1663230793"
"RoomType" => "Porch"
"ListingId" => "40841553"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29930555"
"RoomLength" => null
"RoomDimensions" => "6'4'' x 8'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T19:51:10.25Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29930555/101-houghton-avenue-s-hamilton"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1628810"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "262629"
+"GeocodeManualYN": true
+"ZoningDescription": "D"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 32.0
+"AboveGradeFinishedArea": 1138
+"BelowGradeFinishedArea": 637
+"OriginalEntryTimestamp": "2026-06-19T19:51:10.14Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"BelowGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1063164"
+"ListOfficeNationalAssociationId": "1344651"
+"CoListAgentNationalAssociationId": "1161564"
+"CoListOfficeNationalAssociationId": "1223032"
+"Media": array:40 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29930555_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930555/2b55c17f2c0185783351ccbdc687a305.webp"
"MediaSize" => 107561
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930555/thumbnail-2b55c17f2c0185783351ccbdc687a305.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40841553"
"ResourceRecordKey" => "29930555"
"ModificationTimestamp" => "2026-06-19T19:52:35.51Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29930555_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930555/9c60d93a626dfc4112387148d65ee297.webp"
"MediaSize" => 67568
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930555/thumbnail-9c60d93a626dfc4112387148d65ee297.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841553"
"ResourceRecordKey" => "29930555"
"ModificationTimestamp" => "2026-06-19T19:52:35.54Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29930555_4890_3"
…11
]
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29930555')"
+"ID": "1549407"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25302
+post_id: "1548608"
+post_author: 1
+"ListingKey": "29928705"
+"ListingId": "40841010"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T17:00:05Z"
+"RFModificationTimestamp": "2026-06-19T19:48:41Z"
+"ListPrice": 499900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0.06
+"LivingArea": 1218.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8H2E9"
+"UnparsedAddress": "144 CAMPBELL Avenue, Hamilton, Ontario L8H2E9"
+"Coordinates": array:2 [
0 => -79.8149446
1 => 43.2489535
]
+"Latitude": 43.2489535
+"Longitude": -79.8149446
+"YearBuilt": 1911
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Offered for the first time in nearly 37 years, this impeccably maintained home showcases exceptional pride of ownership. Major updates include a new furnace and central air conditioner (2024), with windows and roof replaced within the past 10–15 years. Originally designed as a 3-bedroom home, the current layout features expanded main-floor living space that can easily be converted back to a third bedroom. The bright basement features three above-grade windows, abundant natural light, and flexible space for a recreation room, home office, gym, workshop, or additional living area. Outside, enjoy a large deck, spacious concrete patio, and a separately gated grass yard ideal for children, pets, or gardening. Situated in sought-after Crown Point East, this home offers access to one of Hamilton’s most vibrant and family-friendly neighbourhoods. Steps from BGC Hamilton-Halton and minutes from Ottawa Street, you’ll enjoy popular cafés, restaurants, boutiques, the farmers market, and year-round community events. Nearby Gage Park, excellent schools, recreation facilities, and shopping at The Centre on Barton add everyday convenience. With its strong sense of community, walkable amenities, and enduring appeal, Crown Point East remains one of Hamilton’s most desirable neighbourhoods. A rare opportunity to own a lovingly cared-for home in an exceptional location (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"ConstructionMaterials": array:3 [
0 => "Wood frame"
1 => "Concrete block"
2 => "Concrete Walls"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T19:48:31.798047+00:00"
+"ExteriorFeatures": array:3 [
0 => "Concrete"
1 => "Wood"
2 => "Aluminum siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1968432"
+"ListOfficeKey": "283457"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "0.06"
+"PhotosChangeTimestamp": "2026-06-19T16:32:48Z"
+"PhotosCount": 35
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T16:50:47Z"
+"Stories": "1.5"
+"StreetName": "CAMPBELL"
+"StreetNumber": "144"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "201 - Crown Point"
+"TaxAnnualAmount": "2974.32"
+"VirtualTourURLUnbranded": "https://youriguide.com/144_campbell_ave_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/29928705/144-campbell-avenue-hamilton"
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1974543"
+"CommonInterest": "Freehold"
+"CoListAgentKey2": "2152293"
+"CoListOfficeKey": "283457"
+"GeocodeManualYN": true
+"CoListOfficeKey2": "268714"
+"ZoningDescription": "D"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 25.0
+"AboveGradeFinishedArea": 1218
+"OriginalEntryTimestamp": "2026-06-19T16:32:48.81Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1256115"
+"ListOfficeNationalAssociationId": "1330157"
+"CoListAgentNationalAssociationId": "1261397"
+"CoListAgentNationalAssociationId2": "1403942"
+"CoListOfficeNationalAssociationId": "1330157"
+"CoListOfficeNationalAssociationId2": "1230749"
+"Media": array:35 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29928705')"
+"ID": "1548608"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25299
+post_id: "1548379"
+post_author: 1
+"ListingKey": "29929311"
+"ListingId": "X13467578"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T22:05:27Z"
+"RFModificationTimestamp": "2026-06-19T22:07:47Z"
+"ListPrice": 499900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Crown Point)"
+"PostalCode": "L8H2E9"
+"UnparsedAddress": "144 CAMPBELL AVENUE, Hamilton (Crown Point), Ontario L8H2E9"
+"Coordinates": array:2 [
0 => -79.8149843
1 => 43.2488927
]
+"Latitude": 43.2488927
+"Longitude": -79.8149843
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Offered for the first time in nearly 37 years, this impeccably maintained home showcases exceptional pride of ownership. Major updates include a new furnace and central air conditioner (2024), with windows and roof replaced within the past 10-15 years. Originally designed as a 3-bedroom home, the current layout features expanded main-floor living space that can easily be converted back to a third bedroom.The bright basement features three above-grade windows, abundant natural light, and flexible space for a recreation room, home office, gym, workshop, or additional living area. Outside, enjoy a large deck, spacious concrete patio, and a separately gated grass yard ideal for children, pets, or gardening.Situated in sought-after Crown Point East, this home offers access to one of Hamilton's most vibrant and family-friendly neighbourhoods. Steps from BGC Hamilton-Halton and minutes from Ottawa Street, you'll enjoy popular cafés, restaurants, boutiques, the farmers market, and year-round community events. Nearby Gage Park, excellent schools, recreation facilities, and shopping at The Centre on Barton add everyday convenience. With its strong sense of community, walkable amenities, and enduring appeal, Crown Point East remains one of Hamilton's most desirable neighbourhoods. A rare opportunity to own a lovingly cared-for home in an exceptional location (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Window Coverings"
5 => "Water Heater"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Partial"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T19:28:31.488022+00:00"
+"Directions": "Cross Streets: Ottawa St N. ** Directions: Main Street E to Ottawa Street N to Campbell Ave."
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1970825"
+"ListOfficeKey": "269164"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "25.1 x 100.1 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-19T21:36:55Z"
+"PhotosCount": 35
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T21:37:47Z"
+"Stories": "1.5"
+"StreetName": "Campbell"
+"StreetNumber": "144"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "2974.32"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/144_campbell_ave_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": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Crown Point"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29929311/144-campbell-avenue-hamilton-crown-point-crown-point"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2222132"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "269164"
+"GeocodeManualYN": true
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 2
+"FrontageLengthNumeric": 25.1
+"OriginalEntryTimestamp": "2026-06-19T17:30:07.12Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1258103"
+"ListOfficeNationalAssociationId": "1243249"
+"CoListAgentNationalAssociationId": "1465800"
+"CoListOfficeNationalAssociationId": "1243249"
+"Media": array:35 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29929311')"
+"ID": "1548379"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25303
+post_id: "1547908"
+post_author: 1
+"ListingKey": "29928394"
+"ListingId": "40838308"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T21:25:31Z"
+"RFModificationTimestamp": "2026-06-19T21:30:24Z"
+"ListPrice": 514900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1281.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8H4Z1"
+"UnparsedAddress": "77 CAMERON Avenue N, Hamilton, Ontario L8H4Z1"
+"Coordinates": array:2 [
0 => -79.8061651
1 => 43.242541
]
+"Latitude": 43.242541
+"Longitude": -79.8061651
+"YearBuilt": 1928
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Great Family Home! Nestled on a mature street, this spacious home offers comfort, functionality, and move-in-ready appeal. Enjoy a morning beverage, relaxing or greeting neighbours from the charming front deck, while the enclosed foyer helps keep the interior organized and clutter-free. Inside, you'll find carpet-free living and neutral décor throughout. The cozy living room flows into a separate dining area featuring wainscotting and crown moulding, while the bright white kitchen offers a built-in dishwasher, double sink, ample cabinetry, and a convenient pass-through to the living room. A versatile bonus/flex space with patio door access to the backyard and a second full bathroom adds even more functionality. Upstairs, you'll find three well-sized bedrooms and a well-appointed 4-piece bathroom, including a primary bedroom with trendy wainscotting and a deeper closet. The blank canvas basement provides excellent storage or the opportunity to create additional living space to suit your needs. Outside, the fully fenced private backyard boasts a deck, patio, grassy area, and garden shed—perfect for children, pets, and summer entertaining. Additional highlights include a roof replaced in 2022, and most windows replaced in 2022 (excluding the main-level bathroom and side windows). Ideally located close to public transit, the library, schools, parks, and shopping. Just unpack and move in! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Hood Fan"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T17:03:09.218473+00:00"
+"Directions": "Kenilworth and Dunsmure to Cameron Ave N"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Other"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524684"
+"ListOfficeKey": "283457"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "None"
]
+"PhotosChangeTimestamp": "2026-06-19T15:51:13Z"
+"PhotosCount": 38
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T20:51:34Z"
+"Stories": "2.0"
+"StreetDirSuffix": "North"
+"StreetName": "CAMERON"
+"StreetNumber": "77"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "231 - Homeside"
+"TaxAnnualAmount": "3285.76"
+"VirtualTourURLUnbranded": "https://youriguide.com/77_cameron_ave_n_hamilton_on/"
+"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/29928394/77-cameron-avenue-n-hamilton"
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1528670"
+"CommonInterest": "Freehold"
+"CoListAgentKey2": "2091490"
+"CoListOfficeKey": "268714"
+"GeocodeManualYN": true
+"CoListOfficeKey2": "268714"
+"ZoningDescription": "R1a"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 25.0
+"AboveGradeFinishedArea": 1281
+"OriginalEntryTimestamp": "2026-06-19T15:51:12.99Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1063363"
+"ListOfficeNationalAssociationId": "1330157"
+"CoListAgentNationalAssociationId": "1140396"
+"CoListAgentNationalAssociationId2": "1364069"
+"CoListOfficeNationalAssociationId": "1230749"
+"CoListOfficeNationalAssociationId2": "1230749"
+"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('29928394')"
+"ID": "1547908"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25301
+post_id: "1547652"
+post_author: 1
+"ListingKey": "29928455"
+"ListingId": "X13466832"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T16:20:09Z"
+"RFModificationTimestamp": "2026-06-19T16:57:17Z"
+"ListPrice": 689900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Gibson)"
+"PostalCode": "L8M2N3"
+"UnparsedAddress": "28 ST CLAIR AVENUE, Hamilton (Gibson), Ontario L8M2N3"
+"Coordinates": array:2 [
0 => -79.839976
1 => 43.250539
]
+"Latitude": 43.250539
+"Longitude": -79.839976
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Prestigious St. Clair Avenue! This one-of-a-kind on the street, character-filled home offers timeless elegance and exceptional warmth throughout. Featuring beautiful leaded and bevelled glass windows, a unique turret feature, custom built-ins, and a separate formal dining room, this home is full of unique charm. The inviting den just off the kitchen provides the perfect space for a home office, reading nook, or family retreat.The basement adds valuable living space with a walk-up to a private backyard ideal for relaxing or entertaining. A rare opportunity to own a distinguished home in one of the area's most sought-after locations. Schedule your private viewing today! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Water Heater"
]
+"Basement": array:5 [
0 => "Partially finished"
1 => "Full"
2 => "Walk-up"
3 => "N/A"
4 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T16:57:13.774771+00:00"
+"Directions": "Cross Streets: Sherman Ave S. ** Directions: King St E to St. Clair Ave."
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2236294"
+"ListOfficeKey": "50984"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "29 x 90.6 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-19T15:59:10Z"
+"PhotosCount": 48
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T15:59:10Z"
+"Stories": "2.0"
+"StreetName": "St Clair"
+"StreetNumber": "28"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "4547.12"
+"VirtualTourURLUnbranded": "https://www.venturehomes.ca/trebtour.asp?tourid=70336"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Gibson"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29928455/28-st-clair-avenue-hamilton-gibson-gibson"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 29.0
+"OriginalEntryTimestamp": "2026-06-19T15:59:10.08Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1474342"
+"ListOfficeNationalAssociationId": "1001061"
+"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('29928455')"
+"ID": "1547652"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25276
+post_id: "1547606"
+post_author: 1
+"ListingKey": "29928216"
+"ListingId": "X13466508"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T22:00:12Z"
+"RFModificationTimestamp": "2026-06-19T22:00:47Z"
+"ListPrice": 499990.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Landsdale)"
+"PostalCode": "L8L5V6"
+"UnparsedAddress": "137 WENTWORTH STREET N, Hamilton (Landsdale), Ontario L8L5V6"
+"Coordinates": array:2 [
0 => -79.847391
1 => 43.256623
]
+"Latitude": 43.256623
+"Longitude": -79.847391
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "A rare opportunity to own a character-filled home with modern bones in one of Hamilton's established neighbourhoods. Built in 1903, this fully updated 4+ bedroom, 2-bathroom property blends timeless charm with extensive mechanical and cosmetic upgrades, offering the best of both worlds for a growing family or savvy buyer. Inside, you'll find four generous bedrooms, a dedicated office space, two full bathrooms, and a spacious basement recreation room with a wood-burning fireplace. The lower level offers excellent potential for additional finished living space, with rough-in potential for a third bathroom already in place. Outside, the property truly shines. Enjoy a fenced front yard, covered and gated front porch, and a private backyard with both front and rear access. Perfect for entertaining, the outdoor space features a large patio with a natural gas BBQ hookup, ambient lighting, thoughtful landscaping, a garden shed, and a detached two-car garage accessed from the rear concrete laneway. A three-car side driveway provides plenty of parking. The updates speak for themselves: all-new electrical with a 200-amp service and surge protection, a 60-amp underground service to the garage with cable, phone, and internet connectivity, updated plumbing, an owned tankless water heater (2021), new A/C and ductwork (2020), new windows and doors (2020), and a fully refreshed exterior including the roof, soffits, fascia, eavestroughs, leaf guards, and downspouts. New flooring throughout and a wired alarm system connecting the house and garage add further value and peace of mind. With exceptional space, flexibility, and a long list of major improvements already completed, 137 Wentworth Street North is truly move-in ready-all that's left is to make it your own. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Water Heater"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T16:47:30.917152+00:00"
+"Directions": "Cross Streets: Cannon and Wentworth. ** Directions: Cannon St E to Wentworth St N."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2027760"
+"ListOfficeKey": "299902"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "29 x 139 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-19T19:55:16Z"
+"PhotosCount": 18
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T21:30:38Z"
+"Stories": "2.5"
+"StreetDirSuffix": "North"
+"StreetName": "Wentworth"
+"StreetNumber": "137"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3285.76"
+"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": "Landsdale"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29928216/137-wentworth-street-n-hamilton-landsdale-landsdale"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 29.0
+"OriginalEntryTimestamp": "2026-06-19T15:33:17.24Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1307105"
+"ListOfficeNationalAssociationId": "1478673"
+"Media": array:18 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29928216')"
+"ID": "1547606"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23394
+post_id: "1547607"
+post_author: 1
+"ListingKey": "29927864"
+"ListingId": "40841321"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T21:05:27Z"
+"RFModificationTimestamp": "2026-06-19T21:10:31Z"
+"ListPrice": 689900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1530.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8M2N3"
+"UnparsedAddress": "28 ST CLAIR Avenue, Hamilton, Ontario L8M2N3"
+"Coordinates": array:2 [
0 => -79.8398953
1 => 43.2505414
]
+"Latitude": 43.2505414
+"Longitude": -79.8398953
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Prestigious St. Clair Avenue! This one-of-a-kind on the street, character-filled home offers timeless elegance and exceptional warmth throughout. Featuring beautiful leaded and bevelled glass windows, a unique turret feature, custom built-ins, and a separate formal dining room, this home is full of unique charm. The inviting den just off the kitchen provides the perfect space for a home office, reading nook, or family retreat. The basement adds valuable living space with a walk-up to a private backyard ideal for relaxing or entertaining. A rare opportunity to own a distinguished home in one of the area’s most sought-after locations. Schedule your private viewing today! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"ConstructionMaterials": array:1 [
0 => "Wood frame"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T16:01:30.372018+00:00"
+"Directions": "King St E to St. Clair"
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Brick"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1948261"
+"ListOfficeKey": "287174"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-06-19T14:52:59Z"
+"PhotosCount": 48
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T20:32:02Z"
+"Stories": "2.0"
+"StreetName": "ST CLAIR"
+"StreetNumber": "28"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "202 - Gibson/Stipley South"
+"TaxAnnualAmount": "4547.12"
+"VirtualTourURLUnbranded": "https://www.venturehomes.ca/virtualtour.asp?tourid=70336"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29927864/28-st-clair-avenue-hamilton"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1523817"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "55168"
+"GeocodeManualYN": true
+"ZoningDescription": "R1a"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 29.0
+"AboveGradeFinishedArea": 1530
+"OriginalEntryTimestamp": "2026-06-19T14:50:25.86Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1242828"
+"ListOfficeNationalAssociationId": "1373445"
+"CoListAgentNationalAssociationId": "1063492"
+"CoListOfficeNationalAssociationId": "1116022"
+"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('29927864')"
+"ID": "1547607"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25304
+post_id: "1547307"
+post_author: 1
+"ListingKey": "29927681"
+"ListingId": "40841177"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T21:25:31Z"
+"RFModificationTimestamp": "2026-06-19T21:30:26Z"
+"ListPrice": 499990.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1633.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8L5V6"
+"UnparsedAddress": "137 WENTWORTH Street N, Hamilton, Ontario L8L5V6"
+"Coordinates": array:2 [
0 => -79.8472102
1 => 43.2566582
]
+"Latitude": 43.2566582
+"Longitude": -79.8472102
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "A rare opportunity to own a character-filled home with modern bones in one of Hamilton’s established neighbourhoods. Built in 1903, this fully updated 4+ bedroom, 2-bathroom property blends timeless charm with extensive mechanical and cosmetic upgrades, offering the best of both worlds for a growing family or savvy buyer. Inside, you'll find four generous bedrooms, a dedicated office space, two full bathrooms, and a spacious basement recreation room with a wood-burning fireplace. The lower level offers excellent potential for additional finished living space, with rough-in potential for a third bathroom already in place. Outside, the property truly shines. Enjoy a fenced front yard, covered and gated front porch, and a private backyard with both front and rear access. Perfect for entertaining, the outdoor space features a large patio with a natural gas BBQ hookup, ambient lighting, thoughtful landscaping, a garden shed, and a detached two-car garage accessed from the rear concrete laneway. A three-car side driveway provides plenty of parking. The updates speak for themselves: all-new electrical with a 200-amp service and surge protection, a 60-amp underground service to the garage with cable, phone, and internet connectivity, updated plumbing, an owned tankless water heater (2021), new A/C and ductwork (2020), new windows and doors (2020), and a fully refreshed exterior including the roof, soffits, fascia, eavestroughs, leaf guards, and downspouts. New flooring throughout and a wired alarm system connecting the house and garage add further value and peace of mind. With exceptional space, flexibility, and a long list of major improvements already completed, 137 Wentworth Street North is truly move-in ready—all that's left is to make it your own. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T15:24:03.515737+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1981716"
+"ListOfficeKey": "299866"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-06-19T19:31:59Z"
+"PhotosCount": 18
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T20:51:00Z"
+"Stories": "2.5"
+"StreetDirSuffix": "North"
+"StreetName": "WENTWORTH"
+"StreetNumber": "137"
+"StreetSuffix": "Street"
+"SubdivisionName": "141 - Landsdale"
+"TaxAnnualAmount": "3285.76"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29927681/137-wentworth-street-n-hamilton"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2068350"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "299867"
+"GeocodeManualYN": true
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 29.0
+"AboveGradeFinishedArea": 1633
+"OriginalEntryTimestamp": "2026-06-19T14:33:47.06Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1267128"
+"ListOfficeNationalAssociationId": "1477944"
+"CoListAgentNationalAssociationId": "1343399"
+"CoListOfficeNationalAssociationId": "1477945"
+"Media": array:18 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29927681')"
+"ID": "1547307"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25305
+post_id: "1544290"
+post_author: 1
+"ListingKey": "29923615"
+"ListingId": "X13462614"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T18:40:20Z"
+"RFModificationTimestamp": "2026-06-18T19:31:40Z"
+"ListPrice": 499900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Gibson)"
+"PostalCode": "L8L6M4"
+"UnparsedAddress": "86 SHERMAN AVENUE N, Hamilton (Gibson), Ontario L8L6M4"
+"Coordinates": array:2 [
0 => -79.836845
1 => 43.254071
]
+"Latitude": 43.254071
+"Longitude": -79.836845
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Step into a piece of Hamilton history at 86 Sherman Avenue North. This grand Victorian residence showcases the kind of craftsmanship, character, and architectural detail that simply cannot be replicated today. From its impressive proportions to its timeless charm, this is a home that tells a story. Featuring 6 spacious bedrooms and 2 large bathrooms, the property provides exceptional flexibility for large families, multigenerational living, or those seeking a restoration project with tremendous upside. Original features such as 10 ft ceilings, 12" baseboards & refinished pine floors create a rare foundation for someone with a vision to bring this remarkable home back to its full potential. Convenient rear laneway access provides valuable private parking, while the central location places you just minutes from downtown Hamilton, the vibrant shops and restaurants of Ottawa Street and James Street North, Gage Park, schools, public transit, and easy highway access for commuters. Whether you're an investor, renovator, or buyer searching for a truly unique property, opportunities like this are becoming increasingly rare. Restore, reimagine, and revive one of Hamilton's classic Victorian homes. (id:62650)"
+"Appliances": array:2 [
0 => "Washer"
1 => "Dryer"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T19:31:30.958383+00:00"
+"Directions": "Cross Streets: Cannon St. E. ** Directions: West on Cannon St. E., North on Sherman Ave. N."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2036043"
+"ListOfficeKey": "291490"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Lane"
1 => "Carpet Free"
]
+"LotSizeDimensions": "32 x 110 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T18:33:09Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T18:33:09Z"
+"Stories": "2.5"
+"StreetDirSuffix": "North"
+"StreetName": "Sherman"
+"StreetNumber": "86"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "4659"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=LwvocnAkqtj"
+"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": "Toronto"
+"CityRegion": "Gibson"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29923615/86-sherman-avenue-n-hamilton-gibson-gibson"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"ZoningDescription": "R1A"
+"BedroomsAboveGrade": 6
+"FrontageLengthNumeric": 32.0
+"OriginalEntryTimestamp": "2026-06-18T18:33:09.74Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1312659"
+"ListOfficeNationalAssociationId": "1398828"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29923615')"
+"ID": "1544290"
}
]
+success: true
+page_size: 9
+page_count: 36
+count: 323
+after_key: ""
}
"RF Response Time" => "0.16 seconds"
]
]