3954 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: 5a820a1dacfdbe6749fedf4416cf25ccb9ffe9515532dd4a55f085d1c448412f" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#14268 +items: array:10 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14454 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12208923" +"ListingId": "X12208923" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-14T19:35:43Z" +"RFModificationTimestamp": "2025-06-14T19:40:58.123141+00:00" +"ListPrice": 1129900.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8B 0P5" +"UnparsedAddress": "23 Fenwick Place, Hamilton, ON L8B 0P5" +"Coordinates": array:2 [ 0 => -79.909571 1 => 43.3227955 ] +"Latitude": 43.3227955 +"Longitude": -79.909571 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX REALTY SERVICES INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to this stunning 4-bedroom, 3-bathroom(1941sqft) home nestled on a quiet street in the sought-after Waterdown community. This sun-filled residence offers a perfect blend of comfort, space, and style. Main Floor Smart home integration:Bluetooth App controlled switches enables controlling lights from your phone. Features: Open-concept living and dining area, perfect for entertaining Separate family room. Spacious, family-sized kitchen with pot lights throughout Hardwood flooring (2022) throughout the home. Main floor laundry with interior access from the Garage. Stylish staircase with modern metal Spindles. Walk-out to an extended wooden deck (2023) ideal for summer BBQs and gatherings. Second Floor Offering Four generously sized bedrooms Primary suite with a walk-in closet and a beautifully upgraded ensuite bathroom All additional bedrooms feature double-door closets Recently updated additional washroom on the second floor. Extra-deep lot with a pool-sized backyard plenty of space for outdoor enjoyment Exposed concrete driveway offering ample parking space. Pot lights outside, adding charm and visibility. Close to top-rated schools, shopping malls, grocery stores, parks, library, and all essential amenities. New Furnace and Air conditioner (2024) along with a Smart Ecobee Thermostat, Attic Insulation Upgraded in (2023) This home is move-in ready and offers everything your buyers are looking for. Don't miss this exceptional opportunity book your showing today and sell with confidence!" +"ArchitecturalStyle": array:1 [ 0 => "2-Storey" ] +"Basement": array:2 [ 0 => "Walk-Up" 1 => "Partially Finished" ] +"CityRegion": "Waterdown" +"CoListOfficeName": "RE/MAX REALTY SERVICES INC." +"CoListOfficePhone": "905-456-1000" +"ConstructionMaterials": array:2 [ 0 => "Brick" 1 => "Vinyl Siding" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CountyOrParish": "Hamilton" +"CoveredSpaces": "2.0" +"CreationDate": "2025-06-10T13:09:32.144781+00:00" +"CrossStreet": "HWY 6 to Dundas St E to Hollybush Dr" +"DirectionFaces": "North" +"Directions": "HWY 6 to Dundas St E to Hollybush Dr" +"ExpirationDate": "2025-12-31" +"FireplaceFeatures": array:2 [ 0 => "Family Room" 1 => "Electric" ] +"FoundationDetails": array:1 [ 0 => "Concrete" ] +"GarageYN": true +"Inclusions": "S/S Stove, S/S Fridge, S/S Dishwasher, Clothes Washer & Dryer, All Washroom Mirrors and all windows Covers." +"InteriorFeatures": array:1 [ 0 => "None" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-06-10" +"MainOfficeKey": "498000" +"MajorChangeTimestamp": "2025-06-10T13:06:08Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-06-10T13:06:08Z" +"OriginalListPrice": 1129900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2533988" +"ParcelNumber": "175620550" +"ParkingFeatures": array:1 [ 0 => "Private" ] +"ParkingTotal": "5.0" +"PhotosChangeTimestamp": "2025-06-14T19:23:40Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:1 [ 0 => "Lockbox" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Fenwick" +"StreetNumber": "23" +"StreetSuffix": "Place" +"TaxAnnualAmount": "6633.5" +"TaxLegalDescription": "PCL PLAN-1, SEC 62M739 ; LT 79, PL 62M739 ; S/T LT406101 ; FLAMBOROUGH S/T RIGHT TO ENTER AT ANY TIME UNTIL..." +"TaxYear": "2025" +"TransactionBrokerCompensation": "2%" +"TransactionType": "For Sale" +"VirtualTourURLUnbranded": "https://unbranded.mediatours.ca/property/23-fenwick-place-waterdown/" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 127.42 +"LotWidth": 45.1 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12208923')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "251830339012044" +"SurveyType": "Unknown" +"RentalItems": "Hot Water Tank" +"HoldoverDays": 90 +"LaundryLevel": "Main Level" +"KitchensTotal": 1 +"ParkingSpaces": 3 +"provider_name": "TRREB" +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included In" ] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"DenFamilyroomYN": true +"LivingAreaRange": "1500-2000" +"RoomsAboveGrade": 10 +"PropertyFeatures": array:6 [ 0 => "Fenced Yard" 1 => "Library" 2 => "Park" 3 => "Public Transit" 4 => "Rec./Commun.Centre" 5 => "Place Of Worship" ] +"PossessionDetails": "T-B-A" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 3 +"WashroomsType3Pcs": 3 +"BedroomsAboveGrade": 4 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"WashroomsType3Level": "Second" +"MediaChangeTimestamp": "2025-06-14T19:23:40Z" +"DevelopmentChargesPaid": array:1 [ 0 => "Unknown" ] +"SystemModificationTimestamp": "2025-06-14T19:35:45.067743Z" +"VendorPropertyInfoStatement": true +"Media": array:50 [ 0 => array:26 [ "Order" => 4 "ImageOf" => null "MediaKey" => "d26d8b1a-b70f-4100-aa86-fcfc0ab1f31a" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12208923/39585bd57ae93c70ecec00bbc3976fbe.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 204057 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12208923/thumbnail-39585bd57ae93c70ecec00bbc3976fbe.webp" "ImageWidth" => 1920 "Permission" => array:1 [ …1] "ImageHeight" => 1280 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "d26d8b1a-b70f-4100-aa86-fcfc0ab1f31a" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12208923" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "d26d8b1a-b70f-4100-aa86-fcfc0ab1f31a" "ModificationTimestamp" => "2025-06-10T13:06:08.727825Z" "MediaModificationTimestamp" => "2025-06-10T13:06:08.727825Z" ] 1 => array:26 [ "Order" => 5 "ImageOf" => null "MediaKey" => "c2a5d78c-ccee-4904-b77f-257a280e4331" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12208923/c9b7b056818c933150b8eb8d33021264.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 253484 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12208923/thumbnail-c9b7b056818c933150b8eb8d33021264.webp" "ImageWidth" => 1920 "Permission" => array:1 [ …1] "ImageHeight" => 1280 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "c2a5d78c-ccee-4904-b77f-257a280e4331" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12208923" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "c2a5d78c-ccee-4904-b77f-257a280e4331" "ModificationTimestamp" => "2025-06-10T13:06:08.727825Z" "MediaModificationTimestamp" => "2025-06-10T13:06:08.727825Z" ] 2 => array:26 [ "Order" => 6 "ImageOf" => null "MediaKey" => "845e50cf-fb5a-4d33-a718-02275040e10b" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12208923/6f9636b4969e2955a4d7948dadddd7ca.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 365426 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12208923/thumbnail-6f9636b4969e2955a4d7948dadddd7ca.webp" "ImageWidth" => 1920 "Permission" => array:1 [ …1] "ImageHeight" => 1280 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "845e50cf-fb5a-4d33-a718-02275040e10b" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12208923" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "845e50cf-fb5a-4d33-a718-02275040e10b" "ModificationTimestamp" => "2025-06-10T13:06:08.727825Z" "MediaModificationTimestamp" => "2025-06-10T13:06:08.727825Z" ] 3 => array:26 [ "Order" => 7 "ImageOf" => null "MediaKey" => "4f954889-2f6a-4554-94b3-f40d4d3fbc89" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12208923/27c33e3cbb852e2384dd09764375ec24.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 329025 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12208923/thumbnail-27c33e3cbb852e2384dd09764375ec24.webp" "ImageWidth" => 1920 "Permission" => array:1 [ …1] "ImageHeight" => 1280 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "4f954889-2f6a-4554-94b3-f40d4d3fbc89" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12208923" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "4f954889-2f6a-4554-94b3-f40d4d3fbc89" "ModificationTimestamp" => "2025-06-10T13:06:08.727825Z" "MediaModificationTimestamp" => "2025-06-10T13:06:08.727825Z" ] 4 => array:26 [ "Order" => 8 "ImageOf" => null "MediaKey" => "ea790e2b-c20b-48eb-b1aa-84f3d3d839d5" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12208923/e73f1aa833ca99eec72e3fbea3373bbc.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 300336 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12208923/thumbnail-e73f1aa833ca99eec72e3fbea3373bbc.webp" "ImageWidth" => 1920 "Permission" => array:1 [ …1] "ImageHeight" => 1280 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "ea790e2b-c20b-48eb-b1aa-84f3d3d839d5" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12208923" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "ea790e2b-c20b-48eb-b1aa-84f3d3d839d5" "ModificationTimestamp" => "2025-06-10T13:06:08.727825Z" "MediaModificationTimestamp" => "2025-06-10T13:06:08.727825Z" ] 5 => array:26 [ "Order" => 9 "ImageOf" => null "MediaKey" => "834bde78-c1a0-4aaf-8930-e951b5f90c66" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12208923/01f7411a9722a8a88e80fd1183015127.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 306534 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12208923/thumbnail-01f7411a9722a8a88e80fd1183015127.webp" "ImageWidth" => 1920 "Permission" => array:1 [ …1] "ImageHeight" => 1280 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "834bde78-c1a0-4aaf-8930-e951b5f90c66" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12208923" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "834bde78-c1a0-4aaf-8930-e951b5f90c66" "ModificationTimestamp" => "2025-06-10T13:06:08.727825Z" "MediaModificationTimestamp" => "2025-06-10T13:06:08.727825Z" ] 6 => array:26 [ "Order" => 10 "ImageOf" => null "MediaKey" => "95b3d69f-920e-449d-b9c0-c5881966448d" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12208923/72607a27ec60ea63c24bc87a92bf1c3c.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 355694 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12208923/thumbnail-72607a27ec60ea63c24bc87a92bf1c3c.webp" "ImageWidth" => 1920 "Permission" => array:1 [ …1] "ImageHeight" => 1280 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "95b3d69f-920e-449d-b9c0-c5881966448d" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12208923" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "95b3d69f-920e-449d-b9c0-c5881966448d" "ModificationTimestamp" => "2025-06-10T13:06:08.727825Z" "MediaModificationTimestamp" => "2025-06-10T13:06:08.727825Z" ] 7 => array:26 [ "Order" => 11 "ImageOf" => null "MediaKey" => "ad5500ad-0d3c-4bcf-8832-175f3e9973a4" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12208923/4f9747743edfb6cd1f3e537928f1b960.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 372992 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12208923/thumbnail-4f9747743edfb6cd1f3e537928f1b960.webp" "ImageWidth" => 1920 "Permission" => array:1 [ …1] "ImageHeight" => 1280 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "ad5500ad-0d3c-4bcf-8832-175f3e9973a4" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12208923" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "ad5500ad-0d3c-4bcf-8832-175f3e9973a4" "ModificationTimestamp" => "2025-06-10T13:06:08.727825Z" "MediaModificationTimestamp" => "2025-06-10T13:06:08.727825Z" ] 8 => array:26 [ "Order" => 12 "ImageOf" => null "MediaKey" => "b2443c68-1e21-48fd-badc-1a35363e0541" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12208923/cc03c0191b51e61df9c159a433445ae0.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 350056 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12208923/thumbnail-cc03c0191b51e61df9c159a433445ae0.webp" "ImageWidth" => 1920 "Permission" => array:1 [ …1] "ImageHeight" => 1280 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "b2443c68-1e21-48fd-badc-1a35363e0541" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12208923" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "b2443c68-1e21-48fd-badc-1a35363e0541" "ModificationTimestamp" => "2025-06-10T13:06:08.727825Z" "MediaModificationTimestamp" => "2025-06-10T13:06:08.727825Z" ] 9 => array:26 [ "Order" => 13 "ImageOf" => null "MediaKey" => "60dd5eb4-5506-4802-8d35-1cc04de156d5" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12208923/5d29e7858f766927612f9db44ddd3e58.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 244439 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12208923/thumbnail-5d29e7858f766927612f9db44ddd3e58.webp" "ImageWidth" => 1920 "Permission" => array:1 [ …1] "ImageHeight" => 1280 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "60dd5eb4-5506-4802-8d35-1cc04de156d5" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12208923" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "60dd5eb4-5506-4802-8d35-1cc04de156d5" "ModificationTimestamp" => "2025-06-10T13:06:08.727825Z" "MediaModificationTimestamp" => "2025-06-10T13:06:08.727825Z" ] 10 => array:26 [ "Order" => 14 "ImageOf" => null "MediaKey" => "4d180dfb-db5f-4564-a27e-73e71cfd2bbd" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12208923/c2404d3f84015925894b0427edd120eb.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 315553 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12208923/thumbnail-c2404d3f84015925894b0427edd120eb.webp" "ImageWidth" => 1920 "Permission" => array:1 [ …1] "ImageHeight" => 1280 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "4d180dfb-db5f-4564-a27e-73e71cfd2bbd" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12208923" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "4d180dfb-db5f-4564-a27e-73e71cfd2bbd" "ModificationTimestamp" => "2025-06-10T13:06:08.727825Z" "MediaModificationTimestamp" => "2025-06-10T13:06:08.727825Z" ] 11 => array:26 [ "Order" => 15 "ImageOf" => null "MediaKey" => "1fbf5bb3-f8fb-4fa4-9fb1-91bbdf7dcde7" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12208923/9ff82405146fe43353d8cbfc7f1e609b.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 281086 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12208923/thumbnail-9ff82405146fe43353d8cbfc7f1e609b.webp" "ImageWidth" => 1920 "Permission" => array:1 [ …1] "ImageHeight" => 1280 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "1fbf5bb3-f8fb-4fa4-9fb1-91bbdf7dcde7" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12208923" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "1fbf5bb3-f8fb-4fa4-9fb1-91bbdf7dcde7" "ModificationTimestamp" => "2025-06-10T13:06:08.727825Z" "MediaModificationTimestamp" => "2025-06-10T13:06:08.727825Z" ] 12 => array:26 [ "Order" => 16 "ImageOf" => null "MediaKey" => "25352022-84f4-4f9b-850e-959d14736094" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12208923/550ac98496e7be6ff789fea982cff39f.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 300858 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12208923/thumbnail-550ac98496e7be6ff789fea982cff39f.webp" "ImageWidth" => 1920 "Permission" => array:1 [ …1] "ImageHeight" => 1280 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "25352022-84f4-4f9b-850e-959d14736094" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12208923" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "25352022-84f4-4f9b-850e-959d14736094" "ModificationTimestamp" => "2025-06-10T13:06:08.727825Z" "MediaModificationTimestamp" => "2025-06-10T13:06:08.727825Z" ] 13 => array:26 [ "Order" => 17 "ImageOf" => null "MediaKey" => "ac385213-7cea-4ef6-9b64-585a0a13f13c" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12208923/b6a59ee4955e6a70d14026bd01ae34c4.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 329520 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12208923/thumbnail-b6a59ee4955e6a70d14026bd01ae34c4.webp" "ImageWidth" => 1920 "Permission" => array:1 [ …1] "ImageHeight" => 1280 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "ac385213-7cea-4ef6-9b64-585a0a13f13c" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12208923" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "ac385213-7cea-4ef6-9b64-585a0a13f13c" "ModificationTimestamp" => "2025-06-10T13:06:08.727825Z" "MediaModificationTimestamp" => "2025-06-10T13:06:08.727825Z" ] 14 => array:26 [ "Order" => 18 "ImageOf" => null "MediaKey" => "5b6afd98-a677-4596-8aa9-1d93407e164b" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12208923/c25fc05276b97a3d949ebdfb1f0bee77.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 282913 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12208923/thumbnail-c25fc05276b97a3d949ebdfb1f0bee77.webp" "ImageWidth" => 1920 "Permission" => array:1 [ …1] "ImageHeight" => 1280 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "5b6afd98-a677-4596-8aa9-1d93407e164b" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12208923" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "5b6afd98-a677-4596-8aa9-1d93407e164b" "ModificationTimestamp" => "2025-06-10T13:06:08.727825Z" "MediaModificationTimestamp" => "2025-06-10T13:06:08.727825Z" ] 15 => array:26 [ "Order" => 19 "ImageOf" => null "MediaKey" => "ddb3c8b3-faff-4c0e-882b-29223ded123c" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12208923/30e80f8bce0a3a63d276efefa5a1d10a.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 201724 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12208923/thumbnail-30e80f8bce0a3a63d276efefa5a1d10a.webp" "ImageWidth" => 1920 "Permission" => array:1 [ …1] "ImageHeight" => 1280 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "ddb3c8b3-faff-4c0e-882b-29223ded123c" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12208923" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "ddb3c8b3-faff-4c0e-882b-29223ded123c" "ModificationTimestamp" => "2025-06-10T13:06:08.727825Z" "MediaModificationTimestamp" => "2025-06-10T13:06:08.727825Z" ] 16 => array:26 [ "Order" => 20 "ImageOf" => null "MediaKey" => "c262d5ef-446f-4571-9640-3d1c0c093dd2" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12208923/6dff486ebbdf5b3a94863727d20f9820.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 239935 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12208923/thumbnail-6dff486ebbdf5b3a94863727d20f9820.webp" "ImageWidth" => 1920 "Permission" => array:1 [ …1] "ImageHeight" => 1280 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "c262d5ef-446f-4571-9640-3d1c0c093dd2" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12208923" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "c262d5ef-446f-4571-9640-3d1c0c093dd2" "ModificationTimestamp" => "2025-06-10T13:06:08.727825Z" "MediaModificationTimestamp" => "2025-06-10T13:06:08.727825Z" ] 17 => array:26 [ "Order" => 21 "ImageOf" => null "MediaKey" => "2c4e7b8f-15d4-4af5-ba08-644151f37ceb" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12208923/3c123a9962b74b68d49a3a63c9a6cf93.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 150279 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12208923/thumbnail-3c123a9962b74b68d49a3a63c9a6cf93.webp" "ImageWidth" => 1920 "Permission" => array:1 [ …1] "ImageHeight" => 1280 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "2c4e7b8f-15d4-4af5-ba08-644151f37ceb" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12208923" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "2c4e7b8f-15d4-4af5-ba08-644151f37ceb" "ModificationTimestamp" => "2025-06-10T13:06:08.727825Z" "MediaModificationTimestamp" => "2025-06-10T13:06:08.727825Z" ] 18 => array:26 [ "Order" => 22 "ImageOf" => null "MediaKey" => "df28a40f-db9c-4a4b-aba6-344c62493919" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12208923/0eb6015ed9e35bf597418fe224a8919a.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 240124 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12208923/thumbnail-0eb6015ed9e35bf597418fe224a8919a.webp" "ImageWidth" => 1920 "Permission" => array:1 [ …1] "ImageHeight" => 1280 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "df28a40f-db9c-4a4b-aba6-344c62493919" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12208923" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "df28a40f-db9c-4a4b-aba6-344c62493919" "ModificationTimestamp" => "2025-06-10T13:06:08.727825Z" "MediaModificationTimestamp" => "2025-06-10T13:06:08.727825Z" ] 19 => array:26 [ "Order" => 23 "ImageOf" => null "MediaKey" => "b4b6b266-cb97-4e41-bf7a-a03407cf9cd0" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12208923/665d9403f7cc04aab85de097c3a29f66.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 322614 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12208923/thumbnail-665d9403f7cc04aab85de097c3a29f66.webp" "ImageWidth" => 1920 "Permission" => array:1 [ …1] "ImageHeight" => 1280 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "b4b6b266-cb97-4e41-bf7a-a03407cf9cd0" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12208923" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "b4b6b266-cb97-4e41-bf7a-a03407cf9cd0" "ModificationTimestamp" => "2025-06-10T13:06:08.727825Z" "MediaModificationTimestamp" => "2025-06-10T13:06:08.727825Z" ] 20 => array:26 [ "Order" => 24 "ImageOf" => null "MediaKey" => "73337357-3ea1-498f-b312-89be3124ed92" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12208923/ad7f1232a56ecb942e1573fc31a6f0f2.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 250630 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12208923/thumbnail-ad7f1232a56ecb942e1573fc31a6f0f2.webp" "ImageWidth" => 1920 "Permission" => array:1 [ …1] "ImageHeight" => 1280 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "73337357-3ea1-498f-b312-89be3124ed92" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12208923" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "73337357-3ea1-498f-b312-89be3124ed92" "ModificationTimestamp" => "2025-06-10T13:06:08.727825Z" "MediaModificationTimestamp" => "2025-06-10T13:06:08.727825Z" ] 21 => array:26 [ "Order" => 25 "ImageOf" => null "MediaKey" => "b74b0f63-93bc-4d19-9d3c-473f39a7cf53" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12208923/28fffb7191ef856649dacc9b2f8ab3ee.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 251424 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12208923/thumbnail-28fffb7191ef856649dacc9b2f8ab3ee.webp" "ImageWidth" => 1920 "Permission" => array:1 [ …1] "ImageHeight" => 1280 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "b74b0f63-93bc-4d19-9d3c-473f39a7cf53" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12208923" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "b74b0f63-93bc-4d19-9d3c-473f39a7cf53" "ModificationTimestamp" => "2025-06-10T13:06:08.727825Z" "MediaModificationTimestamp" => "2025-06-10T13:06:08.727825Z" ] 22 => array:26 [ "Order" => 26 "ImageOf" => null "MediaKey" => "4eeaf67b-54b2-47c7-aa2e-d6b14ee97218" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12208923/cc757a6d5017754acc73f29ed715f615.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 213841 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12208923/thumbnail-cc757a6d5017754acc73f29ed715f615.webp" "ImageWidth" => 1920 "Permission" => array:1 [ …1] "ImageHeight" => 1280 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "4eeaf67b-54b2-47c7-aa2e-d6b14ee97218" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12208923" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "4eeaf67b-54b2-47c7-aa2e-d6b14ee97218" "ModificationTimestamp" => "2025-06-10T13:06:08.727825Z" "MediaModificationTimestamp" => "2025-06-10T13:06:08.727825Z" ] 23 => array:26 [ "Order" => 27 "ImageOf" => null "MediaKey" => "110eb048-6c7e-4bdc-ad3c-3743705df335" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12208923/3557f44ceac48f32f749c915cb885b1b.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 265869 …19 ] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] 31 => array:26 [ …26] 32 => array:26 [ …26] 33 => array:26 [ …26] 34 => array:26 [ …26] 35 => array:26 [ …26] 36 => array:26 [ …26] 37 => array:26 [ …26] 38 => array:26 [ …26] 39 => array:26 [ …26] 40 => array:26 [ …26] 41 => array:26 [ …26] 42 => array:26 [ …26] 43 => array:26 [ …26] 44 => array:26 [ …26] 45 => array:26 [ …26] 46 => array:26 [ …26] 47 => array:26 [ …26] 48 => array:26 [ …26] 49 => array:26 [ …26] ] } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14455 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12221379" +"ListingId": "X12221379" +"PropertyType": "Residential" +"PropertySubType": "Att/Row/Townhouse" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-14T19:13:11Z" +"RFModificationTimestamp": "2025-06-16T16:53:27.091991+00:00" +"ListPrice": 737000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8K 5J3" +"UnparsedAddress": "27 Rapids Lane, Hamilton, ON L8K 5J3" +"Coordinates": array:2 [ 0 => -79.7852107 1 => 43.2176423 ] +"Latitude": 43.2176423 +"Longitude": -79.7852107 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "HOMELIFE FRONTIER REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to nearly 2,000 sq ft of luxurious, contemporary living space, plus an unfinishedbasement offering endless possibilities for storage or future expansion. This spacious3-bedroom, 2.5-bath home is located in a quiet enclave of townhomes close to all amenities,parks, top-rated schools, Sir Wilfrid Laurier Recreation Centre, and with easy access to majorhighways.The spectacular layout includes an open-concept second floor that is an entertainers dream,featuring a custom fireplace, upgraded countertops, stylish backsplash, pot lights throughout,and a separate dining area. The sleek, upgraded kitchen is equipped with high-end appliancesand ample cabinetry perfect for modern living.On the main floor, youll find a bright office space ideal for working from home, which caneasily serve as a 4th bedroom if needed. The upper level offers three generously sizedbedrooms, including a beautiful primary suite with a spa-like ensuite.Enjoy outdoor living on the amazing patio deck with a charming gazebo perfect for summergatherings or peaceful relaxation.This move-in ready home truly has it all space, style, upgrades, and location. Dont missyour opportunity to call it yours!" +"ArchitecturalStyle": array:1 [ 0 => "3-Storey" ] +"Basement": array:1 [ 0 => "Full" ] +"CityRegion": "Vincent" +"ConstructionMaterials": array:2 [ 0 => "Brick" 1 => "Vinyl Siding" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CountyOrParish": "Hamilton" +"CoveredSpaces": "1.0" +"CreationDate": "2025-06-14T17:22:58.845271+00:00" +"CrossStreet": "King St E & Quigley Rd" +"DirectionFaces": "West" +"Directions": "King St E & Quigley Rd" +"Exclusions": "n/a" +"ExpirationDate": "2025-11-13" +"ExteriorFeatures": array:2 [ 0 => "Deck" 1 => "Canopy" ] +"FireplaceFeatures": array:2 [ 0 => "Electric" 1 => "Living Room" ] +"FireplaceYN": true +"FoundationDetails": array:1 [ 0 => "Concrete" ] +"GarageYN": true +"Inclusions": "Included: Dishwasher, Refrigerator, Stove, Washer/Dryer, Range Hood, Garage Door Opener,California Shutters/Window Coverings, and Pot Lights throughout." +"InteriorFeatures": array:2 [ 0 => "Auto Garage Door Remote" 1 => "Carpet Free" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-06-13" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "099000" +"MajorChangeTimestamp": "2025-06-14T17:18:53Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-06-14T17:18:53Z" +"OriginalListPrice": 737000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2562844" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-06-14T19:13:10Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:1 [ 0 => "Lockbox" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Rapids" +"StreetNumber": "27" +"StreetSuffix": "Lane" +"TaxAnnualAmount": "5734.02" +"TaxLegalDescription": "PT BLOCK 1 PLAN 62M1258 PART 85 62R21211 TOGETHER WITH AN UNDIVIDED COMMON INTEREST IN WENTWORTH COMMON ELEMENTS CONDOMINIUM CORPORATION NO. 586 SUBJECT TO AN EASEMENT IN GROSS AS IN WE1282903 SUBJECT TO AN EASEMENT AS IN WE1286092 SUBJECT TO AN EASEMENT IN GROSS AS IN WE1328604 SUBJECT TO AN EASEMENT IN GROSS AS IN WE1332101 SUBJECT TO AN EASEMENT AS IN WE1339632 SUBJECT TO AN EASEMENT IN FAVOUR OF WENTWORTH COMMON ELEMENTS CONDOMINIUM CORPORATION NO. 586 AS IN WE1385097 SUBJECT TO AN EASEMENT" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2.25%+HST" +"TransactionType": "For Sale" +"VirtualTourURLUnbranded": "https://listings.airunlimitedcorp.com/sites/nxmexrj/unbranded" +"DDFYN": true +"Water": "Municipal" +"GasYNA": "Yes" +"HeatType": "Forced Air" +"LotDepth": 78.0 +"LotWidth": 23.4 +"SewerYNA": "Yes" +"WaterYNA": "Yes" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12221379')" +"GarageType": "Built-In" +"HeatSource": "Gas" +"SurveyType": "Available" +"ElectricYNA": "Yes" +"RentalItems": "Hot Water Tank" +"HoldoverDays": 180 +"KitchensTotal": 1 +"ParkingSpaces": 1 +"provider_name": "TRREB" +"ApproximateAge": "0-5" +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included In" ] +"PossessionDate": "2025-08-29" +"PossessionType": "60-89 days" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"DenFamilyroomYN": true +"LivingAreaRange": "1500-2000" +"RoomsAboveGrade": 7 +"PossessionDetails": "TBD" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 4 +"WashroomsType3Pcs": 4 +"BedroomsAboveGrade": 3 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"ShowingAppointments": "DOOR KEYPAD 2017#" +"WashroomsType1Level": "Second" +"WashroomsType2Level": "Third" +"WashroomsType3Level": "Third" +"MediaChangeTimestamp": "2025-06-14T19:13:10Z" +"SystemModificationTimestamp": "2025-06-14T19:13:13.97684Z" +"Media": array:39 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] 31 => array:26 [ …26] 32 => array:26 [ …26] 33 => array:26 [ …26] 34 => array:26 [ …26] 35 => array:26 [ …26] 36 => array:26 [ …26] 37 => array:26 [ …26] 38 => array:26 [ …26] ] } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14461 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12191081" +"ListingId": "X12191081" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-14T19:12:41Z" +"RFModificationTimestamp": "2025-06-14T19:19:14.761335+00:00" +"ListPrice": 1238000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L9A 1A1" +"UnparsedAddress": "37 Mountain Park Avenue, Hamilton, ON L9A 1A1" +"Coordinates": array:2 [ 0 => -79.857563 1 => 43.2439189 ] +"Latitude": 43.2439189 +"Longitude": -79.857563 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "BAY STREET HARBORELITE REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to 37 Mountain Park Avenue! This stunning 4-bedroom, 3-bathroom home is nestled in a private enclave and offers breathtaking, unobstructed views from the Niagara Escarpment all the way to Toronto. The professionally landscaped exterior features an award-winning design with a water feature, pergola, outdoor patio, hot tub, and a full irrigation system perfect for outdoor living and entertaining. Inside, the spacious main floor boasts a custom chefs kitchen, an elegant living and dining area with hardwood flooring, and a four-season sunroom all enjoying spectacular escarpment views. Upstairs, you'll find three generous bedrooms with hardwood floors and a freshly updated 5-piece main bathroom. The fully finished lower level offers bright and versatile space, including a 4-piece bath, a large laundry area, and a cold room. This beautifully maintained and thoughtfully updated home is full of charm, ideally situated in one of Hamilton's most desirable neighborhoods. Don't miss your opportunity schedule your private showing today!" +"ArchitecturalStyle": array:1 [ 0 => "2-Storey" ] +"Basement": array:1 [ 0 => "Finished" ] +"CityRegion": "Inch Park" +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CountyOrParish": "Hamilton" +"CoveredSpaces": "1.0" +"CreationDate": "2025-06-03T09:14:06.393661+00:00" +"CrossStreet": "Mountain Park Ave / Belwood Ave" +"DirectionFaces": "North" +"Directions": "North side of Mountain Park Ave" +"ExpirationDate": "2025-09-02" +"FireplaceYN": true +"FoundationDetails": array:1 [ 0 => "Brick" ] +"GarageYN": true +"Inclusions": "All electric light fixtures. Existing fridge, stove, hood vent, microwave, dishwasher, clothes washer and dryer." +"InteriorFeatures": array:1 [ 0 => "Carpet Free" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-06-03" +"MainOfficeKey": "436200" +"MajorChangeTimestamp": "2025-06-14T19:12:41Z" +"MlsStatus": "Price Change" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-06-03T04:31:04Z" +"OriginalListPrice": 999000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2485640" +"ParcelNumber": "171150130" +"ParkingFeatures": array:2 [ 0 => "Available" 1 => "Private" ] +"ParkingTotal": "3.0" +"PhotosChangeTimestamp": "2025-06-03T04:31:05Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"PreviousListPrice": 999000.0 +"PriceChangeTimestamp": "2025-06-14T19:12:41Z" +"Roof": array:1 [ 0 => "Unknown" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:2 [ 0 => "Lockbox" 1 => "Showing System" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Mountain Park" +"StreetNumber": "37" +"StreetSuffix": "Avenue" +"TaxAnnualAmount": "7000.0" +"TaxLegalDescription": "LT 12, PL 384 ; HAMILTON" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2.5% + HST" +"TransactionType": "For Sale" +"VirtualTourURLUnbranded": "https://www.tsstudio.ca/37-mountain-park-ave" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 110.91 +"LotWidth": 46.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12191081')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "251807081507980" +"SurveyType": "Unknown" +"Waterfront": array:1 [ 0 => "None" ] +"HoldoverDays": 60 +"KitchensTotal": 1 +"ParkingSpaces": 2 +"provider_name": "TRREB" +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Not Subject to HST" ] +"PossessionType": "Immediate" +"PriorMlsStatus": "New" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"DenFamilyroomYN": true +"LivingAreaRange": "1500-2000" +"RoomsAboveGrade": 7 +"PossessionDetails": "TBA" +"WashroomsType1Pcs": 5 +"WashroomsType2Pcs": 4 +"WashroomsType3Pcs": 2 +"BedroomsAboveGrade": 4 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"MediaChangeTimestamp": "2025-06-13T21:52:55Z" +"SystemModificationTimestamp": "2025-06-14T19:12:41.484908Z" +"Media": array:48 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] 31 => array:26 [ …26] 32 => array:26 [ …26] 33 => array:26 [ …26] 34 => array:26 [ …26] 35 => array:26 [ …26] 36 => array:26 [ …26] 37 => array:26 [ …26] 38 => array:26 [ …26] 39 => array:26 [ …26] 40 => array:26 [ …26] 41 => array:26 [ …26] 42 => array:26 [ …26] 43 => array:26 [ …26] 44 => array:26 [ …26] 45 => array:26 [ …26] 46 => array:26 [ …26] 47 => array:26 [ …26] ] } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14458 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12167095" +"ListingId": "X12167095" +"PropertyType": "Residential Lease" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-14T18:48:26Z" +"RFModificationTimestamp": "2025-06-14T18:53:39.338959+00:00" +"ListPrice": 2450.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8V 3R4" +"UnparsedAddress": "74 Bellingham Drive, Hamilton, ON L8V 3R4" +"Coordinates": array:2 [ 0 => -79.8524044 1 => 43.2180371 ] +"Latitude": 43.2180371 +"Longitude": -79.8524044 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX ESCARPMENT REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Great mountain location close to amenities, hospitals, Mohawk College and more. Spacious, bright, private main floor suite with 3 generous bedrooms, insuite laundry and loads of parking. Open concept living with lots of storage, mature gardens and access to the backyard. Tenant to handle snow, landlord to do the lawns. Tenant to pay 60% heat, gas, water and water heater. Available July 1, please prepare credit report, references, and employment letter for review. Two year leases considered. Basement is not tenant occupied." +"ArchitecturalStyle": array:1 [ 0 => "Bungalow" ] +"Basement": array:1 [ 0 => "None" ] +"CityRegion": "Lawfield" +"ConstructionMaterials": array:2 [ 0 => "Brick" 1 => "Other" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CountyOrParish": "Hamilton" +"CreationDate": "2025-05-22T21:48:30.043663+00:00" +"CrossStreet": "MOHAWK" +"DirectionFaces": "West" +"Directions": "BERKO TO BELLINGHAM" +"ExpirationDate": "2025-08-21" +"FoundationDetails": array:1 [ 0 => "Block" ] +"Furnished": "Unfurnished" +"Inclusions": "Dryer, Range Hood, Refrigerator, Washer" +"InteriorFeatures": array:1 [ 0 => "Carpet Free" ] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "In Area" ] +"LeaseTerm": "12 Months" +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-05-21" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "184000" +"MajorChangeTimestamp": "2025-06-14T18:48:26Z" +"MlsStatus": "Price Change" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2025-05-22T20:20:04Z" +"OriginalListPrice": 2500.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2425784" +"ParcelNumber": "169810053" +"ParkingFeatures": array:1 [ 0 => "Private" ] +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-05-22T20:20:04Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"PreviousListPrice": 2500.0 +"PriceChangeTimestamp": "2025-06-14T18:48:25Z" +"RentIncludes": array:2 [ 0 => "Building Maintenance" 1 => "Common Elements" ] +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:1 [ 0 => "Lockbox" ] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "BELLINGHAM" +"StreetNumber": "74" +"StreetSuffix": "Drive" +"TransactionBrokerCompensation": "1/2 MONTHS RENT PLUS HST" +"TransactionType": "For Lease" +"DDFYN": true +"Water": "Municipal" +"GasYNA": "Yes" +"CableYNA": "Available" +"HeatType": "Forced Air" +"LotDepth": 100.0 +"LotShape": "Rectangular" +"LotWidth": 50.0 +"SewerYNA": "Yes" +"WaterYNA": "Yes" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12167095')" +"GarageType": "Other" +"HeatSource": "Gas" +"RollNumber": "251807064207230" +"SurveyType": "None" +"ElectricYNA": "Yes" +"RentalItems": "Water Heater" +"HoldoverDays": 30 +"LaundryLevel": "Main Level" +"TelephoneYNA": "Available" +"CreditCheckYN": true +"KitchensTotal": 1 +"ParkingSpaces": 2 +"PaymentMethod": "Direct Withdrawal" +"provider_name": "TRREB" +"ApproximateAge": "51-99" +"ContractStatus": "Available" +"PossessionDate": "2025-07-01" +"PossessionType": "Other" +"PriorMlsStatus": "New" +"WashroomsType1": 1 +"DepositRequired": true +"LivingAreaRange": "700-1100" +"RoomsAboveGrade": 5 +"LeaseAgreementYN": true +"PaymentFrequency": "Monthly" +"LotSizeRangeAcres": "< .50" +"PossessionDetails": "JULY 1, 2025" +"PrivateEntranceYN": true +"WashroomsType1Pcs": 4 +"BedroomsAboveGrade": 3 +"EmploymentLetterYN": true +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"RentalApplicationYN": true +"ShowingAppointments": "ALLOW 25 HOURS FOR CURRENT TENANT" +"WashroomsType1Level": "Main" +"MediaChangeTimestamp": "2025-05-22T20:20:04Z" +"PortionLeaseComments": "BRIGHT UPPER UNIT" +"PortionPropertyLease": array:1 [ 0 => "Main" ] +"ReferencesRequiredYN": true +"SystemModificationTimestamp": "2025-06-14T18:48:28.065989Z" +"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] ] } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14453 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12221484" +"ListingId": "X12221484" +"PropertyType": "Residential Lease" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-14T18:43:16Z" +"RFModificationTimestamp": "2025-06-16T15:08:12.769525+00:00" +"ListPrice": 3600.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L9G 5A4" +"UnparsedAddress": "45 Kendrick Court, Hamilton, ON L9G 5A4" +"Coordinates": array:2 [ 0 => -79.9903747 1 => 43.2038345 ] +"Latitude": 43.2038345 +"Longitude": -79.9903747 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX REAL ESTATE CENTRE INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Spectacular home in the highly desirable Maple Lane Annex neighbourhood of Ancaster! This move-in-ready gem features 3 bedrooms, 4bathrooms, and has been freshly painted. The finished basement offers a dedicated office space, a den, a game room, and a 3-piece washroom. Enjoy a beautifully re-stoned backyard with no rear neighbours, perfect for privacy and relaxation. Located just 6 minutes from a shopping plaza with major retailers like Walmart, Fortinos, and Canadian Tire. Close to top-rated schools, parks, and playgrounds, this is a must-see home." +"ArchitecturalStyle": array:1 [ 0 => "2-Storey" ] +"Basement": array:1 [ 0 => "Finished" ] +"CityRegion": "Ancaster" +"ConstructionMaterials": array:2 [ 0 => "Vinyl Siding" 1 => "Brick Front" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CountyOrParish": "Hamilton" +"CoveredSpaces": "1.0" +"CreationDate": "2025-06-14T18:43:58.975047+00:00" +"CrossStreet": "Braithwaite Ave" +"DirectionFaces": "North" +"Directions": "Garner Rd W to Braithwaite Ave to Blasdell to Kendrick court." +"ExpirationDate": "2025-08-31" +"FoundationDetails": array:1 [ 0 => "Concrete" ] +"Furnished": "Unfurnished" +"GarageYN": true +"Inclusions": "Dishwasher, Dryer, Gas Stove, Microwave, Refrigerator, Washer" +"InteriorFeatures": array:1 [ 0 => "None" ] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "In Building" ] +"LeaseTerm": "12 Months" +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-06-10" +"MainOfficeKey": "079800" +"MajorChangeTimestamp": "2025-06-14T18:37:41Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-06-14T18:37:41Z" +"OriginalListPrice": 3600.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2558526" +"ParkingTotal": "5.0" +"PhotosChangeTimestamp": "2025-06-14T18:43:15Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"RentIncludes": array:2 [ 0 => "Central Air Conditioning" 1 => "Parking" ] +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:1 [ 0 => "Lockbox" ] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "KENDRICK" +"StreetNumber": "45" +"StreetSuffix": "Court" +"TransactionBrokerCompensation": "Half Month Rent + HST" +"TransactionType": "For Lease" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12221484')" +"GarageType": "Detached" +"HeatSource": "Gas" +"SurveyType": "Unknown" +"RentalItems": "Hot Water Heater" +"HoldoverDays": 90 +"LaundryLevel": "Upper Level" +"CreditCheckYN": true +"KitchensTotal": 1 +"ParkingSpaces": 4 +"PaymentMethod": "Other" +"provider_name": "TRREB" +"ApproximateAge": "16-30" +"ContractStatus": "Available" +"PossessionDate": "2025-07-01" +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"WashroomsType4": 1 +"DepositRequired": true +"LivingAreaRange": "1500-2000" +"RoomsAboveGrade": 7 +"LeaseAgreementYN": true +"ParcelOfTiedLand": "No" +"PaymentFrequency": "Monthly" +"PossessionDetails": "Vacant home" +"PrivateEntranceYN": true +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 5 +"WashroomsType3Pcs": 4 +"WashroomsType4Pcs": 3 +"BedroomsAboveGrade": 3 +"EmploymentLetterYN": true +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"RentalApplicationYN": true +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"WashroomsType3Level": "Second" +"WashroomsType4Level": "Basement" +"MediaChangeTimestamp": "2025-06-14T18:43:15Z" +"PortionLeaseComments": "Entire house" +"PortionPropertyLease": array:1 [ 0 => "Entire Property" ] +"ReferencesRequiredYN": true +"SystemModificationTimestamp": "2025-06-14T18:43:16.113931Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:39 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] 31 => array:26 [ …26] 32 => array:26 [ …26] 33 => array:26 [ …26] 34 => array:26 [ …26] 35 => array:26 [ …26] 36 => array:26 [ …26] 37 => array:26 [ …26] 38 => array:26 [ …26] ] } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14432 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12215230" +"ListingId": "X12215230" +"PropertyType": "Residential" +"PropertySubType": "Condo Townhouse" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-14T18:29:52Z" +"RFModificationTimestamp": "2025-06-14T18:35:08.080510+00:00" +"ListPrice": 699000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8B 1V9" +"UnparsedAddress": "#13 - 219 Dundas Street, Hamilton, ON L8B 1V9" +"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": "Immaculate and an absolute show stopper 2 Beds and 3 Baths townhouse in a great location of promising Waterdown. **2018 Built. 1496 Square Feet**. Comes with a large **private rooftop terrace offering unobstructive northerly 180 degree view**. Main floor boats **9Ft. Ceiling**. As you enter, on the left you'll find the elegant and grand square shaped living room having 3 tall windows offering an open southerly view. The gorgeous formal dining room with large windows sits on the opposite side of the living room. In between is located an elegant**open concept gourmet kitchen** that boasts quartz counters, Centre Island/breakfast bar, backsplash, pendant light, stainless steel appliances, tons of cabinets. This main floor also is complemented by a large Pantry and a powder room. The **two beautiful and large bedrooms** are located on the third level. The master bed has its **own 4 pc ensuite**, walk-in closet and also opens to a **Juliette balcony**. The other room is also stunning with a walk-in closet and 3 windows offering beautiful southerly view. Laundry is also located besides the bedrooms. Isn't it a great feature? Just to add one more mega star to its shoulder, this gem also comes with a large private rooftop oasis having both covered and open terrace offering an unobstructed northerly view. Isn't it nice? This terrace is a real great place for chilling, barbequing, having tea/coffee/drink and entertaining your friends in rain or shine. The whole house has tons of windows opening to both north and south side. It's painted in a beautiful neutral color and shows extremely well. Upgraded blinds and light fixtures. Your clients will really like it. Great complex in an excellent location close to schools, walmart, Sobey's, Harvey's, Swiss Chalet, TD Bank, Shoppers, Pizza Pizza, and much more. 3 minutes to HWY 6, seven minutes to 403, One minute drive to Rockcliffe Trail. Shows A+++++." +"ArchitecturalStyle": array:1 [ 0 => "3-Storey" ] +"AssociationFee": "307.74" +"AssociationFeeIncludes": array:3 [ 0 => "Common Elements Included" 1 => "Parking Included" 2 => "Building Insurance Included" ] +"AssociationYN": true +"Basement": array:1 [ 0 => "None" ] +"CityRegion": "Waterdown" +"ConstructionMaterials": array:1 [ 0 => "Stone" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CoolingYN": true +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2025-06-12T14:25:45.709762+00:00" +"CrossStreet": "Dundas and Hamilton St." +"Directions": "West of Hamilton St" +"Exclusions": "Wall mounted TV's and TV Brackets." +"ExpirationDate": "2025-09-12" +"HeatingYN": true +"Inclusions": "Existing Stainless Fridge, B/I Dishwasher, Electric Stove, Range Hood, Washer, Dryer, All Blinds and Window Coverings and all light fixtures" +"InteriorFeatures": array:1 [ 0 => "None" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "Laundry Closet" ] +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-06-12" +"MainOfficeKey": "079800" +"MajorChangeTimestamp": "2025-06-12T13:48:45Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-06-12T13:48:45Z" +"OriginalListPrice": 699000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2550086" +"ParcelNumber": "185760013" +"ParkingFeatures": array:1 [ 0 => "Private" ] +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ 0 => "Restricted" ] +"PhotosChangeTimestamp": "2025-06-13T20:00:31Z" +"RoomsTotal": "6" +"ShowingRequirements": array:1 [ 0 => "See Brokerage Remarks" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "E" +"StreetName": "Dundas" +"StreetNumber": "219" +"StreetSuffix": "Street" +"TaxAnnualAmount": "4317.44" +"TaxBookNumber": "251830339002413" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2% + HST" +"TransactionType": "For Sale" +"UnitNumber": "13" +"DDFYN": true +"Locker": "None" +"Exposure": "North" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12215230')" +"PictureYN": true +"GarageType": "None" +"HeatSource": "Gas" +"SurveyType": "None" +"BalconyType": "Terrace" +"RentalItems": "Hot Water Heater" +"HoldoverDays": 90 +"LaundryLevel": "Upper Level" +"LegalStories": "1" +"ParkingSpot1": "13" +"ParkingType1": "Exclusive" +"KitchensTotal": 1 +"ParkingSpaces": 1 +"UnderContract": array:1 [ 0 => "Hot Water Heater" ] +"provider_name": "TRREB" +"ApproximateAge": "6-10" +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included In" ] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"CondoCorpNumber": 576 +"LivingAreaRange": "1400-1599" +"RoomsAboveGrade": 6 +"PropertyFeatures": array:3 [ 0 => "Library" 1 => "Public Transit" 2 => "School" ] +"SquareFootSource": "Floor Plan" +"StreetSuffixCode": "St" +"BoardPropertyType": "Condo" +"PossessionDetails": "45-90 days" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 4 +"WashroomsType3Pcs": 4 +"BedroomsAboveGrade": 2 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"StatusCertificateYN": true +"WashroomsType1Level": "Second" +"WashroomsType2Level": "Third" +"WashroomsType3Level": "Third" +"LegalApartmentNumber": "13" +"MediaChangeTimestamp": "2025-06-13T20:00:31Z" +"MLSAreaDistrictOldZone": "X14" +"PropertyManagementCompany": "Property Management Guild" +"MLSAreaMunicipalityDistrict": "Hamilton" +"SystemModificationTimestamp": "2025-06-14T18:29:55.374684Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:45 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] 31 => array:26 [ …26] 32 => array:26 [ …26] 33 => array:26 [ …26] 34 => array:26 [ …26] 35 => array:26 [ …26] 36 => array:26 [ …26] 37 => array:26 [ …26] 38 => array:26 [ …26] 39 => array:26 [ …26] 40 => array:26 [ …26] 41 => array:26 [ …26] 42 => array:26 [ …26] 43 => array:26 [ …26] 44 => array:26 [ …26] ] } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14431 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12221432" +"ListingId": "X12221432" +"PropertyType": "Residential Lease" +"PropertySubType": "Common Element Condo" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-14T17:57:05Z" +"RFModificationTimestamp": "2025-06-16T15:08:12.127979+00:00" +"ListPrice": 2250.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8P 1H8" +"UnparsedAddress": "#1111 - 150 Main Street, Hamilton, ON L8P 1H8" +"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": "Stunning and well maintained unit available for rent August 1! This gorgeous upper-level unit has 10' ceilings and offers tons of natural light. You'll love the modern design and neutral finishes. The unit enjoys 2 full bathrooms, a den, spacious bedroom with private ensuite, in-suite laundry, balcony, and one parking spot! Water and heat included. The building offers indoor pool with rooftop deck and BBQ area, fitness room, large party room, and a virtual concierge. This trendy and centrally located building is ideal for professionals and medical students, as its walking distance to transit, and a quick drive to several hospitals. The building is well managed and quiet. Walkable to shopping, restaurants, public transit and the GO train! Excellent for Mc Master students and medical residents! Looking for AAA tenants! Don't miss out!" +"AccessibilityFeatures": array:2 [ 0 => "Elevator" 1 => "Parking" ] +"ArchitecturalStyle": array:1 [ 0 => "1 Storey/Apt" ] +"AssociationAmenities": array:5 [ 0 => "Elevator" 1 => "Exercise Room" 2 => "Indoor Pool" 3 => "Party Room/Meeting Room" 4 => "Rooftop Deck/Garden" ] +"Basement": array:1 [ 0 => "None" ] +"CityRegion": "Central" +"ConstructionMaterials": array:2 [ 0 => "Brick" 1 => "Concrete" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CountyOrParish": "Hamilton" +"CoveredSpaces": "1.0" +"CreationDate": "2025-06-14T18:04:27.752524+00:00" +"CrossStreet": "CAROLINE ST" +"Directions": "CAROLINE ST TO MAIN ST WEST" +"ExpirationDate": "2025-10-31" +"Furnished": "Unfurnished" +"GarageYN": true +"Inclusions": "Appliances" +"InteriorFeatures": array:1 [ 0 => "Carpet Free" ] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "In-Suite Laundry" ] +"LeaseTerm": "12 Months" +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-06-13" +"MainOfficeKey": "184000" +"MajorChangeTimestamp": "2025-06-14T17:57:05Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2025-06-14T17:57:05Z" +"OriginalListPrice": 2250.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2563424" +"ParkingFeatures": array:1 [ 0 => "None" ] +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ 0 => "Restricted" ] +"PhotosChangeTimestamp": "2025-06-14T17:57:05Z" +"RentIncludes": array:7 [ 0 => "Building Insurance" 1 => "Building Maintenance" 2 => "Common Elements" 3 => "Exterior Maintenance" 4 => "Heat" 5 => "Parking" 6 => "Water" ] +"SecurityFeatures": array:1 [ 0 => "Concierge/Security" ] +"ShowingRequirements": array:1 [ 0 => "Lockbox" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "W" +"StreetName": "MAIN" +"StreetNumber": "150" +"StreetSuffix": "Street" +"TransactionBrokerCompensation": "HALF MONTH RENT + HST" +"TransactionType": "For Lease" +"UnitNumber": "1111" +"DDFYN": true +"Locker": "None" +"Exposure": "East" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12221432')" +"ElevatorYN": true +"GarageType": "Underground" +"HeatSource": "Gas" +"SurveyType": "Unknown" +"BalconyType": "Open" +"HoldoverDays": 90 +"LaundryLevel": "Main Level" +"LegalStories": "12" +"ParkingSpot1": "10" +"ParkingType1": "Owned" +"CreditCheckYN": true +"KitchensTotal": 1 +"PaymentMethod": "Direct Withdrawal" +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8P 1H8, CA" +"ApproximateAge": "6-10" +"ContractStatus": "Available" +"PossessionDate": "2025-08-01" +"PossessionType": "30-59 days" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"CondoCorpNumber": 543 +"DenFamilyroomYN": true +"DepositRequired": true +"LivingAreaRange": "700-799" +"RoomsAboveGrade": 7 +"EnsuiteLaundryYN": true +"LeaseAgreementYN": true +"PaymentFrequency": "Monthly" +"PropertyFeatures": array:6 [ 0 => "Golf" 1 => "Hospital" 2 => "Library" 3 => "Park" 4 => "Place Of Worship" 5 => "Public Transit" ] +"SquareFootSource": "776 - BUILDER FLOOR PLANS" +"ParkingLevelUnit1": "1" +"PossessionDetails": "AUGUST 1" +"WashroomsType1Pcs": 3 +"WashroomsType2Pcs": 4 +"BedroomsAboveGrade": 1 +"EmploymentLetterYN": true +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"RentalApplicationYN": true +"ShowingAppointments": "BROKER BAY - 24 HRS NOTICE TO SHOW" +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Main" +"LegalApartmentNumber": "11" +"MediaChangeTimestamp": "2025-06-14T17:57:05Z" +"PortionPropertyLease": array:1 [ 0 => "Entire Property" ] +"ReferencesRequiredYN": true +"PropertyManagementCompany": "GREENWIN" +"SystemModificationTimestamp": "2025-06-14T17:57:06.020134Z" +"Media": array:20 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] ] } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14430 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12184280" +"ListingId": "X12184280" +"PropertyType": "Commercial Sale" +"PropertySubType": "Industrial" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-14T17:21:23Z" +"RFModificationTimestamp": "2025-06-14T17:28:43.852081+00:00" +"ListPrice": 674999.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 3000.0 +"City": "Hamilton" +"PostalCode": "L8M 2A2" +"UnparsedAddress": "366 Cumberland Avenue, Hamilton, ON L8M 2A2" +"Coordinates": array:2 [ 0 => -79.8368043 1 => 43.2421166 ] +"Latitude": 43.2421166 +"Longitude": -79.8368043 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "INTERNATIONAL REALTY FIRM, INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Free standing light industrial building with 3000 sf of interior space suitable for many commercial uses such as: warehouse, manufacturing, carpenter's shop, retail variety, etc. Since this is not a condo, there are zero maintenance fees, and the property taxes are extremely low ($2561 for 2024), so the overhead costs are much lower than the average industrial unit and you have the freedom to renovate or develop the site as you please. The property has no basement and is mostly on the ground level (with one 2nd floor office). Potential to add a second or third story to existing building. The property backs onto the escarpment and is steps from Gage Park. The building is set back from the road behind a row of houses. Easy access to downtown Hamilton and to Red Hill Valley Parkway. This is the perfect location to run your new or existing business! The sellers will consider offering mortgage financing (VTB) to a buyer with a minimum down payment of 50%." +"BuildingAreaUnits": "Square Feet" +"BusinessType": array:1 [ 0 => "Warehouse" ] +"CityRegion": "Blakeley" +"Cooling": array:1 [ 0 => "No" ] +"CountyOrParish": "Hamilton" +"CreationDate": "2025-05-30T14:55:39.622236+00:00" +"CrossStreet": "GAGE AVE S/CUMBERLAND" +"Directions": "Cumberland Ave., west of Gage" +"ExpirationDate": "2025-12-31" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-05-30" +"MainOfficeKey": "306300" +"MajorChangeTimestamp": "2025-06-14T17:21:23Z" +"MlsStatus": "Price Change" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2025-05-30T14:41:53Z" +"OriginalListPrice": 699999.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2474240" +"ParcelNumber": "171130255" +"PhotosChangeTimestamp": "2025-05-30T14:41:54Z" +"PreviousListPrice": 699999.0 +"PriceChangeTimestamp": "2025-06-14T17:21:22Z" +"SecurityFeatures": array:1 [ 0 => "No" ] +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Cumberland" +"StreetNumber": "366" +"StreetSuffix": "Avenue" +"TaxAnnualAmount": "2561.0" +"TaxLegalDescription": "PART LOT 17 PLAN 305 DESIGNATED AS PARTS 5, 6, 7 & 8 PLAN 62R20492 SUBJECT TO AN EASEMENT OVER PART 5 PLAN 62R20492 IN FAVOUR OF PARTS 3 & 4 PLAN 62R20492 AS IN WE1198880 TOGETHER WITH AN EASEMENT OVER PART 4 PLAN 62R20492 AS IN WE1198880 CITY OF HAMILTON" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2% +HST" +"TransactionType": "For Sale" +"Utilities": array:1 [ 0 => "Yes" ] +"Zoning": "JJ (Light Industrial)" +"Rail": "No" +"DDFYN": true +"Water": "Municipal" +"LotType": "Building" +"TaxType": "Annual" +"HeatType": "Gas Forced Air Closed" +"LotDepth": 235.0 +"LotWidth": 7.84 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12184280')" +"GarageType": "Outside/Surface" +"RetailArea": 1500.0 +"RollNumber": "251803025101212" +"PropertyUse": "Free Standing" +"HoldoverDays": 30 +"ListPriceUnit": "For Sale" +"ParkingSpaces": 5 +"provider_name": "TRREB" +"ContractStatus": "Available" +"FreestandingYN": true +"HSTApplication": array:1 [ 0 => "Included In" ] +"IndustrialArea": 3000.0 +"PossessionDate": "2025-07-01" +"PossessionType": "Flexible" +"PriorMlsStatus": "New" +"RetailAreaCode": "Sq Ft" +"WashroomsType1": 2 +"ClearHeightFeet": 8 +"SalesBrochureUrl": "https://1drv.ms/b/c/46a63702ea396861/EYQH0XWlf4BBtsvi Ck1AONo BPFky JPp5Ae RXv Jr ACmvcf A?e=Cgr Dom" +"LotIrregularities": "Flag Shaped" +"IndustrialAreaCode": "Sq Ft" +"OfficeApartmentArea": 1200.0 +"ShowingAppointments": "Broker Bay" +"MediaChangeTimestamp": "2025-05-30T14:41:54Z" +"OfficeApartmentAreaUnit": "Sq Ft" +"SystemModificationTimestamp": "2025-06-14T17:21:23.34021Z" +"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] ] } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14429 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12220071" +"ListingId": "X12220071" +"PropertyType": "Residential" +"PropertySubType": "Rural Residential" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-14T16:30:04Z" +"RFModificationTimestamp": "2025-06-14T16:35:26.679355+00:00" +"ListPrice": 799000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0.995 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L0R 1W0" +"UnparsedAddress": "1645 Glancaster Road, Hamilton, ON L0R 1W0" +"Coordinates": array:2 [ 0 => -79.9448388 1 => 43.1706544 ] +"Latitude": 43.1706544 +"Longitude": -79.9448388 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX REAL ESTATE CENTRE INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Beautiful Warm Country home nestled on almost a acre of prestige country living with your own private buffer forest with fantastic country views and private living outside huge back yard for kids to play .Parking for a RV / TRAILER and some . Garage is one car with attached rear room with separate man door entrance and window ,Great for hobbies, work shop or artist den or turn into entertainment area using window as serving window for guests. Let your own imagination make the adjustments to your own tastes and pleasures. Excellent starter home for family gatherings and enjoyable bomb fires in the fire pit in rear yard and surrounded by nature's finest . Absolutely stunning updates with new roof,90% of windows ,basement weeping tile and bubble wrap and drainage , furnace, hot water heater ,both bathrooms and All new appliances and much much more!! Excellent opportunity for a place to call home after a long day in the city working. See out of town directions below; DIRECTIONS :Q.E.W. / 403 TOWARDS HAMILTON , ONTARIO TO ANCASTER THEN ENTER HWY 6 SOUTH TO BOOK RD., GO WEST (RIGHT), TO FIDDLERS GREEN RD., ANCASTER ,TURN LEFT (SOUTH), GO TO BUTTER ROAD ,TURN LEFT (EAST ) ,TO GLANCASTER ROAD # 1645." +"AccessibilityFeatures": array:3 [ 0 => "Multiple Entrances" 1 => "Other" 2 => "Parking" ] +"ArchitecturalStyle": array:1 [ 0 => "Bungalow-Raised" ] +"Basement": array:2 [ 0 => "Finished with Walk-Out" 1 => "Full" ] +"CityRegion": "Ancaster" +"ConstructionMaterials": array:2 [ 0 => "Brick" 1 => "Other" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CountyOrParish": "Hamilton" +"CoveredSpaces": "1.0" +"CreationDate": "2025-06-13T22:19:57.108567+00:00" +"CrossStreet": "BUTTER ROAD AND GLANCASTER ROAD" +"DirectionFaces": "East" +"Directions": "HWY 6 SOUTH TO BOOK RD., GO WEST (RIGHT), TO FIDDLERS GREEN RD., ANCASTER ,TURN LEFT (SOUTH), GO TO BUTTER ROAD ,TURN LEFT (EAST ) ,TO GLANCASTER ROAD # 1645." +"Exclusions": "NIL" +"ExpirationDate": "2025-09-17" +"ExteriorFeatures": array:2 [ 0 => "Deck" 1 => "Year Round Living" ] +"FoundationDetails": array:3 [ 0 => "Block" 1 => "Brick" 2 => "Concrete" ] +"GarageYN": true +"Inclusions": "FRIDGE,STOVE,COOKING HOOD FAN , DISHWASHER." +"InteriorFeatures": array:5 [ 0 => "Carpet Free" 1 => "Propane Tank" 2 => "Storage" 3 => "Water Heater" 4 => "Water Treatment" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-06-08" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "079800" +"MajorChangeTimestamp": "2025-06-13T19:48:31Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-06-13T19:48:31Z" +"OriginalListPrice": 799000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2560682" +"ParcelNumber": "173990212" +"ParkingFeatures": array:2 [ 0 => "Private Triple" 1 => "RV/Truck" ] +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2025-06-13T19:48:32Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"SeniorCommunityYN": true +"Sewer": array:1 [ 0 => "Septic" ] +"ShowingRequirements": array:3 [ 0 => "Lockbox" 1 => "See Brokerage Remarks" 2 => "List Brokerage" ] +"SignOnPropertyYN": true +"SoilType": array:3 [ 0 => "Sandy Loam" 1 => "Loam" 2 => "Mixed" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Glancaster" +"StreetNumber": "1645" +"StreetSuffix": "Road" +"TaxAnnualAmount": "3995.0" +"TaxAssessedValue": 385000 +"TaxLegalDescription": "PT LT 1 CON 4 GLANFORD PART 1 , 62R12264; CITY OF HAMILTON" +"TaxYear": "2025" +"Topography": array:5 [ 0 => "Flat" 1 => "Hillside" 2 => "Hilly" 3 => "Rolling" 4 => "Sloping" ] +"TransactionBrokerCompensation": "2% + hst" +"TransactionType": "For Sale" +"View": array:4 [ 0 => "Forest" 1 => "Hills" 2 => "Panoramic" 3 => "Trees/Woods" ] +"VirtualTourURLBranded": "https://www.myvisualliustings.com/vt/356727" +"VirtualTourURLUnbranded": "https://www.myvisualliustings.com/vtnb/356727" +"WaterSource": array:4 [ 0 => "Drilled Well" 1 => "Iron/Mineral Filter" 2 => "Sediment Filter" 3 => "Water System" ] +"Zoning": "SINGLE FAMILY RESIDENTIAL" +"UFFI": "No" +"DDFYN": true +"Water": "Well" +"GasYNA": "No" +"CableYNA": "Available" +"HeatType": "Forced Air" +"LotDepth": 576.55 +"LotWidth": 75.16 +"SewerYNA": "No" +"WaterYNA": "No" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12220071')" +"GarageType": "Attached" +"HeatSource": "Propane" +"RollNumber": "251890231001400" +"SurveyType": "None" +"Waterfront": array:1 [ 0 => "None" ] +"ElectricYNA": "Yes" +"RentalItems": "2 OUTSIDE PROPANE TANKS 96$ EACH/YEAR- RENTAL - 2025" +"HoldoverDays": 120 +"LaundryLevel": "Lower Level" +"TelephoneYNA": "Available" +"KitchensTotal": 1 +"ParkingSpaces": 3 +"UnderContract": array:1 [ 0 => "None" ] +"provider_name": "TRREB" +"ApproximateAge": "51-99" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "In Addition To" ] +"PossessionType": "Immediate" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"DenFamilyroomYN": true +"LivingAreaRange": "1100-1500" +"RoomsAboveGrade": 10 +"LotSizeAreaUnits": "Acres" +"PropertyFeatures": array:6 [ 0 => "Arts Centre" 1 => "Campground" 2 => "Golf" 3 => "Greenbelt/Conservation" 4 => "Hospital" 5 => "Lake/Pond" ] +"LocalImprovements": true +"LotSizeRangeAcres": ".50-1.99" +"PossessionDetails": "Immediate" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 3 +"BedroomsAboveGrade": 2 +"BedroomsBelowGrade": 2 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"LeaseToOwnEquipment": array:1 [ 0 => "None" ] +"ShowingAppointments": "HWY 6 SOUTH TO BOOK RD., GO WEST (RIGHT), TO FIDDLERS GREEN RD., ANCASTER ,TURN LEFT (SOUTH), GO TO BUTTER ROAD ,TURN LEFT (EAST ) ,TO GLANCASTER ROAD # 16" +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Basement" +"MediaChangeTimestamp": "2025-06-13T19:48:32Z" +"LocalImprovementsComments": "AIRPORT AND MAJOR TRANSPORTATION AREA" +"SystemModificationTimestamp": "2025-06-14T16:30:07.401975Z" +"Media": array:45 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] 31 => array:26 [ …26] 32 => array:26 [ …26] 33 => array:26 [ …26] 34 => array:26 [ …26] 35 => array:26 [ …26] 36 => array:26 [ …26] 37 => array:26 [ …26] 38 => array:26 [ …26] 39 => array:26 [ …26] 40 => array:26 [ …26] 41 => array:26 [ …26] 42 => array:26 [ …26] 43 => array:26 [ …26] 44 => array:26 [ …26] ] } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14428 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12211868" +"ListingId": "X12211868" +"PropertyType": "Residential" +"PropertySubType": "Condo Townhouse" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-14T16:00:41Z" +"RFModificationTimestamp": "2025-06-14T16:05:47.360708+00:00" +"ListPrice": 499900.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8E 1C8" +"UnparsedAddress": "8 Glenburn Court, Hamilton, ON L8E 1C8" +"Coordinates": array:2 [ 0 => -79.7590282 1 => 43.2284677 ] +"Latitude": 43.2284677 +"Longitude": -79.7590282 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Right At Home Realty, Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to the thriving community of Riverdale West! This gorgeous, renovated 3 bedroom, 3-bathroom condo townhouse is ideal for first time buyers looking for move-in ready. Loads of natural light on the main level welcomes you through the living area and into the elegant, white kitchen; its super spacious with beautiful stainless appliances and tons of storage space, large enough for a good-sized kitchen table and 4 chairs. Upstairs you'll find 3 bedrooms with a fully renovated 3-piece main bathroom. More to come in the finished basement, which features a secondary studio suite with a mini kitchenette and 3-piece bathroom, perfect for guests, friends, or family to stay! Rounding out the home is the lovely private backyard, fully fenced with a lockable gate and an assigned parking space in the parking lot. The 2025 renovation includes new paint throughout, new wood railing on main staircase, new light fixtures on main and second level, and new drop ceiling and pot lights in basement. In addition, renovated main floor and second floor bathrooms (2023), updated kitchen and new flooring (2022), and new laminate flooring on the second level (2018). Nothing left to do, just move in and enjoy! In addition to the usuals the condo fee includes water, cable TV, and internet, a great savings! Ideally located near all amenities. Eastgate Square shopping centre just a few minutes walk, close to restaurants, schools, and parks, and just a few minutes driving to Red Hill Valley Parkway for easy commuting. Hurry in, this beauty wont last!" +"ArchitecturalStyle": array:1 [ 0 => "2-Storey" ] +"AssociationAmenities": array:2 [ 0 => "BBQs Allowed" 1 => "Visitor Parking" ] +"AssociationFee": "600.0" +"AssociationFeeIncludes": array:5 [ 0 => "Cable TV Included" 1 => "Parking Included" 2 => "Water Included" 3 => "Building Insurance Included" 4 => "Common Elements Included" ] +"AssociationYN": true +"Basement": array:1 [ 0 => "Finished" ] +"CityRegion": "Riverdale" +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2025-06-11T13:01:13.448784+00:00" +"CrossStreet": "Riverdale & Glenburn Crt" +"Directions": "Queenston Rd to Riverdale, right on Glenburn." +"Exclusions": "Window covering in living area (staging)." +"ExpirationDate": "2025-09-30" +"HeatingYN": true +"Inclusions": "Refrigerator, Stove, Dishwasher, Built-in Microwave, all ELF's." +"InteriorFeatures": array:1 [ 0 => "In-Law Suite" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:2 [ 0 => "Washer Hookup" 1 => "Electric Dryer Hookup" ] +"ListAOR": "Oakville, Milton & District Real Estate Board" +"ListingContractDate": "2025-06-11" +"MainLevelBathrooms": 1 +"MainOfficeKey": "540200" +"MajorChangeTimestamp": "2025-06-11T12:55:08Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-06-11T12:55:08Z" +"OriginalListPrice": 499900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2526388" +"ParcelNumber": "180130010" +"ParkingFeatures": array:1 [ 0 => "Other" ] +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ 0 => "Restricted" ] +"PhotosChangeTimestamp": "2025-06-12T12:45:55Z" +"PropertyAttachedYN": true +"RoomsTotal": "9" +"ShowingRequirements": array:4 [ 0 => "Lockbox" 1 => "See Brokerage Remarks" 2 => "Showing System" 3 => "List Brokerage" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Glenburn" +"StreetNumber": "8" +"StreetSuffix": "Court" +"TaxAnnualAmount": "2164.33" +"TaxAssessedValue": 152000 +"TaxBookNumber": "251805046303410" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2.0% + HST with thanks!" +"TransactionType": "For Sale" +"VirtualTourURLBranded": "https://youtu.be/r7Fo9Ypbi Ck" +"VirtualTourURLUnbranded": "https://youtu.be/BGYe HW-Mdno" +"Zoning": "De/S-185" +"UFFI": "No" +"DDFYN": true +"Locker": "None" +"Exposure": "North" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12211868')" +"PictureYN": true +"GarageType": "None" +"HeatSource": "Gas" +"RollNumber": "251805046303411" +"SurveyType": "Unknown" +"BalconyType": "None" +"RentalItems": "Furnace, AC & HWT" +"HoldoverDays": 90 +"LaundryLevel": "Lower Level" +"LegalStories": "1" +"ParkingSpot1": "8" +"ParkingType1": "Exclusive" +"KitchensTotal": 1 +"ParkingSpaces": 1 +"UnderContract": array:2 [ 0 => "Hot Water Tank-Gas" 1 => "Air Conditioner" ] +"provider_name": "TRREB" +"ApproximateAge": "51-99" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included In" ] +"PossessionDate": "2025-06-30" +"PossessionType": "Immediate" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"CondoCorpNumber": 13 +"DenFamilyroomYN": true +"LivingAreaRange": "1000-1199" +"RoomsAboveGrade": 9 +"PropertyFeatures": array:6 [ 0 => "Fenced Yard" 1 => "Hospital" 2 => "Park" 3 => "Public Transit" 4 => "School" 5 => "School Bus Route" ] +"SalesBrochureUrl": "https://www.danagain.com/buyers/brochures/8-glenburn-court-1-2" +"SquareFootSource": "MPAC" +"StreetSuffixCode": "Crt" +"BoardPropertyType": "Condo" +"ParkingLevelUnit1": "1" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 3 +"WashroomsType3Pcs": 3 +"BedroomsAboveGrade": 3 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"StatusCertificateYN": true +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"WashroomsType3Level": "Basement" +"LegalApartmentNumber": "9" +"MediaChangeTimestamp": "2025-06-12T12:45:55Z" +"DevelopmentChargesPaid": array:1 [ 0 => "Unknown" ] +"MLSAreaDistrictOldZone": "X14" +"PropertyManagementCompany": "Wilson Blanchard" +"MLSAreaMunicipalityDistrict": "Hamilton" +"SystemModificationTimestamp": "2025-06-14T16:00:44.065898Z" +"Media": array:39 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] 31 => array:26 [ …26] 32 => array:26 [ …26] 33 => array:26 [ …26] 34 => array:26 [ …26] 35 => array:26 [ …26] 36 => array:26 [ …26] 37 => array:26 [ …26] 38 => array:26 [ …26] ] } ] +success: true +page_size: 10 +page_count: 396 +count: 3954 +after_key: "" } ] ]
