array:2 [
"RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=162&$filter=(StandardStatus eq 'Active')/Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=162&$filter=(StandardStatus eq 'Active')&$expand=Media/Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=162&$filter=(StandardStatus eq 'Active')/Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=162&$filter=(StandardStatus eq 'Active')&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#14244
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14078
+post_id: "611825"
+post_author: 1
+"ListingKey": "X12487213"
+"ListingId": "X12487213"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Townhouse"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-04T17:33:00Z"
+"RFModificationTimestamp": "2025-11-04T17:46:42Z"
+"ListPrice": 599900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2R 0R7"
+"UnparsedAddress": "15 Visionary Avenue, Kitchener, ON N2R 0R7"
+"Coordinates": array:2 [
0 => -80.4892629
1 => 43.3882373
]
+"Latitude": 43.3882373
+"Longitude": -80.4892629
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "HOMELIFE/MIRACLE REALTY LTD"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "!! Absolutely Gorgeous Townhome (1800 Sq. ft as per Builder floor Plan) Built by Activa Builder in 2021 comes with 2 Large Bedrooms ,3 Bathrooms plus Big recreation room at main level with separate entrance , Open Concept Main Floor, !! Spacious Great room & Overlooking Large Kitchen with plenty of Cabinet and Countertop Space. !! Decent Sized Bedrooms with big Windows & Walk in Closets, Primary Bedroom with En-Suite and Large Walk in Closet.!! Easy access to all amenities including Shops, Restaurants & Parks. Don't miss the opportunity to make this exceptional property your own."
+"ArchitecturalStyle": "3-Storey"
+"AssociationFee": "418.58"
+"AssociationFeeIncludes": array:1 [
0 => "Parking Included"
]
+"Basement": array:1 [
0 => "None"
]
+"ConstructionMaterials": array:2 [
0 => "Brick"
1 => "Vinyl Siding"
]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2025-10-29T13:29:39.012993+00:00"
+"CrossStreet": "Fischer Hallman & Seabrook"
+"Directions": "Fischer Hallman & Seabrook"
+"ExpirationDate": "2026-03-31"
+"GarageYN": true
+"Inclusions": "Fridge, Stove, Dishwasher , Washer, Dryer & Central A/C."
+"InteriorFeatures": "Water Heater"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [
0 => "Ensuite"
]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-10-29"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "406000"
+"MajorChangeTimestamp": "2025-10-29T13:16:55Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2025-10-29T13:16:55Z"
+"OriginalListPrice": 599900.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3188206"
+"ParcelNumber": "237310096"
+"ParkingFeatures": "Private"
+"ParkingTotal": "2.0"
+"PetsAllowed": array:1 [
0 => "Yes-with Restrictions"
]
+"PhotosChangeTimestamp": "2025-10-29T13:16:55Z"
+"ShowingRequirements": array:1 [
0 => "Lockbox"
]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Visionary"
+"StreetNumber": "15"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "4097.0"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2% -$50Mkt Fee + HST"
+"TransactionType": "For Sale"
+"VirtualTourURLUnbranded": "https://unbranded.mediatours.ca/property/15-visionary-avenue-kitchener/"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "East"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12487213')"
+"GarageType": "Built-In"
+"HeatSource": "Gas"
+"RollNumber": "301206001102838"
+"SurveyType": "None"
+"BalconyType": "Open"
+"RentalItems": "Hot water Tank & Water Softener"
+"HoldoverDays": 90
+"LegalStories": "1"
+"ParkingType1": "Owned"
+"KitchensTotal": 1
+"ParkingSpaces": 1
+"provider_name": "TRREB"
+"ApproximateAge": "0-5"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [
0 => "Included In"
]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 2
+"CondoCorpNumber": 731
+"LivingAreaRange": "1800-1999"
+"RoomsAboveGrade": 7
+"SquareFootSource": "Builder's Floor Plan"
+"PossessionDetails": "Flexible"
+"WashroomsType1Pcs": 2
+"WashroomsType2Pcs": 3
+"BedroomsAboveGrade": 2
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [
0 => "Unknown"
]
+"StatusCertificateYN": true
+"WashroomsType1Level": "Second"
+"WashroomsType2Level": "Third"
+"LegalApartmentNumber": "96"
+"MediaChangeTimestamp": "2025-10-29T13:16:55Z"
+"PropertyManagementCompany": "Wilson Blanchard"
+"SystemModificationTimestamp": "2025-11-04T17:33:00.226995Z"
+"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]
]
+"ID": "611825"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14241
+post_id: "611076"
+post_author: 1
+"ListingKey": "X12488090"
+"ListingId": "X12488090"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-04T17:32:58Z"
+"RFModificationTimestamp": "2025-11-04T17:46:42Z"
+"ListPrice": 419900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Cambridge"
+"PostalCode": "N3H 1T2"
+"UnparsedAddress": "233 Westminster Drive S 24, Cambridge, ON N3H 1T2"
+"Coordinates": array:2 [
0 => -80.359239
1 => 43.394804
]
+"Latitude": 43.394804
+"Longitude": -80.359239
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "Coldwell Banker Elevate Realty"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Fabulously renovated & updated 2 storey condo unit that is in a terrific part of town! Wouldn't it be great to hike to the Grand & Speed Rivers for a riverside coffee or take a quick stroll downtown to pop into your favourite restaurant or shop! The mature neighbourhood has a mix of housing styles which has attracted owners both young & old, a real community feel! All of this & more can be yours...what a lifestyle for a first time home buyer or a downsizer! This stunning unit is over 900 sf & has two generously sized bedrooms. This home has been extensively upgraded by the current Seller. An expansive eat-in kitchen with all the bells & whistles, quartz countertops, tons of storage, a pantry & a super functional, tastefully designed layout.....a cook's delight! The floors, interior doors, baseboards, runner on stairwell and window, as well as some newer pvc plumbing in the kitchen & bathroom have all been updated. On the Upper level the two large bedrooms share an upgraded 4 pc bath that won't disappoint. Updated cabinetry, Kohler tub/shower wall, Kohler toilet, upgraded Moen fixtures & 12x24 tiles...a clean, spa-like feel. Both the Primary bedroom & the 2nd bedroom have double closets with upgraded 4 panel doors, handles, upgraded baseboards & newer windows. The neutral colour throughout the condo gives a fresh open feel & the abundance of windows lets the lights stream in. This unit faces the front of the building & overlooks Westminster Dr, a vibrant community. The mutually shared driveway was just repaved in May 2025 & this unit has one surface parking spot. The Non-Smoking, pet-friendly (restrictions) bldg only houses 4 studio & 4-2 bedroom condos & is self managed. It has 2 guest parking spots & shares a common laundry area on the main level. Such a stunning condo in a quiet building that has everything you need within a short distance. Walk, ride your bike...enjoy the freedom, peace and tranquility of this little pocket of Cambridge!"
+"ArchitecturalStyle": "2-Storey"
+"AssociationFee": "500.0"
+"AssociationFeeIncludes": array:4 [
0 => "Heat Included"
1 => "Building Insurance Included"
2 => "Parking Included"
3 => "Water Included"
]
+"Basement": array:1 [
0 => "None"
]
+"ConstructionMaterials": array:2 [
0 => "Aluminum Siding"
1 => "Brick"
]
+"Cooling": "None"
+"CountyOrParish": "Waterloo"
+"CreationDate": "2025-10-29T23:45:24.837475+00:00"
+"CrossStreet": "King & Westminster"
+"Directions": "King & Westminster"
+"Exclusions": "N/A"
+"ExpirationDate": "2026-05-29"
+"ExteriorFeatures": "Landscaped"
+"Inclusions": "All Stainless Steel appliances in the kitchen, Upgraded ELF's, ceiling fan in Primary bdrm, window coverings and carpet on stairs. Some furnishings are for sale by owner... enquire if interested."
+"InteriorFeatures": "Carpet Free"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:4 [
0 => "In Hall"
1 => "Common Area"
2 => "Shared"
3 => "Coin Operated"
]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-10-29"
+"MainOfficeKey": "20009500"
+"MajorChangeTimestamp": "2025-10-29T20:38:50Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2025-10-29T20:38:50Z"
+"OriginalListPrice": 419900.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3188086"
+"ParcelNumber": "229110009"
+"ParkingFeatures": "Mutual,Surface"
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [
0 => "Yes-with Restrictions"
]
+"PhotosChangeTimestamp": "2025-10-29T20:38:50Z"
+"ShowingRequirements": array:2 [
0 => "Showing System"
1 => "List Brokerage"
]
+"SignOnPropertyYN": true
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "S"
+"StreetName": "Westminster"
+"StreetNumber": "233"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "1796.29"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2%"
+"TransactionType": "For Sale"
+"UnitNumber": "24"
+"VirtualTourURLBranded": "https://tour.shutterhouse.ca/24233westminsterdrivesouth"
+"VirtualTourURLUnbranded": "https://tour.shutterhouse.ca/24233westminsterdrivesouth?mls"
+"Zoning": "RM3"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "North"
+"HeatType": "Other"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12488090')"
+"GarageType": "None"
+"HeatSource": "Other"
+"RollNumber": "100016047090000"
+"SurveyType": "None"
+"BalconyType": "None"
+"HoldoverDays": 180
+"LegalStories": "2"
+"ParkingType1": "Exclusive"
+"KitchensTotal": 1
+"ParkingSpaces": 1
+"provider_name": "TRREB"
+"ApproximateAge": "51-99"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [
0 => "Included In"
]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"CondoCorpNumber": 11
+"LivingAreaRange": "900-999"
+"RoomsAboveGrade": 5
+"PropertyFeatures": array:6 [
0 => "Golf"
1 => "Greenbelt/Conservation"
2 => "Hospital"
3 => "Park"
4 => "Place Of Worship"
5 => "Public Transit"
]
+"SquareFootSource": "Owner"
+"PossessionDetails": "TBD"
+"WashroomsType1Pcs": 4
+"BedroomsAboveGrade": 2
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [
0 => "Unknown"
]
+"ShowingAppointments": "Through LA's office or Broker Bay with 1 hours notice"
+"WashroomsType1Level": "Second"
+"LegalApartmentNumber": "4"
+"MediaChangeTimestamp": "2025-10-29T20:40:46Z"
+"PropertyManagementCompany": "Waterloo South Condominium Corporation Plan No. 11"
+"SystemModificationTimestamp": "2025-11-04T17:32:58.162446Z"
+"Media": array:28 [
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]
]
+"ID": "611076"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14017
+post_id: "608757"
+post_author: 1
+"ListingKey": "X12485060"
+"ListingId": "X12485060"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-04T17:32:51Z"
+"RFModificationTimestamp": "2025-11-04T17:46:52Z"
+"ListPrice": 599000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.11
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J 1A7"
+"UnparsedAddress": "131 Roger Street, Waterloo, ON N2J 1A7"
+"Coordinates": array:2 [
0 => -80.5077767
1 => 43.4616396
]
+"Latitude": 43.4616396
+"Longitude": -80.5077767
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "TRILLIUMWEST REAL ESTATE"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to 131 Roger Street in Uptown Waterloo! This charming 3-bedroom, 1.5-bathroom home perfectly blends modern updates with classic character. Step inside to discover a beautifully renovated kitchen, featuring sleek cabinetry, stylish finishes, and plenty of natural light - ideal for home chefs and entertainers alike. The main level offers bright, inviting living spaces with timeless details and a comfortable flow. The basement has been recently renovated and perfect for gatherings or cozy nights in. Outside, enjoy a detached garage and private yard - perfect for summer evenings or weekend projects. Located just steps from Uptown waterloo, restaurants, the Spur line common trail and transit, this home offers the perfect balance of lifestyle and convenience in one of Waterloo's most desirable neighbourhoods. Updates- Furnace 2025, Singles 2024, basement 2025, Main floor/kitchen 2019"
+"ArchitecturalStyle": "1 1/2 Storey"
+"Basement": array:2 [
0 => "Partially Finished"
1 => "Full"
]
+"ConstructionMaterials": array:1 [
0 => "Concrete"
]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2025-10-28T12:20:15.967792+00:00"
+"CrossStreet": "Weber Street"
+"DirectionFaces": "South"
+"Directions": "Weber Street to Roger Street"
+"ExpirationDate": "2025-12-31"
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"GarageYN": true
+"InteriorFeatures": "Water Softener"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-10-28"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "244400"
+"MajorChangeTimestamp": "2025-10-28T12:16:21Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2025-10-28T12:16:21Z"
+"OriginalListPrice": 599000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3188040"
+"ParcelNumber": "223300021"
+"ParkingTotal": "5.0"
+"PhotosChangeTimestamp": "2025-10-28T12:16:21Z"
+"PoolFeatures": "None"
+"Roof": "Shingles"
+"Sewer": "Sewer"
+"ShowingRequirements": array:1 [
0 => "Showing System"
]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Roger"
+"StreetNumber": "131"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4602.0"
+"TaxLegalDescription": "LT 70 PL 196 CITY OF WATERLOO; WATERLOO"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2%+HST"
+"TransactionType": "For Sale"
+"VirtualTourURLBranded": "https://youriguide.com/131_roger_st_waterloo_on/"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/131_roger_st_waterloo_on/"
+"Zoning": "R1"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 121.0
+"LotWidth": 40.0
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12485060')"
+"GarageType": "Detached"
+"HeatSource": "Gas"
+"RollNumber": "301602135004100"
+"SurveyType": "Unknown"
+"RentalItems": "HWT"
+"KitchensTotal": 1
+"ParkingSpaces": 4
+"UnderContract": array:1 [
0 => "Hot Water Heater"
]
+"provider_name": "TRREB"
+"ApproximateAge": "51-99"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [
0 => "Included In"
]
+"PossessionDate": "2025-12-17"
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"DenFamilyroomYN": true
+"LivingAreaRange": "1100-1500"
+"RoomsAboveGrade": 7
+"PossessionDetails": "December 15th -18th Ideally"
+"WashroomsType1Pcs": 4
+"WashroomsType2Pcs": 2
+"BedroomsAboveGrade": 3
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [
0 => "Unknown"
]
+"MediaChangeTimestamp": "2025-10-28T12:16:21Z"
+"SystemModificationTimestamp": "2025-11-04T17:32:51.943294Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:38 [
0 => array:26 [ …26]
1 => array:26 [ …26]
2 => array:26 [ …26]
3 => array:26 [ …26]
4 => array:26 [ …26]
5 => array:26 [ …26]
6 => array:26 [ …26]
7 => array:26 [ …26]
8 => array:26 [ …26]
9 => array:26 [ …26]
10 => array:26 [ …26]
11 => array:26 [ …26]
12 => array:26 [ …26]
13 => array:26 [ …26]
14 => array:26 [ …26]
15 => array:26 [ …26]
16 => array:26 [ …26]
17 => array:26 [ …26]
18 => array:26 [ …26]
19 => array:26 [ …26]
20 => array:26 [ …26]
21 => array:26 [ …26]
22 => array:26 [ …26]
23 => array:26 [ …26]
24 => array:26 [ …26]
25 => array:26 [ …26]
26 => array:26 [ …26]
27 => array:26 [ …26]
28 => array:26 [ …26]
29 => array:26 [ …26]
30 => array:26 [ …26]
31 => array:26 [ …26]
32 => array:26 [ …26]
33 => array:26 [ …26]
34 => array:26 [ …26]
35 => array:26 [ …26]
36 => array:26 [ …26]
37 => array:26 [ …26]
]
+"ID": "608757"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14250
+post_id: "577987"
+post_author: 1
+"ListingKey": "X12447823"
+"ListingId": "X12447823"
+"PropertyType": "Residential"
+"PropertySubType": "Att/Row/Townhouse"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-04T17:32:50Z"
+"RFModificationTimestamp": "2025-11-04T17:46:52Z"
+"ListPrice": 639900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Minto"
+"PostalCode": "N0G 2P0"
+"UnparsedAddress": "182 Bridge Crescent 7, Minto, ON N0G 2P0"
+"Coordinates": array:2 [
0 => -66.0784986
1 => 46.0776889
]
+"Latitude": 46.0776889
+"Longitude": -66.0784986
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX Real Estate Centre Inc"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Live in luxury for less! You can own this beautiful fully legal 3+1 bdrm townhome with W/O bsmt apt & live in main unit for under $1,500/mth including utilities, insurance & taxes! With potential rental income from the lower suite covering up to $300,000 worth of mortgage payments, this is your chance to enjoy premium living without premium price tag. Perfect for couples or young professionals priced out of major urban markets, this move-in-ready home delivers modern design, quality & incredible value in one of Palmerston's most desirable communities. Built by Wright Haven Homes this home offers over 2300sqft of finished living space across 2 independent units. Main floor is bright & open W/wide plank vinyl flooring, oversized windows & calming neutral palette. Kitchen W/granite counters, soft-close cabinetry & S/S appliances with breakfast bar ideal for casual dining & entertaining. Separate dining room with W/O to private front balcony & living room that opens to a second rear balcony gives you 2 beautiful spaces to enjoy the outdoors. Upstairs are 3 bdrms including generous primary suite with W/I closet & ensuite W/glass-enclosed shower. A second full bath & upper-level laundry round out the space. Fully legal bsmt apt features its own entrance, kitchen W/granite counters & S/S appliances, laundry, 3pc bath & W/O to private patio-perfect for generating monthly rental income. Backing onto scenic trails & surrounded by quiet streets this location offers the best of small-town life W/access to big-city conveniences. Palmerston is a growing connected community where neighbours wave, shops & restaurants are around the corner & local employers like Palmerston Hospital & TG Minto support strong economic stability. With access to Listowel, Fergus, Guelph & KW commuting is easy but the value here is unmatched. If you're looking for modern living, rental income & room to grow without sacrificing style or location, this property might be the smartest move you'll ever make."
+"ArchitecturalStyle": "2-Storey"
+"Basement": array:2 [
0 => "Finished with Walk-Out"
1 => "Full"
]
+"CityRegion": "Minto"
+"CoListOfficeName": "RE/MAX Real Estate Centre Inc"
+"CoListOfficePhone": "519-836-6365"
+"ConstructionMaterials": array:2 [
0 => "Stone"
1 => "Brick"
]
+"Cooling": "Central Air"
+"Country": "CA"
+"CountyOrParish": "Wellington"
+"CoveredSpaces": "1.0"
+"CreationDate": "2025-10-06T19:38:25.908109+00:00"
+"CrossStreet": "Main St E"
+"DirectionFaces": "North"
+"Directions": "Main St E"
+"ExpirationDate": "2026-04-06"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"GarageYN": true
+"Inclusions": "Built-in Microwave, Dishwasher, Dryer, Refrigerator, Stove, Washer."
+"InteriorFeatures": "Accessory Apartment"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "One Point Association of REALTORS"
+"ListingContractDate": "2025-10-06"
+"MainOfficeKey": "559700"
+"MajorChangeTimestamp": "2025-11-04T17:32:50Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2025-10-06T19:31:45Z"
+"OriginalListPrice": 639900.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3098442"
+"ParcelNumber": "710420195"
+"ParkingFeatures": "Private"
+"ParkingTotal": "2.0"
+"PhotosChangeTimestamp": "2025-10-06T19:31:45Z"
+"PoolFeatures": "None"
+"Roof": "Asphalt Shingle"
+"Sewer": "Sewer"
+"ShowingRequirements": array:2 [
0 => "Lockbox"
1 => "Showing System"
]
+"SignOnPropertyYN": true
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Bridge"
+"StreetNumber": "182"
+"StreetSuffix": "Crescent"
+"TaxLegalDescription": "PART BLOCK 26, PLAN 61M222, PARTS 4 AND 12 61R22495 SUBJECT TO AN EASEMENT IN GROSS AS IN WC727777 SUBJECT TO AN EASEMENT IN GROSS OVER PART 12 61R22495 AS IN WC731840 SUBJECT TO AN EASEMENT OVER PART 12 PLAN 61R22495 AS IN WC742082 TOWN OF MINTO"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2 + HST"
+"TransactionType": "For Sale"
+"UnitNumber": "7"
+"VirtualTourURLBranded": "https://youtu.be/ug4y Ko UZ-TE"
+"Zoning": "R3"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Heat Pump"
+"LotDepth": 84.52
+"LotShape": "Rectangular"
+"LotWidth": 21.25
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12447823')"
+"GarageType": "Attached"
+"HeatSource": "Electric"
+"RollNumber": "234100001100258"
+"SurveyType": "Unknown"
+"RentalItems": "Hot Water Heater."
+"HoldoverDays": 90
+"KitchensTotal": 2
+"ParkingSpaces": 1
+"UnderContract": array:1 [
0 => "Hot Water Heater"
]
+"provider_name": "TRREB"
+"ApproximateAge": "New"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [
0 => "Included In"
]
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 2
+"LivingAreaRange": "1500-2000"
+"RoomsAboveGrade": 9
+"RoomsBelowGrade": 4
+"PropertyFeatures": array:6 [
0 => "Hospital"
1 => "Library"
2 => "Park"
3 => "Place Of Worship"
4 => "School"
5 => "Rec./Commun.Centre"
]
+"CoListOfficeName3": "RE/MAX Real Estate Centre Inc"
+"LotSizeRangeAcres": "< .50"
+"PossessionDetails": "Immediate"
+"WashroomsType1Pcs": 3
+"WashroomsType2Pcs": 2
+"WashroomsType3Pcs": 3
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"KitchensAboveGrade": 1
+"KitchensBelowGrade": 1
+"SpecialDesignation": array:1 [
0 => "Unknown"
]
+"ShowingAppointments": "519-836-6365 or Brokerbay"
+"WashroomsType1Level": "Basement"
+"WashroomsType2Level": "Second"
+"WashroomsType3Level": "Third"
+"MediaChangeTimestamp": "2025-10-06T19:31:45Z"
+"SystemModificationTimestamp": "2025-11-04T17:32:54.722904Z"
+"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]
]
+"ID": "577987"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14251
+post_id: "612864"
+post_author: 1
+"ListingKey": "X12491254"
+"ListingId": "X12491254"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-04T17:32:49Z"
+"RFModificationTimestamp": "2025-11-04T17:46:52Z"
+"ListPrice": 999000.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2R 0R2"
+"UnparsedAddress": "110 Haldimand Street, Kitchener, ON N2R 0R2"
+"Coordinates": array:2 [
0 => -80.4854752
1 => 43.377837
]
+"Latitude": 43.377837
+"Longitude": -80.4854752
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX TWIN CITY REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "This beautifully upgraded family home offers 3,555 sq. ft. of finished living space, including a bright basement with 9-foot ceilings. Designed for comfort and convenience, it blends high-end finishes, a functional layout, and timeless style in one of Kitchener's most desirable neighbourhoods. Here are the Top 6 Reasons this property could be the one for you: #6: PRIME LOCATION - Nestled in family-friendly Huron South, you're minutes to Highway 401, Sunrise Plaza, schools, trails, and everyday essentials. #5: IMPRESSIVE MAIN FLOOR - The open-concept layout features 9-foot ceilings and 5-inch red oak hardwood flooring, offering space for daily living and entertaining. #4: GOURMET KITCHEN - The designer kitchen boasts granite countertops, Listello ceramic tile, a walk-in pantry, and GE Café appliances including a built-in cooktop and oven. The large island with breakfast bar connects seamlessly to the dining area and private deck. #3: PRIVATE BACKYARD - The fully fenced yard offers room for kids, pets, or summer gatherings in a peaceful setting. #2: BEDROOMS & BATHS - Upstairs are 4 bright bedrooms. The primary suite includes a tray ceiling, walk-in closet, and 5-piece ensuite. One bedroom has its own 3-piece ensuite, while the others share a 4-piece bath. A versatile loft with high ceilings and balcony works as a games room, reading nook, or play area. Upper-level laundry adds convenience. #1: FINISHED BASEMENT - The lower level extends the living space with a sunlit rec room, an additional bedroom, and a 4-piece bath. With direct garage access, it's ideal for an in-law suite. With 3,555 sq. ft. of finished space, stylish upgrades, and a prime location, this move-in ready home is waiting for its next family."
+"ArchitecturalStyle": "2-Storey"
+"Basement": array:2 [
0 => "Full"
1 => "Finished"
]
+"ConstructionMaterials": array:2 [
0 => "Brick"
1 => "Vinyl Siding"
]
+"Cooling": "Central Air"
+"Country": "CA"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "2.0"
+"CreationDate": "2025-10-30T15:48:55.887317+00:00"
+"CrossStreet": "Grassbourne Avenue"
+"DirectionFaces": "South"
+"Directions": "Fischer Hallman to Broadacre Drive which turns into Haldimand Street"
+"ExpirationDate": "2026-02-21"
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"GarageYN": true
+"Inclusions": "Dishwasher, Dryer, Range Hood, Refrigerator, Smoke Detector, Stove, Washer, Window Coverings"
+"InteriorFeatures": "Water Heater,Water Softener,Sump Pump"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-10-28"
+"LotSizeSource": "Other"
+"MainOfficeKey": "360900"
+"MajorChangeTimestamp": "2025-10-30T15:41:40Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2025-10-30T15:41:40Z"
+"OriginalListPrice": 999000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3187936"
+"ParcelNumber": "227222669"
+"ParkingFeatures": "Private Double"
+"ParkingTotal": "4.0"
+"PhotosChangeTimestamp": "2025-10-30T15:41:40Z"
+"PoolFeatures": "None"
+"Roof": "Asphalt Shingle"
+"SecurityFeatures": array:2 [
0 => "Carbon Monoxide Detectors"
1 => "Smoke Detector"
]
+"Sewer": "Sewer"
+"ShowingRequirements": array:2 [
0 => "Lockbox"
1 => "Showing System"
]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Haldimand"
+"StreetNumber": "110"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "7391.0"
+"TaxLegalDescription": "LOT 3, PLAN 58M633 SUBJECT TO AN EASEMENT FOR ENTRY UNTIL 2040/01/09 AS IN WR1236325 SUBJECT TO AN EASEMENT IN FAVOUR OF LOT 4, PLAN 58M633 AS IN WR1245637 TOGETHER WITH AN EASEMENT OVER LOT 4, PLAN 58M633 AS IN WR1245638 SUBJECT TO AN EASEMENT FOR ENTRY AS IN WR1393679 CITY OF KITCHENER"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2.0% + HST"
+"TransactionType": "For Sale"
+"VirtualTourURLBranded": "https://youriguide.com/110_haldimand_st_kitchener_on/"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/110_haldimand_st_kitchener_on/"
+"Zoning": "RES 5"
+"DDFYN": true
+"Water": "Municipal"
+"GasYNA": "Yes"
+"CableYNA": "Available"
+"HeatType": "Forced Air"
+"LotDepth": 105.75
+"LotWidth": 36.15
+"SewerYNA": "Yes"
+"WaterYNA": "Yes"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12491254')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "301206001114303"
+"SurveyType": "None"
+"ElectricYNA": "Yes"
+"RentalItems": "Hot Water Heater"
+"HoldoverDays": 60
+"TelephoneYNA": "Available"
+"WaterMeterYN": true
+"KitchensTotal": 1
+"ParkingSpaces": 2
+"provider_name": "TRREB"
+"ApproximateAge": "0-5"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [
0 => "Included In"
]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"WashroomsType4": 1
+"WashroomsType5": 1
+"DenFamilyroomYN": true
+"LivingAreaRange": "2500-3000"
+"RoomsAboveGrade": 12
+"RoomsBelowGrade": 5
+"PropertyFeatures": array:4 [
0 => "Fenced Yard"
1 => "School Bus Route"
2 => "School"
3 => "Skiing"
]
+"PossessionDetails": "Flexible"
+"WashroomsType1Pcs": 2
+"WashroomsType2Pcs": 2
+"WashroomsType3Pcs": 4
+"WashroomsType4Pcs": 5
+"WashroomsType5Pcs": 4
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [
0 => "Unknown"
]
+"ShowingAppointments": "519-885-0200"
+"WashroomsType1Level": "Ground"
+"WashroomsType2Level": "Second"
+"WashroomsType3Level": "Third"
+"WashroomsType4Level": "Third"
+"WashroomsType5Level": "Basement"
+"MediaChangeTimestamp": "2025-10-31T17:20:24Z"
+"SystemModificationTimestamp": "2025-11-04T17:32:49.877393Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:48 [
0 => array:26 [ …26]
1 => array:26 [ …26]
2 => array:26 [ …26]
3 => array:26 [ …26]
4 => array:26 [ …26]
5 => array:26 [ …26]
6 => array:26 [ …26]
7 => array:26 [ …26]
8 => array:26 [ …26]
9 => array:26 [ …26]
10 => array:26 [ …26]
11 => array:26 [ …26]
12 => array:26 [ …26]
13 => array:26 [ …26]
14 => array:26 [ …26]
15 => array:26 [ …26]
16 => array:26 [ …26]
17 => array:26 [ …26]
18 => array:26 [ …26]
19 => array:26 [ …26]
20 => array:26 [ …26]
21 => array:26 [ …26]
22 => array:26 [ …26]
23 => array:26 [ …26]
24 => array:26 [ …26]
25 => array:26 [ …26]
26 => array:26 [ …26]
27 => array:26 [ …26]
28 => array:26 [ …26]
29 => array:26 [ …26]
30 => array:26 [ …26]
31 => array:26 [ …26]
32 => array:26 [ …26]
33 => array:26 [ …26]
34 => array:26 [ …26]
35 => array:26 [ …26]
36 => array:26 [ …26]
37 => array:26 [ …26]
38 => array:26 [ …26]
39 => array:26 [ …26]
40 => array:26 [ …26]
41 => array:26 [ …26]
42 => array:26 [ …26]
43 => array:26 [ …26]
44 => array:26 [ …26]
45 => array:26 [ …26]
46 => array:26 [ …26]
47 => array:26 [ …26]
]
+"ID": "612864"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14247
+post_id: "612409"
+post_author: 1
+"ListingKey": "X12486931"
+"ListingId": "X12486931"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-04T17:32:47Z"
+"RFModificationTimestamp": "2025-11-04T17:46:52Z"
+"ListPrice": 845000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T 2T4"
+"UnparsedAddress": "385 Havendale Crescent, Waterloo, ON N2T 2T4"
+"Coordinates": array:2 [
0 => -80.5827455
1 => 43.47067
]
+"Latitude": 43.47067
+"Longitude": -80.5827455
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RIGHT AT HOME REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Well maintained two storey-single detached 3-bedroom house in Laurelwood! Newly renovated kitchen with white quartz countertop and hardwood cabinets, along with stainless steel appliances (new fridge and dishwasher). Carpet free on the first floor with maple hardwood and floor tiles. Sliders from dinette to a large wooden deck. Spacious master bedroom with ensuite and bright windows. One bedroom with oak hardwood floor while the other two have newly installed vinyl plank flooring. 4-piece main bathroom on the second level with new quartz countertop. Lower level is finished with a cozy recreation room, which can be used for a home theatre, office, or guest space, plus laundry and more storage. The top-ranked Laurelwood Public School is just around the corner, offering an outstanding education for children. Walking distance to schools, shopping centres, YMCA, Waterloo Public Library, and Laurel Creek Conservation Area. On bus routes to universities (UW, WLU, Conestoga College). Central air conditioning, built-in dishwasher, stove, fridge, washer/dryer, and attached garage."
+"ArchitecturalStyle": "2-Storey"
+"Basement": array:1 [
0 => "Finished"
]
+"ConstructionMaterials": array:2 [
0 => "Brick"
1 => "Vinyl Siding"
]
+"Cooling": "Central Air"
+"Country": "CA"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2025-10-29T02:17:53.441710+00:00"
+"CrossStreet": "Laurelwood Dr & Beaver Creek Crescent"
+"DirectionFaces": "West"
+"Directions": "Go Direct"
+"ExpirationDate": "2026-04-26"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"GarageYN": true
+"InteriorFeatures": "Auto Garage Door Remote"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-10-28"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "062200"
+"MajorChangeTimestamp": "2025-10-29T01:56:49Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2025-10-29T01:56:49Z"
+"OriginalListPrice": 845000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3187818"
+"ParcelNumber": "226810927"
+"ParkingFeatures": "Private"
+"ParkingTotal": "2.0"
+"PhotosChangeTimestamp": "2025-10-29T01:56:49Z"
+"PoolFeatures": "None"
+"Roof": "Asphalt Shingle"
+"Sewer": "Sewer"
+"ShowingRequirements": array:1 [
0 => "Go Direct"
]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Havendale"
+"StreetNumber": "385"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "4530.0"
+"TaxLegalDescription": "PT BLK 2 PLAN 58M-47 BEING PTS 27 & 86 ON 58R-11405. S/T EASE #LT13490 IN FAVOUR OF THE CORPORATION OF THE CITY OF WATERLOO & UNION GAS LIMITED OVER PT 86 ON 58R-11405. S/T RIGHT OF ENTRY AS I N LT29894 UNTIL THE LATER OF (1) 5 YRS FROM JUNE 16, 1999 OR (2)THE ASSUMPTION OF SUBD. BY CITY OF WATERLOO. CITY OF WATERLOO"
+"TaxYear": "2024"
+"TransactionBrokerCompensation": "2%"
+"TransactionType": "For Sale"
+"Zoning": "SD"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 108.48
+"LotWidth": 30.22
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12486931')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "301604218010500"
+"SurveyType": "Available"
+"HoldoverDays": 90
+"LaundryLevel": "Lower Level"
+"KitchensTotal": 1
+"ParkingSpaces": 1
+"provider_name": "TRREB"
+"ApproximateAge": "16-30"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [
0 => "Not Subject to HST"
]
+"PossessionDate": "2025-10-28"
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"DenFamilyroomYN": true
+"LivingAreaRange": "1100-1500"
+"RoomsAboveGrade": 7
+"WashroomsType1Pcs": 3
+"WashroomsType2Pcs": 3
+"WashroomsType3Pcs": 2
+"BedroomsAboveGrade": 3
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [
0 => "Unknown"
]
+"WashroomsType1Level": "Second"
+"WashroomsType2Level": "Second"
+"WashroomsType3Level": "Ground"
+"ContactAfterExpiryYN": true
+"MediaChangeTimestamp": "2025-10-29T01:56:49Z"
+"SystemModificationTimestamp": "2025-11-04T17:32:47.793547Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:24 [
0 => array:26 [ …26]
1 => array:26 [ …26]
2 => array:26 [ …26]
3 => array:26 [ …26]
…20
]
+"ID": "612409"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14248
+post_id: "612865"
+post_author: 1
+"ListingKey": "X12484877"
+"ListingId": "X12484877"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-04T17:32:43Z"
+"RFModificationTimestamp": "2025-11-04T17:46:52Z"
+"ListPrice": 419900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2H 6R7"
+"UnparsedAddress": "20 Ellen Street 610, Kitchener, ON N2H 6R7"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.454945
+"Longitude": -80.4836217
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX ICON REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to The Renaissance, a highly sought-after building perfectly located across from Centre in the Square in Downtown Kitchener! This fantastic 2-bedroom, 2-bathroom corner unit is filled with natural light and offers an ideal blend of comfort and convenience. The oversized primary suite features a walk-in closet with in-suite laundry, and an updated ensuite bath, complete with built-in bench in the large shower. The updated kitchen boasts plenty of cabinetry, stainless steel appliances, and a cozy eat-in area framed by windows. You'll love the bonus coffee/wine bar tucked into the hallway with included mini fridge! A generous living and dining space with laminate floors and large windows creates a warm and inviting atmosphere. The second bedroom, full bathroom, handy utility/storage room and great entryway complete the space. Residents of The Renaissance enjoy lovely amenities, including a library, games room, party room, fitness centre, and sauna. Enjoy being just steps from downtown Kitchener's lively shops, restaurants, and cafés, with the Kitchener Public Library, the Kitchener Market, parks, trails, the theatre and public transit all close at hand. Ideal for those seeking affordable urban living, this condo is a fantastic choice for first-time buyers, downsizers, or investors alike. An opportunity not to be missed!"
+"ArchitecturalStyle": "1 Storey/Apt"
+"AssociationFee": "829.12"
+"AssociationFeeIncludes": array:5 [ …5]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2025-10-28T01:50:24.288100+00:00"
+"CrossStreet": "Mansion St"
+"Directions": "Queen St to Ellen St"
+"Exclusions": "None"
+"ExpirationDate": "2026-01-02"
+"FireplaceFeatures": array:1 [ …1]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"GarageYN": true
+"Inclusions": "Dishwasher, Dryer, Refrigerator, Stove, Washer, Window Coverings, R/O system, Water Softener, mini fridge"
+"InteriorFeatures": "Water Heater Owned,Water Purifier,Water Softener"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-10-24"
+"MainOfficeKey": "322400"
+"MajorChangeTimestamp": "2025-10-30T15:15:43Z"
+"MlsStatus": "Price Change"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2025-10-28T01:45:50Z"
+"OriginalListPrice": 429900.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3187634"
+"ParkingFeatures": "Underground,Reserved/Assigned"
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2025-10-28T01:45:50Z"
+"PreviousListPrice": 429900.0
+"PriceChangeTimestamp": "2025-10-30T15:15:43Z"
+"ShowingRequirements": array:3 [ …3]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "E"
+"StreetName": "Ellen"
+"StreetNumber": "20"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3133.88"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2% +HST"
+"TransactionType": "For Sale"
+"UnitNumber": "610"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/61020-ellen-st-e/idx"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "North"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12484877')"
+"GarageType": "Underground"
+"HeatSource": "Electric"
+"SurveyType": "None"
+"BalconyType": "None"
+"RentalItems": "None"
+"HoldoverDays": 10
+"LegalStories": "6"
+"ParkingSpot1": "66"
+"ParkingType1": "Exclusive"
+"KitchensTotal": 1
+"provider_name": "TRREB"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionDate": "2025-12-01"
+"PossessionType": "Flexible"
+"PriorMlsStatus": "New"
+"WashroomsType1": 1
+"WashroomsType2": 2
+"CondoCorpNumber": 106
+"LivingAreaRange": "1200-1399"
+"RoomsAboveGrade": 8
+"EnsuiteLaundryYN": true
+"SquareFootSource": "Plans"
+"PossessionDetails": "Immediate"
+"WashroomsType1Pcs": 3
+"WashroomsType2Pcs": 4
+"BedroomsAboveGrade": 2
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "Broker Bay"
+"StatusCertificateYN": true
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Main"
+"LegalApartmentNumber": "10"
+"MediaChangeTimestamp": "2025-10-28T02:09:00Z"
+"PropertyManagementCompany": "Millcreek Management"
+"SystemModificationTimestamp": "2025-11-04T17:32:43.629247Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:36 [ …36]
+"ID": "612865"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14242
+post_id: "617508"
+post_author: 1
+"ListingKey": "X12495836"
+"ListingId": "X12495836"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-04T17:32:39Z"
+"RFModificationTimestamp": "2025-11-04T17:46:52Z"
+"ListPrice": 2750.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Cambridge"
+"PostalCode": "N3C 1M3"
+"UnparsedAddress": "206 Winston Boulevard Main Level, Cambridge, ON N3C 1M3"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.3600536
+"Longitude": -80.3123023
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "SAVE MAX REAL ESTATE INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to this charming detached bungalow, perfectly located in one of Cambridge's most desirable neighborhoods!.Step inside to discover a brand-new kitchen featuring elegant quartz countertops, stylish cabinetry, and modern appliances - perfect for anyone who loves to cook and entertain. The home also boasts new flooring throughout, upgraded bathrooms, and a fresh, contemporary design that blends warmth with sophistication. Enjoy the convenience of a main floor laundry room with direct access to the attached garage - a thoughtful feature that adds comfort and practicality to your daily routine. Outside, you'll find a massive 200-foot-deep backyard, providing endless possibilities - whether you dream of creating a garden oasis, setting up a play area, or hosting summer barbecues with family and friends. Located close to all major amenities, including shopping centers, restaurants, public transit, and schools - this home offers the perfect balance of tranquility and accessibility. Additional Details: Main floor tenants responsible for 60% of utilities. Spacious driveway and attached garage. Modern upgrades throughout. Quiet, family-friendly community. Don't miss your chance to make this beautifully updated bungalow your next home!"
+"ArchitecturalStyle": "Bungalow"
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2025-11-02T09:32:02.926852+00:00"
+"CrossStreet": "Franklin Blvd and Holiday Inn Drive"
+"DirectionFaces": "South"
+"Directions": "Easily accessible from Franklin and Holiday Inn drive"
+"ExpirationDate": "2026-02-28"
+"FireplaceYN": true
+"FoundationDetails": array:1 [ …1]
+"Furnished": "Unfurnished"
+"GarageYN": true
+"InteriorFeatures": "Carpet Free"
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"LeaseTerm": "12 Months"
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-10-31"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "167900"
+"MajorChangeTimestamp": "2025-10-31T15:20:34Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2025-10-31T15:20:34Z"
+"OriginalListPrice": 2750.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3186950"
+"ParcelNumber": "037660184"
+"ParkingTotal": "3.0"
+"PhotosChangeTimestamp": "2025-10-31T15:20:34Z"
+"PoolFeatures": "None"
+"RentIncludes": array:1 [ …1]
+"Roof": "Asphalt Shingle"
+"Sewer": "Sewer"
+"ShowingRequirements": array:1 [ …1]
+"SignOnPropertyYN": true
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Winston"
+"StreetNumber": "206"
+"StreetSuffix": "Boulevard"
+"TransactionBrokerCompensation": "Half month plus HST"
+"TransactionType": "For Lease"
+"UnitNumber": "MAIN LEVEL"
+"DDFYN": true
+"Water": "Municipal"
+"LinkYN": true
+"HeatType": "Forced Air"
+"LotWidth": 66.0
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12495836')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "300614000613701"
+"SurveyType": "Unknown"
+"HoldoverDays": 30
+"CreditCheckYN": true
+"KitchensTotal": 1
+"ParkingSpaces": 2
+"provider_name": "TRREB"
+"ApproximateAge": "51-99"
+"ContractStatus": "Available"
+"PossessionDate": "2025-11-01"
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"DenFamilyroomYN": true
+"DepositRequired": true
+"LivingAreaRange": "700-1100"
+"RoomsAboveGrade": 5
+"LeaseAgreementYN": true
+"PaymentFrequency": "Monthly"
+"PossessionDetails": "Available Immediately"
+"PrivateEntranceYN": true
+"WashroomsType1Pcs": 3
+"BedroomsAboveGrade": 3
+"EmploymentLetterYN": true
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"RentalApplicationYN": true
+"WashroomsType1Level": "Main"
+"MediaChangeTimestamp": "2025-10-31T15:20:34Z"
+"PortionPropertyLease": array:1 [ …1]
+"ReferencesRequiredYN": true
+"SystemModificationTimestamp": "2025-11-04T17:32:39.492546Z"
+"Media": array:11 [ …11]
+"ID": "617508"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14243
+post_id: "609327"
+post_author: 1
+"ListingKey": "X12484718"
+"ListingId": "X12484718"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-04T17:32:37Z"
+"RFModificationTimestamp": "2025-11-04T17:46:52Z"
+"ListPrice": 3200.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J 1R1"
+"UnparsedAddress": "303 King Street N 6, Waterloo, ON N2J 1R1"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4783207
+"Longitude": -80.5257278
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "EXECUTIVE HOMES REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Spacious & Renovated 4-Bedroom Furnished Unit in Prime Waterloo. Location! Welcome to 303 King St N, Waterloo! This beautifully renovated and fully furnished 4-bedroom unit offers the perfect blend of comfort and convenience. Features: Fully furnished Move-in hassle-free! Spacious living area with modern finishes.Updated kitchen & bathroom for a sleek, contemporary feel. On-site coin laundry for easy access Parking and Hydro included. Unbeatable Location: Steps from shopping centers, grocery stores, and top-rated restaurants. Close to both universities (University of Waterloo & Wilfrid Laurier University). Excellent access to public transit for easy commuting. Perfect for students, young professionals, or anyone looking for a stylish and convenient home in Waterloo! Don't miss out on booking a viewing today!"
+"ArchitecturalStyle": "Apartment"
+"AssociationAmenities": array:1 [ …1]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": "Window Unit(s)"
+"Country": "CA"
+"CountyOrParish": "Waterloo"
+"CreationDate": "2025-10-27T22:53:32.446637+00:00"
+"CrossStreet": "King St N and Hickory St W"
+"Directions": "King St N and Hickory St W"
+"ExpirationDate": "2026-02-27"
+"Furnished": "Furnished"
+"Inclusions": "Building Insurance, Building Maintenance, Heat, Hydro, Parking, Snow Removal, Water, Water Heater"
+"InteriorFeatures": "Other"
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:2 [ …2]
+"LeaseTerm": "12 Months"
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-10-27"
+"MainOfficeKey": "358100"
+"MajorChangeTimestamp": "2025-10-27T22:46:14Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2025-10-27T22:46:14Z"
+"OriginalListPrice": 3200.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3186938"
+"ParkingFeatures": "Surface"
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2025-10-27T22:46:14Z"
+"RentIncludes": array:8 [ …8]
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "N"
+"StreetName": "King"
+"StreetNumber": "303"
+"StreetSuffix": "Street"
+"TransactionBrokerCompensation": "HALF MONTH RENT+HST"
+"TransactionType": "For Lease"
+"UnitNumber": "6"
+"View": array:1 [ …1]
+"DDFYN": true
+"Locker": "None"
+"Exposure": "East"
+"HeatType": "Baseboard"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12484718')"
+"GarageType": "None"
+"HeatSource": "Other"
+"SurveyType": "Unknown"
+"BalconyType": "None"
+"HoldoverDays": 90
+"LaundryLevel": "Lower Level"
+"LegalStories": "1"
+"ParkingType1": "Common"
+"KitchensTotal": 1
+"ParkingSpaces": 1
+"provider_name": "TRREB"
+"ApproximateAge": "51-99"
+"ContractStatus": "Available"
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"DenFamilyroomYN": true
+"LivingAreaRange": "1000-1199"
+"RoomsAboveGrade": 6
+"PropertyFeatures": array:2 [ …2]
+"SquareFootSource": "N/A"
+"PossessionDetails": "immediate"
+"PrivateEntranceYN": true
+"WashroomsType1Pcs": 3
+"BedroomsAboveGrade": 4
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Main"
+"LegalApartmentNumber": "6"
+"MediaChangeTimestamp": "2025-10-27T22:46:14Z"
+"PortionPropertyLease": array:1 [ …1]
+"PropertyManagementCompany": "Liwinco Urby Enterprise Inc"
+"SystemModificationTimestamp": "2025-11-04T17:32:37.42313Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:7 [ …7]
+"ID": "609327"
}
]
+success: true
+page_size: 9
+page_count: 10834
+count: 97500
+after_key: ""
}
"RF Response Time" => "0.33 seconds"
]
"RF Cache Key: fcddbd3a574151913683ad2e3f0d0ed4ee176e61febe66d82a19a7e9c67efd38" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#14290
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#15364
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12487213"
+"ListingId": "X12487213"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Townhouse"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-04T17:33:00Z"
+"RFModificationTimestamp": "2025-11-04T17:46:42Z"
+"ListPrice": 599900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2R 0R7"
+"UnparsedAddress": "15 Visionary Avenue, Kitchener, ON N2R 0R7"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.3882373
+"Longitude": -80.4892629
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "HOMELIFE/MIRACLE REALTY LTD"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "!! Absolutely Gorgeous Townhome (1800 Sq. ft as per Builder floor Plan) Built by Activa Builder in 2021 comes with 2 Large Bedrooms ,3 Bathrooms plus Big recreation room at main level with separate entrance , Open Concept Main Floor, !! Spacious Great room & Overlooking Large Kitchen with plenty of Cabinet and Countertop Space. !! Decent Sized Bedrooms with big Windows & Walk in Closets, Primary Bedroom with En-Suite and Large Walk in Closet.!! Easy access to all amenities including Shops, Restaurants & Parks. Don't miss the opportunity to make this exceptional property your own."
+"ArchitecturalStyle": array:1 [ …1]
+"AssociationFee": "418.58"
+"AssociationFeeIncludes": array:1 [ …1]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2025-10-29T13:29:39.012993+00:00"
+"CrossStreet": "Fischer Hallman & Seabrook"
+"Directions": "Fischer Hallman & Seabrook"
+"ExpirationDate": "2026-03-31"
+"GarageYN": true
+"Inclusions": "Fridge, Stove, Dishwasher , Washer, Dryer & Central A/C."
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-10-29"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "406000"
+"MajorChangeTimestamp": "2025-10-29T13:16:55Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2025-10-29T13:16:55Z"
+"OriginalListPrice": 599900.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3188206"
+"ParcelNumber": "237310096"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "2.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2025-10-29T13:16:55Z"
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Visionary"
+"StreetNumber": "15"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "4097.0"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2% -$50Mkt Fee + HST"
+"TransactionType": "For Sale"
+"VirtualTourURLUnbranded": "https://unbranded.mediatours.ca/property/15-visionary-avenue-kitchener/"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "East"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12487213')"
+"GarageType": "Built-In"
+"HeatSource": "Gas"
+"RollNumber": "301206001102838"
+"SurveyType": "None"
+"BalconyType": "Open"
+"RentalItems": "Hot water Tank & Water Softener"
+"HoldoverDays": 90
+"LegalStories": "1"
+"ParkingType1": "Owned"
+"KitchensTotal": 1
+"ParkingSpaces": 1
+"provider_name": "TRREB"
+"ApproximateAge": "0-5"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 2
+"CondoCorpNumber": 731
+"LivingAreaRange": "1800-1999"
+"RoomsAboveGrade": 7
+"SquareFootSource": "Builder's Floor Plan"
+"PossessionDetails": "Flexible"
+"WashroomsType1Pcs": 2
+"WashroomsType2Pcs": 3
+"BedroomsAboveGrade": 2
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"StatusCertificateYN": true
+"WashroomsType1Level": "Second"
+"WashroomsType2Level": "Third"
+"LegalApartmentNumber": "96"
+"MediaChangeTimestamp": "2025-10-29T13:16:55Z"
+"PropertyManagementCompany": "Wilson Blanchard"
+"SystemModificationTimestamp": "2025-11-04T17:33:00.226995Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:40 [ …40]
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#15363
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12488090"
+"ListingId": "X12488090"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-04T17:32:58Z"
+"RFModificationTimestamp": "2025-11-04T17:46:42Z"
+"ListPrice": 419900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Cambridge"
+"PostalCode": "N3H 1T2"
+"UnparsedAddress": "233 Westminster Drive S 24, Cambridge, ON N3H 1T2"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.394804
+"Longitude": -80.359239
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "Coldwell Banker Elevate Realty"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Fabulously renovated & updated 2 storey condo unit that is in a terrific part of town! Wouldn't it be great to hike to the Grand & Speed Rivers for a riverside coffee or take a quick stroll downtown to pop into your favourite restaurant or shop! The mature neighbourhood has a mix of housing styles which has attracted owners both young & old, a real community feel! All of this & more can be yours...what a lifestyle for a first time home buyer or a downsizer! This stunning unit is over 900 sf & has two generously sized bedrooms. This home has been extensively upgraded by the current Seller. An expansive eat-in kitchen with all the bells & whistles, quartz countertops, tons of storage, a pantry & a super functional, tastefully designed layout.....a cook's delight! The floors, interior doors, baseboards, runner on stairwell and window, as well as some newer pvc plumbing in the kitchen & bathroom have all been updated. On the Upper level the two large bedrooms share an upgraded 4 pc bath that won't disappoint. Updated cabinetry, Kohler tub/shower wall, Kohler toilet, upgraded Moen fixtures & 12x24 tiles...a clean, spa-like feel. Both the Primary bedroom & the 2nd bedroom have double closets with upgraded 4 panel doors, handles, upgraded baseboards & newer windows. The neutral colour throughout the condo gives a fresh open feel & the abundance of windows lets the lights stream in. This unit faces the front of the building & overlooks Westminster Dr, a vibrant community. The mutually shared driveway was just repaved in May 2025 & this unit has one surface parking spot. The Non-Smoking, pet-friendly (restrictions) bldg only houses 4 studio & 4-2 bedroom condos & is self managed. It has 2 guest parking spots & shares a common laundry area on the main level. Such a stunning condo in a quiet building that has everything you need within a short distance. Walk, ride your bike...enjoy the freedom, peace and tranquility of this little pocket of Cambridge!"
+"ArchitecturalStyle": array:1 [ …1]
+"AssociationFee": "500.0"
+"AssociationFeeIncludes": array:4 [ …4]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CreationDate": "2025-10-29T23:45:24.837475+00:00"
+"CrossStreet": "King & Westminster"
+"Directions": "King & Westminster"
+"Exclusions": "N/A"
+"ExpirationDate": "2026-05-29"
+"ExteriorFeatures": array:1 [ …1]
+"Inclusions": "All Stainless Steel appliances in the kitchen, Upgraded ELF's, ceiling fan in Primary bdrm, window coverings and carpet on stairs. Some furnishings are for sale by owner... enquire if interested."
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:4 [ …4]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-10-29"
+"MainOfficeKey": "20009500"
+"MajorChangeTimestamp": "2025-10-29T20:38:50Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2025-10-29T20:38:50Z"
+"OriginalListPrice": 419900.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3188086"
+"ParcelNumber": "229110009"
+"ParkingFeatures": array:2 [ …2]
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2025-10-29T20:38:50Z"
+"ShowingRequirements": array:2 [ …2]
+"SignOnPropertyYN": true
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "S"
+"StreetName": "Westminster"
+"StreetNumber": "233"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "1796.29"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2%"
+"TransactionType": "For Sale"
+"UnitNumber": "24"
+"VirtualTourURLBranded": "https://tour.shutterhouse.ca/24233westminsterdrivesouth"
+"VirtualTourURLUnbranded": "https://tour.shutterhouse.ca/24233westminsterdrivesouth?mls"
+"Zoning": "RM3"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "North"
+"HeatType": "Other"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12488090')"
+"GarageType": "None"
+"HeatSource": "Other"
+"RollNumber": "100016047090000"
+"SurveyType": "None"
+"BalconyType": "None"
+"HoldoverDays": 180
+"LegalStories": "2"
+"ParkingType1": "Exclusive"
+"KitchensTotal": 1
+"ParkingSpaces": 1
+"provider_name": "TRREB"
+"ApproximateAge": "51-99"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"CondoCorpNumber": 11
+"LivingAreaRange": "900-999"
+"RoomsAboveGrade": 5
+"PropertyFeatures": array:6 [ …6]
+"SquareFootSource": "Owner"
+"PossessionDetails": "TBD"
+"WashroomsType1Pcs": 4
+"BedroomsAboveGrade": 2
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "Through LA's office or Broker Bay with 1 hours notice"
+"WashroomsType1Level": "Second"
+"LegalApartmentNumber": "4"
+"MediaChangeTimestamp": "2025-10-29T20:40:46Z"
+"PropertyManagementCompany": "Waterloo South Condominium Corporation Plan No. 11"
+"SystemModificationTimestamp": "2025-11-04T17:32:58.162446Z"
+"Media": array:28 [ …28]
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#15362
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12485060"
+"ListingId": "X12485060"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-04T17:32:51Z"
+"RFModificationTimestamp": "2025-11-04T17:46:52Z"
+"ListPrice": 599000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.11
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J 1A7"
+"UnparsedAddress": "131 Roger Street, Waterloo, ON N2J 1A7"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4616396
+"Longitude": -80.5077767
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "TRILLIUMWEST REAL ESTATE"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to 131 Roger Street in Uptown Waterloo! This charming 3-bedroom, 1.5-bathroom home perfectly blends modern updates with classic character. Step inside to discover a beautifully renovated kitchen, featuring sleek cabinetry, stylish finishes, and plenty of natural light - ideal for home chefs and entertainers alike. The main level offers bright, inviting living spaces with timeless details and a comfortable flow. The basement has been recently renovated and perfect for gatherings or cozy nights in. Outside, enjoy a detached garage and private yard - perfect for summer evenings or weekend projects. Located just steps from Uptown waterloo, restaurants, the Spur line common trail and transit, this home offers the perfect balance of lifestyle and convenience in one of Waterloo's most desirable neighbourhoods. Updates- Furnace 2025, Singles 2024, basement 2025, Main floor/kitchen 2019"
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:2 [ …2]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2025-10-28T12:20:15.967792+00:00"
+"CrossStreet": "Weber Street"
+"DirectionFaces": "South"
+"Directions": "Weber Street to Roger Street"
+"ExpirationDate": "2025-12-31"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-10-28"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "244400"
+"MajorChangeTimestamp": "2025-10-28T12:16:21Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2025-10-28T12:16:21Z"
+"OriginalListPrice": 599000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3188040"
+"ParcelNumber": "223300021"
+"ParkingTotal": "5.0"
+"PhotosChangeTimestamp": "2025-10-28T12:16:21Z"
+"PoolFeatures": array:1 [ …1]
+"Roof": array:1 [ …1]
+"Sewer": array:1 [ …1]
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Roger"
+"StreetNumber": "131"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4602.0"
+"TaxLegalDescription": "LT 70 PL 196 CITY OF WATERLOO; WATERLOO"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2%+HST"
+"TransactionType": "For Sale"
+"VirtualTourURLBranded": "https://youriguide.com/131_roger_st_waterloo_on/"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/131_roger_st_waterloo_on/"
+"Zoning": "R1"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 121.0
+"LotWidth": 40.0
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12485060')"
+"GarageType": "Detached"
+"HeatSource": "Gas"
+"RollNumber": "301602135004100"
+"SurveyType": "Unknown"
+"RentalItems": "HWT"
+"KitchensTotal": 1
+"ParkingSpaces": 4
+"UnderContract": array:1 [ …1]
+"provider_name": "TRREB"
+"ApproximateAge": "51-99"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionDate": "2025-12-17"
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"DenFamilyroomYN": true
+"LivingAreaRange": "1100-1500"
+"RoomsAboveGrade": 7
+"PossessionDetails": "December 15th -18th Ideally"
+"WashroomsType1Pcs": 4
+"WashroomsType2Pcs": 2
+"BedroomsAboveGrade": 3
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"MediaChangeTimestamp": "2025-10-28T12:16:21Z"
+"SystemModificationTimestamp": "2025-11-04T17:32:51.943294Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:38 [ …38]
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#15361
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12447823"
+"ListingId": "X12447823"
+"PropertyType": "Residential"
+"PropertySubType": "Att/Row/Townhouse"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-04T17:32:50Z"
+"RFModificationTimestamp": "2025-11-04T17:46:52Z"
+"ListPrice": 639900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Minto"
+"PostalCode": "N0G 2P0"
+"UnparsedAddress": "182 Bridge Crescent 7, Minto, ON N0G 2P0"
+"Coordinates": array:2 [ …2]
+"Latitude": 46.0776889
+"Longitude": -66.0784986
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX Real Estate Centre Inc"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Live in luxury for less! You can own this beautiful fully legal 3+1 bdrm townhome with W/O bsmt apt & live in main unit for under $1,500/mth including utilities, insurance & taxes! With potential rental income from the lower suite covering up to $300,000 worth of mortgage payments, this is your chance to enjoy premium living without premium price tag. Perfect for couples or young professionals priced out of major urban markets, this move-in-ready home delivers modern design, quality & incredible value in one of Palmerston's most desirable communities. Built by Wright Haven Homes this home offers over 2300sqft of finished living space across 2 independent units. Main floor is bright & open W/wide plank vinyl flooring, oversized windows & calming neutral palette. Kitchen W/granite counters, soft-close cabinetry & S/S appliances with breakfast bar ideal for casual dining & entertaining. Separate dining room with W/O to private front balcony & living room that opens to a second rear balcony gives you 2 beautiful spaces to enjoy the outdoors. Upstairs are 3 bdrms including generous primary suite with W/I closet & ensuite W/glass-enclosed shower. A second full bath & upper-level laundry round out the space. Fully legal bsmt apt features its own entrance, kitchen W/granite counters & S/S appliances, laundry, 3pc bath & W/O to private patio-perfect for generating monthly rental income. Backing onto scenic trails & surrounded by quiet streets this location offers the best of small-town life W/access to big-city conveniences. Palmerston is a growing connected community where neighbours wave, shops & restaurants are around the corner & local employers like Palmerston Hospital & TG Minto support strong economic stability. With access to Listowel, Fergus, Guelph & KW commuting is easy but the value here is unmatched. If you're looking for modern living, rental income & room to grow without sacrificing style or location, this property might be the smartest move you'll ever make."
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:2 [ …2]
+"CityRegion": "Minto"
+"CoListOfficeName": "RE/MAX Real Estate Centre Inc"
+"CoListOfficePhone": "519-836-6365"
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"Country": "CA"
+"CountyOrParish": "Wellington"
+"CoveredSpaces": "1.0"
+"CreationDate": "2025-10-06T19:38:25.908109+00:00"
+"CrossStreet": "Main St E"
+"DirectionFaces": "North"
+"Directions": "Main St E"
+"ExpirationDate": "2026-04-06"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "Built-in Microwave, Dishwasher, Dryer, Refrigerator, Stove, Washer."
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "One Point Association of REALTORS"
+"ListingContractDate": "2025-10-06"
+"MainOfficeKey": "559700"
+"MajorChangeTimestamp": "2025-11-04T17:32:50Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2025-10-06T19:31:45Z"
+"OriginalListPrice": 639900.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3098442"
+"ParcelNumber": "710420195"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "2.0"
+"PhotosChangeTimestamp": "2025-10-06T19:31:45Z"
+"PoolFeatures": array:1 [ …1]
+"Roof": array:1 [ …1]
+"Sewer": array:1 [ …1]
+"ShowingRequirements": array:2 [ …2]
+"SignOnPropertyYN": true
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Bridge"
+"StreetNumber": "182"
+"StreetSuffix": "Crescent"
+"TaxLegalDescription": "PART BLOCK 26, PLAN 61M222, PARTS 4 AND 12 61R22495 SUBJECT TO AN EASEMENT IN GROSS AS IN WC727777 SUBJECT TO AN EASEMENT IN GROSS OVER PART 12 61R22495 AS IN WC731840 SUBJECT TO AN EASEMENT OVER PART 12 PLAN 61R22495 AS IN WC742082 TOWN OF MINTO"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2 + HST"
+"TransactionType": "For Sale"
+"UnitNumber": "7"
+"VirtualTourURLBranded": "https://youtu.be/ug4y Ko UZ-TE"
+"Zoning": "R3"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Heat Pump"
+"LotDepth": 84.52
+"LotShape": "Rectangular"
+"LotWidth": 21.25
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12447823')"
+"GarageType": "Attached"
+"HeatSource": "Electric"
+"RollNumber": "234100001100258"
+"SurveyType": "Unknown"
+"RentalItems": "Hot Water Heater."
+"HoldoverDays": 90
+"KitchensTotal": 2
+"ParkingSpaces": 1
+"UnderContract": array:1 [ …1]
+"provider_name": "TRREB"
+"ApproximateAge": "New"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 2
+"LivingAreaRange": "1500-2000"
+"RoomsAboveGrade": 9
+"RoomsBelowGrade": 4
+"PropertyFeatures": array:6 [ …6]
+"CoListOfficeName3": "RE/MAX Real Estate Centre Inc"
+"LotSizeRangeAcres": "< .50"
+"PossessionDetails": "Immediate"
+"WashroomsType1Pcs": 3
+"WashroomsType2Pcs": 2
+"WashroomsType3Pcs": 3
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"KitchensAboveGrade": 1
+"KitchensBelowGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "519-836-6365 or Brokerbay"
+"WashroomsType1Level": "Basement"
+"WashroomsType2Level": "Second"
+"WashroomsType3Level": "Third"
+"MediaChangeTimestamp": "2025-10-06T19:31:45Z"
+"SystemModificationTimestamp": "2025-11-04T17:32:54.722904Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:37 [ …37]
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#15360
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12491254"
+"ListingId": "X12491254"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-04T17:32:49Z"
+"RFModificationTimestamp": "2025-11-04T17:46:52Z"
+"ListPrice": 999000.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2R 0R2"
+"UnparsedAddress": "110 Haldimand Street, Kitchener, ON N2R 0R2"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.377837
+"Longitude": -80.4854752
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX TWIN CITY REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "This beautifully upgraded family home offers 3,555 sq. ft. of finished living space, including a bright basement with 9-foot ceilings. Designed for comfort and convenience, it blends high-end finishes, a functional layout, and timeless style in one of Kitchener's most desirable neighbourhoods. Here are the Top 6 Reasons this property could be the one for you: #6: PRIME LOCATION - Nestled in family-friendly Huron South, you're minutes to Highway 401, Sunrise Plaza, schools, trails, and everyday essentials. #5: IMPRESSIVE MAIN FLOOR - The open-concept layout features 9-foot ceilings and 5-inch red oak hardwood flooring, offering space for daily living and entertaining. #4: GOURMET KITCHEN - The designer kitchen boasts granite countertops, Listello ceramic tile, a walk-in pantry, and GE Café appliances including a built-in cooktop and oven. The large island with breakfast bar connects seamlessly to the dining area and private deck. #3: PRIVATE BACKYARD - The fully fenced yard offers room for kids, pets, or summer gatherings in a peaceful setting. #2: BEDROOMS & BATHS - Upstairs are 4 bright bedrooms. The primary suite includes a tray ceiling, walk-in closet, and 5-piece ensuite. One bedroom has its own 3-piece ensuite, while the others share a 4-piece bath. A versatile loft with high ceilings and balcony works as a games room, reading nook, or play area. Upper-level laundry adds convenience. #1: FINISHED BASEMENT - The lower level extends the living space with a sunlit rec room, an additional bedroom, and a 4-piece bath. With direct garage access, it's ideal for an in-law suite. With 3,555 sq. ft. of finished space, stylish upgrades, and a prime location, this move-in ready home is waiting for its next family."
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:2 [ …2]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"Country": "CA"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "2.0"
+"CreationDate": "2025-10-30T15:48:55.887317+00:00"
+"CrossStreet": "Grassbourne Avenue"
+"DirectionFaces": "South"
+"Directions": "Fischer Hallman to Broadacre Drive which turns into Haldimand Street"
+"ExpirationDate": "2026-02-21"
+"FireplaceYN": true
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "Dishwasher, Dryer, Range Hood, Refrigerator, Smoke Detector, Stove, Washer, Window Coverings"
+"InteriorFeatures": array:3 [ …3]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-10-28"
+"LotSizeSource": "Other"
+"MainOfficeKey": "360900"
+"MajorChangeTimestamp": "2025-10-30T15:41:40Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2025-10-30T15:41:40Z"
+"OriginalListPrice": 999000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3187936"
+"ParcelNumber": "227222669"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "4.0"
+"PhotosChangeTimestamp": "2025-10-30T15:41:40Z"
+"PoolFeatures": array:1 [ …1]
+"Roof": array:1 [ …1]
+"SecurityFeatures": array:2 [ …2]
+"Sewer": array:1 [ …1]
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Haldimand"
+"StreetNumber": "110"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "7391.0"
+"TaxLegalDescription": "LOT 3, PLAN 58M633 SUBJECT TO AN EASEMENT FOR ENTRY UNTIL 2040/01/09 AS IN WR1236325 SUBJECT TO AN EASEMENT IN FAVOUR OF LOT 4, PLAN 58M633 AS IN WR1245637 TOGETHER WITH AN EASEMENT OVER LOT 4, PLAN 58M633 AS IN WR1245638 SUBJECT TO AN EASEMENT FOR ENTRY AS IN WR1393679 CITY OF KITCHENER"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2.0% + HST"
+"TransactionType": "For Sale"
+"VirtualTourURLBranded": "https://youriguide.com/110_haldimand_st_kitchener_on/"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/110_haldimand_st_kitchener_on/"
+"Zoning": "RES 5"
+"DDFYN": true
+"Water": "Municipal"
+"GasYNA": "Yes"
+"CableYNA": "Available"
+"HeatType": "Forced Air"
+"LotDepth": 105.75
+"LotWidth": 36.15
+"SewerYNA": "Yes"
+"WaterYNA": "Yes"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12491254')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "301206001114303"
+"SurveyType": "None"
+"ElectricYNA": "Yes"
+"RentalItems": "Hot Water Heater"
+"HoldoverDays": 60
+"TelephoneYNA": "Available"
+"WaterMeterYN": true
+"KitchensTotal": 1
+"ParkingSpaces": 2
+"provider_name": "TRREB"
+"ApproximateAge": "0-5"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"WashroomsType4": 1
+"WashroomsType5": 1
+"DenFamilyroomYN": true
+"LivingAreaRange": "2500-3000"
+"RoomsAboveGrade": 12
+"RoomsBelowGrade": 5
+"PropertyFeatures": array:4 [ …4]
+"PossessionDetails": "Flexible"
+"WashroomsType1Pcs": 2
+"WashroomsType2Pcs": 2
+"WashroomsType3Pcs": 4
+"WashroomsType4Pcs": 5
+"WashroomsType5Pcs": 4
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "519-885-0200"
+"WashroomsType1Level": "Ground"
+"WashroomsType2Level": "Second"
+"WashroomsType3Level": "Third"
+"WashroomsType4Level": "Third"
+"WashroomsType5Level": "Basement"
+"MediaChangeTimestamp": "2025-10-31T17:20:24Z"
+"SystemModificationTimestamp": "2025-11-04T17:32:49.877393Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:48 [ …48]
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#15359
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12486931"
+"ListingId": "X12486931"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-04T17:32:47Z"
+"RFModificationTimestamp": "2025-11-04T17:46:52Z"
+"ListPrice": 845000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T 2T4"
+"UnparsedAddress": "385 Havendale Crescent, Waterloo, ON N2T 2T4"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.47067
+"Longitude": -80.5827455
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RIGHT AT HOME REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Well maintained two storey-single detached 3-bedroom house in Laurelwood! Newly renovated kitchen with white quartz countertop and hardwood cabinets, along with stainless steel appliances (new fridge and dishwasher). Carpet free on the first floor with maple hardwood and floor tiles. Sliders from dinette to a large wooden deck. Spacious master bedroom with ensuite and bright windows. One bedroom with oak hardwood floor while the other two have newly installed vinyl plank flooring. 4-piece main bathroom on the second level with new quartz countertop. Lower level is finished with a cozy recreation room, which can be used for a home theatre, office, or guest space, plus laundry and more storage. The top-ranked Laurelwood Public School is just around the corner, offering an outstanding education for children. Walking distance to schools, shopping centres, YMCA, Waterloo Public Library, and Laurel Creek Conservation Area. On bus routes to universities (UW, WLU, Conestoga College). Central air conditioning, built-in dishwasher, stove, fridge, washer/dryer, and attached garage."
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"Country": "CA"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2025-10-29T02:17:53.441710+00:00"
+"CrossStreet": "Laurelwood Dr & Beaver Creek Crescent"
+"DirectionFaces": "West"
+"Directions": "Go Direct"
+"ExpirationDate": "2026-04-26"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-10-28"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "062200"
+"MajorChangeTimestamp": "2025-10-29T01:56:49Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2025-10-29T01:56:49Z"
+"OriginalListPrice": 845000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3187818"
+"ParcelNumber": "226810927"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "2.0"
+"PhotosChangeTimestamp": "2025-10-29T01:56:49Z"
+"PoolFeatures": array:1 [ …1]
+"Roof": array:1 [ …1]
+"Sewer": array:1 [ …1]
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Havendale"
+"StreetNumber": "385"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "4530.0"
+"TaxLegalDescription": "PT BLK 2 PLAN 58M-47 BEING PTS 27 & 86 ON 58R-11405. S/T EASE #LT13490 IN FAVOUR OF THE CORPORATION OF THE CITY OF WATERLOO & UNION GAS LIMITED OVER PT 86 ON 58R-11405. S/T RIGHT OF ENTRY AS I N LT29894 UNTIL THE LATER OF (1) 5 YRS FROM JUNE 16, 1999 OR (2)THE ASSUMPTION OF SUBD. BY CITY OF WATERLOO. CITY OF WATERLOO"
+"TaxYear": "2024"
+"TransactionBrokerCompensation": "2%"
+"TransactionType": "For Sale"
+"Zoning": "SD"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 108.48
+"LotWidth": 30.22
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12486931')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "301604218010500"
+"SurveyType": "Available"
+"HoldoverDays": 90
+"LaundryLevel": "Lower Level"
+"KitchensTotal": 1
+"ParkingSpaces": 1
+"provider_name": "TRREB"
+"ApproximateAge": "16-30"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionDate": "2025-10-28"
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"DenFamilyroomYN": true
+"LivingAreaRange": "1100-1500"
+"RoomsAboveGrade": 7
+"WashroomsType1Pcs": 3
+"WashroomsType2Pcs": 3
+"WashroomsType3Pcs": 2
+"BedroomsAboveGrade": 3
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Second"
+"WashroomsType2Level": "Second"
+"WashroomsType3Level": "Ground"
+"ContactAfterExpiryYN": true
+"MediaChangeTimestamp": "2025-10-29T01:56:49Z"
+"SystemModificationTimestamp": "2025-11-04T17:32:47.793547Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:24 [ …24]
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#15358
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12484877"
+"ListingId": "X12484877"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-04T17:32:43Z"
+"RFModificationTimestamp": "2025-11-04T17:46:52Z"
+"ListPrice": 419900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2H 6R7"
+"UnparsedAddress": "20 Ellen Street 610, Kitchener, ON N2H 6R7"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.454945
+"Longitude": -80.4836217
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX ICON REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to The Renaissance, a highly sought-after building perfectly located across from Centre in the Square in Downtown Kitchener! This fantastic 2-bedroom, 2-bathroom corner unit is filled with natural light and offers an ideal blend of comfort and convenience. The oversized primary suite features a walk-in closet with in-suite laundry, and an updated ensuite bath, complete with built-in bench in the large shower. The updated kitchen boasts plenty of cabinetry, stainless steel appliances, and a cozy eat-in area framed by windows. You'll love the bonus coffee/wine bar tucked into the hallway with included mini fridge! A generous living and dining space with laminate floors and large windows creates a warm and inviting atmosphere. The second bedroom, full bathroom, handy utility/storage room and great entryway complete the space. Residents of The Renaissance enjoy lovely amenities, including a library, games room, party room, fitness centre, and sauna. Enjoy being just steps from downtown Kitchener's lively shops, restaurants, and cafés, with the Kitchener Public Library, the Kitchener Market, parks, trails, the theatre and public transit all close at hand. Ideal for those seeking affordable urban living, this condo is a fantastic choice for first-time buyers, downsizers, or investors alike. An opportunity not to be missed!"
+"ArchitecturalStyle": array:1 [ …1]
+"AssociationFee": "829.12"
+"AssociationFeeIncludes": array:5 [ …5]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2025-10-28T01:50:24.288100+00:00"
+"CrossStreet": "Mansion St"
+"Directions": "Queen St to Ellen St"
+"Exclusions": "None"
+"ExpirationDate": "2026-01-02"
+"FireplaceFeatures": array:1 [ …1]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"GarageYN": true
+"Inclusions": "Dishwasher, Dryer, Refrigerator, Stove, Washer, Window Coverings, R/O system, Water Softener, mini fridge"
+"InteriorFeatures": array:3 [ …3]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-10-24"
+"MainOfficeKey": "322400"
+"MajorChangeTimestamp": "2025-10-30T15:15:43Z"
+"MlsStatus": "Price Change"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2025-10-28T01:45:50Z"
+"OriginalListPrice": 429900.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3187634"
+"ParkingFeatures": array:2 [ …2]
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2025-10-28T01:45:50Z"
+"PreviousListPrice": 429900.0
+"PriceChangeTimestamp": "2025-10-30T15:15:43Z"
+"ShowingRequirements": array:3 [ …3]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "E"
+"StreetName": "Ellen"
+"StreetNumber": "20"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3133.88"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2% +HST"
+"TransactionType": "For Sale"
+"UnitNumber": "610"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/61020-ellen-st-e/idx"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "North"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12484877')"
+"GarageType": "Underground"
+"HeatSource": "Electric"
+"SurveyType": "None"
+"BalconyType": "None"
+"RentalItems": "None"
+"HoldoverDays": 10
+"LegalStories": "6"
+"ParkingSpot1": "66"
+"ParkingType1": "Exclusive"
+"KitchensTotal": 1
+"provider_name": "TRREB"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionDate": "2025-12-01"
+"PossessionType": "Flexible"
+"PriorMlsStatus": "New"
+"WashroomsType1": 1
+"WashroomsType2": 2
+"CondoCorpNumber": 106
+"LivingAreaRange": "1200-1399"
+"RoomsAboveGrade": 8
+"EnsuiteLaundryYN": true
+"SquareFootSource": "Plans"
+"PossessionDetails": "Immediate"
+"WashroomsType1Pcs": 3
+"WashroomsType2Pcs": 4
+"BedroomsAboveGrade": 2
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "Broker Bay"
+"StatusCertificateYN": true
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Main"
+"LegalApartmentNumber": "10"
+"MediaChangeTimestamp": "2025-10-28T02:09:00Z"
+"PropertyManagementCompany": "Millcreek Management"
+"SystemModificationTimestamp": "2025-11-04T17:32:43.629247Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:36 [ …36]
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#15357
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12495836"
+"ListingId": "X12495836"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-04T17:32:39Z"
+"RFModificationTimestamp": "2025-11-04T17:46:52Z"
+"ListPrice": 2750.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Cambridge"
+"PostalCode": "N3C 1M3"
+"UnparsedAddress": "206 Winston Boulevard Main Level, Cambridge, ON N3C 1M3"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.3600536
+"Longitude": -80.3123023
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "SAVE MAX REAL ESTATE INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to this charming detached bungalow, perfectly located in one of Cambridge's most desirable neighborhoods!.Step inside to discover a brand-new kitchen featuring elegant quartz countertops, stylish cabinetry, and modern appliances - perfect for anyone who loves to cook and entertain. The home also boasts new flooring throughout, upgraded bathrooms, and a fresh, contemporary design that blends warmth with sophistication. Enjoy the convenience of a main floor laundry room with direct access to the attached garage - a thoughtful feature that adds comfort and practicality to your daily routine. Outside, you'll find a massive 200-foot-deep backyard, providing endless possibilities - whether you dream of creating a garden oasis, setting up a play area, or hosting summer barbecues with family and friends. Located close to all major amenities, including shopping centers, restaurants, public transit, and schools - this home offers the perfect balance of tranquility and accessibility. Additional Details: Main floor tenants responsible for 60% of utilities. Spacious driveway and attached garage. Modern upgrades throughout. Quiet, family-friendly community. Don't miss your chance to make this beautifully updated bungalow your next home!"
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2025-11-02T09:32:02.926852+00:00"
+"CrossStreet": "Franklin Blvd and Holiday Inn Drive"
+"DirectionFaces": "South"
+"Directions": "Easily accessible from Franklin and Holiday Inn drive"
+"ExpirationDate": "2026-02-28"
+"FireplaceYN": true
+"FoundationDetails": array:1 [ …1]
+"Furnished": "Unfurnished"
+"GarageYN": true
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"LeaseTerm": "12 Months"
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-10-31"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "167900"
+"MajorChangeTimestamp": "2025-10-31T15:20:34Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2025-10-31T15:20:34Z"
+"OriginalListPrice": 2750.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3186950"
+"ParcelNumber": "037660184"
+"ParkingTotal": "3.0"
+"PhotosChangeTimestamp": "2025-10-31T15:20:34Z"
+"PoolFeatures": array:1 [ …1]
+"RentIncludes": array:1 [ …1]
+"Roof": array:1 [ …1]
+"Sewer": array:1 [ …1]
+"ShowingRequirements": array:1 [ …1]
+"SignOnPropertyYN": true
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Winston"
+"StreetNumber": "206"
+"StreetSuffix": "Boulevard"
+"TransactionBrokerCompensation": "Half month plus HST"
+"TransactionType": "For Lease"
+"UnitNumber": "MAIN LEVEL"
+"DDFYN": true
+"Water": "Municipal"
+"LinkYN": true
+"HeatType": "Forced Air"
+"LotWidth": 66.0
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12495836')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "300614000613701"
+"SurveyType": "Unknown"
+"HoldoverDays": 30
+"CreditCheckYN": true
+"KitchensTotal": 1
+"ParkingSpaces": 2
+"provider_name": "TRREB"
+"ApproximateAge": "51-99"
+"ContractStatus": "Available"
+"PossessionDate": "2025-11-01"
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"DenFamilyroomYN": true
+"DepositRequired": true
+"LivingAreaRange": "700-1100"
+"RoomsAboveGrade": 5
+"LeaseAgreementYN": true
+"PaymentFrequency": "Monthly"
+"PossessionDetails": "Available Immediately"
+"PrivateEntranceYN": true
+"WashroomsType1Pcs": 3
+"BedroomsAboveGrade": 3
+"EmploymentLetterYN": true
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"RentalApplicationYN": true
+"WashroomsType1Level": "Main"
+"MediaChangeTimestamp": "2025-10-31T15:20:34Z"
+"PortionPropertyLease": array:1 [ …1]
+"ReferencesRequiredYN": true
+"SystemModificationTimestamp": "2025-11-04T17:32:39.492546Z"
+"Media": array:11 [ …11]
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#15356
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12484718"
+"ListingId": "X12484718"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-04T17:32:37Z"
+"RFModificationTimestamp": "2025-11-04T17:46:52Z"
+"ListPrice": 3200.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J 1R1"
+"UnparsedAddress": "303 King Street N 6, Waterloo, ON N2J 1R1"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4783207
+"Longitude": -80.5257278
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "EXECUTIVE HOMES REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Spacious & Renovated 4-Bedroom Furnished Unit in Prime Waterloo. Location! Welcome to 303 King St N, Waterloo! This beautifully renovated and fully furnished 4-bedroom unit offers the perfect blend of comfort and convenience. Features: Fully furnished Move-in hassle-free! Spacious living area with modern finishes.Updated kitchen & bathroom for a sleek, contemporary feel. On-site coin laundry for easy access Parking and Hydro included. Unbeatable Location: Steps from shopping centers, grocery stores, and top-rated restaurants. Close to both universities (University of Waterloo & Wilfrid Laurier University). Excellent access to public transit for easy commuting. Perfect for students, young professionals, or anyone looking for a stylish and convenient home in Waterloo! Don't miss out on booking a viewing today!"
+"ArchitecturalStyle": array:1 [ …1]
+"AssociationAmenities": array:1 [ …1]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"Country": "CA"
+"CountyOrParish": "Waterloo"
+"CreationDate": "2025-10-27T22:53:32.446637+00:00"
+"CrossStreet": "King St N and Hickory St W"
+"Directions": "King St N and Hickory St W"
+"ExpirationDate": "2026-02-27"
+"Furnished": "Furnished"
+"Inclusions": "Building Insurance, Building Maintenance, Heat, Hydro, Parking, Snow Removal, Water, Water Heater"
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:2 [ …2]
+"LeaseTerm": "12 Months"
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-10-27"
+"MainOfficeKey": "358100"
+"MajorChangeTimestamp": "2025-10-27T22:46:14Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2025-10-27T22:46:14Z"
+"OriginalListPrice": 3200.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3186938"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2025-10-27T22:46:14Z"
+"RentIncludes": array:8 [ …8]
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "N"
+"StreetName": "King"
+"StreetNumber": "303"
+"StreetSuffix": "Street"
+"TransactionBrokerCompensation": "HALF MONTH RENT+HST"
+"TransactionType": "For Lease"
+"UnitNumber": "6"
+"View": array:1 [ …1]
+"DDFYN": true
+"Locker": "None"
+"Exposure": "East"
+"HeatType": "Baseboard"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12484718')"
+"GarageType": "None"
+"HeatSource": "Other"
+"SurveyType": "Unknown"
+"BalconyType": "None"
+"HoldoverDays": 90
+"LaundryLevel": "Lower Level"
+"LegalStories": "1"
+"ParkingType1": "Common"
+"KitchensTotal": 1
+"ParkingSpaces": 1
+"provider_name": "TRREB"
+"ApproximateAge": "51-99"
+"ContractStatus": "Available"
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"DenFamilyroomYN": true
+"LivingAreaRange": "1000-1199"
+"RoomsAboveGrade": 6
+"PropertyFeatures": array:2 [ …2]
+"SquareFootSource": "N/A"
+"PossessionDetails": "immediate"
+"PrivateEntranceYN": true
+"WashroomsType1Pcs": 3
+"BedroomsAboveGrade": 4
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Main"
+"LegalApartmentNumber": "6"
+"MediaChangeTimestamp": "2025-10-27T22:46:14Z"
+"PortionPropertyLease": array:1 [ …1]
+"PropertyManagementCompany": "Liwinco Urby Enterprise Inc"
+"SystemModificationTimestamp": "2025-11-04T17:32:37.42313Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:7 [ …7]
}
]
+success: true
+page_size: 9
+page_count: 10834
+count: 97500
+after_key: ""
}
]
]
