4105 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: dd67b60ba67823dc19aca8c3624522c0b68c6aa48b87b751376a416371418f8b" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#14465 +items: array:10 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14651 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12271515" +"ListingId": "X12271515" +"PropertyType": "Residential" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-08T20:20:55Z" +"RFModificationTimestamp": "2025-07-09T04:05:27Z" +"ListPrice": 299000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8L 5E1" +"UnparsedAddress": "#102 - 28 Victoria Avenue, Hamilton, ON L8L 5E1" +"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": "Stylish. Sunlit. Steps to everything. This beautifully updated 2-bedroom main-level condo is bright, welcoming, and completely move-in ready. The open-concept layout offers a fully equipped kitchen with stainless steel appliances, granite counters, and a peninsula for casual dining plus a walkout to your own deck and exclusive parking spot just steps away. You'll love the in-suite laundry (plus additional laundry facilities in the building), thoughtful storage, and fresh 2024 upgrades including new flooring, a brand new air handler, and a full interior paint refresh. Set in a well-managed building in Central Hamilton, you're surrounded by transit, local restaurants, green space, and all major hospitals including Hamilton General, Ron Joyce, Juravinski, St. Joes, and Mc Master. Whether you're a first-time buyer or medical professional, this is the perfect opportunity to own something clean, modern, and low-maintenance right where you need it. Condo fees include water, parking spot, storage locker, exterior maintenance, and building insurance." +"ArchitecturalStyle": array:1 [ 0 => "Apartment" ] +"AssociationFee": "623.71" +"AssociationFeeIncludes": array:3 [ 0 => "Water Included" 1 => "Common Elements Included" 2 => "Parking Included" ] +"Basement": array:1 [ 0 => "None" ] +"CityRegion": "Landsdale" +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": array:1 [ 0 => "Wall Unit(s)" ] +"CountyOrParish": "Hamilton" +"CreationDate": "2025-07-08T20:37:14.855886+00:00" +"CrossStreet": "King & Victoria" +"Directions": "Parking access via alleyway on King William" +"ExpirationDate": "2025-12-31" +"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-08" +"MainOfficeKey": "184000" +"MajorChangeTimestamp": "2025-07-08T20:20:55Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-07-08T20:20:55Z" +"OriginalListPrice": 299000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2678460" +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ 0 => "Restricted" ] +"PhotosChangeTimestamp": "2025-07-08T20:20:55Z" +"ShowingRequirements": array:1 [ 0 => "Lockbox" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Victoria" +"StreetNumber": "28" +"StreetSuffix": "Avenue" +"TaxAnnualAmount": "1826.51" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2" +"TransactionType": "For Sale" +"UnitNumber": "102" +"VirtualTourURLBranded": "https://youriguide.com/102_28_victoria_ave_n_hamilton_on" +"RoomsAboveGrade": 5 +"PropertyManagementCompany": "Property Solutions Inc." +"Locker": "Exclusive" +"KitchensAboveGrade": 1 +"WashroomsType1": 1 +"DDFYN": true +"LivingAreaRange": "600-699" +"HeatSource": "Electric" +"ContractStatus": "Available" +"Waterfront": array:1 [ 0 => "None" ] +"HeatType": "Forced Air" +"StatusCertificateYN": true +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12271515')" +"WashroomsType1Pcs": 4 +"WashroomsType1Level": "Main" +"HSTApplication": array:1 [ 0 => "Included In" ] +"LegalApartmentNumber": "2" +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"SystemModificationTimestamp": "2025-07-08T20:20:55.868246Z" +"provider_name": "TRREB" +"ParkingSpaces": 1 +"LegalStories": "1" +"PossessionDetails": "Flexible" +"ParkingType1": "Exclusive" +"PermissionToContactListingBrokerToAdvertise": true +"ShowingAppointments": "Pls book through BB" +"LockerNumber": "102" +"GarageType": "None" +"BalconyType": "Terrace" +"PossessionType": "Flexible" +"Exposure": "West" +"PriorMlsStatus": "Draft" +"BedroomsAboveGrade": 2 +"SquareFootSource": "plans" +"MediaChangeTimestamp": "2025-07-08T20:20:55Z" +"SurveyType": "None" +"HoldoverDays": 90 +"CondoCorpNumber": 401 +"LaundryLevel": "Main Level" +"EnsuiteLaundryYN": true +"KitchensTotal": 1 +"short_address": "Hamilton, ON L8L 5E1, CA" +"Media": array:17 [ 0 => array:26 [ "ResourceRecordKey" => "X12271515" "MediaModificationTimestamp" => "2025-07-08T20:20:55.308915Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12271515/thumbnail-320973e904a720e25cfc2bc451581158.webp" "ShortDescription" => null "MediaKey" => "796a711d-9efe-484b-b998-6298aae90c52" "ImageWidth" => 1024 "ClassName" => "ResidentialCondo" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-08T20:20:55.308915Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "796a711d-9efe-484b-b998-6298aae90c52" "Order" => 0 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12271515/320973e904a720e25cfc2bc451581158.webp" "MediaSize" => 172283 "SourceSystemMediaKey" => "796a711d-9efe-484b-b998-6298aae90c52" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => true "LongDescription" => null "ImageHeight" => 681 ] 1 => array:26 [ "ResourceRecordKey" => "X12271515" "MediaModificationTimestamp" => "2025-07-08T20:20:55.308915Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12271515/thumbnail-73aaa7eca17d512d1d8acb6a83ead605.webp" "ShortDescription" => null "MediaKey" => "9f2b8b1b-de66-41b1-96fa-476d4348a233" "ImageWidth" => 1024 "ClassName" => "ResidentialCondo" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-08T20:20:55.308915Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "9f2b8b1b-de66-41b1-96fa-476d4348a233" "Order" => 1 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12271515/73aaa7eca17d512d1d8acb6a83ead605.webp" "MediaSize" => 87024 "SourceSystemMediaKey" => "9f2b8b1b-de66-41b1-96fa-476d4348a233" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 681 ] 2 => array:26 [ "ResourceRecordKey" => "X12271515" "MediaModificationTimestamp" => "2025-07-08T20:20:55.308915Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12271515/thumbnail-10dea17ce6d4a7aa5b0603f9ca4e1293.webp" "ShortDescription" => null "MediaKey" => "a7ae2b13-0f3c-462c-af63-cdd9593025ed" "ImageWidth" => 1024 "ClassName" => "ResidentialCondo" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-08T20:20:55.308915Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "a7ae2b13-0f3c-462c-af63-cdd9593025ed" "Order" => 2 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12271515/10dea17ce6d4a7aa5b0603f9ca4e1293.webp" "MediaSize" => 103717 "SourceSystemMediaKey" => "a7ae2b13-0f3c-462c-af63-cdd9593025ed" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 681 ] 3 => array:26 [ "ResourceRecordKey" => "X12271515" "MediaModificationTimestamp" => "2025-07-08T20:20:55.308915Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12271515/thumbnail-86902daab4a36c08516893b2da4790ad.webp" "ShortDescription" => null "MediaKey" => "5838f457-109c-43bd-9c5e-eb2142075ede" "ImageWidth" => 1024 "ClassName" => "ResidentialCondo" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-08T20:20:55.308915Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "5838f457-109c-43bd-9c5e-eb2142075ede" "Order" => 3 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12271515/86902daab4a36c08516893b2da4790ad.webp" "MediaSize" => 99517 "SourceSystemMediaKey" => "5838f457-109c-43bd-9c5e-eb2142075ede" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 681 ] 4 => array:26 [ "ResourceRecordKey" => "X12271515" "MediaModificationTimestamp" => "2025-07-08T20:20:55.308915Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12271515/thumbnail-2d774d8d554a36baef339301b4d8e445.webp" "ShortDescription" => null "MediaKey" => "bfa1a09e-4a11-4767-a2ad-520b33d6e574" "ImageWidth" => 1024 "ClassName" => "ResidentialCondo" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-08T20:20:55.308915Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "bfa1a09e-4a11-4767-a2ad-520b33d6e574" "Order" => 4 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12271515/2d774d8d554a36baef339301b4d8e445.webp" "MediaSize" => 105029 "SourceSystemMediaKey" => "bfa1a09e-4a11-4767-a2ad-520b33d6e574" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 681 ] 5 => array:26 [ "ResourceRecordKey" => "X12271515" "MediaModificationTimestamp" => "2025-07-08T20:20:55.308915Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12271515/thumbnail-4301bf2d3e4a83c7174e20f64a1ffddc.webp" "ShortDescription" => null "MediaKey" => "9a7fbded-92c6-466c-8f00-8fadeefca85b" "ImageWidth" => 1024 "ClassName" => "ResidentialCondo" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-08T20:20:55.308915Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "9a7fbded-92c6-466c-8f00-8fadeefca85b" "Order" => 5 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12271515/4301bf2d3e4a83c7174e20f64a1ffddc.webp" "MediaSize" => 96045 "SourceSystemMediaKey" => "9a7fbded-92c6-466c-8f00-8fadeefca85b" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 681 ] 6 => array:26 [ "ResourceRecordKey" => "X12271515" "MediaModificationTimestamp" => "2025-07-08T20:20:55.308915Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12271515/thumbnail-55685e7e987863a959536be2cf390c9e.webp" "ShortDescription" => null "MediaKey" => "b1c3ead9-bb2c-43b3-b2ce-a0f65beea522" "ImageWidth" => 1024 "ClassName" => "ResidentialCondo" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-08T20:20:55.308915Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "b1c3ead9-bb2c-43b3-b2ce-a0f65beea522" "Order" => 6 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12271515/55685e7e987863a959536be2cf390c9e.webp" "MediaSize" => 113761 "SourceSystemMediaKey" => "b1c3ead9-bb2c-43b3-b2ce-a0f65beea522" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 681 ] 7 => array:26 [ "ResourceRecordKey" => "X12271515" "MediaModificationTimestamp" => "2025-07-08T20:20:55.308915Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12271515/thumbnail-5fc8bd95fce2c390abb644ae13b64456.webp" "ShortDescription" => null "MediaKey" => "8d3e9e18-10d7-4012-8883-bdae8385e5a4" "ImageWidth" => 1024 "ClassName" => "ResidentialCondo" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-08T20:20:55.308915Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "8d3e9e18-10d7-4012-8883-bdae8385e5a4" "Order" => 7 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12271515/5fc8bd95fce2c390abb644ae13b64456.webp" "MediaSize" => 85205 "SourceSystemMediaKey" => "8d3e9e18-10d7-4012-8883-bdae8385e5a4" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 681 ] 8 => array:26 [ "ResourceRecordKey" => "X12271515" "MediaModificationTimestamp" => "2025-07-08T20:20:55.308915Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12271515/thumbnail-30c856914cee7f80f639e3fa9ae33e88.webp" "ShortDescription" => null "MediaKey" => "3dae3b7c-de4b-475e-8764-01f664fb0ae1" "ImageWidth" => 1024 "ClassName" => "ResidentialCondo" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-08T20:20:55.308915Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "3dae3b7c-de4b-475e-8764-01f664fb0ae1" "Order" => 8 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12271515/30c856914cee7f80f639e3fa9ae33e88.webp" "MediaSize" => 97338 "SourceSystemMediaKey" => "3dae3b7c-de4b-475e-8764-01f664fb0ae1" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 681 ] 9 => array:26 [ "ResourceRecordKey" => "X12271515" "MediaModificationTimestamp" => "2025-07-08T20:20:55.308915Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12271515/thumbnail-97030af08e0e68fb3fefe994f40eb12c.webp" "ShortDescription" => null "MediaKey" => "7a26871c-f70e-4593-9918-e55793295ef1" "ImageWidth" => 1024 "ClassName" => "ResidentialCondo" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-08T20:20:55.308915Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "7a26871c-f70e-4593-9918-e55793295ef1" "Order" => 9 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12271515/97030af08e0e68fb3fefe994f40eb12c.webp" "MediaSize" => 115031 "SourceSystemMediaKey" => "7a26871c-f70e-4593-9918-e55793295ef1" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 681 ] 10 => array:26 [ "ResourceRecordKey" => "X12271515" "MediaModificationTimestamp" => "2025-07-08T20:20:55.308915Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12271515/thumbnail-d203bf73feb220f5672a2d1b3f66e987.webp" "ShortDescription" => null "MediaKey" => "b896585e-8895-4e95-a79f-19f4aa7baec5" "ImageWidth" => 1024 "ClassName" => "ResidentialCondo" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-08T20:20:55.308915Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "b896585e-8895-4e95-a79f-19f4aa7baec5" "Order" => 10 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12271515/d203bf73feb220f5672a2d1b3f66e987.webp" "MediaSize" => 80768 "SourceSystemMediaKey" => "b896585e-8895-4e95-a79f-19f4aa7baec5" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 681 ] 11 => array:26 [ "ResourceRecordKey" => "X12271515" "MediaModificationTimestamp" => "2025-07-08T20:20:55.308915Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12271515/thumbnail-a52d46096a97eee5e3bdba6f1642e480.webp" "ShortDescription" => null "MediaKey" => "84a536d7-1cd8-44c6-a2b4-eb516b06e9fb" "ImageWidth" => 1024 "ClassName" => "ResidentialCondo" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-08T20:20:55.308915Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "84a536d7-1cd8-44c6-a2b4-eb516b06e9fb" "Order" => 11 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12271515/a52d46096a97eee5e3bdba6f1642e480.webp" "MediaSize" => 92983 "SourceSystemMediaKey" => "84a536d7-1cd8-44c6-a2b4-eb516b06e9fb" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 681 ] 12 => array:26 [ "ResourceRecordKey" => "X12271515" "MediaModificationTimestamp" => "2025-07-08T20:20:55.308915Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12271515/thumbnail-77155960bb8684588d8d5a061fd86ac1.webp" "ShortDescription" => null "MediaKey" => "131a1385-8937-4f84-908a-d3078f7af6c1" "ImageWidth" => 1024 "ClassName" => "ResidentialCondo" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-08T20:20:55.308915Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "131a1385-8937-4f84-908a-d3078f7af6c1" "Order" => 12 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12271515/77155960bb8684588d8d5a061fd86ac1.webp" "MediaSize" => 90545 "SourceSystemMediaKey" => "131a1385-8937-4f84-908a-d3078f7af6c1" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 681 ] 13 => array:26 [ "ResourceRecordKey" => "X12271515" "MediaModificationTimestamp" => "2025-07-08T20:20:55.308915Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12271515/thumbnail-85fce9a3c5a86136c274e8514d2db8d0.webp" "ShortDescription" => null "MediaKey" => "f4a29b94-b8c4-434d-a16f-111c71720c8a" "ImageWidth" => 1024 "ClassName" => "ResidentialCondo" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-08T20:20:55.308915Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "f4a29b94-b8c4-434d-a16f-111c71720c8a" "Order" => 13 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12271515/85fce9a3c5a86136c274e8514d2db8d0.webp" "MediaSize" => 78878 "SourceSystemMediaKey" => "f4a29b94-b8c4-434d-a16f-111c71720c8a" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 681 ] 14 => array:26 [ "ResourceRecordKey" => "X12271515" "MediaModificationTimestamp" => "2025-07-08T20:20:55.308915Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12271515/thumbnail-0c40dd2cd61f1b5be126a582947fe504.webp" "ShortDescription" => null "MediaKey" => "a610b1e8-2391-44db-b881-0d91f34e83fa" "ImageWidth" => 1024 "ClassName" => "ResidentialCondo" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-08T20:20:55.308915Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "a610b1e8-2391-44db-b881-0d91f34e83fa" "Order" => 14 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12271515/0c40dd2cd61f1b5be126a582947fe504.webp" "MediaSize" => 80884 "SourceSystemMediaKey" => "a610b1e8-2391-44db-b881-0d91f34e83fa" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 681 ] 15 => array:26 [ "ResourceRecordKey" => "X12271515" "MediaModificationTimestamp" => "2025-07-08T20:20:55.308915Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12271515/thumbnail-36999eabb0b2f93d892cc402e989cc6e.webp" "ShortDescription" => null "MediaKey" => "0313538d-43ec-43fb-a2e2-267d2b932a4f" "ImageWidth" => 1024 "ClassName" => "ResidentialCondo" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-08T20:20:55.308915Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "0313538d-43ec-43fb-a2e2-267d2b932a4f" "Order" => 15 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12271515/36999eabb0b2f93d892cc402e989cc6e.webp" "MediaSize" => 128121 "SourceSystemMediaKey" => "0313538d-43ec-43fb-a2e2-267d2b932a4f" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 681 ] 16 => array:26 [ "ResourceRecordKey" => "X12271515" "MediaModificationTimestamp" => "2025-07-08T20:20:55.308915Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12271515/thumbnail-62a9a350f542e337ff52d7eef87c213a.webp" "ShortDescription" => null "MediaKey" => "9ab44d68-64d5-4f13-b9cd-ae90362c2432" "ImageWidth" => 1536 "ClassName" => "ResidentialCondo" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-08T20:20:55.308915Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "9ab44d68-64d5-4f13-b9cd-ae90362c2432" "Order" => 16 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12271515/62a9a350f542e337ff52d7eef87c213a.webp" "MediaSize" => 300919 "SourceSystemMediaKey" => "9ab44d68-64d5-4f13-b9cd-ae90362c2432" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 1024 ] ] } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14652 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12271508" +"ListingId": "X12271508" +"PropertyType": "Residential Lease" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-08T20:19:16Z" +"RFModificationTimestamp": "2025-07-09T04:05:27Z" +"ListPrice": 3500.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L0R 1C0" +"UnparsedAddress": "128 Festival Way, Hamilton, ON L0R 1C0" +"Coordinates": array:2 [ 0 => -79.8167982 1 => 43.1288318 ] +"Latitude": 43.1288318 +"Longitude": -79.8167982 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "SUTTON GROUP QUANTUM REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Bright & Spacious Detached 4 Bed 3 Bath Home In Binbrook! Enjoy The Oversized Kitchen With White Cabinetry, Stainless Steel Appliances, Stove Range, & Brand New Modern Backsplash. The Home Has An Open Concept Large Living Room & Eat-In Area With A Formal Dining Space. Included On The Main Floor Is A Private Office With Double Doors. The Upper Floor Includes 4 Very Spacious Bedrooms & 2 Large Bright Bathrooms. The Primary Includes 3 Pc Ensuite & Walk In Closet. As Well As The Large Laundry Room Located On The Upper Floor For Ultimate Convenience. This Home Is Located On A Large Lot Backing Onto Farmer Fields, Enjoy No Neighbours In The Back. Ready For You To Call It Your New Home!" +"ArchitecturalStyle": array:1 [ 0 => "2-Storey" ] +"Basement": array:2 [ 0 => "Unfinished" 1 => "Full" ] +"CityRegion": "Binbrook" +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CountyOrParish": "Hamilton" +"CoveredSpaces": "2.0" +"CreationDate": "2025-07-08T20:39:46.688292+00:00" +"CrossStreet": "Festival Way & Pumpkin Pass" +"DirectionFaces": "East" +"Directions": "Festival Way & Pumpkin Pass" +"ExpirationDate": "2025-10-07" +"FoundationDetails": array:1 [ 0 => "Other" ] +"Furnished": "Unfurnished" +"GarageYN": true +"Inclusions": "Ss Fridge, Ss Gas Stove, Ss B/I Dishwasher, Hood Fan, Washer And Dryer, Window Blinds. Electric Light Fixtures." +"InteriorFeatures": array:1 [ 0 => "Other" ] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "Ensuite" ] +"LeaseTerm": "12 Months" +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-07-08" +"MainOfficeKey": "102300" +"MajorChangeTimestamp": "2025-07-08T20:19:16Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2025-07-08T20:19:16Z" +"OriginalListPrice": 3500.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2680896" +"ParcelNumber": "173844504" +"ParkingFeatures": array:1 [ 0 => "Private Double" ] +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2025-07-08T20:19:16Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"RentIncludes": array:1 [ 0 => "None" ] +"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": "Festival" +"StreetNumber": "128" +"StreetSuffix": "Way" +"TransactionBrokerCompensation": "half months rent plus hst" +"TransactionType": "For Lease" +"Water": "Municipal" +"RoomsAboveGrade": 7 +"DDFYN": true +"LivingAreaRange": "2000-2500" +"VendorPropertyInfoStatement": true +"CableYNA": "Available" +"HeatSource": "Gas" +"WaterYNA": "Available" +"PortionPropertyLease": array:1 [ 0 => "Entire Property" ] +"WashroomsType3Pcs": 2 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12271508')" +"WashroomsType1Level": "Upper" +"CreditCheckYN": true +"EmploymentLetterYN": true +"PossessionType": "Flexible" +"PrivateEntranceYN": true +"PriorMlsStatus": "Draft" +"RentalItems": "Hot Water Tank & Hrv ($86.10)" +"LaundryLevel": "Upper Level" +"WashroomsType3Level": "Main" +"PossessionDate": "2025-09-01" +"short_address": "Hamilton, ON L0R 1C0, CA" +"KitchensAboveGrade": 1 +"RentalApplicationYN": true +"WashroomsType1": 1 +"WashroomsType2": 1 +"GasYNA": "Available" +"ContractStatus": "Available" +"HeatType": "Forced Air" +"WashroomsType1Pcs": 3 +"RollNumber": "251890134038518" +"DepositRequired": true +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"TelephoneYNA": "Available" +"SystemModificationTimestamp": "2025-07-08T20:19:17.49955Z" +"provider_name": "TRREB" +"ParkingSpaces": 2 +"PossessionDetails": "Sept 1 2025" +"PermissionToContactListingBrokerToAdvertise": true +"LeaseAgreementYN": true +"GarageType": "Attached" +"ElectricYNA": "Available" +"WashroomsType2Level": "Upper" +"BedroomsAboveGrade": 4 +"MediaChangeTimestamp": "2025-07-08T20:19:16Z" +"WashroomsType2Pcs": 3 +"DenFamilyroomYN": true +"SurveyType": "None" +"HoldoverDays": 90 +"SewerYNA": "Available" +"ReferencesRequiredYN": true +"WashroomsType3": 1 +"KitchensTotal": 1 +"Media": array:38 [ 0 => array:26 [ "ResourceRecordKey" => "X12271508" "MediaModificationTimestamp" => "2025-07-08T20:19:16.809734Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12271508/thumbnail-9093c3ef3bcd096215736f00b0d9cabe.webp" "ShortDescription" => null "MediaKey" => "0826ee9a-c5e7-4a06-bb87-24d66d5fd26b" "ImageWidth" => 576 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-08T20:19:16.809734Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "0826ee9a-c5e7-4a06-bb87-24d66d5fd26b" "Order" => 0 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12271508/9093c3ef3bcd096215736f00b0d9cabe.webp" "MediaSize" => 82525 "SourceSystemMediaKey" => "0826ee9a-c5e7-4a06-bb87-24d66d5fd26b" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => true "LongDescription" => null "ImageHeight" => 768 ] 1 => array:26 [ "ResourceRecordKey" => "X12271508" "MediaModificationTimestamp" => "2025-07-08T20:19:16.809734Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12271508/thumbnail-3a42b4aee99835f41876a47c25514d90.webp" "ShortDescription" => null "MediaKey" => "724d2b02-b916-4114-ae11-19d32d51699c" "ImageWidth" => 576 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-08T20:19:16.809734Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "724d2b02-b916-4114-ae11-19d32d51699c" "Order" => 1 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12271508/3a42b4aee99835f41876a47c25514d90.webp" "MediaSize" => 45646 "SourceSystemMediaKey" => "724d2b02-b916-4114-ae11-19d32d51699c" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 768 ] 2 => array:26 [ "ResourceRecordKey" => "X12271508" "MediaModificationTimestamp" => "2025-07-08T20:19:16.809734Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12271508/thumbnail-97916a24050c3f8cb83c5dc9ba34ddcd.webp" "ShortDescription" => null "MediaKey" => "68e9277e-39d0-4225-8cee-886000960e8d" "ImageWidth" => 1545 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-08T20:19:16.809734Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "68e9277e-39d0-4225-8cee-886000960e8d" "Order" => 2 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12271508/97916a24050c3f8cb83c5dc9ba34ddcd.webp" "MediaSize" => 171084 "SourceSystemMediaKey" => "68e9277e-39d0-4225-8cee-886000960e8d" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 2000 ] 3 => array:26 [ "ResourceRecordKey" => "X12271508" "MediaModificationTimestamp" => "2025-07-08T20:19:16.809734Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12271508/thumbnail-271799543492582e410ff42151e38a94.webp" "ShortDescription" => null "MediaKey" => "7a308c8f-373e-4a13-9c72-470ffbf299a6" "ImageWidth" => 1545 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-08T20:19:16.809734Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "7a308c8f-373e-4a13-9c72-470ffbf299a6" "Order" => 3 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12271508/271799543492582e410ff42151e38a94.webp" "MediaSize" => 174588 "SourceSystemMediaKey" => "7a308c8f-373e-4a13-9c72-470ffbf299a6" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 2000 ] 4 => array:26 [ "ResourceRecordKey" => "X12271508" "MediaModificationTimestamp" => "2025-07-08T20:19:16.809734Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12271508/thumbnail-ce169e43851eff81c71b5c70a3369790.webp" "ShortDescription" => null "MediaKey" => "3700ab63-9aba-4666-92bb-6c9d967c52d4" "ImageWidth" => 1024 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-08T20:19:16.809734Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "3700ab63-9aba-4666-92bb-6c9d967c52d4" "Order" => 4 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12271508/ce169e43851eff81c71b5c70a3369790.webp" "MediaSize" => 96621 "SourceSystemMediaKey" => "3700ab63-9aba-4666-92bb-6c9d967c52d4" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 768 ] 5 => array:26 [ "ResourceRecordKey" => "X12271508" "MediaModificationTimestamp" => "2025-07-08T20:19:16.809734Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12271508/thumbnail-b224ce174b6b12b8e5d0893227dce01d.webp" "ShortDescription" => null "MediaKey" => "dc3e419f-d445-4b1b-ba2a-5a45aff5605f" "ImageWidth" => 576 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-08T20:19:16.809734Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "dc3e419f-d445-4b1b-ba2a-5a45aff5605f" "Order" => 5 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12271508/b224ce174b6b12b8e5d0893227dce01d.webp" "MediaSize" => 63096 "SourceSystemMediaKey" => "dc3e419f-d445-4b1b-ba2a-5a45aff5605f" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 768 ] 6 => array:26 [ "ResourceRecordKey" => "X12271508" "MediaModificationTimestamp" => "2025-07-08T20:19:16.809734Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12271508/thumbnail-74013059d0f80e6725c9a2bb5c8e2947.webp" "ShortDescription" => null "MediaKey" => "8572dd9a-9470-4058-bb25-5741c042b320" "ImageWidth" => 576 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-08T20:19:16.809734Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "8572dd9a-9470-4058-bb25-5741c042b320" "Order" => 6 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12271508/74013059d0f80e6725c9a2bb5c8e2947.webp" "MediaSize" => 55064 "SourceSystemMediaKey" => "8572dd9a-9470-4058-bb25-5741c042b320" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 768 ] 7 => array:26 [ "ResourceRecordKey" => "X12271508" "MediaModificationTimestamp" => "2025-07-08T20:19:16.809734Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12271508/thumbnail-5b9760547229f9e5c17a8be177a62889.webp" "ShortDescription" => null "MediaKey" => "1df95c52-5c53-4128-9863-85dcc377f381" "ImageWidth" => 576 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-08T20:19:16.809734Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "1df95c52-5c53-4128-9863-85dcc377f381" "Order" => 7 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12271508/5b9760547229f9e5c17a8be177a62889.webp" "MediaSize" => 78113 "SourceSystemMediaKey" => "1df95c52-5c53-4128-9863-85dcc377f381" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 768 ] 8 => array:26 [ "ResourceRecordKey" => "X12271508" "MediaModificationTimestamp" => "2025-07-08T20:19:16.809734Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12271508/thumbnail-6aeb789c08195419697c009544d67e49.webp" "ShortDescription" => null "MediaKey" => "f57a7947-ce57-47db-aece-09502977b566" "ImageWidth" => 1545 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-08T20:19:16.809734Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "f57a7947-ce57-47db-aece-09502977b566" "Order" => 8 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12271508/6aeb789c08195419697c009544d67e49.webp" "MediaSize" => 225163 "SourceSystemMediaKey" => "f57a7947-ce57-47db-aece-09502977b566" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 2000 ] 9 => array:26 [ "ResourceRecordKey" => "X12271508" "MediaModificationTimestamp" => "2025-07-08T20:19:16.809734Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12271508/thumbnail-72cd5d929435dedb59aa6e5292a6f5d4.webp" "ShortDescription" => null "MediaKey" => "1885ef51-aa22-42a9-b664-cd46047338e3" "ImageWidth" => 2000 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-08T20:19:16.809734Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "1885ef51-aa22-42a9-b664-cd46047338e3" "Order" => 9 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12271508/72cd5d929435dedb59aa6e5292a6f5d4.webp" "MediaSize" => 211895 "SourceSystemMediaKey" => "1885ef51-aa22-42a9-b664-cd46047338e3" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 1429 ] 10 => array:26 [ "ResourceRecordKey" => "X12271508" "MediaModificationTimestamp" => "2025-07-08T20:19:16.809734Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12271508/thumbnail-65f540328b387738147111c72d682e6f.webp" "ShortDescription" => null "MediaKey" => "fb477d30-8d7b-4a83-a570-57a925213238" "ImageWidth" => 1545 "ClassName" => "ResidentialFree" …17 ] 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] ] } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14658 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12271495" +"ListingId": "X12271495" +"PropertyType": "Residential Lease" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-08T20:15:05Z" +"RFModificationTimestamp": "2025-07-09T04:05:27Z" +"ListPrice": 2150.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0.06 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8L 7K4" +"UnparsedAddress": "233 Glendale Avenue, Hamilton, ON L8L 7K4" +"Coordinates": array:2 [ 0 => -79.8233781 1 => 43.2522825 ] +"Latitude": 43.2522825 +"Longitude": -79.8233781 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "COLDWELL BANKER COMMUNITY PROFESSIONALS" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to 233 Glendale Ave N! This character-filled home in the desirable Crown Point neighbourhood, which is walking distance to Ottawa St for dining, shopping, entertainment, and close to schools, parks, as well as Hamilton Stadium - the home of the Hamilton Ti Cats and Forge FC! This full home rental features 3 bedrooms, 1 bathroom along with rear parking. There's also a generously sized backyard with ample space for relaxing, gardening or entertaining. Tenant to pay utilities (electricity, water, gas, internet)." +"ArchitecturalStyle": array:1 [ 0 => "2-Storey" ] +"Basement": array:2 [ 0 => "Full" 1 => "Unfinished" ] +"CityRegion": "Crown Point" +"ConstructionMaterials": array:1 [ 0 => "Vinyl Siding" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2025-07-08T20:22:47.573270+00:00" +"CrossStreet": "Cannon/Glendale`" +"DirectionFaces": "West" +"Directions": "Glendale and Cannon" +"ExpirationDate": "2025-09-30" +"FoundationDetails": array:1 [ 0 => "Block" ] +"Furnished": "Unfurnished" +"Inclusions": "Fridge, stove, washer, dryer" +"InteriorFeatures": array:1 [ 0 => "None" ] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "In Basement" ] +"LeaseTerm": "12 Months" +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-07-07" +"LotSizeSource": "MPAC" +"MainOfficeKey": "090000" +"MajorChangeTimestamp": "2025-07-08T20:15:05Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-07-08T20:15:05Z" +"OriginalListPrice": 2150.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2681292" +"ParcelNumber": "172210161" +"ParkingFeatures": array:1 [ 0 => "Available" ] +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2025-07-08T20:15:05Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"RentIncludes": array:1 [ 0 => "None" ] +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "N" +"StreetName": "Glendale" +"StreetNumber": "233" +"StreetSuffix": "Avenue" +"TransactionBrokerCompensation": "1/2 months rent + HST" +"TransactionType": "For Lease" +"Water": "Municipal" +"RoomsAboveGrade": 7 +"KitchensAboveGrade": 1 +"RentalApplicationYN": true +"WashroomsType1": 1 +"DDFYN": true +"LivingAreaRange": "700-1100" +"HeatSource": "Gas" +"ContractStatus": "Available" +"PortionPropertyLease": array:1 [ 0 => "Entire Property" ] +"LotWidth": 20.67 +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12271495')" +"WashroomsType1Pcs": 3 +"WashroomsType1Level": "Main" +"RollNumber": "251804028401000" +"DepositRequired": true +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"SystemModificationTimestamp": "2025-07-08T20:15:06.13601Z" +"provider_name": "TRREB" +"LotDepth": 118.0 +"ParkingSpaces": 1 +"PossessionDetails": "immediate" +"LeaseAgreementYN": true +"CreditCheckYN": true +"EmploymentLetterYN": true +"GarageType": "None" +"PaymentFrequency": "Monthly" +"PossessionType": "Immediate" +"PrivateEntranceYN": true +"PriorMlsStatus": "Draft" +"BedroomsAboveGrade": 3 +"MediaChangeTimestamp": "2025-07-08T20:15:05Z" +"SurveyType": "None" +"ApproximateAge": "100+" +"HoldoverDays": 30 +"ReferencesRequiredYN": true +"KitchensTotal": 1 +"short_address": "Hamilton, ON L8L 7K4, 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] ] } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14655 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12271480" +"ListingId": "X12271480" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-08T20:10:32Z" +"RFModificationTimestamp": "2025-07-09T04:05:27Z" +"ListPrice": 1369900.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0.13 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L9K 1R7" +"UnparsedAddress": "194 Joshua Avenue, Hamilton, ON L9K 1R7" +"Coordinates": array:2 [ 0 => -79.9428723 1 => 43.2202668 ] +"Latitude": 43.2202668 +"Longitude": -79.9428723 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ONE PERCENT REALTY LTD." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to 194 Joshua Avenue in the neighbourhood of the Ancaster Meadowlands. Situated on a private treed premium lot, this property is ready for its newest owner to enjoy the amazing backyard with a beautiful inground pool, interlocking patio and no rear neighbours. Enjoy the privacy and quietness of this amazing street. The home features over 4,000sqft of total living space. Over 2,900sqft above grade with a massive entertainment area, open kitchen with granite countertops and eat-in kitchen. A large family room with huge windows and 10ft ceilings. Enjoy a formal dining space and main level laundry. On the second floor, this layout gives you the option to enjoy the office/loft area OR have the sellers create an additional 4th massive bedroom. New hardwood flooring has been installed and this home is truly move-in ready. The following updates have been done: Pool liner + Winter cover (2021), pool heater (2021), Pool filter (2021), Roof (2014), professionally finished basement (2020), majority of windows have been updated and upgraded with California shutters. New large front door. Furnace and air conditioner have been regularly inspected and maintained professionally. Close to schools, public transit and shopping. RSA." +"ArchitecturalStyle": array:1 [ 0 => "2-Storey" ] +"Basement": array:2 [ 0 => "Full" 1 => "Finished" ] +"CityRegion": "Meadowlands" +"ConstructionMaterials": array:2 [ 0 => "Brick" 1 => "Stone" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CoveredSpaces": "2.0" +"CreationDate": "2025-07-08T20:27:45.293238+00:00" +"CrossStreet": "Biggs" +"DirectionFaces": "South" +"Directions": "Stonehenge to Joshua" +"ExpirationDate": "2025-09-30" +"ExteriorFeatures": array:6 [ 0 => "Awnings" 1 => "Landscaped" 2 => "Hot Tub" 3 => "Patio" 4 => "Privacy" 5 => "Lawn Sprinkler System" ] +"FireplaceFeatures": array:3 [ 0 => "Electric" 1 => "Natural Gas" 2 => "Family Room" ] +"FireplaceYN": true +"FireplacesTotal": "2" +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"GarageYN": true +"Inclusions": "Built-in Microwave, Dishwasher, Dryer, Gas Oven/Range, Hot Tub, Hot Tub Equipment, Pool Equipment, Refrigerator, Washer, Window Coverings" +"InteriorFeatures": array:2 [ 0 => "Sump Pump" 1 => "Water Heater" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-07-08" +"LotSizeSource": "MPAC" +"MainOfficeKey": "179500" +"MajorChangeTimestamp": "2025-07-08T20:10:32Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-07-08T20:10:32Z" +"OriginalListPrice": 1369900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2682628" +"ParcelNumber": "175652245" +"ParkingFeatures": array:1 [ 0 => "Private Double" ] +"ParkingTotal": "6.0" +"PhotosChangeTimestamp": "2025-07-08T20:10:32Z" +"PoolFeatures": array:1 [ 0 => "Inground" ] +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:1 [ 0 => "Lockbox" ] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Joshua" +"StreetNumber": "194" +"StreetSuffix": "Avenue" +"TaxAnnualAmount": "8798.0" +"TaxAssessedValue": 674000 +"TaxLegalDescription": "LOT 8, PLAN 62M991, ANCASTER, CITY OF HAMILTON ; S/T EASE IN FAVOUR OF CITY OF HAMILTON AS IN WE197700" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2% + HST" +"TransactionType": "For Sale" +"View": array:1 [ 0 => "Forest" ] +"Zoning": "RT" +"Water": "Municipal" +"RoomsAboveGrade": 11 +"KitchensAboveGrade": 1 +"UnderContract": array:1 [ 0 => "Hot Water Heater" ] +"WashroomsType1": 2 +"DDFYN": true +"WashroomsType2": 1 +"LivingAreaRange": "2500-3000" +"HeatSource": "Gas" +"ContractStatus": "Available" +"PropertyFeatures": array:6 [ 0 => "Fenced Yard" 1 => "Hospital" 2 => "Library" 3 => "Park" 4 => "Place Of Worship" 5 => "School" ] +"LotWidth": 40.4 +"HeatType": "Forced Air" +"WashroomsType3Pcs": 2 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12271480')" +"WashroomsType1Pcs": 4 +"WashroomsType1Level": "Second" +"HSTApplication": array:1 [ 0 => "Included In" ] +"RollNumber": "251814028017815" +"DevelopmentChargesPaid": array:1 [ 0 => "Yes" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"WaterMeterYN": true +"AssessmentYear": 2024 +"SystemModificationTimestamp": "2025-07-08T20:10:33.81232Z" +"provider_name": "TRREB" +"LotDepth": 116.8 +"ParkingSpaces": 4 +"PossessionDetails": "Flexible" +"ShowingAppointments": "Broker Bay" +"LotSizeRangeAcres": "< .50" +"GarageType": "Attached" +"ParcelOfTiedLand": "No" +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType2Level": "Main" +"BedroomsAboveGrade": 3 +"MediaChangeTimestamp": "2025-07-08T20:10:32Z" +"WashroomsType2Pcs": 2 +"RentalItems": "Hot Water Tank" +"DenFamilyroomYN": true +"SurveyType": "None" +"ApproximateAge": "16-30" +"HoldoverDays": 30 +"LaundryLevel": "Main Level" +"WashroomsType3": 1 +"WashroomsType3Level": "Basement" +"KitchensTotal": 1 +"short_address": "Hamilton, ON L9K 1R7, CA" +"Media": array:42 [ 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] ] } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14650 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12268072" +"ListingId": "X12268072" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-08T20:05:27Z" +"RFModificationTimestamp": "2025-07-08T20:30:54Z" +"ListPrice": 2487000.0 +"BathroomsTotalInteger": 6.0 +"BathroomsHalf": 0 +"BedroomsTotal": 6.0 +"LotSizeArea": 1.98 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L0R 1R0" +"UnparsedAddress": "187 Sunnyridge Road, Hamilton, ON L0R 1R0" +"Coordinates": array:2 [ 0 => -80.1051178 1 => 43.1933608 ] +"Latitude": 43.1933608 +"Longitude": -80.1051178 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE STATE REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Experience refined living in this exceptional custom-built 2-storey home, set on nearly 2 acres of peaceful countryside. With a 350 setback from the road, it offers unmatched privacy, tranquility, and sweeping pastoral views. Step into the grand foyer with soaring 20 ceilings and gleaming porcelain floors, where craftsmanship and quality finishes are immediately evident. The chefs kitchen is a showstopperfeaturing quartz countertops and backsplash, high-end appliances, an 8-burner gas range, and a walk-in butlers pantryopening to an elegant Great Room with 10 coffered ceilings, rich hardwoods, a gas fireplace, custom lighting, and a built-in sound system. Ideal for entertaining in any season, the expansive covered deck extends your living space outdoors. A formal dining room with 15 coffered ceilings and oversized windows offers captivating views and natural light. Upstairs, 9 ceilings enhance a serene primary suite with a spa-inspired ensuite, a second bedroom with its own 4-piece bath, and two additional bedrooms sharing a stylish Jack and Jill bathroom. The fully finished lower level features a large rec room with a rough-in for a kitchen or wet bar, two more bedrooms (one with a 4-piece ensuite, the other with its own 3-piece bath), a home gym, and ample storageperfect for in-law or multi-generational living. A 4.5-car garage with inside entry to a spacious mudroom/laundry area is ideal for multi-vehicle households. The deep, fully fenced backyard is ready for your visionwhether its a pool, tennis court, or extensive gardens. A private oasis with space, sophistication, and flexibility, this is a rare opportunity to live the lifestyle youve been dreaming of. School bus pickups very close to property." +"ArchitecturalStyle": array:1 [ 0 => "2-Storey" ] +"Basement": array:2 [ 0 => "Full" 1 => "Finished" ] +"CityRegion": "Jerseyville" +"ConstructionMaterials": array:2 [ 0 => "Brick" 1 => "Stone" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CountyOrParish": "Hamilton" +"CoveredSpaces": "4.5" +"CreationDate": "2025-07-07T18:17:42.645796+00:00" +"CrossStreet": "Jerseyville Rd W" +"DirectionFaces": "East" +"Directions": "Jerseyville Rd. W. to Sunnyridge Rd. (near Poplar)" +"Exclusions": "Flat screen TV's, fridge & stove in basement" +"ExpirationDate": "2025-09-30" +"ExteriorFeatures": array:7 [ 0 => "Backs On Green Belt" 1 => "Controlled Entry" 2 => "Landscape Lighting" 3 => "Patio" 4 => "Porch" 5 => "Year Round Living" 6 => "Deck" ] +"FireplaceFeatures": array:2 [ 0 => "Family Room" 1 => "Natural Gas" ] +"FireplaceYN": true +"FireplacesTotal": "2" +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"GarageYN": true +"Inclusions": "Carbon Monoxide Detector, Central Vac, Dishwasher, Dryer, Garage Door Opener, Gas Oven/Range, Gas Stove, Hot Water Tank Owned, Microwave, Range Hood, Refrigerator, Smoke Detector, Washer, Window Coverings, Wine Cooler, bar fridge, 4 garage door openers & remotes, 5 bathroom mirrors, light fixtures, window coverings, Water purification equipment, H/W tank & circulation pump, electric fireplace in Primary bedroom" +"InteriorFeatures": array:14 [ 0 => "Air Exchanger" 1 => "Auto Garage Door Remote" 2 => "Built-In Oven" 3 => "Central Vacuum" 4 => "ERV/HRV" 5 => "Floor Drain" 6 => "In-Law Capability" 7 => "Sewage Pump" 8 => "Sump Pump" 9 => "Upgraded Insulation" 10 => "Water Heater Owned" 11 => "Water Treatment" 12 => "Storage" 13 => "Ventilation System" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-07-07" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "288000" +"MajorChangeTimestamp": "2025-07-07T17:56:17Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-07-07T17:56:17Z" +"OriginalListPrice": 2487000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2672086" +"ParcelNumber": "174060141" +"ParkingFeatures": array:2 [ 0 => "Private" 1 => "Private Triple" ] +"ParkingTotal": "29.0" +"PhotosChangeTimestamp": "2025-07-08T20:05:27Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"SecurityFeatures": array:3 [ 0 => "Carbon Monoxide Detectors" 1 => "Other" 2 => "Smoke Detector" ] +"Sewer": array:1 [ 0 => "Septic" ] +"ShowingRequirements": array:2 [ 0 => "Lockbox" 1 => "Showing System" ] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Sunnyridge" +"StreetNumber": "187" +"StreetSuffix": "Road" +"TaxAnnualAmount": "12819.56" +"TaxAssessedValue": 1033000 +"TaxLegalDescription": "PT LT 19, CON 3 ANCASTER , AS IN CD202999 ; ANCASTER CITY OF HAMILTON" +"TaxYear": "2025" +"Topography": array:1 [ 0 => "Dry" ] +"TransactionBrokerCompensation": "2% + hst less 50% + HST if Buyer is shown by LA" +"TransactionType": "For Sale" +"View": array:5 [ 0 => "Forest" 1 => "Garden" 2 => "Park/Greenbelt" 3 => "Skyline" 4 => "Trees/Woods" ] +"VirtualTourURLUnbranded": "https://sites.cathykoop.ca/mls/183306281" +"VirtualTourURLUnbranded2": "https://sites.cathykoop.ca/vd/185729791" +"WaterSource": array:3 [ 0 => "Cistern" 1 => "Iron/Mineral Filter" 2 => "Sediment Filter" ] +"Zoning": "S1" +"Water": "Other" +"RoomsAboveGrade": 10 +"DDFYN": true +"LivingAreaRange": "3500-5000" +"CableYNA": "Available" +"HeatSource": "Gas" +"WaterYNA": "No" +"RoomsBelowGrade": 4 +"Waterfront": array:1 [ 0 => "None" ] +"PropertyFeatures": array:6 [ 0 => "Campground" 1 => "Fenced Yard" 2 => "Golf" 3 => "Greenbelt/Conservation" 4 => "Park" 5 => "Place Of Worship" ] +"LotWidth": 93.3 +"LotShape": "Irregular" +"WashroomsType3Pcs": 4 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12268072')" +"LotSizeAreaUnits": "Acres" +"WashroomsType1Level": "Second" +"MortgageComment": "treat as clear" +"Winterized": "Fully" +"LotDepth": 701.71 +"BedroomsBelowGrade": 2 +"ParcelOfTiedLand": "No" +"PossessionType": "30-59 days" +"PriorMlsStatus": "Draft" +"RentalItems": "none" +"UFFI": "No" +"LaundryLevel": "Main Level" +"WashroomsType3Level": "Second" +"CentralVacuumYN": true +"KitchensAboveGrade": 1 +"WashroomsType1": 2 +"WashroomsType2": 1 +"AccessToProperty": array:3 [ 0 => "Municipal Road" 1 => "Public Road" 2 => "Year Round Municipal Road" ] +"GasYNA": "Yes" +"ContractStatus": "Available" +"WashroomsType4Pcs": 5 +"HeatType": "Forced Air" +"WashroomsType4Level": "Basement" +"WashroomsType1Pcs": 5 +"HSTApplication": array:1 [ 0 => "Not Subject to HST" ] +"RollNumber": "251814031028400" +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"AssessmentYear": 2024 +"TelephoneYNA": "Available" +"SystemModificationTimestamp": "2025-07-08T20:05:33.338436Z" +"provider_name": "TRREB" +"KitchensBelowGrade": 1 +"ParkingSpaces": 24 +"PossessionDetails": "30-60 DAYS\TBD" +"LotSizeRangeAcres": ".50-1.99" +"GarageType": "Attached" +"ElectricYNA": "Yes" +"WashroomsType5Level": "Basement" +"WashroomsType5Pcs": 3 +"WashroomsType2Level": "Main" +"BedroomsAboveGrade": 4 +"MediaChangeTimestamp": "2025-07-08T20:05:27Z" +"WashroomsType2Pcs": 2 +"DenFamilyroomYN": true +"LotIrregularities": "87.29 ft x 701.71 ft x 93.49 ft -Sch. C" +"SurveyType": "Unknown" +"ApproximateAge": "0-5" +"HoldoverDays": 60 +"RuralUtilities": array:7 [ 0 => "Cable Available" 1 => "Cell Services" 2 => "Electricity Connected" 3 => "Garbage Pickup" 4 => "Internet High Speed" 5 => "Natural Gas" 6 => "Street Lights" ] +"SewerYNA": "No" +"WashroomsType5": 1 +"WashroomsType3": 1 +"WashroomsType4": 1 +"KitchensTotal": 2 +"Media": array:50 [ 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] 45 => array:26 [ …26] 46 => array:26 [ …26] 47 => array:26 [ …26] 48 => array:26 [ …26] 49 => array:26 [ …26] ] } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14629 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12271441" +"ListingId": "X12271441" +"PropertyType": "Commercial Sale" +"PropertySubType": "Investment" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-08T19:56:48Z" +"RFModificationTimestamp": "2025-07-10T03:09:13Z" +"ListPrice": 3950000.0 +"BathroomsTotalInteger": 15.0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0.24 +"LivingArea": 0 +"BuildingAreaTotal": 0.24 +"City": "Hamilton" +"PostalCode": "L8P 2S2" +"UnparsedAddress": "450 Aberdeen Avenue, Hamilton, ON L8P 2S2" +"Coordinates": array:2 [ 0 => -79.8942889 1 => 43.2515255 ] +"Latitude": 43.2515255 +"Longitude": -79.8942889 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "COMMERCIAL FOCUS REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Attention First Time Buyers - great turnkey rental apartment investment in prime location in Hamilton. Solid structure - low maintenance with no elevator, balconies or under ground garage. Minimal common areas. Boutique rental living with quality well screened tenants. All larger 2 bedrooms suites with 11 of them totally renovated to a high standard. 20-30% remaining rental upside. Potential to add 1 bedroom suite in the basement. Seconds to downtown and highway - bus service along Aberdeen. Well respected high demand residential location." +"BasementYN": true +"BuildingAreaUnits": "Acres" +"BusinessName": "Aberdeen Apartments" +"BusinessType": array:1 [ 0 => "Apts - 13 To 20 Units" ] +"CityRegion": "Kirkendall" +"CommunityFeatures": array:2 [ 0 => "Major Highway" 1 => "Public Transit" ] +"Cooling": array:1 [ 0 => "No" ] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2025-07-08T20:37:30.721754+00:00" +"CrossStreet": "Aberdeen Locke" +"Directions": "Aberdeen" +"ExpirationDate": "2025-09-06" +"Inclusions": "2 washers and 2 dryers Huebsch" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-07-08" +"LotSizeSource": "MPAC" +"MainOfficeKey": "038500" +"MajorChangeTimestamp": "2025-07-08T19:56:48Z" +"MlsStatus": "New" +"NetOperatingIncome": 195000.0 +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2025-07-08T19:56:48Z" +"OriginalListPrice": 3950000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2682346" +"ParcelNumber": "171320304" +"PhotosChangeTimestamp": "2025-07-08T19:56:48Z" +"SecurityFeatures": array:1 [ 0 => "No" ] +"ShowingRequirements": array:1 [ 0 => "List Brokerage" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Aberdeen" +"StreetNumber": "450" +"StreetSuffix": "Avenue" +"TaxAnnualAmount": "39150.0" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2.0% +HST" +"TransactionType": "For Sale" +"Utilities": array:1 [ 0 => "Yes" ] +"Zoning": "Res" +"Water": "Municipal" +"FreestandingYN": true +"WashroomsType1": 15 +"DDFYN": true +"LotType": "Lot" +"Expenses": "Estimated" +"PropertyUse": "Apartment" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"LotWidth": 127.33 +"HeatType": "Gas Hot Water" +"YearExpenses": 2025 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12271441')" +"LotSizeAreaUnits": "Acres" +"HSTApplication": array:1 [ 0 => "Not Subject to HST" ] +"RollNumber": "251801009100220" +"AssessmentYear": 2025 +"SystemModificationTimestamp": "2025-07-08T19:56:48.839821Z" +"provider_name": "TRREB" +"LotDepth": 82.0 +"ParkingSpaces": 9 +"ShowingAppointments": "48 hours notice" +"GarageType": "Outside/Surface" +"PossessionType": "Immediate" +"PriorMlsStatus": "Draft" +"MediaChangeTimestamp": "2025-07-08T19:56:48Z" +"TaxType": "Annual" +"HoldoverDays": 90 +"ElevatorType": "None" +"GrossRevenue": 296800.0 +"PossessionDate": "2025-07-08" +"short_address": "Hamilton, ON L8P 2S2, CA" +"Media": array:24 [ 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] ] } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14628 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12271429" +"ListingId": "X12271429" +"PropertyType": "Residential Lease" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-08T19:53:34Z" +"RFModificationTimestamp": "2025-07-09T16:10:02Z" +"ListPrice": 3350.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0.06 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8E 0C3" +"UnparsedAddress": "165 Palacebeach Trail, Hamilton, ON L8E 0C3" +"Coordinates": array:2 [ 0 => -79.6762297 1 => 43.2282827 ] +"Latitude": 43.2282827 +"Longitude": -79.6762297 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "CENTRAL HOME REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Great Two Storey Home In Sought After Area Stoney Creek, Steps To The Lake, Easy Access To Hwy. Bright & Spacious W/ Open Concept Layout, 9' Ceilings On Main Floor, Hardwood Floors, Gas Fireplace In Living Room. Spacious Eat-In Kitchen W/ Stainless Steel Appls & Backsplash, Walk-Out To Spacious Backyard W/ A Kitchen Garden. 3 Large Bedrooms Plus A Loft On 2nd Floor, Primary Bedroom W/ Walk-In Closet & A 4 Pc Ensuite W/ Jacuzzi & Glass Shower." +"ArchitecturalStyle": array:1 [ 0 => "2-Storey" ] +"Basement": array:1 [ 0 => "Full" ] +"CityRegion": "Lakeshore" +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CoveredSpaces": "1.0" +"CreationDate": "2025-07-08T20:41:48.440209+00:00" +"CrossStreet": "North Service Rd" +"DirectionFaces": "West" +"Directions": "Service Rd and Glover Rd" +"ExpirationDate": "2025-09-30" +"FireplaceFeatures": array:1 [ 0 => "Natural Gas" ] +"FireplaceYN": true +"FoundationDetails": array:1 [ 0 => "Concrete" ] +"Furnished": "Unfurnished" +"GarageYN": true +"Inclusions": "Stainless steel dishwasher, refrigerator, and stove. Washer and Dryer." +"InteriorFeatures": array:1 [ 0 => "Sump Pump" ] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "Laundry Room" ] +"LeaseTerm": "12 Months" +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-07-07" +"LotSizeSource": "MPAC" +"MainOfficeKey": "280600" +"MajorChangeTimestamp": "2025-07-08T19:53:34Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-07-08T19:53:34Z" +"OriginalListPrice": 3350.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2682418" +"ParcelNumber": "173471186" +"ParkingFeatures": array:1 [ 0 => "Private" ] +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-07-08T19:53:34Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"RentIncludes": array:1 [ 0 => "None" ] +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:1 [ 0 => "Lockbox" ] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Palacebeach" +"StreetNumber": "165" +"StreetSuffix": "Trail" +"TransactionBrokerCompensation": "Half a month + HST" +"TransactionType": "For Lease" +"Water": "Municipal" +"RoomsAboveGrade": 8 +"DDFYN": true +"LivingAreaRange": "1500-2000" +"HeatSource": "Gas" +"RoomsBelowGrade": 1 +"PortionPropertyLease": array:1 [ 0 => "Entire Property" ] +"LotWidth": 30.05 +"WashroomsType3Pcs": 5 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12271429')" +"WashroomsType1Level": "Main" +"LotDepth": 85.43 +"CreditCheckYN": true +"EmploymentLetterYN": true +"BedroomsBelowGrade": 1 +"PaymentFrequency": "Monthly" +"PossessionType": "Immediate" +"PrivateEntranceYN": true +"PriorMlsStatus": "Draft" +"LaundryLevel": "Lower Level" +"PaymentMethod": "Cheque" +"WashroomsType3Level": "Second" +"short_address": "Hamilton, ON L8E 0C3, CA" +"KitchensAboveGrade": 1 +"RentalApplicationYN": true +"WashroomsType1": 1 +"WashroomsType2": 1 +"ContractStatus": "Available" +"HeatType": "Forced Air" +"WashroomsType1Pcs": 2 +"BuyOptionYN": true +"RollNumber": "251800302031653" +"DepositRequired": true +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"SystemModificationTimestamp": "2025-07-08T19:53:35.201476Z" +"provider_name": "TRREB" +"ParkingSpaces": 1 +"PossessionDetails": "immediate" +"PermissionToContactListingBrokerToAdvertise": true +"LeaseAgreementYN": true +"GarageType": "Attached" +"WashroomsType2Level": "Second" +"BedroomsAboveGrade": 3 +"MediaChangeTimestamp": "2025-07-08T19:53:34Z" +"WashroomsType2Pcs": 3 +"SurveyType": "None" +"HoldoverDays": 90 +"ReferencesRequiredYN": true +"WashroomsType3": 1 +"KitchensTotal": 1 +"Media": array:25 [ 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] ] } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14627 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12271417" +"ListingId": "X12271417" +"PropertyType": "Residential" +"PropertySubType": "Condo Townhouse" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-08T19:50:32Z" +"RFModificationTimestamp": "2025-07-09T04:05:26Z" +"ListPrice": 499990.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L0R 2H7" +"UnparsedAddress": "249 Burke Street, Hamilton, ON L0R 2H7" +"Coordinates": array:2 [ 0 => -79.8795517 1 => 43.336861 ] +"Latitude": 43.336861 +"Longitude": -79.8795517 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX ESCARPMENT REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Brand new stacked townhome by award-winning developer New Horizon Development Group! This 1-bedroom, 1-bath home offers 672 sq ft of modern living. Featuring vinyl plank flooring throughout, stainless steel kitchen appliances & a 1 car garage! Just minutes from vibrant downtown Waterdown, you'll have access to boutique shopping, diverse dining, and scenic hiking trails. With easy access to major highways and transit including Aldershot GO Station you're never far from Burlington, Hamilton, or Toronto." +"ArchitecturalStyle": array:1 [ 0 => "1 Storey/Apt" ] +"AssociationFee": "225.0" +"AssociationFeeIncludes": array:2 [ 0 => "Common Elements Included" 1 => "Parking Included" ] +"Basement": array:1 [ 0 => "None" ] +"CityRegion": "Waterdown" +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CountyOrParish": "Hamilton" +"CoveredSpaces": "1.0" +"CreationDate": "2025-07-08T20:43:15.172224+00:00" +"CrossStreet": "Kenesky Dr or Great Falls Blvd." +"Directions": "Dundas St E to Burke St." +"ExpirationDate": "2025-11-08" +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"GarageYN": true +"Inclusions": "Built-in Microwave, Dishwasher, Dryer, Refrigerator, Stove, Washer" +"InteriorFeatures": array:1 [ 0 => "Water Heater" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "In-Suite Laundry" ] +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-07-08" +"MainOfficeKey": "184000" +"MajorChangeTimestamp": "2025-07-08T19:50:32Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-07-08T19:50:32Z" +"OriginalListPrice": 499990.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2682152" +"ParkingFeatures": array:1 [ 0 => "None" ] +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ 0 => "Restricted" ] +"PhotosChangeTimestamp": "2025-07-08T19:50:32Z" +"Roof": array:1 [ 0 => "Flat" ] +"ShowingRequirements": array:2 [ 0 => "Lockbox" 1 => "Showing System" ] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Burke" +"StreetNumber": "249" +"StreetSuffix": "Street" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2%" +"TransactionType": "For Sale" +"RoomsAboveGrade": 3 +"PropertyManagementCompany": "TBD" +"Locker": "None" +"KitchensAboveGrade": 1 +"WashroomsType1": 1 +"DDFYN": true +"LivingAreaRange": "600-699" +"HeatSource": "Gas" +"ContractStatus": "Available" +"PropertyFeatures": array:6 [ 0 => "School" 1 => "School Bus Route" 2 => "Rec./Commun.Centre" 3 => "Public Transit" 4 => "Park" 5 => "Library" ] +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12271417')" +"WashroomsType1Pcs": 4 +"HSTApplication": array:1 [ 0 => "In Addition To" ] +"LegalApartmentNumber": "0" +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"SystemModificationTimestamp": "2025-07-08T19:50:32.926749Z" +"provider_name": "TRREB" +"LegalStories": "0" +"PossessionDetails": "Flexible" +"ParkingType1": "None" +"ShowingAppointments": "905-592-7777" +"GarageType": "Attached" +"BalconyType": "Terrace" +"PossessionType": "Flexible" +"Exposure": "West" +"PriorMlsStatus": "Draft" +"BedroomsAboveGrade": 1 +"SquareFootSource": "Builders Floor Plan" +"MediaChangeTimestamp": "2025-07-08T19:50:32Z" +"SurveyType": "Unknown" +"ApproximateAge": "New" +"HoldoverDays": 60 +"EnsuiteLaundryYN": true +"KitchensTotal": 1 +"short_address": "Hamilton, ON L0R 2H7, CA" +"Media": array:20 [ 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] ] } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14626 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12271408" +"ListingId": "X12271408" +"PropertyType": "Residential Lease" +"PropertySubType": "Co-op Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-08T19:46:14Z" +"RFModificationTimestamp": "2025-07-10T03:09:13Z" +"ListPrice": 2500.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8P 0C6" +"UnparsedAddress": "#509 - 15 Queen Street, Hamilton, ON L8P 0C6" +"Coordinates": array:2 [ 0 => -79.8728583 1 => 43.2560802 ] +"Latitude": 43.2560802 +"Longitude": -79.8728583 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX HALLMARK ALLIANCE REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Experience modern downtown living at its finest at 15 Queen Street South in Hamiltons sought-after Platinum Condos. This well-designed 2-bedroom, 2-bathroom suite offers 728 sq ft of sleek living space, featuring a contemporary kitchen with stainless steel appliances and quartz countertops, in-suite laundry, and floor-to-ceiling windows with scenic water and city views. The primary bedroom includes a stylish glass wall with integrated blinds for added privacy and flair. Residents enjoy access to premium amenities including a rooftop terrace with BBQs, a fully equipped fitness centre, yoga deck, party lounge, and bike storage. Located on a quiet stretch in the heart of the city, you're just steps from St. Josephs Hospital, Mc Master, shops, restaurants, the upcoming Queen Street LRT, and more. With unbeatable value and urban convenience, this condo is the perfect place to call home or invest in Hamiltons vibrant core." +"ArchitecturalStyle": array:1 [ 0 => "Apartment" ] +"Basement": array:1 [ 0 => "None" ] +"CityRegion": "Central" +"ConstructionMaterials": array:1 [ 0 => "Metal/Steel Siding" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CountyOrParish": "Hamilton" +"CoveredSpaces": "1.0" +"CreationDate": "2025-07-08T20:45:37.276669+00:00" +"CrossStreet": "QUEEN ST SOUTH & KING ST" +"Directions": "QUEEN ST SOUTH & KING ST" +"ExpirationDate": "2025-11-30" +"Furnished": "Unfurnished" +"GarageYN": true +"InteriorFeatures": array:1 [ 0 => "Other" ] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "Ensuite" ] +"LeaseTerm": "12 Months" +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-07-08" +"MainOfficeKey": "211500" +"MajorChangeTimestamp": "2025-07-08T19:46:14Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-07-08T19:46:14Z" +"OriginalListPrice": 2500.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2681980" +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ 0 => "Restricted" ] +"PhotosChangeTimestamp": "2025-07-08T19:46:14Z" +"RentIncludes": array:4 [ 0 => "Building Insurance" 1 => "Common Elements" 2 => "Grounds Maintenance" 3 => "Exterior Maintenance" ] +"ShowingRequirements": array:1 [ 0 => "Lockbox" ] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Queen" +"StreetNumber": "15" +"StreetSuffix": "Street" +"TransactionBrokerCompensation": "Half months rent" +"TransactionType": "For Lease" +"UnitNumber": "509" +"RoomsAboveGrade": 6 +"PropertyManagementCompany": "City Towers Property Management Inc" +"Locker": "Owned" +"KitchensAboveGrade": 1 +"WashroomsType1": 1 +"DDFYN": true +"WashroomsType2": 1 +"LivingAreaRange": "700-799" +"VendorPropertyInfoStatement": true +"HeatSource": "Gas" +"ContractStatus": "Available" +"PortionPropertyLease": array:1 [ 0 => "Entire Property" ] +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12271408')" +"WashroomsType1Pcs": 4 +"RollNumber": "251802012101709" +"LegalApartmentNumber": "509" +"SpecialDesignation": array:1 [ 0 => "Other" ] +"SystemModificationTimestamp": "2025-07-08T19:46:14.560933Z" +"provider_name": "TRREB" +"LegalStories": "5" +"ParkingType1": "Owned" +"LockerLevel": "2" +"LockerNumber": "44" +"GarageType": "Underground" +"BalconyType": "Enclosed" +"PossessionType": "Immediate" +"PrivateEntranceYN": true +"Exposure": "North" +"PriorMlsStatus": "Draft" +"BedroomsAboveGrade": 2 +"SquareFootSource": "Owner" +"MediaChangeTimestamp": "2025-07-08T19:46:14Z" +"WashroomsType2Pcs": 3 +"SurveyType": "None" +"HoldoverDays": 30 +"CondoCorpNumber": 625 +"KitchensTotal": 1 +"PossessionDate": "2025-07-08" +"short_address": "Hamilton, ON L8P 0C6, CA" +"Media": array:21 [ 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] ] } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14625 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12271230" +"ListingId": "X12271230" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-08T19:23:33Z" +"RFModificationTimestamp": "2025-07-09T04:05:24Z" +"ListPrice": 599000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0.1 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8L 6M8" +"UnparsedAddress": "197 Sherman Avenue, Hamilton, ON L8L 6M8" +"Coordinates": array:2 [ 0 => -79.8406804 1 => 43.2455524 ] +"Latitude": 43.2455524 +"Longitude": -79.8406804 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX REALTY SERVICES INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Amazing opportunity ! Fully detached all brick building operating as a sports club / bar with a two bedroom rental apartment on the upper level. Premium 20' X 158' pie - shaped lot ( 40' rear ) located in the up and coming " Gibson Community ". This is a fully operational " Sports Club" with a 64 person capacity and is being sold with the " Liquor Sales Licence " ( see attached ). The new owner is responsible to transfer the licence to his / her name. The building is solid but needs cosmetic updating on all three levels, large rear yard with multiple storage buildings and a detached all brick garage fronting onto the rear laneway. All fixtures and chattels are included " as-is ", no financials are available for the Sports Club and there is no guarantee that the Alcohol and Gaming Commission will accept the new applicant. This is a perfect opportunity for the new owner to live / work in the same location and create equity by improving the existing building / property. Second floor apartment has a side entrance as well as a rear stairwell. Hot water gas heat, gas hot water tank ( rental ). Sale price includes the building and operating business." +"ArchitecturalStyle": array:1 [ 0 => "2-Storey" ] +"Basement": array:2 [ 0 => "Unfinished" 1 => "Full" ] +"CityRegion": "Gibson" +"ConstructionMaterials": array:2 [ 0 => "Stone" 1 => "Brick" ] +"Cooling": array:1 [ 0 => "None" ] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CoveredSpaces": "2.0" +"CreationDate": "2025-07-08T19:07:25.082853+00:00" +"CrossStreet": "Sherman / Barton" +"DirectionFaces": "West" +"Directions": "Sherman / Barton" +"ExpirationDate": "2026-03-30" +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"GarageYN": true +"Inclusions": "All electrical light fixtures, all window coverings, fridge, stove, shed, bar fridge." +"InteriorFeatures": array:1 [ 0 => "None" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-07-08" +"LotSizeSource": "MPAC" +"MainOfficeKey": "498000" +"MajorChangeTimestamp": "2025-07-08T18:59:11Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2025-07-08T18:59:11Z" +"OriginalListPrice": 599000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2679672" +"ParcelNumber": "171940228" +"ParkingFeatures": array:1 [ 0 => "Street Only" ] +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-07-08T18:59:11Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:1 [ 0 => "Go Direct" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "N" +"StreetName": "Sherman" +"StreetNumber": "197" +"StreetSuffix": "Avenue" +"TaxAnnualAmount": "3667.99" +"TaxLegalDescription": "Plan 245, PT Lot 10" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2.5%" +"TransactionType": "For Sale" +"Water": "Municipal" +"RoomsAboveGrade": 5 +"KitchensAboveGrade": 1 +"WashroomsType1": 1 +"DDFYN": true +"WashroomsType2": 1 +"LivingAreaRange": "1500-2000" +"HeatSource": "Gas" +"ContractStatus": "Available" +"PropertyFeatures": array:1 [ 0 => "Public Transit" ] +"LotWidth": 20.0 +"HeatType": "Water" +"WashroomsType3Pcs": 4 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12271230')" +"WashroomsType1Pcs": 2 +"HSTApplication": array:1 [ 0 => "In Addition To" ] +"MortgageComment": "Treat as clear, please email all offers to [email protected], as per the seller." +"RollNumber": "251803023607890" +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"AssessmentYear": 2025 +"SystemModificationTimestamp": "2025-07-08T19:23:34.157599Z" +"provider_name": "TRREB" +"KitchensBelowGrade": 1 +"LotDepth": 157.9 +"PossessionDetails": "30-60 Days / TBA" +"GarageType": "Detached" +"ParcelOfTiedLand": "No" +"PossessionType": "30-59 days" +"PriorMlsStatus": "Draft" +"BedroomsAboveGrade": 2 +"MediaChangeTimestamp": "2025-07-08T18:59:11Z" +"WashroomsType2Pcs": 3 +"RentalItems": "Hot water tank ( if rental )" +"LotIrregularities": "Pie-Shaped Lot ( 40' Rear ) !" +"SurveyType": "None" +"UFFI": "No" +"HoldoverDays": 90 +"WashroomsType3": 1 +"KitchensTotal": 2 +"Media": array:20 [ 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] ] } ] +success: true +page_size: 10 +page_count: 411 +count: 4105 +after_key: "" } ] ]
