4048 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: e25bda84b2fbe00e70a627fcb5640dea046ef0261370308e40446472e503f7bc" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#14711 +items: array:10 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14873 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12119700" +"ListingId": "X12119700" +"PropertyType": "Residential Lease" +"PropertySubType": "Multiplex" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-05-07T20:14:07Z" +"RFModificationTimestamp": "2025-05-07T21:44:29Z" +"ListPrice": 1895.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0.23 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8L 3W6" +"UnparsedAddress": "#4 - 164 Picton Street, Hamilton, On L8l 3w6" +"Coordinates": array:2 [ 0 => -79.8657401 1 => 43.2703192 ] +"Latitude": 43.2703192 +"Longitude": -79.8657401 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Keller Williams Signature Realty, Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Newly Renovated: Modern finishes and stylish upgrades throughout.Spacious Living Room: Large windows bring in plenty of natural light.Beautiful Large Deck: Overlooks a stunning backyard with great landscaping.Big Storage Closet: Ample space to keep your belongings organized.Great Location: Close to shops, parks, and everyday essentials.This charming apartment offers a perfect blend of comfort and convenience in a fantastic location. Ideal for professionals, couples, or small families looking for a stylish and well-maintained home." +"ArchitecturalStyle": array:1 [ 0 => "1 Storey/Apt" ] +"Basement": array:1 [ 0 => "None" ] +"CityRegion": "North End" +"ConstructionMaterials": array:1 [ 0 => "Wood" ] +"Cooling": array:1 [ 0 => "Wall Unit(s)" ] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2025-05-02T18:20:47.114847+00:00" +"CrossStreet": "Picton St E & Ferguson Ave N" +"DirectionFaces": "South" +"Directions": "Picton St E & Ferguson Ave N" +"ExpirationDate": "2025-10-31" +"FoundationDetails": array:1 [ 0 => "Concrete" ] +"Furnished": "Unfurnished" +"InteriorFeatures": array:1 [ 0 => "None" ] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "In-Suite Laundry" ] +"LeaseTerm": "12 Months" +"ListAOR": "Oakville, Milton & District Real Estate Board" +"ListingContractDate": "2025-05-02" +"LotSizeSource": "MPAC" +"MainOfficeKey": "534800" +"MajorChangeTimestamp": "2025-05-02T15:17:35Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-05-02T15:17:35Z" +"OriginalListPrice": 1895.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2322852" +"ParcelNumber": "171570186" +"ParkingFeatures": array:1 [ 0 => "Street Only" ] +"PhotosChangeTimestamp": "2025-05-02T15:17:35Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"RentIncludes": array:2 [ 0 => "Central Air Conditioning" 1 => "Exterior Maintenance" ] +"Roof": array:1 [ 0 => "Shingles" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "E" +"StreetName": "Picton" +"StreetNumber": "164" +"StreetSuffix": "Street" +"TransactionBrokerCompensation": "1/2 Months Rent" +"TransactionType": "For Lease" +"UnitNumber": "4" +"Water": "Municipal" +"RoomsAboveGrade": 4 +"KitchensAboveGrade": 1 +"RentalApplicationYN": true +"WashroomsType1": 1 +"DDFYN": true +"LivingAreaRange": "< 700" +"HeatSource": "Other" +"ContractStatus": "Available" +"PortionPropertyLease": array:1 [ 0 => "Entire Property" ] +"LotWidth": 62.0 +"HeatType": "Other" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12119700')" +"WashroomsType1Pcs": 4 +"RollNumber": "251802016208490" +"DepositRequired": true +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"SystemModificationTimestamp": "2025-05-07T20:14:08.866412Z" +"provider_name": "TRREB" +"LotDepth": 159.0 +"PossessionDetails": "Immediate" +"LeaseAgreementYN": true +"CreditCheckYN": true +"EmploymentLetterYN": true +"GarageType": "None" +"PossessionType": "Immediate" +"PrivateEntranceYN": true +"PriorMlsStatus": "Draft" +"BedroomsAboveGrade": 2 +"MediaChangeTimestamp": "2025-05-02T15:17:35Z" +"SurveyType": "None" +"HoldoverDays": 60 +"ReferencesRequiredYN": true +"KitchensTotal": 1 +"Media": array:12 [ 0 => array:26 [ "ResourceRecordKey" => "X12119700" "MediaModificationTimestamp" => "2025-05-02T15:17:35.450102Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12119700/thumbnail-491826c1f1dcff8472158d4ab2c19f2a.webp" "ShortDescription" => null "MediaKey" => "d1005d9b-4b05-43e7-bd8b-ca7cd430f742" "ImageWidth" => 1617 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-05-02T15:17:35.450102Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "d1005d9b-4b05-43e7-bd8b-ca7cd430f742" "Order" => 0 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12119700/491826c1f1dcff8472158d4ab2c19f2a.webp" "MediaSize" => 412318 "SourceSystemMediaKey" => "d1005d9b-4b05-43e7-bd8b-ca7cd430f742" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => true "LongDescription" => null "ImageHeight" => 1080 ] 1 => array:26 [ "ResourceRecordKey" => "X12119700" "MediaModificationTimestamp" => "2025-05-02T15:17:35.450102Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12119700/thumbnail-e87e4497c8da8fdf53eb787257e1a2c3.webp" "ShortDescription" => null "MediaKey" => "dc837a18-e617-4be1-ac31-0119fc29e4fc" "ImageWidth" => 1617 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-05-02T15:17:35.450102Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "dc837a18-e617-4be1-ac31-0119fc29e4fc" "Order" => 1 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12119700/e87e4497c8da8fdf53eb787257e1a2c3.webp" "MediaSize" => 471332 "SourceSystemMediaKey" => "dc837a18-e617-4be1-ac31-0119fc29e4fc" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 1080 ] 2 => array:26 [ "ResourceRecordKey" => "X12119700" "MediaModificationTimestamp" => "2025-05-02T15:17:35.450102Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12119700/thumbnail-ecfc9909c7b0c250eb05015b34ac593a.webp" "ShortDescription" => null "MediaKey" => "51b3795e-9e96-44e0-a044-32c63086cfad" "ImageWidth" => 1617 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-05-02T15:17:35.450102Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "51b3795e-9e96-44e0-a044-32c63086cfad" "Order" => 2 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12119700/ecfc9909c7b0c250eb05015b34ac593a.webp" "MediaSize" => 145452 "SourceSystemMediaKey" => "51b3795e-9e96-44e0-a044-32c63086cfad" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 1080 ] 3 => array:26 [ "ResourceRecordKey" => "X12119700" "MediaModificationTimestamp" => "2025-05-02T15:17:35.450102Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12119700/thumbnail-c8aab7363d1531765e9c7d2f6f60c60c.webp" "ShortDescription" => null "MediaKey" => "edb42ce3-1ca4-49a7-9967-b1eccd819db6" "ImageWidth" => 1617 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-05-02T15:17:35.450102Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "edb42ce3-1ca4-49a7-9967-b1eccd819db6" "Order" => 3 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12119700/c8aab7363d1531765e9c7d2f6f60c60c.webp" "MediaSize" => 153206 "SourceSystemMediaKey" => "edb42ce3-1ca4-49a7-9967-b1eccd819db6" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 1080 ] 4 => array:26 [ "ResourceRecordKey" => "X12119700" "MediaModificationTimestamp" => "2025-05-02T15:17:35.450102Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12119700/thumbnail-de509e54beeca6cedc7caedfcd24bbe9.webp" "ShortDescription" => null "MediaKey" => "b8fb384a-854e-40b7-92fe-0a0f27138a79" "ImageWidth" => 1617 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-05-02T15:17:35.450102Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "b8fb384a-854e-40b7-92fe-0a0f27138a79" "Order" => 4 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12119700/de509e54beeca6cedc7caedfcd24bbe9.webp" "MediaSize" => 136405 "SourceSystemMediaKey" => "b8fb384a-854e-40b7-92fe-0a0f27138a79" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 1080 ] 5 => array:26 [ "ResourceRecordKey" => "X12119700" "MediaModificationTimestamp" => "2025-05-02T15:17:35.450102Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12119700/thumbnail-e7f4d04d27f9ee742f731524670f6db6.webp" "ShortDescription" => null "MediaKey" => "e9bef02a-8b18-4d44-bf20-e85464644277" "ImageWidth" => 1617 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-05-02T15:17:35.450102Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "e9bef02a-8b18-4d44-bf20-e85464644277" "Order" => 5 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12119700/e7f4d04d27f9ee742f731524670f6db6.webp" "MediaSize" => 145472 "SourceSystemMediaKey" => "e9bef02a-8b18-4d44-bf20-e85464644277" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 1080 ] 6 => array:26 [ "ResourceRecordKey" => "X12119700" "MediaModificationTimestamp" => "2025-05-02T15:17:35.450102Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12119700/thumbnail-4f192e2541df2ff2cd57104e88dbcaf9.webp" "ShortDescription" => null "MediaKey" => "a87bba1a-8ed9-4bc7-9d6b-3d5d3efb39d1" "ImageWidth" => 1617 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-05-02T15:17:35.450102Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "a87bba1a-8ed9-4bc7-9d6b-3d5d3efb39d1" "Order" => 6 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12119700/4f192e2541df2ff2cd57104e88dbcaf9.webp" "MediaSize" => 79499 "SourceSystemMediaKey" => "a87bba1a-8ed9-4bc7-9d6b-3d5d3efb39d1" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 1080 ] 7 => array:26 [ "ResourceRecordKey" => "X12119700" "MediaModificationTimestamp" => "2025-05-02T15:17:35.450102Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12119700/thumbnail-11fef9a3bc4e86395e17e9bedc057578.webp" "ShortDescription" => null "MediaKey" => "ba798adb-e2c0-4915-a940-67336a7ea92d" "ImageWidth" => 1617 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-05-02T15:17:35.450102Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "ba798adb-e2c0-4915-a940-67336a7ea92d" "Order" => 7 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12119700/11fef9a3bc4e86395e17e9bedc057578.webp" "MediaSize" => 112870 "SourceSystemMediaKey" => "ba798adb-e2c0-4915-a940-67336a7ea92d" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 1080 ] 8 => array:26 [ "ResourceRecordKey" => "X12119700" "MediaModificationTimestamp" => "2025-05-02T15:17:35.450102Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12119700/thumbnail-3c214d80422a3ace2a81987688a3c2be.webp" "ShortDescription" => null "MediaKey" => "2b5d7d67-40e3-4f0e-852f-fe79091cd971" "ImageWidth" => 1617 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-05-02T15:17:35.450102Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "2b5d7d67-40e3-4f0e-852f-fe79091cd971" "Order" => 8 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12119700/3c214d80422a3ace2a81987688a3c2be.webp" "MediaSize" => 81554 "SourceSystemMediaKey" => "2b5d7d67-40e3-4f0e-852f-fe79091cd971" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 1080 ] 9 => array:26 [ "ResourceRecordKey" => "X12119700" "MediaModificationTimestamp" => "2025-05-02T15:17:35.450102Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12119700/thumbnail-f626597be932572412646a30a807a7c3.webp" "ShortDescription" => null "MediaKey" => "7c789f7a-0750-43de-bece-857d7ba9c828" "ImageWidth" => 1617 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-05-02T15:17:35.450102Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "7c789f7a-0750-43de-bece-857d7ba9c828" "Order" => 9 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12119700/f626597be932572412646a30a807a7c3.webp" "MediaSize" => 89706 "SourceSystemMediaKey" => "7c789f7a-0750-43de-bece-857d7ba9c828" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 1080 ] 10 => array:26 [ "ResourceRecordKey" => "X12119700" "MediaModificationTimestamp" => "2025-05-02T15:17:35.450102Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12119700/thumbnail-e3b76f759336fbee229209f5014a0128.webp" "ShortDescription" => null "MediaKey" => "7bfd5c50-f132-4325-8a17-c0e35f82a7bc" "ImageWidth" => 1617 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-05-02T15:17:35.450102Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "7bfd5c50-f132-4325-8a17-c0e35f82a7bc" "Order" => 10 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12119700/e3b76f759336fbee229209f5014a0128.webp" "MediaSize" => 106828 "SourceSystemMediaKey" => "7bfd5c50-f132-4325-8a17-c0e35f82a7bc" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 1080 ] 11 => array:26 [ "ResourceRecordKey" => "X12119700" "MediaModificationTimestamp" => "2025-05-02T15:17:35.450102Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12119700/thumbnail-637e3caca473951d1a45269f55dbcbba.webp" "ShortDescription" => null "MediaKey" => "9b6ff702-8453-4538-b794-badbda73fe67" "ImageWidth" => 3840 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-05-02T15:17:35.450102Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "9b6ff702-8453-4538-b794-badbda73fe67" "Order" => 11 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12119700/637e3caca473951d1a45269f55dbcbba.webp" "MediaSize" => 2071165 "SourceSystemMediaKey" => "9b6ff702-8453-4538-b794-badbda73fe67" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 2564 ] ] } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14874 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12131620" +"ListingId": "X12131620" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-05-07T19:20:17Z" +"RFModificationTimestamp": "2025-05-07T22:28:56Z" +"ListPrice": 1199990.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L9H 5E2" +"UnparsedAddress": "195 Hwy 5, Hamilton, On L9h 5e2" +"Coordinates": array:2 [ 0 => -79.8728583 1 => 43.2560802 ] +"Latitude": 43.2560802 +"Longitude": -79.8728583 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX PROFESSIONALS INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome home! This custom built (2015) 3 bedroom A-Frame home has many thoughtful upgrades, including in-floor heating throughout (natural gas), ICF foundation, and much more! It is nestled on a beautiful tree lined, half acre property on the outskirts of the highly desired Waterdown community. A welcoming and bright foyer leads you to the open concept living/dining and kitchen areas. Boasting vaulted ceilings, a gas fireplace and a breath taking two story wall of windows looking on to never to be developed green space. Move through the back hallway to a 4 piece bathroom flanked by your second and third bedrooms or office. Upstairs you will find an extra large private primary bedroom with ensuite 3piece bath and convenient access to laundry. The wrap around stone patio, covered composite deck off of the kitchen, and impeccably landscaped and easy to maintain property, adds additional living and entertaining space to this well designed home. The newly built (2023) garage fits two cars, or all your toys. Private driveway with parking for 15 cars, and close to all amenities that Waterdown has to offer." +"ArchitecturalStyle": array:1 [ 0 => "2-Storey" ] +"Basement": array:1 [ 0 => "Full" ] +"CityRegion": "Rural Flamborough" +"ConstructionMaterials": array:2 [ 0 => "Stone" 1 => "Wood" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CountyOrParish": "Hamilton" +"CoveredSpaces": "2.0" +"CreationDate": "2025-05-07T22:17:09.243242+00:00" +"CrossStreet": "Dundas/HWY6" +"DirectionFaces": "North" +"Directions": "Dundas/HWY6" +"Exclusions": "Decorative propeller above patio doors, all televisions." +"ExpirationDate": "2025-12-31" +"FireplaceYN": true +"FoundationDetails": array:1 [ 0 => "Insulated Concrete Form" ] +"GarageYN": true +"Inclusions": "Fridge, stove, exhaust fan, dishwasher, B/I microwave, washer and dryer." +"InteriorFeatures": array:1 [ 0 => "None" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-05-07" +"MainOfficeKey": "474000" +"MajorChangeTimestamp": "2025-05-07T19:17:02Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-05-07T19:17:02Z" +"OriginalListPrice": 1199990.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2353710" +"ParcelNumber": "175470025" +"ParkingFeatures": array:1 [ 0 => "Private" ] +"ParkingTotal": "17.0" +"PhotosChangeTimestamp": "2025-05-07T19:17:02Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"Sewer": array:1 [ 0 => "Septic" ] +"ShowingRequirements": array:1 [ 0 => "Lockbox" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "W" +"StreetName": "Hwy 5" +"StreetNumber": "195" +"StreetSuffix": "N/A" +"TaxAnnualAmount": "5937.18" +"TaxLegalDescription": "SEE REMARKS" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2%" +"TransactionType": "For Sale" +"Water": "Well" +"RoomsAboveGrade": 9 +"KitchensAboveGrade": 1 +"WashroomsType1": 1 +"DDFYN": true +"WashroomsType2": 1 +"LivingAreaRange": "1500-2000" +"HeatSource": "Gas" +"ContractStatus": "Available" +"LotWidth": 100.19 +"HeatType": "Radiant" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12131620')" +"WashroomsType1Pcs": 4 +"HSTApplication": array:1 [ 0 => "Included In" ] +"RollNumber": "251830233065800" +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"SystemModificationTimestamp": "2025-05-07T19:20:19.989195Z" +"provider_name": "TRREB" +"LotDepth": 150.29 +"ParkingSpaces": 15 +"LotSizeRangeAcres": ".50-1.99" +"GarageType": "Detached" +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"BedroomsAboveGrade": 3 +"MediaChangeTimestamp": "2025-05-07T19:17:02Z" +"WashroomsType2Pcs": 3 +"DenFamilyroomYN": true +"SurveyType": "None" +"HoldoverDays": 60 +"KitchensTotal": 1 +"PossessionDate": "2025-07-31" +"short_address": "Hamilton, ON L9H 5E2, CA" +"Media": array:34 [ 0 => array:26 [ "ResourceRecordKey" => "X12131620" "MediaModificationTimestamp" => "2025-05-07T19:17:02.284975Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12131620/thumbnail-1ff4ea96887083c52acfc3ac8fd1dbc2.webp" "ShortDescription" => null "MediaKey" => "cd47ae3f-f32e-4228-a083-3cba9813e3bf" "ImageWidth" => 3840 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-05-07T19:17:02.284975Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "cd47ae3f-f32e-4228-a083-3cba9813e3bf" "Order" => 0 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12131620/1ff4ea96887083c52acfc3ac8fd1dbc2.webp" "MediaSize" => 1827979 "SourceSystemMediaKey" => "cd47ae3f-f32e-4228-a083-3cba9813e3bf" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => true "LongDescription" => null "ImageHeight" => 2558 ] 1 => array:26 [ "ResourceRecordKey" => "X12131620" "MediaModificationTimestamp" => "2025-05-07T19:17:02.284975Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12131620/thumbnail-ee61f26943ed06c94d8a15af434acf15.webp" "ShortDescription" => null "MediaKey" => "d7c42c59-cc81-485d-a4f0-87a26353b9d6" "ImageWidth" => 3840 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-05-07T19:17:02.284975Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "d7c42c59-cc81-485d-a4f0-87a26353b9d6" "Order" => 1 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12131620/ee61f26943ed06c94d8a15af434acf15.webp" "MediaSize" => 1835789 "SourceSystemMediaKey" => "d7c42c59-cc81-485d-a4f0-87a26353b9d6" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 2557 ] 2 => array:26 [ "ResourceRecordKey" => "X12131620" "MediaModificationTimestamp" => "2025-05-07T19:17:02.284975Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12131620/thumbnail-a5f4083eb28ff5ee58276af77ac04f35.webp" "ShortDescription" => null "MediaKey" => "914d0b57-a9b2-4a10-bacb-fbb22a7adf34" "ImageWidth" => 3840 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-05-07T19:17:02.284975Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "914d0b57-a9b2-4a10-bacb-fbb22a7adf34" "Order" => 2 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12131620/a5f4083eb28ff5ee58276af77ac04f35.webp" "MediaSize" => 3274366 "SourceSystemMediaKey" => "914d0b57-a9b2-4a10-bacb-fbb22a7adf34" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 2557 ] 3 => array:26 [ "ResourceRecordKey" => "X12131620" "MediaModificationTimestamp" => "2025-05-07T19:17:02.284975Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12131620/thumbnail-c37b9e9dd64945b1f2b706e4c8ccb613.webp" "ShortDescription" => null "MediaKey" => "c643ec89-9ae1-451a-bb57-d1fc74fe5d0d" "ImageWidth" => 3840 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-05-07T19:17:02.284975Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "c643ec89-9ae1-451a-bb57-d1fc74fe5d0d" "Order" => 3 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12131620/c37b9e9dd64945b1f2b706e4c8ccb613.webp" "MediaSize" => 2169327 "SourceSystemMediaKey" => "c643ec89-9ae1-451a-bb57-d1fc74fe5d0d" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 2557 ] 4 => array:26 [ "ResourceRecordKey" => "X12131620" "MediaModificationTimestamp" => "2025-05-07T19:17:02.284975Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12131620/thumbnail-8e071b7ca284b4e3a85f89b2f1485fc1.webp" "ShortDescription" => null "MediaKey" => "525e787a-522d-4efb-bf06-6538519080c7" "ImageWidth" => 3840 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-05-07T19:17:02.284975Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "525e787a-522d-4efb-bf06-6538519080c7" "Order" => 4 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12131620/8e071b7ca284b4e3a85f89b2f1485fc1.webp" "MediaSize" => 1425200 "SourceSystemMediaKey" => "525e787a-522d-4efb-bf06-6538519080c7" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 2557 ] 5 => array:26 [ "ResourceRecordKey" => "X12131620" "MediaModificationTimestamp" => "2025-05-07T19:17:02.284975Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12131620/thumbnail-db64ba030273f21bf2ecba6572faae07.webp" "ShortDescription" => null "MediaKey" => "70fc5649-5669-4ac4-972e-13094edaf923" "ImageWidth" => 3840 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-05-07T19:17:02.284975Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "70fc5649-5669-4ac4-972e-13094edaf923" "Order" => 5 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12131620/db64ba030273f21bf2ecba6572faae07.webp" "MediaSize" => 1298841 "SourceSystemMediaKey" => "70fc5649-5669-4ac4-972e-13094edaf923" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 2557 ] 6 => array:26 [ "ResourceRecordKey" => "X12131620" "MediaModificationTimestamp" => "2025-05-07T19:17:02.284975Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12131620/thumbnail-b53ab8657ce73d51d97db195469329bb.webp" "ShortDescription" => null "MediaKey" => "a8e6e46c-0faf-435c-a3e1-92e496d6ab32" "ImageWidth" => 3840 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-05-07T19:17:02.284975Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "a8e6e46c-0faf-435c-a3e1-92e496d6ab32" "Order" => 6 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12131620/b53ab8657ce73d51d97db195469329bb.webp" "MediaSize" => 1423043 "SourceSystemMediaKey" => "a8e6e46c-0faf-435c-a3e1-92e496d6ab32" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 2557 ] 7 => array:26 [ "ResourceRecordKey" => "X12131620" "MediaModificationTimestamp" => "2025-05-07T19:17:02.284975Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12131620/thumbnail-d8fc623eb5e3d32266ab7d618f221325.webp" "ShortDescription" => null "MediaKey" => "25fd44c0-45eb-4617-ae45-f24fbc8e96a0" "ImageWidth" => 3840 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-05-07T19:17:02.284975Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "25fd44c0-45eb-4617-ae45-f24fbc8e96a0" "Order" => 7 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12131620/d8fc623eb5e3d32266ab7d618f221325.webp" "MediaSize" => 1225318 "SourceSystemMediaKey" => "25fd44c0-45eb-4617-ae45-f24fbc8e96a0" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 2557 ] 8 => array:26 [ "ResourceRecordKey" => "X12131620" "MediaModificationTimestamp" => "2025-05-07T19:17:02.284975Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12131620/thumbnail-237856bf747558fb2f4f51a82cad0ff1.webp" "ShortDescription" => null "MediaKey" => "943671ea-d9f1-4483-a8b6-d5819fab036f" "ImageWidth" => 3840 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-05-07T19:17:02.284975Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "943671ea-d9f1-4483-a8b6-d5819fab036f" "Order" => 8 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12131620/237856bf747558fb2f4f51a82cad0ff1.webp" "MediaSize" => 977765 "SourceSystemMediaKey" => "943671ea-d9f1-4483-a8b6-d5819fab036f" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 2557 ] 9 => array:26 [ "ResourceRecordKey" => "X12131620" "MediaModificationTimestamp" => "2025-05-07T19:17:02.284975Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12131620/thumbnail-946a7dbaf9504c06f2e69934c17a79c4.webp" "ShortDescription" => null "MediaKey" => "85c50f34-d221-46fd-82e5-f4248ff07ba5" "ImageWidth" => 3840 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-05-07T19:17:02.284975Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "85c50f34-d221-46fd-82e5-f4248ff07ba5" "Order" => 9 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12131620/946a7dbaf9504c06f2e69934c17a79c4.webp" "MediaSize" => 1446629 "SourceSystemMediaKey" => "85c50f34-d221-46fd-82e5-f4248ff07ba5" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 2557 ] 10 => array:26 [ "ResourceRecordKey" => "X12131620" "MediaModificationTimestamp" => "2025-05-07T19:17:02.284975Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12131620/thumbnail-e3b3b415604831095c9347d5fa388499.webp" "ShortDescription" => null "MediaKey" => "77ed7a40-bda4-4f6b-a071-4860a06aa595" "ImageWidth" => 3840 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-05-07T19:17:02.284975Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "77ed7a40-bda4-4f6b-a071-4860a06aa595" "Order" => 10 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12131620/e3b3b415604831095c9347d5fa388499.webp" "MediaSize" => 788259 "SourceSystemMediaKey" => "77ed7a40-bda4-4f6b-a071-4860a06aa595" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 2557 ] 11 => array:26 [ "ResourceRecordKey" => "X12131620" "MediaModificationTimestamp" => "2025-05-07T19:17:02.284975Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12131620/thumbnail-5217796ca7b8e735d138f2edd4447709.webp" "ShortDescription" => null "MediaKey" => "bb3445e8-e061-4797-8e9c-14e6b736a74e" "ImageWidth" => 3840 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-05-07T19:17:02.284975Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "bb3445e8-e061-4797-8e9c-14e6b736a74e" "Order" => 11 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12131620/5217796ca7b8e735d138f2edd4447709.webp" "MediaSize" => 729665 "SourceSystemMediaKey" => "bb3445e8-e061-4797-8e9c-14e6b736a74e" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 2557 ] 12 => array:26 [ "ResourceRecordKey" => "X12131620" "MediaModificationTimestamp" => "2025-05-07T19:17:02.284975Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12131620/thumbnail-49ddd3d4beb6486b9fa97794d2805a66.webp" "ShortDescription" => null "MediaKey" => "4c5ffad1-4131-40ee-8c49-32b7a4f94e5c" "ImageWidth" => 3840 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-05-07T19:17:02.284975Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "4c5ffad1-4131-40ee-8c49-32b7a4f94e5c" "Order" => 12 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12131620/49ddd3d4beb6486b9fa97794d2805a66.webp" "MediaSize" => 769559 "SourceSystemMediaKey" => "4c5ffad1-4131-40ee-8c49-32b7a4f94e5c" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 2557 ] 13 => array:26 [ "ResourceRecordKey" => "X12131620" "MediaModificationTimestamp" => "2025-05-07T19:17:02.284975Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12131620/thumbnail-f2eaa30889ee0da06266c11b8ece79a1.webp" "ShortDescription" => null "MediaKey" => "af37f911-33c9-41ba-a2de-40fc495f88a4" "ImageWidth" => 3840 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-05-07T19:17:02.284975Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "af37f911-33c9-41ba-a2de-40fc495f88a4" "Order" => 13 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12131620/f2eaa30889ee0da06266c11b8ece79a1.webp" "MediaSize" => 1189017 "SourceSystemMediaKey" => "af37f911-33c9-41ba-a2de-40fc495f88a4" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 2557 ] 14 => array:26 [ "ResourceRecordKey" => "X12131620" "MediaModificationTimestamp" => "2025-05-07T19:17:02.284975Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12131620/thumbnail-c384e4e049da1fe38c62d1bb36217273.webp" "ShortDescription" => null "MediaKey" => "38787ff1-faba-4405-86de-90e2e415ed5b" "ImageWidth" => 3840 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-05-07T19:17:02.284975Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "38787ff1-faba-4405-86de-90e2e415ed5b" "Order" => 14 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12131620/c384e4e049da1fe38c62d1bb36217273.webp" "MediaSize" => 900657 "SourceSystemMediaKey" => "38787ff1-faba-4405-86de-90e2e415ed5b" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 2557 ] 15 => array:26 [ "ResourceRecordKey" => "X12131620" "MediaModificationTimestamp" => "2025-05-07T19:17:02.284975Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12131620/thumbnail-ea60e858201637ff54a05bb7fe584ed6.webp" "ShortDescription" => null "MediaKey" => "a13e07fb-9bce-45b1-80b8-dc97dbd8257f" "ImageWidth" => 1900 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-05-07T19:17:02.284975Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "a13e07fb-9bce-45b1-80b8-dc97dbd8257f" "Order" => 15 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12131620/ea60e858201637ff54a05bb7fe584ed6.webp" "MediaSize" => 319706 "SourceSystemMediaKey" => "a13e07fb-9bce-45b1-80b8-dc97dbd8257f" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 1265 ] 16 => array:26 [ "ResourceRecordKey" => "X12131620" "MediaModificationTimestamp" => "2025-05-07T19:17:02.284975Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12131620/thumbnail-0541f25477660f0e6ad99b3fa2b8677d.webp" "ShortDescription" => null "MediaKey" => "4a0381f7-01f4-41fb-9f44-c0bb7d00e6b9" "ImageWidth" => 1900 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-05-07T19:17:02.284975Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "4a0381f7-01f4-41fb-9f44-c0bb7d00e6b9" "Order" => 16 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12131620/0541f25477660f0e6ad99b3fa2b8677d.webp" "MediaSize" => 261123 "SourceSystemMediaKey" => "4a0381f7-01f4-41fb-9f44-c0bb7d00e6b9" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 1265 ] 17 => array:26 [ "ResourceRecordKey" => "X12131620" "MediaModificationTimestamp" => "2025-05-07T19:17:02.284975Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12131620/thumbnail-15333e11c8f365b155e586ea38acf586.webp" "ShortDescription" => null "MediaKey" => "c000ea85-5a35-404b-9d23-281f3c95fd39" "ImageWidth" => 1900 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-05-07T19:17:02.284975Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "c000ea85-5a35-404b-9d23-281f3c95fd39" "Order" => 17 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12131620/15333e11c8f365b155e586ea38acf586.webp" "MediaSize" => 247943 "SourceSystemMediaKey" => "c000ea85-5a35-404b-9d23-281f3c95fd39" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 1265 ] 18 => array:26 [ "ResourceRecordKey" => "X12131620" "MediaModificationTimestamp" => "2025-05-07T19:17:02.284975Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12131620/thumbnail-67243bd0834b9c2d8f67627d8d70087c.webp" "ShortDescription" => null "MediaKey" => "af87ac60-2f1c-4bd4-8440-76ab9de6ff19" "ImageWidth" => 1900 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-05-07T19:17:02.284975Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "af87ac60-2f1c-4bd4-8440-76ab9de6ff19" "Order" => 18 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12131620/67243bd0834b9c2d8f67627d8d70087c.webp" "MediaSize" => 285923 "SourceSystemMediaKey" => "af87ac60-2f1c-4bd4-8440-76ab9de6ff19" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 1265 ] 19 => array:26 [ "ResourceRecordKey" => "X12131620" "MediaModificationTimestamp" => "2025-05-07T19:17:02.284975Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12131620/thumbnail-5d7ded1640e0033e34f79412d33dd3ff.webp" "ShortDescription" => null "MediaKey" => "d70c180f-1864-46e8-a210-2787bf54000d" "ImageWidth" => 1920 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-05-07T19:17:02.284975Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "d70c180f-1864-46e8-a210-2787bf54000d" "Order" => 19 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12131620/5d7ded1640e0033e34f79412d33dd3ff.webp" "MediaSize" => 369902 "SourceSystemMediaKey" => "d70c180f-1864-46e8-a210-2787bf54000d" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null …1 ] 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] ] } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14880 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12130970" +"ListingId": "X12130970" +"PropertyType": "Residential" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-05-07T18:42:17Z" +"RFModificationTimestamp": "2025-05-07T18:51:59Z" +"ListPrice": 589000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8E 5B4" +"UnparsedAddress": "#1202 - 461 Green Road, Hamilton, On L8e 5b4" +"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": "ASSIGNMENT SALE UNDER CONSTRUCTION JANUARY 2026 OCCUPANCY Introducing the SKY floorplan at Muse Lakeview Condominiums in Stoney Creek. Situated on the coveted penthouse level, this stylish 1-bedroom, 1-bathroom suite offers 663 sq. ft. of interior living space plus a rare 259 sq. ft. private terrace - perfect for outdoor entertaining. This upgraded unit boasts soaring 11 ceilings, luxury vinyl plank flooring throughout, quartz countertops in both the kitchen and bathroom, a premium 7-piece stainless steel appliance package, upgraded 100 cm upper cabinetry, and in-suite laundry. The spacious primary bedroom features a walk-in closet. Included are one underground parking space and one storage locker. Residents enjoy access to a range of art-inspired amenities including a 6th-floor BBQ terrace, chefs kitchen lounge, art studio, media room, pet spa, and more. Smart home features include app-based climate control, digital building access, energy tracking, and enhanced security. Just steps from the future GO Station, Confederation Park, Van Wagners Beach, scenic trails, shopping, dining, and major highways." +"ArchitecturalStyle": array:1 [ 0 => "Apartment" ] +"AssociationFee": "198.9" +"AssociationFeeIncludes": array:2 [ 0 => "Common Elements Included" 1 => "Building Insurance Included" ] +"Basement": array:1 [ 0 => "None" ] +"BuildingName": "Muse Condominiums" +"CityRegion": "Stoney Creek" +"ConstructionMaterials": array:2 [ 0 => "Brick" 1 => "Stucco (Plaster)" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CountyOrParish": "Hamilton" +"CoveredSpaces": "1.0" +"CreationDate": "2025-05-07T17:00:20.211392+00:00" +"CrossStreet": "North Service Rd to Green Rd" +"Directions": "North Service Rd to Green Rd" +"ExpirationDate": "2025-08-31" +"ExteriorFeatures": array:7 [ 0 => "Awnings" 1 => "Built-In-BBQ" 2 => "Controlled Entry" 3 => "Landscape Lighting" 4 => "Landscaped" 5 => "Lighting" 6 => "Patio" ] +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Inclusions": "Stainless steel 30" fridge, 30" dishwasher, 30" cooktop & range, white stackable washer/dryer, OTR Microwave" +"InteriorFeatures": array:1 [ 0 => "Other" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "In-Suite Laundry" ] +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-05-07" +"MainOfficeKey": "184000" +"MajorChangeTimestamp": "2025-05-07T16:49:49Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-05-07T16:49:49Z" +"OriginalListPrice": 589000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2351960" +"ParcelNumber": "173300568" +"ParkingFeatures": array:1 [ 0 => "Private" ] +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ 0 => "Restricted" ] +"PhotosChangeTimestamp": "2025-05-07T18:42:17Z" +"Roof": array:1 [ 0 => "Flat" ] +"ShowingRequirements": array:1 [ 0 => "See Brokerage Remarks" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Green" +"StreetNumber": "461" +"StreetSuffix": "Road" +"TaxYear": "2024" +"Topography": array:1 [ 0 => "Flat" ] +"TransactionBrokerCompensation": "2% + HST" +"TransactionType": "For Sale" +"UnitNumber": "1202" +"View": array:2 [ 0 => "Bay" 1 => "Beach" ] +"Zoning": "C3" +"RoomsAboveGrade": 5 +"PropertyManagementCompany": "TBD" +"Locker": "Owned" +"KitchensAboveGrade": 1 +"WashroomsType1": 1 +"DDFYN": true +"LivingAreaRange": "600-699" +"HeatSource": "Electric" +"ContractStatus": "Available" +"LockerUnit": "TBD" +"PropertyFeatures": array:6 [ 0 => "Beach" 1 => "Clear View" 2 => "Electric Car Charger" 3 => "Golf" 4 => "Hospital" 5 => "Lake Access" ] +"HeatType": "Heat Pump" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12130970')" +"WashroomsType1Pcs": 4 +"WashroomsType1Level": "Main" +"HSTApplication": array:1 [ 0 => "Included In" ] +"RollNumber": "251800304550000" +"LegalApartmentNumber": "1202" +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"SystemModificationTimestamp": "2025-05-07T18:42:19.280486Z" +"provider_name": "TRREB" +"ParkingSpaces": 1 +"LegalStories": "12" +"PossessionDetails": "TO BE BUILT" +"ParkingType1": "Owned" +"LockerLevel": "TBD" +"ShowingAppointments": "905-592-7777" +"LockerNumber": "TBD" +"GarageType": "Underground" +"BalconyType": "Enclosed" +"PossessionType": "Other" +"Exposure": "West" +"PriorMlsStatus": "Draft" +"LeaseToOwnEquipment": array:1 [ 0 => "Other" ] +"BedroomsAboveGrade": 1 +"SquareFootSource": "Builder Floor Plan" +"MediaChangeTimestamp": "2025-05-07T18:42:17Z" +"RentalItems": "Other" +"SurveyType": "None" +"ApproximateAge": "New" +"ParkingLevelUnit1": "TBD" +"HoldoverDays": 30 +"EnsuiteLaundryYN": true +"ParkingSpot1": "TBD" +"KitchensTotal": 1 +"Media": array:10 [ 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] ] } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14877 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12130028" +"ListingId": "X12130028" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-05-07T17:39:57Z" +"RFModificationTimestamp": "2025-05-07T18:51:59Z" +"ListPrice": 3998000.0 +"BathroomsTotalInteger": 7.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8B 1H8" +"UnparsedAddress": "102 Concession 11, Hamilton, On L8b 1h8" +"Coordinates": array:2 [ 0 => -80.0253426 1 => 43.4068297 ] +"Latitude": 43.4068297 +"Longitude": -80.0253426 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "KELLER WILLIAMS REAL ESTATE ASSOCIATES" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Renovated Bungalow W/ Walk-Out Basement Features 4+1 Beds & 7 Baths & Parking for 12+ Cars. The Grand Entry Greets You W/ Vaulted 11ft Ceilings, Premium Vinyl Flooring, & Pot Lights Throughout The Main Level.The Open-Concept Dining Room & Chefs Kitchen Boast An Oversized Sit-Up Island, Quartz Countertops, Top-Tier B/I S/S Appliances, A W/I Pantry, & A Coffee Bar. The Formal Living Room, Create A Cozy Space For Family Gatherings. The Family Room Features Vaulted Ceilings, Floor-To-Ceiling Windows & A Gas Fireplace.The Primary Suite Offers A W/I Closet & A 5-Piece Ensuite, Dbl Vanity, & Glass Shower. 3 Well-Appointed Beds W/Their Own Ensuites. A Main Level Mudroom W/Laundry Area & Garage Access, Completes The Main Level. The Lower Level Featuring 8ft Ceilings, Above-Grade Windows, Pot Lights, & B/I Speakers. The Rec Room Provides Ample Space For Entertaining Friends & Family W/ A Wet Bar. An Additional Bedroom & Office Make A Great Space For Guests Or Th. An Oversized Flex Space Offers A Great Playroom W/ Ample Storage & A 4pc Bathroom. Head Outside To The Custom-Built Pergola W/ Wired-In Heaters, Pot Lights, B/I Speakers, &A Ceiling Fan, Perfect For Summer Dinners Overlooking The Resort-Style Backyard. It Is A True Entertainers Dream, Featuring An Inground Saltwater Pool W/ A Waterslide, A Putting Green, & A Custom-Built Cabana W/Outdoor Kitchen & Wood-Burning Fireplace. The Expansive 2500 Sqft Detached Garage/Shop Features A Man Cave, 3-pc Bathroom, & Ample Storage. Ideal For Those Who Cherish Tranquility & A Slower Pace Of Life, This Property Is Protected By Partial Conservation Land, Providing A Serene Setting And Unparalleled Privacy. With Trails, Farms, And Conservation Areas, It's A Haven For Nature Lovers And Outdoor Enthusiasts. With Easy Access To Major Highways, This Is A True Dream Home Within Close Proximity To All Necessities And Amenities A like." +"ArchitecturalStyle": array:1 [ 0 => "Bungalow" ] +"Basement": array:1 [ 0 => "Finished with Walk-Out" ] +"CityRegion": "Rural Flamborough" +"CoListOfficeName": "KELLER WILLIAMS REAL ESTATE ASSOCIATES" +"CoListOfficePhone": "905-812-8123" +"ConstructionMaterials": array:2 [ 0 => "Stone" 1 => "Wood" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CountyOrParish": "Hamilton" +"CoveredSpaces": "2.0" +"CreationDate": "2025-05-07T14:16:49.074451+00:00" +"CrossStreet": "Hwy 6 & Concession 11 E" +"DirectionFaces": "North" +"Directions": "Hwy 6 & Concession 11 E" +"Exclusions": "Removable Fence Around Pool (Negotiable), Pool Table (Negotiable), Shelving In Furnace Room, All Tv's & Wall Mounts, Fridge & Freezer In Garage, Chest Freezer In Basement, Safe." +"ExpirationDate": "2025-09-30" +"ExteriorFeatures": array:2 [ 0 => "Porch" 1 => "Landscaped" ] +"FireplaceFeatures": array:3 [ 0 => "Family Room" 1 => "Other" 2 => "Rec Room" ] +"FireplaceYN": true +"FireplacesTotal": "3" +"FoundationDetails": array:1 [ 0 => "Unknown" ] +"GarageYN": true +"Inclusions": "All ELF'S,Window Coverings,Automatic Blinds(Primary, Family Room,2nd Bedroom & Dining Room), All B/I Appliances, Washer & Dryer(LG),B/I BBQ, Pool Slide, All Pool & Hot Tub Equipment, Play Structure, Exterior Cameras (unmonitored), Outdoor Heaters." +"InteriorFeatures": array:6 [ 0 => "Auto Garage Door Remote" 1 => "Central Vacuum" 2 => "Primary Bedroom - Main Floor" 3 => "Water Softener" 4 => "Water Purifier" 5 => "Sump Pump" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-05-07" +"MainOfficeKey": "101200" +"MajorChangeTimestamp": "2025-05-07T17:39:57Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-05-07T14:02:34Z" +"OriginalListPrice": 3998000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2334676" +"OtherStructures": array:1 [ 0 => "Workshop" ] +"ParcelNumber": "175240019" +"ParkingFeatures": array:3 [ 0 => "Private Double" 1 => "Private" 2 => "Circular Drive" ] +"ParkingTotal": "14.0" +"PhotosChangeTimestamp": "2025-05-07T14:02:34Z" +"PoolFeatures": array:2 [ 0 => "Inground" 1 => "Salt" ] +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"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" +"StreetDirSuffix": "E" +"StreetName": "Concession 11" +"StreetNumber": "102" +"StreetSuffix": "N/A" +"TaxAnnualAmount": "11108.26" +"TaxLegalDescription": "PCL 3-1, SEC 62M754 ; LT 3, PL 62M754 ; FLAMBOROUGH CITY OF HAMILTON" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2" +"TransactionType": "For Sale" +"VirtualTourURLUnbranded": "https://fresh-approach-listings.webflow.io/listing/102-concession-11-e-2-unbranded" +"Zoning": "P6,P7" +"Water": "Well" +"RoomsAboveGrade": 9 +"DDFYN": true +"LivingAreaRange": "3500-5000" +"HeatSource": "Propane" +"RoomsBelowGrade": 4 +"Waterfront": array:1 [ 0 => "None" ] +"PropertyFeatures": array:3 [ 0 => "Wooded/Treed" 1 => "Golf" 2 => "Greenbelt/Conservation" ] +"LotWidth": 278.97 +"WashroomsType3Pcs": 2 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12130028')" +"WashroomsType1Level": "Main" +"LotDepth": 624.31 +"BedroomsBelowGrade": 1 +"PossessionType": "Other" +"PriorMlsStatus": "Extension" +"LaundryLevel": "Main Level" +"WashroomsType3Level": "Main" +"CentralVacuumYN": true +"KitchensAboveGrade": 1 +"WashroomsType1": 2 +"WashroomsType2": 1 +"ExtensionEntryTimestamp": "2025-05-07T14:34:28Z" +"ContractStatus": "Available" +"WashroomsType4Pcs": 5 +"HeatType": "Forced Air" +"WashroomsType4Level": "Main" +"WashroomsType1Pcs": 3 +"HSTApplication": array:1 [ 0 => "Included In" ] +"RollNumber": "251830393036750" +"DevelopmentChargesPaid": array:1 [ 0 => "Unknown" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"SystemModificationTimestamp": "2025-05-07T17:39:59.916627Z" +"provider_name": "TRREB" +"ParkingSpaces": 12 +"PossessionDetails": "TBD" +"LotSizeRangeAcres": "2-4.99" +"GarageType": "Attached" +"WashroomsType5Level": "Basement" +"WashroomsType5Pcs": 3 +"WashroomsType2Level": "Main" +"BedroomsAboveGrade": 4 +"MediaChangeTimestamp": "2025-05-07T14:02:34Z" +"WashroomsType2Pcs": 4 +"DenFamilyroomYN": true +"SurveyType": "None" +"ApproximateAge": "16-30" +"HoldoverDays": 60 +"WashroomsType5": 2 +"WashroomsType3": 1 +"WashroomsType4": 1 +"KitchensTotal": 1 +"Media": array:36 [ 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] ] } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14872 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12130717" +"ListingId": "X12130717" +"PropertyType": "Commercial Lease" +"PropertySubType": "Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-05-07T16:01:55Z" +"RFModificationTimestamp": "2025-05-07T18:51:59Z" +"ListPrice": 1600.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 3500.0 +"City": "Hamilton" +"PostalCode": "L8E 2L8" +"UnparsedAddress": "#yard - 200 Arvin Avenue, Hamilton, On L8e 2l8" +"Coordinates": array:2 [ 0 => -79.8728583 1 => 43.2560802 ] +"Latitude": 43.2560802 +"Longitude": -79.8728583 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "NORTH 2 SOUTH REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Versatile yard space available at approximately 3,500 sq ft (85 ft x 40 ft). Ideal for storage containers, bus or commercial vehicle parking, construction material storage, landscaping equipment, and other clean outdoor uses. Flat and accessible lot with easy access for large vehicles. Centrally located in Stoney Creek with quick access to major roads and highways. Perfect for businesses in need of flexible outdoor space." +"BuildingAreaUnits": "Square Feet" +"CityRegion": "Stoney Creek" +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2025-05-07T16:20:24.256346+00:00" +"CrossStreet": "Grays Rd & Arvin Ave" +"Directions": "Grays Rd & Arvin Ave" +"ExpirationDate": "2025-08-31" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-05-07" +"LotDimensionsSource": "Other" +"LotSizeDimensions": "160.00 x 291.00 Feet" +"MainOfficeKey": "428700" +"MajorChangeTimestamp": "2025-05-07T16:01:55Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-05-07T16:01:55Z" +"OriginalListPrice": 1600.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2316540" +"PhotosChangeTimestamp": "2025-05-07T16:01:55Z" +"Sewer": array:1 [ 0 => "None" ] +"ShowingRequirements": array:2 [ 0 => "Showing System" 1 => "List Salesperson" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Arvin" +"StreetNumber": "200" +"StreetSuffix": "Avenue" +"TaxLegalDescription": "Pt Lt 22, Con 1 Saltfleet , Parts 3, 4 & 5 , 62R51" +"TaxYear": "2025" +"TransactionBrokerCompensation": "Half Months Rent + HST" +"TransactionType": "For Lease" +"UnitNumber": "YARD" +"Utilities": array:1 [ 0 => "None" ] +"Zoning": "M2" +"Water": "None" +"FreestandingYN": true +"DDFYN": true +"LotType": "Lot" +"PropertyUse": "Designated" +"ContractStatus": "Available" +"ListPriceUnit": "Gross Lease" +"HeatType": "None" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12130717')" +"MinimumRentalTermMonths": 6 +"SystemModificationTimestamp": "2025-05-07T16:01:56.837787Z" +"provider_name": "TRREB" +"PossessionDetails": "TBD" +"MaximumRentalMonthsTerm": 60 +"PermissionToContactListingBrokerToAdvertise": true +"OutsideStorageYN": true +"GarageType": "None" +"PossessionType": "Immediate" +"PriorMlsStatus": "Draft" +"PictureYN": true +"MediaChangeTimestamp": "2025-05-07T16:01:55Z" +"TaxType": "N/A" +"BoardPropertyType": "Com" +"HoldoverDays": 90 +"StreetSuffixCode": "Ave" +"MLSAreaDistrictOldZone": "X14" +"MLSAreaMunicipalityDistrict": "Hamilton" +"PossessionDate": "2025-05-07" +"short_address": "Hamilton, ON L8E 2L8, CA" +"Media": array:4 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] ] } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14851 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12130051" +"ListingId": "X12130051" +"PropertyType": "Residential" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-05-07T14:14:50Z" +"RFModificationTimestamp": "2025-05-07T18:51:59Z" +"ListPrice": 362800.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8R 0A8" +"UnparsedAddress": "#607 - 1 Jarvis Street, Hamilton, On L8r 0a8" +"Coordinates": array:2 [ 0 => -79.8728583 1 => 43.2560802 ] +"Latitude": 43.2560802 +"Longitude": -79.8728583 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "HC REALTY GROUP INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Do Not Miss Your Chance To Move Into This Stylish, Bright & Functional 1-Bedroom Condo, In The Heart Of Downtown Hamilton! Thoughtfully Designed Layout With No Wasted Space. Floor-To-Ceiling Windows Bring In Tons Of Natural Light. Modern Kitchen With Quartz Countertops, Stainless Steel Appliances. Spacious Bedroom With Walk-In Closet. Spacious Private Balcony. Stunning Building With 24Hr Concierge, Gym & Co-Working Lounge. Close to HWYs, Steps To Transit, Shops, Restaurants, & More. A Perfect Blend Of Urban Living & Comfort. Youll Fall In Love With This Home!" +"ArchitecturalStyle": array:1 [ 0 => "Apartment" ] +"AssociationAmenities": array:3 [ 0 => "Concierge" 1 => "Gym" 2 => "Visitor Parking" ] +"AssociationFee": "322.98" +"AssociationFeeIncludes": array:2 [ 0 => "Building Insurance Included" 1 => "Common Elements Included" ] +"Basement": array:1 [ 0 => "None" ] +"CityRegion": "Beasley" +"ConstructionMaterials": array:2 [ 0 => "Brick" 1 => "Concrete" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CountyOrParish": "Hamilton" +"CreationDate": "2025-05-07T14:41:10.115451+00:00" +"CrossStreet": "King Street E (HWY8) / Jarvis Street" +"Directions": "King Street E (HWY8) / Jarvis Street" +"ExpirationDate": "2025-09-01" +"Inclusions": "All Existing Window Coverings, Light Fixtures, Washer & Dryer. Fridge, Cooktop, Range Hood, Oven, Dishwasher, Microwave." +"InteriorFeatures": array:2 [ 0 => "Carpet Free" 1 => "Built-In Oven" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "In-Suite Laundry" ] +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-05-07" +"MainOfficeKey": "367200" +"MajorChangeTimestamp": "2025-05-07T14:06:40Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2025-05-07T14:06:40Z" +"OriginalListPrice": 362800.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2350092" +"ParkingFeatures": array:1 [ 0 => "None" ] +"PetsAllowed": array:1 [ 0 => "Restricted" ] +"PhotosChangeTimestamp": "2025-05-07T14:06:40Z" +"ShowingRequirements": array:1 [ 0 => "Lockbox" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Jarvis" +"StreetNumber": "1" +"StreetSuffix": "Street" +"TaxAnnualAmount": "4500.0" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2.5% + Hst" +"TransactionType": "For Sale" +"UnitNumber": "607" +"RoomsAboveGrade": 2 +"PropertyManagementCompany": "First Service Residential" +"Locker": "None" +"KitchensAboveGrade": 1 +"WashroomsType1": 1 +"DDFYN": true +"LivingAreaRange": "0-499" +"HeatSource": "Gas" +"ContractStatus": "Available" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12130051')" +"WashroomsType1Pcs": 3 +"WashroomsType1Level": "Flat" +"HSTApplication": array:1 [ 0 => "Included In" ] +"LegalApartmentNumber": "7" +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"SystemModificationTimestamp": "2025-05-07T14:14:51.285685Z" +"provider_name": "TRREB" +"LegalStories": "6" +"PossessionDetails": "Flexible" +"ParkingType1": "None" +"PermissionToContactListingBrokerToAdvertise": true +"GarageType": "None" +"BalconyType": "Open" +"PossessionType": "Flexible" +"Exposure": "South" +"PriorMlsStatus": "Draft" +"BedroomsAboveGrade": 1 +"SquareFootSource": "Builder" +"MediaChangeTimestamp": "2025-05-07T14:06:40Z" +"SurveyType": "Boundary Only" +"ApproximateAge": "0-5" +"HoldoverDays": 30 +"CondoCorpNumber": 655 +"EnsuiteLaundryYN": true +"KitchensTotal": 1 +"short_address": "Hamilton, ON L8R 0A8, CA" +"Media": array:19 [ 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] ] } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14850 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12129216" +"ListingId": "X12129216" +"PropertyType": "Residential" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-05-07T01:07:37Z" +"RFModificationTimestamp": "2025-05-07T06:24:37Z" +"ListPrice": 449990.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8N 0B3" +"UnparsedAddress": "#305 - 467 Charlton Avenue, Hamilton, On L8n 0b3" +"Coordinates": array:2 [ 0 => -79.8728583 1 => 43.2560802 ] +"Latitude": 43.2560802 +"Longitude": -79.8728583 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX REAL ESTATE CENTRE INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Attention investors & first time buyers . Welcome to Unit 305 at the sought after and beautifully designed Vista Condos on Charlton .This two bedroom, two bathroom unit offers a spacious & modern open-concept layout with one of the best views in the city. Fantastic Location! On bus route, close to St Josephs Healthcare, schools and shopping. Third Floor Unit with stunning views of Hamilton and waterfront. Stylish building complete with Gym, Meeting Room, Communal Space with BBQ and outdoor seating, abundance of visitor parking. Parking spot 67 and locker 9 are owned with the unit. Living space feature 2 bedroom (one has movable walls for alternate use), 2 bathroom and quartz countertops. Quiet living in a great central location. The unit also includes a large underground parking space and storage locker. Complex amenities include party room, gym, visitor parking and access to communal terrace with BBQs. Amazing location, close to 3 major hospitals, public transit, shopping, dining, rail trail and Wentworth Escarpment stairs. Summer or winter, enjoy the Escarpment trees view and feel at the top of the world!" +"ArchitecturalStyle": array:1 [ 0 => "Apartment" ] +"AssociationAmenities": array:4 [ 0 => "Bike Storage" 1 => "Gym" 2 => "Party Room/Meeting Room" 3 => "Visitor Parking" ] +"AssociationFee": "661.78" +"AssociationFeeIncludes": array:6 [ 0 => "Heat Included" 1 => "Water Included" 2 => "CAC Included" 3 => "Common Elements Included" 4 => "Building Insurance Included" 5 => "Parking Included" ] +"Basement": array:1 [ 0 => "None" ] +"CityRegion": "Stinson" +"CoListOfficeName": "RE/MAX REAL ESTATE CENTRE INC." +"CoListOfficePhone": "905-456-1177" +"ConstructionMaterials": array:2 [ 0 => "Concrete" 1 => "Stone" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CountyOrParish": "Hamilton" +"CoveredSpaces": "1.0" +"CreationDate": "2025-05-07T04:30:19.296165+00:00" +"CrossStreet": "JUST WEST OF WENTWORTH N" +"Directions": "From downtown Hamilton, take Wentworth St South eastward until you reach Charlton Avenue East. Turn right onto Charlton Ave E and drive for about 300 meters until you center building at 467 Charlton E." +"ExpirationDate": "2025-12-31" +"Inclusions": "Built-in Microwave,Fridge, Stove, Washer, Dryer, Dishwasher." +"InteriorFeatures": array:1 [ 0 => "Other" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "In-Suite Laundry" ] +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-05-06" +"MainOfficeKey": "079800" +"MajorChangeTimestamp": "2025-05-07T01:07:37Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2025-05-07T01:07:37Z" +"OriginalListPrice": 449990.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2335140" +"ParkingFeatures": array:1 [ 0 => "Underground" ] +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ 0 => "Restricted" ] +"PhotosChangeTimestamp": "2025-05-07T01:07:37Z" +"ShowingRequirements": array:1 [ 0 => "Lockbox" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "E" +"StreetName": "CHARLTON" +"StreetNumber": "467" +"StreetSuffix": "Avenue" +"TaxAnnualAmount": "4303.0" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2.5%+H.S.T" +"TransactionType": "For Sale" +"UnitNumber": "305" +"VirtualTourURLUnbranded": "https://www.myvisuallistings.com/vtnb/355799" +"RoomsAboveGrade": 4 +"PropertyManagementCompany": "PROPERTY MANAGEMENT GUILD / 905-575-3636" +"Locker": "Ensuite+Owned" +"KitchensAboveGrade": 1 +"WashroomsType1": 1 +"DDFYN": true +"WashroomsType2": 1 +"LivingAreaRange": "700-799" +"HeatSource": "Gas" +"ContractStatus": "Available" +"PropertyFeatures": array:4 [ 0 => "Clear View" 1 => "Hospital" 2 => "Place Of Worship" 3 => "Public Transit" ] +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12129216')" +"WashroomsType1Pcs": 3 +"WashroomsType1Level": "Flat" +"HSTApplication": array:1 [ 0 => "Included In" ] +"LegalApartmentNumber": "15" +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"SystemModificationTimestamp": "2025-05-07T01:07:39.12357Z" +"provider_name": "TRREB" +"LegalStories": "3" +"PossessionDetails": "60" +"ParkingType1": "Owned" +"PermissionToContactListingBrokerToAdvertise": true +"GarageType": "Underground" +"BalconyType": "Open" +"PossessionType": "Flexible" +"Exposure": "North" +"PriorMlsStatus": "Draft" +"WashroomsType2Level": "Flat" +"BedroomsAboveGrade": 2 +"SquareFootSource": "796" +"MediaChangeTimestamp": "2025-05-07T01:07:37Z" +"WashroomsType2Pcs": 4 +"SurveyType": "None" +"ApproximateAge": "0-5" +"HoldoverDays": 90 +"CondoCorpNumber": 599 +"LaundryLevel": "Main Level" +"EnsuiteLaundryYN": true +"ParkingSpot1": "67" +"KitchensTotal": 1 +"short_address": "Hamilton, ON L8N 0B3, 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] ] } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14849 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12125397" +"ListingId": "X12125397" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-05-06T18:58:21Z" +"RFModificationTimestamp": "2025-05-06T23:08:03Z" +"ListPrice": 849900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8W 3V2" +"UnparsedAddress": "741 Acadia Drive, Hamilton, On L8w 3v2" +"Coordinates": array:2 [ 0 => -79.8710448 1 => 43.1989829 ] +"Latitude": 43.1989829 +"Longitude": -79.8710448 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE STATE REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome Home!Step into comfort and style with this beautifully updated residence, featuring modern finishes and family-friendly functionality. Featuring gorgeous quartz countertops in both the kitchen and main floor bathroom, this home boasts a freshly painted interior and laminate flooring that flows seamlessly through the spacious living room, dining area, and main floor primary bedroom.Upstairs, you'll find two generously sized bedrooms and one full bath, perfect for family or guests, while the mostly finished basement includes a versatile den that easily serves as a fourth bedroom, office, or home gym. The open-concept layout offers both warmth and flexibility for everyday living or entertaining.Enjoy the outdoors with a two-tiered deck, fully fenced yard, and the potential to design your own dream backyard oasisideal for summer gatherings or quiet relaxation. Attached single car garage with side entrance into home provides comfort living year round. Situated in a prime location, this home is within walking distance to schools, and just minutes from shopping, parks, highway access and other local amenitiesperfect for growing families or those seeking both convenience and charm.Dont miss the opportunity to own this move-in ready gem. Your next chapter starts here!" +"ArchitecturalStyle": array:1 [ 0 => "1 1/2 Storey" ] +"Basement": array:2 [ 0 => "Full" 1 => "Partially Finished" ] +"CityRegion": "Butler" +"CoListOfficeName": "ROYAL LEPAGE STATE REALTY" +"CoListOfficePhone": "905-574-4600" +"ConstructionMaterials": array:2 [ 0 => "Aluminum Siding" 1 => "Brick" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CoveredSpaces": "1.0" +"CreationDate": "2025-05-05T21:55:20.952430+00:00" +"CrossStreet": "Elite Drive" +"DirectionFaces": "West" +"Directions": "Upper Wentworth Street to Elite Drive, Right onto Acadia Drive" +"ExpirationDate": "2025-08-15" +"ExteriorFeatures": array:2 [ 0 => "Deck" 1 => "Privacy" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ 0 => "Concrete" ] +"GarageYN": true +"InteriorFeatures": array:2 [ 0 => "Auto Garage Door Remote" 1 => "Water Heater Owned" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-05-05" +"MainOfficeKey": "288000" +"MajorChangeTimestamp": "2025-05-05T19:25:34Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-05-05T19:25:34Z" +"OriginalListPrice": 849900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2335618" +"ParcelNumber": "169200298" +"ParkingFeatures": array:1 [ 0 => "Private" ] +"ParkingTotal": "3.0" +"PhotosChangeTimestamp": "2025-05-05T19:25:35Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:3 [ 0 => "Lockbox" 1 => "List Brokerage" 2 => "List Salesperson" ] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Acadia" +"StreetNumber": "741" +"StreetSuffix": "Drive" +"TaxAnnualAmount": "4869.78" +"TaxAssessedValue": 342000 +"TaxLegalDescription": "PCL 6-1, SEC 62M743 ; LT 6, PL 62M743 , T/W PT LT 7, PT 6, 62R12795 AS IN LT354344 & S/T PT 5, 62R12795 IN FAVOUR OF LT 5 AS IN LT354344 ; S/T LT351694 HAMILTON" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2% + HST" +"TransactionType": "For Sale" +"VirtualTourURLBranded": "https://view.spiro.media/741_acadia_dr-097" +"VirtualTourURLUnbranded": "https://view.spiro.media/741_acadia_dr-097?branding=false" +"VirtualTourURLUnbranded2": "https://youriguide.com/xn2pg_741_acadia_dr_hamilton_on/" +"Zoning": "R-4" +"Water": "Municipal" +"RoomsAboveGrade": 6 +"KitchensAboveGrade": 1 +"WashroomsType1": 1 +"DDFYN": true +"WashroomsType2": 1 +"LivingAreaRange": "1100-1500" +"HeatSource": "Gas" +"ContractStatus": "Available" +"RoomsBelowGrade": 2 +"PropertyFeatures": array:5 [ 0 => "Park" 1 => "Place Of Worship" 2 => "Public Transit" 3 => "Rec./Commun.Centre" 4 => "School" ] +"LotWidth": 31.35 +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12125397')" +"WashroomsType1Pcs": 4 +"WashroomsType1Level": "Main" +"HSTApplication": array:1 [ 0 => "Included In" ] +"RollNumber": "251807075108496" +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"AssessmentYear": 2024 +"SystemModificationTimestamp": "2025-05-06T18:58:23.459672Z" +"provider_name": "TRREB" +"LotDepth": 99.9 +"ParkingSpaces": 2 +"PossessionDetails": "Flexible" +"ShowingAppointments": "LBO/Brokerbay" +"GarageType": "Attached" +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType2Level": "Second" +"BedroomsAboveGrade": 3 +"MediaChangeTimestamp": "2025-05-05T19:25:35Z" +"WashroomsType2Pcs": 4 +"SurveyType": "Unknown" +"ApproximateAge": "16-30" +"HoldoverDays": 90 +"KitchensTotal": 1 +"Media": array:38 [ 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] ] } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14848 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X11977790" +"ListingId": "X11977790" +"PropertyType": "Residential Lease" +"PropertySubType": "Semi-Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-05-06T18:31:42Z" +"RFModificationTimestamp": "2025-05-06T19:16:59Z" +"ListPrice": 5500.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8B 1Z4" +"UnparsedAddress": "38 Silver Meadow Gardens, Hamilton, On L8b 1z4" +"Coordinates": array:2 [ 0 => -79.873193 1 => 43.341245 ] +"Latitude": 43.341245 +"Longitude": -79.873193 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "REAL CITY REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Stunning Fully Furnished Semi-Detached Home for Lease in Mountainview Heights, Waterdown. Welcome to this beautifully appointed, fully furnished semi-detached home in the desirable new community of Mountainview Heights, Waterdown. Nestled on a premium lot, this brand-new home is being offered for lease for the very first time an exceptional opportunity you won't want to miss. Offering approximately 2,000 sq ft of thoughtfully designed living space, this 4-bedroom, 4-bathroom residence showcases a spacious open-concept layout, 9-foot ceilings on both the main and upper levels. . The main level features elegant hardwood stairs, stylish coffered ceilings, and a bright living area with an electric fireplace. Enjoy the convenience of main-floor laundry with direct access to the garage. Upstairs, you are welcomed by a generous landing area leading to four spacious, fully furnished bedrooms and three full bathrooms, ideal for families or guests seeking comfort and privacy. Additional Features Include: Modern light fixtures and upgraded finishes High-efficiency HVAC system3-car parking (1-car garage + 2-car driveway) Smart home features including a doorbell camera and driveway security camera Perfectly located just minutes from the scenic Bruce Trail and Great Falls, and offering quick access to Aldershot GO Station, QEW, 407, local restaurants, parks, shopping, and more." +"AccessibilityFeatures": array:1 [ 0 => "Open Floor Plan" ] +"ArchitecturalStyle": array:1 [ 0 => "2-Storey" ] +"Basement": array:1 [ 0 => "Unfinished" ] +"CityRegion": "Waterdown" +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CountyOrParish": "Hamilton" +"CoveredSpaces": "1.0" +"CreationDate": "2025-02-19T05:22:25.707112+00:00" +"CrossStreet": "Dundas Street E/Skinner Rd" +"DirectionFaces": "North" +"Directions": "Dundas St E/Skinner Rd" +"ExpirationDate": "2025-12-31" +"ExteriorFeatures": array:1 [ 0 => "Deck" ] +"FireplaceFeatures": array:1 [ 0 => "Electric" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Furnished": "Unfurnished" +"GarageYN": true +"InteriorFeatures": array:1 [ 0 => "Primary Bedroom - Main Floor" ] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "In Building" ] +"LeaseTerm": "Short Term Lease" +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-02-18" +"MainOfficeKey": "264100" +"MajorChangeTimestamp": "2025-05-06T18:31:42Z" +"MlsStatus": "Price Change" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-02-19T03:14:54Z" +"OriginalListPrice": 6000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft1989090" +"ParkingFeatures": array:1 [ 0 => "Available" ] +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-02-19T03:14:54Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"PreviousListPrice": 4500.0 +"PriceChangeTimestamp": "2025-05-06T18:31:41Z" +"RentIncludes": array:1 [ 0 => "All Inclusive" ] +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:2 [ 0 => "Lockbox" 1 => "List Salesperson" ] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Silver Meadow" +"StreetNumber": "38" +"StreetSuffix": "Gardens" +"TransactionBrokerCompensation": "1/2 Month Rent Plus HST" +"TransactionType": "For Lease" +"Water": "Municipal" +"RoomsAboveGrade": 7 +"KitchensAboveGrade": 1 +"WashroomsType1": 1 +"DDFYN": true +"WashroomsType2": 2 +"LivingAreaRange": "1500-2000" +"GasYNA": "No" +"CableYNA": "Yes" +"HeatSource": "Gas" +"ContractStatus": "Available" +"WaterYNA": "No" +"Waterfront": array:1 [ 0 => "None" ] +"PortionPropertyLease": array:2 [ 0 => "Main" 1 => "2nd Floor" ] +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X11977790')" +"WashroomsType1Pcs": 2 +"WashroomsType1Level": "Main" +"SpecialDesignation": array:1 [ 0 => "Other" ] +"TelephoneYNA": "No" +"SystemModificationTimestamp": "2025-05-06T18:31:43.73675Z" +"provider_name": "TRREB" +"ParkingSpaces": 1 +"PossessionDetails": "Immediate" +"PermissionToContactListingBrokerToAdvertise": true +"GarageType": "Built-In" +"ParcelOfTiedLand": "No" +"PaymentFrequency": "Monthly" +"PossessionType": "Immediate" +"ElectricYNA": "No" +"PriorMlsStatus": "New" +"WashroomsType2Level": "Second" +"BedroomsAboveGrade": 4 +"MediaChangeTimestamp": "2025-02-19T03:14:54Z" +"WashroomsType2Pcs": 4 +"SurveyType": "None" +"ApproximateAge": "0-5" +"UFFI": "No" +"HoldoverDays": 90 +"LaundryLevel": "Main Level" +"SewerYNA": "Yes" +"PaymentMethod": "Direct Withdrawal" +"KitchensTotal": 1 +"PossessionDate": "2025-02-18" +"Media": array:41 [ 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] ] } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14847 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12122616" +"ListingId": "X12122616" +"PropertyType": "Commercial Sale" +"PropertySubType": "Commercial Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-05-06T14:52:00Z" +"RFModificationTimestamp": "2025-05-07T05:30:23Z" +"ListPrice": 179900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0.15 +"LivingArea": 0 +"BuildingAreaTotal": 1180.0 +"City": "Hamilton" +"PostalCode": "L9A 3P9" +"UnparsedAddress": "570 Upper Wellington Street, Hamilton, On L9a 3p9" +"Coordinates": array:2 [ 0 => -79.8667481 1 => 43.2389066 ] +"Latitude": 43.2389066 +"Longitude": -79.8667481 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "CENTURY 21 FIRST CANADIAN CORP" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Turnkey Restaurant Opportunity in Prime Hamilton Location! Seize the perfect business opportunity with this profitable, well-established restaurant in one of Hamilton Mountains most high-traffic locations! Whether you're an aspiring restaurateur or an experienced owner, this turnkey operation is ready for immediate success and future growth. Thriving business with a loyal customer base and strong financial performance. Liquor License for 58 Patrons Immediate revenue potential with dine-in and bar service. Smooth Transition: Seller offers comprehensive training to ensure your success from day one! Growth Potential Expand reach with existing Uber Eats and other delivery service integrations. Previously franchised under BAB, but no ongoing obligations you can operate independently! Optional Franchise Opportunity Initial franchise fee included in the asking price, giving you the choice to continue under the brand or run it your way. New air conditioning installed in April 2023 for a better customer experience. Fully Equipped & Ready to Operate All chattels and equipment owned outright no extra costs! Retirement Sale Step into Ownership and Start Earning Right Away! This isn't just a restaurant its a ready-made business in a prime Hamilton location. Don't let this rare chance slip away!" +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"BusinessName": "BAB Korean food & BBQ" +"BusinessType": array:1 [ 0 => "Hospitality/Food Related" ] +"CityRegion": "Inch Park" +"CommunityFeatures": array:1 [ 0 => "Public Transit" ] +"Cooling": array:1 [ 0 => "Yes" ] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2025-05-04T00:48:50.127818+00:00" +"CrossStreet": "Upper Wellington and Queensdale Ave. E" +"Directions": "Upper" +"Exclusions": "rice cookers and the framed pictures, If the purchaser does not require the fixtures and equipment used for Korean cuisine, the seller shall ensure the removal of such items from the premises prior to the closing date, unless otherwise stipulated in a written agreement between the parties." +"ExpirationDate": "2025-12-31" +"HoursDaysOfOperation": array:1 [ 0 => "Open 6 Days" ] +"HoursDaysOfOperationDescription": "11:30 a.m. to10:00 pm" +"Inclusions": "All existing appliances and chattels included in AS-IS condition. Rent $3995/month including HST and TMI. Remaining Lease term: 2.5+5 year." +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "London and St. Thomas Association of REALTORS" +"ListingContractDate": "2025-05-03" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "371300" +"MajorChangeTimestamp": "2025-05-03T21:59:03Z" +"MlsStatus": "New" +"NumberOfFullTimeEmployees": 3 +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-05-03T21:59:03Z" +"OriginalListPrice": 179900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2250686" +"ParcelNumber": "170460352" +"PhotosChangeTimestamp": "2025-05-03T21:59:04Z" +"SeatingCapacity": "32" +"SecurityFeatures": array:2 [ 0 => "Partial" 1 => "Yes" ] +"ShowingRequirements": array:1 [ 0 => "List Salesperson" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Upper Wellington" +"StreetNumber": "570" +"StreetSuffix": "Street" +"TaxAnnualAmount": "12000.0" +"TaxAssessedValue": 492000 +"TaxLegalDescription": "PT LT 5, PL 476, AS IN VM14035; HAMILTON" +"TaxYear": "2025" +"TransactionBrokerCompensation": "4%+HST" +"TransactionType": "For Sale" +"Utilities": array:1 [ 0 => "Yes" ] +"Zoning": "C5" +"Water": "Municipal" +"LiquorLicenseYN": true +"FreestandingYN": true +"WashroomsType1": 2 +"DDFYN": true +"LotType": "Unit" +"PropertyUse": "Retail" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"LotWidth": 50.0 +"HeatType": "Gas Forced Air Open" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12122616')" +"Rail": "No" +"HSTApplication": array:1 [ 0 => "Included In" ] +"MortgageComment": "seller discharge" +"RollNumber": "251808090308590" +"DevelopmentChargesPaid": array:1 [ 0 => "No" ] +"MinimumRentalTermMonths": 30 +"RetailArea": 1180.0 +"Winterized": "Fully" +"AssessmentYear": 2025 +"ChattelsYN": true +"SystemModificationTimestamp": "2025-05-06T14:52:00.877707Z" +"provider_name": "TRREB" +"LotDepth": 127.0 +"ParkingSpaces": 2 +"PossessionDetails": "flexible" +"MaximumRentalMonthsTerm": 60 +"PermissionToContactListingBrokerToAdvertise": true +"ShowingAppointments": "Call listing agent to book a showing. Book an appointment at least 12 hours before showing. Please avoid the busy time (lunch and evening). 10:00 am~12:00 pm and 3:00-4:300 pm are preferred." +"GarageType": "Outside/Surface" +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"MediaChangeTimestamp": "2025-05-03T21:59:04Z" +"TaxType": "Annual" +"ApproximateAge": "51-99" +"UFFI": "No" +"HoldoverDays": 90 +"RetailAreaCode": "Sq Ft" +"PossessionDate": "2025-06-30" +"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] ] } ] +success: true +page_size: 10 +page_count: 405 +count: 4048 +after_key: "" } ] ]
