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: f5368fe41ff463615a9159da8e69c59479a51caf7f9756f4d268dd6ea31159fd" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#14454 +items: array:10 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14625 +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 [ "ResourceRecordKey" => "X12271429" "MediaModificationTimestamp" => "2025-07-08T19:53:34.964667Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12271429/thumbnail-b070441b1f6373ff1f3e716802d03bf3.webp" "ShortDescription" => null "MediaKey" => "198b300d-49ac-4b45-958e-fd8aa011c4a7" "ImageWidth" => 3840 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-08T19:53:34.964667Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "198b300d-49ac-4b45-958e-fd8aa011c4a7" "Order" => 0 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12271429/b070441b1f6373ff1f3e716802d03bf3.webp" "MediaSize" => 1776872 "SourceSystemMediaKey" => "198b300d-49ac-4b45-958e-fd8aa011c4a7" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => true "LongDescription" => null "ImageHeight" => 2560 ] 1 => array:26 [ "ResourceRecordKey" => "X12271429" "MediaModificationTimestamp" => "2025-07-08T19:53:34.964667Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12271429/thumbnail-e73c8c4d8de16949f85415d177f2886e.webp" "ShortDescription" => null "MediaKey" => "07f1a8ae-16b4-4f0c-aec0-c2e5f5bb2e24" "ImageWidth" => 3840 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-08T19:53:34.964667Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "07f1a8ae-16b4-4f0c-aec0-c2e5f5bb2e24" "Order" => 1 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12271429/e73c8c4d8de16949f85415d177f2886e.webp" "MediaSize" => 1799494 "SourceSystemMediaKey" => "07f1a8ae-16b4-4f0c-aec0-c2e5f5bb2e24" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 2560 ] 2 => array:26 [ "ResourceRecordKey" => "X12271429" "MediaModificationTimestamp" => "2025-07-08T19:53:34.964667Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12271429/thumbnail-b55bf2fd8ae1010bf8a8d75a9bcb854e.webp" "ShortDescription" => null "MediaKey" => "febe28a7-5947-4ad6-a199-ccd0a6c5fb35" "ImageWidth" => 3840 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-08T19:53:34.964667Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "febe28a7-5947-4ad6-a199-ccd0a6c5fb35" "Order" => 2 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12271429/b55bf2fd8ae1010bf8a8d75a9bcb854e.webp" "MediaSize" => 1764382 "SourceSystemMediaKey" => "febe28a7-5947-4ad6-a199-ccd0a6c5fb35" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 2560 ] 3 => array:26 [ "ResourceRecordKey" => "X12271429" "MediaModificationTimestamp" => "2025-07-08T19:53:34.964667Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12271429/thumbnail-6e98d8386a224ae8693ed8cc8eef396e.webp" "ShortDescription" => null "MediaKey" => "a976a447-9e76-40ad-aacc-1657c693f050" "ImageWidth" => 3000 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-08T19:53:34.964667Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "a976a447-9e76-40ad-aacc-1657c693f050" "Order" => 3 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12271429/6e98d8386a224ae8693ed8cc8eef396e.webp" "MediaSize" => 647749 "SourceSystemMediaKey" => "a976a447-9e76-40ad-aacc-1657c693f050" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 2000 ] 4 => array:26 [ "ResourceRecordKey" => "X12271429" "MediaModificationTimestamp" => "2025-07-08T19:53:34.964667Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12271429/thumbnail-c85448b22e5ba1c5958d1ae9649c44e9.webp" "ShortDescription" => null "MediaKey" => "4b8909b1-bff9-4b43-a0f6-d8dd058b6509" "ImageWidth" => 3000 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-08T19:53:34.964667Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "4b8909b1-bff9-4b43-a0f6-d8dd058b6509" "Order" => 4 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12271429/c85448b22e5ba1c5958d1ae9649c44e9.webp" "MediaSize" => 800746 "SourceSystemMediaKey" => "4b8909b1-bff9-4b43-a0f6-d8dd058b6509" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 2000 ] 5 => array:26 [ "ResourceRecordKey" => "X12271429" "MediaModificationTimestamp" => "2025-07-08T19:53:34.964667Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12271429/thumbnail-f7eb7b031ef3b4cd2a8f994686499dde.webp" "ShortDescription" => null "MediaKey" => "1d4e1f82-5979-4a97-9c83-7bbe8dc74484" "ImageWidth" => 3000 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-08T19:53:34.964667Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "1d4e1f82-5979-4a97-9c83-7bbe8dc74484" "Order" => 5 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12271429/f7eb7b031ef3b4cd2a8f994686499dde.webp" "MediaSize" => 719735 "SourceSystemMediaKey" => "1d4e1f82-5979-4a97-9c83-7bbe8dc74484" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 2000 ] 6 => array:26 [ "ResourceRecordKey" => "X12271429" "MediaModificationTimestamp" => "2025-07-08T19:53:34.964667Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12271429/thumbnail-8382ea53e2f1f5c7dd553af4842b829c.webp" "ShortDescription" => null "MediaKey" => "9a9f6b82-bc0c-4fdf-92dd-db375f099eb8" "ImageWidth" => 3000 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-08T19:53:34.964667Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "9a9f6b82-bc0c-4fdf-92dd-db375f099eb8" "Order" => 6 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12271429/8382ea53e2f1f5c7dd553af4842b829c.webp" "MediaSize" => 701777 "SourceSystemMediaKey" => "9a9f6b82-bc0c-4fdf-92dd-db375f099eb8" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 2000 ] 7 => array:26 [ "ResourceRecordKey" => "X12271429" "MediaModificationTimestamp" => "2025-07-08T19:53:34.964667Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12271429/thumbnail-7ed3770d0a88a42859aaac9a984bf5e9.webp" "ShortDescription" => null "MediaKey" => "00fa921d-75dc-46df-bf0f-3ec3713855bf" "ImageWidth" => 3000 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-08T19:53:34.964667Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "00fa921d-75dc-46df-bf0f-3ec3713855bf" "Order" => 7 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12271429/7ed3770d0a88a42859aaac9a984bf5e9.webp" "MediaSize" => 656332 "SourceSystemMediaKey" => "00fa921d-75dc-46df-bf0f-3ec3713855bf" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 2000 ] 8 => array:26 [ "ResourceRecordKey" => "X12271429" "MediaModificationTimestamp" => "2025-07-08T19:53:34.964667Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12271429/thumbnail-cd365e29a15709925b95ae2439dcca36.webp" "ShortDescription" => null "MediaKey" => "8b0b1455-9119-4dcd-9f69-429faf35573b" "ImageWidth" => 3000 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-08T19:53:34.964667Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "8b0b1455-9119-4dcd-9f69-429faf35573b" "Order" => 8 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12271429/cd365e29a15709925b95ae2439dcca36.webp" "MediaSize" => 661337 "SourceSystemMediaKey" => "8b0b1455-9119-4dcd-9f69-429faf35573b" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 2000 ] 9 => array:26 [ "ResourceRecordKey" => "X12271429" "MediaModificationTimestamp" => "2025-07-08T19:53:34.964667Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12271429/thumbnail-dd1ad0f70c27aed986cfe0a809affdfc.webp" "ShortDescription" => null "MediaKey" => "4b351d88-113c-47d1-aa2e-eca5544c5dd0" "ImageWidth" => 3000 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-08T19:53:34.964667Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "4b351d88-113c-47d1-aa2e-eca5544c5dd0" "Order" => 9 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12271429/dd1ad0f70c27aed986cfe0a809affdfc.webp" "MediaSize" => 720689 "SourceSystemMediaKey" => "4b351d88-113c-47d1-aa2e-eca5544c5dd0" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 2000 ] 10 => array:26 [ "ResourceRecordKey" => "X12271429" "MediaModificationTimestamp" => "2025-07-08T19:53:34.964667Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12271429/thumbnail-b3ac98c9de83f98194d733235ec7e228.webp" "ShortDescription" => null "MediaKey" => "52018d1c-4389-4f5c-9381-5b1afa7f17bc" "ImageWidth" => 3000 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-08T19:53:34.964667Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "52018d1c-4389-4f5c-9381-5b1afa7f17bc" "Order" => 10 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12271429/b3ac98c9de83f98194d733235ec7e228.webp" "MediaSize" => 833258 "SourceSystemMediaKey" => "52018d1c-4389-4f5c-9381-5b1afa7f17bc" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 2000 ] 11 => array:26 [ "ResourceRecordKey" => "X12271429" "MediaModificationTimestamp" => "2025-07-08T19:53:34.964667Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12271429/thumbnail-6c62fe2c72f312dcb7273ae4571ab134.webp" "ShortDescription" => null "MediaKey" => "65d2850b-819a-404e-a98e-9242eac7efca" "ImageWidth" => 3000 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-08T19:53:34.964667Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "65d2850b-819a-404e-a98e-9242eac7efca" "Order" => 11 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12271429/6c62fe2c72f312dcb7273ae4571ab134.webp" "MediaSize" => 704486 "SourceSystemMediaKey" => "65d2850b-819a-404e-a98e-9242eac7efca" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 2000 ] 12 => array:26 [ "ResourceRecordKey" => "X12271429" "MediaModificationTimestamp" => "2025-07-08T19:53:34.964667Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12271429/thumbnail-dbe3fd7748ad5b325183f923bfb866d5.webp" "ShortDescription" => null "MediaKey" => "2fb1948e-2efc-4548-b952-b422cd9ea729" "ImageWidth" => 3000 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-08T19:53:34.964667Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "2fb1948e-2efc-4548-b952-b422cd9ea729" "Order" => 12 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12271429/dbe3fd7748ad5b325183f923bfb866d5.webp" "MediaSize" => 831156 "SourceSystemMediaKey" => "2fb1948e-2efc-4548-b952-b422cd9ea729" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 2000 ] 13 => array:26 [ "ResourceRecordKey" => "X12271429" "MediaModificationTimestamp" => "2025-07-08T19:53:34.964667Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12271429/thumbnail-690ecc52b9d7f3cb95fdc29afd561e3c.webp" "ShortDescription" => null "MediaKey" => "25cde06c-2753-4442-9e59-c3fec7989981" "ImageWidth" => 3000 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-08T19:53:34.964667Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "25cde06c-2753-4442-9e59-c3fec7989981" "Order" => 13 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12271429/690ecc52b9d7f3cb95fdc29afd561e3c.webp" "MediaSize" => 705067 "SourceSystemMediaKey" => "25cde06c-2753-4442-9e59-c3fec7989981" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 2000 ] 14 => array:26 [ "ResourceRecordKey" => "X12271429" "MediaModificationTimestamp" => "2025-07-08T19:53:34.964667Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12271429/thumbnail-ae0420ee475df358e5692fd96a7f9c78.webp" "ShortDescription" => null "MediaKey" => "630cb69a-bcf8-42e8-b2f7-86dcec9761a1" "ImageWidth" => 3000 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-08T19:53:34.964667Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "630cb69a-bcf8-42e8-b2f7-86dcec9761a1" "Order" => 14 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12271429/ae0420ee475df358e5692fd96a7f9c78.webp" "MediaSize" => 555110 "SourceSystemMediaKey" => "630cb69a-bcf8-42e8-b2f7-86dcec9761a1" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 2000 ] 15 => array:26 [ "ResourceRecordKey" => "X12271429" "MediaModificationTimestamp" => "2025-07-08T19:53:34.964667Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12271429/thumbnail-10c6c18490f9e1ff3a6a6ece14ae1ae9.webp" "ShortDescription" => null "MediaKey" => "95aad0b2-ea62-468d-88f2-f939f05c03b2" "ImageWidth" => 3000 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-08T19:53:34.964667Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "95aad0b2-ea62-468d-88f2-f939f05c03b2" "Order" => 15 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12271429/10c6c18490f9e1ff3a6a6ece14ae1ae9.webp" "MediaSize" => 477267 "SourceSystemMediaKey" => "95aad0b2-ea62-468d-88f2-f939f05c03b2" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 2000 ] 16 => array:26 [ "ResourceRecordKey" => "X12271429" "MediaModificationTimestamp" => "2025-07-08T19:53:34.964667Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12271429/thumbnail-633707217a4f33114c7e470b3e6117ca.webp" "ShortDescription" => null "MediaKey" => "ba7abcd3-ecde-4e7c-a9c4-b03f342d6b91" "ImageWidth" => 3000 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-08T19:53:34.964667Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "ba7abcd3-ecde-4e7c-a9c4-b03f342d6b91" "Order" => 16 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12271429/633707217a4f33114c7e470b3e6117ca.webp" "MediaSize" => 534966 "SourceSystemMediaKey" => "ba7abcd3-ecde-4e7c-a9c4-b03f342d6b91" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 2000 ] 17 => array:26 [ "ResourceRecordKey" => "X12271429" "MediaModificationTimestamp" => "2025-07-08T19:53:34.964667Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12271429/thumbnail-32aaf363eb1720372f511e02f389ec30.webp" "ShortDescription" => null "MediaKey" => "9c3c1235-13e1-447c-8479-9b3cbd16a41a" "ImageWidth" => 3000 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-08T19:53:34.964667Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "9c3c1235-13e1-447c-8479-9b3cbd16a41a" "Order" => 17 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12271429/32aaf363eb1720372f511e02f389ec30.webp" "MediaSize" => 680309 "SourceSystemMediaKey" => "9c3c1235-13e1-447c-8479-9b3cbd16a41a" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 2000 ] 18 => array:26 [ "ResourceRecordKey" => "X12271429" "MediaModificationTimestamp" => "2025-07-08T19:53:34.964667Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12271429/thumbnail-2af95d5203026fc6b733cea297e91478.webp" "ShortDescription" => null "MediaKey" => "4c3042f6-ac23-415e-b546-e15a4b615b42" "ImageWidth" => 3000 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-08T19:53:34.964667Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "4c3042f6-ac23-415e-b546-e15a4b615b42" "Order" => 18 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12271429/2af95d5203026fc6b733cea297e91478.webp" "MediaSize" => 766464 "SourceSystemMediaKey" => "4c3042f6-ac23-415e-b546-e15a4b615b42" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 2000 ] 19 => array:26 [ "ResourceRecordKey" => "X12271429" "MediaModificationTimestamp" => "2025-07-08T19:53:34.964667Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12271429/thumbnail-b632ef4006d4bff469ef4305dc5e8268.webp" "ShortDescription" => null "MediaKey" => "cd5b92a9-9503-4a8b-87e3-96d199a7144c" "ImageWidth" => 3000 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-08T19:53:34.964667Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "cd5b92a9-9503-4a8b-87e3-96d199a7144c" "Order" => 19 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12271429/b632ef4006d4bff469ef4305dc5e8268.webp" "MediaSize" => 546721 "SourceSystemMediaKey" => "cd5b92a9-9503-4a8b-87e3-96d199a7144c" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 2000 ] 20 => array:26 [ "ResourceRecordKey" => "X12271429" "MediaModificationTimestamp" => "2025-07-08T19:53:34.964667Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12271429/thumbnail-a327ba581cf07b5b76937bb6013166ae.webp" "ShortDescription" => null "MediaKey" => "ef875cdc-75df-47bb-96b4-612b680c26da" "ImageWidth" => 3000 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-08T19:53:34.964667Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "ef875cdc-75df-47bb-96b4-612b680c26da" "Order" => 20 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12271429/a327ba581cf07b5b76937bb6013166ae.webp" "MediaSize" => 539981 "SourceSystemMediaKey" => "ef875cdc-75df-47bb-96b4-612b680c26da" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 2000 ] 21 => array:26 [ "ResourceRecordKey" => "X12271429" "MediaModificationTimestamp" => "2025-07-08T19:53:34.964667Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12271429/thumbnail-4a5fe65b77aa02e1ea47222291636500.webp" "ShortDescription" => null "MediaKey" => "30b1db7b-ca98-4e82-a20c-1d31855cf6d0" "ImageWidth" => 3000 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-08T19:53:34.964667Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "30b1db7b-ca98-4e82-a20c-1d31855cf6d0" "Order" => 21 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12271429/4a5fe65b77aa02e1ea47222291636500.webp" "MediaSize" => 799473 "SourceSystemMediaKey" => "30b1db7b-ca98-4e82-a20c-1d31855cf6d0" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 2000 ] 22 => array:26 [ "ResourceRecordKey" => "X12271429" "MediaModificationTimestamp" => "2025-07-08T19:53:34.964667Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12271429/thumbnail-6b35e4fb6763147e938db45da4288653.webp" "ShortDescription" => null "MediaKey" => "70ee8ad6-ed24-41fb-b884-1d8cf5489658" "ImageWidth" => 3000 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-08T19:53:34.964667Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "70ee8ad6-ed24-41fb-b884-1d8cf5489658" "Order" => 22 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12271429/6b35e4fb6763147e938db45da4288653.webp" "MediaSize" => 991926 "SourceSystemMediaKey" => "70ee8ad6-ed24-41fb-b884-1d8cf5489658" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 2000 ] 23 => array:26 [ "ResourceRecordKey" => "X12271429" "MediaModificationTimestamp" => "2025-07-08T19:53:34.964667Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12271429/thumbnail-99ab694c550243e271520a0f17fd01a8.webp" "ShortDescription" => null "MediaKey" => "8df85928-5759-40e1-ad03-cc5baba9ba27" "ImageWidth" => 3000 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-08T19:53:34.964667Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "8df85928-5759-40e1-ad03-cc5baba9ba27" "Order" => 23 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12271429/99ab694c550243e271520a0f17fd01a8.webp" "MediaSize" => 1469580 "SourceSystemMediaKey" => "8df85928-5759-40e1-ad03-cc5baba9ba27" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 2000 ] 24 => array:26 [ "ResourceRecordKey" => "X12271429" "MediaModificationTimestamp" => "2025-07-08T19:53:34.964667Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12271429/thumbnail-bfa010a03a1fc796c77619df0bbd2077.webp" "ShortDescription" => null "MediaKey" => "e616f539-051c-4ff9-8f03-a0e6a22ec3e0" "ImageWidth" => 3000 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-08T19:53:34.964667Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "e616f539-051c-4ff9-8f03-a0e6a22ec3e0" "Order" => 24 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12271429/bfa010a03a1fc796c77619df0bbd2077.webp" "MediaSize" => 1349329 "SourceSystemMediaKey" => "e616f539-051c-4ff9-8f03-a0e6a22ec3e0" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 2000 ] ] } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14626 +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 [ "ResourceRecordKey" => "X12271417" "MediaModificationTimestamp" => "2025-07-08T19:50:32.338879Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12271417/thumbnail-34852533d41cfce057b54d116cdf2032.webp" "ShortDescription" => null "MediaKey" => "7b4228da-7494-49cc-9084-3b6cee266388" "ImageWidth" => 3564 "ClassName" => "ResidentialCondo" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-08T19:50:32.338879Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "7b4228da-7494-49cc-9084-3b6cee266388" "Order" => 0 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12271417/34852533d41cfce057b54d116cdf2032.webp" "MediaSize" => 809297 "SourceSystemMediaKey" => "7b4228da-7494-49cc-9084-3b6cee266388" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => true "LongDescription" => null "ImageHeight" => 1323 ] 1 => array:26 [ "ResourceRecordKey" => "X12271417" "MediaModificationTimestamp" => "2025-07-08T19:50:32.338879Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12271417/thumbnail-7d3c066b87e9a680fa428942c82b6497.webp" "ShortDescription" => null "MediaKey" => "008b1d63-d1a0-4f9b-9b27-e9bbca91e65e" "ImageWidth" => 2500 "ClassName" => "ResidentialCondo" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-08T19:50:32.338879Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "008b1d63-d1a0-4f9b-9b27-e9bbca91e65e" "Order" => 1 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12271417/7d3c066b87e9a680fa428942c82b6497.webp" "MediaSize" => 203654 "SourceSystemMediaKey" => "008b1d63-d1a0-4f9b-9b27-e9bbca91e65e" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 1667 ] 2 => array:26 [ "ResourceRecordKey" => "X12271417" "MediaModificationTimestamp" => "2025-07-08T19:50:32.338879Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12271417/thumbnail-1d82ac55113a853184132f99d0cba5e0.webp" "ShortDescription" => null "MediaKey" => "a96b7bae-0724-43fe-b46f-10e9fd48ef04" "ImageWidth" => 2500 "ClassName" => "ResidentialCondo" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-08T19:50:32.338879Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "a96b7bae-0724-43fe-b46f-10e9fd48ef04" "Order" => 2 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12271417/1d82ac55113a853184132f99d0cba5e0.webp" "MediaSize" => 182161 "SourceSystemMediaKey" => "a96b7bae-0724-43fe-b46f-10e9fd48ef04" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 1667 ] 3 => array:26 [ "ResourceRecordKey" => "X12271417" "MediaModificationTimestamp" => "2025-07-08T19:50:32.338879Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12271417/thumbnail-74d555779f8e513a316022982dd86e47.webp" "ShortDescription" => null "MediaKey" => "bb12b3b2-8f51-46b6-86a4-1d83ce50435e" "ImageWidth" => 2500 "ClassName" => "ResidentialCondo" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-08T19:50:32.338879Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "bb12b3b2-8f51-46b6-86a4-1d83ce50435e" "Order" => 3 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12271417/74d555779f8e513a316022982dd86e47.webp" "MediaSize" => 218570 "SourceSystemMediaKey" => "bb12b3b2-8f51-46b6-86a4-1d83ce50435e" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 1667 ] 4 => array:26 [ "ResourceRecordKey" => "X12271417" "MediaModificationTimestamp" => "2025-07-08T19:50:32.338879Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12271417/thumbnail-2821f41be6a2a758575a239839956595.webp" "ShortDescription" => null "MediaKey" => "7452c8fd-9da8-4677-ac7a-224de68a1f52" "ImageWidth" => 2500 "ClassName" => "ResidentialCondo" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-08T19:50:32.338879Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "7452c8fd-9da8-4677-ac7a-224de68a1f52" "Order" => 4 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12271417/2821f41be6a2a758575a239839956595.webp" "MediaSize" => 210509 "SourceSystemMediaKey" => "7452c8fd-9da8-4677-ac7a-224de68a1f52" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 1667 ] 5 => array:26 [ "ResourceRecordKey" => "X12271417" "MediaModificationTimestamp" => "2025-07-08T19:50:32.338879Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12271417/thumbnail-2b123544456f5a539aa287092dba4fe9.webp" "ShortDescription" => null "MediaKey" => "427fe12c-9b9d-437f-bddf-d2ab509bfbd0" "ImageWidth" => 2500 "ClassName" => "ResidentialCondo" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-08T19:50:32.338879Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "427fe12c-9b9d-437f-bddf-d2ab509bfbd0" "Order" => 5 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12271417/2b123544456f5a539aa287092dba4fe9.webp" "MediaSize" => 180063 "SourceSystemMediaKey" => "427fe12c-9b9d-437f-bddf-d2ab509bfbd0" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 1667 ] 6 => array:26 [ "ResourceRecordKey" => "X12271417" "MediaModificationTimestamp" => "2025-07-08T19:50:32.338879Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12271417/thumbnail-d000bba828999b31ec5e6ab800e6b5a6.webp" "ShortDescription" => null "MediaKey" => "d51145d2-1416-4da0-bf06-8c43a1836472" "ImageWidth" => 2500 "ClassName" => "ResidentialCondo" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-08T19:50:32.338879Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "d51145d2-1416-4da0-bf06-8c43a1836472" "Order" => 6 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12271417/d000bba828999b31ec5e6ab800e6b5a6.webp" "MediaSize" => 200939 "SourceSystemMediaKey" => "d51145d2-1416-4da0-bf06-8c43a1836472" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 1667 ] 7 => array:26 [ "ResourceRecordKey" => "X12271417" "MediaModificationTimestamp" => "2025-07-08T19:50:32.338879Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12271417/thumbnail-ece707e857c1ff991ddc17dae4359d0a.webp" "ShortDescription" => null "MediaKey" => "01612b14-6a2e-46e9-ae33-35a5828ead87" "ImageWidth" => 2500 "ClassName" => "ResidentialCondo" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-07-08T19:50:32.338879Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "01612b14-6a2e-46e9-ae33-35a5828ead87" "Order" => 7 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12271417/ece707e857c1ff991ddc17dae4359d0a.webp" "MediaSize" => 193500 "SourceSystemMediaKey" => "01612b14-6a2e-46e9-ae33-35a5828ead87" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 1667 ] 8 => array:26 [ "ResourceRecordKey" => "X12271417" "MediaModificationTimestamp" => "2025-07-08T19:50:32.338879Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12271417/thumbnail-9e12d1111c25effe6c55b000758a4632.webp" "ShortDescription" => null …20 ] 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] ] } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14632 +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] ] } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14629 +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] ] } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14624 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12265285" +"ListingId": "X12265285" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-08T19:23:21Z" +"RFModificationTimestamp": "2025-07-08T20:06:46Z" +"ListPrice": 899900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8M 2P9" +"UnparsedAddress": "176 Sherman Avenue, Hamilton, ON L8M 2P9" +"Coordinates": array:2 [ 0 => -79.8407541 1 => 43.2462461 ] +"Latitude": 43.2462461 +"Longitude": -79.8407541 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX ESCARPMENT REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to 176 Sherman, a beautiful century home nestled in the prestigious Blakeley/St Clair neighbourhood. This home has so much to offer with the perfect balance of thoughtful updates and classic character. Solid wood trim, original pocket doors, and gorgeous hardwood have been meticulously maintained. New kichen seamlessly complements the century details of the home while providing all the modern comforts. Quartz counters, sleek cabinets, oversized island and pot filler are just a few of the kitchen features you'll enjoy. Convenient mud room leads to the lush and private backyard with garage. All bedrooms are a great size and one of them has a balcony, offering a private retreat tucked in the trees. Fully renovated bathroom on the bedroom level with clawfoot tub and original wood trim. Third floor is an incredible multi-function space with a wet bar and can be used as an office, primary retreat, guest suite or play room! Separate entrance to the dry finished basement with second full bath. Located just minutes from parks, schools (steps to Adelaide Hoodless!), and trendy shops, this home is a true gem in one of Hamiltons most desirable areas." +"ArchitecturalStyle": array:1 [ 0 => "2 1/2 Storey" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"CityRegion": "St. Clair" +"CoListOfficeName": "RE/MAX ESCARPMENT REALTY INC." +"CoListOfficePhone": "905-632-2199" +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CountyOrParish": "Hamilton" +"CoveredSpaces": "1.0" +"CreationDate": "2025-07-05T16:39:31.365438+00:00" +"CrossStreet": "Main St & Sherman Ave" +"DirectionFaces": "West" +"Directions": "South of Main St. East" +"ExpirationDate": "2025-11-02" +"FireplaceFeatures": array:1 [ 0 => "Wood" ] +"FireplaceYN": true +"FoundationDetails": array:1 [ 0 => "Stone" ] +"GarageYN": true +"Inclusions": "Fridge, stove, hood fan, dishwasher, washer/dryer" +"InteriorFeatures": array:1 [ 0 => "Other" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-07-05" +"MainOfficeKey": "184000" +"MajorChangeTimestamp": "2025-07-05T16:35:28Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-07-05T16:35:28Z" +"OriginalListPrice": 899900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2666306" +"ParcelNumber": "172030155" +"ParkingFeatures": array:2 [ 0 => "Front Yard Parking" 1 => "Mutual" ] +"ParkingTotal": "3.0" +"PhotosChangeTimestamp": "2025-07-05T16:35:28Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:3 [ 0 => "Lockbox" 1 => "Showing System" 2 => "List Brokerage" ] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "S" +"StreetName": "Sherman" +"StreetNumber": "176" +"StreetSuffix": "Avenue" +"TaxAnnualAmount": "4086.0" +"TaxAssessedValue": 216000 +"TaxLegalDescription": "LT 34, Registrar's Compiled Plan 1487; Hamilton" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2%" +"TransactionType": "For Sale" +"VirtualTourURLUnbranded": "https://youriguide.com/176_sherman_ave_s_hamilton_on/" +"Zoning": "C" +"Water": "Municipal" +"RoomsAboveGrade": 9 +"KitchensAboveGrade": 1 +"UnderContract": array:1 [ 0 => "Hot Water Heater" ] +"WashroomsType1": 1 +"DDFYN": true +"WashroomsType2": 1 +"LivingAreaRange": "2000-2500" +"HeatSource": "Gas" +"ContractStatus": "Available" +"PropertyFeatures": array:6 [ 0 => "Place Of Worship" 1 => "Public Transit" 2 => "Rec./Commun.Centre" 3 => "School" 4 => "Hospital" 5 => "Library" ] +"LotWidth": 26.67 +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12265285')" +"WashroomsType1Pcs": 3 +"WashroomsType1Level": "Second" +"HSTApplication": array:1 [ 0 => "Included In" ] +"MortgageComment": "Seller to Discharge" +"RollNumber": "251803024607920" +"DevelopmentChargesPaid": array:1 [ 0 => "Unknown" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"AssessmentYear": 2025 +"SystemModificationTimestamp": "2025-07-08T19:23:25.051638Z" +"provider_name": "TRREB" +"LotDepth": 115.0 +"ParkingSpaces": 2 +"PossessionDetails": "Flexible" +"PermissionToContactListingBrokerToAdvertise": true +"ShowingAppointments": "Broker Bay/LBO" +"BedroomsBelowGrade": 1 +"GarageType": "Detached" +"ParcelOfTiedLand": "No" +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType2Level": "Basement" +"BedroomsAboveGrade": 3 +"MediaChangeTimestamp": "2025-07-05T16:35:28Z" +"WashroomsType2Pcs": 3 +"RentalItems": "Hot Water Heater" +"DenFamilyroomYN": true +"SurveyType": "None" +"ApproximateAge": "51-99" +"HoldoverDays": 60 +"LaundryLevel": "Lower Level" +"KitchensTotal": 1 +"Media": array:49 [ 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] ] } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14603 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12271290" +"ListingId": "X12271290" +"PropertyType": "Commercial Sale" +"PropertySubType": "Commercial Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-08T19:17:22Z" +"RFModificationTimestamp": "2025-07-09T04:05:25Z" +"ListPrice": 599000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 4015.0 +"LivingArea": 0 +"BuildingAreaTotal": 5817.0 +"City": "Hamilton" +"PostalCode": "L8L 3C4" +"UnparsedAddress": "955 Barton Street, Hamilton, ON L8L 3C4" +"Coordinates": array:2 [ 0 => -79.6741308 1 => 43.2164185 ] +"Latitude": 43.2164185 +"Longitude": -79.6741308 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX ESCARPMENT REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Prime Commerical Space- High traffic Barton St. E. Don't miss this incredible opportunity to establish your buisness in a prime commerical space on bustling Barton Street in Hamilton. Located in a high-exposure area with steady pedestrian and vehicle traffic, this property is ideal for retail or service based businesses. Grab the chance to grow your buisness in one of Hamilton's busiest corridors." +"BuildingAreaUnits": "Square Feet" +"BusinessType": array:1 [ 0 => "Other" ] +"CityRegion": "Crown Point" +"Cooling": array:1 [ 0 => "Yes" ] +"CountyOrParish": "Hamilton" +"CreationDate": "2025-07-08T20:10:23.881773+00:00" +"CrossStreet": "GAGE" +"Directions": "BARTON, EAST OF GAGE AVE" +"ExpirationDate": "2026-01-08" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-07-08" +"MainOfficeKey": "184000" +"MajorChangeTimestamp": "2025-07-08T19:17:22Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-07-08T19:17:22Z" +"OriginalListPrice": 599000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2678622" +"ParcelNumber": "172200138" +"PhotosChangeTimestamp": "2025-07-08T19:17:22Z" +"SecurityFeatures": array:1 [ 0 => "No" ] +"ShowingRequirements": array:1 [ 0 => "List Brokerage" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "E" +"StreetName": "Barton" +"StreetNumber": "955" +"StreetSuffix": "Street" +"TaxAnnualAmount": "7473.0" +"TaxLegalDescription": "LT 64, PL 414 ; HAMILTON" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2%+HST" +"TransactionType": "For Sale" +"Utilities": array:1 [ 0 => "Yes" ] +"Zoning": "C5" +"Water": "Municipal" +"FreestandingYN": true +"WashroomsType1": 2 +"DDFYN": true +"LotType": "Lot" +"PropertyUse": "Retail" +"SoilTest": "No" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"LotWidth": 40.0 +"HeatType": "Gas Forced Air Open" +"LotShape": "Rectangular" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12271290')" +"LotSizeAreaUnits": "Square Meters" +"Rail": "No" +"HSTApplication": array:1 [ 0 => "Included In" ] +"RollNumber": "251804028602160" +"RetailArea": 5817.0 +"SystemModificationTimestamp": "2025-07-08T19:17:22.550768Z" +"provider_name": "TRREB" +"LotDepth": 100.0 +"ParkingSpaces": 4 +"PossessionDetails": "IMMEDIATE" +"PermissionToContactListingBrokerToAdvertise": true +"ShowingAppointments": "Showings anytime. 905-597-7777" +"GarageType": "None" +"PossessionType": "Immediate" +"PriorMlsStatus": "Draft" +"MediaChangeTimestamp": "2025-07-08T19:17:22Z" +"TaxType": "Annual" +"ApproximateAge": "51-99" +"HoldoverDays": 90 +"ElevatorType": "None" +"RetailAreaCode": "Sq Ft" +"short_address": "Hamilton, ON L8L 3C4, CA" +"Media": array:13 [ 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] ] } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14602 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12097471" +"ListingId": "X12097471" +"PropertyType": "Commercial Sale" +"PropertySubType": "Commercial Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-08T19:13:58Z" +"RFModificationTimestamp": "2025-07-08T19:29:57Z" +"ListPrice": 650000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 2000.0 +"City": "Hamilton" +"PostalCode": "L8N 1B9" +"UnparsedAddress": "273 King Street, Hamilton, On L8n 1b9" +"Coordinates": array:2 [ 0 => -79.85799398 1 => 43.25474794 ] +"Latitude": 43.25474794 +"Longitude": -79.85799398 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "T-ONE GROUP REALTY INC.," +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Excellent Investment Opportunity in Downtown Hamilton! Presently used as a Chinese restaurant, this well-maintained property offers the flexibility to be converted into a variety of other cuisines. It features a basement with 1 bedroom and 1 bathroom. Seating capacity: 60. Conveniently located close to all amenities, including schools, colleges, Mc Master University, Jackson Square, shopping stores, theaters, banks, and GO Station. The property is also just steps away from the bus station and nearby metered parking. With great pedestrian traffic, this is an ideal location for a business. Property for sale only." +"BuildingAreaUnits": "Square Feet" +"BusinessType": array:1 [ 0 => "Hospitality/Food Related" ] +"CityRegion": "Beasley" +"CoListOfficeName": "T-ONE GROUP REALTY INC.," +"CoListOfficePhone": "905-669-8881" +"Cooling": array:1 [ 0 => "Yes" ] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2025-04-23T01:18:42.926633+00:00" +"CrossStreet": "King St. E/Wellington St. N" +"Directions": "King St. E" +"ExpirationDate": "2025-10-20" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-04-20" +"LotSizeSource": "MPAC" +"MainOfficeKey": "360800" +"MajorChangeTimestamp": "2025-04-23T00:44:35Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2025-04-23T00:44:35Z" +"OriginalListPrice": 650000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2261774" +"ParcelNumber": "171680116" +"PhotosChangeTimestamp": "2025-07-08T19:13:58Z" +"SecurityFeatures": array:1 [ 0 => "Yes" ] +"ShowingRequirements": array:1 [ 0 => "See Brokerage Remarks" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "E" +"StreetName": "King" +"StreetNumber": "273" +"StreetSuffix": "Street" +"TaxAnnualAmount": "10485.0" +"TaxLegalDescription": "Plan 38 PT Lot 9" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2.5%" +"TransactionType": "For Sale" +"Utilities": array:1 [ 0 => "Available" ] +"Zoning": "D2" +"Water": "Municipal" +"FreestandingYN": true +"DDFYN": true +"LotType": "Unit" +"PropertyUse": "Retail" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"LotWidth": 20.0 +"HeatType": "Gas Forced Air Open" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12097471')" +"HSTApplication": array:1 [ 0 => "Included In" ] +"RollNumber": "251802018104060" +"DevelopmentChargesPaid": array:1 [ 0 => "Unknown" ] +"RetailArea": 1800.0 +"AssessmentYear": 2025 +"SystemModificationTimestamp": "2025-07-08T19:13:58.902027Z" +"provider_name": "TRREB" +"LotDepth": 100.0 +"PossessionDetails": "TBA" +"PermissionToContactListingBrokerToAdvertise": true +"GarageType": "None" +"PossessionType": "30-59 days" +"PriorMlsStatus": "Draft" +"MediaChangeTimestamp": "2025-07-08T19:13:58Z" +"TaxType": "Annual" +"HoldoverDays": 90 +"RetailAreaCode": "Sq Ft" +"Media": array:6 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] ] } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14601 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12199012" +"ListingId": "X12199012" +"PropertyType": "Residential" +"PropertySubType": "Att/Row/Townhouse" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-08T19:02:39Z" +"RFModificationTimestamp": "2025-07-08T19:40:23Z" +"ListPrice": 669000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L9G 3K9" +"UnparsedAddress": "10 Workman Lane, Hamilton, ON L9G 3K9" +"Coordinates": array:2 [ 0 => -79.9654193 1 => 43.2054412 ] +"Latitude": 43.2054412 +"Longitude": -79.9654193 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "REAL BROKER ONTARIO LTD." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Stunning townhouse in sought-after family friendly neighbourhood. Bright & functional floorbeautiful kitchen with quartz countertops, S/S appliances &breakfast bar. Open speciousbalcony. Large bedrooms on 3rd level. 2 parking spaces with ample visitor parking. Minutesplan offers large den on main floor, open concept living & dining room on 2nd floor andfrom HWY 403 with convenient access to shopping, schools & parks." +"ArchitecturalStyle": array:1 [ 0 => "3-Storey" ] +"Basement": array:1 [ 0 => "None" ] +"CityRegion": "Ancaster" +"ConstructionMaterials": array:2 [ 0 => "Brick" 1 => "Stone" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CountyOrParish": "Hamilton" +"CoveredSpaces": "1.0" +"CreationDate": "2025-06-05T16:38:30.890435+00:00" +"CrossStreet": "Garner Rd E to John Frederick Dr" +"DirectionFaces": "East" +"Directions": "Garner Rd E to John Frederick Dr" +"ExpirationDate": "2025-10-04" +"FoundationDetails": array:1 [ 0 => "Concrete" ] +"GarageYN": true +"Inclusions": "Fridge, Stove, B/I Microwave, Dishwasher, Washer & Dryer, Existing Window Coverings & Light Fixtures." +"InteriorFeatures": array:1 [ 0 => "Other" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-06-05" +"MainOfficeKey": "384000" +"MajorChangeTimestamp": "2025-06-05T16:38:40Z" +"MlsStatus": "Price Change" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-06-05T16:26:44Z" +"OriginalListPrice": 699000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2510136" +"ParkingFeatures": array:1 [ 0 => "Private" ] +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-07-08T19:02:39Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"PreviousListPrice": 700000.0 +"PriceChangeTimestamp": "2025-06-05T16:38:40Z" +"Roof": array:1 [ 0 => "Shingles" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:1 [ 0 => "Lockbox" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Workman" +"StreetNumber": "10" +"StreetSuffix": "Lane" +"TaxAnnualAmount": "5464.58" +"TaxLegalDescription": "PART BLOCK 1, PLAN 62M1245 DESIGNATED AS PART 66 ON 62R20824; TOGETHER WITH AN EASEMENT AS IN WE1173997 FOR THE BENEFIT OF PART BLOCK 1, PLAN 62M1245 DESIGNATED AS PART 66 ON 62R20824 TOGETHER WITH AN UNDIVIDED COMMON INTEREST IN WENTWORTH COMMON ELEMENTS" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2%" +"TransactionType": "For Sale" +"Water": "Municipal" +"RoomsAboveGrade": 7 +"KitchensAboveGrade": 1 +"WashroomsType1": 1 +"DDFYN": true +"WashroomsType2": 1 +"LivingAreaRange": "1100-1500" +"HeatSource": "Gas" +"ContractStatus": "Available" +"LotWidth": 27.4 +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12199012')" +"WashroomsType1Pcs": 2 +"WashroomsType1Level": "Second" +"HSTApplication": array:1 [ 0 => "Included In" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"SystemModificationTimestamp": "2025-07-08T19:02:40.992185Z" +"provider_name": "TRREB" +"LotDepth": 41.03 +"ParkingSpaces": 1 +"PermissionToContactListingBrokerToAdvertise": true +"BedroomsBelowGrade": 1 +"GarageType": "Attached" +"PossessionType": "Immediate" +"PriorMlsStatus": "New" +"WashroomsType2Level": "Third" +"BedroomsAboveGrade": 3 +"MediaChangeTimestamp": "2025-07-08T19:02:39Z" +"WashroomsType2Pcs": 4 +"DenFamilyroomYN": true +"SurveyType": "None" +"HoldoverDays": 90 +"KitchensTotal": 1 +"PossessionDate": "2025-06-05" +"Media": array:39 [ 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] ] } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14600 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12271239" +"ListingId": "X12271239" +"PropertyType": "Residential" +"PropertySubType": "Att/Row/Townhouse" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-08T19:00:16Z" +"RFModificationTimestamp": "2025-07-09T04:05:24Z" +"ListPrice": 599900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8E 0K6" +"UnparsedAddress": "#36 - 27 Rachel Drive, Hamilton, ON L8E 0K6" +"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": "Modern Freehold Townhome Steps from the Lake in Prime Stoney Creek! Welcome to 27 Rachel Drive, Unit 36an impeccably maintained 3-storey, 2-bedroom + loft freehold townhome built in 2022 offering the perfect blend of style, comfort, and convenience in the sought-after lakeside Community Beach neighbourhood. Enjoy 1,358 sq. ft. of thoughtfully designed living space with chic finishes throughout. The bright entryway features a versatile flex spaceideal for a home office, fitness area, or cozy reading nook. The main living level boasts 9-ft ceilings, sleek laminate flooring, and oversized windows that flood the open-concept space with natural light. The contemporary kitchen features upgraded stainless steel appliances, ample cabinetry, and a breakfast bar perfect for casual dining or entertaining. Flow seamlessly into the dining and living areas and step out to your own private balconyideal for morning coffee or evening relaxation. Upstairs, retreat to a spacious primary bedroom, a generously sized second bedroom, and a flexible loft space that works beautifully as a home office, study, or lounge. A stylish 4-piece bathroom and convenient bedroom-level laundry complete the upper floor. Just steps from the shores of Lake Ontario and minutes to Fifty Point Conservation Area, Costco, parks, and scenic trails, this location offers the best of outdoor living and everyday convenience. Commuters will love the quick access to the QEW, with easy drives to both Niagara and the GTA. Dont miss this incredible opportunity to own a modern, move-in ready townhome in one of Stoney Creeks most desirable and fastest-growing communities!" +"ArchitecturalStyle": array:1 [ 0 => "3-Storey" ] +"Basement": array:1 [ 0 => "None" ] +"CityRegion": "Stoney Creek" +"ConstructionMaterials": array:2 [ 0 => "Brick" 1 => "Vinyl Siding" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CountyOrParish": "Hamilton" +"CoveredSpaces": "1.0" +"CreationDate": "2025-07-08T19:05:26.313441+00:00" +"CrossStreet": "North Service Rd" +"DirectionFaces": "West" +"Directions": "North Service Rd to Rachel Dr" +"ExpirationDate": "2026-01-08" +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"GarageYN": true +"Inclusions": "FRIDGE, STOVE, DISHWASHER, OTR MICROWAVE, WASHER & DRYER" +"InteriorFeatures": array:1 [ 0 => "Water Heater" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-07-08" +"MainOfficeKey": "184000" +"MajorChangeTimestamp": "2025-07-08T19:00:16Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-07-08T19:00:16Z" +"OriginalListPrice": 599900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2681838" +"ParcelNumber": "173690862" +"ParkingFeatures": array:1 [ 0 => "Private" ] +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-07-08T19:00:16Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:3 [ 0 => "Lockbox" 1 => "Showing System" 2 => "List Brokerage" ] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Rachel" +"StreetNumber": "27" +"StreetSuffix": "Drive" +"TaxAnnualAmount": "3930.73" +"TaxLegalDescription": "PART BLOCK 1, PLAN 62M1283 PART 17, 62R21862 TOGETHER WITH AN UNDIVIDED COMMON INTEREST IN WENTWORTH COMMON ELEMENTS CONDOMINIUM CORPORATION NO. 624 SUBJECT TO AN EASEMENT IN GROSS AS IN WE1498736 SUBJECT TO AN EASEMENT IN GROSS AS IN WE1559284 SUBJECT TO AN EASEMENT AS IN WE1556006 SUBJECT TO AN EASEMENT IN GROSS AS IN WE1584416 SUBJECT TO AN EASEMENT AS IN WE1635133 CITY OF HAMILTON" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2%+HST" +"TransactionType": "For Sale" +"UnitNumber": "36" +"VirtualTourURLBranded": "https://www.youtube.com/watch?v=Ho Hv Hgd Jk Qg" +"VirtualTourURLUnbranded": "https://listings.northernsprucemedia.com/videos/0196da4b-0e65-71b0-b9ef-7ae2a64ca29c" +"Water": "Municipal" +"AdditionalMonthlyFee": 120.42 +"RoomsAboveGrade": 8 +"KitchensAboveGrade": 1 +"UnderContract": array:1 [ 0 => "Hot Water Heater" ] +"WashroomsType1": 1 +"DDFYN": true +"WashroomsType2": 1 +"LivingAreaRange": "1100-1500" +"HeatSource": "Gas" +"ContractStatus": "Available" +"PropertyFeatures": array:5 [ 0 => "Beach" 1 => "Lake/Pond" 2 => "Marina" 3 => "Park" 4 => "School" ] +"LotWidth": 21.17 +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12271239')" +"WashroomsType1Pcs": 2 +"WashroomsType1Level": "Second" +"HSTApplication": array:1 [ 0 => "Not Subject to HST" ] +"RollNumber": "251800301040234" +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"SystemModificationTimestamp": "2025-07-08T19:00:17.769846Z" +"provider_name": "TRREB" +"LotDepth": 41.68 +"ParkingSpaces": 1 +"PossessionDetails": "Flexible" +"ShowingAppointments": "905-592-7777" +"LotSizeRangeAcres": "< .50" +"GarageType": "Attached" +"ParcelOfTiedLand": "Yes" +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType2Level": "Third" +"BedroomsAboveGrade": 2 +"MediaChangeTimestamp": "2025-07-08T19:00:16Z" +"WashroomsType2Pcs": 4 +"RentalItems": "HOT WATER HEATER" +"SurveyType": "None" +"ApproximateAge": "0-5" +"HoldoverDays": 90 +"LaundryLevel": "Upper Level" +"KitchensTotal": 1 +"short_address": "Hamilton, ON L8E 0K6, CA" +"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] ] } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14599 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12267044" +"ListingId": "X12267044" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-08T18:56:20Z" +"RFModificationTimestamp": "2025-07-09T04:05:11Z" +"ListPrice": 849900.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 6.0 +"LotSizeArea": 0.12 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L9C 3K3" +"UnparsedAddress": "78 West 3rd Street, Hamilton, ON L9C 3K3" +"Coordinates": array:2 [ 0 => -79.8831145 1 => 43.233179 ] +"Latitude": 43.233179 +"Longitude": -79.8831145 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX ESCARPMENT REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Incredible opportunity for first time buyers or savvy investors looking to combine lifestyle with smart investing! This LEGAL DUPLEX in Hamiltons desirable West Mountain is just minutes from Mohawk College, shopping and all needed amenities and offers the perfect live-and-earn setup. The spacious main floor unit features a spacious living and dining room area, update kitchen, wide main floor laundry, 4 bedrooms and 2 full bathrooms, ideal for co-living, work-from-home setups, or growing families. The separate lower level, offers 2-bedroom, 1 bathroom and comes complete with its own private entrance, kitchen, laundry, and income potential, perfect to offset your mortgage or support multi-generational living. Move-in ready with updated finishes, and a rare double-length drive-through garage, that provides parking for multiple vehicles, storage, or a future workshop/studio. Nestled in Hamilton Mountain's prime location near Mohawk College, public transit, schools, shopping, hospitals, and commuter routes. Whether you're house hacking, building equity, or investing in your future, this property checks all the boxes for value, versatility, and long-term growth." +"ArchitecturalStyle": array:1 [ 0 => "1 1/2 Storey" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Separate Entrance" ] +"CityRegion": "Bonnington" +"ConstructionMaterials": array:2 [ 0 => "Vinyl Siding" 1 => "Brick" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CoveredSpaces": "2.0" +"CreationDate": "2025-07-07T14:32:37.534364+00:00" +"CrossStreet": "Mohawk Road" +"DirectionFaces": "North" +"Directions": "Between Mohawk Rd. W. & Fennell Ave W., west of Upper James" +"Exclusions": "Staging items nad tenants belongings" +"ExpirationDate": "2025-10-31" +"FoundationDetails": array:1 [ 0 => "Concrete Block" ] +"GarageYN": true +"Inclusions": "Main floor Dishwasher, Microwave, Refrigerator, Stove and Basement Dishwasher, Microwave, Refrigerator, Stove" +"InteriorFeatures": array:3 [ 0 => "Carpet Free" 1 => "In-Law Suite" 2 => "Primary Bedroom - Main Floor" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-07-07" +"LotSizeSource": "MPAC" +"MainOfficeKey": "184000" +"MajorChangeTimestamp": "2025-07-08T18:56:20Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2025-07-07T14:24:00Z" +"OriginalListPrice": 849900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2670534" +"ParcelNumber": "170260126" +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2025-07-07T14:24:00Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"PreviousListPrice": 8499000.0 +"PriceChangeTimestamp": "2025-07-07T20:18:12Z" +"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": "West 3rd" +"StreetNumber": "78" +"StreetSuffix": "Street" +"TaxAnnualAmount": "5482.0" +"TaxAssessedValue": 385000 +"TaxLegalDescription": "LT 278, PL 540. CITY OF HAMILTON" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2%" +"TransactionType": "For Sale" +"VirtualTourURLBranded": "https://youriguide.com/78_w_3rd_st_hamilton_on/" +"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/78_w_3rd_st_hamilton_on/" +"Water": "Municipal" +"RoomsAboveGrade": 7 +"KitchensAboveGrade": 1 +"WashroomsType1": 1 +"DDFYN": true +"WashroomsType2": 1 +"LivingAreaRange": "1100-1500" +"HeatSource": "Gas" +"ContractStatus": "Available" +"RoomsBelowGrade": 4 +"LotWidth": 50.0 +"HeatType": "Forced Air" +"WashroomsType3Pcs": 3 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12267044')" +"WashroomsType1Pcs": 4 +"WashroomsType1Level": "Ground" +"HSTApplication": array:1 [ 0 => "Included In" ] +"RollNumber": "251808092105780" +"SpecialDesignation": array:1 [ 0 => "Other" ] +"AssessmentYear": 2025 +"SystemModificationTimestamp": "2025-07-08T18:56:22.999378Z" +"provider_name": "TRREB" +"KitchensBelowGrade": 1 +"LotDepth": 105.75 +"ParkingSpaces": 2 +"PossessionDetails": "IMMEDIATE" +"PermissionToContactListingBrokerToAdvertise": true +"ShowingAppointments": "Book on Broker Bay" +"LotSizeRangeAcres": "< .50" +"BedroomsBelowGrade": 2 +"GarageType": "Attached" +"PossessionType": "Flexible" +"PriorMlsStatus": "Price Change" +"WashroomsType2Level": "Second" +"BedroomsAboveGrade": 4 +"MediaChangeTimestamp": "2025-07-07T16:04:29Z" +"WashroomsType2Pcs": 3 +"SurveyType": "None" +"HoldoverDays": 30 +"WashroomsType3": 1 +"WashroomsType3Level": "Basement" +"KitchensTotal": 2 +"PossessionDate": "2025-08-01" +"Media": array:32 [ 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] ] } ] +success: true +page_size: 10 +page_count: 411 +count: 4105 +after_key: "" } ] ]
