Compare listings
ComparePlease enter your username or email address. You will receive a link to create a new password via email.
array:2 [ "RF Cache Key: 603252ca25c9e62da723f147ef800f4288d02e0b0f2377ae9ebe4970aa5ecd8b" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#4264 +items: array:10 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4008 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12476055" +"ListingId": "X12476055" +"PropertyType": "Residential" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-11-20T12:52:34Z" +"RFModificationTimestamp": "2026-02-08T00:53:34Z" +"ListPrice": 529900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Kitchener" +"PostalCode": "N2P 0K8" +"UnparsedAddress": "525 New Dundee Road 322, Kitchener, ON N2P 0K8" +"Coordinates": array:2 [ 0 => -80.4198982 1 => 43.3734201 ] +"Latitude": 43.3734201 +"Longitude": -80.4198982 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "CONVERGE REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to the Flats at Rainbow Lake! Nestled in nature, this brand-new, beautifully built residence offers a variety of amenities, including a yoga studio with sauna, a fitness center, a party room, a social lounge, a library, and a pet wash station. Residents enjoy private access to the Rainbow Lake Conservation Area. The building is ideally situated near local shops, dining, recreational venues, and Highway 401 for added convenience.This 912 sq ft unit includes 2 bedrooms and 2 bathrooms. The spacious primary bedroom features an ensuite with a large walk-in shower, while the second bedroom offers a built-in wardrobe. The open-concept kitchen, dining, and living areas are perfect for entertaining and relaxing, complete with stainless steel Samsung appliances. Step out onto the generous 92 sq ft balcony and enjoy the surrounding peace and serenity. Dont miss the opportunity to make this exceptional building your new home." +"ArchitecturalStyle": array:1 [ 0 => "Apartment" ] +"AssociationFee": "421.51" +"AssociationFeeIncludes": array:1 [ 0 => "None" ] +"Basement": array:1 [ 0 => "None" ] +"ConstructionMaterials": array:1 [ 0 => "Concrete Block" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Waterloo" +"CreationDate": "2026-02-08T00:07:16.685908+00:00" +"CrossStreet": "New Dundee Road and Reichert Drive" +"Directions": "N" +"ExpirationDate": "2026-04-01" +"InteriorFeatures": array:1 [ 0 => "None" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "Ensuite" ] +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-10-22" +"MainOfficeKey": "475600" +"MajorChangeTimestamp": "2025-10-22T15:35:53Z" +"MlsStatus": "New" +"OccupantType": "Partial" +"OriginalEntryTimestamp": "2025-10-22T15:35:53Z" +"OriginalListPrice": 529900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3164314" +"ParcelNumber": "237840260" +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ 0 => "Yes-with Restrictions" ] +"PhotosChangeTimestamp": "2025-10-22T15:35:53Z" +"ShowingRequirements": array:1 [ 0 => "Go Direct" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "New Dundee" +"StreetNumber": "525" +"StreetSuffix": "Road" +"TaxAnnualAmount": "2843.76" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2.5" +"TransactionType": "For Sale" +"UnitNumber": "322" +"DDFYN": true +"Locker": "None" +"Exposure": "North" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12476055')" +"ElevatorYN": true +"GarageType": "Other" +"HeatSource": "Electric" +"RollNumber": "301206001030021" +"SurveyType": "Available" +"BalconyType": "Terrace" +"HoldoverDays": 90 +"LaundryLevel": "Main Level" +"LegalStories": "3" +"ParkingSpot1": "1" +"ParkingType1": "Owned" +"HeatTypeMulti": array:1 [ 0 => "Forced Air" ] +"KitchensTotal": 1 +"ParkingSpaces": 1 +"provider_name": "TRREB" +"short_address": "Kitchener, ON N2P 0K8, CA" +"ApproximateAge": "0-5" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included In" ] +"PossessionDate": "2025-11-01" +"PossessionType": "Immediate" +"PriorMlsStatus": "Draft" +"WashroomsType1": 2 +"CondoCorpNumber": 784 +"HeatSourceMulti": array:1 [ 0 => "Electric" ] +"LivingAreaRange": "900-999" +"MortgageComment": "TREAT AS CLEAR" +"RoomsAboveGrade": 3 +"SquareFootSource": "FLOOR PLAN" +"ParkingLevelUnit1": "1" +"PossessionDetails": "IMMEDIATE" +"WashroomsType1Pcs": 3 +"BedroomsAboveGrade": 2 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"StatusCertificateYN": true +"WashroomsType1Level": "Flat" +"LegalApartmentNumber": "22" +"MediaChangeTimestamp": "2025-10-22T15:35:53Z" +"PropertyManagementCompany": "Weigel Property management" +"SystemModificationTimestamp": "2025-11-20T12:52:34.384914Z" +"VendorPropertyInfoStatement": true +"GreenPropertyInformationStatement": true +"Media": array:21 [ 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] ] } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4001 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12464454" +"ListingId": "X12464454" +"PropertyType": "Residential" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-11-20T12:11:21Z" +"RFModificationTimestamp": "2026-02-08T00:53:31Z" +"ListPrice": 525000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2L 3W6" +"UnparsedAddress": "251 Lester Street 605, Waterloo, ON N2L 3W6" +"Coordinates": array:2 [ 0 => -80.5347762 1 => 43.4734668 ] +"Latitude": 43.4734668 +"Longitude": -80.5347762 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE SIGNATURE REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Prime Turnkey Investment in Waterloo's University District! Exceptional opportunity to own a purpose-built 5-bedroom, 2-bathroom condo at 251 Lester Street, located just steps from Wilfrid Laurier University and the University of Waterloo. Designed for strong rental performance, this unit has the potential to generate over $49,000 in annual gross income. The condo offers a bright, open-concept living space, two full bathrooms, and comes fully furnished, making it move-in ready for tenants. Investors will appreciate the professional property management in place, ensuring a seamless, hands-off ownership experience. Condo fees include heat and water, while the building features shared laundry, elevator access, and unbeatable proximity to transit, shopping, dining, and everyday amenities. Whether you're expanding your portfolio or entering the student rental market, this property delivers reliable returns in one of Waterloo's most sought-after locations. Upgrades to the unit include: entire unit recently painted, new toilets, new dishwasher, new security locks on all rooms, new laminate flooring, new student chairs (gaming style) and whiteboards in every room." +"ArchitecturalStyle": array:1 [ 0 => "Apartment" ] +"AssociationFee": "790.49" +"AssociationFeeIncludes": array:5 [ 0 => "Heat Included" 1 => "Common Elements Included" 2 => "Building Insurance Included" 3 => "Water Included" 4 => "CAC Included" ] +"Basement": array:1 [ 0 => "None" ] +"CoListOfficeName": "ROYAL LEPAGE SIGNATURE REALTY" +"CoListOfficePhone": "416-443-0300" +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Waterloo" +"CreationDate": "2026-02-08T00:08:07.009744+00:00" +"CrossStreet": "University Ave W / Lester St" +"Directions": "University Ave W / Lester St" +"Exclusions": "Tenants Belongings" +"ExpirationDate": "2026-03-14" +"Inclusions": "Fridge, Stove, Hood Fan, B/I Dishwasher, 5 Beds, 5 Desks, Couch, Kitchen Table and Chairs" +"InteriorFeatures": array:1 [ 0 => "None" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:2 [ 0 => "Coin Operated" 1 => "In Building" ] +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-10-15" +"MainOfficeKey": "572000" +"MajorChangeTimestamp": "2025-10-16T00:07:37Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2025-10-16T00:07:37Z" +"OriginalListPrice": 525000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3138640" +"PetsAllowed": array:1 [ 0 => "Yes-with Restrictions" ] +"PhotosChangeTimestamp": "2025-10-16T00:07:37Z" +"ShowingRequirements": array:2 [ 0 => "Lockbox" 1 => "Showing System" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Lester" +"StreetNumber": "251" +"StreetSuffix": "Street" +"TaxAnnualAmount": "4205.82" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2.25% + HST" +"TransactionType": "For Sale" +"UnitNumber": "605" +"DDFYN": true +"Locker": "None" +"Exposure": "East" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12464454')" +"GarageType": "None" +"HeatSource": "Gas" +"SurveyType": "Unknown" +"BalconyType": "None" +"HoldoverDays": 90 +"LegalStories": "3" +"ParkingType1": "None" +"HeatTypeMulti": array:1 [ 0 => "Forced Air" ] +"KitchensTotal": 1 +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2L 3W6, CA" +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included In" ] +"PossessionDate": "2025-10-15" +"PossessionType": "Immediate" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"CondoCorpNumber": 641 +"HeatSourceMulti": array:1 [ 0 => "Gas" ] +"LivingAreaRange": "1200-1399" +"RoomsAboveGrade": 8 +"SquareFootSource": "MPAC" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 3 +"BedroomsAboveGrade": 5 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Main" +"LegalApartmentNumber": "304" +"MediaChangeTimestamp": "2025-10-16T00:07:37Z" +"PropertyManagementCompany": "Wolverine Property Management" +"SystemModificationTimestamp": "2025-11-20T12:11:21.356527Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:12 [ 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] ] } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4007 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12464450" +"ListingId": "X12464450" +"PropertyType": "Residential" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-11-20T12:11:15Z" +"RFModificationTimestamp": "2026-02-08T00:53:30Z" +"ListPrice": 525000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2L 3W6" +"UnparsedAddress": "251 Lester Street 202, Waterloo, ON N2L 3W6" +"Coordinates": array:2 [ 0 => -80.5347762 1 => 43.4734668 ] +"Latitude": 43.4734668 +"Longitude": -80.5347762 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE SIGNATURE REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Prime Turnkey Investment in Waterloo's University District! Exceptional opportunity to own a include heat and water, while the building features shared laundry, elevator access, and include: entire unit recently painted, new toilets, new dishwasher, new security locks on all purpose-built 5-bedroom, 2-bathroom condo at 251 Lester Street, located just steps from Wilfrid Laurier University and the University of Waterloo. Designed for strong rental performance, this unit has the potential to generate over $49,000 in annual gross income. The condo offers a bright, open-concept living space, two full bathrooms, and comes fully furnished, making it move-in ready for tenants. Investors will appreciate the professional property management in place, ensuring a seamless, hands-off ownership experience. Condo fees include heat and water, while the building features shared laundry, elevator access, and unbeatable proximity to transit, shopping, dining, and everyday amenities. Whether you're expanding your portfolio or entering the student rental market, this property delivers reliable returns in one of Waterloo's most sought-after locations. Upgrades to the unit include: entire unit recently painted, new toilets, new dishwasher, new security locks on all rooms, new laminate flooring, new student chairs (gaming style) and whiteboards in every room." +"ArchitecturalStyle": array:1 [ 0 => "Apartment" ] +"AssociationFee": "790.49" +"AssociationFeeIncludes": array:5 [ 0 => "Heat Included" 1 => "Common Elements Included" 2 => "Building Insurance Included" 3 => "Water Included" 4 => "CAC Included" ] +"Basement": array:1 [ 0 => "None" ] +"CoListOfficeName": "ROYAL LEPAGE SIGNATURE REALTY" +"CoListOfficePhone": "416-443-0300" +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Waterloo" +"CreationDate": "2026-02-08T00:08:14.734531+00:00" +"CrossStreet": "University Ave W / Lester St" +"Directions": "University Ave W / Lester St" +"Exclusions": "Tenants Belongings" +"ExpirationDate": "2026-03-14" +"Inclusions": "Fridge, Stove, Hood Fan, B/I Dishwasher, 5 Beds, 5 Desks, Couch, Kitchen Table, Chairs" +"InteriorFeatures": array:1 [ 0 => "None" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:2 [ 0 => "Coin Operated" 1 => "In Building" ] +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-10-15" +"MainOfficeKey": "572000" +"MajorChangeTimestamp": "2025-10-16T00:03:56Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2025-10-16T00:03:56Z" +"OriginalListPrice": 525000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3138810" +"PetsAllowed": array:1 [ 0 => "Yes-with Restrictions" ] +"PhotosChangeTimestamp": "2025-10-16T00:03:56Z" +"ShowingRequirements": array:2 [ 0 => "Lockbox" 1 => "Showing System" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Lester" +"StreetNumber": "251" +"StreetSuffix": "Street" +"TaxAnnualAmount": "3946.37" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2.25% + HST" +"TransactionType": "For Sale" +"UnitNumber": "202" +"DDFYN": true +"Locker": "None" +"Exposure": "East" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12464450')" +"GarageType": "None" +"HeatSource": "Gas" +"SurveyType": "Unknown" +"BalconyType": "None" +"HoldoverDays": 90 +"LegalStories": "3" +"ParkingType1": "None" +"HeatTypeMulti": array:1 [ 0 => "Forced Air" ] +"KitchensTotal": 1 +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2L 3W6, CA" +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included In" ] +"PossessionDate": "2025-10-15" +"PossessionType": "Immediate" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"CondoCorpNumber": 641 +"HeatSourceMulti": array:1 [ 0 => "Gas" ] +"LivingAreaRange": "1200-1399" +"RoomsAboveGrade": 8 +"SquareFootSource": "MPAC" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 3 +"BedroomsAboveGrade": 5 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Main" +"LegalApartmentNumber": "304" +"MediaChangeTimestamp": "2025-10-16T00:03:56Z" +"PropertyManagementCompany": "Rent Corp Property Management" +"SystemModificationTimestamp": "2025-11-20T12:11:15.329144Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:12 [ 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] ] } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4004 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12454498" +"ListingId": "X12454498" +"PropertyType": "Residential" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-11-20T11:37:40Z" +"RFModificationTimestamp": "2026-02-08T00:53:28Z" +"ListPrice": 475900.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2J 1A4" +"UnparsedAddress": "107 Roger Street 101, Waterloo, ON N2J 1A4" +"Coordinates": array:2 [ 0 => -80.5091859 1 => 43.46019 ] +"Latitude": 43.46019 +"Longitude": -80.5091859 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX TWIN CITY REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to your ideal urban retreat, perfectly situated in the heart of Uptown Waterloo. This beautifully designed 2-bedroom, 1-bathroom condo offers the perfect blend of style, comfort, and unbeatable location ideal for professionals, students, or investors looking to be at the center of it all. Step inside and be greeted by luxury vinyl plank flooring that flows seamlessly throughout the space, creating a modern and cohesive feel. Large, bright windows flood the unit with natural light, creating a warm, welcoming ambiance. The kitchen is a true highlight, featuring sleek quartz countertops that add both beauty and durability to your culinary experience. Both bedrooms are equipped with walk in closets, providing ample storage and comfort. Enjoy your morning coffee or unwind after a long day on your private ground-level balcony, offering a cozy outdoor escape. This location simply cant be beat. Just minutes from the University of Waterloo, Wilfrid Laurier University, and steps to the LRT, youll enjoy quick, car-free access to Downtown Kitchener, local restaurants, boutique shops, the hospital, and Spur Line Trail. Whether you're commuting, grabbing a bite, or enjoying the outdoors, everything you need is right at your doorstep. Don't miss this rare opportunity to own a stylish condo in one of Waterloo Regions most sought-after communities." +"ArchitecturalStyle": array:1 [ 0 => "1 Storey/Apt" ] +"AssociationAmenities": array:3 [ 0 => "Party Room/Meeting Room" 1 => "Visitor Parking" 2 => "Elevator" ] +"AssociationFee": "447.54" +"AssociationFeeIncludes": array:1 [ 0 => "Building Insurance Included" ] +"Basement": array:1 [ 0 => "None" ] +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Waterloo" +"CreationDate": "2026-02-08T00:09:08.762612+00:00" +"CrossStreet": "UNION & WEBER" +"Directions": "Moore Avenue S & Roger Street" +"ExpirationDate": "2026-02-28" +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"InteriorFeatures": array:2 [ 0 => "Water Heater" 1 => "Built-In Oven" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "In-Suite Laundry" ] +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-10-08" +"LotSizeSource": "MPAC" +"MainOfficeKey": "360900" +"MajorChangeTimestamp": "2025-10-09T16:36:43Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-10-09T16:36:43Z" +"OriginalListPrice": 475900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3103402" +"ParcelNumber": "237730305" +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ 0 => "Yes-with Restrictions" ] +"PhotosChangeTimestamp": "2025-10-09T16:36:43Z" +"Roof": array:1 [ 0 => "Flat" ] +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Roger" +"StreetNumber": "107" +"StreetSuffix": "Street" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2% NST HST" +"TransactionType": "For Sale" +"UnitNumber": "101" +"VirtualTourURLBranded": "https://youtu.be/45l Q4TBGwfw" +"VirtualTourURLUnbranded": "https://youtu.be/j Am2-9b3Jy Y" +"Zoning": "GR1" +"UFFI": "No" +"DDFYN": true +"Locker": "None" +"Exposure": "East" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12454498')" +"GarageType": "None" +"HeatSource": "Gas" +"RollNumber": "301602135005126" +"SurveyType": "None" +"BalconyType": "Open" +"HoldoverDays": 60 +"LaundryLevel": "Main Level" +"LegalStories": "1" +"ParkingType1": "Exclusive" +"HeatTypeMulti": array:1 [ 0 => "Forced Air" ] +"KitchensTotal": 1 +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2J 1A4, CA" +"ApproximateAge": "New" +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included In" ] +"PossessionDate": "2025-10-13" +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"CondoCorpNumber": 733 +"HeatSourceMulti": array:1 [ 0 => "Gas" ] +"LivingAreaRange": "800-899" +"RoomsAboveGrade": 6 +"EnsuiteLaundryYN": true +"PropertyFeatures": array:6 [ 0 => "School" 1 => "Park" 2 => "Public Transit" 3 => "Golf" 4 => "Lake/Pond" 5 => "Place Of Worship" ] +"SquareFootSource": "BUILDER" +"WashroomsType1Pcs": 4 +"BedroomsAboveGrade": 2 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"WashroomsType1Level": "Main" +"LegalApartmentNumber": "101" +"MediaChangeTimestamp": "2025-10-09T16:36:43Z" +"PropertyManagementCompany": "DUKA PROPERTY MANAGEMENT" +"SystemModificationTimestamp": "2025-11-20T11:37:40.321771Z" +"VendorPropertyInfoStatement": true +"Media": array:35 [ 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] ] } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4009 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12442356" +"ListingId": "X12442356" +"PropertyType": "Residential" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-11-20T11:00:29Z" +"RFModificationTimestamp": "2026-01-27T00:45:59Z" +"ListPrice": 349000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Kitchener" +"PostalCode": "N2A 0K9" +"UnparsedAddress": "110 Fergus Avenue 419, Kitchener, ON N2A 0K9" +"Coordinates": array:2 [ 0 => -80.4410161 1 => 43.4345867 ] +"Latitude": 43.4345867 +"Longitude": -80.4410161 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE TERREQUITY REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to this stunning one-bedroom, one-bathroom condo in prestigious Hush Condos. Boasting an open-concept layout, this condo offers seamless flow from the living room to the modern kitchen with stainless steel appliances, Quartz Countertop, Built-in Microwave and ample cabinet space. Residents also benefit from an array of exceptional amenities that boasts a luxurious lifestyle with a low maintenance/common elements fee: including an outdoor BBQ area in the courtyard Garden, perfect for entertaining guests inviting a serene and tranquil atmosphere. Stylish space available for private functions with ample visitor parking. Located 10 mins away from Costco, St. Mary's Hospital, Fairview Mall, Chicopee Ski Area, Highways and more." +"AccessibilityFeatures": array:2 [ 0 => "Elevator" 1 => "Open Floor Plan" ] +"ArchitecturalStyle": array:1 [ 0 => "Apartment" ] +"AssociationAmenities": array:4 [ 0 => "BBQs Allowed" 1 => "Elevator" 2 => "Party Room/Meeting Room" 3 => "Visitor Parking" ] +"AssociationFee": "340.48" +"AssociationFeeIncludes": array:3 [ 0 => "Heat Included" 1 => "Building Insurance Included" 2 => "Common Elements Included" ] +"Basement": array:1 [ 0 => "None" ] +"ConstructionMaterials": array:2 [ 0 => "Stone" 1 => "Vinyl Siding" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Waterloo" +"CoveredSpaces": "1.0" +"CreationDate": "2026-01-11T15:07:04.906809+00:00" +"CrossStreet": "Weber Street E / Fergus Ave" +"Directions": "Weber Street E / Fergus Ave" +"Exclusions": "N/A" +"ExpirationDate": "2026-10-03" +"ExteriorFeatures": array:8 [ 0 => "Built-In-BBQ" 1 => "Controlled Entry" 2 => "Landscaped" 3 => "Lighting" 4 => "Patio" 5 => "Paved Yard" 6 => "Privacy" 7 => "Seasonal Living" ] +"GarageYN": true +"Inclusions": "S/S Appliances: Fridge, Stove, B/I Microwave and Dishwasher. Washer and Dryer. All ELFs and Light Fixtures." +"InteriorFeatures": array:2 [ 0 => "Primary Bedroom - Main Floor" 1 => "Auto Garage Door Remote" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "In-Suite Laundry" ] +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-10-03" +"MainOfficeKey": "045700" +"MajorChangeTimestamp": "2025-10-03T13:21:25Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-10-03T13:21:25Z" +"OriginalListPrice": 349000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3080192" +"ParcelNumber": "237070191" +"ParkingFeatures": array:2 [ 0 => "Inside Entry" 1 => "Underground" ] +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ 0 => "Yes-with Restrictions" ] +"PhotosChangeTimestamp": "2025-10-03T13:21:26Z" +"SecurityFeatures": array:1 [ 0 => "Monitored" ] +"ShowingRequirements": array:1 [ 0 => "Lockbox" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Fergus" +"StreetNumber": "110" +"StreetSuffix": "Avenue" +"TaxAnnualAmount": "2535.26" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2.5%" +"TransactionType": "For Sale" +"UnitNumber": "419" +"View": array:1 [ 0 => "Garden" ] +"VirtualTourURLUnbranded": "https://winsold.com/matterport/embed/428685/DRb4TGz V4na" +"DDFYN": true +"Locker": "None" +"Exposure": "West" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12442356')" +"ElevatorYN": true +"GarageType": "Underground" +"HeatSource": "Gas" +"RollNumber": "301203001819417" +"SurveyType": "None" +"BalconyType": "None" +"RentalItems": "Hot Water Tank" +"HoldoverDays": 90 +"LaundryLevel": "Main Level" +"LegalStories": "4" +"ParkingSpot1": "19" +"ParkingType1": "Owned" +"HeatTypeMulti": array:1 [ 0 => "Forced Air" ] +"KitchensTotal": 1 +"UnderContract": array:1 [ 0 => "Hot Water Heater" ] +"provider_name": "TRREB" +"short_address": "Kitchener, ON N2A 0K9, CA" +"ApproximateAge": "0-5" +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included In" ] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"CondoCorpNumber": 707 +"HeatSourceMulti": array:1 [ 0 => "Gas" ] +"LivingAreaRange": "500-599" +"RoomsAboveGrade": 4 +"EnsuiteLaundryYN": true +"PropertyFeatures": array:6 [ 0 => "Clear View" 1 => "Fenced Yard" 2 => "Park" 3 => "Public Transit" 4 => "Rec./Commun.Centre" 5 => "School" ] +"SquareFootSource": "MPAC" +"ParkingLevelUnit1": "1" +"PossessionDetails": "TBD" +"WashroomsType1Pcs": 4 +"BedroomsAboveGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"ShowingAppointments": "Showings Anytime. Lockbox located on garage entrance wall." +"StatusCertificateYN": true +"WashroomsType1Level": "Main" +"LegalApartmentNumber": "26" +"MediaChangeTimestamp": "2025-10-03T13:21:26Z" +"PropertyManagementCompany": "King Condo Management - 519-279-6796" +"SystemModificationTimestamp": "2025-11-20T11:00:29.462658Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:40 [ 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] ] } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4030 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "W12561322" +"ListingId": "W12561322" +"PropertyType": "Residential" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-11-20T10:50:14Z" +"RFModificationTimestamp": "2026-02-08T00:51:37Z" +"ListPrice": 679000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Mississauga" +"PostalCode": "L5B 0N3" +"UnparsedAddress": "36 Elm Drive W 3702, Mississauga, ON L5B 0N3" +"Coordinates": array:2 [ 0 => -79.6318832 1 => 43.5897723 ] +"Latitude": 43.5897723 +"Longitude": -79.6318832 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL ESTATE REALTY POINT" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to #3702- 36 Elm Drive West, Mississauga, ON. A luxurious Condo featuring sophisticated and traditional interior design by Dochia Interior; designed by Roy Varacalli, the celebrated architect of Cusumano Architects. This Pent-house condo apartment offers unparalleled living in this exquisite, modern corner unit, offering breathtaking and unobstructed views. The expansive master bedroom features an ensuite and a spacious closet, ensuring comfort and convenience. The sleek, contemporary kitchen is equipped with top of-the-line stainless steel appliances and a built-in island, perfect for culinary enthusiasts. The unit also boasts a large second bedroom, providing ample space for family or guests. Uniquely positioned with the only balcony on the building's side, this residence offers exclusive, unobstructed vistas, creating a serene and private outdoor retreat. Nestled in a prime location, the property is surrounded by an array of shopping destinations and picturesque parks, enhancing the urban living experience. Walk to Square One, Hurontario, close to Cooksville Go Station, Steps from New LRT Transit. Building Amenities include 24hr Concierge, Gym, Party Room and more. Must See." +"ArchitecturalStyle": array:1 [ 0 => "Apartment" ] +"AssociationAmenities": array:5 [ 0 => "Day Care" 1 => "Elevator" 2 => "Guest Suites" 3 => "Gym" 4 => "Visitor Parking" ] +"AssociationFee": "552.11" +"AssociationFeeIncludes": array:6 [ 0 => "Water Included" 1 => "Building Insurance Included" 2 => "Common Elements Included" 3 => "CAC Included" 4 => "Parking Included" 5 => "Heat Included" ] +"Basement": array:1 [ 0 => "Apartment" ] +"BuildingName": "Edge Towers" +"CityRegion": "Fairview" +"ConstructionMaterials": array:1 [ 0 => "Concrete Poured" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CountyOrParish": "Peel" +"CoveredSpaces": "1.0" +"CreationDate": "2026-02-08T00:09:42.742205+00:00" +"CrossStreet": "Hurontario St / Burnhamthorpe" +"Directions": "Hurontario St/Burnhamthorpe Rd W" +"ExpirationDate": "2026-11-16" +"GarageYN": true +"Inclusions": "1 Underground Parking Spot and Extra Large Storage Locker Included. Integrated Full Size Appliances, including Built-in Fridge, Oven, Recessed Hood Range, Built-in Dishwasher, Upgraded Bathroom Lighting." +"InteriorFeatures": array:1 [ 0 => "Other" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "In-Suite Laundry" ] +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-11-20" +"MainOfficeKey": "282400" +"MajorChangeTimestamp": "2025-11-20T10:50:13Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2025-11-20T10:50:13Z" +"OriginalListPrice": 679000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3283300" +"ParkingFeatures": array:1 [ 0 => "Underground" ] +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ 0 => "Yes-with Restrictions" ] +"PhotosChangeTimestamp": "2025-11-20T10:50:14Z" +"SecurityFeatures": array:1 [ 0 => "Concierge/Security" ] +"ShowingRequirements": array:3 [ 0 => "Lockbox" 1 => "See Brokerage Remarks" 2 => "Showing System" ] +"SignOnPropertyYN": true +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "W" +"StreetName": "Elm" +"StreetNumber": "36" +"StreetSuffix": "Drive" +"TaxAnnualAmount": "4321.55" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2.5% + HST" +"TransactionType": "For Sale" +"UnitNumber": "3702" +"View": array:4 [ 0 => "City" 1 => "Downtown" 2 => "Skyline" 3 => "Panoramic" ] +"VirtualTourURLBranded": "https://www.houssmax.ca/vtour/c9144351" +"VirtualTourURLUnbranded": "https://www.houssmax.ca/vtournb/c9144351" +"DDFYN": true +"Locker": "Owned" +"Sewage": array:1 [ 0 => "Municipal Available" ] +"Exposure": "South West" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('W12561322')" +"ElevatorYN": true +"GarageType": "Underground" +"HeatSource": "Gas" +"RollNumber": "1258945632" +"SurveyType": "Unknown" +"Waterfront": array:1 [ 0 => "Direct" ] +"BalconyType": "Enclosed" +"LockerLevel": "P2" +"HoldoverDays": 90 +"LaundryLevel": "Main Level" +"LegalStories": "35" +"LockerNumber": "137" +"ParkingSpot1": "7" +"ParkingType1": "Owned" +"HeatTypeMulti": array:1 [ 0 => "Forced Air" ] +"KitchensTotal": 1 +"WaterBodyType": "Lake" +"provider_name": "TRREB" +"short_address": "Mississauga, ON L5B 0N3, CA" +"ApproximateAge": "0-5" +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Not Subject to HST" ] +"PossessionDate": "2026-01-30" +"PossessionType": "60-89 days" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"CondoCorpNumber": 1153 +"HeatSourceMulti": array:1 [ 0 => "Gas" ] +"LivingAreaRange": "700-799" +"MortgageComment": "TAC" +"RoomsAboveGrade": 5 +"EnsuiteLaundryYN": true +"PropertyFeatures": array:3 [ 0 => "Public Transit" 1 => "School" 2 => "Place Of Worship" ] +"SquareFootSource": "Builder's Plan" +"ParkingLevelUnit1": "P1" +"PossessionDetails": "TBD" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 3 +"BedroomsAboveGrade": 2 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"StatusCertificateYN": true +"ContactAfterExpiryYN": true +"LegalApartmentNumber": "02" +"MediaChangeTimestamp": "2025-11-20T10:50:14Z" +"PropertyManagementCompany": "Zoran Property 905-949-2389" +"SystemModificationTimestamp": "2025-11-20T10:50:14.495911Z" +"PermissionToContactListingBrokerToAdvertise": true +"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] ] } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4031 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12390687" +"ListingId": "X12390687" +"PropertyType": "Residential" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-11-20T08:35:44Z" +"RFModificationTimestamp": "2026-02-08T00:53:22Z" +"ListPrice": 275999.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2L 0H7" +"UnparsedAddress": "258b Sunview Street 227, Waterloo, ON N2L 0H7" +"Coordinates": array:2 [ 0 => -80.5334051 1 => 43.4745719 ] +"Latitude": 43.4745719 +"Longitude": -80.5334051 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Coldwell Banker Neumann Real Estate" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "This open-concept condo is a smart choice for anyone looking for comfort, convenience, and long-term value. Parents can secure housing for their university-bound child while building equity, why pay rent when you can own an appreciating asset? For students, its an equally smart move: instead of paying rent, you could put those monthly payments toward your own mortgage. Inside, the bright and contemporary layout features sleek laminate flooring, high ceilings, and large windows that flood the space with natural light. The kitchen is equipped with stylish two-toned cabinetry, quartz countertops, a modern backsplash, and stainless steel appliances. The open living/sleeping area is thoughtfully designed to maximize space, and a well-appointed bathroom with contemporary fixtures completes the suite. The location is unbeatable just steps from Wilfrid Laurier University and a 10-minute walk to the University of Waterloo. Daily life is effortless with cafes, restaurants, shopping, and public transit (including the LRT) all within walking distance. The condo is also close to Waterloos thriving tech hubs, making it attractive for young professionals seeking an urban lifestyle. Whether you're a parent looking to secure affordable housing for your student, an investor seeking a high-demand rental property, or a student wanting to build equity instead of paying rent, 227-258B Sunview St is a strategic investment in one of Canadas top university towns." +"ArchitecturalStyle": array:1 [ 0 => "Bachelor/Studio" ] +"AssociationFee": "230.0" +"AssociationFeeIncludes": array:4 [ 0 => "Heat Included" 1 => "Water Included" 2 => "Common Elements Included" 3 => "Building Insurance Included" ] +"Basement": array:1 [ 0 => "None" ] +"ConstructionMaterials": array:1 [ 0 => "Metal/Steel Siding" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Waterloo" +"CreationDate": "2026-02-08T00:12:10.766225+00:00" +"CrossStreet": "Sunview and University" +"Directions": "University Avenue turn right onto Sunview St" +"ExpirationDate": "2026-02-27" +"Inclusions": "Dishwasher, Dryer, Refrigerator, Stove, Washer, Kitchen Tables & Chairs, Coffee Table, Living Room Single Chair, 3-Seater Couch, Computer Desk, Headboard & Bedframe, Mattress, Bed Cover, 2 Drawer Dressers, Wardrobe." +"InteriorFeatures": array:1 [ 0 => "Carpet Free" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "In-Suite Laundry" ] +"ListAOR": "One Point Association of REALTORS" +"ListingContractDate": "2025-09-09" +"LotSizeSource": "MPAC" +"MainOfficeKey": "558300" +"MajorChangeTimestamp": "2025-11-17T15:53:19Z" +"MlsStatus": "Extension" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2025-09-09T13:18:59Z" +"OriginalListPrice": 289000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2893386" +"ParcelNumber": "236660112" +"PetsAllowed": array:1 [ 0 => "Yes-with Restrictions" ] +"PhotosChangeTimestamp": "2025-09-10T15:49:09Z" +"PreviousListPrice": 289000.0 +"PriceChangeTimestamp": "2025-10-16T13:22:37Z" +"ShowingRequirements": array:2 [ 0 => "Lockbox" 1 => "Showing System" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Sunview" +"StreetNumber": "258b" +"StreetSuffix": "Street" +"TaxAnnualAmount": "2392.0" +"TaxAssessedValue": 188000 +"TaxYear": "2024" +"TransactionBrokerCompensation": "2.5" +"TransactionType": "For Sale" +"UnitNumber": "227" +"DDFYN": true +"Locker": "None" +"Exposure": "South" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12390687')" +"GarageType": "None" +"HeatSource": "Gas" +"RollNumber": "301604435004346" +"SurveyType": "Unknown" +"BalconyType": "None" +"HoldoverDays": 90 +"LegalStories": "2" +"ParkingType1": "None" +"HeatTypeMulti": array:1 [ 0 => "Forced Air" ] +"KitchensTotal": 1 +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2L 0H7, CA" +"ApproximateAge": "6-10" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included In" ] +"PossessionDate": "2025-11-17" +"PossessionType": "Flexible" +"PriorMlsStatus": "Price Change" +"WashroomsType1": 1 +"CondoCorpNumber": 666 +"HeatSourceMulti": array:1 [ 0 => "Gas" ] +"LivingAreaRange": "0-499" +"RoomsAboveGrade": 3 +"EnsuiteLaundryYN": true +"SquareFootSource": "Public Records" +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 4 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Other" ] +"ShowingAppointments": "24 hours notice, because it is tenanted" +"StatusCertificateYN": true +"WashroomsType1Level": "Main" +"LegalApartmentNumber": "21" +"MediaChangeTimestamp": "2025-09-10T15:49:09Z" +"ExtensionEntryTimestamp": "2025-11-17T15:53:19Z" +"PropertyManagementCompany": "Wilson Blanchard Management Inc." +"SystemModificationTimestamp": "2025-11-20T08:35:44.791481Z" +"VendorPropertyInfoStatement": true +"Media": array:9 [ 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] ] } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4032 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12388091" +"ListingId": "X12388091" +"PropertyType": "Residential" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-11-20T08:28:48Z" +"RFModificationTimestamp": "2026-01-27T00:45:56Z" +"ListPrice": 435000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Kitchener" +"PostalCode": "N2P 2A5" +"UnparsedAddress": "35 Green Valley Drive 103, Kitchener, ON N2P 2A5" +"Coordinates": array:2 [ 0 => -80.4321171 1 => 43.3983239 ] +"Latitude": 43.3983239 +"Longitude": -80.4321171 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX ICON REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to luxury living at 103 - 35 Green Valley Drive, Kitchener. This splendid 2 bed, 2 bath residence combines modern sophistication with timeless comfort, offering a home you'll be proud to call your own. Every detail has been thoughtfully curated, from the sleek renovations to the tranquil natural setting. Step inside and you'll be greeted by bright, freshly painted interiors (2025) accented with upgraded baseboards, window frames, and door casings (2025), giving the unit a refined elegance. Lovely flooring pairs beautifully with newly added pot lights (2022) and updated light fixtures, creating a warm and inviting ambiance throughout. The spacious kitchen has been upgraded with a new countertop (2020), along with a newer stove and fridge (2023), complemented by a washer and dryer (2025). An elegant electric fireplace (2023) adds both comfort and style. The thoughtful renovations continue with renovated closets, a new electrical panel (2022), and upgraded outside windows (2024), ensuring both functionality and peace of mind. Beyond the unit itself, serenity abounds. The calming flow of the Grand River and the surrounding walking trails offer a daily retreat into nature. Conveniently situated near Highway 401 and Conestoga College, this residence provides easy access to major routes, while a nearby plaza offers groceries, dining, and retail options just steps away. Families will also appreciate its close proximity to schools, parks, and public transit. The building welcomes you with a secure entrance and inviting lobby, including variety of amenities, a gym with sauna, a quiet room, a party room, and a bike room. Surrounding parks provide safe and enjoyable outdoor spaces for both adults and children alike. This home offers more than just a place to live-it delivers a lifestyle of convenience, and elegance. We invite you to experience the allure of this remarkable residence and make it your own." +"ArchitecturalStyle": array:1 [ 0 => "1 Storey/Apt" ] +"AssociationAmenities": array:5 [ 0 => "Bike Storage" 1 => "Elevator" 2 => "Exercise Room" 3 => "Sauna" 4 => "Visitor Parking" ] +"AssociationFee": "571.3" +"AssociationFeeIncludes": array:4 [ 0 => "Building Insurance Included" 1 => "Common Elements Included" 2 => "Parking Included" 3 => "Water Included" ] +"Basement": array:1 [ 0 => "None" ] +"ConstructionMaterials": array:1 [ 0 => "Stucco (Plaster)" ] +"Cooling": array:1 [ 0 => "None" ] +"Country": "CA" +"CountyOrParish": "Waterloo" +"CreationDate": "2026-01-11T15:22:04.249726+00:00" +"CrossStreet": "Pioneer Dr" +"Directions": "Homer Watson on to Pioneer Drive and turn left on Green Valley Drive - guest parking above ground in view of front entrance" +"Exclusions": "TV and TV Mount brackets" +"ExpirationDate": "2026-02-25" +"FireplaceFeatures": array:2 [ 0 => "Electric" 1 => "Living Room" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Inclusions": "Dryer, Hot Water Tank Owned, Microwave, Range Hood, Refrigerator, Smoke Detector, Stove, Washer, Window Coverings, Water Purifier" +"InteriorFeatures": array:5 [ 0 => "Water Heater Owned" 1 => "Water Softener" 2 => "Water Purifier" 3 => "Separate Heating Controls" 4 => "Carpet Free" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:2 [ 0 => "In-Suite Laundry" 1 => "Laundry Room" ] +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-09-08" +"MainOfficeKey": "322400" +"MajorChangeTimestamp": "2025-09-08T14:19:09Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-09-08T14:19:09Z" +"OriginalListPrice": 435000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2946392" +"ParcelNumber": "232000007" +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ 0 => "Yes-with Restrictions" ] +"PhotosChangeTimestamp": "2025-09-08T14:19:10Z" +"Roof": array:1 [ 0 => "Flat" ] +"SecurityFeatures": array:1 [ 0 => "Smoke Detector" ] +"ShowingRequirements": array:2 [ 0 => "Lockbox" 1 => "Showing System" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Green Valley" +"StreetNumber": "35" +"StreetSuffix": "Drive" +"TaxAnnualAmount": "2374.15" +"TaxAssessedValue": 175000 +"TaxYear": "2025" +"TransactionBrokerCompensation": "2.00 % + HST" +"TransactionType": "For Sale" +"UnitNumber": "103" +"VirtualTourURLBranded": "https://youriguide.com/1mk66_35_green_valley_dr_kitchener_on/" +"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/1mk66_35_green_valley_dr_kitchener_on/" +"Zoning": "R2DC5" +"DDFYN": true +"Locker": "None" +"Exposure": "East" +"HeatType": "Baseboard" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12388091')" +"GarageType": "None" +"HeatSource": "Electric" +"RollNumber": "301204004035003" +"SurveyType": "Unknown" +"BalconyType": "None" +"HoldoverDays": 30 +"LaundryLevel": "Main Level" +"LegalStories": "1" +"ParkingType1": "Exclusive" +"HeatTypeMulti": array:1 [ 0 => "Baseboard" ] +"KitchensTotal": 1 +"ParkingSpaces": 1 +"provider_name": "TRREB" +"short_address": "Kitchener, ON N2P 2A5, CA" +"ApproximateAge": "31-50" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included In" ] +"PossessionType": "30-59 days" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"CondoCorpNumber": 200 +"HeatSourceMulti": array:1 [ 0 => "Electric" ] +"LivingAreaRange": "1000-1199" +"RoomsAboveGrade": 5 +"EnsuiteLaundryYN": true +"PropertyFeatures": array:6 [ 0 => "Park" 1 => "Place Of Worship" 2 => "Public Transit" 3 => "Rec./Commun.Centre" 4 => "School Bus Route" 5 => "River/Stream" ] +"SquareFootSource": "Iguide" +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 4 +"BedroomsAboveGrade": 2 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"ShowingAppointments": "Remove shoes, leave business card & turn off all lights when finished. Press buzzer 225 from the front entrance to enter in the building." +"StatusCertificateYN": true +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Main" +"LegalApartmentNumber": "103" +"MediaChangeTimestamp": "2025-09-08T14:46:05Z" +"PropertyManagementCompany": "Wilson Blanchard" +"SystemModificationTimestamp": "2025-11-20T08:28:48.310653Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:37 [ 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] ] } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4033 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12383368" +"ListingId": "X12383368" +"PropertyType": "Residential" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-11-20T08:19:07Z" +"RFModificationTimestamp": "2026-02-08T00:53:22Z" +"ListPrice": 549000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterloo" +"PostalCode": "N2L 3W6" +"UnparsedAddress": "261 Lester Street 101, Waterloo, ON N2L 3W6" +"Coordinates": array:2 [ 0 => -80.5354582 1 => 43.4742674 ] +"Latitude": 43.4742674 +"Longitude": -80.5354582 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX REALTY SPECIALISTS INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Turnkey Student Rental Investment Fully Furnished 5 Bed, 2 Bath at 261 Lester St. Prime opportunity to own in one of Waterloos most sought-after student rental buildings, just steps from the University of Waterloo. This spacious 5-bedroom, 2-bathroom unit is purpose-built for student living, offering a modern layout designed for comfort and convenience. Perfect for investors seeking a hands-off, income-generating property in a high-demand market. Currently leased to a group of A+ tenants (all female) on a secure 3-year lease term, this property provides immediate cash flow with excellent rental income. Professionally managed, the building is well-maintained and tailored to student needs, ensuring consistent demand year after year." +"ArchitecturalStyle": array:1 [ 0 => "Apartment" ] +"AssociationFee": "941.24" +"AssociationFeeIncludes": array:4 [ 0 => "Common Elements Included" 1 => "Heat Included" 2 => "Building Insurance Included" 3 => "Water Included" ] +"AssociationYN": true +"AttachedGarageYN": true +"Basement": array:1 [ 0 => "None" ] +"CoListOfficeName": "RE/MAX REALTY SPECIALISTS INC." +"CoListOfficePhone": "905-828-3434" +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CoolingYN": true +"Country": "CA" +"CountyOrParish": "Waterloo" +"CreationDate": "2026-02-08T00:12:22.596084+00:00" +"CrossStreet": "University/Lester" +"Directions": "University/Lester" +"Exclusions": "ALL TENANT BELONGINGS" +"ExpirationDate": "2026-03-31" +"HeatingYN": true +"Inclusions": "All Electric Light Fixtures, All Window Coverings and Blinds, All Appliances, HVAC, Furniture. New $9000 heat exchanger/HVAC system installed in 2024 - warranty info available." +"InteriorFeatures": array:1 [ 0 => "None" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "Coin Operated" ] +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-09-05" +"MainOfficeKey": "495300" +"MajorChangeTimestamp": "2025-09-05T13:37:49Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2025-09-05T13:37:49Z" +"OriginalListPrice": 549000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2944142" +"ParkingFeatures": array:1 [ 0 => "None" ] +"PetsAllowed": array:1 [ 0 => "Yes-with Restrictions" ] +"PhotosChangeTimestamp": "2025-09-05T13:37:49Z" +"PropertyAttachedYN": true +"RoomsTotal": "8" +"ShowingRequirements": array:2 [ 0 => "Showing System" 1 => "List Brokerage" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Lester" +"StreetNumber": "261" +"StreetSuffix": "Street" +"TaxAnnualAmount": "3891.75" +"TaxBookNumber": "301604280006001" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2.25% + HST" +"TransactionType": "For Sale" +"UnitNumber": "101" +"DDFYN": true +"Locker": "None" +"Exposure": "East" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12383368')" +"PictureYN": true +"GarageType": "None" +"HeatSource": "Gas" +"RollNumber": "301604280006001" +"SurveyType": "None" +"BalconyType": "None" +"HoldoverDays": 90 +"LegalStories": "1" +"ParkingType1": "None" +"HeatTypeMulti": array:1 [ 0 => "Forced Air" ] +"KitchensTotal": 1 +"provider_name": "TRREB" +"short_address": "Waterloo, ON N2L 3W6, CA" +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included In" ] +"PossessionDate": "2025-09-05" +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 2 +"CondoCorpNumber": 630 +"HeatSourceMulti": array:1 [ 0 => "Gas" ] +"LivingAreaRange": "1200-1399" +"RoomsAboveGrade": 7 +"SquareFootSource": "Owner" +"StreetSuffixCode": "St" +"BoardPropertyType": "Condo" +"PossessionDetails": "Immediate" +"WashroomsType1Pcs": 4 +"BedroomsAboveGrade": 5 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"WashroomsType1Level": "Main" +"LegalApartmentNumber": "1" +"MediaChangeTimestamp": "2025-09-05T13:37:49Z" +"MLSAreaDistrictOldZone": "X11" +"PropertyManagementCompany": "Cie Property Management" +"MLSAreaMunicipalityDistrict": "Waterloo" +"SystemModificationTimestamp": "2025-11-20T08:19:08.007326Z" +"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] ] } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4034 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12356117" +"ListingId": "X12356117" +"PropertyType": "Residential" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-11-20T07:18:36Z" +"RFModificationTimestamp": "2026-02-08T00:53:20Z" +"ListPrice": 584900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Brantford" +"PostalCode": "N3T 2L3" +"UnparsedAddress": "1 Wellington Street 308, Brantford, ON N3T 2L3" +"Coordinates": array:2 [ 0 => -80.2522626 1 => 43.1419906 ] +"Latitude": 43.1419906 +"Longitude": -80.2522626 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Right At Home Realty, Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Motivated Seller! The condo is rented to a great tenant that is paying 2,500$ per month. Absolutely Beautiful Brand New And Rare 3Bed, 2Bath Corner Unit Condo With Abundance Of Natural Lighting Is Sure To Impress! All 3 Rooms Are Very Spacious And Can Be Easy Used As Play Room Or Recreational Space. Comes With 1 Parking, 9' Foot Ceilings, And Many Upgrades. Open Concept Floor Plan With Laminate Throughout. Modern Spacious Kitchen With Brand New Stainless Steel Appliances. This Sought-after Condo In Desired Downtown Location With Steps Away From The Go Train Station, Laurier University, Conestoga College, YMCA, Harmony And Market Square, And Many Restaurants And Parks. Don't Forget To Include Amenities Like A Gym, A Lovely Rooftop Garden, And A Party Room. Don't Delay, Book Your Showing Today." +"ArchitecturalStyle": array:1 [ 0 => "Other" ] +"AssociationAmenities": array:5 [ 0 => "Gym" 1 => "Rooftop Deck/Garden" 2 => "Game Room" 3 => "Party Room/Meeting Room" 4 => "Visitor Parking" ] +"AssociationFee": "701.08" +"AssociationFeeIncludes": array:4 [ 0 => "CAC Included" 1 => "Heat Included" 2 => "Building Insurance Included" 3 => "Common Elements Included" ] +"Basement": array:1 [ 0 => "None" ] +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Brantford" +"CoveredSpaces": "1.0" +"CreationDate": "2026-02-08T00:13:14.657608+00:00" +"CrossStreet": "Brant Avenue & West Street" +"Directions": "Brant Avenue & West Street" +"ExpirationDate": "2026-03-15" +"Inclusions": "Built-in Microwave, Dishwasher, Dryer, Range Hood, Refrigerator, Stove, Washer" +"InteriorFeatures": array:1 [ 0 => "None" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "Ensuite" ] +"ListAOR": "Oakville, Milton & District Real Estate Board" +"ListingContractDate": "2025-08-20" +"LotSizeDimensions": "x" +"MainOfficeKey": "540200" +"MajorChangeTimestamp": "2025-08-21T01:41:19Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2025-08-21T01:41:19Z" +"OriginalListPrice": 584900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft2881522" +"ParcelNumber": "328240070" +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ 0 => "Yes-with Restrictions" ] +"PhotosChangeTimestamp": "2025-08-21T01:41:20Z" +"PropertyAttachedYN": true +"Roof": array:1 [ 0 => "Flat" ] +"RoomsTotal": "7" +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "WELLINGTON" +"StreetNumber": "1" +"StreetSuffix": "Street" +"TaxAnnualAmount": "3196.0" +"TaxBookNumber": "290620200406744" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2.5% plus hst" +"TransactionType": "For Sale" +"UnitNumber": "308" +"Zoning": "R" +"DDFYN": true +"Locker": "Exclusive" +"Exposure": "East" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12356117')" +"GarageType": "Underground" +"HeatSource": "Other" +"RollNumber": "290620200406744" +"SurveyType": "None" +"Waterfront": array:1 [ 0 => "None" ] +"BalconyType": "None" +"HoldoverDays": 90 +"LegalStories": "3" +"LockerNumber": "A6" +"ParkingType1": "Owned" +"HeatTypeMulti": array:1 [ 0 => "Forced Air" ] +"provider_name": "TRREB" +"short_address": "Brantford, ON N3T 2L3, CA" +"ApproximateAge": "0-5" +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included In" ] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 2 +"CondoCorpNumber": 124 +"HeatSourceMulti": array:1 [ 0 => "Other" ] +"LivingAreaRange": "1000-1199" +"RoomsAboveGrade": 7 +"SquareFootSource": "Builder" +"ParkingLevelUnit1": "A/6" +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 3 +"BedroomsAboveGrade": 3 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"WashroomsType1Level": "Main" +"LegalApartmentNumber": "8" +"MediaChangeTimestamp": "2025-08-21T01:41:20Z" +"PropertyManagementCompany": "G3 Property Solutions Inc" +"SystemModificationTimestamp": "2025-11-20T07:18:36.146586Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:22 [ 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] ] } ] +success: true +page_size: 10 +page_count: 719 +count: 7189 +after_key: "" } ] "RF Cache Key: 5f2e4a03e397dfc059bb210a593ad47f69ea85b04d21be98c92a219c13d13a4a" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#4122 +items: array:5 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4035 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "E12799906" +"ListingId": "E12799906" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-02-24T19:21:05Z" +"RFModificationTimestamp": "2026-02-24T19:27:48Z" +"ListPrice": 999888.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Pickering" +"PostalCode": "L1X 0C8" +"UnparsedAddress": "1562 Brandy Court, Pickering, ON L1X 0C8" +"Coordinates": array:2 [ 0 => -79.090576 1 => 43.835765 ] +"Latitude": 43.835765 +"Longitude": -79.090576 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX HALLMARK FRASER GROUP REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Tucked at the end of a quiet cul-de-sac, this end-lot detached sits beside the ravine with no neighbour to the west. The west side and backyard are wrapped in treeline and conservation, creating a true sense of retreat, where your daily view is greenery, birdsong, and sunset light filtering through the canopy. Curb appeal begins with an interlocking walkway framed by two interlocking flower beds. Out back, the lifestyle is the headline: step onto a generous deck with a pergola set against the forest edge. Entertain with a gas BBQ connection, gather around the gas fire pit, then unwind in the Arctic Hot Tub Swim Spa, all while the ravine and treeline deliver privacy you can feel. Thoughtful native plantings and trees invite monarchs and songbirds, while an outdoor pot light system extends the atmosphere into the evening. Inside, the main level offers a formal dining room with hardwood floors, a vaulted ceiling, pot lights, and a large window overlooking the trees. The open-concept kitchen features a wrap-around counter, tile backsplash, ceramic flooring, and a bright breakfast area with a walkout to the deck (glass door with shutters) plus a west-facing window to the ravine. The living room is warm and light-filled with a gas fireplace, hardwood, and large windows on two sides. Upstairs, an open study/loft with hardwood provides flexible work-from-home or lounge space. Bedrooms are generously sized with excellent closet storage. The primary suite impresses with a spa-like ensuite (soaker tub, glass shower, double vanity, separate toilet) and a custom built-in closet system. Second-floor laundry for added convenience. Finished basement includes two rooms and a 3-piece bath; currently used as a guitar/wood workshop. Equipment may stay or be removed. Minutes to Seaton Centre shops, banks, cafés, dining, trails/green space, and Pickering Golf Club. Furnace 2015, AC 2016, Roof 2015, HWT 2015, Hot Tub Swim Spa 2016, Deck & Pergola 2016. Window 2015" +"ArchitecturalStyle": array:1 [ 0 => "2-Storey" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"CityRegion": "Duffin Heights" +"CoListOfficeName": "RE/MAX HALLMARK FRASER GROUP REALTY" +"CoListOfficePhone": "416-494-7686" +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Durham" +"CoveredSpaces": "1.0" +"CreationDate": "2026-02-18T22:32:06.926471+00:00" +"CrossStreet": "Brock Rd & Tauton Rd" +"DirectionFaces": "West" +"Directions": "From Brock Rd, enter the neighbourhood from Zent Dr, circle around the park to continue on Brandy Crt, at the end of cul de sac to your right." +"Exclusions": "Drapes & rods (staging)" +"ExpirationDate": "2026-05-31" +"ExteriorFeatures": array:5 [ 0 => "Backs On Green Belt" 1 => "Hot Tub" 2 => "Landscape Lighting" 3 => "Landscaped" 4 => "Privacy" ] +"FireplaceFeatures": array:2 [ 0 => "Natural Gas" 1 => "Living Room" ] +"FireplaceYN": true +"FoundationDetails": array:1 [ 0 => "Concrete" ] +"GarageYN": true +"Inclusions": "Coat Cabinet, Fridge, Electric Stove, Dishwasher, Microwave/Toaster Oven, Washer and Dryer, All Window Coverings (excluding staging items) and Electric Light Fixtures, Existing Fans and remotes, Gas Fire Place and remote, Central Vacuum, 1 Garage Door Opener and 1 remote, Central Air Conditioning, Bathroom Mirrors, Arctic Hot Tub Swim Spa and supplies, Over head Bins In Garage, * Workshop equipment - see attached for list (can stay or be removed, Seller willing to provide buyer with guitar making lessons after deal firm, all workshop equipment will be AS IS) *" +"InteriorFeatures": array:2 [ 0 => "Carpet Free" 1 => "Workbench" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-02-18" +"LotSizeSource": "MPAC" +"MainOfficeKey": "255100" +"MajorChangeTimestamp": "2026-02-18T22:26:36Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-02-18T22:26:36Z" +"OriginalListPrice": 999888.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3568430" +"ParcelNumber": "263831051" +"ParkingFeatures": array:1 [ 0 => "Private" ] +"ParkingTotal": "3.0" +"PhotosChangeTimestamp": "2026-02-24T19:21:06Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:2 [ 0 => "Lockbox" 1 => "Showing System" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Brandy" +"StreetNumber": "1562" +"StreetSuffix": "Court" +"TaxAnnualAmount": "7227.0" +"TaxLegalDescription": "LOT 63, PLAN 40M2495 SUBJECT TO AN EASEMENT FOR ENTRY AS IN DR1396001 CITY OF PICKERING" +"TaxYear": "2025" +"Topography": array:1 [ 0 => "Wooded/Treed" ] +"TransactionBrokerCompensation": "2.5% + HST" +"TransactionType": "For Sale" +"View": array:3 [ 0 => "Forest" 1 => "Park/Greenbelt" 2 => "Trees/Woods" ] +"VirtualTourURLBranded": "https://youtu.be/0v M-RIFz JUo" +"VirtualTourURLUnbranded": "https://youtu.be/0v M-RIFz JUo" +"Zoning": "S-SD-SA-3" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 92.33 +"LotShape": "Irregular" +"LotWidth": 47.24 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('E12799906')" +"GarageType": "Built-In" +"HeatSource": "Gas" +"RollNumber": "180103001119373" +"SurveyType": "Unknown" +"Waterfront": array:1 [ 0 => "None" ] +"RentalItems": "Hot water tank $31.57/month" +"HoldoverDays": 90 +"LaundryLevel": "Upper Level" +"HeatTypeMulti": array:1 [ 0 => "Forced Air" ] +"KitchensTotal": 1 +"ParkingSpaces": 2 +"provider_name": "TRREB" +"ApproximateAge": "6-15" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included In" ] +"PossessionType": "60-89 days" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"WashroomsType4": 1 +"HeatSourceMulti": array:1 [ 0 => "Gas" ] +"LivingAreaRange": "1500-2000" +"RoomsAboveGrade": 8 +"RoomsBelowGrade": 2 +"LotSizeAreaUnits": "Square Feet" +"ParcelOfTiedLand": "No" +"PropertyFeatures": array:5 [ 0 => "Greenbelt/Conservation" 1 => "Golf" 2 => "Park" 3 => "Ravine" 4 => "School" ] +"LotIrregularities": "End unit ravine lot" +"PossessionDetails": "60-89 days" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 5 +"WashroomsType3Pcs": 4 +"WashroomsType4Pcs": 3 +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 2 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"WashroomsType3Level": "Second" +"WashroomsType4Level": "Basement" +"MediaChangeTimestamp": "2026-02-24T19:21:06Z" +"SystemModificationTimestamp": "2026-02-24T19:21:11.63029Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:40 [ 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] ] } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4090 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12816154" +"ListingId": "X12816154" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-02-24T19:20:58Z" +"RFModificationTimestamp": "2026-02-24T19:27:34Z" +"ListPrice": 729900.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Russell" +"PostalCode": "K0A 1W0" +"UnparsedAddress": "149 Lyon Street, Russell, ON K0A 1W0" +"Coordinates": array:2 [ 0 => -75.2649329 1 => 45.2863196 ] +"Latitude": 45.2863196 +"Longitude": -75.2649329 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "EXIT REALTY MATRIX" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "OPEN HOUSE Sun Mar 1st, 11-1pm. Welcome to luxury living in one of Embrun's most sought-after, family-oriented communities - moments from parks, top-rated schools, scenic hiking trails, and endless recreation. This stunning residence blends timeless elegance with modern sophistication, offering a lifestyle defined by comfort and luxury. From the moment you step inside, you're greeted by an expansive open-concept design bathed in natural light. The living room creates an inviting yet elevated atmosphere, with a bright window filling the space in natural light. The lovely dining area, framed by patio doors, seamlessly connects indoor and outdoor living - perfect for hosting unforgettable gatherings. At the heart of the home lies a kitchen showcasing sleek appliances, abundant cabinetry, and a convenient sit-at island, this culinary space is both functional and beautiful. The main level is thoughtfully designed with a stylish powder room, convenient laundry, and direct access to the double-car garage. Upstairs, you'll find three beautifully appointed bedrooms and two bathrooms. The primary suite is complete with a spacious walk-in closet and an ensuite designed for relaxation. Step outside to your own private backyard retreat - fully fenced and perfect for enjoyment. Featuring a sparkling pool, storage shed, and abundant green space, this outdoor oasis is the ultimate setting for summer entertaining and peaceful evenings under the stars. An exceptional opportunity to own a truly dreamy home in the heart of Embrun." +"ArchitecturalStyle": array:1 [ 0 => "2-Storey" ] +"Basement": array:2 [ 0 => "Full" 1 => "Unfinished" ] +"CityRegion": "602 - Embrun" +"CoListOfficeName": "EXIT REALTY MATRIX" +"CoListOfficePhone": "613-443-4300" +"ConstructionMaterials": array:2 [ 0 => "Brick" 1 => "Vinyl Siding" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Prescott and Russell" +"CoveredSpaces": "2.0" +"CreationDate": "2026-02-24T18:41:32.401211+00:00" +"CrossStreet": "Lucerne and St Thomas Rd." +"DirectionFaces": "South" +"Directions": "From Notre Dame Embrun, turn onto St Thomas Rd, then turn left onto Lyon St." +"Exclusions": "Fridge in garage, pool heater, Washer, Dryer, work benches in shed and garage, all shelving." +"ExpirationDate": "2026-07-31" +"ExteriorFeatures": array:1 [ 0 => "Deck" ] +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"GarageYN": true +"Inclusions": "Fridge, Stove, Dishwasher, Garage Door Opener, Blinds/Window coverings, Pool" +"InteriorFeatures": array:5 [ 0 => "Air Exchanger" 1 => "Auto Garage Door Remote" 2 => "ERV/HRV" 3 => "Rough-In Bath" 4 => "Storage" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Ottawa Real Estate Board" +"ListingContractDate": "2026-02-24" +"LotSizeSource": "MPAC" +"MainOfficeKey": "488500" +"MajorChangeTimestamp": "2026-02-24T18:34:37Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-02-24T18:34:37Z" +"OriginalListPrice": 729900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3587278" +"OtherStructures": array:1 [ 0 => "Shed" ] +"ParcelNumber": "690121323" +"ParkingFeatures": array:1 [ 0 => "Available" ] +"ParkingTotal": "8.0" +"PhotosChangeTimestamp": "2026-02-24T18:34:38Z" +"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": "Lyon" +"StreetNumber": "149" +"StreetSuffix": "Street" +"TaxAnnualAmount": "5233.89" +"TaxLegalDescription": "LOT 44, PLAN 50M331 TOWNSHIP OF RUSSELL" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2%" +"TransactionType": "For Sale" +"View": array:1 [ 0 => "Pool" ] +"VirtualTourURLBranded": "https://listings.sellitmedia.ca/videos/019c7e6c-1047-70b4-b023-fac3ef4f2a73?v=114" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 110.9 +"LotWidth": 46.16 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12816154')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "030600000807936" +"SurveyType": "Available" +"RentalItems": "Hot water tank." +"HoldoverDays": 90 +"LaundryLevel": "Main Level" +"HeatTypeMulti": array:1 [ 0 => "Forced Air" ] +"KitchensTotal": 1 +"ParkingSpaces": 6 +"provider_name": "TRREB" +"ApproximateAge": "6-15" +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included In" ] +"PossessionDate": "2026-04-30" +"PossessionType": "30-59 days" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 2 +"HeatSourceMulti": array:1 [ 0 => "Gas" ] +"LivingAreaRange": "1500-2000" +"RoomsAboveGrade": 6 +"LotSizeAreaUnits": "Square Meters" +"PropertyFeatures": array:5 [ 0 => "Place Of Worship" 1 => "Rec./Commun.Centre" 2 => "School" 3 => "School Bus Route" 4 => "Fenced Yard" ] +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 4 +"BedroomsAboveGrade": 3 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Upper" +"MediaChangeTimestamp": "2026-02-24T18:34:38Z" +"SystemModificationTimestamp": "2026-02-24T19:21:05.571684Z" +"Media": array:38 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] …34 ] } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4088 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "W12768458" +"ListingId": "W12768458" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-02-24T19:20:54Z" +"RFModificationTimestamp": "2026-02-24T19:27:39Z" +"ListPrice": 879000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Brampton" +"PostalCode": "L7A 2W1" +"UnparsedAddress": "63 Tideland Drive, Brampton, ON L7A 2W1" +"Coordinates": array:2 [ …2] +"Latitude": 43.7005543 +"Longitude": -79.8271336 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ESTATE #1 REALTY SERVICES INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "S T U N N I N G , Immaculate Detach brick house Totally **RENOVATED **3 +1 bedroom in highly sought after area of Fletcher meadow , open concept and finished basement with washroom, loaded with upgrades of $75000 with 4 washroom ( 1on main floor , 2 on second fooor and 1 in basement ) and modern white kitchen with Potlights and stainless appliances , 4 car parking , hardwood on main floor , no carpet in house , oak stairs and list of upgrades is attached with schedule. Salient features *****3 +1 Bedroom Detach house ****4 washroom All renovated ***Modern white kitchen with S/S appliances****Renovated common washroom 2023 New washroom 2023 New standing shower in basement 2025 ****Brand new Quartz countertop in washrooms & Kitchen 2024 ****Gourmet kitchen with quartz couhtertop Renovated 2025 ****New washer Dryer 2023 ****New Ac ,furnace 2023 (owned ), interlocking front and back Too much to explain must be seen. !! ***Loaded with upgrades ***" +"ArchitecturalStyle": array:1 [ …1] +"AttachedGarageYN": true +"Basement": array:1 [ …1] +"CityRegion": "Fletcher's Meadow" +"CoListOfficeName": "ESTATE #1 REALTY SERVICES INC." +"CoListOfficePhone": "905-497-1676" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"CoolingYN": true +"Country": "CA" +"CountyOrParish": "Peel" +"CoveredSpaces": "1.0" +"CreationDate": "2026-02-23T00:55:37.489745+00:00" +"CrossStreet": "Sandalwood/Edenbrook Hills" +"DirectionFaces": "North" +"Directions": "NE" +"Exclusions": "None" +"ExpirationDate": "2026-08-29" +"FoundationDetails": array:2 [ …2] +"GarageYN": true +"HeatingYN": true +"Inclusions": "All existing appliances stove , fridge , Ac , dishwasher , Dryer and washer. **location ** Detach house ****4 washroom All renovated ***Modern white kitchen with S/S appliances****Renovated common washroom 2023 New washroom 2023 New standing shower in basement 2025 ****Brand new Quartz countertop in washrooms & Kitchen 2024 ****Gourmet kitchen with quartz couhtertop Renovated 2025 ****New washer Dryer 2023 ****New Ac ,furnace 2023 (owned ) virtual tour link attached !!" +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2026-02-07" +"LotDimensionsSource": "Other" +"LotSizeDimensions": "30.00 x 85.00 Feet" +"MainOfficeKey": "316000" +"MajorChangeTimestamp": "2026-02-07T09:45:38Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2026-02-07T09:45:38Z" +"OriginalListPrice": 879000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3521466" +"ParkingFeatures": array:1 [ …1] +"ParkingTotal": "3.0" +"PhotosChangeTimestamp": "2026-02-24T19:20:54Z" +"PoolFeatures": array:1 [ …1] +"Roof": array:1 [ …1] +"RoomsTotal": "7" +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Tideland" +"StreetNumber": "63" +"StreetSuffix": "Drive" +"TaxAnnualAmount": "4735.0" +"TaxLegalDescription": "Lot 122 Plan 43M1504, Brampton" +"TaxYear": "2026" +"TransactionBrokerCompensation": "2.5" +"TransactionType": "For Sale" +"Town": "Brampton" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 85.0 +"LotWidth": 30.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('W12768458')" +"PictureYN": true +"GarageType": "Attached" +"HeatSource": "Gas" +"SurveyType": "None" +"RentalItems": "Hot water tank ( Tankless )" +"HoldoverDays": 90 +"LaundryLevel": "Lower Level" +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 2 +"provider_name": "TRREB" +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Flexible" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"WashroomsType4": 1 +"DenFamilyroomYN": true +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "1100-1500" +"RoomsAboveGrade": 7 +"StreetSuffixCode": "Dr" +"BoardPropertyType": "Free" +"CoListOfficeName3": "ESTATE #1 REALTY SERVICES INC." +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 4 +"WashroomsType3Pcs": 2 +"WashroomsType4Pcs": 4 +"BedroomsAboveGrade": 3 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"MediaChangeTimestamp": "2026-02-24T19:20:54Z" +"MLSAreaDistrictOldZone": "W00" +"MLSAreaMunicipalityDistrict": "Brampton" +"SystemModificationTimestamp": "2026-02-24T19:21:04.047815Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:30 [ …30] } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4086 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12742528" +"ListingId": "X12742528" +"PropertyType": "Residential" +"PropertySubType": "Semi-Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-02-24T19:20:31Z" +"RFModificationTimestamp": "2026-02-24T19:27:36Z" +"ListPrice": 459900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Cornwall" +"PostalCode": "K6J 5V6" +"UnparsedAddress": "149 Heritage Place, Cornwall, ON K6J 5V6" +"Coordinates": array:2 [ …2] +"Latitude": 45.0435146 +"Longitude": -74.7510326 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "EXSELLENCE TEAM REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to 149 Heritage Place in Cornwall - a home where over 20 years of memories were made. From watching children grow up, to grandkids playing and even a marriage proposal, this home has been deeply loved and well cared for.T his 2+1 bedroom, 2 full bathroom semi-detached home with a garage offers a functional layout perfect for families or those looking to downsize without compromise. The living room was the heart of the home, ideal for gatherings and everyday life, while the spacious kitchen was designed for real family meals and connection. The finished lower level provides additional living space, great storage, and flexibility for a rec room, guest space, or home office. Outside, enjoy a covered patio area and a fully fenced yard, perfect for relaxing, entertaining, or letting kids and pets play safely. In a desirable area close to parks, schools, amenities, and just minutes to Tim Hortons, this home offers both comfort and convenience. At the Seller's request: 48 hours irrevocable on all offers." +"ArchitecturalStyle": array:1 [ …1] +"Basement": array:1 [ …1] +"CityRegion": "717 - Cornwall" +"ConstructionMaterials": array:1 [ …1] +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Stormont, Dundas and Glengarry" +"CoveredSpaces": "1.0" +"CreationDate": "2026-02-17T15:48:42.296132+00:00" +"CrossStreet": "Tollgate" +"DirectionFaces": "North" +"Directions": "Tollgate going West, turn left on Heritage" +"ExpirationDate": "2026-04-30" +"FoundationDetails": array:1 [ …1] +"GarageYN": true +"InteriorFeatures": array:1 [ …1] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Cornwall and District Real Estate Board" +"ListingContractDate": "2026-01-30" +"LotSizeSource": "MPAC" +"MainOfficeKey": "479600" +"MajorChangeTimestamp": "2026-02-17T15:32:56Z" +"MlsStatus": "Price Change" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2026-01-30T16:57:42Z" +"OriginalListPrice": 469900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3497544" +"ParcelNumber": "601970382" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2026-01-30T16:57:43Z" +"PoolFeatures": array:1 [ …1] +"PreviousListPrice": 469900.0 +"PriceChangeTimestamp": "2026-02-17T15:32:56Z" +"Roof": array:1 [ …1] +"Sewer": array:1 [ …1] +"ShowingRequirements": array:1 [ …1] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Heritage" +"StreetNumber": "149" +"StreetSuffix": "Place" +"TaxAnnualAmount": "4221.0" +"TaxLegalDescription": "PT LT 17 PL 392 PT 1 & 3 52R6481; S/T INTEREST IN S331721; S/T S225581; CORNWALL" +"TaxYear": "2026" +"TransactionBrokerCompensation": "2%" +"TransactionType": "For Sale" +"Zoning": "Residential" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 124.67 +"LotWidth": 36.38 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12742528')" +"GarageType": "Attached" +"HeatSource": "Gas" +"RollNumber": "040204000363982" +"SurveyType": "None" +"Waterfront": array:1 [ …1] +"HoldoverDays": 30 +"HeatTypeMulti": array:1 [ …1] +"KitchensTotal": 1 +"ParkingSpaces": 2 +"provider_name": "TRREB" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"HSTApplication": array:1 [ …1] +"PossessionType": "Immediate" +"PriorMlsStatus": "New" +"WashroomsType1": 1 +"WashroomsType2": 1 +"HeatSourceMulti": array:1 [ …1] +"LivingAreaRange": "700-1100" +"RoomsAboveGrade": 7 +"LotSizeAreaUnits": "Acres" +"PossessionDetails": "Immediate" +"WashroomsType1Pcs": 4 +"WashroomsType2Pcs": 3 +"BedroomsAboveGrade": 2 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ …1] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Lower" +"MediaChangeTimestamp": "2026-01-30T16:57:43Z" +"DevelopmentChargesPaid": array:1 [ …1] +"SystemModificationTimestamp": "2026-02-24T19:20:36.745229Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:24 [ …24] } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4068 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X12663162" +"ListingId": "X12663162" +"PropertyType": "Commercial Lease" +"PropertySubType": "Industrial" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-02-24T19:20:04Z" +"RFModificationTimestamp": "2026-02-24T19:27:39Z" +"ListPrice": 12.75 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 7500.0 +"City": "Beacon Hill North - South And Area" +"PostalCode": "K1J 9J5" +"UnparsedAddress": "5510 Canotek Road 8, Beacon Hill North - South And Area, ON K1J 9J5" +"Coordinates": array:2 [ …2] +"Latitude": 45.457352 +"Longitude": -75.58445 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "CDN GLOBAL (OTTAWA) LTD." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Ground floor industrial space. Conveniently located within the well known Canotek Industrial Park, 5510 Canotek offers convenient access to Highway 417 and other major arterials. Would be a great location for sports/activities or clubs looking for space. Four parking spaces included. Office cleaning and light bulb changes are not included. Taxes are estimated at $7.25 per SF for 2025, including basic heat and hydro." +"BuildingAreaUnits": "Square Feet" +"CityRegion": "2104 - Canotek Industrial Park" +"CoListOfficeName": "CDN GLOBAL (OTTAWA) LTD." +"CoListOfficePhone": "613-695-0440" +"Cooling": array:1 [ …1] +"Country": "CA" +"CountyOrParish": "Ottawa" +"CreationDate": "2026-02-20T03:15:34.011237+00:00" +"CrossStreet": "Canotek Road and Polytek Street" +"Directions": "Just off Highway 174 at Montreal Road exit. Located in the Canotek Business Park" +"ExpirationDate": "2026-06-30" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListAOR": "Ottawa Real Estate Board" +"ListingContractDate": "2026-01-05" +"LotSizeSource": "MPAC" +"MainOfficeKey": "483400" +"MajorChangeTimestamp": "2026-01-05T19:23:48Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2026-01-05T19:23:48Z" +"OriginalListPrice": 12.75 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft3397290" +"ParcelNumber": "043910887" +"PhotosChangeTimestamp": "2026-01-05T19:23:49Z" +"SecurityFeatures": array:1 [ …1] +"ShowingRequirements": array:2 [ …2] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Canotek" +"StreetNumber": "5510" +"StreetSuffix": "Road" +"TaxYear": "2025" +"TransactionBrokerCompensation": "2.5% of the net years 1-5, 1.25% of net years 6-10" +"TransactionType": "For Lease" +"UnitNumber": "8" +"Utilities": array:1 [ …1] +"Zoning": "IL2H(14)" +"Rail": "No" +"DDFYN": true +"Water": "Municipal" +"LotType": "Unit" +"TaxType": "N/A" +"HeatType": "Gas Forced Air Open" +"LotDepth": 425.03 +"LotWidth": 195.08 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12663162')" +"GarageType": "Other" +"RollNumber": "061460010022788" +"PropertyUse": "Multi-Unit" +"HoldoverDays": 90 +"HeatTypeMulti": array:1 [ …1] +"ListPriceUnit": "Per Sq Ft" +"provider_name": "TRREB" +"AssessmentYear": 2025 +"ContractStatus": "Available" +"IndustrialArea": 7500.0 +"PossessionDate": "2026-01-05" +"PossessionType": "Immediate" +"PriorMlsStatus": "Draft" +"WashroomsType1": 3 +"ClearHeightFeet": 26 +"LotSizeAreaUnits": "Acres" +"CoListOfficeName3": "CDN GLOBAL (OTTAWA) LTD." +"IndustrialAreaCode": "Sq Ft" +"ShowingAppointments": "All inquiries through Listing Agents. PLEASE DO NOT USE SHOWINGTIME." +"MediaChangeTimestamp": "2026-02-24T19:20:04Z" +"GradeLevelShippingDoors": 2 +"MaximumRentalMonthsTerm": 120 +"MinimumRentalTermMonths": 60 +"TruckLevelShippingDoors": 1 +"SystemModificationTimestamp": "2026-02-24T19:20:04.856571Z" +"VendorPropertyInfoStatement": true +"Media": array:7 [ …7] } ] +success: true +page_size: 5 +page_count: 11888 +count: 59440 +after_key: "" } ] ]