4070 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: 048bdb86384c203fe1b5d3e0632f40da3f81fa36e8a9c95f3791d8e0dbabad84" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#14355 +items: array:10 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14541 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12261811" +"ListingId": "X12261811" +"PropertyType": "Residential" +"PropertySubType": "Condo Townhouse" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-04T12:33:53Z" +"RFModificationTimestamp": "2025-07-04T19:47:22.347898+00:00" +"ListPrice": 669000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8E 5V6" +"UnparsedAddress": "#28 - 44 Frances Avenue, Hamilton, ON L8E 5V6" +"Coordinates": array:2 [ 0 => -79.8728583 1 => 43.2560802 ] +"Latitude": 43.2560802 +"Longitude": -79.8728583 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "EXP REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to 44 Frances Ave #28! An exceptionally maintained townhome in a fantastic Stoney Creek neighbourhood! Perfect for first-time buyers, investors, commuters, or those looking to downsize, this move in ready 3-bedroom, 2.5-bath home backs onto serene green space and is just steps from Lake Ontario, parks, and minutes from the QEW. The main level has an open-concept layout and features hardwood flooring, a spacious kitchen, and a comfortable living and dining area. The second floor offers three generous sized bedrooms, including a primary bedroom with a private ensuite bath that has heated floors. The finished basement provides additional living space with a spacious recreation room, an additional bathroom, and laundry/storage area. Enjoy summer nights in your private backyard oasis with privacy and gorgeous views of lush greenery. The home also features an attached garage with inside entry and plenty of visitor parking within the complex. With Edgelake Park just across the street, nearby schools, trails, shopping, and unbeatable highway access, this home truly has it all!" +"ArchitecturalStyle": array:1 [ 0 => "2-Storey" ] +"AssociationAmenities": array:1 [ 0 => "Visitor Parking" ] +"AssociationFee": "457.2" +"AssociationFeeIncludes": array:2 [ 0 => "Water Included" 1 => "Parking Included" ] +"Basement": array:1 [ 0 => "Finished" ] +"CityRegion": "Stoney Creek" +"CoListOfficeName": "EXP REALTY" +"CoListOfficePhone": "866-530-7737" +"ConstructionMaterials": array:2 [ 0 => "Brick" 1 => "Vinyl Siding" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CoveredSpaces": "1.0" +"CreationDate": "2025-07-04T12:52:34.987107+00:00" +"CrossStreet": "N Service Rd" +"Directions": "N Service Rd to Teal Ave to Frances Ave" +"ExpirationDate": "2025-10-04" +"ExteriorFeatures": array:1 [ 0 => "Deck" ] +"GarageYN": true +"InteriorFeatures": array:2 [ 0 => "Auto Garage Door Remote" 1 => "Carpet Free" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "In Basement" ] +"ListAOR": "Niagara Association of REALTORS" +"ListingContractDate": "2025-07-04" +"LotSizeSource": "MPAC" +"MainOfficeKey": "285400" +"MajorChangeTimestamp": "2025-07-04T12:33:53Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-07-04T12:33:53Z" +"OriginalListPrice": 669000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2654156" +"ParcelNumber": "182250028" +"ParkingFeatures": array:1 [ 0 => "Private" ] +"ParkingTotal": "2.0" +"PetsAllowed": array:1 [ 0 => "Restricted" ] +"PhotosChangeTimestamp": "2025-07-04T12:33:53Z" +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Frances" +"StreetNumber": "44" +"StreetSuffix": "Avenue" +"TaxAnnualAmount": "3843.08" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2% + HST" +"TransactionType": "For Sale" +"UnitNumber": "28" +"DDFYN": true +"Locker": "None" +"Exposure": "West" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12261811')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "251800304027084" +"SurveyType": "Unknown" +"BalconyType": "Open" +"RentalItems": "HWT" +"HoldoverDays": 60 +"LegalStories": "1" +"ParkingType1": "Owned" +"KitchensTotal": 1 +"ParkingSpaces": 1 +"UnderContract": array:1 [ 0 => "Hot Water Heater" ] +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8E 5V6, CA" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included In" ] +"PossessionType": "60-89 days" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"CondoCorpNumber": 225 +"DenFamilyroomYN": true +"LivingAreaRange": "1200-1399" +"RoomsAboveGrade": 11 +"PropertyFeatures": array:3 [ 0 => "Cul de Sac/Dead End" 1 => "Park" 2 => "Beach" ] +"SquareFootSource": "1332" +"PossessionDetails": "60+" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 3 +"WashroomsType3Pcs": 2 +"BedroomsAboveGrade": 3 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"ShowingAppointments": "Brokerbay" +"WashroomsType1Level": "Second" +"WashroomsType2Level": "Second" +"WashroomsType3Level": "Basement" +"LegalApartmentNumber": "28" +"MediaChangeTimestamp": "2025-07-04T12:33:53Z" +"PropertyManagementCompany": "Enfield Group Inc." +"SystemModificationTimestamp": "2025-07-04T12:33:54.070963Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:45 [ 0 => array:26 [ "Order" => 0 "ImageOf" => null "MediaKey" => "54f81972-bd29-467e-b945-3681bdf7d0e9" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12261811/0a99297c4f5b789d927769e6894342b3.webp" "ClassName" => "ResidentialCondo" "MediaHTML" => null "MediaSize" => 1158895 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12261811/thumbnail-0a99297c4f5b789d927769e6894342b3.webp" "ImageWidth" => 2254 "Permission" => array:1 [ …1] "ImageHeight" => 1985 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "54f81972-bd29-467e-b945-3681bdf7d0e9" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => true "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12261811" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "54f81972-bd29-467e-b945-3681bdf7d0e9" "ModificationTimestamp" => "2025-07-04T12:33:53.662365Z" "MediaModificationTimestamp" => "2025-07-04T12:33:53.662365Z" ] 1 => array:26 [ "Order" => 1 "ImageOf" => null "MediaKey" => "3520139c-77a9-4935-8cdd-5010020fdcc4" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12261811/75513d5142c75f4c2f84287c10acf0fd.webp" "ClassName" => "ResidentialCondo" "MediaHTML" => null "MediaSize" => 1161020 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12261811/thumbnail-75513d5142c75f4c2f84287c10acf0fd.webp" "ImageWidth" => 3000 "Permission" => array:1 [ …1] "ImageHeight" => 1688 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "3520139c-77a9-4935-8cdd-5010020fdcc4" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12261811" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "3520139c-77a9-4935-8cdd-5010020fdcc4" "ModificationTimestamp" => "2025-07-04T12:33:53.662365Z" "MediaModificationTimestamp" => "2025-07-04T12:33:53.662365Z" ] 2 => array:26 [ "Order" => 2 "ImageOf" => null "MediaKey" => "19a0a667-e710-4bf2-b101-a2729afaeabd" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12261811/0fc1cebf785da8fc9d2db8be6ccd6562.webp" "ClassName" => "ResidentialCondo" "MediaHTML" => null "MediaSize" => 1257034 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12261811/thumbnail-0fc1cebf785da8fc9d2db8be6ccd6562.webp" "ImageWidth" => 3000 "Permission" => array:1 [ …1] "ImageHeight" => 1688 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "19a0a667-e710-4bf2-b101-a2729afaeabd" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12261811" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "19a0a667-e710-4bf2-b101-a2729afaeabd" "ModificationTimestamp" => "2025-07-04T12:33:53.662365Z" "MediaModificationTimestamp" => "2025-07-04T12:33:53.662365Z" ] 3 => array:26 [ "Order" => 3 "ImageOf" => null "MediaKey" => "2aa9b20f-dec8-45c9-b025-8005ef2a4fa5" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12261811/3e49f80d974b5e1a55a7c51f47d64bb0.webp" "ClassName" => "ResidentialCondo" "MediaHTML" => null "MediaSize" => 1113711 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12261811/thumbnail-3e49f80d974b5e1a55a7c51f47d64bb0.webp" "ImageWidth" => 3000 "Permission" => array:1 [ …1] "ImageHeight" => 1688 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "2aa9b20f-dec8-45c9-b025-8005ef2a4fa5" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12261811" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "2aa9b20f-dec8-45c9-b025-8005ef2a4fa5" "ModificationTimestamp" => "2025-07-04T12:33:53.662365Z" "MediaModificationTimestamp" => "2025-07-04T12:33:53.662365Z" ] 4 => array:26 [ "Order" => 4 "ImageOf" => null "MediaKey" => "2059ae73-c248-470d-9f32-5ad6291037f5" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12261811/04ec15065e138e90c9970ffcfd57ef37.webp" "ClassName" => "ResidentialCondo" "MediaHTML" => null "MediaSize" => 1279392 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12261811/thumbnail-04ec15065e138e90c9970ffcfd57ef37.webp" "ImageWidth" => 3000 "Permission" => array:1 [ …1] "ImageHeight" => 1688 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "2059ae73-c248-470d-9f32-5ad6291037f5" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12261811" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "2059ae73-c248-470d-9f32-5ad6291037f5" "ModificationTimestamp" => "2025-07-04T12:33:53.662365Z" "MediaModificationTimestamp" => "2025-07-04T12:33:53.662365Z" ] 5 => array:26 [ "Order" => 5 "ImageOf" => null "MediaKey" => "b440530e-b017-49fb-83c1-f87f0405578e" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12261811/5fb9802142de3f17e0a478659c8c6c1b.webp" "ClassName" => "ResidentialCondo" "MediaHTML" => null "MediaSize" => 1256005 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12261811/thumbnail-5fb9802142de3f17e0a478659c8c6c1b.webp" "ImageWidth" => 2000 "Permission" => array:1 [ …1] "ImageHeight" => 3000 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "b440530e-b017-49fb-83c1-f87f0405578e" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12261811" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "b440530e-b017-49fb-83c1-f87f0405578e" "ModificationTimestamp" => "2025-07-04T12:33:53.662365Z" "MediaModificationTimestamp" => "2025-07-04T12:33:53.662365Z" ] 6 => array:26 [ "Order" => 6 "ImageOf" => null "MediaKey" => "6a814a13-e16a-4d6f-a50e-5a496b5e6267" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12261811/009fd9272672e9b9c097ea63089541e0.webp" "ClassName" => "ResidentialCondo" "MediaHTML" => null "MediaSize" => 574146 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12261811/thumbnail-009fd9272672e9b9c097ea63089541e0.webp" "ImageWidth" => 3000 "Permission" => array:1 [ …1] "ImageHeight" => 2000 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "6a814a13-e16a-4d6f-a50e-5a496b5e6267" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12261811" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "6a814a13-e16a-4d6f-a50e-5a496b5e6267" "ModificationTimestamp" => "2025-07-04T12:33:53.662365Z" "MediaModificationTimestamp" => "2025-07-04T12:33:53.662365Z" ] 7 => array:26 [ "Order" => 7 "ImageOf" => null "MediaKey" => "448671a9-eb9d-40ca-badb-0b53dc2b4ac9" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12261811/00feb2f144f7e8979a0152ea51d9dc04.webp" "ClassName" => "ResidentialCondo" "MediaHTML" => null "MediaSize" => 631397 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12261811/thumbnail-00feb2f144f7e8979a0152ea51d9dc04.webp" "ImageWidth" => 3000 "Permission" => array:1 [ …1] "ImageHeight" => 2000 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "448671a9-eb9d-40ca-badb-0b53dc2b4ac9" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12261811" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "448671a9-eb9d-40ca-badb-0b53dc2b4ac9" "ModificationTimestamp" => "2025-07-04T12:33:53.662365Z" "MediaModificationTimestamp" => "2025-07-04T12:33:53.662365Z" ] 8 => array:26 [ "Order" => 8 "ImageOf" => null "MediaKey" => "1581f59d-ab9e-4375-a793-84c6d3e7f917" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12261811/050e70dd373ee05e93493d4be609dc7b.webp" "ClassName" => "ResidentialCondo" "MediaHTML" => null "MediaSize" => 1356020 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12261811/thumbnail-050e70dd373ee05e93493d4be609dc7b.webp" "ImageWidth" => 3000 "Permission" => array:1 [ …1] "ImageHeight" => 2000 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "1581f59d-ab9e-4375-a793-84c6d3e7f917" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12261811" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "1581f59d-ab9e-4375-a793-84c6d3e7f917" "ModificationTimestamp" => "2025-07-04T12:33:53.662365Z" "MediaModificationTimestamp" => "2025-07-04T12:33:53.662365Z" ] 9 => array:26 [ "Order" => 9 "ImageOf" => null "MediaKey" => "0ad6a04d-c2d6-4792-8101-dbd550336301" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12261811/6e7dabe056d02fbc271c77b03d2f3c63.webp" "ClassName" => "ResidentialCondo" "MediaHTML" => null "MediaSize" => 624630 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12261811/thumbnail-6e7dabe056d02fbc271c77b03d2f3c63.webp" "ImageWidth" => 3000 "Permission" => array:1 [ …1] "ImageHeight" => 2000 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "0ad6a04d-c2d6-4792-8101-dbd550336301" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12261811" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "0ad6a04d-c2d6-4792-8101-dbd550336301" "ModificationTimestamp" => "2025-07-04T12:33:53.662365Z" "MediaModificationTimestamp" => "2025-07-04T12:33:53.662365Z" ] 10 => array:26 [ "Order" => 10 "ImageOf" => null "MediaKey" => "adfedd00-efeb-4e96-aa0f-f415f4191526" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12261811/e377148b9c1f44a727e116765b9f6d04.webp" "ClassName" => "ResidentialCondo" "MediaHTML" => null "MediaSize" => 682308 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12261811/thumbnail-e377148b9c1f44a727e116765b9f6d04.webp" "ImageWidth" => 3000 "Permission" => array:1 [ …1] "ImageHeight" => 2000 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "adfedd00-efeb-4e96-aa0f-f415f4191526" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12261811" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "adfedd00-efeb-4e96-aa0f-f415f4191526" "ModificationTimestamp" => "2025-07-04T12:33:53.662365Z" "MediaModificationTimestamp" => "2025-07-04T12:33:53.662365Z" ] 11 => array:26 [ "Order" => 11 "ImageOf" => null "MediaKey" => "632f353c-00a2-4741-aa6b-ae4336d5e6c2" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12261811/07fd5ca7ae8cd440c1a5eb9d070cc678.webp" "ClassName" => "ResidentialCondo" "MediaHTML" => null "MediaSize" => 583725 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12261811/thumbnail-07fd5ca7ae8cd440c1a5eb9d070cc678.webp" "ImageWidth" => 3000 "Permission" => array:1 [ …1] "ImageHeight" => 2000 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "632f353c-00a2-4741-aa6b-ae4336d5e6c2" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12261811" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "632f353c-00a2-4741-aa6b-ae4336d5e6c2" "ModificationTimestamp" => "2025-07-04T12:33:53.662365Z" "MediaModificationTimestamp" => "2025-07-04T12:33:53.662365Z" ] 12 => array:26 [ "Order" => 12 "ImageOf" => null "MediaKey" => "33c6937d-cb90-46aa-a440-095e9819dd0c" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12261811/105d689e693bb324b42e5e3d90ec08d3.webp" "ClassName" => "ResidentialCondo" "MediaHTML" => null "MediaSize" => 579926 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12261811/thumbnail-105d689e693bb324b42e5e3d90ec08d3.webp" "ImageWidth" => 3000 "Permission" => array:1 [ …1] "ImageHeight" => 2000 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "33c6937d-cb90-46aa-a440-095e9819dd0c" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12261811" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "33c6937d-cb90-46aa-a440-095e9819dd0c" "ModificationTimestamp" => "2025-07-04T12:33:53.662365Z" "MediaModificationTimestamp" => "2025-07-04T12:33:53.662365Z" ] 13 => array:26 [ "Order" => 13 "ImageOf" => null "MediaKey" => "adfcd6be-f8d2-4700-82ab-be6aa420bdc9" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12261811/28f20ca8d0465a319ae4451b61777486.webp" "ClassName" => "ResidentialCondo" "MediaHTML" => null "MediaSize" => 659783 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12261811/thumbnail-28f20ca8d0465a319ae4451b61777486.webp" "ImageWidth" => 3000 "Permission" => array:1 [ …1] "ImageHeight" => 2000 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "adfcd6be-f8d2-4700-82ab-be6aa420bdc9" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12261811" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "adfcd6be-f8d2-4700-82ab-be6aa420bdc9" "ModificationTimestamp" => "2025-07-04T12:33:53.662365Z" "MediaModificationTimestamp" => "2025-07-04T12:33:53.662365Z" ] 14 => array:26 [ "Order" => 14 "ImageOf" => null "MediaKey" => "59458d49-4c3f-4dfb-a727-a10f79d29d89" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12261811/d0c27800e7af87d60aa9270b5c6c4175.webp" "ClassName" => "ResidentialCondo" "MediaHTML" => null "MediaSize" => 953774 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12261811/thumbnail-d0c27800e7af87d60aa9270b5c6c4175.webp" "ImageWidth" => 3000 "Permission" => array:1 [ …1] "ImageHeight" => 2000 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "59458d49-4c3f-4dfb-a727-a10f79d29d89" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12261811" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "59458d49-4c3f-4dfb-a727-a10f79d29d89" "ModificationTimestamp" => "2025-07-04T12:33:53.662365Z" "MediaModificationTimestamp" => "2025-07-04T12:33:53.662365Z" ] 15 => array:26 [ "Order" => 15 "ImageOf" => null "MediaKey" => "c098cae6-a7e3-4c9b-a839-807c9550e729" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12261811/ceb4b736f1ea2e75613cbd001bfa626c.webp" "ClassName" => "ResidentialCondo" "MediaHTML" => null "MediaSize" => 938731 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12261811/thumbnail-ceb4b736f1ea2e75613cbd001bfa626c.webp" "ImageWidth" => 3000 "Permission" => array:1 [ …1] "ImageHeight" => 2000 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "c098cae6-a7e3-4c9b-a839-807c9550e729" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12261811" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "c098cae6-a7e3-4c9b-a839-807c9550e729" "ModificationTimestamp" => "2025-07-04T12:33:53.662365Z" "MediaModificationTimestamp" => "2025-07-04T12:33:53.662365Z" ] 16 => array:26 [ "Order" => 16 "ImageOf" => null "MediaKey" => "59aa7584-374c-401b-b873-f0f71f97a1e5" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12261811/5eaff55db634801b2247d540f23bcc67.webp" "ClassName" => "ResidentialCondo" "MediaHTML" => null "MediaSize" => 856183 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12261811/thumbnail-5eaff55db634801b2247d540f23bcc67.webp" "ImageWidth" => 3000 "Permission" => array:1 [ …1] "ImageHeight" => 2000 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "59aa7584-374c-401b-b873-f0f71f97a1e5" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12261811" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "59aa7584-374c-401b-b873-f0f71f97a1e5" "ModificationTimestamp" => "2025-07-04T12:33:53.662365Z" "MediaModificationTimestamp" => "2025-07-04T12:33:53.662365Z" ] 17 => array:26 [ "Order" => 17 "ImageOf" => null "MediaKey" => "ff066416-7286-4ed8-85a3-9afc8aa3f467" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12261811/c62b83ee7f77248e21202c4dc9760996.webp" "ClassName" => "ResidentialCondo" "MediaHTML" => null "MediaSize" => 832694 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12261811/thumbnail-c62b83ee7f77248e21202c4dc9760996.webp" "ImageWidth" => 3000 "Permission" => array:1 [ …1] "ImageHeight" => 2000 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "ff066416-7286-4ed8-85a3-9afc8aa3f467" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12261811" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "ff066416-7286-4ed8-85a3-9afc8aa3f467" "ModificationTimestamp" => "2025-07-04T12:33:53.662365Z" "MediaModificationTimestamp" => "2025-07-04T12:33:53.662365Z" ] 18 => array:26 [ "Order" => 18 "ImageOf" => null "MediaKey" => "52f52d82-aabd-4db8-a436-bf91f6ef5634" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12261811/96894e7997d0a86b6df8e872ec3035aa.webp" "ClassName" => "ResidentialCondo" "MediaHTML" => null "MediaSize" => 911862 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12261811/thumbnail-96894e7997d0a86b6df8e872ec3035aa.webp" "ImageWidth" => 3000 "Permission" => array:1 [ …1] "ImageHeight" => 2000 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "52f52d82-aabd-4db8-a436-bf91f6ef5634" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12261811" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "52f52d82-aabd-4db8-a436-bf91f6ef5634" "ModificationTimestamp" => "2025-07-04T12:33:53.662365Z" "MediaModificationTimestamp" => "2025-07-04T12:33:53.662365Z" ] 19 => array:26 [ "Order" => 19 "ImageOf" => null "MediaKey" => "bfd5a5a3-c571-49f5-bc83-635d1093090a" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12261811/cf9a1ddd11066e44b89ff0c55be44daf.webp" "ClassName" => "ResidentialCondo" "MediaHTML" => null "MediaSize" => 765564 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12261811/thumbnail-cf9a1ddd11066e44b89ff0c55be44daf.webp" "ImageWidth" => 3000 "Permission" => array:1 [ …1] "ImageHeight" => 2000 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "bfd5a5a3-c571-49f5-bc83-635d1093090a" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12261811" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "bfd5a5a3-c571-49f5-bc83-635d1093090a" "ModificationTimestamp" => "2025-07-04T12:33:53.662365Z" "MediaModificationTimestamp" => "2025-07-04T12:33:53.662365Z" ] 20 => array:26 [ "Order" => 20 "ImageOf" => null "MediaKey" => "c6c8e3a4-b5e7-4c3f-9e01-603648af7679" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12261811/ab453165202e208abec9e2130a025b95.webp" "ClassName" => "ResidentialCondo" "MediaHTML" => null "MediaSize" => 1042153 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12261811/thumbnail-ab453165202e208abec9e2130a025b95.webp" "ImageWidth" => 3000 "Permission" => array:1 [ …1] "ImageHeight" => 2000 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "c6c8e3a4-b5e7-4c3f-9e01-603648af7679" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12261811" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "c6c8e3a4-b5e7-4c3f-9e01-603648af7679" "ModificationTimestamp" => "2025-07-04T12:33:53.662365Z" "MediaModificationTimestamp" => "2025-07-04T12:33:53.662365Z" ] 21 => array:26 [ "Order" => 21 "ImageOf" => null "MediaKey" => "b212279d-4127-4b5b-a7ce-9be9efdd111d" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12261811/d47e099f1ea15495e5dbde85e809a426.webp" "ClassName" => "ResidentialCondo" "MediaHTML" => null "MediaSize" => 1233404 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12261811/thumbnail-d47e099f1ea15495e5dbde85e809a426.webp" "ImageWidth" => 3000 "Permission" => array:1 [ …1] "ImageHeight" => 2000 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "b212279d-4127-4b5b-a7ce-9be9efdd111d" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12261811" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "b212279d-4127-4b5b-a7ce-9be9efdd111d" "ModificationTimestamp" => "2025-07-04T12:33:53.662365Z" "MediaModificationTimestamp" => "2025-07-04T12:33:53.662365Z" ] 22 => array:26 [ "Order" => 22 "ImageOf" => null "MediaKey" => "4a0b3c81-1c11-4b13-9efd-c624c92e2673" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12261811/f10f2db6cb03171694d1cb2dc61615b1.webp" "ClassName" => "ResidentialCondo" "MediaHTML" => null "MediaSize" => 1522878 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12261811/thumbnail-f10f2db6cb03171694d1cb2dc61615b1.webp" "ImageWidth" => 3000 "Permission" => array:1 [ …1] "ImageHeight" => 2000 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "4a0b3c81-1c11-4b13-9efd-c624c92e2673" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" …5 ] 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] ] } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14542 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12261794" +"ListingId": "X12261794" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-04T12:22:53Z" +"RFModificationTimestamp": "2025-07-04T19:47:22.012990+00:00" +"ListPrice": 1499900.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L0R 2H9" +"UnparsedAddress": "8 Macbean Crescent, Hamilton, ON L0R 2H9" +"Coordinates": array:2 [ 0 => -79.9145706 1 => 43.3359482 ] +"Latitude": 43.3359482 +"Longitude": -79.9145706 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "PROSENSE REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Fabulous all Brick Detached Home With Nothing To Do But Move In! Over 3800 sq ft of living space, 4 Bedrooms /4 Washrooms, Great Rm W/ Luxury Coffered Ceilings, Pot Lights,Wainscotting, Gas Fp. Upgraded Kitchen W/ Granite Countertops, B/I Cooktop/Range, Pendant Lights. Mudrm W/ Access To Garage. Primary Bed Has Walk- In Closet, Std Closet, 5 Piece Ensuite. Front Bed Has Walk-In Closet And Ensuite Basement W/ Recrm, Bed, Full Bath, Laundry, Storage. Backyard W/ Exposed Aggregate Patio, Shed, Play area. Easy Access To All Amenities. Minutes to Mc Master university and much more!!!" +"ArchitecturalStyle": array:1 [ 0 => "2-Storey" ] +"Basement": array:1 [ 0 => "Finished" ] +"CityRegion": "Waterdown" +"ConstructionMaterials": array:2 [ 0 => "Brick" 1 => "Vinyl Siding" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CoveredSpaces": "2.0" +"CreationDate": "2025-07-04T12:27:40.035893+00:00" +"CrossStreet": "Parkside Dr/ Wimberley" +"DirectionFaces": "North" +"Directions": "Parkside Dr/ Wimberley" +"ExpirationDate": "2025-09-04" +"FireplaceYN": true +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"GarageYN": true +"Inclusions": "Stainless steel Gas Stove, Hood fan, Fridge Dishwasher, Built in micro/oven ,Washer Dryer." +"InteriorFeatures": array:1 [ 0 => "None" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-07-04" +"LotSizeSource": "MPAC" +"MainOfficeKey": "301100" +"MajorChangeTimestamp": "2025-07-04T12:22:53Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-07-04T12:22:53Z" +"OriginalListPrice": 1499900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2659686" +"ParcelNumber": "175111371" +"ParkingFeatures": array:1 [ 0 => "Private Double" ] +"ParkingTotal": "6.0" +"PhotosChangeTimestamp": "2025-07-04T12:22:53Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"Roof": array:1 [ 0 => "Shingles" ] +"Sewer": array:1 [ 0 => "None" ] +"ShowingRequirements": array:2 [ 0 => "Lockbox" 1 => "Showing System" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Macbean" +"StreetNumber": "8" +"StreetSuffix": "Crescent" +"TaxAnnualAmount": "7400.0" +"TaxLegalDescription": "LOT 51, PLAN 62M1218 SUBJECT TO AN EASEMENT AS IN WE475770 SUBJECT TO AN EASEMENT IN GROSS AS IN WE1063009 SUBJECT TO AN EASEMENT FOR ENTRY AS IN WE1093893 SUBJECT TO AN EASEMENT OVER PART 10 ON 62R20360 IN FAVOUR OF LOT 52 ON 62M1218 AS IN WE1161441 TOGETHER WITH AN EASEMENT OVER PART 11 ON 62R20360 AS IN WE1161441 SUBJECT TO AN EASEMENT FOR ENTRY AS IN WE1190746 CITY OF HAMILTON" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2%" +"TransactionType": "For Sale" +"VirtualTourURLUnbranded": "https://unbranded.mediatours.ca/property/8-macbean-crescent-hamilton/" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 88.0 +"LotWidth": 40.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12261794')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "251830342003251" +"SurveyType": "None" +"RentalItems": "Hot water Tank." +"HoldoverDays": 60 +"KitchensTotal": 1 +"ParkingSpaces": 4 +"provider_name": "TRREB" +"short_address": "Hamilton, ON L0R 2H9, CA" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included In" ] +"PossessionDate": "2025-07-04" +"PossessionType": "Immediate" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"WashroomsType4": 1 +"DenFamilyroomYN": true +"LivingAreaRange": "2500-3000" +"RoomsAboveGrade": 9 +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 3 +"WashroomsType3Pcs": 2 +"WashroomsType4Pcs": 3 +"BedroomsAboveGrade": 4 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"WashroomsType1Level": "Second" +"WashroomsType2Level": "Second" +"WashroomsType3Level": "Main" +"WashroomsType4Level": "Basement" +"MediaChangeTimestamp": "2025-07-04T12:22:53Z" +"SystemModificationTimestamp": "2025-07-04T12:22:54.407593Z" +"Media": array:38 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] 31 => array:26 [ …26] 32 => array:26 [ …26] 33 => array:26 [ …26] 34 => array:26 [ …26] 35 => array:26 [ …26] 36 => array:26 [ …26] 37 => array:26 [ …26] ] } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14548 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X11890294" +"ListingId": "X11890294" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-04T10:45:20Z" +"RFModificationTimestamp": "2025-07-04T10:56:51.143954+00:00" +"ListPrice": 649999.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8L 2L8" +"UnparsedAddress": "8 Harvey Street, Hamilton, On L8l 2l8" +"Coordinates": array:2 [ 0 => -79.843284048987 1 => 43.255675953801 ] +"Latitude": 43.255675953801 +"Longitude": -79.843284048987 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RIGHT AT HOME REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to Hamilton, a vibrant and culturally diverse city! This fully renovated modern home, complete with an in-law suite, has been a model project by a renowned European builder for the past decade. All renovations were completed under city permits and inspections. Situated in the heart of the city, just 100 meters from Tim Hortons, City Park, the recreation center, stores, and bus stops, this 1,750 sq. ft. open-concept two-story home offers exceptional convenience. The main floor features a brand-new open kitchen, a bright dining room, a spacious family room, and a 3-piece washroom. The family room can also serve as an office or additional bedroom. Upstairs, you'll find three spacious, sunlit bedrooms and a luxurious 3-piece bathroom. The master bedroom includes an ensuite, a closet, and a balcony with breathtaking city and escarpment views. The full-sized basement (approximately 750 sq. ft.) boasts high ceilings, large windows, and two walk-out doors, giving it a ground-floor feel. Its perfect for a large family or as a rental unit, providing income potential without compromising privacy. Outside, the landscaped yard features a new metal fence, a mature tree offering plenty of shade. Beyond the backyard are Tim Hortons and local shops for your convenience. To facilitate your purchase, the owner is open to a Vendor Take-Back Mortgage. Don't miss this rare investment opportunity . act quickly!" +"ArchitecturalStyle": array:1 [ 0 => "2-Storey" ] +"Basement": array:1 [ 0 => "Unfinished" ] +"CityRegion": "Gibson" +"ConstructionMaterials": array:2 [ 0 => "Brick" 1 => "Stucco (Plaster)" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2024-12-16T15:07:39.266239+00:00" +"CrossStreet": "Harvey /Sanford Ave N" +"DirectionFaces": "North" +"ExpirationDate": "2025-09-30" +"FoundationDetails": array:1 [ 0 => "Unknown" ] +"InteriorFeatures": array:1 [ 0 => "Water Heater" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2024-12-12" +"MainOfficeKey": "062200" +"MajorChangeTimestamp": "2025-05-12T15:02:49Z" +"MlsStatus": "Price Change" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2024-12-12T14:43:52Z" +"OriginalListPrice": 699000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft1782378" +"ParcelNumber": "171960277" +"ParkingFeatures": array:1 [ 0 => "Available" ] +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-05-14T12:53:08Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"PreviousListPrice": 699000.0 +"PriceChangeTimestamp": "2025-05-12T15:02:49Z" +"Roof": array:1 [ 0 => "Asphalt Rolled" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:1 [ 0 => "Lockbox" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Harvey" +"StreetNumber": "8" +"StreetSuffix": "Street" +"TaxAnnualAmount": "3500.0" +"TaxLegalDescription": "PT LT 3-4 PL 170 AS IN VM103197; CITY OF HAMILTON" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2.5%" +"TransactionType": "For Sale" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 91.0 +"LotWidth": 31.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X11890294')" +"GarageType": "None" +"HeatSource": "Gas" +"RollNumber": "251803023406000" +"Waterfront": array:1 [ 0 => "None" ] +"HoldoverDays": 120 +"KitchensTotal": 1 +"provider_name": "TRREB" +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "No" ] +"PossessionDate": "2024-12-31" +"PriorMlsStatus": "New" +"WashroomsType1": 3 +"DenFamilyroomYN": true +"LivingAreaRange": "1500-2000" +"RoomsAboveGrade": 8 +"WashroomsType1Pcs": 3 +"BedroomsAboveGrade": 3 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"ShowingAppointments": "Thr listing ag" +"MediaChangeTimestamp": "2025-05-14T12:53:08Z" +"DevelopmentChargesPaid": array:1 [ 0 => "No" ] +"SystemModificationTimestamp": "2025-07-04T10:45:21.000193Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:29 [ 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] ] } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14545 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12215831" +"ListingId": "X12215831" +"PropertyType": "Residential" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-04T05:42:08Z" +"RFModificationTimestamp": "2025-07-04T05:46:15.134643+00:00" +"ListPrice": 309000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8K 5J5" +"UnparsedAddress": "#812 - 15 Nicklaus Drive, Hamilton, ON L8K 5J5" +"Coordinates": array:2 [ 0 => -79.8728583 1 => 43.2560802 ] +"Latitude": 43.2560802 +"Longitude": -79.8728583 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "KALLAY REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "This Gorgeous 2 Bedroom Condo Is Perfect For First Time Buyers And Downsizers In Prime Location. Features Modern Open Concept Living. Freshly Painted and Decorated Unit Offers Generous Space And Natural Light. Extremely Bright And Sunny West Exposure. Carpet Free Home. Laminate & Ceramic Floor Throughout. Central Island. Dining Room Has A Walk Out To The Large Balcony 20' 2" X 5' 8" With Spectacular Panoramic Views. Includes 1 Unassigned Parking Spot. Conveniently Located To Shops, Restaurants. Steps To Transit, Schools, Parks, Community Centre. Building Has Fantastic Amenities; Gym, Sauna, Party room, Outdoor Pool, Parkette, Onsite Laundry Room, Visitor Parking." +"ArchitecturalStyle": array:1 [ 0 => "Apartment" ] +"AssociationFee": "584.91" +"AssociationFeeIncludes": array:5 [ 0 => "Heat Included" 1 => "Water Included" 2 => "Common Elements Included" 3 => "Parking Included" 4 => "Building Insurance Included" ] +"Basement": array:1 [ 0 => "None" ] +"CityRegion": "Vincent" +"ConstructionMaterials": array:1 [ 0 => "Concrete" ] +"Cooling": array:1 [ 0 => "None" ] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2025-06-12T16:07:03.030675+00:00" +"CrossStreet": "Quigley/Albright" +"Directions": "Albright to Nicklaus" +"ExpirationDate": "2025-09-11" +"Inclusions": "stove" +"InteriorFeatures": array:1 [ 0 => "Carpet Free" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "Coin Operated" ] +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-06-12" +"LotSizeSource": "MPAC" +"MainOfficeKey": "209300" +"MajorChangeTimestamp": "2025-07-04T05:42:08Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-06-12T15:33:11Z" +"OriginalListPrice": 309000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2550168" +"ParcelNumber": "183090104" +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ 0 => "Restricted" ] +"PhotosChangeTimestamp": "2025-06-12T15:33:12Z" +"ShowingRequirements": array:1 [ 0 => "Lockbox" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Nicklaus" +"StreetNumber": "15" +"StreetSuffix": "Drive" +"TaxAnnualAmount": "1497.13" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2 % + Hst" +"TransactionType": "For Sale" +"UnitNumber": "812" +"DDFYN": true +"Locker": "None" +"Exposure": "West" +"HeatType": "Other" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12215831')" +"GarageType": "None" +"HeatSource": "Gas" +"RollNumber": "251805053404409" +"SurveyType": "None" +"BalconyType": "Open" +"HoldoverDays": 90 +"LegalStories": "7" +"ParkingType1": "Exclusive" +"KitchensTotal": 1 +"ParkingSpaces": 1 +"provider_name": "TRREB" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included In" ] +"PossessionType": "Immediate" +"PriorMlsStatus": "Sold Conditional" +"WashroomsType1": 1 +"CondoCorpNumber": 309 +"LivingAreaRange": "700-799" +"RoomsAboveGrade": 5 +"SquareFootSource": "estimate" +"PossessionDetails": "immediate" +"WashroomsType1Pcs": 4 +"BedroomsAboveGrade": 2 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"LegalApartmentNumber": "12" +"MediaChangeTimestamp": "2025-06-12T15:33:12Z" +"PropertyManagementCompany": "Lodestone Properties Inc." +"SystemModificationTimestamp": "2025-07-04T05:42:09.589199Z" +"SoldConditionalEntryTimestamp": "2025-06-17T23:21:11Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:38 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] 31 => array:26 [ …26] 32 => array:26 [ …26] 33 => array:26 [ …26] 34 => array:26 [ …26] 35 => array:26 [ …26] 36 => array:26 [ …26] 37 => array:26 [ …26] ] } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14540 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12221392" +"ListingId": "X12221392" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-04T04:50:20Z" +"RFModificationTimestamp": "2025-07-04T04:53:52.846248+00:00" +"ListPrice": 990000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0.2 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8E 4X8" +"UnparsedAddress": "15 Talia Court, Hamilton, ON L8E 4X8" +"Coordinates": array:2 [ 0 => -79.7650277 1 => 43.2362138 ] +"Latitude": 43.2362138 +"Longitude": -79.7650277 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "IPRO REALTY LTD." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Amazing East-End neighborhood, featuring 4 bedrooms, separate living room and dining room, eat in kitchen, large family room, main floor laundry room, attached double garage. In-law suite in fully finished basement, with another full kitchen, bedroom, washroom. Above the ground pool, covered backyard area with kitchen cabinets, wooden patio for entering backyard pool party. Your private backyard oasis" +"ArchitecturalStyle": array:1 [ 0 => "Bungalow" ] +"Basement": array:2 [ 0 => "Full" 1 => "Finished" ] +"CityRegion": "Kentley" +"ConstructionMaterials": array:2 [ 0 => "Aluminum Siding" 1 => "Brick" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CoveredSpaces": "2.0" +"CreationDate": "2025-06-14T17:30:06.048417+00:00" +"CrossStreet": "Kenora & Janet" +"DirectionFaces": "East" +"Directions": "Kenora & Janet" +"ExpirationDate": "2025-09-14" +"ExteriorFeatures": array:3 [ 0 => "Hot Tub" 1 => "Landscaped" 2 => "Recreational Area" ] +"FireplaceYN": true +"FireplacesTotal": "2" +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"GarageYN": true +"Inclusions": "Washer/ Dryer, Fridge, Stove, Microwave." +"InteriorFeatures": array:1 [ 0 => "None" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-06-13" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "158500" +"MajorChangeTimestamp": "2025-06-14T17:22:38Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-06-14T17:22:38Z" +"OriginalListPrice": 990000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2559748" +"ParcelNumber": "172960270" +"ParkingFeatures": array:1 [ 0 => "Private Double" ] +"ParkingTotal": "6.0" +"PhotosChangeTimestamp": "2025-07-04T04:50:20Z" +"PoolFeatures": array:1 [ 0 => "Above Ground" ] +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:2 [ 0 => "Lockbox" 1 => "Showing System" ] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Talia" +"StreetNumber": "15" +"StreetSuffix": "Court" +"TaxAnnualAmount": "7650.0" +"TaxLegalDescription": "PCL 13-1 SEC 62M575; LT 13, PL 62M575; S/T LT 231498, LT 241690" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2.0% + HST" +"TransactionType": "For Sale" +"VirtualTourURLBranded": "https://fusion.realtourvision.com/281520" +"VirtualTourURLUnbranded": "https://fusion.realtourvision.com/idx/281520" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 114.29 +"LotWidth": 26.86 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12221392')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "251805045400648" +"SurveyType": "Unknown" +"RentalItems": "Hot Water Tank" +"HoldoverDays": 90 +"KitchensTotal": 2 +"ParkingSpaces": 4 +"UnderContract": array:1 [ 0 => "Hot Water Heater" ] +"provider_name": "TRREB" +"ApproximateAge": "31-50" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included In" ] +"PossessionDate": "2025-07-01" +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 3 +"DenFamilyroomYN": true +"LivingAreaRange": "2500-3000" +"RoomsAboveGrade": 7 +"PropertyFeatures": array:6 [ 0 => "Fenced Yard" 1 => "Hospital" 2 => "Library" 3 => "Park" 4 => "Place Of Worship" 5 => "School" ] +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 4 +"BedroomsAboveGrade": 4 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 2 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"ShowingAppointments": "Broker Bay" +"MediaChangeTimestamp": "2025-07-04T04:50:20Z" +"SystemModificationTimestamp": "2025-07-04T04:50:23.6578Z" +"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] ] } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14519 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12073615" +"ListingId": "X12073615" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-04T03:20:54Z" +"RFModificationTimestamp": "2025-07-04T03:34:17.480117+00:00" +"ListPrice": 1950000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 10.42 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L9H 5E1" +"UnparsedAddress": "1243 Highway 5 West Highway, Hamilton, On L9h 5e1" +"Coordinates": array:2 [ 0 => -80.051766 1 => 43.28329 ] +"Latitude": 43.28329 +"Longitude": -80.051766 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "EXP REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome the historically famous Spencer Creek Raspberry Farm, nestled on 10.42 acres of lush farmland with endless possibilities to grow what your heart desires with a versatile hobby barn, utility garage, and triple car garage/workshop with attached greenhouse, and walk in cooler to store fresh picked produce - the opportunities are endless! Nestled between trees on a private wooded lot with Spencer Creek running at the back, you'll immediately fall in love with this move-in ready custom built 4 bedroom home. Immaculately clean with hardwood floors & tile throughout, you have the convenience of 2 kitchens, and 2 full bathrooms. The lower level ground entrance allows for wheelchair accessibility through the bright sunroom leading into open concept family room and kitchen area. Stocked with 4 yrs worth of chopped fire wood, the wood burning stove with built in venting system provides extra heat throughout both levels of the home. This fully bricked home features metal roof (2017), casement windows, 2 hydro poles (2017), sunroom, owned hot water tank, electrical panel approx. 12 yrs, 18 ft dug well with endless fresh water supply & UV filter. A2 zoning allows for many uses including vet services, kennel, retirement facility, slaughter house and more. Conveniently located 10 minutes from Hwy 403, major big box shopping, and restaurants you'll also enjoy the many golf courses nearby, hiking trails, Flamborough Casino, and Christie Lake Conservation - you do not want to miss out on this!" +"AccessibilityFeatures": array:2 [ 0 => "Shower Stall" 1 => "Wheelchair Access" ] +"ArchitecturalStyle": array:1 [ 0 => "Bungalow-Raised" ] +"Basement": array:1 [ 0 => "None" ] +"CityRegion": "Rural Flamborough" +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CoveredSpaces": "3.0" +"CreationDate": "2025-04-10T06:40:06.986188+00:00" +"CrossStreet": "Hwy 5 and Hwy 8" +"DirectionFaces": "North" +"Directions": "Exit Hwy 403 West at Hwy 6, Turn Left at Hwy 5" +"Exclusions": "Lawn mower, and deep freezer" +"ExpirationDate": "2025-07-31" +"ExteriorFeatures": array:1 [ 0 => "Privacy" ] +"FireplaceFeatures": array:2 [ 0 => "Natural Gas" 1 => "Wood Stove" ] +"FireplaceYN": true +"FoundationDetails": array:1 [ 0 => "Concrete Block" ] +"GarageYN": true +"Inclusions": "All window coverings, ELFs, appliances, Kubota tractor with attachments for farming and snow removal" +"InteriorFeatures": array:4 [ 0 => "Carpet Free" 1 => "Storage" 2 => "Water Heater Owned" 3 => "Wheelchair Access" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-04-10" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "285400" +"MajorChangeTimestamp": "2025-06-29T16:22:55Z" +"MlsStatus": "Extension" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-04-10T05:38:00Z" +"OriginalListPrice": 1950000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2219352" +"OtherStructures": array:3 [ 0 => "Greenhouse" 1 => "Shed" 2 => "Workshop" ] +"ParcelNumber": "175500100" +"ParkingFeatures": array:1 [ 0 => "Private" ] +"ParkingTotal": "13.0" +"PhotosChangeTimestamp": "2025-04-10T05:38:01Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"Roof": array:1 [ 0 => "Metal" ] +"Sewer": array:1 [ 0 => "Septic" ] +"ShowingRequirements": array:1 [ 0 => "Lockbox" ] +"SignOnPropertyYN": true +"SoilType": array:1 [ 0 => "Loam" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Highway 5 West" +"StreetNumber": "1243" +"StreetSuffix": "Highway" +"TaxAnnualAmount": "4292.5" +"TaxLegalDescription": "PT LTS 32 & 33, CON 3 BEVERLY , AS IN AB321309 ; FLAMBOROUGH CITY OF HAMILTON" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2%" +"TransactionType": "For Sale" +"View": array:4 [ 0 => "Trees/Woods" 1 => "Lake" 2 => "Garden" 3 => "Clear" ] +"VirtualTourURLBranded": "https://mediatours.ca/property/1243-highway-5-west-hamilton/" +"VirtualTourURLUnbranded": "https://unbranded.mediatours.ca/property/1243-highway-5-west-hamilton/" +"WaterBodyName": "Spencer Creek" +"Zoning": "P8, A2 pet services/retirement facility/slaughter" +"DDFYN": true +"Water": "Well" +"HeatType": "Forced Air" +"LotDepth": 411.0 +"LotShape": "Irregular" +"LotWidth": 1416.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12073615')" +"GarageType": "Detached" +"HeatSource": "Gas" +"RollNumber": "251830134065800" +"SurveyType": "Available" +"Waterfront": array:1 [ 0 => "Direct" ] +"FarmFeatures": array:2 [ 0 => "Cold Storage" 1 => "Equipment Included" ] +"HoldoverDays": 60 +"LaundryLevel": "Lower Level" +"KitchensTotal": 2 +"ParkingSpaces": 13 +"WaterBodyType": "Creek" +"provider_name": "TRREB" +"ApproximateAge": "31-50" +"AssessmentYear": 2024 +"ContractStatus": "Available" +"HSTApplication": array:2 [ 0 => "In Addition To" 1 => "Included In" ] +"PossessionType": "Flexible" +"PriorMlsStatus": "New" +"WashroomsType1": 1 +"WashroomsType2": 1 +"DenFamilyroomYN": true +"LivingAreaRange": "2500-3000" +"RoomsAboveGrade": 11 +"PropertyFeatures": array:6 [ 0 => "Clear View" 1 => "Golf" 2 => "School" 3 => "School Bus Route" 4 => "Wooded/Treed" 5 => "Campground" ] +"LotIrregularities": "Frontage 66.14 ft at driveway entrance" +"LotSizeRangeAcres": "10-24.99" +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 3 +"WashroomsType2Pcs": 4 +"BedroomsAboveGrade": 4 +"KitchensAboveGrade": 2 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"ShowingAppointments": "at least 2 hours notice" +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Lower" +"MediaChangeTimestamp": "2025-04-11T20:26:50Z" +"ExtensionEntryTimestamp": "2025-06-29T16:22:55Z" +"SystemModificationTimestamp": "2025-07-04T03:20:57.087593Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:41 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] 31 => array:26 [ …26] 32 => array:26 [ …26] 33 => array:26 [ …26] 34 => array:26 [ …26] 35 => array:26 [ …26] 36 => array:26 [ …26] 37 => array:26 [ …26] 38 => array:26 [ …26] 39 => array:26 [ …26] 40 => array:26 [ …26] ] } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14518 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12171811" +"ListingId": "X12171811" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-04T02:01:42Z" +"RFModificationTimestamp": "2025-07-04T02:06:16.618249+00:00" +"ListPrice": 769000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0.12 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L9C 3M1" +"UnparsedAddress": "6 West 4th Street, Hamilton, ON L9C 3M1" +"Coordinates": array:2 [ 0 => -79.8834459 1 => 43.234609 ] +"Latitude": 43.234609 +"Longitude": -79.8834459 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "REAL BROKER ONTARIO LTD." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "LEGAL DUPLEX!!!! 1400 SQ FT Total!. 700 SQFT EACH UNIT!! LOCATION LOCATION LOCATON!! SET YOUR OWN RENTS!!!! You will not find a better location on the Hamilton Mountain Then This LEGAL DUPLEX. FULLY RENOVATED FROM TOP TO BOTTOM!! Located 400m away from Mohawk College, 800m away from St. Joseph Healthcare West 5th campus . 2 km's away from St. Joseph's Healthcare Hamilton. 850m away from the Mountain Shopping plaza Renters Paradise!! This Property can be used in multiple ways. Fully Renovated from top to bottom this Turn Key Legal Duplex can be used as a mortgage helper Live in one unit (House Hack) and rent the other unit out for top rents. Being this close to the college you can achieve high rents as a Super Clean student rental (add a room to each level for extra extra cashflow make it 6 bedrooms). Located within close proximity to both hospitals creates a Medical Professionals Dream with a 3 min commute to work finding A+ tenants will be a breeze. With vacant possession you can find your own tenants and set your rents this Property Features : New roof 2021. All new Electrical, All New Plumbing, New floors, 2 New Kitchens both with Quartz counter tops slow close cabinets, 5 Stainless Steel Appliances in Each Unit. Washer/Dryer. Spray foamed basement making this a nice and warm lower level. Features: Two fully self contained units with separate entrances. 200 AMP SERVICE with 2 ELECTRICAL METERS ( 1 for each unit) tenants pays their own electricity. This property sits on a Large 50 ft x 103 ft Lot with the potential to build a 500 sqft garden suite or an addition to create a 3rd unit Buyer to verify. All permits closed with ESA certificates. You will not be disappointed with this property using it as a rental or as a mortgage helper. Property is registered with the city of Hamilton as a Duplex. 2.5 % + HST to buyer agent. Seller/Sellers agent does not warrant the retrofit status of basement." +"ArchitecturalStyle": array:1 [ 0 => "Bungalow" ] +"Basement": array:2 [ 0 => "Apartment" 1 => "Separate Entrance" ] +"CityRegion": "Bonnington" +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2025-05-25T01:52:20.840784+00:00" +"CrossStreet": "Fennell Avenue and West 5th Street" +"DirectionFaces": "South" +"Directions": "W" +"Exclusions": "All Staging furniture" +"ExpirationDate": "2025-08-26" +"FoundationDetails": array:1 [ 0 => "Concrete Block" ] +"Inclusions": "2 Fridges 2 Stoves 2 Washers 2 Dryers 2 Dishwashers All ELFS and Window coverings" +"InteriorFeatures": array:3 [ 0 => "Carpet Free" 1 => "Separate Hydro Meter" 2 => "Upgraded Insulation" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-05-24" +"LotSizeSource": "MPAC" +"MainOfficeKey": "384000" +"MajorChangeTimestamp": "2025-07-04T02:01:42Z" +"MlsStatus": "Price Change" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-05-25T01:49:16Z" +"OriginalListPrice": 816000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2333432" +"OtherStructures": array:1 [ 0 => "Shed" ] +"ParcelNumber": "170250061" +"ParkingTotal": "3.0" +"PhotosChangeTimestamp": "2025-06-27T01:25:22Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"PreviousListPrice": 789999.0 +"PriceChangeTimestamp": "2025-07-04T02:01:42Z" +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:1 [ 0 => "Lockbox" ] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "West 4th" +"StreetNumber": "6" +"StreetSuffix": "Street" +"TaxAnnualAmount": "4850.71" +"TaxLegalDescription": "LT 325, PL 540 ; HAMILTON" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2.5% + HST" +"TransactionType": "For Sale" +"VirtualTourURLBranded": "https://view.doamedia.ca/order/4ec4a41c-0453-4a5c-3709-08dd94666dda" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 103.83 +"LotWidth": 50.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12171811')" +"GarageType": "None" +"HeatSource": "Gas" +"RollNumber": "251808092102540" +"SurveyType": "Up-to-Date" +"RentalItems": "Water Heater" +"HoldoverDays": 90 +"WaterMeterYN": true +"KitchensTotal": 2 +"ParkingSpaces": 3 +"provider_name": "TRREB" +"AssessmentYear": 2024 +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included In" ] +"PossessionType": "Flexible" +"PriorMlsStatus": "New" +"WashroomsType1": 1 +"WashroomsType2": 1 +"DenFamilyroomYN": true +"LivingAreaRange": "700-1100" +"RoomsAboveGrade": 10 +"PropertyFeatures": array:6 [ 0 => "Hospital" 1 => "Library" 2 => "Place Of Worship" 3 => "Public Transit" 4 => "School" 5 => "Fenced Yard" ] +"SalesBrochureUrl": "https://view.doamedia.ca/order/4ec4a41c-0453-4a5c-3709-08dd94666dda" +"PossessionDetails": "Vacant" +"WashroomsType1Pcs": 3 +"WashroomsType2Pcs": 3 +"BedroomsAboveGrade": 2 +"BedroomsBelowGrade": 2 +"KitchensAboveGrade": 2 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"ShowingAppointments": "Anytime" +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Basement" +"MediaChangeTimestamp": "2025-06-27T01:25:22Z" +"SystemModificationTimestamp": "2025-07-04T02:01:44.891947Z" +"Media": array:25 [ 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] ] } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14517 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12260929" +"ListingId": "X12260929" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-04T01:31:54Z" +"RFModificationTimestamp": "2025-07-04T06:47:44.333684+00:00" +"ListPrice": 1569900.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 343.75 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8B 1W7" +"UnparsedAddress": "107 Avanti Crescent, Hamilton, ON L8B 1W7" +"Coordinates": array:2 [ 0 => -79.8832342 1 => 43.3346942 ] +"Latitude": 43.3346942 +"Longitude": -79.8832342 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ONE PERCENT REALTY LTD." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome To 107 Avanti Crescent, A Beautiful Detached Home On One Of The Most Sought-After Streets In Waterdown's Mountainview Heights Community. With Nearly 3,000 Sq Ft Of Finished Living Space Above Grade, This 4-Bedroom, 3.5-Bath Home Offers A Great Layout And High-End Finishes Throughout. The Entire Home Is Carpet-Free, With Hardwood Flooring On The Main Level, Pot Lights, And A Custom White Shaker Kitchen With Quartz Countertops, An Oversized Island With Seating And Stainless Steel Appliances. The Family Room Is Warm And Welcoming With A Gas Fireplace And Coffered Ceiling. Both The Main And Upper Levels Boast 9 Foot Ceilings & The Home Features California Shutters Throughout. Upstairs, Every Bedroom Has A Walk-In Closet And Access To A Bathroom, Perfect For Families, Including A Spacious Primary Suite With Dual Walk-In Closets And A Luxurious 5-Piece Ensuite. Exterior Pot Lights Surround The Home For Added Curb Appeal. The Unfinished Basement Includes A Rough-In For A Bathroom And Room To Grow. Located Close To Top-Rated Schools, Parks, Trails, And Highways 403/407, This Is A Rare Opportunity To Own A Stunning Home In One Of Waterdown's Best Neighbourhoods." +"ArchitecturalStyle": array:1 [ 0 => "2-Storey" ] +"Basement": array:2 [ 0 => "Unfinished" 1 => "Full" ] +"CityRegion": "Waterdown" +"ConstructionMaterials": array:2 [ 0 => "Brick" 1 => "Stone" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CoveredSpaces": "2.0" +"CreationDate": "2025-07-03T21:24:32.692084+00:00" +"CrossStreet": "Dundas St & Burke St" +"DirectionFaces": "South" +"Directions": "Burke St. South To Kenesky Dr. To Avanti Cres" +"Exclusions": "Upstairs Hallway Chandelier, Stand Up Freezer & Fridge In Garage, 2 Hose Reels (Garage & Backyard), Family Room TV Bracket." +"ExpirationDate": "2025-11-30" +"FireplaceFeatures": array:2 [ 0 => "Natural Gas" 1 => "Family Room" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"GarageYN": true +"Inclusions": "Fridge, Stove, Dishwasher, Built-in Microwave, Washer, Dryer, Garage Door Opener, ELFS, Window Coverings" +"InteriorFeatures": array:3 [ 0 => "Auto Garage Door Remote" 1 => "ERV/HRV" 2 => "Water Heater" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-07-03" +"LotSizeSource": "MPAC" +"MainOfficeKey": "179500" +"MajorChangeTimestamp": "2025-07-03T21:00:19Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-07-03T21:00:19Z" +"OriginalListPrice": 1569900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2651260" +"ParcelNumber": "175010554" +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2025-07-04T01:12:24Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"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": "Avanti" +"StreetNumber": "107" +"StreetSuffix": "Crescent" +"TaxAnnualAmount": "8924.36" +"TaxLegalDescription": "LOT 32, PLAN 62M1238 SUBJECT TO AN EASEMENT IN GROSS AS IN WE1193623 SUBJECT TO AN EASEMENT FOR ENTRY AS IN WE1229401 SUBJECT TO AN EASEMENT OVER PART 1 ON 62R20921 IN FAVOUR OF LOT 31, PLAN 62M1238 AS IN WE1342309 SUBJECT TO AN EASEMENT FOR ENTRY AS IN WE1342309 TOGETHER WITH AN EASEMENT OVER PART OF LOT 33, PLAN 62M1238, PART 2 PLAN 62R20921 AS IN WE1345333 CITY OF HAMILTON" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2% + HST" +"TransactionType": "For Sale" +"VirtualTourURLBranded": "https://media.relavix.com/107-avanti-crescent-hamilton/" +"VirtualTourURLUnbranded": "https://media.relavix.com/107-avanti-crescent-hamilton/?unbranded=true" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 27.5 +"LotWidth": 12.5 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12260929')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "251830331009552" +"SurveyType": "Unknown" +"RentalItems": "Hot Water Heater" +"HoldoverDays": 60 +"LaundryLevel": "Main Level" +"KitchensTotal": 1 +"ParkingSpaces": 2 +"provider_name": "TRREB" +"ApproximateAge": "6-15" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included In" ] +"PossessionDate": "2025-10-01" +"PossessionType": "60-89 days" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"WashroomsType4": 1 +"DenFamilyroomYN": true +"LivingAreaRange": "2500-3000" +"RoomsAboveGrade": 9 +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 3 +"WashroomsType3Pcs": 4 +"WashroomsType4Pcs": 5 +"BedroomsAboveGrade": 4 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"LeaseToOwnEquipment": array:1 [ 0 => "Water Heater" ] +"ShowingAppointments": "2 Hours Notice. Please Schedule Through Broker Bay" +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"WashroomsType3Level": "Second" +"WashroomsType4Level": "Second" +"MediaChangeTimestamp": "2025-07-04T01:12:24Z" +"SystemModificationTimestamp": "2025-07-04T01:31:56.015683Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:43 [ 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] ] } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14516 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12261254" +"ListingId": "X12261254" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-04T01:01:46Z" +"RFModificationTimestamp": "2025-07-04T06:47:47.227096+00:00" +"ListPrice": 779900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 4714.59 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8T 3L2" +"UnparsedAddress": "63 Fernwood Crescent, Hamilton, ON L8T 3L2" +"Coordinates": array:2 [ 0 => -79.8338707 1 => 43.2249046 ] +"Latitude": 43.2249046 +"Longitude": -79.8338707 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE BURLOAK REAL ESTATE SERVICES" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Discover elevated living in this fully renovated home in Hamilton Mountains family-friendly Hampton Heights. The stunning finishes and expert craftsmanship really make this home stand out, it's impeccably well done. Set on a quiet, tree-lined street known for its welcoming neighbours, parks, and great schools, this property is a true standout. The main floor has been completely reimagined with all-new oak hardwood flooring, large new windows that bring in natural light, pot lights and a stunning custom kitchen featuring wraparound quartz countertops that continue seamlessly up the backsplash. Paired with stainless steel appliances and sleek cabinetry, this kitchen is as functional as it is beautiful. The open-concept layout flows effortlessly into the dining and living areas, perfect for everyday living or entertaining. Three spacious bedrooms provide room for the whole family, with the primary bedroom offering ensuite access to the beautifully updated bathroom. Downstairs, oak stairs lead to a fully finished lower level with a separate entrance ideal as an in-law suite or teen retreat. This space includes two more bedrooms, a second kitchen with quartz countertops and brand-new appliances, a stylish full bath, and a comfortable family room with warm woodgrain vinyl floors. Thoughtfully upgraded throughout, this home has been fully rewired, reinsulated, and professionally finished from top to bottom. With parking for six cars, a large backyard, and a handy storage shed, this property offers space, flexibility, and true move-in ready quality in one of the most desirable pockets on the Mountain." +"ArchitecturalStyle": array:1 [ 0 => "Bungalow" ] +"Basement": array:2 [ 0 => "Separate Entrance" 1 => "Finished" ] +"CityRegion": "Hampton Heights" +"ConstructionMaterials": array:2 [ 0 => "Aluminum Siding" 1 => "Brick" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2025-07-03T23:51:00.893917+00:00" +"CrossStreet": "Fennel and Upper Ottawa" +"DirectionFaces": "East" +"Directions": "Fennel and Upper Ottawa" +"Exclusions": "None." +"ExpirationDate": "2025-10-03" +"ExteriorFeatures": array:1 [ 0 => "Porch" ] +"FoundationDetails": array:1 [ 0 => "Concrete" ] +"Inclusions": "2 fridges, 2 stoves, vent hood, microwave, dishwasher, washer/dryer" +"InteriorFeatures": array:4 [ 0 => "Carpet Free" 1 => "In-Law Suite" 2 => "Primary Bedroom - Main Floor" 3 => "Upgraded Insulation" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-07-03" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "190200" +"MajorChangeTimestamp": "2025-07-03T23:38:40Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-07-03T23:38:40Z" +"OriginalListPrice": 779900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2653438" +"OtherStructures": array:1 [ 0 => "Shed" ] +"ParcelNumber": "170030095" +"ParkingFeatures": array:1 [ 0 => "Private Double" ] +"ParkingTotal": "6.0" +"PhotosChangeTimestamp": "2025-07-03T23:43:07Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"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": "Fernwood" +"StreetNumber": "63" +"StreetSuffix": "Crescent" +"TaxAnnualAmount": "4266.84" +"TaxAssessedValue": 285000 +"TaxLegalDescription": "LT 204, PL 984; S/T NS259232 HAMILTON" +"TaxYear": "2025" +"Topography": array:1 [ 0 => "Flat" ] +"TransactionBrokerCompensation": "2%" +"TransactionType": "For Sale" +"UFFI": "No" +"DDFYN": true +"Water": "Municipal" +"GasYNA": "Available" +"CableYNA": "Available" +"HeatType": "Forced Air" +"LotDepth": 100.0 +"LotShape": "Rectangular" +"LotWidth": 47.0 +"SewerYNA": "Available" +"WaterYNA": "Available" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12261254')" +"GarageType": "None" +"HeatSource": "Gas" +"RollNumber": "251806060105160" +"SurveyType": "Unknown" +"ElectricYNA": "Available" +"RentalItems": "Water Heater" +"HoldoverDays": 30 +"LaundryLevel": "Lower Level" +"TelephoneYNA": "Available" +"KitchensTotal": 2 +"ParkingSpaces": 6 +"UnderContract": array:1 [ 0 => "Hot Water Heater" ] +"provider_name": "TRREB" +"ApproximateAge": "51-99" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included In" ] +"PossessionType": "Immediate" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"DenFamilyroomYN": true +"LivingAreaRange": "700-1100" +"RoomsAboveGrade": 11 +"LotSizeAreaUnits": "Square Feet" +"ParcelOfTiedLand": "No" +"LotSizeRangeAcres": "< .50" +"PossessionDetails": "ASAP" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 3 +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 2 +"KitchensAboveGrade": 2 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"ShowingAppointments": "Showings through BBay or LBO" +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Basement" +"MediaChangeTimestamp": "2025-07-04T01:01:46Z" +"SystemModificationTimestamp": "2025-07-04T01:01:48.14254Z" +"Media": array:31 [ 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] ] } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14515 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12261342" +"ListingId": "X12261342" +"PropertyType": "Residential" +"PropertySubType": "Att/Row/Townhouse" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-04T00:40:22Z" +"RFModificationTimestamp": "2025-07-04T14:09:55.746694+00:00" +"ListPrice": 939000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8B 1V7" +"UnparsedAddress": "#80 - 22 Spring Creek Drive, Hamilton, ON L8B 1V7" +"Coordinates": array:2 [ 0 => -79.8728583 1 => 43.2560802 ] +"Latitude": 43.2560802 +"Longitude": -79.8728583 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX ESCARPMENT REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to this spectacular 3 level, just like a semi Detached end-Unit Townhome in the Charming quiet town of Waterdown! Over the three levels there is 1900 sq.ft. of living space.Professional Painted in neutral colours with numerous upgrades including quartz counters, pot lights, upgraded Black lever hinges and handles and plumbing Fixtures.The ground floor encompasses vinyl flooring with an upgraded designer laundry room with new front load washer / dryer + Wood counter + Sink and shelving. Super useful Large storage area with a separate office with French doors that can be used as a 4th. Bedroom. Internal access to stunning oversized double garage fully painted with an epoxy floor.The main level incorporates the upgraded kitchen with S/S appliances, quartz counter with floating island. The powder room has a ship lap feature wall with new vanity and vinyl floor. The bright natural sunlight exudes an abundance of light in the Living and Dining area which encompasses a feature wall and pot lights. This leads via a sliding patio door to the large 20 x 12 ft. deck with a Gazebo and privacy blinds.The third level has a Primary Bedroom with ensuite 3 pice Bathroom (Quartz Counter and glass shower) and walk-in closet. Good sized 2nd. and 3rd. Bedrooms. The main bathroom has 4 pieces including a tub and Quartz Counter top.Commuters have many options -Minutes to GO station, 407 and QEW highways and a short drive to Burlington waterfront. This property should showcase in any designer magazine and the owner has meticulously upgraded and maintained the property since new.This property will not last long as it shows 10+++ so book your private showing before its SOLD !!!" +"ArchitecturalStyle": array:1 [ 0 => "3-Storey" ] +"AttachedGarageYN": true +"Basement": array:1 [ 0 => "None" ] +"CityRegion": "Waterdown" +"ConstructionMaterials": array:2 [ 0 => "Brick" 1 => "Vinyl Siding" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CoolingYN": true +"Country": "CA" +"CountyOrParish": "Hamilton" +"CoveredSpaces": "2.0" +"CreationDate": "2025-07-04T00:40:41.129800+00:00" +"CrossStreet": "Dundas St E/ Hamilton St N" +"DirectionFaces": "South" +"Directions": "Dundas to Spring Creek, turn into complex before roundabout" +"Exclusions": "tv mounts and tv's" +"ExpirationDate": "2025-12-31" +"FoundationDetails": array:1 [ 0 => "Concrete" ] +"GarageYN": true +"HeatingYN": true +"Inclusions": "Samsung S/S Fridge,S/S Electric Range,S/S Dishwasher,S/S range fan, Grey Front load Washer/Dryer, all Elf's, All window covering's, all electrical light fixtures, outdoor gazebo and privacy Blinds, shelves in laundry/ mud room, Tv Mount wall board in family room,Central Vac including all attachments. Gdo with remote." +"InteriorFeatures": array:3 [ 0 => "Auto Garage Door Remote" 1 => "Central Vacuum" 2 => "On Demand Water Heater" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-07-03" +"LotDimensionsSource": "Other" +"LotSizeDimensions": "25.43 x 62.66 Feet" +"LotSizeSource": "Other" +"MainOfficeKey": "184000" +"MajorChangeTimestamp": "2025-07-04T00:35:16Z" +"MlsStatus": "New" +"NewConstructionYN": true +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-07-04T00:35:16Z" +"OriginalListPrice": 939000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2657438" +"OtherStructures": array:1 [ 0 => "Gazebo" ] +"ParcelNumber": "175031357" +"ParkingFeatures": array:1 [ 0 => "None" ] +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-07-04T00:35:17Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"PropertyAttachedYN": true +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"RoomsTotal": "13" +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:1 [ 0 => "Lockbox" ] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Spring Creek" +"StreetNumber": "22" +"StreetSuffix": "Drive" +"TaxAnnualAmount": "6055.0" +"TaxLegalDescription": "Part Block195 Plan 62M1231 Parts 80, 214, 218,219," +"TaxYear": "2025" +"Topography": array:1 [ 0 => "Flat" ] +"TransactionBrokerCompensation": "2.0 + HST" +"TransactionType": "For Sale" +"UnitNumber": "80" +"VirtualTourURLBranded": "https://media.visualadvantage.ca/22-Spring-Creek-Dr" +"VirtualTourURLUnbranded2": "https://media.visualadvantage.ca/22-Spring-Creek-Dr" +"Zoning": "R6-42" +"UFFI": "No" +"DDFYN": true +"Water": "Municipal" +"GasYNA": "Yes" +"CableYNA": "Available" +"HeatType": "Forced Air" +"LotDepth": 62.66 +"LotWidth": 19.85 +"SewerYNA": "Yes" +"WaterYNA": "Yes" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12261342')" +"PictureYN": true +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "251830335063465" +"SurveyType": "Available" +"ElectricYNA": "Yes" +"RentalItems": "hot water tank on demand 56.43" +"HoldoverDays": 90 +"LaundryLevel": "Main Level" +"TelephoneYNA": "Available" +"KitchensTotal": 1 +"ParkingSpaces": 2 +"UnderContract": array:1 [ 0 => "Hot Water Tank-Gas" ] +"provider_name": "TRREB" +"ApproximateAge": "6-15" +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included In" ] +"PossessionType": "60-89 days" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"CentralVacuumYN": true +"DenFamilyroomYN": true +"LivingAreaRange": "1500-2000" +"MortgageComment": "Treat as clear" +"RoomsAboveGrade": 11 +"RoomsBelowGrade": 2 +"PropertyFeatures": array:6 [ 0 => "Park" 1 => "Place Of Worship" 2 => "Public Transit" 3 => "Rec./Commun.Centre" 4 => "School Bus Route" 5 => "Library" ] +"StreetSuffixCode": "Dr" +"BoardPropertyType": "Free" +"LotSizeRangeAcres": "< .50" +"PossessionDetails": "60-90 days" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 4 +"WashroomsType3Pcs": 3 +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Other" ] +"ShowingAppointments": "broker bay 2 hours notice pls" +"WashroomsType1Level": "Second" +"WashroomsType2Level": "Third" +"WashroomsType3Level": "Third" +"MediaChangeTimestamp": "2025-07-04T00:40:22Z" +"DevelopmentChargesPaid": array:1 [ 0 => "Yes" ] +"MLSAreaDistrictOldZone": "X14" +"MLSAreaMunicipalityDistrict": "Hamilton" +"SystemModificationTimestamp": "2025-07-04T00:40:25.093525Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:41 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] 31 => array:26 [ …26] 32 => array:26 [ …26] 33 => array:26 [ …26] 34 => array:26 [ …26] 35 => array:26 [ …26] 36 => array:26 [ …26] 37 => array:26 [ …26] 38 => array:26 [ …26] 39 => array:26 [ …26] 40 => array:26 [ …26] ] } ] +success: true +page_size: 10 +page_count: 407 +count: 4070 +after_key: "" } ] ]
