4132 Properties
Sort by:
Compare listings
ComparePlease enter your username or email address. You will receive a link to create a new password via email.
array:1 [ "RF Cache Key: a2e00f2b6d286cfa141d3b0339ba7e995ef4a56af1ff5c3e200bcebae1c9093f" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#14357 +items: array:10 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14531 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12268439" +"ListingId": "X12268439" +"PropertyType": "Residential" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-07T19:17:21Z" +"RFModificationTimestamp": "2025-07-08T17:02:14.088787+00:00" +"ListPrice": 479900.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8B 2A7" +"UnparsedAddress": "#335 - 10 Mallard Trail, Hamilton, ON L8B 2A7" +"Coordinates": array:2 [ 0 => -79.8728583 1 => 43.2560802 ] +"Latitude": 43.2560802 +"Longitude": -79.8728583 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX ESCARPMENT REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "1 BEDROOM + DEN, TREND BOUTIQUE condo available for sale located in trendy hot spot of Waterdown. Living steps away from upscale boutiques, antique shops and super centre with major stores, that will satisfy any shopping fanatic. Entrance will give you first impression of stylish interiors and elegant lobby. Enjoy a fresh cup of coffee while you bask in sunshine on your rooftop patio. During cooler days, take the festivities indoors to your fully furnished party room. Say goodbye to gym membership with a fully equipped facility at your disposal. Stunning 1 BEDROOM + DEN condo features bright open concept kitchen, along with your living space that exudes both comfort and style spacious interiors that provides endless opportunities to create unique lifestyle. Quality upgrades through out includes stylish tiles, bath accessories, upgraded kitchen cabinetry, interior doors/handles, vinyl plank flooring throughout, quartz counter tops, custom blinds, and extra long living room. In-suite laundry. Experience the convenience of condo living with 1 UG PARK, bike storage, & your own personal locker. HUGE balcony with unobstructed view (66 sqf). Minutes to Aldershot GO Station, downtown Burlington and Hamilton. Some amenities are at Trend (1-3)." +"ArchitecturalStyle": array:1 [ 0 => "1 Storey/Apt" ] +"AssociationFee": "383.15" +"AssociationFeeIncludes": array:4 [ 0 => "Heat Included" 1 => "Common Elements Included" 2 => "Building Insurance Included" 3 => "Parking Included" ] +"Basement": array:1 [ 0 => "None" ] +"BuildingName": "TREND BOUTIQUE" +"CityRegion": "Waterdown" +"ConstructionMaterials": array:2 [ 0 => "Brick" 1 => "Other" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CountyOrParish": "Hamilton" +"CoveredSpaces": "1.0" +"CreationDate": "2025-07-07T20:20:09.228997+00:00" +"CrossStreet": "MALLARD TRAIL/DUNDAS STREET E" +"Directions": "Corner of Mallard Trail/Dundas Street E" +"ExpirationDate": "2025-11-04" +"GarageYN": true +"Inclusions": "Built-in microwave, dryer, refrigerator, stove, washer, dishwasher" +"InteriorFeatures": array:3 [ 0 => "Auto Garage Door Remote" 1 => "Carpet Free" 2 => "Intercom" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "Ensuite" ] +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-07-04" +"MainOfficeKey": "184000" +"MajorChangeTimestamp": "2025-07-07T19:17:21Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-07-07T19:17:21Z" +"OriginalListPrice": 479900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2674766" +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ 0 => "Restricted" ] +"PhotosChangeTimestamp": "2025-07-07T19:17:21Z" +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "MALLARD" +"StreetNumber": "10" +"StreetSuffix": "Trail" +"TaxAnnualAmount": "3071.29" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2.00%" +"TransactionType": "For Sale" +"UnitNumber": "335" +"RoomsAboveGrade": 6 +"PropertyManagementCompany": "FIRST SERVICE RESIDENTIAL" +"Locker": "Owned" +"KitchensAboveGrade": 1 +"WashroomsType1": 1 +"DDFYN": true +"LivingAreaRange": "700-799" +"HeatSource": "Other" +"ContractStatus": "Available" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12268439')" +"WashroomsType1Pcs": 4 +"WashroomsType1Level": "Ground" +"HSTApplication": array:1 [ 0 => "Not Subject to HST" ] +"LegalApartmentNumber": "251" +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"SystemModificationTimestamp": "2025-07-07T19:17:22.504651Z" +"provider_name": "TRREB" +"LegalStories": "3" +"PossessionDetails": "-" +"ParkingType1": "Owned" +"GarageType": "Underground" +"BalconyType": "Enclosed" +"PossessionType": "Immediate" +"Exposure": "East" +"PriorMlsStatus": "Draft" +"BedroomsAboveGrade": 1 +"SquareFootSource": "BUILDER" +"MediaChangeTimestamp": "2025-07-07T19:17:21Z" +"SurveyType": "None" +"ApproximateAge": "0-5" +"HoldoverDays": 30 +"CondoCorpNumber": 629 +"LaundryLevel": "Main Level" +"KitchensTotal": 1 +"short_address": "Hamilton, ON L8B 2A7, CA" +"Media": array:50 [ 0 => array:26 [ "ResourceRecordKey" => "X12268439" "MediaModificationTimestamp" => "2025-07-07T19:17:21.171815Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12268439/thumbnail-e6e430c33518d8dc90de23b13a7b8bd8.webp" "ShortDescription" => null "MediaKey" => "bc1de41a-e25b-4382-8bed-19eed44a687d" "ImageWidth" => 1093 "ClassName" => "ResidentialCondo" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-07T19:17:21.171815Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "bc1de41a-e25b-4382-8bed-19eed44a687d" "Order" => 0 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12268439/e6e430c33518d8dc90de23b13a7b8bd8.webp" "MediaSize" => 175597 "SourceSystemMediaKey" => "bc1de41a-e25b-4382-8bed-19eed44a687d" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => true "LongDescription" => null "ImageHeight" => 718 ] 1 => array:26 [ "ResourceRecordKey" => "X12268439" "MediaModificationTimestamp" => "2025-07-07T19:17:21.171815Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12268439/thumbnail-134d356a04527041ab8f21a8dc55a75e.webp" "ShortDescription" => null "MediaKey" => "e5f371e0-3f5a-4fae-9a15-676b3b0472cd" "ImageWidth" => 1024 "ClassName" => "ResidentialCondo" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-07T19:17:21.171815Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "e5f371e0-3f5a-4fae-9a15-676b3b0472cd" "Order" => 1 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12268439/134d356a04527041ab8f21a8dc55a75e.webp" "MediaSize" => 165052 "SourceSystemMediaKey" => "e5f371e0-3f5a-4fae-9a15-676b3b0472cd" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 767 ] 2 => array:26 [ "ResourceRecordKey" => "X12268439" "MediaModificationTimestamp" => "2025-07-07T19:17:21.171815Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12268439/thumbnail-86a164f17981bc0cdf0392f241eaff1f.webp" "ShortDescription" => null "MediaKey" => "316e341a-2dd4-4017-b051-1e60f00eccc8" "ImageWidth" => 1085 "ClassName" => "ResidentialCondo" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-07T19:17:21.171815Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "316e341a-2dd4-4017-b051-1e60f00eccc8" "Order" => 2 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12268439/86a164f17981bc0cdf0392f241eaff1f.webp" "MediaSize" => 81898 "SourceSystemMediaKey" => "316e341a-2dd4-4017-b051-1e60f00eccc8" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 724 ] 3 => array:26 [ "ResourceRecordKey" => "X12268439" "MediaModificationTimestamp" => "2025-07-07T19:17:21.171815Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12268439/thumbnail-0eb394257d28f1c7883e09f8588d38a4.webp" "ShortDescription" => null "MediaKey" => "2de62f4a-eaa5-45cc-946e-d3cb573265dc" "ImageWidth" => 1085 "ClassName" => "ResidentialCondo" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-07T19:17:21.171815Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "2de62f4a-eaa5-45cc-946e-d3cb573265dc" "Order" => 3 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12268439/0eb394257d28f1c7883e09f8588d38a4.webp" "MediaSize" => 50587 "SourceSystemMediaKey" => "2de62f4a-eaa5-45cc-946e-d3cb573265dc" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 724 ] 4 => array:26 [ "ResourceRecordKey" => "X12268439" "MediaModificationTimestamp" => "2025-07-07T19:17:21.171815Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12268439/thumbnail-ef365a4aa291b2a1b52c744537dc9305.webp" "ShortDescription" => null "MediaKey" => "2d4b7484-4f9a-4b2c-bd19-2a3aea8bf655" "ImageWidth" => 1085 "ClassName" => "ResidentialCondo" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-07T19:17:21.171815Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "2d4b7484-4f9a-4b2c-bd19-2a3aea8bf655" "Order" => 4 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12268439/ef365a4aa291b2a1b52c744537dc9305.webp" "MediaSize" => 44624 "SourceSystemMediaKey" => "2d4b7484-4f9a-4b2c-bd19-2a3aea8bf655" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 724 ] 5 => array:26 [ "ResourceRecordKey" => "X12268439" "MediaModificationTimestamp" => "2025-07-07T19:17:21.171815Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12268439/thumbnail-a413c885061e33a8b286436404116d51.webp" "ShortDescription" => null "MediaKey" => "89bfe35e-6238-443d-9cf4-df8dbfd7be94" "ImageWidth" => 1085 "ClassName" => "ResidentialCondo" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-07T19:17:21.171815Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "89bfe35e-6238-443d-9cf4-df8dbfd7be94" "Order" => 5 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12268439/a413c885061e33a8b286436404116d51.webp" "MediaSize" => 44804 "SourceSystemMediaKey" => "89bfe35e-6238-443d-9cf4-df8dbfd7be94" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 724 ] 6 => array:26 [ "ResourceRecordKey" => "X12268439" "MediaModificationTimestamp" => "2025-07-07T19:17:21.171815Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12268439/thumbnail-10c05f28824b62aca8b4bc18968390b1.webp" "ShortDescription" => null "MediaKey" => "17cb740c-7b43-4355-8667-245234eb1c54" "ImageWidth" => 1085 "ClassName" => "ResidentialCondo" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-07T19:17:21.171815Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "17cb740c-7b43-4355-8667-245234eb1c54" "Order" => 6 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12268439/10c05f28824b62aca8b4bc18968390b1.webp" "MediaSize" => 40698 "SourceSystemMediaKey" => "17cb740c-7b43-4355-8667-245234eb1c54" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 724 ] 7 => array:26 [ "ResourceRecordKey" => "X12268439" "MediaModificationTimestamp" => "2025-07-07T19:17:21.171815Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12268439/thumbnail-ddb7e994a89a37daa2a2933cf0ef465f.webp" "ShortDescription" => null "MediaKey" => "f0ef2ae0-4bfe-4108-8dca-5debdc76e9af" "ImageWidth" => 1085 "ClassName" => "ResidentialCondo" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-07T19:17:21.171815Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "f0ef2ae0-4bfe-4108-8dca-5debdc76e9af" "Order" => 7 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12268439/ddb7e994a89a37daa2a2933cf0ef465f.webp" "MediaSize" => 43720 "SourceSystemMediaKey" => "f0ef2ae0-4bfe-4108-8dca-5debdc76e9af" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 724 ] 8 => array:26 [ "ResourceRecordKey" => "X12268439" "MediaModificationTimestamp" => "2025-07-07T19:17:21.171815Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12268439/thumbnail-c70e41782daafc38c56c92f49efa3251.webp" "ShortDescription" => null "MediaKey" => "1145b890-050d-4a94-bd4e-c46003aad9c7" "ImageWidth" => 1085 "ClassName" => "ResidentialCondo" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-07T19:17:21.171815Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "1145b890-050d-4a94-bd4e-c46003aad9c7" "Order" => 8 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12268439/c70e41782daafc38c56c92f49efa3251.webp" "MediaSize" => 42910 "SourceSystemMediaKey" => "1145b890-050d-4a94-bd4e-c46003aad9c7" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 724 ] 9 => array:26 [ "ResourceRecordKey" => "X12268439" "MediaModificationTimestamp" => "2025-07-07T19:17:21.171815Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12268439/thumbnail-d4b1fa2ca57ee68523669010d4488537.webp" "ShortDescription" => null "MediaKey" => "3aeb4262-3d8a-4f1c-83fb-5621a23944ee" "ImageWidth" => 1085 "ClassName" => "ResidentialCondo" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-07T19:17:21.171815Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "3aeb4262-3d8a-4f1c-83fb-5621a23944ee" "Order" => 9 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12268439/d4b1fa2ca57ee68523669010d4488537.webp" "MediaSize" => 37523 "SourceSystemMediaKey" => "3aeb4262-3d8a-4f1c-83fb-5621a23944ee" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 724 ] 10 => array:26 [ "ResourceRecordKey" => "X12268439" "MediaModificationTimestamp" => "2025-07-07T19:17:21.171815Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12268439/thumbnail-4666ff061b054245a5e79e773bb61139.webp" "ShortDescription" => null "MediaKey" => "0beb78ad-559a-4329-ae8a-9bac2f3f288a" "ImageWidth" => 1085 "ClassName" => "ResidentialCondo" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-07T19:17:21.171815Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "0beb78ad-559a-4329-ae8a-9bac2f3f288a" "Order" => 10 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12268439/4666ff061b054245a5e79e773bb61139.webp" "MediaSize" => 53906 "SourceSystemMediaKey" => "0beb78ad-559a-4329-ae8a-9bac2f3f288a" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 724 ] 11 => array:26 [ "ResourceRecordKey" => "X12268439" "MediaModificationTimestamp" => "2025-07-07T19:17:21.171815Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12268439/thumbnail-e8db8e2b73248dc501e8332bcf8ac3c2.webp" "ShortDescription" => null "MediaKey" => "0247b4bd-76dd-4c48-aac4-9c9a3a986abc" "ImageWidth" => 1085 "ClassName" => "ResidentialCondo" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-07T19:17:21.171815Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "0247b4bd-76dd-4c48-aac4-9c9a3a986abc" "Order" => 11 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12268439/e8db8e2b73248dc501e8332bcf8ac3c2.webp" "MediaSize" => 51993 "SourceSystemMediaKey" => "0247b4bd-76dd-4c48-aac4-9c9a3a986abc" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 724 ] 12 => array:26 [ "ResourceRecordKey" => "X12268439" "MediaModificationTimestamp" => "2025-07-07T19:17:21.171815Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12268439/thumbnail-99ef9efbb801c226a780bad8a4aa44c4.webp" "ShortDescription" => null "MediaKey" => "744184fd-cbde-4a3a-8601-f94627111af3" "ImageWidth" => 1085 "ClassName" => "ResidentialCondo" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-07T19:17:21.171815Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "744184fd-cbde-4a3a-8601-f94627111af3" "Order" => 12 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12268439/99ef9efbb801c226a780bad8a4aa44c4.webp" "MediaSize" => 45260 "SourceSystemMediaKey" => "744184fd-cbde-4a3a-8601-f94627111af3" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 724 ] 13 => array:26 [ "ResourceRecordKey" => "X12268439" "MediaModificationTimestamp" => "2025-07-07T19:17:21.171815Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12268439/thumbnail-6f1dad6f0a691689348230aff10e77ca.webp" "ShortDescription" => null "MediaKey" => "c0815e74-c456-42f6-b9ac-65556881a2e1" "ImageWidth" => 1085 "ClassName" => "ResidentialCondo" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-07T19:17:21.171815Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "c0815e74-c456-42f6-b9ac-65556881a2e1" "Order" => 13 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12268439/6f1dad6f0a691689348230aff10e77ca.webp" "MediaSize" => 38295 "SourceSystemMediaKey" => "c0815e74-c456-42f6-b9ac-65556881a2e1" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 724 ] 14 => array:26 [ "ResourceRecordKey" => "X12268439" "MediaModificationTimestamp" => "2025-07-07T19:17:21.171815Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12268439/thumbnail-bcce2d48638cb943f50820ae366cf976.webp" "ShortDescription" => null "MediaKey" => "01fe55ab-aad0-4ef5-8a09-52286396fde7" "ImageWidth" => 1085 "ClassName" => "ResidentialCondo" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-07T19:17:21.171815Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "01fe55ab-aad0-4ef5-8a09-52286396fde7" "Order" => 14 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12268439/bcce2d48638cb943f50820ae366cf976.webp" "MediaSize" => 41242 "SourceSystemMediaKey" => "01fe55ab-aad0-4ef5-8a09-52286396fde7" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 724 ] 15 => array:26 [ "ResourceRecordKey" => "X12268439" "MediaModificationTimestamp" => "2025-07-07T19:17:21.171815Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12268439/thumbnail-a52f0200a8f25811dc3bc13a9afe62a4.webp" "ShortDescription" => null "MediaKey" => "19cef2b2-e994-45cc-947d-db6a171cc99e" "ImageWidth" => 1085 "ClassName" => "ResidentialCondo" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-07T19:17:21.171815Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "19cef2b2-e994-45cc-947d-db6a171cc99e" "Order" => 15 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12268439/a52f0200a8f25811dc3bc13a9afe62a4.webp" "MediaSize" => 38854 "SourceSystemMediaKey" => "19cef2b2-e994-45cc-947d-db6a171cc99e" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 724 ] 16 => array:26 [ "ResourceRecordKey" => "X12268439" "MediaModificationTimestamp" => "2025-07-07T19:17:21.171815Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12268439/thumbnail-cb03804b0b5c0cf8f9ebd4ed882b30c9.webp" "ShortDescription" => null "MediaKey" => "0f7e176b-7e0f-489b-ae6a-a87c2ebe08d3" "ImageWidth" => 1085 "ClassName" => "ResidentialCondo" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-07T19:17:21.171815Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "0f7e176b-7e0f-489b-ae6a-a87c2ebe08d3" "Order" => 16 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12268439/cb03804b0b5c0cf8f9ebd4ed882b30c9.webp" "MediaSize" => 44870 "SourceSystemMediaKey" => "0f7e176b-7e0f-489b-ae6a-a87c2ebe08d3" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 724 ] 17 => array:26 [ "ResourceRecordKey" => "X12268439" "MediaModificationTimestamp" => "2025-07-07T19:17:21.171815Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12268439/thumbnail-0a2f69ea681607a2c4e1b5447b25c25c.webp" "ShortDescription" => null "MediaKey" => "c886d7c4-a7a2-496d-87c8-137423ee671e" "ImageWidth" => 1085 "ClassName" => "ResidentialCondo" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-07T19:17:21.171815Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "c886d7c4-a7a2-496d-87c8-137423ee671e" "Order" => 17 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12268439/0a2f69ea681607a2c4e1b5447b25c25c.webp" "MediaSize" => 38087 "SourceSystemMediaKey" => "c886d7c4-a7a2-496d-87c8-137423ee671e" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 724 ] 18 => array:26 [ "ResourceRecordKey" => "X12268439" "MediaModificationTimestamp" => "2025-07-07T19:17:21.171815Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12268439/thumbnail-4d07d0f7cc4400171ad35475217cd229.webp" "ShortDescription" => null "MediaKey" => "da198989-057b-4bf8-8df6-80107c4a3e59" "ImageWidth" => 1085 "ClassName" => "ResidentialCondo" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-07T19:17:21.171815Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "da198989-057b-4bf8-8df6-80107c4a3e59" "Order" => 18 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12268439/4d07d0f7cc4400171ad35475217cd229.webp" "MediaSize" => 30659 "SourceSystemMediaKey" => "da198989-057b-4bf8-8df6-80107c4a3e59" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 724 ] 19 => array:26 [ "ResourceRecordKey" => "X12268439" "MediaModificationTimestamp" => "2025-07-07T19:17:21.171815Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12268439/thumbnail-82c6bf446da21303986f9a6984b89e19.webp" "ShortDescription" => null "MediaKey" => "8206d13a-695d-4f67-a379-a682da459123" "ImageWidth" => 1085 "ClassName" => "ResidentialCondo" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-07T19:17:21.171815Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "8206d13a-695d-4f67-a379-a682da459123" "Order" => 19 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12268439/82c6bf446da21303986f9a6984b89e19.webp" "MediaSize" => 29771 "SourceSystemMediaKey" => "8206d13a-695d-4f67-a379-a682da459123" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 724 ] 20 => array:26 [ "ResourceRecordKey" => "X12268439" "MediaModificationTimestamp" => "2025-07-07T19:17:21.171815Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12268439/thumbnail-2842f78c1ec1df9081344aa7380d3317.webp" "ShortDescription" => null "MediaKey" => "ed6ebaf6-5f29-4487-8f96-68348c5d6fa2" "ImageWidth" => 1085 "ClassName" => "ResidentialCondo" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-07T19:17:21.171815Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "ed6ebaf6-5f29-4487-8f96-68348c5d6fa2" "Order" => 20 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12268439/2842f78c1ec1df9081344aa7380d3317.webp" "MediaSize" => 39166 "SourceSystemMediaKey" => "ed6ebaf6-5f29-4487-8f96-68348c5d6fa2" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 724 ] 21 => array:26 [ "ResourceRecordKey" => "X12268439" "MediaModificationTimestamp" => "2025-07-07T19:17:21.171815Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12268439/thumbnail-115cac6ac631c8e7b4beb310a9c4b850.webp" "ShortDescription" => null "MediaKey" => "4669206d-91fc-4c38-88b9-7c07a34ca8be" "ImageWidth" => 1085 "ClassName" => "ResidentialCondo" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-07T19:17:21.171815Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "4669206d-91fc-4c38-88b9-7c07a34ca8be" "Order" => 21 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12268439/115cac6ac631c8e7b4beb310a9c4b850.webp" "MediaSize" => 36840 "SourceSystemMediaKey" => "4669206d-91fc-4c38-88b9-7c07a34ca8be" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 724 ] 22 => array:26 [ "ResourceRecordKey" => "X12268439" "MediaModificationTimestamp" => "2025-07-07T19:17:21.171815Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12268439/thumbnail-d8cf6c14ffbac6cfa86a89722575ee03.webp" "ShortDescription" => null "MediaKey" => "185e7704-1eb7-46f9-a9ac-f9d63ca8721e" "ImageWidth" => 1085 "ClassName" => "ResidentialCondo" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-07T19:17:21.171815Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "185e7704-1eb7-46f9-a9ac-f9d63ca8721e" "Order" => 22 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12268439/d8cf6c14ffbac6cfa86a89722575ee03.webp" "MediaSize" => 137783 "SourceSystemMediaKey" => "185e7704-1eb7-46f9-a9ac-f9d63ca8721e" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 724 ] 23 => array:26 [ "ResourceRecordKey" => "X12268439" "MediaModificationTimestamp" => "2025-07-07T19:17:21.171815Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12268439/thumbnail-5264900155b2a38d3105b18314543a68.webp" "ShortDescription" => null "MediaKey" => "482bf1b8-0e63-4491-8193-2d5ce0455c60" "ImageWidth" => 1085 "ClassName" => "ResidentialCondo" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-07T19:17:21.171815Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "482bf1b8-0e63-4491-8193-2d5ce0455c60" "Order" => 23 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12268439/5264900155b2a38d3105b18314543a68.webp" "MediaSize" => 103109 "SourceSystemMediaKey" => "482bf1b8-0e63-4491-8193-2d5ce0455c60" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 724 ] 24 => array:26 [ "ResourceRecordKey" => "X12268439" "MediaModificationTimestamp" => "2025-07-07T19:17:21.171815Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12268439/thumbnail-c52de99fb6687c79668a9cbaef36a409.webp" "ShortDescription" => null "MediaKey" => "58e3a094-9e63-4a4d-b452-8a1767058e2d" "ImageWidth" => 1085 "ClassName" => "ResidentialCondo" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-07T19:17:21.171815Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "58e3a094-9e63-4a4d-b452-8a1767058e2d" "Order" => 24 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12268439/c52de99fb6687c79668a9cbaef36a409.webp" "MediaSize" => 149252 "SourceSystemMediaKey" => "58e3a094-9e63-4a4d-b452-8a1767058e2d" …5 ] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] 31 => array:26 [ …26] 32 => array:26 [ …26] 33 => array:26 [ …26] 34 => array:26 [ …26] 35 => array:26 [ …26] 36 => array:26 [ …26] 37 => array:26 [ …26] 38 => array:26 [ …26] 39 => array:26 [ …26] 40 => array:26 [ …26] 41 => array:26 [ …26] 42 => array:26 [ …26] 43 => array:26 [ …26] 44 => array:26 [ …26] 45 => array:26 [ …26] 46 => array:26 [ …26] 47 => array:26 [ …26] 48 => array:26 [ …26] 49 => array:26 [ …26] ] } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14532 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12109521" +"ListingId": "X12109521" +"PropertyType": "Residential" +"PropertySubType": "Triplex" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-07T19:13:01Z" +"RFModificationTimestamp": "2025-07-07T20:21:39.032358+00:00" +"ListPrice": 1250000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 7.0 +"LotSizeArea": 0.1 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8P 2S5" +"UnparsedAddress": "495 Aberdeen Avenue, Hamilton, On L8p 2s5" +"Coordinates": array:2 [ 0 => -79.895438 1 => 43.251532 ] +"Latitude": 43.251532 +"Longitude": -79.895438 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "SUTTON GROUP-ADMIRAL REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Attention Investors! Welcome to 495 Aberdeen Avenue, a legal non-conforming triplex nestled in one of Hamilton's most desirable neighbourhoods. Offering a total of 7 bedrooms and 4 full bathrooms across 3 spacious units, this property is a fantastic opportunity for investors. Unit 1 (Basement): 1+1 bedrooms, 1 full bath, approx. 1000 sq. ft. with vinyl plank flooring. Unit 2 (Main Floor): 2 bedrooms, 1 full bath, approx. 1000 sq. ft. with laminate throughout and ceramic in the kitchen. Unit 3 (Top Two Floors): 3 bedrooms, 2 full baths, approx. 1500 sq. ft. with hardwood and ceramic on the main level, and vinyl plank on the top floor. Tenanted until July 1st. Live in the Top Unit while reaping the income from the other two units. This home has seen major updates including a new roof (2024), high-efficiency boiler (2023), and updated windows on the second and third floors (2017). Coin-operated washer (2024) and dryer (2013) provide added convenience. Appliances include multiple updated fridges and stoves. Located steps from Mc Master University, St. Josephs Healthcare, Chedoke Golf Club, and vibrant Locke Street with its shops, cafes, and restaurants. Easy access to trails, transit, and Highway 403. A turnkey property in a prime west Hamilton location, don't miss out! ***EXTRAS Listing contains virtually staged photos. Boiler/radiant heating. Legal non-conforming (purchaser to verify), all fully tenanted with reliable tenants, and leases to be transferred to new owner.***" +"ArchitecturalStyle": array:1 [ 0 => "2 1/2 Storey" ] +"Basement": array:1 [ 0 => "Finished" ] +"CityRegion": "Kirkendall" +"CoListOfficeName": "SUTTON GROUP-ADMIRAL REALTY INC." +"CoListOfficePhone": "416-739-7200" +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": array:1 [ 0 => "None" ] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CoveredSpaces": "1.0" +"CreationDate": "2025-04-29T14:42:49.131506+00:00" +"CrossStreet": "Flatt Ave & Aberdeen Ave" +"DirectionFaces": "South" +"Directions": "North on Aberdeen Ave & then turn on Flatt Ave" +"Exclusions": "Window coverings, Any tenant belongings in units and Contents of the garage." +"ExpirationDate": "2025-07-31" +"ExteriorFeatures": array:1 [ 0 => "Patio" ] +"FoundationDetails": array:1 [ 0 => "Concrete" ] +"Inclusions": "All appliances (Coin operated washer, Coin operated dryer, 3 fridges, 3 stoves), Main floor wardrobe and all electrical light fixtures." +"InteriorFeatures": array:4 [ 0 => "Carpet Free" 1 => "Separate Hydro Meter" 2 => "Separate Heating Controls" 3 => "Water Heater" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-04-29" +"LotSizeSource": "MPAC" +"MainOfficeKey": "079900" +"MajorChangeTimestamp": "2025-04-29T13:03:19Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2025-04-29T13:03:19Z" +"OriginalListPrice": 1250000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2283312" +"ParcelNumber": "171190010" +"ParkingFeatures": array:1 [ 0 => "Private" ] +"ParkingTotal": "5.0" +"PhotosChangeTimestamp": "2025-07-03T15:07:26Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"SecurityFeatures": array:2 [ 0 => "Carbon Monoxide Detectors" 1 => "Smoke Detector" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:2 [ 0 => "Lockbox" 1 => "List Brokerage" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Aberdeen" +"StreetNumber": "495" +"StreetSuffix": "Avenue" +"TaxAnnualAmount": "7119.55" +"TaxLegalDescription": "LT 11, PL 403 ; HAMILTON" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2.5% + Hst" +"TransactionType": "For Sale" +"View": array:1 [ 0 => "City" ] +"Water": "Municipal" +"RoomsAboveGrade": 13 +"DDFYN": true +"LivingAreaRange": "2500-3000" +"HeatSource": "Gas" +"PropertyFeatures": array:6 [ 0 => "School" 1 => "Park" 2 => "Library" 3 => "Hospital" 4 => "Public Transit" 5 => "Rec./Commun.Centre" ] +"LotWidth": 38.67 +"WashroomsType3Pcs": 3 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12109521')" +"SalesBrochureUrl": "495Aberdeen Avenue.com" +"WashroomsType1Level": "Main" +"LotDepth": 110.0 +"SoundBiteUrl": "495Aberdeen Avenue.com" +"ShowingAppointments": "Through LB. See Brokerage Remarks: 24Hr Notice Required. All Units Currently Tenanted." +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"RentalItems": "2 hot water tank rentals by Reliance, 3x tenant leases (2x month to month, 1x until November 2025 then switches to month to month)." +"LaundryLevel": "Lower Level" +"WashroomsType3Level": "Third" +"KitchensAboveGrade": 3 +"UnderContract": array:1 [ 0 => "Hot Water Heater" ] +"WashroomsType1": 1 +"WashroomsType2": 1 +"ContractStatus": "Available" +"WashroomsType4Pcs": 4 +"HeatType": "Radiant" +"WashroomsType4Level": "Basement" +"WashroomsType1Pcs": 4 +"HSTApplication": array:1 [ 0 => "Included In" ] +"RollNumber": "251801008305220" +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"WaterMeterYN": true +"AssessmentYear": 2025 +"SystemModificationTimestamp": "2025-07-07T19:13:04.792792Z" +"provider_name": "TRREB" +"ParkingSpaces": 4 +"PossessionDetails": "Flex Closing" +"PermissionToContactListingBrokerToAdvertise": true +"GarageType": "Detached" +"WashroomsType2Level": "Second" +"BedroomsAboveGrade": 7 +"MediaChangeTimestamp": "2025-07-03T15:07:27Z" +"WashroomsType2Pcs": 3 +"SurveyType": "Available" +"ApproximateAge": "100+" +"HoldoverDays": 30 +"WashroomsType3": 1 +"WashroomsType4": 1 +"KitchensTotal": 3 +"Media": array:45 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] 31 => array:26 [ …26] 32 => array:26 [ …26] 33 => array:26 [ …26] 34 => array:26 [ …26] 35 => array:26 [ …26] 36 => array:26 [ …26] 37 => array:26 [ …26] 38 => array:26 [ …26] 39 => array:26 [ …26] 40 => array:26 [ …26] 41 => array:26 [ …26] 42 => array:26 [ …26] 43 => array:26 [ …26] 44 => array:26 [ …26] ] } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14538 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12268369" +"ListingId": "X12268369" +"PropertyType": "Residential Lease" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-07T19:03:23Z" +"RFModificationTimestamp": "2025-07-08T11:36:18.904211+00:00" +"ListPrice": 4500.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8E 5C6" +"UnparsedAddress": "18 1/2 Lakeshore Drive, Hamilton, ON L8E 5C6" +"Coordinates": array:2 [ 0 => -79.6765501 1 => 43.2302856 ] +"Latitude": 43.2302856 +"Longitude": -79.6765501 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "SUTTON GROUP - SUMMIT REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "An Exceptional Chance To Enjoy Lakeside Living In This Waterfront Retreat. Fully Updated And Move-In Ready. Take In Gorgeous Sunrises Over The Water From Your Two-Level Deck And Patio. Marvel At Stunning Panoramic Views Of The Toronto Skyline. In The Evenings, Admire Beautiful Sunsets Over The Escarpment. Perfectly Situated Between Newport And Fifty Point Yacht Clubs. Just 10 Minutes To Burlington Waterfront, 30 Minutes To Niagara Falls And The Border, And 45 Minutes To Downtown Toronto. A Peaceful Getaway From City Life Awaits." +"ArchitecturalStyle": array:1 [ 0 => "Bungalow" ] +"Basement": array:1 [ 0 => "Partial Basement" ] +"CityRegion": "Stoney Creek" +"ConstructionMaterials": array:1 [ 0 => "Aluminum Siding" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CountyOrParish": "Hamilton" +"CoveredSpaces": "1.0" +"CreationDate": "2025-07-07T19:41:24.940152+00:00" +"CrossStreet": "Fruitland Rd/North Sevice Rd" +"DirectionFaces": "South" +"Directions": "Fruitland Rd/North Sevice Rd" +"Disclosures": array:1 [ 0 => "Unknown" ] +"ExpirationDate": "2025-10-31" +"FoundationDetails": array:1 [ 0 => "Concrete Block" ] +"Furnished": "Unfurnished" +"GarageYN": true +"InteriorFeatures": array:1 [ 0 => "Carpet Free" ] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "In Basement" ] +"LeaseTerm": "12 Months" +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-07-07" +"MainOfficeKey": "686500" +"MajorChangeTimestamp": "2025-07-07T19:03:23Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-07-07T19:03:23Z" +"OriginalListPrice": 4500.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2674624" +"ParkingTotal": "6.0" +"PhotosChangeTimestamp": "2025-07-07T19:03:23Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"RentIncludes": array:1 [ 0 => "Parking" ] +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:1 [ 0 => "Lockbox" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Lakeshore" +"StreetNumber": "18 1/2" +"StreetSuffix": "Drive" +"TransactionBrokerCompensation": "Half Month rent" +"TransactionType": "For Lease" +"View": array:2 [ 0 => "Lake" 1 => "Water" ] +"WaterBodyName": "Lake Ontario" +"WaterfrontFeatures": array:2 [ 0 => "Boat Launch" 1 => "Marina Services" ] +"WaterfrontYN": true +"Water": "Municipal" +"RoomsAboveGrade": 4 +"DDFYN": true +"LivingAreaRange": "700-1100" +"CableYNA": "Available" +"Shoreline": array:1 [ 0 => "Unknown" ] +"AlternativePower": array:1 [ 0 => "None" ] +"HeatSource": "Gas" +"WaterYNA": "Available" +"Waterfront": array:2 [ 0 => "Direct" 1 => "Waterfront Community" ] +"PortionPropertyLease": array:1 [ 0 => "Entire Property" ] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12268369')" +"WaterView": array:1 [ 0 => "Direct" ] +"ShorelineAllowance": "None" +"CreditCheckYN": true +"EmploymentLetterYN": true +"PaymentFrequency": "Monthly" +"PossessionType": "Immediate" +"DockingType": array:1 [ 0 => "None" ] +"PriorMlsStatus": "Draft" +"WaterfrontAccessory": array:1 [ 0 => "Not Applicable" ] +"PaymentMethod": "Cheque" +"short_address": "Hamilton, ON L8E 5C6, CA" +"KitchensAboveGrade": 1 +"RentalApplicationYN": true +"WashroomsType1": 1 +"AccessToProperty": array:1 [ 0 => "Public Road" ] +"GasYNA": "Available" +"ContractStatus": "Available" +"HeatType": "Forced Air" +"WaterBodyType": "Lake" +"WashroomsType1Pcs": 4 +"BuyOptionYN": true +"DepositRequired": true +"SpecialDesignation": array:1 [ 0 => "Other" ] +"TelephoneYNA": "Available" +"SystemModificationTimestamp": "2025-07-07T19:03:23.934348Z" +"provider_name": "TRREB" +"ParkingSpaces": 6 +"PossessionDetails": "ASAP" +"PermissionToContactListingBrokerToAdvertise": true +"LeaseAgreementYN": true +"GarageType": "Detached" +"ElectricYNA": "Available" +"BedroomsAboveGrade": 2 +"MediaChangeTimestamp": "2025-07-07T19:03:23Z" +"SurveyType": "None" +"Sewage": array:1 [ 0 => "Municipal Available" ] +"HoldoverDays": 60 +"SewerYNA": "Yes" +"ReferencesRequiredYN": true +"KitchensTotal": 1 +"Media": array:26 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] ] } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14535 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12268365" +"ListingId": "X12268365" +"PropertyType": "Residential Lease" +"PropertySubType": "Multiplex" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-07T19:01:46Z" +"RFModificationTimestamp": "2025-07-08T19:00:34.623772+00:00" +"ListPrice": 2360.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 0.529 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8P 3A3" +"UnparsedAddress": "#803 - 169 James Street, Hamilton, ON L8P 3A3" +"Coordinates": array:2 [ 0 => -79.8728583 1 => 43.2560802 ] +"Latitude": 43.2560802 +"Longitude": -79.8728583 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "REAL BROKER ONTARIO LTD." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "The Greystone is one of Hamilton's newest apartment buildings located within the Augusta Street restaurant district. This unit seamlessly blends contemporary design with top-of-the-line finishes. As you step inside, you'll be greeted by an open-concept layout beaming in natural light. The kitchen comes fully equipped with stainless steel appliances, quartz countertops, and ample cabinet space ideal for everyday living and entertaining. The bedroom can comfortably fit any size mattress and includes a sizable closet. Building amenities include a rooftop terrace, fitness room, and fob secured access. Located in the lively Corktown community, you'll find yourself surrounded by some of Hamilton's best restaurants like Ciao Bella, Lobby, Plank Restobar, Paloma Bar, The Ship, Secco, and Goldies's. The Hamilton Go Centre is less than a two-minute walk from the doorstep of this building! Experience the ultimate blend of comfort, convenience, and culture at The Greystone. Don't miss this extraordinary opportunity! Please note that this units price does not include parking; parking is available at additional cost." +"ArchitecturalStyle": array:1 [ 0 => "Apartment" ] +"Basement": array:1 [ 0 => "None" ] +"CityRegion": "Corktown" +"ConstructionMaterials": array:2 [ 0 => "Concrete" 1 => "Brick" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CountyOrParish": "Hamilton" +"CreationDate": "2025-07-07T19:42:07.525082+00:00" +"CrossStreet": "Augusta Street" +"DirectionFaces": "West" +"Directions": "James St S between Augusta & Young St" +"ExpirationDate": "2025-11-30" +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Furnished": "Unfurnished" +"InteriorFeatures": array:2 [ 0 => "Separate Hydro Meter" 1 => "Primary Bedroom - Main Floor" ] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "Ensuite" ] +"LeaseTerm": "12 Months" +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-07-07" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "384000" +"MajorChangeTimestamp": "2025-07-07T19:01:46Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2025-07-07T19:01:46Z" +"OriginalListPrice": 2360.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2653676" +"ParcelNumber": "171730003" +"ParkingFeatures": array:1 [ 0 => "Private" ] +"PhotosChangeTimestamp": "2025-07-07T19:01:46Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"RentIncludes": array:5 [ 0 => "Building Maintenance" 1 => "Grounds Maintenance" 2 => "Exterior Maintenance" 3 => "Water" 4 => "Interior Maintenance" ] +"Roof": array:1 [ 0 => "Flat" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "S" +"StreetName": "James" +"StreetNumber": "169" +"StreetSuffix": "Street" +"TransactionBrokerCompensation": "half month's lawful rent plus HST" +"TransactionType": "For Lease" +"UnitNumber": "803" +"Water": "Municipal" +"RoomsAboveGrade": 4 +"DDFYN": true +"LivingAreaRange": "< 700" +"HeatSource": "Electric" +"Waterfront": array:1 [ 0 => "None" ] +"PropertyFeatures": array:6 [ 0 => "Arts Centre" 1 => "Golf" 2 => "Electric Car Charger" 3 => "Park" 4 => "Place Of Worship" 5 => "Public Transit" ] +"PortionPropertyLease": array:1 [ 0 => "Main" ] +"LotWidth": 75.9 +"LotShape": "Irregular" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12268365')" +"LotSizeAreaUnits": "Acres" +"WashroomsType1Level": "Main" +"Winterized": "Fully" +"ElevatorYN": true +"LotDepth": 133.68 +"ShowingAppointments": "please allow 24 hours notice, tenant occupied" +"CreditCheckYN": true +"EmploymentLetterYN": true +"ParcelOfTiedLand": "No" +"PaymentFrequency": "Monthly" +"PossessionType": "30-59 days" +"PrivateEntranceYN": true +"PriorMlsStatus": "Draft" +"LaundryLevel": "Main Level" +"PaymentMethod": "Direct Withdrawal" +"PossessionDate": "2025-08-01" +"short_address": "Hamilton, ON L8P 3A3, CA" +"PropertyManagementCompany": "James Hughson LP" +"KitchensAboveGrade": 1 +"RentalApplicationYN": true +"WashroomsType1": 1 +"ContractStatus": "Available" +"HeatType": "Forced Air" +"WashroomsType1Pcs": 4 +"RollNumber": "251802014400100" +"DepositRequired": true +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"SystemModificationTimestamp": "2025-07-07T19:01:46.906095Z" +"provider_name": "TRREB" +"LeaseAgreementYN": true +"LotSizeRangeAcres": ".50-1.99" +"GarageType": "Attached" +"BedroomsAboveGrade": 1 +"MediaChangeTimestamp": "2025-07-07T19:01:46Z" +"SurveyType": "None" +"ApproximateAge": "New" +"HoldoverDays": 45 +"ReferencesRequiredYN": true +"KitchensTotal": 1 +"Media": array:7 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] ] } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14530 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12264144" +"ListingId": "X12264144" +"PropertyType": "Residential" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-07T18:58:45Z" +"RFModificationTimestamp": "2025-07-07T19:39:23.553556+00:00" +"ListPrice": 649900.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8N 1A8" +"UnparsedAddress": "#lph13 - 118 King Street, Hamilton, ON L8N 1A8" +"Coordinates": array:2 [ 0 => -79.8728583 1 => 43.2560802 ] +"Latitude": 43.2560802 +"Longitude": -79.8728583 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE STATE REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to this lovely lower penthouse at the iconic Royal Connaught, a beautifully preserved piece of Hamiltons history right in the heart of downtown. This pristine, sun-filled unit offers soaring 13-foot ceilings, a bright open-concept layout, and southwest views. The modern kitchen is perfect for entertaining, featuring a waterfall quartz island, matching quartz countertops, and custom glass backsplash. The spacious living area includes a custom feature wall with electric fireplace. Enjoy added comfort and convenience with automated blinds throughout, a double vanity in the large 4-piece bath, a custom glass-enclosed tub/shower,in-suite laundry, and a walk-in closet in the primary bedroom. This unit also comes with an owned locker and an underground parking spot. Located just steps to everything you love about city living including trendy cafes, shops, art galleries, restaurants, and the vibrant energy of James Street. You'll also love the easy access to hospital services, transit, and GO Station connections. If you're ready for a blend of luxury, history, and urban convenience, this spectacular condo might just be your perfect match." +"ArchitecturalStyle": array:1 [ 0 => "1 Storey/Apt" ] +"AssociationAmenities": array:4 [ 0 => "Community BBQ" 1 => "Gym" 2 => "Media Room" 3 => "Rooftop Deck/Garden" ] +"AssociationFee": "690.9" +"AssociationFeeIncludes": array:2 [ 0 => "Common Elements Included" 1 => "Building Insurance Included" ] +"Basement": array:1 [ 0 => "None" ] +"CityRegion": "Beasley" +"ConstructionMaterials": array:2 [ 0 => "Brick" 1 => "Concrete Block" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CoveredSpaces": "1.0" +"CreationDate": "2025-07-04T21:01:08.752129+00:00" +"CrossStreet": "Catherine St S" +"Directions": "Corner of King St E & Catherine St S" +"Exclusions": "TV, Sound Bar" +"ExpirationDate": "2025-12-31" +"ExteriorFeatures": array:1 [ 0 => "Controlled Entry" ] +"FireplaceYN": true +"GarageYN": true +"Inclusions": "Refrigerator, Stove, Dishwasher, Microwave, Stackable Washer/Dryer, All Light Fixtures, All Window Coverings" +"InteriorFeatures": array:1 [ 0 => "Carpet Free" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "In-Suite Laundry" ] +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-07-04" +"LotSizeSource": "MPAC" +"MainOfficeKey": "288000" +"MajorChangeTimestamp": "2025-07-04T20:42:44Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-07-04T20:42:44Z" +"OriginalListPrice": 649900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2662088" +"ParcelNumber": "185730150" +"ParkingFeatures": array:1 [ 0 => "Underground" ] +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ 0 => "Restricted" ] +"PhotosChangeTimestamp": "2025-07-05T20:22:42Z" +"SecurityFeatures": array:1 [ 0 => "Concierge/Security" ] +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "E" +"StreetName": "King" +"StreetNumber": "118" +"StreetSuffix": "Street" +"TaxAnnualAmount": "6574.0" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2% + hst; 1% redctn appl if buyer shown by LB" +"TransactionType": "For Sale" +"UnitNumber": "LPH13" +"View": array:1 [ 0 => "City" ] +"RoomsAboveGrade": 4 +"PropertyManagementCompany": "Property Management Guild" +"Locker": "Owned" +"KitchensAboveGrade": 1 +"UnderContract": array:1 [ 0 => "None" ] +"WashroomsType1": 1 +"DDFYN": true +"LivingAreaRange": "1000-1199" +"HeatSource": "Gas" +"ContractStatus": "Available" +"PropertyFeatures": array:6 [ 0 => "Arts Centre" 1 => "Hospital" 2 => "Library" 3 => "Park" 4 => "Place Of Worship" 5 => "Public Transit" ] +"HeatType": "Heat Pump" +"StatusCertificateYN": true +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12264144')" +"WashroomsType1Pcs": 4 +"WashroomsType1Level": "Main" +"HSTApplication": array:1 [ 0 => "Included In" ] +"RollNumber": "251802015150681" +"LegalApartmentNumber": "2" +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"AssessmentYear": 2025 +"SystemModificationTimestamp": "2025-07-07T18:58:46.871484Z" +"provider_name": "TRREB" +"ElevatorYN": true +"LegalStories": "12" +"PossessionDetails": "Flexible" +"ParkingType1": "Owned" +"ShowingAppointments": "LBO/BB 3hr notice." +"GarageType": "Underground" +"BalconyType": "Juliette" +"PossessionType": "Flexible" +"Exposure": "South West" +"PriorMlsStatus": "Draft" +"BedroomsAboveGrade": 2 +"SquareFootSource": "Other" +"MediaChangeTimestamp": "2025-07-05T20:22:42Z" +"SurveyType": "None" +"ApproximateAge": "6-10" +"HoldoverDays": 120 +"CondoCorpNumber": 573 +"EnsuiteLaundryYN": true +"KitchensTotal": 1 +"Media": array:40 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] 31 => array:26 [ …26] 32 => array:26 [ …26] 33 => array:26 [ …26] 34 => array:26 [ …26] 35 => array:26 [ …26] 36 => array:26 [ …26] 37 => array:26 [ …26] 38 => array:26 [ …26] 39 => array:26 [ …26] ] } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14509 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12104901" +"ListingId": "X12104901" +"PropertyType": "Residential" +"PropertySubType": "Condo Townhouse" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-07T18:53:36Z" +"RFModificationTimestamp": "2025-07-07T18:57:42.802617+00:00" +"ListPrice": 599000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8H 6X1" +"UnparsedAddress": "454 Beach Boulevard, Hamilton, On L8h 6x1" +"Coordinates": array:2 [ 0 => -79.7809641 1 => 43.2753026 ] +"Latitude": 43.2753026 +"Longitude": -79.7809641 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "THE AGENCY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Live the Lakefront Lifestyle in Hamilton Beach. Located just steps from the shoreline, this residence offers a rare opportunity to experience the vibrant charm of the Hamilton Beach community. Nestled on Beach Boulevard, the home is part of a well-maintained condominium enclave known for its quiet setting and close-knit atmosphere. Surrounded by natural beauty, this home is perfectly positioned near the waterfront trail, Confederation Park, and the shores of Lake Ontario offering direct access to outdoor recreation, bike rides, and scenic views. Enjoy seamless connectivity to the QEW, downtown Hamilton, and Burlington, with the upcoming Confederation GO Station just minutes away for added convenience. Inside, the home boasts 3spacious bedrooms and 2.5 bathrooms, showcasing a modern coastal design that reflects the elegance and ease of this established lakeside development. As one of the largest two-story homes in the enclave, it features a very large second-level recreation room, perfect for entertaining or relaxing, along with a split staircase that offers added privacy leading to the bedroom wing. The exterior includes classic finishes, a private driveway, and an attached garage, blending style with practicality. With low condo fees, this property presents a fantastic opportunity for first-time buyers, savvy investors, or those looking to downsize without compromise. Enjoy afternoon strolls along the boardwalk or sunset cocktails at Barangas on the Beach all just steps from your front door. This property is offered with vacant possession on closing, making it move-in ready and waiting for its next chapter." +"ArchitecturalStyle": array:1 [ 0 => "2-Storey" ] +"AssociationFee": "203.0" +"AssociationFeeIncludes": array:1 [ 0 => "Common Elements Included" ] +"Basement": array:1 [ 0 => "None" ] +"BuildingName": "WENTWORTH STANDARD" +"CityRegion": "Hamilton Beach" +"ConstructionMaterials": array:2 [ 0 => "Aluminum Siding" 1 => "Brick" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CountyOrParish": "Hamilton" +"CoveredSpaces": "1.0" +"CreationDate": "2025-04-26T08:25:03.229728+00:00" +"CrossStreet": "Beach Blv, Tower Dr" +"Directions": "Beach Blv, Tower Dr" +"Exclusions": "Tenant belongings" +"ExpirationDate": "2025-08-24" +"FireplaceYN": true +"GarageYN": true +"Inclusions": "Washer, fridge, stove, dishwasher." +"InteriorFeatures": array:1 [ 0 => "Water Heater" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "In Area" ] +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-04-25" +"MainOfficeKey": "350300" +"MajorChangeTimestamp": "2025-07-07T18:53:36Z" +"MlsStatus": "Price Change" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2025-04-25T18:17:28Z" +"OriginalListPrice": 699000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2289862" +"ParcelNumber": "184480020" +"ParkingFeatures": array:1 [ 0 => "Inside Entry" ] +"ParkingTotal": "2.0" +"PetsAllowed": array:1 [ 0 => "Restricted" ] +"PhotosChangeTimestamp": "2025-04-25T18:17:28Z" +"PreviousListPrice": 610000.0 +"PriceChangeTimestamp": "2025-07-07T18:53:36Z" +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"SecurityFeatures": array:1 [ 0 => "Smoke Detector" ] +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Beach" +"StreetNumber": "454" +"StreetSuffix": "Boulevard" +"TaxAnnualAmount": "4300.0" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2% plus HST" +"TransactionType": "For Sale" +"RoomsAboveGrade": 10 +"PropertyManagementCompany": "Green Brick Property" +"Locker": "None" +"KitchensAboveGrade": 1 +"UnderContract": array:1 [ 0 => "Hot Water Heater" ] +"WashroomsType1": 1 +"DDFYN": true +"WashroomsType2": 1 +"LivingAreaRange": "1600-1799" +"HeatSource": "Gas" +"ContractStatus": "Available" +"PropertyFeatures": array:6 [ 0 => "Beach" 1 => "Clear View" 2 => "Hospital" 3 => "Level" 4 => "Park" 5 => "Public Transit" ] +"HeatType": "Forced Air" +"WashroomsType3Pcs": 2 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12104901')" +"WashroomsType1Pcs": 4 +"WashroomsType1Level": "Second" +"HSTApplication": array:1 [ 0 => "Included In" ] +"RollNumber": "251805051106823" +"LegalApartmentNumber": "20" +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"SystemModificationTimestamp": "2025-07-07T18:53:38.519951Z" +"provider_name": "TRREB" +"ParkingSpaces": 1 +"LegalStories": "1" +"PossessionDetails": "TBD" +"ParkingType1": "Owned" +"PermissionToContactListingBrokerToAdvertise": true +"GarageType": "Attached" +"BalconyType": "None" +"PossessionType": "90+ days" +"Exposure": "South East" +"PriorMlsStatus": "New" +"WashroomsType2Level": "Second" +"BedroomsAboveGrade": 3 +"SquareFootSource": "3rd party" +"MediaChangeTimestamp": "2025-04-25T18:17:28Z" +"WashroomsType2Pcs": 4 +"RentalItems": "water heater" +"DenFamilyroomYN": true +"SurveyType": "Unknown" +"ApproximateAge": "16-30" +"HoldoverDays": 90 +"CondoCorpNumber": 448 +"WashroomsType3": 1 +"WashroomsType3Level": "Main" +"KitchensTotal": 1 +"PossessionDate": "2025-07-31" +"Media": array:14 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] ] } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14508 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12193390" +"ListingId": "X12193390" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-07T18:47:01Z" +"RFModificationTimestamp": "2025-07-07T19:07:43.836612+00:00" +"ListPrice": 1149999.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L9B 2V7" +"UnparsedAddress": "317 Jacqueline Boulevard, Hamilton, ON L9B 2V7" +"Coordinates": array:2 [ 0 => -79.8861372 1 => 43.1954329 ] +"Latitude": 43.1954329 +"Longitude": -79.8861372 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX ESCARPMENT GOLFI REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to 317 Jacqueline Blvd a rare opportunity to own a beautifully maintained and spacious 2-storey home with over 2,200 sq ft above grade, plus a fully finished basement, in one of the most sought-after neighbourhoods on the Hamilton Mountain. Proudly owned by the original owners and built in 2002, this home blends timeless charm with modern comfort. Step inside to find gleaming hardwood floors, a bright and open eat-in kitchen with patio doors leading to your private backyard, a separate dining room perfect for family gatherings, and a warm, inviting living area designed for everyday comfort. Upstairs, you'll find 4 generously sized bedrooms and 2 full bathrooms, including a luxuriously updated ensuite off the primary bedroom, complete with heated floors - a perfect retreat after a long day. The fully finished basement adds exceptional living space with a spacious rec room, wet bar, two private offices, and a beautifully finished bathroom with heated floors - ideal for remote work, entertaining, or multi-generational living. Step outside to your own backyard oasis with complete privacy, no rear neighbours, a deep 131 ft lot, heated above-ground saltwater pool, and a two-tiered deck - perfect for summer entertaining or peaceful evenings under the stars. Conveniently located just minutes from parks, top-rated schools, shopping, and quick access to Highway 403 and the LINC, this incredible home truly has it all. Don't miss your chance to make 317 Jacqueline Blvd your forever home!" +"ArchitecturalStyle": array:1 [ 0 => "2-Storey" ] +"Basement": array:2 [ 0 => "Full" 1 => "Finished" ] +"CityRegion": "Allison" +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CountyOrParish": "Hamilton" +"CoveredSpaces": "2.0" +"CreationDate": "2025-06-03T20:20:54.207643+00:00" +"CrossStreet": "-" +"DirectionFaces": "South" +"Directions": "Kettlepoint Drive to Jacqueline Blvd" +"ExpirationDate": "2025-12-31" +"ExteriorFeatures": array:1 [ 0 => "Deck" ] +"FireplaceFeatures": array:1 [ 0 => "Natural Gas" ] +"FireplaceYN": true +"FoundationDetails": array:1 [ 0 => "Concrete Block" ] +"GarageYN": true +"Inclusions": "Dishwasher, Dryer, Refrigerator, Stove, Washer, Window Coverings, ELF's, above ground pool and related equipment." +"InteriorFeatures": array:1 [ 0 => "In-Law Capability" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-06-03" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "269900" +"MajorChangeTimestamp": "2025-07-07T18:47:01Z" +"MlsStatus": "Price Change" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-06-03T20:01:57Z" +"OriginalListPrice": 1199999.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2499112" +"ParcelNumber": "169050676" +"ParkingFeatures": array:1 [ 0 => "Front Yard Parking" ] +"ParkingTotal": "6.0" +"PhotosChangeTimestamp": "2025-06-05T00:44:42Z" +"PoolFeatures": array:2 [ 0 => "Above Ground" 1 => "Salt" ] +"PreviousListPrice": 1199999.0 +"PriceChangeTimestamp": "2025-07-07T18:47:01Z" +"Roof": array:2 [ 0 => "Asphalt Shingle" 1 => "Solar" ] +"SecurityFeatures": array:1 [ 0 => "Alarm System" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:1 [ 0 => "Lockbox" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Jacqueline" +"StreetNumber": "317" +"StreetSuffix": "Boulevard" +"TaxAnnualAmount": "7216.19" +"TaxLegalDescription": "LOT 10, PLAN 62M957, GLANFORD, HAMILTON; S/T AN EASEMENT AS IN WE96784 , S/T RT IN FAVOUR OF 839891 ONTARIO INC. TO ENTER AT ANY TIME PRIOR TO THE ACCEPTANCE BY THE CITY OF HAMILTON OF PLAN 62M957, AS IN WE137328 , T/W RT OVER PT LOT 9 BEING PT 9 ON 62R-16179 AS IN WE137328 , S/T RT IN FAVOUR OF LOT 11 OVER PT LOT 10 BEING PT 10 ON 62R-16170 AS IN WE137328" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2%" +"TransactionType": "For Sale" +"Water": "Municipal" +"RoomsAboveGrade": 6 +"KitchensAboveGrade": 1 +"WashroomsType1": 1 +"DDFYN": true +"WashroomsType2": 1 +"LivingAreaRange": "2000-2500" +"HeatSource": "Gas" +"ContractStatus": "Available" +"RoomsBelowGrade": 3 +"EnergyCertificate": true +"WashroomsType4Pcs": 3 +"LotWidth": 23.01 +"HeatType": "Forced Air" +"WashroomsType4Level": "Lower" +"LotShape": "Irregular" +"WashroomsType3Pcs": 5 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12193390')" +"WashroomsType1Pcs": 2 +"WashroomsType1Level": "Main" +"HSTApplication": array:1 [ 0 => "Included In" ] +"RollNumber": "251807113206307" +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"SystemModificationTimestamp": "2025-07-07T18:47:04.617088Z" +"provider_name": "TRREB" +"LotDepth": 131.22 +"ParkingSpaces": 4 +"PossessionDetails": "-" +"PermissionToContactListingBrokerToAdvertise": true +"ShowingAppointments": "905-592-7777" +"LotSizeRangeAcres": "< .50" +"GarageType": "Attached" +"PossessionType": "Flexible" +"PriorMlsStatus": "New" +"LeaseToOwnEquipment": array:2 [ 0 => "Air Conditioner" 1 => "Water Filtration System" ] +"WashroomsType2Level": "Second" +"BedroomsAboveGrade": 3 +"MediaChangeTimestamp": "2025-06-05T00:44:42Z" +"WashroomsType2Pcs": 4 +"RentalItems": "Air Conditioner, Furnace, Tankless Water Heater, Water Filtration System" +"SurveyType": "None" +"ApproximateAge": "16-30" +"HoldoverDays": 90 +"LaundryLevel": "Upper Level" +"WashroomsType3": 1 +"WashroomsType3Level": "Second" +"WashroomsType4": 1 +"KitchensTotal": 1 +"Media": array:40 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] 31 => array:26 [ …26] 32 => array:26 [ …26] 33 => array:26 [ …26] 34 => array:26 [ …26] 35 => array:26 [ …26] 36 => array:26 [ …26] 37 => array:26 [ …26] 38 => array:26 [ …26] 39 => array:26 [ …26] ] } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14507 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12227118" +"ListingId": "X12227118" +"PropertyType": "Residential Lease" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-07T18:45:56Z" +"RFModificationTimestamp": "2025-07-07T18:49:34.563585+00:00" +"ListPrice": 2600.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L9A 5J6" +"UnparsedAddress": "1 Resolute(upper Unit) Drive, Hamilton, ON L9A 5J6" +"Coordinates": array:2 [ 0 => -79.8728583 1 => 43.2560802 ] +"Latitude": 43.2560802 +"Longitude": -79.8728583 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "META REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "*** ONLY UPPER UNIT*** Discover this bright and spacious home, accommodating a large family. Situated in the highly sought-after Hamilton Mountain, conveniently close to all major amenities, like the Lime Ridge Mall, parks and recreation centres and with quick access to the Linc Highway. The home boasts a large double concrete driveway, a 1.5 car garage, Enjoy the spacious kitchen with ample counter space and many modern updates including new quartz countertop (2023), appliances (2023), hardwood flooring (2018), and central vacuum. High-quality triple-pane windows (2023), a new roof, an updated washroom, and a large walk-in closet in the primary bedroom enhance the living experience. Additional features include a tankless hot water heater, furnace (2016), AC (2017), new washer/dryer (2023), a home security system, plenty of storage spaces and an electrically equipped shed." +"ArchitecturalStyle": array:1 [ 0 => "Backsplit 3" ] +"Basement": array:1 [ 0 => "None" ] +"CityRegion": "Crerar" +"ConstructionMaterials": array:2 [ 0 => "Brick" 1 => "Vinyl Siding" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CountyOrParish": "Hamilton" +"CoveredSpaces": "1.5" +"CreationDate": "2025-06-18T00:18:02.025706+00:00" +"CrossStreet": "UPPER WENTWORTH" +"DirectionFaces": "North" +"Directions": "UPPER WENTWORTH" +"Exclusions": "None" +"ExpirationDate": "2025-09-17" +"FireplaceYN": true +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Furnished": "Unfurnished" +"GarageYN": true +"Inclusions": "Dishwasher, Dryer, Microwave, Refrigerator, Stove, Washer" +"InteriorFeatures": array:1 [ 0 => "None" ] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:2 [ 0 => "Laundry Room" 1 => "In Basement" ] +"LeaseTerm": "12 Months" +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-06-17" +"MainOfficeKey": "422100" +"MajorChangeTimestamp": "2025-07-07T18:45:56Z" +"MlsStatus": "Price Change" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2025-06-17T18:38:56Z" +"OriginalListPrice": 2700.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2576444" +"ParkingFeatures": array:1 [ 0 => "Private" ] +"ParkingTotal": "2.5" +"PhotosChangeTimestamp": "2025-06-17T18:38:56Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"PreviousListPrice": 2700.0 +"PriceChangeTimestamp": "2025-07-07T18:45:56Z" +"RentIncludes": array:1 [ 0 => "Parking" ] +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:1 [ 0 => "Lockbox" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "RESOLUTE(UPPER UNIT)" +"StreetNumber": "1" +"StreetSuffix": "Drive" +"TransactionBrokerCompensation": "Half month rent+ Hst" +"TransactionType": "For Lease" +"Water": "Municipal" +"RoomsAboveGrade": 4 +"KitchensAboveGrade": 1 +"RentalApplicationYN": true +"WashroomsType1": 1 +"DDFYN": true +"LivingAreaRange": "1100-1500" +"VendorPropertyInfoStatement": true +"GasYNA": "Yes" +"CableYNA": "Yes" +"HeatSource": "Gas" +"ContractStatus": "Available" +"WaterYNA": "Yes" +"PropertyFeatures": array:4 [ 0 => "Park" 1 => "Place Of Worship" 2 => "Public Transit" 3 => "School Bus Route" ] +"PortionPropertyLease": array:2 [ 0 => "2nd Floor" 1 => "3rd Floor" ] +"LotWidth": 44.29 +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12227118')" +"WashroomsType1Pcs": 4 +"WashroomsType1Level": "Third" +"DepositRequired": true +"SpecialDesignation": array:1 [ 0 => "Other" ] +"TelephoneYNA": "Yes" +"SystemModificationTimestamp": "2025-07-07T18:45:57.664088Z" +"provider_name": "TRREB" +"LotDepth": 100.23 +"ParkingSpaces": 1 +"PermissionToContactListingBrokerToAdvertise": true +"LeaseAgreementYN": true +"CreditCheckYN": true +"EmploymentLetterYN": true +"GarageType": "Attached" +"PaymentFrequency": "Monthly" +"PossessionType": "Immediate" +"PrivateEntranceYN": true +"ElectricYNA": "Yes" +"PriorMlsStatus": "New" +"BedroomsAboveGrade": 3 +"MediaChangeTimestamp": "2025-06-17T18:38:56Z" +"RentalItems": "HOt water tank" +"SurveyType": "Unknown" +"ApproximateAge": "16-30" +"HoldoverDays": 90 +"SewerYNA": "Yes" +"ReferencesRequiredYN": true +"PaymentMethod": "Other" +"KitchensTotal": 1 +"PossessionDate": "2025-07-15" +"Media": array:33 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] 31 => array:26 [ …26] 32 => array:26 [ …26] ] } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14506 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12268284" +"ListingId": "X12268284" +"PropertyType": "Residential" +"PropertySubType": "Vacant Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-07T18:44:06Z" +"RFModificationTimestamp": "2025-07-08T17:02:13.385636+00:00" +"ListPrice": 2999000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L0R 1C0" +"UnparsedAddress": "2311 Highway 56, Hamilton, ON L0R 1C0" +"Coordinates": array:2 [ 0 => -79.8728583 1 => 43.2560802 ] +"Latitude": 43.2560802 +"Longitude": -79.8728583 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX ESCARPMENT GOLFI REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Attention Builders, Developers, Investors & Dream-Home Seekers! An incredible opportunity awaits w/ this rare 5.54-acre parcel in the heart of Binbrook, one of Ontarios fastest-growing communities. Surrounded by new residential & multi-purpose developments, this prime piece of real estate offers endless potential. 4 bdrm, 2 bath bungalow w/ walkout basement currently on the property, opportunity to rent or live in while planning your next move. Includes massive 30' x 60' detached workshop/garage w/ 14ft ceilings & concrete floors, horse barns, ample parking & 2 driveways. With flat topography & generous frontage, the land offers a versatile canvas for future residential or multi-use development proposals. Close proximity to all amenities makes it a convenient & strategic investment. Rare & valuable opportunity to invest in a region experiencing rapid growth. Continued development & infrastructure plans underway in the surrounding area, this parcel is poised for strong appreciation." +"ArchitecturalStyle": array:1 [ 0 => "Bungalow" ] +"CityRegion": "Rural Glanbrook" +"ConstructionMaterials": array:1 [ 0 => "Vinyl Siding" ] +"CountyOrParish": "Hamilton" +"CoveredSpaces": "10.0" +"CreationDate": "2025-07-07T18:53:46.060529+00:00" +"CrossStreet": "Guyatt Rd" +"DirectionFaces": "East" +"Directions": "Guyatt Rd" +"ExpirationDate": "2025-12-31" +"GarageYN": true +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-07-07" +"LotSizeSource": "MPAC" +"MainOfficeKey": "269900" +"MajorChangeTimestamp": "2025-07-07T18:44:06Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2025-07-07T18:44:06Z" +"OriginalListPrice": 2999000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2674742" +"OtherStructures": array:3 [ 0 => "Additional Garage(s)" 1 => "Barn" 2 => "Workshop" ] +"ParcelNumber": "173840073" +"ParkingFeatures": array:2 [ 0 => "Private" 1 => "RV/Truck" ] +"ParkingTotal": "28.0" +"PhotosChangeTimestamp": "2025-07-07T18:44:06Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"Sewer": array:1 [ 0 => "Septic" ] +"ShowingRequirements": array:2 [ 0 => "Go Direct" 1 => "Showing System" ] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Highway 56" +"StreetNumber": "2311" +"StreetSuffix": "N/A" +"TaxAnnualAmount": "5967.82" +"TaxLegalDescription": "PT LT 5, BLK 3, CON 3 BINBROOK , AS IN VM62390 ; GLANBROOK CITY OF HAMILTON" +"TaxYear": "2025" +"Topography": array:2 [ 0 => "Flat" 1 => "Level" ] +"TransactionBrokerCompensation": "2%" +"TransactionType": "For Sale" +"View": array:1 [ 0 => "Clear" ] +"WaterSource": array:1 [ 0 => "Drilled Well" ] +"Zoning": "A1" +"Water": "Well" +"DDFYN": true +"LivingAreaRange": "1500-2000" +"GasYNA": "Yes" +"CableYNA": "Available" +"HeatSource": "Gas" +"ContractStatus": "Available" +"WaterYNA": "Available" +"Waterfront": array:1 [ 0 => "None" ] +"PropertyFeatures": array:5 [ 0 => "Clear View" 1 => "Golf" 2 => "Level" 3 => "School Bus Route" 4 => "Wooded/Treed" ] +"LotWidth": 270.5 +"HeatType": "Forced Air" +"LotShape": "Rectangular" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12268284')" +"HSTApplication": array:1 [ 0 => "Included In" ] +"RollNumber": "251890131074400" +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"TelephoneYNA": "Available" +"SystemModificationTimestamp": "2025-07-07T18:44:07.135794Z" +"provider_name": "TRREB" +"LotDepth": 649.0 +"ParkingSpaces": 18 +"PossessionDetails": "Flexible" +"ShowingAppointments": "905-592-7777" +"LotSizeRangeAcres": "5-9.99" +"GarageType": "Detached" +"PossessionType": "Flexible" +"ElectricYNA": "Yes" +"PriorMlsStatus": "Draft" +"MediaChangeTimestamp": "2025-07-07T18:44:06Z" +"SurveyType": "None" +"HoldoverDays": 60 +"SewerYNA": "Available" +"PossessionDate": "2025-08-29" +"short_address": "Hamilton, ON L0R 1C0, CA" +"Media": array:40 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] 31 => array:26 [ …26] 32 => array:26 [ …26] 33 => array:26 [ …26] 34 => array:26 [ …26] 35 => array:26 [ …26] 36 => array:26 [ …26] 37 => array:26 [ …26] 38 => array:26 [ …26] 39 => array:26 [ …26] ] } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14505 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12268278" +"ListingId": "X12268278" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-07T18:43:25Z" +"RFModificationTimestamp": "2025-07-08T19:00:33.822543+00:00" +"ListPrice": 849900.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 6.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8W 1A7" +"UnparsedAddress": "704 Stone Church Road, Hamilton, ON L8W 1A7" +"Coordinates": array:2 [ 0 => -79.9248329 1 => 43.2200077 ] +"Latitude": 43.2200077 +"Longitude": -79.9248329 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX REALTY SERVICES INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to This All-Brick and Stone Bungalow in the Heart of Hamilton's Desirable Eleanor Neighborhood. Built in 2008, This Home Features 3+3 Bedrooms, 9 Ft Ceilings, and Great Curb Appeal. The Main Floor Offers a Spacious Living Room, Two Full Bathrooms, Three Large Bedrooms, and a Well-Equipped Kitchen With Stainless Steel Appliances and a Built-in Dishwasher. The Fully Finished Basement Has a Separate Entrance, Three Bedrooms, a Full Kitchen, and Its Own Laundry, Ideal for Extended Family or Rental Income. With an Extended Driveway Fitting up to Six Cars and Two Separate Laundry Areas, This Home Suits Upsizers, Downsizers, or Investors Alike. Close to Top-Rated Schools, Shopping, Transit, Major Highways, Mohawk College, and Just a Short Drive to Ancaster, this Location Offers Both Comfort and Convenience." +"ArchitecturalStyle": array:1 [ 0 => "Bungalow" ] +"AttachedGarageYN": true +"Basement": array:2 [ 0 => "Apartment" 1 => "Separate Entrance" ] +"CityRegion": "Eleanor" +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CoolingYN": true +"Country": "CA" +"CountyOrParish": "Hamilton" +"CoveredSpaces": "1.0" +"CreationDate": "2025-07-07T18:53:35.954600+00:00" +"CrossStreet": "Upper Sherman Ave & Stone Church Rd E" +"DirectionFaces": "South" +"Directions": "Upper Sherman Ave & Stone Church Rd E" +"ExpirationDate": "2025-09-26" +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"GarageYN": true +"HeatingYN": true +"Inclusions": "All Existing Appliances: 2 Stoves, 2 Fridges, 2 B/I Dishwasher, All Elf's, and Washer & Dryer" +"InteriorFeatures": array:1 [ 0 => "None" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-07-07" +"LotDimensionsSource": "Other" +"LotFeatures": array:1 [ 0 => "Irregular Lot" ] +"LotSizeDimensions": "39.60 x 100.00 Feet (Separate Side Entrance)" +"LotSizeSource": "Other" +"MainLevelBathrooms": 1 +"MainLevelBedrooms": 2 +"MainOfficeKey": "498000" +"MajorChangeTimestamp": "2025-07-07T18:43:25Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-07-07T18:43:25Z" +"OriginalListPrice": 849900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2674514" +"ParcelNumber": "169210224" +"ParkingFeatures": array:1 [ 0 => "Private" ] +"ParkingTotal": "6.0" +"PhotosChangeTimestamp": "2025-07-07T18:43:25Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"Roof": array:1 [ 0 => "Shingles" ] +"RoomsTotal": "15" +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:1 [ 0 => "Lockbox" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "E" +"StreetName": "Stone Church" +"StreetNumber": "704" +"StreetSuffix": "Road" +"TaxAnnualAmount": "3870.0" +"TaxBookNumber": "251807074100405" +"TaxLegalDescription": "Barton Con 8 Pt Lot 8 Rp 62R17655 Part 3" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2% + HST" +"TransactionType": "For Sale" +"Zoning": "Residential" +"Water": "Municipal" +"RoomsAboveGrade": 9 +"KitchensAboveGrade": 1 +"WashroomsType1": 1 +"DDFYN": true +"WashroomsType2": 1 +"LivingAreaRange": "1100-1500" +"HeatSource": "Gas" +"ContractStatus": "Available" +"RoomsBelowGrade": 6 +"PropertyFeatures": array:6 [ 0 => "Golf" 1 => "Hospital" 2 => "Place Of Worship" 3 => "Public Transit" 4 => "Rec./Commun.Centre" 5 => "School" ] +"LotWidth": 39.6 +"HeatType": "Forced Air" +"WashroomsType3Pcs": 4 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12268278')" +"WashroomsType1Pcs": 3 +"WashroomsType1Level": "Main" +"HSTApplication": array:1 [ 0 => "Included In" ] +"RollNumber": "251807074100405" +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"SystemModificationTimestamp": "2025-07-07T18:43:25.91074Z" +"provider_name": "TRREB" +"KitchensBelowGrade": 1 +"LotDepth": 100.0 +"ParkingSpaces": 5 +"PossessionDetails": "TBD" +"PermissionToContactListingBrokerToAdvertise": true +"LotSizeRangeAcres": "< .50" +"BedroomsBelowGrade": 3 +"GarageType": "Built-In" +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"PictureYN": true +"WashroomsType2Level": "Main" +"BedroomsAboveGrade": 3 +"MediaChangeTimestamp": "2025-07-07T18:43:25Z" +"WashroomsType2Pcs": 3 +"BoardPropertyType": "Free" +"LotIrregularities": "Separate Side Entrance" +"SurveyType": "Unknown" +"HoldoverDays": 90 +"StreetSuffixCode": "Rd" +"MLSAreaDistrictOldZone": "X14" +"WashroomsType3": 1 +"WashroomsType3Level": "Basement" +"MLSAreaMunicipalityDistrict": "Hamilton" +"KitchensTotal": 2 +"short_address": "Hamilton, ON L8W 1A7, CA" +"Media": array:22 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] ] } ] +success: true +page_size: 10 +page_count: 414 +count: 4132 +after_key: "" } ] ]
