718 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: 9076d226ff5cdcef13ae05bcb38f9adfb8b55845d41aaf0477584df796e5a65e" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#14717 +items: array:10 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14913 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12328949" +"ListingId": "X12328949" +"PropertyType": "Residential Lease" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-08-13T13:26:53Z" +"RFModificationTimestamp": "2025-08-13T13:44:31Z" +"ListPrice": 1950.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Cambridge" +"PostalCode": "N3H 3G4" +"UnparsedAddress": "1267 Hamilton Street, Cambridge, ON N3H 3G4" +"Coordinates": array:2 [ 0 => -80.351514 1 => 43.3898433 ] +"Latitude": 43.3898433 +"Longitude": -80.351514 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Red And White Realty Inc" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to Hamilton Street in Cambridge! This charming entire 2-bedroom, 1-bathroom home is available for lease September 1st 2025 and is located just minutes from downtown Preston. Enjoy the convenience of in-suite laundry, a detached garage, and a private backyard with parking for 4+ vehicles. The home also includes an unfinished basement, a perfect spot for storage and it's all exclusively for tenant use. With just a 5-minute drive to the 401, Kitchener, and the expressway, commuting is quick and easy. A wonderful place to call home!" +"ArchitecturalStyle": array:1 [ 0 => "Bungalow" ] +"Basement": array:1 [ 0 => "Unfinished" ] +"ConstructionMaterials": array:1 [ 0 => "Aluminum Siding" ] +"Cooling": array:1 [ 0 => "None" ] +"CountyOrParish": "Waterloo" +"CoveredSpaces": "1.0" +"CreationDate": "2025-08-07T00:04:36.557025+00:00" +"CrossStreet": "Montrose" +"DirectionFaces": "North" +"Directions": "King to Montrose to Hamilton" +"ExpirationDate": "2025-12-05" +"FoundationDetails": array:1 [ 0 => "Stone" ] +"Furnished": "Unfurnished" +"GarageYN": true +"Inclusions": "Refrigerator, Stove. Washer, Dryer" +"InteriorFeatures": array:1 [ 0 => "Water Heater" ] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "In-Suite Laundry" ] +"LeaseTerm": "12 Months" +"ListAOR": "One Point Association of REALTORS" +"ListingContractDate": "2025-08-06" +"MainOfficeKey": "575000" +"MajorChangeTimestamp": "2025-08-13T13:26:53Z" +"MlsStatus": "Price Change" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-08-06T23:58:24Z" +"OriginalListPrice": 2100.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2816718" +"ParkingTotal": "5.0" +"PhotosChangeTimestamp": "2025-08-06T23:58:24Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"PreviousListPrice": 2100.0 +"PriceChangeTimestamp": "2025-08-13T13:26:53Z" +"RentIncludes": 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": "Hamilton" +"StreetNumber": "1267" +"StreetSuffix": "Street" +"TransactionBrokerCompensation": "1/2 months rent +HST" +"TransactionType": "For Lease" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12328949')" +"GarageType": "Detached" +"HeatSource": "Gas" +"SurveyType": "None" +"HoldoverDays": 60 +"CreditCheckYN": true +"KitchensTotal": 1 +"ParkingSpaces": 4 +"provider_name": "TRREB" +"ApproximateAge": "100+" +"ContractStatus": "Available" +"PossessionDate": "2025-09-01" +"PossessionType": "Immediate" +"PriorMlsStatus": "New" +"WashroomsType1": 1 +"DepositRequired": true +"LivingAreaRange": "< 700" +"RoomsAboveGrade": 5 +"LeaseAgreementYN": true +"ParcelOfTiedLand": "No" +"PaymentFrequency": "Monthly" +"PossessionDetails": "Immediate" +"PrivateEntranceYN": true +"WashroomsType1Pcs": 3 +"BedroomsAboveGrade": 2 +"EmploymentLetterYN": true +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"RentalApplicationYN": true +"ShowingAppointments": "Please use showing time to book." +"WashroomsType1Level": "Main" +"MediaChangeTimestamp": "2025-08-06T23:58:24Z" +"PortionPropertyLease": array:1 [ 0 => "Entire Property" ] +"ReferencesRequiredYN": true +"SystemModificationTimestamp": "2025-08-13T13:26:54.927604Z" +"Media": array:12 [ 0 => array:26 [ "Order" => 0 "ImageOf" => null "MediaKey" => "bb31b8ff-4bd7-459b-97f1-5e63ead4fecd" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12328949/5ab80d2e879335768ecdd58211d0ab1b.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 898332 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12328949/thumbnail-5ab80d2e879335768ecdd58211d0ab1b.webp" "ImageWidth" => 2000 "Permission" => array:1 [ …1] "ImageHeight" => 1500 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "bb31b8ff-4bd7-459b-97f1-5e63ead4fecd" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => true "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12328949" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "bb31b8ff-4bd7-459b-97f1-5e63ead4fecd" "ModificationTimestamp" => "2025-08-06T23:58:24.112199Z" "MediaModificationTimestamp" => "2025-08-06T23:58:24.112199Z" ] 1 => array:26 [ "Order" => 1 "ImageOf" => null "MediaKey" => "043bb4ef-4c03-4eff-b733-bf897f8062fd" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12328949/26e904885b14c6c05b72b779a0d95ef5.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 1000747 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12328949/thumbnail-26e904885b14c6c05b72b779a0d95ef5.webp" "ImageWidth" => 2000 "Permission" => array:1 [ …1] "ImageHeight" => 1500 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "043bb4ef-4c03-4eff-b733-bf897f8062fd" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12328949" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "043bb4ef-4c03-4eff-b733-bf897f8062fd" "ModificationTimestamp" => "2025-08-06T23:58:24.112199Z" "MediaModificationTimestamp" => "2025-08-06T23:58:24.112199Z" ] 2 => array:26 [ "Order" => 2 "ImageOf" => null "MediaKey" => "bd1f0516-2601-4737-8270-86f3d9983026" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12328949/5c2b494a514d9209cc9aef8a537a1b3b.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 909659 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12328949/thumbnail-5c2b494a514d9209cc9aef8a537a1b3b.webp" "ImageWidth" => 2000 "Permission" => array:1 [ …1] "ImageHeight" => 1500 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "bd1f0516-2601-4737-8270-86f3d9983026" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12328949" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "bd1f0516-2601-4737-8270-86f3d9983026" "ModificationTimestamp" => "2025-08-06T23:58:24.112199Z" "MediaModificationTimestamp" => "2025-08-06T23:58:24.112199Z" ] 3 => array:26 [ "Order" => 3 "ImageOf" => null "MediaKey" => "2dfd6cec-ec61-4bd3-b509-29b0ff004359" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12328949/397044590887ef686a93e2ad72fe22f1.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 879592 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12328949/thumbnail-397044590887ef686a93e2ad72fe22f1.webp" "ImageWidth" => 2000 "Permission" => array:1 [ …1] "ImageHeight" => 1500 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "2dfd6cec-ec61-4bd3-b509-29b0ff004359" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12328949" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "2dfd6cec-ec61-4bd3-b509-29b0ff004359" "ModificationTimestamp" => "2025-08-06T23:58:24.112199Z" "MediaModificationTimestamp" => "2025-08-06T23:58:24.112199Z" ] 4 => array:26 [ "Order" => 4 "ImageOf" => null "MediaKey" => "b4a1d54c-2978-448f-93cd-c75417036c59" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12328949/576cff52c1463cc2f9787b5f6a73f8b5.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 367926 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12328949/thumbnail-576cff52c1463cc2f9787b5f6a73f8b5.webp" "ImageWidth" => 2000 "Permission" => array:1 [ …1] "ImageHeight" => 1500 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "b4a1d54c-2978-448f-93cd-c75417036c59" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12328949" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "b4a1d54c-2978-448f-93cd-c75417036c59" "ModificationTimestamp" => "2025-08-06T23:58:24.112199Z" "MediaModificationTimestamp" => "2025-08-06T23:58:24.112199Z" ] 5 => array:26 [ "Order" => 5 "ImageOf" => null "MediaKey" => "caa0065e-50a2-406d-acb5-662027b9862a" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12328949/fce53d7cca0d60b749443424771efb91.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 259883 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12328949/thumbnail-fce53d7cca0d60b749443424771efb91.webp" "ImageWidth" => 2000 "Permission" => array:1 [ …1] "ImageHeight" => 1500 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "caa0065e-50a2-406d-acb5-662027b9862a" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12328949" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "caa0065e-50a2-406d-acb5-662027b9862a" "ModificationTimestamp" => "2025-08-06T23:58:24.112199Z" "MediaModificationTimestamp" => "2025-08-06T23:58:24.112199Z" ] 6 => array:26 [ "Order" => 6 "ImageOf" => null "MediaKey" => "01005428-0759-47dc-a39f-78cf1b141b5a" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12328949/1386ead518036546f5deb588b5dc5247.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 968870 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12328949/thumbnail-1386ead518036546f5deb588b5dc5247.webp" "ImageWidth" => 2880 "Permission" => array:1 [ …1] "ImageHeight" => 3840 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "01005428-0759-47dc-a39f-78cf1b141b5a" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12328949" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "01005428-0759-47dc-a39f-78cf1b141b5a" "ModificationTimestamp" => "2025-08-06T23:58:24.112199Z" "MediaModificationTimestamp" => "2025-08-06T23:58:24.112199Z" ] 7 => array:26 [ "Order" => 7 "ImageOf" => null "MediaKey" => "01921c98-baeb-4bae-ad73-fbb356f9324b" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12328949/344be756256a3482d1a691e6ea7b4acf.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 289758 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12328949/thumbnail-344be756256a3482d1a691e6ea7b4acf.webp" "ImageWidth" => 2000 "Permission" => array:1 [ …1] "ImageHeight" => 1500 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "01921c98-baeb-4bae-ad73-fbb356f9324b" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12328949" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "01921c98-baeb-4bae-ad73-fbb356f9324b" "ModificationTimestamp" => "2025-08-06T23:58:24.112199Z" "MediaModificationTimestamp" => "2025-08-06T23:58:24.112199Z" ] 8 => array:26 [ "Order" => 8 "ImageOf" => null "MediaKey" => "a2308765-49ce-4724-af3f-4601b3a367ba" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12328949/d5d8cd43abbb3b5303f18c5adb718f0d.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 926050 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12328949/thumbnail-d5d8cd43abbb3b5303f18c5adb718f0d.webp" "ImageWidth" => 1500 "Permission" => array:1 [ …1] "ImageHeight" => 2000 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "a2308765-49ce-4724-af3f-4601b3a367ba" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12328949" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "a2308765-49ce-4724-af3f-4601b3a367ba" "ModificationTimestamp" => "2025-08-06T23:58:24.112199Z" "MediaModificationTimestamp" => "2025-08-06T23:58:24.112199Z" ] 9 => array:26 [ "Order" => 9 "ImageOf" => null "MediaKey" => "c007ec21-498a-46b1-a385-7930112fcfc2" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12328949/74fa49595a1132d9383e544e7a9599e7.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 927553 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12328949/thumbnail-74fa49595a1132d9383e544e7a9599e7.webp" "ImageWidth" => 2000 "Permission" => array:1 [ …1] "ImageHeight" => 1500 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "c007ec21-498a-46b1-a385-7930112fcfc2" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12328949" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "c007ec21-498a-46b1-a385-7930112fcfc2" "ModificationTimestamp" => "2025-08-06T23:58:24.112199Z" "MediaModificationTimestamp" => "2025-08-06T23:58:24.112199Z" ] 10 => array:26 [ "Order" => 10 "ImageOf" => null "MediaKey" => "bd51e827-99d5-49bf-beac-88995c184f4c" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12328949/68a0c4840bf4a0af2edc53742323475c.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 1026264 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12328949/thumbnail-68a0c4840bf4a0af2edc53742323475c.webp" "ImageWidth" => 2000 "Permission" => array:1 [ …1] "ImageHeight" => 1500 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "bd51e827-99d5-49bf-beac-88995c184f4c" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12328949" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "bd51e827-99d5-49bf-beac-88995c184f4c" "ModificationTimestamp" => "2025-08-06T23:58:24.112199Z" "MediaModificationTimestamp" => "2025-08-06T23:58:24.112199Z" ] 11 => array:26 [ "Order" => 11 "ImageOf" => null "MediaKey" => "6c790f38-46b5-495e-8678-179241151ff9" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12328949/c0c4fda2695ea1f658145b0877627da3.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 1062056 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12328949/thumbnail-c0c4fda2695ea1f658145b0877627da3.webp" "ImageWidth" => 2000 "Permission" => array:1 [ …1] "ImageHeight" => 1500 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "6c790f38-46b5-495e-8678-179241151ff9" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12328949" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "6c790f38-46b5-495e-8678-179241151ff9" "ModificationTimestamp" => "2025-08-06T23:58:24.112199Z" "MediaModificationTimestamp" => "2025-08-06T23:58:24.112199Z" ] ] } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14914 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12341278" +"ListingId": "X12341278" +"PropertyType": "Residential" +"PropertySubType": "Semi-Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-08-13T13:17:08Z" +"RFModificationTimestamp": "2025-08-13T17:10:31Z" +"ListPrice": 712888.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0.12 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Cambridge" +"PostalCode": "N1R 4T9" +"UnparsedAddress": "153 Dudhope Avenue, Cambridge, ON N1R 4T9" +"Coordinates": array:2 [ 0 => -80.2962934 1 => 43.3485438 ] +"Latitude": 43.3485438 +"Longitude": -80.2962934 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Keller Williams Signature Realty, Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to this fully renovated gem in the heart of Cambridge! This stunning 3-bedroom, 2-bath semi has just undergone a complete transformation with endless upgrades, modern finishes and meticulous attention to detail throughout. From the moment you step inside, you'll be impressed by the bright, functional layout and the seamless blend of style and comfort. A truly turnkey home ready for you to move right in. Sitting proudly on an incredible 72'+ frontage lot, the possibilities here are endless. Explore the potential to sever and build, add a detached ADU or simply enjoy the expansive yard as your private retreat. The flexible RS1 zoning offers remarkable versatility for both personal and investment plans. The finished basement with a separate entrance unlocks even more potential, transform it into an in-law suite or income-generating rental unit to suit your needs. All of this in a prime location close to highways, shopping, parks, schools and more, offering unbeatable convenience in a growing market just outside the GTA. Whether you're a first-time buyer seeking a move-in-ready home, an investor looking for serious upside or a developer envisioning your next project, this property checks every box!" +"ArchitecturalStyle": array:1 [ 0 => "2-Storey" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Separate Entrance" ] +"ConstructionMaterials": array:2 [ 0 => "Brick" 1 => "Aluminum Siding" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Waterloo" +"CreationDate": "2025-08-13T13:31:19.835301+00:00" +"CrossStreet": "Champlain & Elgin" +"DirectionFaces": "North" +"Directions": "Champlain & Elgin" +"Exclusions": "Current fridge (shown in listing photos & showings), All Interior & Exterior Furniture, TVs." +"ExpirationDate": "2025-12-31" +"ExteriorFeatures": array:1 [ 0 => "Patio" ] +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Inclusions": "Dishwasher, Stove, Washer, Dryer, Range Hood, Fridge (Not current one shown in listing photos,to be swapped with a different S/S fridge for buyer), Water Softener, Chest Freezer in Basement,All Existing Window Coverings, All Existing ELFs." +"InteriorFeatures": array:4 [ 0 => "Carpet Free" 1 => "In-Law Capability" 2 => "Water Heater" 3 => "Water Softener" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Oakville, Milton & District Real Estate Board" +"ListingContractDate": "2025-08-13" +"LotSizeSource": "MPAC" +"MainOfficeKey": "534800" +"MajorChangeTimestamp": "2025-08-13T13:17:08Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-08-13T13:17:08Z" +"OriginalListPrice": 712888.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2845988" +"OtherStructures": array:1 [ 0 => "Shed" ] +"ParcelNumber": "038390248" +"ParkingFeatures": array:1 [ 0 => "Private" ] +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2025-08-13T13:17:08Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"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": "Dudhope" +"StreetNumber": "153" +"StreetSuffix": "Avenue" +"TaxAnnualAmount": "2942.0" +"TaxLegalDescription": "PT LT 9 PL 1326 CAMBRIDGE ; AS IN WS534385; S/T WS513122; CAMBRIDGE" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2.0%" +"TransactionType": "For Sale" +"VirtualTourURLUnbranded": "https://youriguide.com/153_dudhope_ave_cambridge_on" +"Zoning": "RS1" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 70.0 +"LotWidth": 72.5 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12341278')" +"GarageType": "None" +"HeatSource": "Gas" +"RollNumber": "300602004103001" +"SurveyType": "None" +"RentalItems": "None" +"HoldoverDays": 60 +"KitchensTotal": 1 +"ParkingSpaces": 4 +"provider_name": "TRREB" +"short_address": "Cambridge, ON N1R 4T9, CA" +"AssessmentYear": 2024 +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included In" ] +"PossessionType": "60-89 days" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"LivingAreaRange": "1100-1500" +"MortgageComment": "Seller to Discharge" +"RoomsAboveGrade": 9 +"PropertyFeatures": array:4 [ 0 => "Park" 1 => "Public Transit" 2 => "School" 3 => "Place Of Worship" ] +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 2 +"BedroomsAboveGrade": 3 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"ShowingAppointments": "Min. 3 Hours Notice. Broker Bay" +"WashroomsType1Level": "Second" +"WashroomsType2Level": "Basement" +"MediaChangeTimestamp": "2025-08-13T13:17:08Z" +"SystemModificationTimestamp": "2025-08-13T13:17:08.614199Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:32 [ 0 => array:26 [ "Order" => 0 "ImageOf" => null "MediaKey" => "05767d63-79ba-4f20-8992-5b677f1646b2" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12341278/d351342a0c6b0ac4522628b241cca416.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 442094 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12341278/thumbnail-d351342a0c6b0ac4522628b241cca416.webp" "ImageWidth" => 1599 "Permission" => array:1 [ …1] "ImageHeight" => 1200 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "05767d63-79ba-4f20-8992-5b677f1646b2" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => true "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12341278" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "05767d63-79ba-4f20-8992-5b677f1646b2" "ModificationTimestamp" => "2025-08-13T13:17:08.239896Z" "MediaModificationTimestamp" => "2025-08-13T13:17:08.239896Z" ] 1 => array:26 [ "Order" => 1 "ImageOf" => null "MediaKey" => "79b4ae68-0cec-4576-bdd7-0c50e6584c8f" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12341278/4c345f1e5fad42d1e5ddb6eb4b7c745b.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 411135 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12341278/thumbnail-4c345f1e5fad42d1e5ddb6eb4b7c745b.webp" "ImageWidth" => 1599 "Permission" => array:1 [ …1] "ImageHeight" => 1200 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "79b4ae68-0cec-4576-bdd7-0c50e6584c8f" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12341278" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "79b4ae68-0cec-4576-bdd7-0c50e6584c8f" "ModificationTimestamp" => "2025-08-13T13:17:08.239896Z" "MediaModificationTimestamp" => "2025-08-13T13:17:08.239896Z" ] 2 => array:26 [ "Order" => 2 "ImageOf" => null "MediaKey" => "b29f1df3-3630-412b-85f9-4d76b0b56856" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12341278/41bb4bff2024c13ffdae12c2125a00d3.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 491296 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12341278/thumbnail-41bb4bff2024c13ffdae12c2125a00d3.webp" "ImageWidth" => 1599 "Permission" => array:1 [ …1] "ImageHeight" => 1200 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "b29f1df3-3630-412b-85f9-4d76b0b56856" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => "Huge Lot with 72'+ Frontage" "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12341278" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "b29f1df3-3630-412b-85f9-4d76b0b56856" "ModificationTimestamp" => "2025-08-13T13:17:08.239896Z" "MediaModificationTimestamp" => "2025-08-13T13:17:08.239896Z" ] 3 => array:26 [ "Order" => 3 "ImageOf" => null "MediaKey" => "d4e8127e-71a5-45dd-9a5e-a3400df290a1" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12341278/33a61f1d7f975612a948acb9adbb0c7a.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 168412 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12341278/thumbnail-33a61f1d7f975612a948acb9adbb0c7a.webp" "ImageWidth" => 1599 "Permission" => array:1 [ …1] "ImageHeight" => 1200 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "d4e8127e-71a5-45dd-9a5e-a3400df290a1" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => "Fully Renovated!" "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12341278" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "d4e8127e-71a5-45dd-9a5e-a3400df290a1" "ModificationTimestamp" => "2025-08-13T13:17:08.239896Z" "MediaModificationTimestamp" => "2025-08-13T13:17:08.239896Z" ] 4 => array:26 [ "Order" => 4 "ImageOf" => null "MediaKey" => "2899a090-1261-4ebd-ab62-bafed2163ae9" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12341278/a2e2d59262483e43eb3689bc436a6eeb.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 183782 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12341278/thumbnail-a2e2d59262483e43eb3689bc436a6eeb.webp" "ImageWidth" => 1599 "Permission" => array:1 [ …1] "ImageHeight" => 1200 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "2899a090-1261-4ebd-ab62-bafed2163ae9" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12341278" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "2899a090-1261-4ebd-ab62-bafed2163ae9" "ModificationTimestamp" => "2025-08-13T13:17:08.239896Z" "MediaModificationTimestamp" => "2025-08-13T13:17:08.239896Z" ] 5 => array:26 [ "Order" => 5 "ImageOf" => null "MediaKey" => "187ba823-83cb-4ef6-88f8-8d56958ec527" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12341278/be12bf2a77cb0fa2dde29a1776553072.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 202523 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12341278/thumbnail-be12bf2a77cb0fa2dde29a1776553072.webp" "ImageWidth" => 1599 "Permission" => array:1 [ …1] "ImageHeight" => 1200 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "187ba823-83cb-4ef6-88f8-8d56958ec527" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12341278" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "187ba823-83cb-4ef6-88f8-8d56958ec527" "ModificationTimestamp" => "2025-08-13T13:17:08.239896Z" "MediaModificationTimestamp" => "2025-08-13T13:17:08.239896Z" ] 6 => array:26 [ "Order" => 6 "ImageOf" => null "MediaKey" => "03727103-33f3-4239-b1f5-19bb473e3560" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12341278/6444665c2c81d17d347edaca4c9e1140.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 174479 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12341278/thumbnail-6444665c2c81d17d347edaca4c9e1140.webp" "ImageWidth" => 1599 "Permission" => array:1 [ …1] "ImageHeight" => 1200 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "03727103-33f3-4239-b1f5-19bb473e3560" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12341278" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "03727103-33f3-4239-b1f5-19bb473e3560" "ModificationTimestamp" => "2025-08-13T13:17:08.239896Z" "MediaModificationTimestamp" => "2025-08-13T13:17:08.239896Z" ] 7 => array:26 [ "Order" => 7 "ImageOf" => null "MediaKey" => "ec3b805f-0b5b-4774-b1a1-8fca9d37b4d0" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12341278/44a24537bc70b1278d71be0dbfc32f92.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 163638 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12341278/thumbnail-44a24537bc70b1278d71be0dbfc32f92.webp" "ImageWidth" => 1599 "Permission" => array:1 [ …1] "ImageHeight" => 1200 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "ec3b805f-0b5b-4774-b1a1-8fca9d37b4d0" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12341278" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "ec3b805f-0b5b-4774-b1a1-8fca9d37b4d0" "ModificationTimestamp" => "2025-08-13T13:17:08.239896Z" "MediaModificationTimestamp" => "2025-08-13T13:17:08.239896Z" ] 8 => array:26 [ "Order" => 8 "ImageOf" => null "MediaKey" => "1162e5e1-d628-4f9b-86c3-716ee8dd8492" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12341278/4dd1830a89499b03c4bf5ee6fc838547.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 183574 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12341278/thumbnail-4dd1830a89499b03c4bf5ee6fc838547.webp" "ImageWidth" => 1599 "Permission" => array:1 [ …1] "ImageHeight" => 1200 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "1162e5e1-d628-4f9b-86c3-716ee8dd8492" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12341278" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "1162e5e1-d628-4f9b-86c3-716ee8dd8492" "ModificationTimestamp" => "2025-08-13T13:17:08.239896Z" "MediaModificationTimestamp" => "2025-08-13T13:17:08.239896Z" ] 9 => array:26 [ "Order" => 9 "ImageOf" => null "MediaKey" => "fd254021-14c3-4a95-ab05-5f84d1006bb6" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12341278/469cd4d46c454e382f17d9c14befca55.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 144299 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12341278/thumbnail-469cd4d46c454e382f17d9c14befca55.webp" "ImageWidth" => 1599 "Permission" => array:1 [ …1] "ImageHeight" => 1200 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "fd254021-14c3-4a95-ab05-5f84d1006bb6" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12341278" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "fd254021-14c3-4a95-ab05-5f84d1006bb6" "ModificationTimestamp" => "2025-08-13T13:17:08.239896Z" "MediaModificationTimestamp" => "2025-08-13T13:17:08.239896Z" ] 10 => array:26 [ "Order" => 10 "ImageOf" => null "MediaKey" => "f45758a1-950f-4230-b848-7e18d6f29abc" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12341278/6885ca61d8966094f72a4212701e2b60.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 159207 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12341278/thumbnail-6885ca61d8966094f72a4212701e2b60.webp" "ImageWidth" => 1599 "Permission" => array:1 [ …1] "ImageHeight" => 1200 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "f45758a1-950f-4230-b848-7e18d6f29abc" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12341278" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "f45758a1-950f-4230-b848-7e18d6f29abc" "ModificationTimestamp" => "2025-08-13T13:17:08.239896Z" "MediaModificationTimestamp" => "2025-08-13T13:17:08.239896Z" ] 11 => array:26 [ "Order" => 11 "ImageOf" => null "MediaKey" => "5508cf67-6e2b-4cf1-a1cd-ff281a0c49b0" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12341278/3942f256bfe8498e0b0bc42ce24c6dcc.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 137061 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12341278/thumbnail-3942f256bfe8498e0b0bc42ce24c6dcc.webp" "ImageWidth" => 1599 "Permission" => array:1 [ …1] "ImageHeight" => 1200 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "5508cf67-6e2b-4cf1-a1cd-ff281a0c49b0" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12341278" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "5508cf67-6e2b-4cf1-a1cd-ff281a0c49b0" "ModificationTimestamp" => "2025-08-13T13:17:08.239896Z" "MediaModificationTimestamp" => "2025-08-13T13:17:08.239896Z" ] 12 => array:26 [ "Order" => 12 "ImageOf" => null "MediaKey" => "b5df6892-d196-48ef-ab31-3dfcbb47f256" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12341278/052a2a46031389e3743d915fbe8fd041.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 166699 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12341278/thumbnail-052a2a46031389e3743d915fbe8fd041.webp" "ImageWidth" => 1599 "Permission" => array:1 [ …1] "ImageHeight" => 1200 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "b5df6892-d196-48ef-ab31-3dfcbb47f256" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12341278" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "b5df6892-d196-48ef-ab31-3dfcbb47f256" "ModificationTimestamp" => "2025-08-13T13:17:08.239896Z" "MediaModificationTimestamp" => "2025-08-13T13:17:08.239896Z" ] 13 => array:26 [ "Order" => 13 "ImageOf" => null "MediaKey" => "c594457c-08d1-4c31-92e3-0dfa1c4ccde3" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12341278/1ce105f5ec693dd20dc48564a43016d7.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 155401 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12341278/thumbnail-1ce105f5ec693dd20dc48564a43016d7.webp" "ImageWidth" => 1599 "Permission" => array:1 [ …1] "ImageHeight" => 1200 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "c594457c-08d1-4c31-92e3-0dfa1c4ccde3" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12341278" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "c594457c-08d1-4c31-92e3-0dfa1c4ccde3" "ModificationTimestamp" => "2025-08-13T13:17:08.239896Z" "MediaModificationTimestamp" => "2025-08-13T13:17:08.239896Z" ] 14 => array:26 [ "Order" => 14 "ImageOf" => null "MediaKey" => "9424ce5f-9a3c-4558-9cbc-58b9cf6baf86" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12341278/fdc1915759b5a1e68f9f72fd6223f25f.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 187783 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12341278/thumbnail-fdc1915759b5a1e68f9f72fd6223f25f.webp" "ImageWidth" => 1599 "Permission" => array:1 [ …1] "ImageHeight" => 1200 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "9424ce5f-9a3c-4558-9cbc-58b9cf6baf86" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12341278" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "9424ce5f-9a3c-4558-9cbc-58b9cf6baf86" "ModificationTimestamp" => "2025-08-13T13:17:08.239896Z" "MediaModificationTimestamp" => "2025-08-13T13:17:08.239896Z" ] 15 => array:26 [ "Order" => 15 "ImageOf" => null "MediaKey" => "66546671-71cc-426e-84e2-a8291a5af994" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12341278/91aa2dcde3ac3b47606cce85894fda83.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 166948 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12341278/thumbnail-91aa2dcde3ac3b47606cce85894fda83.webp" "ImageWidth" => 1599 "Permission" => array:1 [ …1] "ImageHeight" => 1200 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "66546671-71cc-426e-84e2-a8291a5af994" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12341278" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "66546671-71cc-426e-84e2-a8291a5af994" "ModificationTimestamp" => "2025-08-13T13:17:08.239896Z" "MediaModificationTimestamp" => "2025-08-13T13:17:08.239896Z" ] 16 => array:26 [ "Order" => 16 "ImageOf" => null "MediaKey" => "4f76fbcf-2e06-406a-907b-e78ef127d2b9" "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X12341278/0a7474bb82fd16dba057d8e96a7c5dfe.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 169751 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X12341278/thumbnail-0a7474bb82fd16dba057d8e96a7c5dfe.webp" "ImageWidth" => 1599 "Permission" => array:1 [ …1] "ImageHeight" => 1200 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "4f76fbcf-2e06-406a-907b-e78ef127d2b9" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X12341278" "ImageSizeDescription" => "Largest" …3 ] 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] ] } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14920 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12336346" +"ListingId": "X12336346" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-08-13T13:05:05Z" +"RFModificationTimestamp": "2025-08-13T13:14:20Z" +"ListPrice": 599000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0.11 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Cambridge" +"PostalCode": "N1S 3G8" +"UnparsedAddress": "97 Berkley Road, Cambridge, ON N1S 3G8" +"Coordinates": array:2 [ 0 => -80.3273999 1 => 43.3533453 ] +"Latitude": 43.3533453 +"Longitude": -80.3273999 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX TWIN CITY REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Charming bungalow in West Galt with a separate unit! Fall in love with this warm and welcoming bungalow that offers both comfort and opportunity. Step inside where the heart of the home is the bright eat-in kitchen, where sleek concrete countertops, stainless steel appliances, and a gas stove make cooking a joy. The cozy family room is perfect for relaxing, and its walkout to a large deck that wraps around the back of the house creates the ideal space for morning coffee or evening BBQs while overlooking the fully fenced sprawling backyard where there is lots of room for the kids and dog to play. The main floor features 2 comfortable bedrooms with a 4-piece bathroom that includes laundry. The inviting lower-level unit has a separate entrance and offers comfortable, self-contained living with a spacious bedroom, a full 4-piece bathroom, laundry, and a well-equipped kitchen perfect for everyday cooking. The open layout provides a cozy living space with plenty of room to relax. Close to the Gaslight District, Hamilton Theatre, downtown Galt, and amenities. Whether you're looking for a smart mortgage helper, a comfortable downsizing option, or a versatile investment property, this bungalow with its separate unit offers endless possibilities. Don't miss the chance to make this flexible and well-located home your own." +"ArchitecturalStyle": array:1 [ 0 => "Bungalow" ] +"Basement": array:2 [ 0 => "Apartment" 1 => "Finished" ] +"ConstructionMaterials": array:2 [ 0 => "Vinyl Siding" 1 => "Wood" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Waterloo" +"CreationDate": "2025-08-11T11:28:27.891500+00:00" +"CrossStreet": "Cedar St." +"DirectionFaces": "West" +"Directions": "Cedar St. to Berkley Rd OR Churchill Dr. to Berkley Rd" +"ExpirationDate": "2025-10-31" +"FireplaceFeatures": array:1 [ 0 => "Electric" ] +"FireplaceYN": true +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Inclusions": "Dishwasher, Dryer, Gas Stove, Microwave, Refrigerator, Stove, Washer, Window Coverings, tv wall mount, Stove in basement ("as-is"), fridge in basement, washer and dryer in basement" +"InteriorFeatures": array:5 [ 0 => "In-Law Suite" 1 => "Primary Bedroom - Main Floor" 2 => "Water Heater" 3 => "Water Softener" 4 => "Sump Pump" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-08-11" +"LotSizeSource": "MPAC" +"MainOfficeKey": "360900" +"MajorChangeTimestamp": "2025-08-11T11:23:59Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-08-11T11:23:59Z" +"OriginalListPrice": 599000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2829892" +"ParcelNumber": "038030025" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-08-11T11:24:00Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"Sewer": array:1 [ 0 => "None" ] +"ShowingRequirements": array:1 [ 0 => "See Brokerage Remarks" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Berkley" +"StreetNumber": "97" +"StreetSuffix": "Road" +"TaxAnnualAmount": "3205.0" +"TaxAssessedValue": 231000 +"TaxLegalDescription": "LT 36 PL 201 CAMBRIDGE; CAMBRIDGE" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2% + HST" +"TransactionType": "For Sale" +"VirtualTourURLBranded": "https://youriguide.com/97_berkley_rd_cambridge_on" +"VirtualTourURLBranded2": "https://video-playback.web.app/Mopj ET8XWaod VI21n004l9QQvx LGp Oh VIzm RCyk2m OQc" +"Zoning": "R5" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 117.5 +"LotWidth": 40.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12336346')" +"GarageType": "None" +"HeatSource": "Gas" +"RollNumber": "300605005705700" +"SurveyType": "None" +"RentalItems": "Hot Water Heater, Water Softener" +"HoldoverDays": 60 +"LaundryLevel": "Main Level" +"KitchensTotal": 2 +"ParkingSpaces": 2 +"UnderContract": array:2 [ 0 => "Hot Water Heater" 1 => "Water Softener" ] +"provider_name": "TRREB" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included In" ] +"PossessionDate": "2025-11-03" +"PossessionType": "60-89 days" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"LivingAreaRange": "700-1100" +"RoomsAboveGrade": 11 +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 4 +"BedroomsAboveGrade": 3 +"KitchensAboveGrade": 2 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"ShowingAppointments": "Please remove shoes & turn off lights" +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Basement" +"MediaChangeTimestamp": "2025-08-11T11:24:00Z" +"SystemModificationTimestamp": "2025-08-13T13:05:06.373789Z" +"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] ] } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14917 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12188019" +"ListingId": "X12188019" +"PropertyType": "Residential" +"PropertySubType": "Att/Row/Townhouse" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-08-13T00:58:08Z" +"RFModificationTimestamp": "2025-08-13T01:02:55Z" +"ListPrice": 649900.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 1790.25 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Cambridge" +"PostalCode": "N3H 5L5" +"UnparsedAddress": "#30 - 470 Linden Drive, Cambridge, ON N3H 5L5" +"Coordinates": array:2 [ 0 => -80.3123023 1 => 43.3600536 ] +"Latitude": 43.3600536 +"Longitude": -80.3123023 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX Real Estate Centre Inc, Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to this exceptional opportunity for first-time home buyers and investors seeking to generate a positive monthly cash flow! This bright, inviting, open-concept townhome features a versatile layout with 3+1 bedrooms and 3 bathrooms. The generous master bedroom has a private en-suite & two walk-in closets, offering a comfortable retreat. This beautifully upgraded unit has hardwood floors, quartz countertops, and stainless steel appliances, adding a fresh and modern touch. Enjoy outdoor living with a spacious backyard, perfect for relaxation or entertaining guests. Centrally located near a host of amenities, this property is a short distance away from Conestoga College and minutes away from Highway 401. Its proximity to schools makes this an ideal home for families. Do not miss out on this fantastic opportunity to own a property with strong rental potential and excellent living space." +"ArchitecturalStyle": array:1 [ 0 => "3-Storey" ] +"Basement": array:1 [ 0 => "None" ] +"ConstructionMaterials": array:2 [ 0 => "Vinyl Siding" 1 => "Brick" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Waterloo" +"CoveredSpaces": "1.0" +"CreationDate": "2025-06-02T04:39:04.705110+00:00" +"CrossStreet": "Fountain St/Preston Parkway" +"DirectionFaces": "West" +"Directions": "Fountain St/Linden" +"ExpirationDate": "2025-09-30" +"ExteriorFeatures": array:1 [ 0 => "Year Round Living" ] +"FoundationDetails": array:1 [ 0 => "Concrete" ] +"GarageYN": true +"InteriorFeatures": array:3 [ 0 => "Water Meter" 1 => "Water Heater" 2 => "Air Exchanger" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Oakville, Milton & District Real Estate Board" +"ListingContractDate": "2025-06-01" +"LotSizeDimensions": "85.5 x 22.5" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "543400" +"MajorChangeTimestamp": "2025-06-24T22:13:30Z" +"MlsStatus": "Price Change" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-06-02T04:30:57Z" +"OriginalListPrice": 659900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2480048" +"ParcelNumber": "037700679" +"ParkingFeatures": array:1 [ 0 => "Private" ] +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-06-02T16:40:35Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"PreviousListPrice": 659900.0 +"PriceChangeTimestamp": "2025-06-24T22:13:30Z" +"PropertyAttachedYN": true +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"RoomsTotal": "11" +"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": "LINDEN" +"StreetNumber": "470" +"StreetSuffix": "Drive" +"TaxAnnualAmount": "5743.59" +"TaxBookNumber": "300610002403613" +"TaxLegalDescription": "PART BLOCK 86 PLAN 58M-582, BEING PARTS 159, 164, 165 ON 58R-19940 T/W AN UNDIVIDED COMMON INTEREST IN WATERLOO PLAN NUMBER 649 AS IN WR1107548 CITY OF CAMBRIDGE" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2.50% Plus HST" +"TransactionType": "For Sale" +"UnitNumber": "30" +"VirtualTourURLBranded": "https://viralrealestate.media/30-470-linden-dr-cambridge" +"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=Ad2qb Au TAE8" +"Zoning": "RM3" +"DDFYN": true +"Water": "Municipal" +"GasYNA": "Available" +"CableYNA": "Available" +"HeatType": "Forced Air" +"LotDepth": 85.5 +"LotShape": "Rectangular" +"LotWidth": 22.5 +"SewerYNA": "Available" +"WaterYNA": "Available" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12188019')" +"GarageType": "Attached" +"HeatSource": "Gas" +"SurveyType": "None" +"ElectricYNA": "Available" +"HoldoverDays": 90 +"LaundryLevel": "Upper Level" +"TelephoneYNA": "Available" +"WaterMeterYN": true +"KitchensTotal": 1 +"ParkingSpaces": 1 +"provider_name": "TRREB" +"ApproximateAge": "6-15" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included In" ] +"PossessionDate": "2025-06-15" +"PossessionType": "Immediate" +"PriorMlsStatus": "New" +"WashroomsType1": 1 +"WashroomsType2": 2 +"DenFamilyroomYN": true +"LivingAreaRange": "1500-2000" +"MortgageComment": "Seller to discharge" +"RoomsAboveGrade": 10 +"LotSizeAreaUnits": "Square Feet" +"ParcelOfTiedLand": "Yes" +"PropertyFeatures": array:5 [ 0 => "Hospital" 1 => "Public Transit" 2 => "School Bus Route" 3 => "Park" 4 => "Library" ] +"LotSizeRangeAcres": "< .50" +"PossessionDetails": "Immidiate" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 3 +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"LeaseToOwnEquipment": array:1 [ 0 => "None" ] +"WashroomsType1Level": "Second" +"WashroomsType2Level": "Third" +"AdditionalMonthlyFee": 145.0 +"MediaChangeTimestamp": "2025-08-13T00:58:08Z" +"DevelopmentChargesPaid": array:1 [ 0 => "Yes" ] +"SystemModificationTimestamp": "2025-08-13T00:58:11.144899Z" +"GreenPropertyInformationStatement": true +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:39 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] 31 => array:26 [ …26] 32 => array:26 [ …26] 33 => array:26 [ …26] 34 => array:26 [ …26] 35 => array:26 [ …26] 36 => array:26 [ …26] 37 => array:26 [ …26] 38 => array:26 [ …26] ] } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14912 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12306847" +"ListingId": "X12306847" +"PropertyType": "Residential Lease" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-08-13T00:47:06Z" +"RFModificationTimestamp": "2025-08-13T00:49:56Z" +"ListPrice": 2790.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Cambridge" +"PostalCode": "N3H 0B7" +"UnparsedAddress": "24 Plumridge Crescent, Cambridge, ON N3H 0B7" +"Coordinates": array:2 [ 0 => -80.3828089 1 => 43.3949438 ] +"Latitude": 43.3949438 +"Longitude": -80.3828089 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "IPRO REALTY LTD." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to this stunning 4-bedroom home on a premium corner lot in the sought-after Grand River Woods community in Preston Heights. Backing onto a quiet dead-end road and scenic greenbelt, this home offers privacy with no rear neighbours - perfect for summer entertaining on the new oversized deck (2024). Recently refreshed with a fresh coat of paint throughout, the bright and modern main floor features engineered hardwood flooring, brand new stove, quartz countertops, and a functional breakfast island with double sink. Enjoy the ease of main floor laundry with garage access and a low-maintenance backyard with exposed concrete for clean and easy outdoor living. Upstairs offers 4 generously sized bedrooms, including a primary retreat with a large walk-in closet and ensuite. PRIME LOCATION: Close to parks, top-rated schools, shopping, and transit. Just minutes to Costco (5-7 min), Walmart, Home Depot (6-8 min), Conestoga College (7-9 min), and Highway 401 making daily commutes and errands effortless." +"ArchitecturalStyle": array:1 [ 0 => "2-Storey" ] +"Basement": array:1 [ 0 => "Apartment" ] +"ConstructionMaterials": array:1 [ 0 => "Vinyl Siding" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Waterloo" +"CoveredSpaces": "1.0" +"CreationDate": "2025-07-25T13:35:27.324862+00:00" +"CrossStreet": "Preston Parkway/ Shantz Hill Road" +"DirectionFaces": "South" +"Directions": "Via Linden Dr, turn onto Plumridge Cres" +"ExpirationDate": "2025-12-25" +"FoundationDetails": array:1 [ 0 => "Concrete" ] +"Furnished": "Unfurnished" +"GarageYN": true +"Inclusions": "Parking, Faux California Blinds, SS Fridge, Stove , Dishwasher, Washer/Dryer" +"InteriorFeatures": array:1 [ 0 => "ERV/HRV" ] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "Laundry Room" ] +"LeaseTerm": "12 Months" +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-07-24" +"MainOfficeKey": "158500" +"MajorChangeTimestamp": "2025-07-25T13:24:18Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-07-25T13:24:18Z" +"OriginalListPrice": 2790.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2762832" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-07-25T13:24:18Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"RentIncludes": array:1 [ 0 => "Parking" ] +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:1 [ 0 => "Lockbox" ] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Plumridge" +"StreetNumber": "24" +"StreetSuffix": "Crescent" +"TransactionBrokerCompensation": "Half Month's Rent + HST" +"TransactionType": "For Lease" +"View": array:1 [ 0 => "Trees/Woods" ] +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotWidth": 47.41 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12306847')" +"GarageType": "Built-In" +"HeatSource": "Gas" +"SurveyType": "None" +"RentalItems": "Hot Water Tank" +"CreditCheckYN": true +"KitchensTotal": 1 +"ParkingSpaces": 1 +"provider_name": "TRREB" +"ContractStatus": "Available" +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"LivingAreaRange": "2000-2500" +"RoomsAboveGrade": 8 +"LeaseAgreementYN": true +"PossessionDetails": "Immediate" +"PrivateEntranceYN": true +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 4 +"WashroomsType3Pcs": 4 +"BedroomsAboveGrade": 4 +"EmploymentLetterYN": true +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"RentalApplicationYN": true +"WashroomsType1Level": "In Between" +"WashroomsType2Level": "Second" +"WashroomsType3Level": "Second" +"MediaChangeTimestamp": "2025-07-25T13:24:18Z" +"PortionPropertyLease": array:2 [ 0 => "Main" 1 => "2nd Floor" ] +"ReferencesRequiredYN": true +"SystemModificationTimestamp": "2025-08-13T00:47:08.504917Z" +"Media": array:33 [ 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] ] } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14891 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12324454" +"ListingId": "X12324454" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-08-13T00:43:54Z" +"RFModificationTimestamp": "2025-08-13T00:46:28Z" +"ListPrice": 650000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Cambridge" +"PostalCode": "N1R 2A9" +"UnparsedAddress": "29 Pollock Avenue, Cambridge, ON N1R 2A9" +"Coordinates": array:2 [ 0 => -80.3049999 1 => 43.3576229 ] +"Latitude": 43.3576229 +"Longitude": -80.3049999 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX REAL ESTATE CENTRE INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Tucked into one of East Galts most beloved pockets, this 1939 brick home sits on a quiet tree-lined street with neighbours who care for their homes as much as they do their gardens. Surrounded by character homes on Kerr, Oak, and Pollock, its the kind of street that feels like a hidden chapter of old Cambridge. Set on a generous 45x156 foot lot, this 1.5 storey home offers thoughtful living with two bedrooms, a full bath, and a layout that makes sense. Inside, original details like a wood-burning fireplace in the living room and a separate dining room add warmth and intention. Outside, a fully fenced yard stretches deepperfect for quiet mornings or busy gatheringswith a detached single garage tucked neatly off to the side. A home with history, in a neighbourhood that wears its past beautifully." +"ArchitecturalStyle": array:1 [ 0 => "1 1/2 Storey" ] +"Basement": array:1 [ 0 => "Unfinished" ] +"ConstructionMaterials": array:2 [ 0 => "Brick" 1 => "Aluminum Siding" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CountyOrParish": "Waterloo" +"CoveredSpaces": "1.0" +"CreationDate": "2025-08-05T15:41:07.563207+00:00" +"CrossStreet": "OAK" +"DirectionFaces": "South" +"Directions": "MAIN ST/ OAK" +"Exclusions": "Small freezer in the sunroom" +"ExpirationDate": "2025-11-28" +"FireplaceFeatures": array:1 [ 0 => "Wood" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ 0 => "Concrete" ] +"GarageYN": true +"InteriorFeatures": array:1 [ 0 => "Water Heater" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-08-05" +"MainOfficeKey": "079800" +"MajorChangeTimestamp": "2025-08-13T00:43:54Z" +"MlsStatus": "Price Change" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-08-05T15:30:52Z" +"OriginalListPrice": 599900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2805912" +"ParcelNumber": "038190144" +"ParkingFeatures": array:1 [ 0 => "Private" ] +"ParkingTotal": "3.0" +"PhotosChangeTimestamp": "2025-08-05T15:30:52Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"PreviousListPrice": 599900.0 +"PriceChangeTimestamp": "2025-08-13T00:43:54Z" +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:2 [ 0 => "Showing System" 1 => "List Brokerage" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "POLLOCK" +"StreetNumber": "29" +"StreetSuffix": "Avenue" +"TaxAnnualAmount": "4084.09" +"TaxLegalDescription": "PT LT 93 PL 442 CAMBRIDGE; PT LT 6 N/S MAIN ST E PL 615 CAMBRIDGE AS IN D37522 & D36920 CITY OF CAMBRIDGE" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2%" +"TransactionType": "For Sale" +"VirtualTourURLBranded": "https://youriguide.com/29_pollock_ave_cambridge_on/" +"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/29_pollock_ave_cambridge_on/" +"Zoning": "R4" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 156.0 +"LotWidth": 45.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12324454')" +"GarageType": "Detached" +"HeatSource": "Gas" +"RollNumber": "300608002006100" +"SurveyType": "None" +"HoldoverDays": 60 +"KitchensTotal": 1 +"ParkingSpaces": 2 +"provider_name": "TRREB" +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included In" ] +"PossessionType": "Flexible" +"PriorMlsStatus": "New" +"WashroomsType1": 1 +"LivingAreaRange": "1100-1500" +"RoomsAboveGrade": 7 +"RoomsBelowGrade": 1 +"PossessionDetails": "FLEXIBLE" +"WashroomsType1Pcs": 4 +"BedroomsAboveGrade": 2 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"WashroomsType1Level": "Second" +"MediaChangeTimestamp": "2025-08-13T00:43:54Z" +"SystemModificationTimestamp": "2025-08-13T00:43:54.603396Z" +"Media": array:36 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] 31 => array:26 [ …26] 32 => array:26 [ …26] 33 => array:26 [ …26] 34 => array:26 [ …26] 35 => array:26 [ …26] ] } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14890 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12237985" +"ListingId": "X12237985" +"PropertyType": "Residential" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-08-12T23:25:45Z" +"RFModificationTimestamp": "2025-08-12T23:33:05Z" +"ListPrice": 334000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Cambridge" +"PostalCode": "N1R 3E3" +"UnparsedAddress": "#206 - 155 Water Street, Cambridge, ON N1R 3E3" +"Coordinates": array:2 [ 0 => -80.3123023 1 => 43.3600536 ] +"Latitude": 43.3600536 +"Longitude": -80.3123023 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE FLOWER CITY REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Beautiful River Front Condominiums. Appliances In Good Condition, Massive Patio, One Bedroom Condo - Perfect For A Couple. Easy Access To The Unit From Parking (S68). Spacious Eat-In Kitchen With Moveable Island & California Closet With Ample Storage, Rooftop Terrace With Gas Fireplace + BBQ, Excellent Location In Galt, Close To The Theatre, Library, Gym, Boutique Shops, Farmers Market. Grand River is Just Across The Street." +"ArchitecturalStyle": array:1 [ 0 => "Apartment" ] +"AssociationFee": "422.0" +"AssociationFeeIncludes": array:3 [ 0 => "Parking Included" 1 => "Building Insurance Included" 2 => "Water Included" ] +"Basement": array:1 [ 0 => "None" ] +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CountyOrParish": "Waterloo" +"CreationDate": "2025-06-21T18:03:48.035646+00:00" +"CrossStreet": "Ainsle St S /Water St S" +"Directions": "Ainsle St S /Water St S" +"ExpirationDate": "2025-09-21" +"InteriorFeatures": array:1 [ 0 => "Other" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "Inside" ] +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-06-21" +"MainOfficeKey": "206600" +"MajorChangeTimestamp": "2025-08-08T20:58:28Z" +"MlsStatus": "Price Change" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-06-21T18:00:25Z" +"OriginalListPrice": 348786.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2599816" +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ 0 => "Restricted" ] +"PhotosChangeTimestamp": "2025-08-12T23:25:45Z" +"PreviousListPrice": 348786.0 +"PriceChangeTimestamp": "2025-08-08T20:58:27Z" +"ShowingRequirements": array:1 [ 0 => "List Brokerage" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "S" +"StreetName": "Water" +"StreetNumber": "155" +"StreetSuffix": "Street" +"TaxAnnualAmount": "2580.0" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2 %" +"TransactionType": "For Sale" +"UnitNumber": "206" +"DDFYN": true +"Locker": "None" +"Exposure": "East" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12237985')" +"ElevatorYN": true +"GarageType": "None" +"HeatSource": "Gas" +"SurveyType": "None" +"BalconyType": "Terrace" +"HoldoverDays": 60 +"LaundryLevel": "Main Level" +"LegalStories": "2" +"ParkingType1": "Owned" +"KitchensTotal": 1 +"ParkingSpaces": 1 +"provider_name": "TRREB" +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included In" ] +"PossessionType": "1-29 days" +"PriorMlsStatus": "New" +"WashroomsType1": 1 +"CondoCorpNumber": 623 +"LivingAreaRange": "0-499" +"RoomsAboveGrade": 4 +"PropertyFeatures": array:1 [ 0 => "Park" ] +"SquareFootSource": "MLS" +"PossessionDetails": "30 DAYS" +"WashroomsType1Pcs": 3 +"BedroomsAboveGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"StatusCertificateYN": true +"LegalApartmentNumber": "06" +"MediaChangeTimestamp": "2025-08-12T23:25:45Z" +"PropertyManagementCompany": "Sanderson Management inc" +"SystemModificationTimestamp": "2025-08-12T23:25:45.347484Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:15 [ 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] ] } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14889 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12205402" +"ListingId": "X12205402" +"PropertyType": "Residential Lease" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-08-12T23:25:16Z" +"RFModificationTimestamp": "2025-08-12T23:33:28Z" +"ListPrice": 1800.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Cambridge" +"PostalCode": "N1R 3E3" +"UnparsedAddress": "#206 - 155 Water Street, Cambridge, ON N1R 3E3" +"Coordinates": array:2 [ 0 => -80.3123023 1 => 43.3600536 ] +"Latitude": 43.3600536 +"Longitude": -80.3123023 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE FLOWER CITY REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Beautiful River Front Condominiums. Appliances In Good Condition , Massive Patio , One Bedroom Condo Perfect For A Couple. Easy Access To The Unit From Parking (S68). Spacious Eat In Kitchen With Moveable Island & California Closet With Ample Storage, Rooftop Terrace With Gas Fireplace + BBQ, Excellent Location In Galt , Close To The Theatre , Library , Gym , Boutique Shops , Farmers Market. Grand River is Just Across The Street ." +"ArchitecturalStyle": array:1 [ 0 => "Apartment" ] +"Basement": array:1 [ 0 => "None" ] +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CountyOrParish": "Waterloo" +"CreationDate": "2025-06-08T16:07:47.466819+00:00" +"CrossStreet": "Ainsle St S /Water St S" +"Directions": "Ainsle St S /Water St S" +"ExpirationDate": "2025-09-30" +"Furnished": "Unfurnished" +"InteriorFeatures": array:1 [ 0 => "Other" ] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "Inside" ] +"LeaseTerm": "24 Months" +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-06-08" +"MainOfficeKey": "206600" +"MajorChangeTimestamp": "2025-06-08T16:04:38Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-06-08T16:04:38Z" +"OriginalListPrice": 1800.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2524490" +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ 0 => "Restricted" ] +"PhotosChangeTimestamp": "2025-08-12T23:25:15Z" +"RentIncludes": array:4 [ 0 => "Building Insurance" 1 => "Building Maintenance" 2 => "Central Air Conditioning" 3 => "Parking" ] +"ShowingRequirements": array:1 [ 0 => "List Brokerage" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "S" +"StreetName": "Water" +"StreetNumber": "155" +"StreetSuffix": "Street" +"TransactionBrokerCompensation": "Half Month Rent + HST" +"TransactionType": "For Lease" +"UnitNumber": "206" +"DDFYN": true +"Locker": "None" +"Exposure": "East" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12205402')" +"ElevatorYN": true +"GarageType": "None" +"HeatSource": "Gas" +"SurveyType": "None" +"BalconyType": "Terrace" +"HoldoverDays": 60 +"LaundryLevel": "Main Level" +"LegalStories": "2" +"ParkingType1": "Owned" +"CreditCheckYN": true +"KitchensTotal": 1 +"ParkingSpaces": 1 +"PaymentMethod": "Other" +"provider_name": "TRREB" +"ContractStatus": "Available" +"PossessionDate": "2025-07-01" +"PossessionType": "30-59 days" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"CondoCorpNumber": 623 +"DepositRequired": true +"LivingAreaRange": "0-499" +"RoomsAboveGrade": 4 +"LeaseAgreementYN": true +"PaymentFrequency": "Monthly" +"PropertyFeatures": array:1 [ 0 => "Park" ] +"SquareFootSource": "Previous MLS" +"PossessionDetails": "1st July 2025" +"PrivateEntranceYN": true +"WashroomsType1Pcs": 3 +"BedroomsAboveGrade": 1 +"EmploymentLetterYN": true +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"RentalApplicationYN": true +"LegalApartmentNumber": "06" +"MediaChangeTimestamp": "2025-08-12T23:25:15Z" +"PortionPropertyLease": array:1 [ 0 => "Entire Property" ] +"ReferencesRequiredYN": true +"PropertyManagementCompany": "MF Property Management" +"SystemModificationTimestamp": "2025-08-12T23:25:16.714087Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:15 [ 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] ] } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14888 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12340441" +"ListingId": "X12340441" +"PropertyType": "Residential" +"PropertySubType": "Condo Townhouse" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-08-12T22:34:54Z" +"RFModificationTimestamp": "2025-08-13T21:09:27Z" +"ListPrice": 569000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Cambridge" +"PostalCode": "N3H 4Z9" +"UnparsedAddress": "513 E Parkview Crescent E 4, Cambridge, ON N3H 4Z9" +"Coordinates": array:2 [ 0 => -80.3755116 1 => 43.3951585 ] +"Latitude": 43.3951585 +"Longitude": -80.3755116 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "HOMELIFE SUPERSTARS REAL ESTATE LIMITED" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Your search ends here!! Prime Location. Featuring Open Concept Main Floor, Stainless Steel Appliances.3+1 Bedroom and 2 full washroom. Pot Lights, 2nd Floor Features Large Prime Bedroom and two good sized bedrooms Finished basement with one bedroom and full washroom. Freshly Painted. Near Shopping, School, Transit, Major Highways and Parks. Move In Ready. Priced to sell. This Townhome is well maintained and upgraded. No disappointments. Show and sell. Ideal for big family as well as for investors, Nice backyard for summer fun and activities." +"ArchitecturalStyle": array:1 [ 0 => "2-Storey" ] +"AssociationFee": "394.66" +"AssociationFeeIncludes": array:3 [ 0 => "Common Elements Included" 1 => "Building Insurance Included" 2 => "Parking Included" ] +"Basement": array:2 [ 0 => "Full" 1 => "Finished" ] +"ConstructionMaterials": array:2 [ 0 => "Brick" 1 => "Vinyl Siding" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Waterloo" +"CreationDate": "2025-08-12T20:07:28.113877+00:00" +"CrossStreet": "Priston Pkwy/ Pineview Crescent" +"Directions": "East" +"Exclusions": "None" +"ExpirationDate": "2025-11-30" +"Inclusions": "S/S Stove, S/S fridge, Microwave, Washer, Dryer, All Elf"s and window coverings." +"InteriorFeatures": array:3 [ 0 => "Carpet Free" 1 => "On Demand Water Heater" 2 => "Water Heater" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "In Basement" ] +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-08-12" +"LotSizeSource": "MPAC" +"MainOfficeKey": "004200" +"MajorChangeTimestamp": "2025-08-12T19:58:50Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-08-12T19:58:50Z" +"OriginalListPrice": 569000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2843742" +"ParcelNumber": "235900004" +"ParkingFeatures": array:1 [ 0 => "Private" ] +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ 0 => "Restricted" ] +"PhotosChangeTimestamp": "2025-08-12T19:58:51Z" +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"ShowingRequirements": array:1 [ 0 => "Lockbox" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirPrefix": "E" +"StreetDirSuffix": "E" +"StreetName": "Parkview" +"StreetNumber": "513" +"StreetSuffix": "Crescent" +"TaxAnnualAmount": "2882.0" +"TaxAssessedValue": 196000 +"TaxYear": "2024" +"TransactionBrokerCompensation": "2.0%+Hst" +"TransactionType": "For Sale" +"UnitNumber": "4" +"UFFI": "No" +"DDFYN": true +"Locker": "None" +"Exposure": "East" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12340441')" +"GarageType": "None" +"HeatSource": "Gas" +"RollNumber": "300610002426904" +"SurveyType": "Unknown" +"Waterfront": array:1 [ 0 => "None" ] +"BalconyType": "None" +"RentalItems": "Hot water Tank" +"HoldoverDays": 90 +"LaundryLevel": "Lower Level" +"LegalStories": "Main" +"ParkingType1": "Owned" +"KitchensTotal": 1 +"ParkingSpaces": 1 +"provider_name": "TRREB" +"AssessmentYear": 2024 +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included In" ] +"PossessionDate": "2025-09-01" +"PossessionType": "Immediate" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"CondoCorpNumber": 590 +"LivingAreaRange": "1000-1199" +"MortgageComment": "TAC" +"RoomsAboveGrade": 6 +"RoomsBelowGrade": 1 +"SquareFootSource": "Owner" +"WashroomsType1Pcs": 3 +"WashroomsType2Pcs": 3 +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"StatusCertificateYN": true +"WashroomsType1Level": "Second" +"WashroomsType2Level": "Basement" +"LegalApartmentNumber": "4" +"MediaChangeTimestamp": "2025-08-12T19:58:51Z" +"PropertyManagementCompany": "Edwards Community Management" +"SystemModificationTimestamp": "2025-08-12T22:34:56.597682Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:16 [ 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] ] } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14887 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12340743" +"ListingId": "X12340743" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-08-12T22:16:51Z" +"RFModificationTimestamp": "2025-08-13T21:09:28Z" +"ListPrice": 899000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Cambridge" +"PostalCode": "N3E 0B4" +"UnparsedAddress": "28 Pickett Place, Cambridge, ON N3E 0B4" +"Coordinates": array:2 [ 0 => -80.3430007 1 => 43.428462 ] +"Latitude": 43.428462 +"Longitude": -80.3430007 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RIGHT AT HOME REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Absolutely Stunning Fully Upgraded Detached Home Situated In Desirable River Mills. Easy to Park 4 Cars! Elegant Cottage Exterior Feel with High Quality Stone Finish. 7 Inch Wide Hardwood Main Floor & Upstairs Hallway. 9Ft Ceilings & Gas Fireplace On Main Floor. Soaring 8Ft Doors Throughout. 3 Bedrooms Upstairs + Extra Bedroom/Office Room On Main Floor! Chef Style Kitchen with Extended Cabinets, Quartz Counters, Tiled Backsplash, Double Undermount Sink, Stainless Steel Appliances & a Breakfast Bar. Upstairs Laundry, Oak Stairs. All Spacious Bedrooms W/ Luxury Carpet. Both Full Washrooms With Quartz Counters & Tiled Showers. Large Ensuite W/ Glass Stand-Up Shower. Basement is a Newly & Fully Finished In-Law Suite with a Bedroom, Kitchen, Huge Walk-in Closet, and Two Living Areas! New Concrete Work Beside Driveway, Walkway Beside House, and Oversized Backyard Patio, Perfect for an Outdoor Gazebo & Outdoor Furniture! Fully Fenced! The Neighborhood Park is Literally a 1 Minute Walk From the House! Highway 401 Exit is Easy to Get to in 5 Minutes, Costco is a 7 Minute Drive, This Location is a Great In-Between Cambridge Core & Kitchener Border, Milton is a 25 Minute Drive. Basement Utility Room Has All the Rough-in's Completed for a Laundry Set. Don't Miss Out on this Great Opportunity!" +"ArchitecturalStyle": array:1 [ 0 => "2-Storey" ] +"AttachedGarageYN": true +"Basement": array:2 [ 0 => "Full" 1 => "Unfinished" ] +"ConstructionMaterials": array:2 [ 0 => "Stone" 1 => "Vinyl Siding" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CoolingYN": true +"Country": "CA" +"CountyOrParish": "Waterloo" +"CoveredSpaces": "1.0" +"CreationDate": "2025-08-12T22:19:58.629160+00:00" +"CrossStreet": "Pointer Street & Pickett Place" +"DirectionFaces": "East" +"Directions": "From 401, Exit on Hespeler Rd Hwy 24 & Head North, Turn Left (West) on Maple Grove Rd, Turn Left (South) on Compass Trail, Turn Left on Pickett Place." +"ExpirationDate": "2026-03-31" +"ExteriorFeatures": array:3 [ 0 => "Patio" 1 => "Porch" 2 => "Paved Yard" ] +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"GarageYN": true +"HeatingYN": true +"Inclusions": "2 Fridges, 2 Stoves, 1 Combo Microwave Rangehood, 1 Rangehood, 1 Dishwasher, 1 Washer, 1 Dryer, All Electric Light Fixtures, All Window Coverings/Blinds, Sump Pump, Auto Garage Door Opener & Remote(s)." +"InteriorFeatures": array:3 [ 0 => "Auto Garage Door Remote" 1 => "Sump Pump" 2 => "ERV/HRV" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-08-12" +"LotDimensionsSource": "Other" +"LotSizeDimensions": "30.02 x 108.46 Feet" +"LotSizeSource": "Other" +"MainOfficeKey": "062200" +"MajorChangeTimestamp": "2025-08-12T22:16:51Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-08-12T22:16:51Z" +"OriginalListPrice": 899000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2844426" +"ParcelNumber": "037560463" +"ParkingFeatures": array:1 [ 0 => "Private" ] +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2025-08-12T22:16:51Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"RoomsTotal": "9" +"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": "Pickett" +"StreetNumber": "28" +"StreetSuffix": "Place" +"TaxAnnualAmount": "6104.43" +"TaxBookNumber": "300614002123475" +"TaxLegalDescription": "Lot 75, Plan 58M604 Subject To An Easement" +"TaxYear": "2025" +"Topography": array:1 [ 0 => "Flat" ] +"TransactionBrokerCompensation": "2% + HST *See Broker Remarks*" +"TransactionType": "For Sale" +"VirtualTourURLBranded": "https://mediatours.ca/property/28-pickett-place-cambridge/" +"VirtualTourURLUnbranded": "https://unbranded.mediatours.ca/property/28-pickett-place-cambridge/" +"Zoning": "Residential" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 108.46 +"LotWidth": 30.02 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12340743')" +"PictureYN": true +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "300614002123475" +"SurveyType": "Unknown" +"RentalItems": "Hot Water Heater with Reliance" +"HoldoverDays": 60 +"LaundryLevel": "Upper Level" +"WaterMeterYN": true +"KitchensTotal": 2 +"ParkingSpaces": 3 +"provider_name": "TRREB" +"short_address": "Cambridge, ON N3E 0B4, CA" +"ApproximateAge": "6-15" +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included In" ] +"PossessionDate": "2025-09-02" +"PossessionType": "Immediate" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"WashroomsType4": 1 +"LivingAreaRange": "1500-2000" +"RoomsAboveGrade": 9 +"RoomsBelowGrade": 3 +"ParcelOfTiedLand": "No" +"PropertyFeatures": array:3 [ 0 => "Park" 1 => "Public Transit" 2 => "School Bus Route" ] +"StreetSuffixCode": "Pl" +"BoardPropertyType": "Free" +"LotSizeRangeAcres": "< .50" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 3 +"WashroomsType3Pcs": 4 +"WashroomsType4Pcs": 3 +"BedroomsAboveGrade": 4 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"KitchensBelowGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"ShowingAppointments": "Broker Bay" +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"WashroomsType3Level": "Second" +"WashroomsType4Level": "Basement" +"MediaChangeTimestamp": "2025-08-12T22:16:51Z" +"MLSAreaDistrictOldZone": "X11" +"MLSAreaMunicipalityDistrict": "Cambridge" +"SystemModificationTimestamp": "2025-08-12T22:16:52.632474Z" +"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] ] } ] +success: true +page_size: 10 +page_count: 72 +count: 718 +after_key: "" } ] ]
