Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#21670 +post_id: "205842" +post_author: 1 +"ListingKey": "29004213" +"ListingId": "40764307" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-10-17T21:25:19Z" +"RFModificationTimestamp": "2025-10-17T21:27:16Z" +"ListPrice": 750000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1079.0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8W1G1" +"UnparsedAddress": "24 QUEENSLEA Drive, Hamilton, Ontario L8W1G1" +"Coordinates": array:2 [ 0 => -79.841189 1 => 43.205945 ] +"Latitude": 43.205945 +"Longitude": -79.841189 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Welcome to 24 Queenslea Drive – a move-in ready backsplit nestled in a family-friendly neighbourhood on Hamilton Mountain. This home offers a fantastic location close to the Linc and Redhill Expressway, schools, shopping, and all amenities. Step inside to discover a bright, updated white kitchen and a spacious open-concept living and dining area – perfect for entertaining. Upstairs, you’ll find three generously sized bedrooms along with an updated 4-piece main bath. The finished basement adds valuable living space with a modern 3-piece bathroom and plenty of storage. Step outside to your own backyard retreat featuring a stunning in-ground pool, ideal for summer enjoyment. The fully fenced yard provides both privacy and security. Key updates include: hot tub (2025), pool liner (2019), updated pool pump line & sand filter (2025), robot pool cleaner (2025), electrical upgraded (2024/2025), furnace (2019), kitchen & main bath counters (2022), basement bath (2022), front porch with composite decking (2022), flooring throughout (2018 & 2022), front fence & side gate (2025), fully wired security system with exterior security cameras (2025). With numerous updates and upgrades already completed, all that’s left to do is move in and enjoy. (id:62650)" +"Appliances": array:7 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Hot Tub" 3 => "Dishwasher" 4 => "Stove" 5 => "Dryer" 6 => "Hood Fan" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Partial" ] +"CommunityFeatures": array:1 [ 0 => "School Bus" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2025-10-17T21:27:00.572213+00:00" +"Directions": "Located between Upper Gage & Upper Ottawa" +"ExteriorFeatures": array:2 [ 0 => "Brick" 1 => "Vinyl siding" ] +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1525305" +"ListOfficeKey": "55061" +"LivingAreaUnits": "square feet" +"LotFeatures": array:1 [ 0 => "Paved driveway" ] +"PhotosChangeTimestamp": "2025-10-17T20:32:38Z" +"PhotosCount": 17 +"PoolFeatures": array:1 [ 0 => "Inground pool" ] +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2025-10-17T21:10:50Z" +"StreetName": "QUEENSLEA" +"StreetNumber": "24" +"StreetSuffix": "Drive" +"SubdivisionName": "262 - Quinndale" +"TaxAnnualAmount": "4599" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:11 [ 0 => array:11 [ "RoomKey" => "1517249664" "RoomType" => "Storage" "ListingId" => "40764307" "RoomLevel" => "Basement" "RoomWidth" => null "ListingKey" => "29004213" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-10-17T21:10:50.17Z" ] 1 => array:11 [ "RoomKey" => "1517249665" "RoomType" => "Laundry room" "ListingId" => "40764307" "RoomLevel" => "Lower level" "RoomWidth" => null "ListingKey" => "29004213" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-10-17T21:10:50.17Z" ] 2 => array:11 [ "RoomKey" => "1517249666" "RoomType" => "3pc Bathroom" "ListingId" => "40764307" "RoomLevel" => "Lower level" "RoomWidth" => null "ListingKey" => "29004213" "RoomLength" => null "RoomDimensions" => "10'10'' x 7'5''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-10-17T21:10:50.17Z" ] 3 => array:11 [ "RoomKey" => "1517249667" "RoomType" => "Den" "ListingId" => "40764307" "RoomLevel" => "Lower level" "RoomWidth" => null "ListingKey" => "29004213" "RoomLength" => null "RoomDimensions" => "7'9'' x 7'8''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-10-17T21:10:50.17Z" ] 4 => array:11 [ "RoomKey" => "1517249668" "RoomType" => "Family room" "ListingId" => "40764307" "RoomLevel" => "Lower level" "RoomWidth" => null "ListingKey" => "29004213" "RoomLength" => null "RoomDimensions" => "20'5'' x 10'0''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-10-17T21:10:50.17Z" ] 5 => array:11 [ "RoomKey" => "1517249669" "RoomType" => "4pc Bathroom" "ListingId" => "40764307" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29004213" "RoomLength" => null "RoomDimensions" => "5' x 9'7''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-10-17T21:10:50.18Z" ] 6 => array:11 [ "RoomKey" => "1517249670" "RoomType" => "Primary Bedroom" "ListingId" => "40764307" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29004213" "RoomLength" => null "RoomDimensions" => "9'11'' x 15'11''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-10-17T21:10:50.18Z" ] 7 => array:11 [ "RoomKey" => "1517249671" "RoomType" => "Bedroom" "ListingId" => "40764307" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29004213" "RoomLength" => null "RoomDimensions" => "9'8'' x 10'2''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-10-17T21:10:50.18Z" ] 8 => array:11 [ "RoomKey" => "1517249672" "RoomType" => "Bedroom" "ListingId" => "40764307" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29004213" "RoomLength" => null "RoomDimensions" => "13'0'' x 10'10''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-10-17T21:10:50.18Z" ] 9 => array:11 [ "RoomKey" => "1517249673" "RoomType" => "Kitchen" "ListingId" => "40764307" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29004213" "RoomLength" => null "RoomDimensions" => "15'0'' x 11'4''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-10-17T21:10:50.18Z" ] 10 => array:11 [ "RoomKey" => "1517249674" "RoomType" => "Living room/Dining room" "ListingId" => "40764307" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29004213" "RoomLength" => null "RoomDimensions" => "11'8'' x 21'0''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-10-17T21:10:50.18Z" ] ] +"ListAOR": "Cornerstone - Hamilton-Burlington" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29004213/24-queenslea-drive-hamilton" +"ParkingTotal": 2 +"StructureType": array:1 [ 0 => "House" ] +"CoListAgentKey": "1643024" +"CommonInterest": "Freehold" +"CoListOfficeKey": "55061" +"ZoningDescription": "C" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 54.0 +"AboveGradeFinishedArea": 1079 +"OriginalEntryTimestamp": "2025-10-17T20:32:38.2Z" +"MapCoordinateVerifiedYN": true +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Listing Brokerage" +"Media": array:17 [ 0 => array:13 [ "Order" => 0 "MediaKey" => "6252279475" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29004213/3c4dbf2270bc94c9cb09eaa7ab6b9a04.webp" "MediaSize" => 166911 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29004213/thumbnail-3c4dbf2270bc94c9cb09eaa7ab6b9a04.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => true "ResourceRecordId" => "40764307" "ResourceRecordKey" => "29004213" "ModificationTimestamp" => "2025-10-17T20:32:38.22Z" ] 1 => array:13 [ "Order" => 1 "MediaKey" => "6252279584" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29004213/fe085b47adc06ff5942d1b430548b08b.webp" "MediaSize" => 89126 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29004213/thumbnail-fe085b47adc06ff5942d1b430548b08b.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40764307" "ResourceRecordKey" => "29004213" "ModificationTimestamp" => "2025-10-17T20:32:38.22Z" ] 2 => array:13 [ "Order" => 2 "MediaKey" => "6252279621" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29004213/00e927bdb615d963a6a5608dfcf172c4.webp" "MediaSize" => 104151 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29004213/thumbnail-00e927bdb615d963a6a5608dfcf172c4.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40764307" "ResourceRecordKey" => "29004213" "ModificationTimestamp" => "2025-10-17T20:32:38.22Z" ] 3 => array:13 [ "Order" => 3 "MediaKey" => "6252279724" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29004213/c35d547f48c05f13c920ab0d284455d0.webp" "MediaSize" => 61351 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29004213/thumbnail-c35d547f48c05f13c920ab0d284455d0.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40764307" "ResourceRecordKey" => "29004213" "ModificationTimestamp" => "2025-10-17T20:32:38.22Z" ] 4 => array:13 [ "Order" => 4 "MediaKey" => "6252279775" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29004213/c09748e4d423f0843075f6949f1d1b61.webp" "MediaSize" => 61922 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29004213/thumbnail-c09748e4d423f0843075f6949f1d1b61.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40764307" "ResourceRecordKey" => "29004213" "ModificationTimestamp" => "2025-10-17T20:32:38.22Z" ] 5 => array:13 [ "Order" => 5 "MediaKey" => "6252279866" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29004213/f53ee4de03a0834b92156bcc57b4289d.webp" "MediaSize" => 72455 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29004213/thumbnail-f53ee4de03a0834b92156bcc57b4289d.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40764307" "ResourceRecordKey" => "29004213" "ModificationTimestamp" => "2025-10-17T20:32:38.22Z" ] 6 => array:13 [ "Order" => 6 "MediaKey" => "6252279963" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29004213/54b2b0b446a9065c91f5afa2363b4b4a.webp" "MediaSize" => 103188 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29004213/thumbnail-54b2b0b446a9065c91f5afa2363b4b4a.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40764307" "ResourceRecordKey" => "29004213" "ModificationTimestamp" => "2025-10-17T20:32:38.22Z" ] 7 => array:13 [ "Order" => 7 "MediaKey" => "6252280061" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29004213/7d1fb72d1b00271086885ac4573502f4.webp" "MediaSize" => 77886 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29004213/thumbnail-7d1fb72d1b00271086885ac4573502f4.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40764307" "ResourceRecordKey" => "29004213" "ModificationTimestamp" => "2025-10-17T20:32:38.22Z" ] 8 => array:13 [ "Order" => 8 "MediaKey" => "6252280077" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29004213/2c83e9d7df0940b88f604b41fe1b73f0.webp" "MediaSize" => 73524 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29004213/thumbnail-2c83e9d7df0940b88f604b41fe1b73f0.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40764307" "ResourceRecordKey" => "29004213" "ModificationTimestamp" => "2025-10-17T20:32:38.22Z" ] 9 => array:13 [ "Order" => 9 "MediaKey" => "6252280218" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29004213/b569f2b71dbd7aafdd74fbe4493269c5.webp" "MediaSize" => 26859 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29004213/thumbnail-b569f2b71dbd7aafdd74fbe4493269c5.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40764307" "ResourceRecordKey" => "29004213" "ModificationTimestamp" => "2025-10-17T20:32:38.22Z" ] 10 => array:13 [ "Order" => 10 "MediaKey" => "6252280263" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29004213/64b8b4925d2d1b0d25771b4a865f744e.webp" "MediaSize" => 72600 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29004213/thumbnail-64b8b4925d2d1b0d25771b4a865f744e.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40764307" "ResourceRecordKey" => "29004213" "ModificationTimestamp" => "2025-10-17T20:32:38.22Z" ] 11 => array:13 [ "Order" => 11 "MediaKey" => "6252280352" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29004213/cf7a36394f1242124c17391831adff19.webp" "MediaSize" => 89581 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29004213/thumbnail-cf7a36394f1242124c17391831adff19.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40764307" "ResourceRecordKey" => "29004213" "ModificationTimestamp" => "2025-10-17T20:32:38.22Z" ] 12 => array:13 [ "Order" => 12 "MediaKey" => "6252280437" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29004213/5c5c6de8f03e648457abe435d09677cf.webp" "MediaSize" => 122832 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29004213/thumbnail-5c5c6de8f03e648457abe435d09677cf.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40764307" "ResourceRecordKey" => "29004213" "ModificationTimestamp" => "2025-10-17T20:32:38.22Z" ] 13 => array:13 [ "Order" => 13 "MediaKey" => "6252280539" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29004213/304d394f0d3d97c983c15dcc3cd3061a.webp" "MediaSize" => 120126 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29004213/thumbnail-304d394f0d3d97c983c15dcc3cd3061a.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40764307" "ResourceRecordKey" => "29004213" "ModificationTimestamp" => "2025-10-17T20:32:38.22Z" ] 14 => array:13 [ "Order" => 14 "MediaKey" => "6252280611" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29004213/fbfa96507ed1c68f21dcdf17261d6635.webp" "MediaSize" => 113241 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29004213/thumbnail-fbfa96507ed1c68f21dcdf17261d6635.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40764307" "ResourceRecordKey" => "29004213" "ModificationTimestamp" => "2025-10-17T20:32:38.22Z" ] 15 => array:13 [ "Order" => 15 "MediaKey" => "6252280664" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29004213/80b478308051f7924af6c202be990f1e.webp" "MediaSize" => 85607 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29004213/thumbnail-80b478308051f7924af6c202be990f1e.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40764307" "ResourceRecordKey" => "29004213" "ModificationTimestamp" => "2025-10-17T20:32:38.22Z" ] 16 => array:13 [ "Order" => 16 "MediaKey" => "6252280693" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29004213/5a1ed8922e096df8b6fef09300404b9d.webp" "MediaSize" => 152770 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29004213/thumbnail-5a1ed8922e096df8b6fef09300404b9d.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40764307" "ResourceRecordKey" => "29004213" "ModificationTimestamp" => "2025-10-17T20:32:38.22Z" ] ] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29004213')" +"ID": "205842" }