4155 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: 6a8acb3b7877f9ae439dc431345739ba4c37e3bafbb756e4943c57a8f08b237a" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#14484 +items: array:10 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14649 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12305210" +"ListingId": "X12305210" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-25T20:17:44Z" +"RFModificationTimestamp": "2025-07-25T20:45:43Z" +"ListPrice": 6999000.0 +"BathroomsTotalInteger": 7.0 +"BathroomsHalf": 0 +"BedroomsTotal": 6.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L0R 1V0" +"UnparsedAddress": "1046 Concession 6 Road W, Hamilton, ON L0R 1V0" +"Coordinates": array:2 [ 0 => -80.0688153 1 => 43.4098635 ] +"Latitude": 43.4098635 +"Longitude": -80.0688153 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "SAM MCDADI REAL ESTATE INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to a rare 98-acre estate that seamlessly blends luxury living, natural beauty, and income-generating infrastructure, supported by two separate deeds. Whether you're envisioning a family compound, business expansion, or long-term investment, this versatile property delivers the scale, zoning, and revenue potential to bring your goals to life. At the heart of the estate is a newly renovated, custom-built two-storey residence with loft, offering over 5,500 sq ft of refined living space. Designed for both elegance and practicality, it features 6-spacious bedrooms and 7-bathrooms, perfect for multi-generational living or large-scale entertaining. The fully finished walkout basement includes a private entrance, full bath, and kitchenette ideal for guests, in-laws, or a rental suite. Surrounding the home are rolling meadows, mature forests, trails, and a peaceful pond offering unmatched privacy and a strong connection to nature. What truly sets this estate apart is over 45,000 sq ft of indoor infrastructure: nine barns, 175 stalls, 31 paddocks, and two professionally built Standardbred training tracks. This operational facility supports a dedicated client base and offers immediate revenue with room to grow, perfect for entrepreneurs or investors. The inclusion of dual deeds offer rare flexibility for future subdivision, development, or generational planing. Zoned P8, P7, and A2, the property supports a wide range of uses, including equestrian operations, agriculture, storage, events, and retreats. A unique opportunity to own a property that delivers on lifestyle, business, and investment all under two titles. A once-in-a-generation estate that must be seen to be truly appreciated." +"ArchitecturalStyle": array:1 [ 0 => "2 1/2 Storey" ] +"Basement": array:2 [ 0 => "Finished with Walk-Out" 1 => "Full" ] +"CityRegion": "Rural Flamborough" +"ConstructionMaterials": array:2 [ 0 => "Brick" 1 => "Stucco (Plaster)" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2025-07-24T17:21:18.951678+00:00" +"CrossStreet": "Conc Rd 6 W/Middletown Rd" +"DirectionFaces": "South" +"Directions": "Via Concession 6, head south on Brock Rd toward Concession Rd 6 W, then turn right at the first cross street onto Concession Rd. Destination will be on the left." +"Exclusions": "All barn materials are not included, however, are negotiable." +"ExpirationDate": "2025-10-18" +"ExteriorFeatures": array:1 [ 0 => "Privacy" ] +"FireplaceFeatures": array:2 [ 0 => "Electric" 1 => "Natural Gas" ] +"FireplaceYN": true +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Inclusions": "For a comprehensive list of inclusions, please download attached feature sheet." +"InteriorFeatures": array:3 [ 0 => "Built-In Oven" 1 => "Storage" 2 => "Water Heater" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-07-24" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "193800" +"MajorChangeTimestamp": "2025-07-24T16:43:54Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-07-24T16:43:54Z" +"OriginalListPrice": 6999000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2745470" +"OtherStructures": array:2 [ 0 => "Barn" 1 => "Box Stall" ] +"ParcelNumber": "175430014" +"ParkingFeatures": array:1 [ 0 => "Circular Drive" ] +"ParkingTotal": "8.0" +"PhotosChangeTimestamp": "2025-07-24T17:36:28Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"SecurityFeatures": array:1 [ 0 => "Carbon Monoxide Detectors" ] +"Sewer": array:1 [ 0 => "Septic" ] +"ShowingRequirements": array:2 [ 0 => "Showing System" 1 => "List Brokerage" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "W" +"StreetName": "Concession 6" +"StreetNumber": "1046" +"StreetSuffix": "Road" +"TaxAnnualAmount": "15269.72" +"TaxLegalDescription": "PT LT 3, CON 5 WEST FLAMBOROUGH , PART 2 , 62R1166 ; FLAMBOROUGH CITY OF HAMILTON" +"TaxYear": "2024" +"Topography": array:2 [ 0 => "Wooded/Treed" 1 => "Flat" ] +"TransactionBrokerCompensation": "2.5% + Applicable HST" +"TransactionType": "For Sale" +"View": array:4 [ 0 => "Panoramic" 1 => "Trees/Woods" 2 => "Pond" 3 => "Park/Greenbelt" ] +"VirtualTourURLUnbranded": "https://vimeo.com/1015326514" +"VirtualTourURLUnbranded2": "https://unbranded.youriguide.com/1046_concession_rd_6_w_hamilton_on/" +"WaterSource": array:1 [ 0 => "Dug Well" ] +"Zoning": "P8, P7, A2" +"DDFYN": true +"Water": "Well" +"GasYNA": "Available" +"CableYNA": "Yes" +"HeatType": "Forced Air" +"LotDepth": 3161.53 +"LotWidth": 682.5 +"SewerYNA": "Available" +"WaterYNA": "Available" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12305210')" +"GarageType": "None" +"HeatSource": "Propane" +"RollNumber": "251830251000600" +"SurveyType": "None" +"ElectricYNA": "Yes" +"HoldoverDays": 90 +"TelephoneYNA": "Yes" +"KitchensTotal": 2 +"ParkingSpaces": 8 +"provider_name": "TRREB" +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included In" ] +"PossessionType": "Other" +"PriorMlsStatus": "Draft" +"WashroomsType1": 4 +"WashroomsType2": 1 +"WashroomsType3": 2 +"DenFamilyroomYN": true +"LivingAreaRange": "5000 +" +"RoomsAboveGrade": 12 +"RoomsBelowGrade": 4 +"PropertyFeatures": array:6 [ 0 => "Wooded/Treed" 1 => "Lake/Pond" 2 => "School" 3 => "Golf" 4 => "Greenbelt/Conservation" 5 => "Rec./Commun.Centre" ] +"LotSizeRangeAcres": "50-99.99" +"PossessionDetails": "60/90/TBA" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 3 +"WashroomsType3Pcs": 4 +"BedroomsAboveGrade": 5 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"KitchensBelowGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"MediaChangeTimestamp": "2025-07-24T17:36:28Z" +"SystemModificationTimestamp": "2025-07-25T20:17:46.645934Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:40 [ 0 => array:26 [ "Order" => 0 "ImageOf" => null "MediaKey" => "261d7e67-445b-4af0-862c-ebd12125b447" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12305210/f1042e6ec400f96590ea0de07ddec993.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 1805751 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12305210/thumbnail-f1042e6ec400f96590ea0de07ddec993.webp" "ImageWidth" => 3840 "Permission" => array:1 [ …1] "ImageHeight" => 2880 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "261d7e67-445b-4af0-862c-ebd12125b447" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => true "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12305210" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "261d7e67-445b-4af0-862c-ebd12125b447" "ModificationTimestamp" => "2025-07-24T16:43:54.019781Z" "MediaModificationTimestamp" => "2025-07-24T16:43:54.019781Z" ] 1 => array:26 [ "Order" => 1 "ImageOf" => null "MediaKey" => "3cd50b86-007c-433a-971e-63449f48703e" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12305210/8269224fb17f8e3677631e99094c079f.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 1466461 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12305210/thumbnail-8269224fb17f8e3677631e99094c079f.webp" "ImageWidth" => 4000 "Permission" => array:1 [ …1] "ImageHeight" => 3000 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "3cd50b86-007c-433a-971e-63449f48703e" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12305210" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "3cd50b86-007c-433a-971e-63449f48703e" "ModificationTimestamp" => "2025-07-24T16:43:54.019781Z" "MediaModificationTimestamp" => "2025-07-24T16:43:54.019781Z" ] 2 => array:26 [ "Order" => 2 "ImageOf" => null "MediaKey" => "e570a3a8-bd79-4c74-a6ab-2226ed988e38" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12305210/d893982be24104b84410d6101c54b367.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 986995 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12305210/thumbnail-d893982be24104b84410d6101c54b367.webp" "ImageWidth" => 3840 "Permission" => array:1 [ …1] "ImageHeight" => 2560 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "e570a3a8-bd79-4c74-a6ab-2226ed988e38" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12305210" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "e570a3a8-bd79-4c74-a6ab-2226ed988e38" "ModificationTimestamp" => "2025-07-24T16:43:54.019781Z" "MediaModificationTimestamp" => "2025-07-24T16:43:54.019781Z" ] 3 => array:26 [ "Order" => 3 "ImageOf" => null "MediaKey" => "c97ef5f2-293e-476d-97cd-ae2dd43f347b" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12305210/b71e7b02f486472b72f1a31e54500f71.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 880809 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12305210/thumbnail-b71e7b02f486472b72f1a31e54500f71.webp" "ImageWidth" => 3840 "Permission" => array:1 [ …1] "ImageHeight" => 2560 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "c97ef5f2-293e-476d-97cd-ae2dd43f347b" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12305210" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "c97ef5f2-293e-476d-97cd-ae2dd43f347b" "ModificationTimestamp" => "2025-07-24T16:43:54.019781Z" "MediaModificationTimestamp" => "2025-07-24T16:43:54.019781Z" ] 4 => array:26 [ "Order" => 4 "ImageOf" => null "MediaKey" => "21c895a9-4305-48ee-a69b-5fca861ac442" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12305210/9f032ae8200aa1b0f35dee428e6bc706.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 1056841 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12305210/thumbnail-9f032ae8200aa1b0f35dee428e6bc706.webp" "ImageWidth" => 3840 "Permission" => array:1 [ …1] "ImageHeight" => 2560 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "21c895a9-4305-48ee-a69b-5fca861ac442" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12305210" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "21c895a9-4305-48ee-a69b-5fca861ac442" "ModificationTimestamp" => "2025-07-24T16:43:54.019781Z" "MediaModificationTimestamp" => "2025-07-24T16:43:54.019781Z" ] 5 => array:26 [ "Order" => 5 "ImageOf" => null "MediaKey" => "614e222f-eee4-40ac-8a0f-9441b41d438e" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12305210/b466c40743d625fa5fc426d499a1586a.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 1567602 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12305210/thumbnail-b466c40743d625fa5fc426d499a1586a.webp" "ImageWidth" => 3840 "Permission" => array:1 [ …1] "ImageHeight" => 2560 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "614e222f-eee4-40ac-8a0f-9441b41d438e" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12305210" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "614e222f-eee4-40ac-8a0f-9441b41d438e" "ModificationTimestamp" => "2025-07-24T16:43:54.019781Z" "MediaModificationTimestamp" => "2025-07-24T16:43:54.019781Z" ] 6 => array:26 [ "Order" => 6 "ImageOf" => null "MediaKey" => "703067f8-2576-4935-a81f-0543725ce016" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12305210/04b523fed8efe81b7f93c009d3bceab5.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 928454 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12305210/thumbnail-04b523fed8efe81b7f93c009d3bceab5.webp" "ImageWidth" => 3840 "Permission" => array:1 [ …1] "ImageHeight" => 2560 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "703067f8-2576-4935-a81f-0543725ce016" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12305210" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "703067f8-2576-4935-a81f-0543725ce016" "ModificationTimestamp" => "2025-07-24T16:43:54.019781Z" "MediaModificationTimestamp" => "2025-07-24T16:43:54.019781Z" ] 7 => array:26 [ "Order" => 7 "ImageOf" => null "MediaKey" => "e60e298e-26a2-44ca-a320-57b3ef325a32" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12305210/b6d2a6e679e18e77d5f2ed7b915d4f1a.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 894425 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12305210/thumbnail-b6d2a6e679e18e77d5f2ed7b915d4f1a.webp" "ImageWidth" => 3840 "Permission" => array:1 [ …1] "ImageHeight" => 2560 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "e60e298e-26a2-44ca-a320-57b3ef325a32" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12305210" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "e60e298e-26a2-44ca-a320-57b3ef325a32" "ModificationTimestamp" => "2025-07-24T16:43:54.019781Z" "MediaModificationTimestamp" => "2025-07-24T16:43:54.019781Z" ] 8 => array:26 [ "Order" => 8 "ImageOf" => null "MediaKey" => "ad2f203f-483c-44f1-a3e5-1f7a0e790093" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12305210/9951f34a9651c753f40514c0f06a0490.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 1617784 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12305210/thumbnail-9951f34a9651c753f40514c0f06a0490.webp" "ImageWidth" => 3840 "Permission" => array:1 [ …1] "ImageHeight" => 2560 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "ad2f203f-483c-44f1-a3e5-1f7a0e790093" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12305210" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "ad2f203f-483c-44f1-a3e5-1f7a0e790093" "ModificationTimestamp" => "2025-07-24T16:43:54.019781Z" "MediaModificationTimestamp" => "2025-07-24T16:43:54.019781Z" ] 9 => array:26 [ "Order" => 9 "ImageOf" => null "MediaKey" => "db23563a-6631-46b6-8bb2-19754117f9d2" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12305210/590768ca6fa7ee6a6c4b5644ccc586cc.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 1531014 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12305210/thumbnail-590768ca6fa7ee6a6c4b5644ccc586cc.webp" "ImageWidth" => 3840 "Permission" => array:1 [ …1] "ImageHeight" => 2560 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "db23563a-6631-46b6-8bb2-19754117f9d2" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12305210" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "db23563a-6631-46b6-8bb2-19754117f9d2" "ModificationTimestamp" => "2025-07-24T16:43:54.019781Z" "MediaModificationTimestamp" => "2025-07-24T16:43:54.019781Z" ] 10 => array:26 [ "Order" => 10 "ImageOf" => null "MediaKey" => "fe431fb8-d2bf-482d-b98c-8e32c4db8f02" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12305210/aded39f142299b3b8196a2d6f908b038.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 1337156 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12305210/thumbnail-aded39f142299b3b8196a2d6f908b038.webp" "ImageWidth" => 3840 "Permission" => array:1 [ …1] "ImageHeight" => 2560 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "fe431fb8-d2bf-482d-b98c-8e32c4db8f02" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12305210" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "fe431fb8-d2bf-482d-b98c-8e32c4db8f02" "ModificationTimestamp" => "2025-07-24T16:43:54.019781Z" "MediaModificationTimestamp" => "2025-07-24T16:43:54.019781Z" ] 11 => array:26 [ "Order" => 11 "ImageOf" => null "MediaKey" => "75d09b2b-801b-4d57-8883-e35b0046cd9b" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12305210/27defe5787c7c894f3d12816ddcb3d81.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 1111658 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12305210/thumbnail-27defe5787c7c894f3d12816ddcb3d81.webp" "ImageWidth" => 3840 "Permission" => array:1 [ …1] "ImageHeight" => 2560 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "75d09b2b-801b-4d57-8883-e35b0046cd9b" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12305210" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "75d09b2b-801b-4d57-8883-e35b0046cd9b" "ModificationTimestamp" => "2025-07-24T16:43:54.019781Z" "MediaModificationTimestamp" => "2025-07-24T16:43:54.019781Z" ] 12 => array:26 [ "Order" => 12 "ImageOf" => null "MediaKey" => "79397bde-014a-424c-8ba4-39e6e7e4e66e" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12305210/61b3ada3fea085c6853f09c87a9f0844.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 1304733 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12305210/thumbnail-61b3ada3fea085c6853f09c87a9f0844.webp" "ImageWidth" => 3840 "Permission" => array:1 [ …1] "ImageHeight" => 2560 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "79397bde-014a-424c-8ba4-39e6e7e4e66e" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12305210" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "79397bde-014a-424c-8ba4-39e6e7e4e66e" "ModificationTimestamp" => "2025-07-24T16:43:54.019781Z" "MediaModificationTimestamp" => "2025-07-24T16:43:54.019781Z" ] 13 => array:26 [ "Order" => 13 "ImageOf" => null "MediaKey" => "3bd07324-feb1-4d53-a364-211a3b7bdf82" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12305210/0929d48213a5c22d8b186bac15ae31e6.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 1434896 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12305210/thumbnail-0929d48213a5c22d8b186bac15ae31e6.webp" "ImageWidth" => 3840 "Permission" => array:1 [ …1] "ImageHeight" => 2560 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "3bd07324-feb1-4d53-a364-211a3b7bdf82" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12305210" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "3bd07324-feb1-4d53-a364-211a3b7bdf82" "ModificationTimestamp" => "2025-07-24T16:43:54.019781Z" "MediaModificationTimestamp" => "2025-07-24T16:43:54.019781Z" ] 14 => array:26 [ "Order" => 14 "ImageOf" => null "MediaKey" => "ab0cec18-26ee-46d4-9f5e-fe9e76396f60" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12305210/2b48e0e2c4f91ec65c68d876e58fa737.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 1364794 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12305210/thumbnail-2b48e0e2c4f91ec65c68d876e58fa737.webp" "ImageWidth" => 6000 "Permission" => array:1 [ …1] "ImageHeight" => 4000 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "ab0cec18-26ee-46d4-9f5e-fe9e76396f60" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12305210" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "ab0cec18-26ee-46d4-9f5e-fe9e76396f60" "ModificationTimestamp" => "2025-07-24T16:43:54.019781Z" "MediaModificationTimestamp" => "2025-07-24T16:43:54.019781Z" ] 15 => array:26 [ "Order" => 15 "ImageOf" => null "MediaKey" => "a15a3b9f-ca60-475f-96a6-eac2a370924a" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12305210/f173505542b9d1eba03f3d363bb64e6a.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 1147494 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12305210/thumbnail-f173505542b9d1eba03f3d363bb64e6a.webp" "ImageWidth" => 6000 "Permission" => array:1 [ …1] "ImageHeight" => 4000 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "a15a3b9f-ca60-475f-96a6-eac2a370924a" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12305210" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "a15a3b9f-ca60-475f-96a6-eac2a370924a" "ModificationTimestamp" => "2025-07-24T16:43:54.019781Z" "MediaModificationTimestamp" => "2025-07-24T16:43:54.019781Z" ] 16 => array:26 [ "Order" => 16 "ImageOf" => null "MediaKey" => "2a518ba0-8a31-4ec0-a616-54338e76d9bf" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12305210/e0c8683d84e0d5022ac09c522dc1b451.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 1103012 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12305210/thumbnail-e0c8683d84e0d5022ac09c522dc1b451.webp" "ImageWidth" => 6000 "Permission" => array:1 [ …1] "ImageHeight" => 4000 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "2a518ba0-8a31-4ec0-a616-54338e76d9bf" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12305210" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "2a518ba0-8a31-4ec0-a616-54338e76d9bf" "ModificationTimestamp" => "2025-07-24T16:43:54.019781Z" "MediaModificationTimestamp" => "2025-07-24T16:43:54.019781Z" ] 17 => array:26 [ "Order" => 17 "ImageOf" => null "MediaKey" => "4c62ccf4-fcc3-48be-9ee0-d720a65cc38a" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12305210/fd27258af00593abeea13c6035ac7a9f.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 1833535 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12305210/thumbnail-fd27258af00593abeea13c6035ac7a9f.webp" "ImageWidth" => 6000 "Permission" => array:1 [ …1] "ImageHeight" => 4000 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "4c62ccf4-fcc3-48be-9ee0-d720a65cc38a" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12305210" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "4c62ccf4-fcc3-48be-9ee0-d720a65cc38a" "ModificationTimestamp" => "2025-07-24T16:43:54.019781Z" "MediaModificationTimestamp" => "2025-07-24T16:43:54.019781Z" ] 18 => array:26 [ "Order" => 18 "ImageOf" => null "MediaKey" => "b1319668-bc2f-4c6d-97a4-87f257342452" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12305210/bdc231528a749277612931094764599c.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 1748354 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12305210/thumbnail-bdc231528a749277612931094764599c.webp" "ImageWidth" => 3840 "Permission" => array:1 [ …1] "ImageHeight" => 2560 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "b1319668-bc2f-4c6d-97a4-87f257342452" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12305210" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "b1319668-bc2f-4c6d-97a4-87f257342452" "ModificationTimestamp" => "2025-07-24T16:43:54.019781Z" "MediaModificationTimestamp" => "2025-07-24T16:43:54.019781Z" ] 19 => array:26 [ "Order" => 19 "ImageOf" => null "MediaKey" => "c9dfd274-7166-4dc3-8d25-08b5b16b6775" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12305210/cc9ea821389c8903a91cd55c34122556.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 1883157 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12305210/thumbnail-cc9ea821389c8903a91cd55c34122556.webp" "ImageWidth" => 3840 "Permission" => array:1 [ …1] "ImageHeight" => 2560 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "c9dfd274-7166-4dc3-8d25-08b5b16b6775" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12305210" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "c9dfd274-7166-4dc3-8d25-08b5b16b6775" "ModificationTimestamp" => "2025-07-24T16:43:54.019781Z" "MediaModificationTimestamp" => "2025-07-24T16:43:54.019781Z" ] 20 => array:26 [ "Order" => 20 "ImageOf" => null "MediaKey" => "d9e5bb79-d2e2-46f0-ab92-96a74ce5d7a4" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12305210/ec93fb1e747763a90f2c5a70a8c80cf0.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null …20 ] 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] ] } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14650 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12296794" +"ListingId": "X12296794" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-25T20:17:32Z" +"RFModificationTimestamp": "2025-07-25T20:46:08Z" +"ListPrice": 749000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0.09 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L9C 7E8" +"UnparsedAddress": "18 Novoco Drive, Hamilton, ON L9C 7E8" +"Coordinates": array:2 [ 0 => -79.9180554 1 => 43.2214284 ] +"Latitude": 43.2214284 +"Longitude": -79.9180554 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE NRC REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to this 4-bedroom, 2-storey home located in a desirable Hamilton neighborhood! This spacious family home features a newly repaved driveway (2024), brand-new concrete front porch (2024), and fresh front landscaping (2025), creating great curb appeal. Inside, enjoy a fully updated kitchen with mostly new appliances, ideal for family meals and entertaining. Many of the rooms of the home have had a fresh coat of paint! The home offers bright, generous living spaces, four well-sized bedrooms, and a layout perfect for growing families with lots of potential. Located close to schools, parks, shopping, and transit, home blends some modern updates with timeless charm. Don't miss this opportunity to get into a great area, schedule your showing today!" +"ArchitecturalStyle": array:1 [ 0 => "2-Storey" ] +"Basement": array:1 [ 0 => "Unfinished" ] +"CityRegion": "Gurnett" +"ConstructionMaterials": array:2 [ 0 => "Brick" 1 => "Vinyl Siding" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CoveredSpaces": "1.0" +"CreationDate": "2025-07-21T11:31:54.909968+00:00" +"CrossStreet": "Sone Church Rd W and Upper Paradise" +"DirectionFaces": "North" +"Directions": "Stone Church Rd W to Upper Paradise Rd to Novoco Dr" +"ExpirationDate": "2025-10-31" +"FireplaceFeatures": array:1 [ 0 => "Wood" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"GarageYN": true +"Inclusions": "Dishwasher, Dryer, Washer, Stove, Oven, Built in Microwave, Window Coverings, GDO, TV Wall Mounts" +"InteriorFeatures": array:1 [ 0 => "Auto Garage Door Remote" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Niagara Association of REALTORS" +"ListingContractDate": "2025-07-21" +"LotSizeSource": "MPAC" +"MainOfficeKey": "292600" +"MajorChangeTimestamp": "2025-07-21T11:28:14Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-07-21T11:28:14Z" +"OriginalListPrice": 749000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2334962" +"OtherStructures": array:1 [ 0 => "Garden Shed" ] +"ParcelNumber": "169490106" +"ParkingFeatures": array:1 [ 0 => "Private Double" ] +"ParkingTotal": "5.0" +"PhotosChangeTimestamp": "2025-07-21T11:28:14Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Novoco" +"StreetNumber": "18" +"StreetSuffix": "Drive" +"TaxAnnualAmount": "7218.67" +"TaxLegalDescription": "PCL 11-1, SEC 62M458; LT 11, PL 62M458; S/T LT200225; S/T LT177492 HAMILTON" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2% + HST" +"TransactionType": "For Sale" +"VirtualTourURLBranded": "https://dl.dropboxusercontent.com/scl/fi/0kj5qcofhahbxng25j83y/18-Novoco-Dr-Hamilton-Walkthrough.mp4?rlkey=apryf4v0uqympma77th8m0iws&raw=1" +"Zoning": "R1" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 99.48 +"LotWidth": 40.42 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12296794')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "251808106302336" +"SurveyType": "None" +"LaundryLevel": "Lower Level" +"KitchensTotal": 1 +"ParkingSpaces": 4 +"provider_name": "TRREB" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included In" ] +"PossessionType": "60-89 days" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"DenFamilyroomYN": true +"LivingAreaRange": "1500-2000" +"RoomsAboveGrade": 4 +"ParcelOfTiedLand": "No" +"PropertyFeatures": array:4 [ 0 => "Place Of Worship" 1 => "School" 2 => "Public Transit" 3 => "Park" ] +"PossessionDetails": "60-89" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 3 +"BedroomsAboveGrade": 4 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Upper" +"MediaChangeTimestamp": "2025-07-21T11:28:14Z" +"SystemModificationTimestamp": "2025-07-25T20:17:34.958794Z" +"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] ] } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14656 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12290719" +"ListingId": "X12290719" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-25T19:43:34Z" +"RFModificationTimestamp": "2025-07-25T19:53:49Z" +"ListPrice": 3850000.0 +"BathroomsTotalInteger": 6.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 1.995 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L9H 7N4" +"UnparsedAddress": "51 Tews Lane, Hamilton, ON L9H 7N4" +"Coordinates": array:2 [ 0 => -79.9793769 1 => 43.2825993 ] +"Latitude": 43.2825993 +"Longitude": -79.9793769 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "SOTHEBY'S INTERNATIONAL REALTY, BROKERAGE" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "An unparalleled estate residence in the heart of Dundas' most prestigious enclave. Poised on a pristine, professionally manicured two-acre lot backing directly onto the protected conservation lands of Tews Falls, this extraordinary bungalow offers over 4,000 square feet of exquisite main floor living, meticulously crafted with the finest materials and finishes available. Every element of this home speaks to luxury and sophistication. Dramatic coffered ceilings soaring from 10 to 18 feet frame the interior with architectural distinction, while expansive principal rooms flow effortlessly under a canopy of custom millwork, oversized baseboards, detailed crown mouldings, and designer lighting. The heart of the home is the gourmet chefs kitchen, an entertainers dream complete with top-tier appliances, bespoke cabinetry, an oversized island, and a fully outfitted walk-in pantry, all opening to the magnificent great room with its sweeping views of the lush grounds beyond. Offering 4 spacious bedrooms on the main level, including an opulent primary suite. With dual walk-in closets, a spa-like ensuite, and tranquil views of the rear gardens, it is a private retreat of the highest order. An additional fifth bedroom is located in the fully finished lower level, which has been designed as a self-contained suite with its own full kitchen, bath, and living area ideal for extended family or guests. The rear yard is a resort-caliber oasis, featuring a heated in-ground pool, elegant cabana, your own putting green, mature trees and conservation views. A four-season sunroom invites year-round enjoyment of the surrounding nature, while four garage bays provide ample room for automotive enthusiasts. The lower level is finished to the same exceptional standard as the main floor, with wide-plank flooring, designer tilework, custom built-ins, and premium fixtures throughout. Recently, the property has undergone numerous high-end upgrades, further enhancing its already impeccable quality." +"ArchitecturalStyle": array:1 [ 0 => "Bungalow" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"CityRegion": "Dundas" +"ConstructionMaterials": array:1 [ 0 => "Stone" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CountyOrParish": "Hamilton" +"CoveredSpaces": "4.0" +"CreationDate": "2025-07-17T14:52:01.690044+00:00" +"CrossStreet": "Harvest Road & Ofield Road S" +"DirectionFaces": "South" +"Directions": "west on Harvest Rd from Ofield Rd S, north on Tews Lane" +"ExpirationDate": "2025-12-05" +"ExteriorFeatures": array:9 [ 0 => "Backs On Green Belt" 1 => "Canopy" 2 => "Landscape Lighting" 3 => "Landscaped" 4 => "Patio" 5 => "Privacy" 6 => "Porch Enclosed" 7 => "Year Round Living" 8 => "Porch" ] +"FireplaceFeatures": array:1 [ 0 => "Natural Gas" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"GarageYN": true +"InteriorFeatures": array:9 [ 0 => "Air Exchanger" 1 => "Auto Garage Door Remote" 2 => "Built-In Oven" 3 => "Central Vacuum" 4 => "Carpet Free" 5 => "Generator - Full" 6 => "Primary Bedroom - Main Floor" 7 => "Separate Heating Controls" 8 => "Storage" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Niagara Association of REALTORS" +"ListingContractDate": "2025-07-17" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "118900" +"MajorChangeTimestamp": "2025-07-17T14:14:46Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-07-17T14:14:46Z" +"OriginalListPrice": 3850000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2711172" +"OtherStructures": array:2 [ 0 => "Other" 1 => "Fence - Full" ] +"ParcelNumber": "174920476" +"ParkingFeatures": array:2 [ 0 => "Circular Drive" 1 => "Private" ] +"ParkingTotal": "6.0" +"PhotosChangeTimestamp": "2025-07-17T14:14:46Z" +"PoolFeatures": array:3 [ 0 => "Outdoor" 1 => "Salt" 2 => "Inground" ] +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"SecurityFeatures": array:2 [ 0 => "Carbon Monoxide Detectors" 1 => "Security System" ] +"Sewer": array:1 [ 0 => "Septic" ] +"ShowingRequirements": array:1 [ 0 => "See Brokerage Remarks" ] +"SignOnPropertyYN": true +"SoilType": array:1 [ 0 => "Clay" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Tews" +"StreetNumber": "51" +"StreetSuffix": "Lane" +"TaxAnnualAmount": "19748.06" +"TaxAssessedValue": 1638000 +"TaxLegalDescription": "PTLT 11, CON 2 WEST FLAMBOROUGH, PT 3 ON 62R18667 SUBJECT TO AN EASEMENT IN GROSS AS IN WE725195 SUBJECT TO AN EASEMENT FOR ENTRY UNTIL 2021/03/01 AS IN WE1103855 CITY OF HAMILTON" +"TaxYear": "2025" +"Topography": array:1 [ 0 => "Sloping" ] +"TransactionBrokerCompensation": "2%+HST" +"TransactionType": "For Sale" +"View": array:3 [ 0 => "Park/Greenbelt" 1 => "Ridge" 2 => "Trees/Woods" ] +"VirtualTourURLBranded": "https://show.tours/v/k YJk Sn Z" +"VirtualTourURLUnbranded": "https://show.tours/v/9LDv P2H" +"VirtualTourURLUnbranded2": "https://show.tours/v/k YJk Sn Z?b=0" +"WaterSource": array:1 [ 0 => "Dug Well" ] +"Zoning": "S1" +"DDFYN": true +"Water": "Well" +"GasYNA": "Yes" +"CableYNA": "Yes" +"HeatType": "Forced Air" +"LotDepth": 584.29 +"LotShape": "Pie" +"LotWidth": 319.66 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12290719')" +"GarageType": "Built-In" +"HeatSource": "Gas" +"RollNumber": "251830223035809" +"SurveyType": "None" +"ElectricYNA": "Yes" +"RentalItems": "Water Heater" +"HoldoverDays": 60 +"LaundryLevel": "Main Level" +"TelephoneYNA": "Yes" +"KitchensTotal": 2 +"ParkingSpaces": 2 +"provider_name": "TRREB" +"ApproximateAge": "6-15" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included In" ] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"WashroomsType4": 1 +"WashroomsType5": 2 +"CentralVacuumYN": true +"DenFamilyroomYN": true +"LivingAreaRange": "3500-5000" +"RoomsAboveGrade": 12 +"RoomsBelowGrade": 8 +"LotSizeAreaUnits": "Acres" +"PropertyFeatures": array:3 [ 0 => "Fenced Yard" 1 => "Greenbelt/Conservation" 2 => "Wooded/Treed" ] +"LotIrregularities": "large irregular pie shaped lot" +"LotSizeRangeAcres": ".50-1.99" +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 5 +"WashroomsType2Pcs": 4 +"WashroomsType3Pcs": 2 +"WashroomsType4Pcs": 3 +"WashroomsType5Pcs": 3 +"BedroomsAboveGrade": 4 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"KitchensBelowGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"ShowingAppointments": "Listing Realtor to attend all showings. Require 3-4 hour notice for showings" +"WashroomsType1Level": "Ground" +"WashroomsType2Level": "Ground" +"WashroomsType3Level": "Ground" +"WashroomsType4Level": "Ground" +"WashroomsType5Level": "Basement" +"MediaChangeTimestamp": "2025-07-19T02:01:03Z" +"SystemModificationTimestamp": "2025-07-25T19:43:42.891594Z" +"Media": array:50 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] 31 => array:26 [ …26] 32 => array:26 [ …26] 33 => array:26 [ …26] 34 => array:26 [ …26] 35 => array:26 [ …26] 36 => array:26 [ …26] 37 => array:26 [ …26] 38 => array:26 [ …26] 39 => array:26 [ …26] 40 => array:26 [ …26] 41 => array:26 [ …26] 42 => array:26 [ …26] 43 => array:26 [ …26] 44 => array:26 [ …26] 45 => array:26 [ …26] 46 => array:26 [ …26] 47 => array:26 [ …26] 48 => array:26 [ …26] 49 => array:26 [ …26] ] } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14653 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12175427" +"ListingId": "X12175427" +"PropertyType": "Residential" +"PropertySubType": "Semi-Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-25T19:38:22Z" +"RFModificationTimestamp": "2025-07-25T19:41:50Z" +"ListPrice": 649900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0.082 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8K 5E8" +"UnparsedAddress": "566 Greenhill Avenue, Hamilton, ON L8K 5E8" +"Coordinates": array:2 [ 0 => -79.7896827 1 => 43.2096715 ] +"Latitude": 43.2096715 +"Longitude": -79.7896827 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "COLDWELL BANKER SUN REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to Your Ideal Family Home! Nestled in a quiet, family-friendly neighborhood, this charming semi-detached 3-bedroom, 2-bathroom, 3-level backsplit home is the perfect blend of comfort and convenience. Enjoy spacious living areas, a well-equipped kitchen, and bright, airy bedrooms designed for relaxation.Located close to parks, schools, escarpment, and major highways, this home offers unparalleled accessibility while maintaining a peaceful residential charm. The separate entrance to the basement adds flexibility for extra living space, rental potential, or a private retreat. Property currently tenanted, Tenants willing to stay or leave." +"ArchitecturalStyle": array:1 [ 0 => "Backsplit 3" ] +"Basement": array:2 [ 0 => "Separate Entrance" 1 => "Finished" ] +"CityRegion": "Vincent" +"ConstructionMaterials": array:2 [ 0 => "Brick" 1 => "Vinyl Siding" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2025-05-27T14:14:22.625721+00:00" +"CrossStreet": "Redhill Valley Pkwy/Greenhill Ave." +"DirectionFaces": "South" +"Directions": "Redhill Valley Pkwy/Greenhill Ave." +"Exclusions": "All Tenant's Belongings" +"ExpirationDate": "2025-09-30" +"FoundationDetails": array:1 [ 0 => "Concrete Block" ] +"Inclusions": "2-Fridge,2-Stove, Washer, dryer, Sheds in the backyard and ELFs." +"InteriorFeatures": array:2 [ 0 => "Carpet Free" 1 => "In-Law Capability" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-05-27" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "237800" +"MajorChangeTimestamp": "2025-05-27T14:09:48Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2025-05-27T14:09:48Z" +"OriginalListPrice": 649900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2452784" +"OtherStructures": array:1 [ 0 => "Garden Shed" ] +"ParcelNumber": "170970236" +"ParkingFeatures": array:1 [ 0 => "Private Double" ] +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2025-05-27T20:25:38Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"Sewer": array:1 [ 0 => "Septic" ] +"ShowingRequirements": array:4 [ 0 => "Lockbox" 1 => "Showing System" 2 => "List Brokerage" 3 => "List Salesperson" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Greenhill" +"StreetNumber": "566" +"StreetSuffix": "Avenue" +"TaxAnnualAmount": "3801.81" +"TaxLegalDescription": "PCL 230-1, SEC M65 ; LT 230, PL M65 ; S/T LT8115 CITY OF HAMILTON" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2% + Hst" +"TransactionType": "For Sale" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 101.81 +"LotShape": "Irregular" +"LotWidth": 34.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12175427')" +"GarageType": "None" +"HeatSource": "Gas" +"RollNumber": "251805053520550" +"SurveyType": "None" +"RentalItems": "Hpt Water Tank" +"HoldoverDays": 30 +"LaundryLevel": "Lower Level" +"KitchensTotal": 1 +"ParkingSpaces": 4 +"provider_name": "TRREB" +"ApproximateAge": "51-99" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included In" ] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"LivingAreaRange": "700-1100" +"MortgageComment": "Treat as Clear" +"RoomsAboveGrade": 6 +"RoomsBelowGrade": 1 +"LotSizeAreaUnits": "Acres" +"PropertyFeatures": array:5 [ 0 => "Clear View" 1 => "Fenced Yard" 2 => "Golf" 3 => "School" 4 => "School Bus Route" ] +"LotIrregularities": "34.09 ft x100.95 ft x36.06 ft x101.79 ft" +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 3 +"WashroomsType2Pcs": 3 +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"ShowingAppointments": "Property is Tenanted, 24 hrs notice required." +"WashroomsType1Level": "Upper" +"WashroomsType2Level": "Lower" +"MediaChangeTimestamp": "2025-05-27T20:25:38Z" +"SystemModificationTimestamp": "2025-07-25T19:38:23.622321Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:23 [ 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] ] } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14648 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12202894" +"ListingId": "X12202894" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-25T19:28:28Z" +"RFModificationTimestamp": "2025-07-25T19:36:14Z" +"ListPrice": 674900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8V 4T3" +"UnparsedAddress": "183 Garden Crescent, Hamilton, ON L8V 4T3" +"Coordinates": array:2 [ 0 => -79.8575733 1 => 43.2265597 ] +"Latitude": 43.2265597 +"Longitude": -79.8575733 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE STATE REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome home! This freshly painted home (June 2025) with unique multi level design. Featuring large entry way walk in closet. Up a short flight of stairs, to your main floor with spacious living room, separate dining room and large kitchen loaded with cupboards, and Granite counters! Convenient 2 pce bath too! Living room features walk out through sliding doors to two tiered deck, with gazebo and shed. heading towards the bedroom level, you have an additional storage with spacious closet, a few more steps and you reach the 3 bedrooms, all with NEW carpet (June 2025) and light fixtures. 4 pce bath with glass sink. Basement level features, large family room with fireplace (as is), separate laundry area and furnace room. Loaded with storage! Large driveway with 1.5 car garage. Some pictures are virtually staged . Quick close possible, close to shopping, buses and highway access. Easy walk to park and schools." +"ArchitecturalStyle": array:1 [ 0 => "Backsplit 3" ] +"Basement": array:1 [ 0 => "Partially Finished" ] +"CityRegion": "Burkholme" +"ConstructionMaterials": array:2 [ 0 => "Brick" 1 => "Vinyl Siding" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CoveredSpaces": "1.0" +"CreationDate": "2025-06-06T18:01:17.879939+00:00" +"CrossStreet": "Upper Wentworth to East 24th to Garden Cress" +"DirectionFaces": "North" +"Directions": "Upper Wentworth to East 24th to Garden Cress" +"ExpirationDate": "2025-09-30" +"FireplaceYN": true +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"GarageYN": true +"Inclusions": "Dishwasher, dryer, fridge, stove, washer, shed - all as is" +"InteriorFeatures": array:2 [ 0 => "On Demand Water Heater" 1 => "Water Heater Owned" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-06-06" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "288000" +"MajorChangeTimestamp": "2025-07-17T20:33:15Z" +"MlsStatus": "Price Change" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-06-06T17:42:27Z" +"OriginalListPrice": 719900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2383466" +"ParcelNumber": "170140091" +"ParkingTotal": "3.0" +"PhotosChangeTimestamp": "2025-06-06T17:42:28Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"PreviousListPrice": 699900.0 +"PriceChangeTimestamp": "2025-07-17T20:33:15Z" +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Garden" +"StreetNumber": "183" +"StreetSuffix": "Crescent" +"TaxAnnualAmount": "4641.0" +"TaxLegalDescription": "PCL 151-1. SEC M284; LT 151, PL M284; EASEMENT FOR MAINTENANCE RUNS WITH LAND AS PART OF THE DESIGNATED AS PT 324 62R5829 BEING PT LT 152, PL M284" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2% + hst" +"TransactionType": "For Sale" +"VirtualTourURLBranded": "https://www.myvisuallistings.com/vt/356877" +"VirtualTourURLUnbranded": "https://www.myvisuallistings.com/vtnb/356877" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 100.06 +"LotShape": "Rectangular" +"LotWidth": 27.8 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12202894')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "251807066203115" +"SurveyType": "None" +"RentalItems": "Hot water heater" +"HoldoverDays": 30 +"KitchensTotal": 1 +"ParkingSpaces": 2 +"provider_name": "TRREB" +"ApproximateAge": "31-50" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Not Subject to HST" ] +"PossessionType": "Immediate" +"PriorMlsStatus": "New" +"WashroomsType1": 1 +"WashroomsType2": 1 +"LivingAreaRange": "1100-1500" +"RoomsAboveGrade": 6 +"LotSizeAreaUnits": "Acres" +"ParcelOfTiedLand": "No" +"LotSizeRangeAcres": "< .50" +"PossessionDetails": "Immediate" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 4 +"BedroomsAboveGrade": 3 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"LeaseToOwnEquipment": array:1 [ 0 => "None" ] +"ShowingAppointments": "LBO/BB" +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Basement" +"MediaChangeTimestamp": "2025-06-06T17:42:28Z" +"SystemModificationTimestamp": "2025-07-25T19:28:31.198181Z" +"Media": array:50 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] 31 => array:26 [ …26] 32 => array:26 [ …26] 33 => array:26 [ …26] 34 => array:26 [ …26] 35 => array:26 [ …26] 36 => array:26 [ …26] 37 => array:26 [ …26] 38 => array:26 [ …26] 39 => array:26 [ …26] 40 => array:26 [ …26] 41 => array:26 [ …26] 42 => array:26 [ …26] 43 => array:26 [ …26] 44 => array:26 [ …26] 45 => array:26 [ …26] 46 => array:26 [ …26] 47 => array:26 [ …26] 48 => array:26 [ …26] 49 => array:26 [ …26] ] } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14627 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12296363" +"ListingId": "X12296363" +"PropertyType": "Residential Lease" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-25T19:24:33Z" +"RFModificationTimestamp": "2025-07-25T19:38:03Z" +"ListPrice": 2400.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8R 3J2" +"UnparsedAddress": "1 Jarvis Street 427, Hamilton, ON L8R 3J2" +"Coordinates": array:2 [ 0 => -79.8601256 1 => 43.2547782 ] +"Latitude": 43.2547782 +"Longitude": -79.8601256 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "HOMELIFE/MIRACLE REALTY LTD" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Stylish 2 Bedroom/2 Washroom condo in Hamilton 836 Interior Sq ft Unit including 1 Parking unit with a remarkable 44 sq ft private terrace!. Very Usable layout features a sleek kitchen with high-end appliances, a master bedroom with an ensuite bath, and large second bedroom with extended closet. Enjoy the vibrancy of Hamilton's city life with shops and restaurants at your doorstep. With convenient and close proximity to highway 403 and QEW, steps away from GO Stations, close to Mc Master University and many more. Building amenities including fitness space, yoga and lounge, and 24/7 security." +"ArchitecturalStyle": array:1 [ 0 => "Apartment" ] +"AssociationAmenities": array:3 [ 0 => "Bus Ctr (Wi Fi Bldg)" 1 => "Concierge" 2 => "Gym" ] +"Basement": array:1 [ 0 => "None" ] +"CityRegion": "Beasley" +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CountyOrParish": "Hamilton" +"CoveredSpaces": "1.0" +"CreationDate": "2025-07-20T15:31:32.508867+00:00" +"CrossStreet": "King St E and Jarvis St" +"Directions": "King St E and Jarvis St" +"Exclusions": "N/A" +"ExpirationDate": "2025-10-01" +"Furnished": "Unfurnished" +"Inclusions": "All Appliances" +"InteriorFeatures": array:3 [ 0 => "Built-In Oven" 1 => "Countertop Range" 2 => "Primary Bedroom - Main Floor" ] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "Ensuite" ] +"LeaseTerm": "12 Months" +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-07-19" +"MainOfficeKey": "406000" +"MajorChangeTimestamp": "2025-07-20T15:27:05Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-07-20T15:27:05Z" +"OriginalListPrice": 2400.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2737864" +"ParkingFeatures": array:1 [ 0 => "Underground" ] +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ 0 => "Restricted" ] +"PhotosChangeTimestamp": "2025-07-20T15:27:05Z" +"RentIncludes": array:3 [ 0 => "Building Insurance" 1 => "Heat" 2 => "Parking" ] +"ShowingRequirements": array:1 [ 0 => "List Brokerage" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Jarvis" +"StreetNumber": "1" +"StreetSuffix": "Street" +"TransactionBrokerCompensation": "Half Month Rent + HST" +"TransactionType": "For Lease" +"UnitNumber": "427" +"DDFYN": true +"Locker": "None" +"Exposure": "West" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12296363')" +"GarageType": "None" +"HeatSource": "Gas" +"SurveyType": "Unknown" +"BalconyType": "Open" +"HoldoverDays": 90 +"LegalStories": "4" +"ParkingType1": "Owned" +"CreditCheckYN": true +"KitchensTotal": 1 +"ParkingSpaces": 1 +"provider_name": "TRREB" +"ApproximateAge": "New" +"ContractStatus": "Available" +"PossessionDate": "2025-09-01" +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"DepositRequired": true +"LivingAreaRange": "800-899" +"RoomsAboveGrade": 6 +"LeaseAgreementYN": true +"PropertyFeatures": array:6 [ 0 => "Arts Centre" 1 => "Hospital" 2 => "Library" 3 => "Park" 4 => "Public Transit" 5 => "School" ] +"SquareFootSource": "Builder" +"PossessionDetails": "Tenanted - Need 24 hours Notice" +"WashroomsType1Pcs": 3 +"WashroomsType2Pcs": 3 +"BedroomsAboveGrade": 2 +"EmploymentLetterYN": true +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"RentalApplicationYN": true +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Main" +"LegalApartmentNumber": "427" +"MediaChangeTimestamp": "2025-07-20T15:27:05Z" +"PortionPropertyLease": array:1 [ 0 => "Entire Property" ] +"ReferencesRequiredYN": true +"PropertyManagementCompany": "Crossbridge Condominium Services Ltd. (364) 237 0399" +"SystemModificationTimestamp": "2025-07-25T19:24:34.466856Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:10 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] ] } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14626 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12037868" +"ListingId": "X12037868" +"PropertyType": "Residential" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-25T19:22:58Z" +"RFModificationTimestamp": "2025-07-25T19:38:38Z" +"ListPrice": 499999.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8R 3J3" +"UnparsedAddress": "#1702 - 75 Queen Street, Hamilton, On L8r 3j3" +"Coordinates": array:2 [ 0 => -79.8949644 1 => 43.3373356 ] +"Latitude": 43.3373356 +"Longitude": -79.8949644 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX ESCARPMENT REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Introducing a remarkable opportunity to own a fully renovated 2-bedroom,1-bathroom condo This stunning residence has been thoughtfully redesigned with a focus on quality and modern elegance. The open-concept floor plan is enhanced by sleek new finishes, including top-of-the-line stainless steel appliances, custom cabinetry, upgraded lighting fixtures, and exquisite new countertops and backsplash. The newly updated kitchen is a true highlight, providing an ideal space for both culinary creativity and everyday functionality, while the expansive windows throughout the living and dining areas invite natural light, creating a warm and welcoming atmosphere. The renovated 3-piece bathroom is a highlight, featuring elegant new tile flooring, a modern shower, and a brand-new vanity, all designed to provide a spa-like experience. Situated just minutes from downtown, Go Station, and major highways, this condo offers the ultimate in convenience. Residents will enjoy exclusive access to an impressive array of amenities, including an indoor pool, hot tub, sauna, fitness centre, green space, tennis court, and car wash station. Additionally, ample visitor parking and on-site security ensure a safe and hassle-free living experience. The buildings exterior is currently undergoing a complete makeover, including the installation of new windows, which will enhance both the curb appeal and the overall appeal of the property." +"ArchitecturalStyle": array:1 [ 0 => "1 Storey/Apt" ] +"AssociationAmenities": array:6 [ 0 => "Car Wash" 1 => "Exercise Room" 2 => "Indoor Pool" 3 => "Party Room/Meeting Room" 4 => "Sauna" 5 => "Visitor Parking" ] +"AssociationFee": "1102.9" +"AssociationFeeIncludes": array:4 [ 0 => "Common Elements Included" 1 => "Water Included" 2 => "Parking Included" 3 => "Building Insurance Included" ] +"Basement": array:1 [ 0 => "None" ] +"CityRegion": "Strathcona" +"ConstructionMaterials": array:2 [ 0 => "Concrete" 1 => "Stucco (Plaster)" ] +"Cooling": array:1 [ 0 => "Wall Unit(s)" ] +"CountyOrParish": "Hamilton" +"CoveredSpaces": "1.0" +"CreationDate": "2025-03-25T12:15:02.301767+00:00" +"CrossStreet": "York Blvd to Queen St N" +"Directions": "York Blvd to Queen St N" +"ExpirationDate": "2025-12-31" +"ExteriorFeatures": array:3 [ 0 => "Controlled Entry" 1 => "Landscaped" 2 => "Year Round Living" ] +"GarageYN": true +"Inclusions": "Carbon Monoxide Detector, Dishwasher, Microwave, Refrigerator, Stove, Washer" +"InteriorFeatures": array:2 [ 0 => "Carpet Free" 1 => "Primary Bedroom - Main Floor" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "In-Suite Laundry" ] +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-03-20" +"MainOfficeKey": "184000" +"MajorChangeTimestamp": "2025-07-25T19:22:58Z" +"MlsStatus": "Extension" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-03-24T15:29:47Z" +"OriginalListPrice": 499999.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2121112" +"ParcelNumber": "180450114" +"ParkingFeatures": array:2 [ 0 => "Other" 1 => "Surface" ] +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ 0 => "Restricted" ] +"PhotosChangeTimestamp": "2025-03-24T15:29:47Z" +"Roof": array:2 [ 0 => "Flat" 1 => "Other" ] +"SecurityFeatures": array:3 [ 0 => "Carbon Monoxide Detectors" 1 => "Concierge/Security" 2 => "Smoke Detector" ] +"ShowingRequirements": array:1 [ 0 => "List Brokerage" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "N" +"StreetName": "Queen" +"StreetNumber": "75" +"StreetSuffix": "Street" +"TaxAnnualAmount": "2460.0" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2% + hst" +"TransactionType": "For Sale" +"UnitNumber": "1702" +"View": array:5 [ 0 => "Bay" 1 => "Downtown" 2 => "Hills" 3 => "Skyline" 4 => "Water" ] +"VirtualTourURLBranded": "https://northernmediagroup.hd.pics/75-Queen-St-S-1702" +"Zoning": "E/S" +"DDFYN": true +"Locker": "Owned" +"Exposure": "East" +"HeatType": "Baseboard" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12037868')" +"GarageType": "Underground" +"HeatSource": "Electric" +"RollNumber": "251801010702113" +"SurveyType": "None" +"BalconyType": "Open" +"LockerLevel": "Main" +"HoldoverDays": 30 +"LaundryLevel": "Main Level" +"LegalStories": "17" +"LockerNumber": "163" +"ParkingType1": "Owned" +"KitchensTotal": 1 +"provider_name": "TRREB" +"ApproximateAge": "31-50" +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Not Subject to HST" ] +"PossessionType": "Immediate" +"PriorMlsStatus": "New" +"WashroomsType1": 1 +"CondoCorpNumber": 45 +"DenFamilyroomYN": true +"LivingAreaRange": "900-999" +"RoomsAboveGrade": 7 +"EnsuiteLaundryYN": true +"PropertyFeatures": array:6 [ 0 => "Clear View" 1 => "Hospital" 2 => "Library" 3 => "Marina" 4 => "Park" 5 => "Place Of Worship" ] +"SquareFootSource": "LBO" +"ParkingLevelUnit1": "163" +"PossessionDetails": "immediate" +"WashroomsType1Pcs": 3 +"BedroomsAboveGrade": 2 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"ShowingAppointments": "905-592-7777" +"WashroomsType1Level": "Main" +"LegalApartmentNumber": "2" +"MediaChangeTimestamp": "2025-03-24T15:29:47Z" +"ExtensionEntryTimestamp": "2025-07-25T19:22:58Z" +"PropertyManagementCompany": "J&W Condo Co" +"SystemModificationTimestamp": "2025-07-25T19:23:00.112227Z" +"VendorPropertyInfoStatement": true +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:5 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] ] } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14625 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12304337" +"ListingId": "X12304337" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-25T19:14:20Z" +"RFModificationTimestamp": "2025-07-25T19:42:47Z" +"ListPrice": 1092000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8E 4N1" +"UnparsedAddress": "365 Celtic Drive, Hamilton, ON L8E 4N1" +"Coordinates": array:2 [ 0 => -79.7394147 1 => 43.23089 ] +"Latitude": 43.23089 +"Longitude": -79.7394147 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE MEADOWTOWNE REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to Highly Sought-After & Family Friendly Stoney Creek Neighbourhood. This Recently Update Home is sitting on a premium Lot. Don't miss your chance to see it!!Pride of Ownership is evident in every detail. Featuring 3+2 Br & 4 Bath, this 2-storey/home has more than 2000sqf-above-grade-space. A Prim/Br with spacious layout, includes a cozy reading nook area, a perfect place to laid down with a good book and enjoy the natural light, or unwind watching the sunset. A W/I Closet offering a lot of storage and comfort & (3)Pcs ensuite w/spacious glass shower. This level also offers two comfortable & very spacious/size 2nd & 3rd brms & 4Pcs bath. Ground level features an Open Concept-Bright- Modern recently renovated Custom Kitchen. A Chef's Dream-Kitchen w/Quartz Countertops, custom cabinets, Pot lights & Laminate/Floors throughout, S/S Appliances, ample/center/Island & custom/made sitting area to enjoy views to a beautiful backyard. Walk-out to Ample-Yard-Outdoors & Be Welcomed To Your Own Private Oasis, enjoy the quiet & natural views of this beautiful garden-retreat, Perfect For Entertaining. Sun/filled & very bright Open Concept Living and Dining Area features a fireplace and Oversized Windows and modern lighting-fixtures providing an Abundance Of Light. Finished Bsmnt w/Sep Entry includes (2) two spacious Brms, kitchenette & 3Pcs Bath (ideal for in-laws or Income/potential).Concrete drive-way (fits 4 cars).Conveniently Located Just Minutes from Shopping Area, Restaurants, Parks, Trails, Schools and Hwy." +"AccessibilityFeatures": array:1 [ 0 => "Open Floor Plan" ] +"ArchitecturalStyle": array:1 [ 0 => "2-Storey" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Separate Entrance" ] +"CityRegion": "Stoney Creek" +"CoListOfficeName": "ROYAL LEPAGE MEADOWTOWNE REALTY" +"CoListOfficePhone": "905-821-3200" +"ConstructionMaterials": array:2 [ 0 => "Brick" 1 => "Brick Veneer" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CountyOrParish": "Hamilton" +"CoveredSpaces": "2.0" +"CreationDate": "2025-07-24T13:54:25.933474+00:00" +"CrossStreet": "Barton St / Grays Rd" +"DirectionFaces": "East" +"Directions": "Barton St / Grays Rd" +"Exclusions": "Security System" +"ExpirationDate": "2025-11-23" +"ExteriorFeatures": array:6 [ 0 => "Deck" 1 => "Landscaped" 2 => "Patio" 3 => "Paved Yard" 4 => "Privacy" 5 => "Porch Enclosed" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ 0 => "Concrete" ] +"GarageYN": true +"Inclusions": "ALL EXISTING; S/S FRIDGE, S/S STOVE, DISHWASHER, WASHER, DRYER, ELFS, WINDOW BLINDS, BSMT FRIDGE, BSMT STOVE" +"InteriorFeatures": array:1 [ 0 => "Carpet Free" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-07-24" +"MainOfficeKey": "108800" +"MajorChangeTimestamp": "2025-07-24T13:31:15Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-07-24T13:31:15Z" +"OriginalListPrice": 1092000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2753218" +"OtherStructures": array:2 [ 0 => "Fence - Full" 1 => "Garden Shed" ] +"ParcelNumber": "173280154" +"ParkingFeatures": array:2 [ 0 => "Private" 1 => "Private Double" ] +"ParkingTotal": "6.0" +"PhotosChangeTimestamp": "2025-07-24T13:31:16Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"SecurityFeatures": array:3 [ 0 => "Alarm System" 1 => "Security System" 2 => "Smoke Detector" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:1 [ 0 => "Lockbox" ] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Celtic" +"StreetNumber": "365" +"StreetSuffix": "Drive" +"TaxAnnualAmount": "6179.51" +"TaxAssessedValue": 449000 +"TaxLegalDescription": "PCL 14-1, SEC 62M421 ; LT 14, PL 62M421 ; STONEY CREEK CITY OF HAMILTON" +"TaxYear": "2025" +"Topography": array:1 [ 0 => "Flat" ] +"TransactionBrokerCompensation": "Full 2.5% + Applicable HST" +"TransactionType": "For Sale" +"VirtualTourURLUnbranded": "https://www.cirius3d.com/tour/417268" +"Zoning": "R2" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 121.08 +"LotShape": "Irregular" +"LotWidth": 46.26 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12304337')" +"GarageType": "Attached" +"HeatSource": "Other" +"RollNumber": "251800328505120" +"SurveyType": "None" +"RentalItems": "Hot Water Tank" +"HoldoverDays": 90 +"LaundryLevel": "Main Level" +"KitchensTotal": 2 +"ParkingSpaces": 4 +"UnderContract": array:1 [ 0 => "Hot Water Heater" ] +"provider_name": "TRREB" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included In" ] +"PossessionDate": "2025-08-29" +"PossessionType": "Immediate" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"WashroomsType4": 1 +"DenFamilyroomYN": true +"LivingAreaRange": "2000-2500" +"MortgageComment": "T.A.C." +"RoomsAboveGrade": 10 +"ParcelOfTiedLand": "No" +"PropertyFeatures": array:3 [ 0 => "Park" 1 => "Public Transit" 2 => "School" ] +"SalesBrochureUrl": "https://catalogs.meadowtownerealty.com/view/453977908/" +"LotSizeRangeAcres": "< .50" +"PossessionDetails": "30/60/90" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 3 +"WashroomsType3Pcs": 2 +"WashroomsType4Pcs": 3 +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 2 +"KitchensAboveGrade": 1 +"KitchensBelowGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"LeaseToOwnEquipment": array:1 [ 0 => "None" ] +"WashroomsType1Level": "Second" +"WashroomsType2Level": "Second" +"WashroomsType3Level": "Main" +"WashroomsType4Level": "Basement" +"MediaChangeTimestamp": "2025-07-24T14:18:26Z" +"SystemModificationTimestamp": "2025-07-25T19:14:24.043918Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:50 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] 31 => array:26 [ …26] 32 => array:26 [ …26] 33 => array:26 [ …26] 34 => array:26 [ …26] 35 => array:26 [ …26] 36 => array:26 [ …26] 37 => array:26 [ …26] 38 => array:26 [ …26] 39 => array:26 [ …26] 40 => array:26 [ …26] 41 => array:26 [ …26] 42 => array:26 [ …26] 43 => array:26 [ …26] 44 => array:26 [ …26] 45 => array:26 [ …26] 46 => array:26 [ …26] 47 => array:26 [ …26] 48 => array:26 [ …26] 49 => array:26 [ …26] ] } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14624 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12271689" +"ListingId": "X12271689" +"PropertyType": "Residential Lease" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-25T19:14:07Z" +"RFModificationTimestamp": "2025-07-25T19:43:16Z" +"ListPrice": 3200.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0.04 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8L 7S2" +"UnparsedAddress": "242 Balmoral Avenue, Hamilton, ON L8L 7S2" +"Coordinates": array:2 [ 0 => -79.824901 1 => 43.2358372 ] +"Latitude": 43.2358372 +"Longitude": -79.824901 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX REAL ESTATE CENTRE INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "For Lease! Charming & Fully Renovated 4 bedroom Century Home in Prime Crown Point! Welcome to this beautifully restored 2.5-story century home in Hamilton vibrant Crown Point neighborhood! Thoughtfully updated in 2022-2023, this home has a modern kitchen featuring stainless steel appliances and updated cabinetry. The main floor boasts a new 2-piece bath, while every bathroom has been tastefully renovated. A separate side entrance adds flexibility, and the fully fenced backyard with a rear deck offers the perfect space for relaxing or entertaining. Just two blocks west of Ottawa Street, this home is within walking distance of boutiques, trendy restaurants, Centre Mall, and Gage Park. Conveniently located just 5 minutes from Red Hill Valley Parkway and QEW, commuting is a breeze." +"ArchitecturalStyle": array:1 [ 0 => "2 1/2 Storey" ] +"Basement": array:1 [ 0 => "Full" ] +"CityRegion": "Crown Point" +"ConstructionMaterials": array:2 [ 0 => "Brick" 1 => "Vinyl Siding" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2025-07-08T21:24:41.379093+00:00" +"CrossStreet": "Campbell/Ottawa" +"DirectionFaces": "East" +"Directions": "Campbell/Ottawa" +"ExpirationDate": "2025-11-30" +"FoundationDetails": array:1 [ 0 => "Concrete" ] +"Furnished": "Unfurnished" +"InteriorFeatures": array:2 [ 0 => "Water Meter" 1 => "Water Heater" ] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "In Basement" ] +"LeaseTerm": "12 Months" +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-07-07" +"LotSizeSource": "MPAC" +"MainOfficeKey": "079800" +"MajorChangeTimestamp": "2025-07-08T21:20:56Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-07-08T21:20:56Z" +"OriginalListPrice": 3200.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2683096" +"ParcelNumber": "172230140" +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2025-07-08T21:20:56Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"RentIncludes": array:2 [ 0 => "Water Heater" 1 => "Parking" ] +"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" +"StreetDirSuffix": "N" +"StreetName": "Balmoral" +"StreetNumber": "242" +"StreetSuffix": "Avenue" +"TransactionBrokerCompensation": "Half Month + HST" +"TransactionType": "For Lease" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 75.0 +"LotWidth": 25.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12271689')" +"GarageType": "None" +"HeatSource": "Gas" +"RollNumber": "251804028454940" +"SurveyType": "None" +"BuyOptionYN": true +"HoldoverDays": 90 +"CreditCheckYN": true +"KitchensTotal": 1 +"ParkingSpaces": 1 +"provider_name": "TRREB" +"ContractStatus": "Available" +"PossessionDate": "2025-07-10" +"PossessionType": "Immediate" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"DepositRequired": true +"LivingAreaRange": "1100-1500" +"RoomsAboveGrade": 7 +"LeaseAgreementYN": true +"PrivateEntranceYN": true +"WashroomsType1Pcs": 3 +"WashroomsType2Pcs": 2 +"WashroomsType3Pcs": 4 +"BedroomsAboveGrade": 4 +"EmploymentLetterYN": true +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"RentalApplicationYN": true +"WashroomsType1Level": "Basement" +"WashroomsType2Level": "Main" +"WashroomsType3Level": "Second" +"MediaChangeTimestamp": "2025-07-08T21:20:56Z" +"PortionPropertyLease": array:1 [ 0 => "Entire Property" ] +"SystemModificationTimestamp": "2025-07-25T19:14:07.893828Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:23 [ 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] ] } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14623 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12260983" +"ListingId": "X12260983" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-25T19:13:42Z" +"RFModificationTimestamp": "2025-07-25T19:43:43Z" +"ListPrice": 710000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0.11 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8T 2J8" +"UnparsedAddress": "57 Burfield Avenue, Hamilton, ON L8T 2J8" +"Coordinates": array:2 [ 0 => -79.8279461 1 => 43.2180216 ] +"Latitude": 43.2180216 +"Longitude": -79.8279461 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "CENTURY 21 HERITAGE GROUP LTD." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "This 3+1 bedroom, 1.5 bath beauty in the heart of Huntington Park impresses from the moment you walk in. Light-filled living spaces, great flow, and room for everyone make it the perfect place to kick off your next chapter. Love to entertain? You'll flip for the epic 4-season room, complete with a pool table and space to catch every big game in style. Its the ultimate year-round hangout. This home is built to last with a 2-year-old metal roof and gutter guards on all eavestroughs, giving you peace of mind through every season. Set in a family-friendly neighbourhood with top-rated schools, plus easy access to bus routes, restaurants, and shopping, this location is as convenient as it is welcoming. Turn the key and get ready to call 57 Burfield Ave home!" +"ArchitecturalStyle": array:1 [ 0 => "Bungalow" ] +"Basement": array:2 [ 0 => "Full" 1 => "Finished" ] +"CityRegion": "Huntington" +"ConstructionMaterials": array:2 [ 0 => "Brick" 1 => "Vinyl Siding" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2025-07-03T21:41:38.811763+00:00" +"CrossStreet": "Kingslea Drive" +"DirectionFaces": "North" +"Directions": "Kingslea Drive" +"Exclusions": "none" +"ExpirationDate": "2025-10-03" +"FireplaceFeatures": array:2 [ 0 => "Family Room" 1 => "Natural Gas" ] +"FireplaceYN": true +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Inclusions": "Fridge, Dishwasher, Stove, Washer, Dryer, stove in the basement and storage units in the laundry room, pool table, piano" +"InteriorFeatures": array:4 [ 0 => "Central Vacuum" 1 => "Primary Bedroom - Main Floor" 2 => "Storage Area Lockers" 3 => "Water Heater" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-07-03" +"LotSizeSource": "MPAC" +"MainOfficeKey": "248500" +"MajorChangeTimestamp": "2025-07-25T19:13:42Z" +"MlsStatus": "Price Change" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-07-03T21:16:47Z" +"OriginalListPrice": 745000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2547140" +"ParcelNumber": "170000117" +"ParkingFeatures": array:1 [ 0 => "Private Double" ] +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2025-07-04T17:54:57Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"PreviousListPrice": 745000.0 +"PriceChangeTimestamp": "2025-07-25T19:13:42Z" +"Roof": array:1 [ 0 => "Metal" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:3 [ 0 => "Lockbox" 1 => "Showing System" 2 => "List Salesperson" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Burfield" +"StreetNumber": "57" +"StreetSuffix": "Avenue" +"TaxAnnualAmount": "4671.0" +"TaxAssessedValue": 312000 +"TaxLegalDescription": "LT 102, PL 964 ; HAMILTON ; SUBJECT TO EXECUTION 94-01495, IF ENFORCEABLE. ; SUBJECT TO EXECUTION 94-03033, IF ENFORCEABLE. ;" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2% + HST" +"TransactionType": "For Sale" +"UFFI": "No" +"DDFYN": true +"Water": "Municipal" +"GasYNA": "Available" +"CableYNA": "Available" +"HeatType": "Forced Air" +"LotDepth": 100.21 +"LotWidth": 49.44 +"SewerYNA": "Available" +"WaterYNA": "Available" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12260983')" +"GarageType": "None" +"HeatSource": "Gas" +"RollNumber": "251806056401740" +"SurveyType": "None" +"ElectricYNA": "Available" +"RentalItems": "none" +"HoldoverDays": 90 +"LaundryLevel": "Lower Level" +"TelephoneYNA": "Available" +"KitchensTotal": 1 +"ParkingSpaces": 4 +"provider_name": "TRREB" +"ApproximateAge": "51-99" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included In" ] +"PossessionType": "Flexible" +"PriorMlsStatus": "New" +"WashroomsType1": 1 +"WashroomsType2": 1 +"CentralVacuumYN": true +"DenFamilyroomYN": true +"LivingAreaRange": "700-1100" +"RoomsAboveGrade": 8 +"RoomsBelowGrade": 5 +"LotSizeAreaUnits": "Acres" +"PropertyFeatures": array:6 [ 0 => "Library" 1 => "Park" 2 => "Place Of Worship" 3 => "Public Transit" 4 => "Rec./Commun.Centre" 5 => "School" ] +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 3 +"WashroomsType2Pcs": 2 +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"LeaseToOwnEquipment": array:1 [ 0 => "None" ] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Main" +"MediaChangeTimestamp": "2025-07-04T17:54:57Z" +"SystemModificationTimestamp": "2025-07-25T19:13:46.670939Z" +"VendorPropertyInfoStatement": true +"Media": array:50 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] 31 => array:26 [ …26] 32 => array:26 [ …26] 33 => array:26 [ …26] 34 => array:26 [ …26] 35 => array:26 [ …26] 36 => array:26 [ …26] 37 => array:26 [ …26] 38 => array:26 [ …26] 39 => array:26 [ …26] 40 => array:26 [ …26] 41 => array:26 [ …26] 42 => array:26 [ …26] 43 => array:26 [ …26] 44 => array:26 [ …26] 45 => array:26 [ …26] 46 => array:26 [ …26] 47 => array:26 [ …26] 48 => array:26 [ …26] 49 => array:26 [ …26] ] } ] +success: true +page_size: 10 +page_count: 416 +count: 4155 +after_key: "" } ] ]
