array:2 [
"RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=1440&$filter=(StandardStatus eq 'Active')/Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=1440&$filter=(StandardStatus eq 'Active')&$expand=Media/Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=1440&$filter=(StandardStatus eq 'Active')/Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=1440&$filter=(StandardStatus eq 'Active')&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#14271
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14276
+post_id: "618544"
+post_author: 1
+"ListingKey": "X12503514"
+"ListingId": "X12503514"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-11T03:52:32Z"
+"RFModificationTimestamp": "2025-11-11T03:57:29Z"
+"ListPrice": 579900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2C 1R2"
+"UnparsedAddress": "195 Sixth Avenue, Kitchener, ON N2C 1R2"
+"Coordinates": array:2 [
0 => -80.4528245
1 => 43.4289909
]
+"Latitude": 43.4289909
+"Longitude": -80.4528245
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "Howie Schmidt Realty Inc"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "All you have to do is place your furniture! You will LOVE this bright, open concept 1.5 story home! Spacious Livingroom, separate dining room with walk-out to the rear covered patio overlooking the 132' deep yard!! The upper level with Primary & second bedroom. The lower level is fully finished with gas F/p and a separate office area! Plenty of room for parking with access to build a garage/shop space!"
+"ArchitecturalStyle": "1 1/2 Storey"
+"Basement": array:1 [
0 => "Full"
]
+"ConstructionMaterials": array:2 [
0 => "Aluminum Siding"
1 => "Brick Veneer"
]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CreationDate": "2025-11-03T18:19:41.244949+00:00"
+"CrossStreet": "Kingsway"
+"DirectionFaces": "East"
+"Directions": "Kingsway Drive to Sixth Avenue, property on left"
+"ExpirationDate": "2026-02-03"
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Concrete Block"
]
+"Inclusions": "Central Vac, Dishwasher, Dryer, Microwave, Refrigerator, Stove, Washer, Negotiable"
+"InteriorFeatures": "Water Softener"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "One Point Association of REALTORS"
+"ListingContractDate": "2025-11-03"
+"MainOfficeKey": "578100"
+"MajorChangeTimestamp": "2025-11-03T17:45:16Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2025-11-03T17:45:16Z"
+"OriginalListPrice": 579900.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3214288"
+"OtherStructures": array:2 [
0 => "Fence - Full"
1 => "Garden Shed"
]
+"ParcelNumber": "225860076"
+"ParkingFeatures": "Private Double"
+"ParkingTotal": "4.0"
+"PhotosChangeTimestamp": "2025-11-03T17:45:16Z"
+"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": "Sixth"
+"StreetNumber": "195"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "3405.21"
+"TaxAssessedValue": 251000
+"TaxLegalDescription": "LT 7 PL 918 KITCHENER; KITCHENER"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2.0%+HST"
+"TransactionType": "For Sale"
+"VirtualTourURLBranded": "https://youriguide.com/195_sixth_ave_kitchener_on/"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/195_sixth_ave_kitchener_on/"
+"VirtualTourURLUnbranded2": "https://youriguide.com/195_sixth_ave_kitchener_on/doc/floorplan_imperial.pdf"
+"Zoning": "R2B"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 132.0
+"LotWidth": 50.0
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12503514')"
+"GarageType": "None"
+"HeatSource": "Gas"
+"RollNumber": "301204002415000"
+"SurveyType": "None"
+"RentalItems": "Hot Water Heater"
+"HoldoverDays": 120
+"LaundryLevel": "Lower Level"
+"WaterMeterYN": true
+"KitchensTotal": 1
+"ParkingSpaces": 4
+"provider_name": "TRREB"
+"ApproximateAge": "51-99"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [
0 => "Included In"
]
+"PossessionDate": "2025-10-31"
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"LivingAreaRange": "700-1100"
+"RoomsAboveGrade": 7
+"PropertyFeatures": array:3 [
0 => "Park"
1 => "Place Of Worship"
2 => "Public Transit"
]
+"PossessionDetails": "Immidiate"
+"WashroomsType1Pcs": 4
+"BedroomsAboveGrade": 2
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [
0 => "Unknown"
]
+"ShowingAppointments": "All Appts VIA Showingtime, Please watch for a 2nd email "Extra Info" incl. a Realtor listing & insts for Sentriconnect. NO ONE DAY CODES will be provided. Ensure listing notifications are turned on, this is the only format for listing updates"
+"WashroomsType1Level": "Ground"
+"MediaChangeTimestamp": "2025-11-03T17:45:16Z"
+"SystemModificationTimestamp": "2025-11-11T03:52:32.847674Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:47 [
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]
]
+"ID": "618544"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14275
+post_id: "618569"
+post_author: 1
+"ListingKey": "X12503398"
+"ListingId": "X12503398"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-11T03:52:20Z"
+"RFModificationTimestamp": "2025-11-11T03:57:29Z"
+"ListPrice": 750000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Cambridge"
+"PostalCode": "N3H 1J2"
+"UnparsedAddress": "401 Fountain Street S, Cambridge, ON N3H 1J2"
+"Coordinates": array:2 [
0 => -80.3679953
1 => 43.405575
]
+"Latitude": 43.405575
+"Longitude": -80.3679953
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX REAL ESTATE CENTRE INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Absolutely Fantastic! Top-to-bottom fully renovated, this stunning home offers the perfect blend of modern luxury and natural beauty, backing directly onto the Grand River. Every detail has been thoughtfully upgraded to deliver style, comfort, and peace of mind. Featuring new hardwood flooring (2024), an oak staircase, and polished porcelain tiles throughout the elegant kitchen with quartz countertops, matching backsplash, and premium stainless steel appliances. The formal dining room with a custom accent wall adds sophistication and charm. The main level boasts spacious bedroom Facing the Grand river with full washroom-->> Separate living and dinning area -->> 2nd Floor has 3 Bedrooms with access to Full WR -->>Finished attic provides extra living or office space.-->> New Windows -->> New entrance door (2024)-->> upgraded Roof shingles-->> A fully finished basement with vinyl floors and LED pot lights offers generous storage and functionality.--->> (New Furnace and Heat pump (2024)-->> New Electrical pannel upgraded in 2024-->>Set on a large lot with a beautiful deck overlooking the Grand River, this home defines tranquil living. Major updates include new electrical wiring and panel, new windows and doors, waterproofing, new drywalls (2024).Truly a showstopper-move-in ready and waiting for you to call it home!"
+"ArchitecturalStyle": "2-Storey"
+"Basement": array:2 [
0 => "Finished"
1 => "Separate Entrance"
]
+"ConstructionMaterials": array:1 [
0 => "Brick"
]
+"Cooling": "None"
+"CountyOrParish": "Waterloo"
+"CreationDate": "2025-11-07T20:33:15.811963+00:00"
+"CrossStreet": "Shantz Rd right onto Fountain"
+"DirectionFaces": "South"
+"Directions": "From front door"
+"Disclosures": array:1 [
0 => "Conservation Regulations"
]
+"ExpirationDate": "2026-02-28"
+"FoundationDetails": array:1 [
0 => "Other"
]
+"InteriorFeatures": "None"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-11-03"
+"MainOfficeKey": "079800"
+"MajorChangeTimestamp": "2025-11-03T17:32:23Z"
+"MlsStatus": "New"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2025-11-03T17:32:23Z"
+"OriginalListPrice": 750000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3214394"
+"ParkingFeatures": "Private"
+"ParkingTotal": "2.0"
+"PhotosChangeTimestamp": "2025-11-03T17:32:23Z"
+"PoolFeatures": "None"
+"Roof": "Asphalt Shingle"
+"Sewer": "Sewer"
+"ShowingRequirements": array:2 [
0 => "Go Direct"
1 => "Lockbox"
]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "S"
+"StreetName": "Fountain"
+"StreetNumber": "401"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3474.0"
+"TaxLegalDescription": "Lt 44 Pl 731 Cambridge"
+"TaxYear": "2024"
+"TransactionBrokerCompensation": "2.5"
+"TransactionType": "For Sale"
+"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=8g IK9ZA0Ukg"
+"WaterBodyName": "Grand River"
+"WaterfrontFeatures": "River Access"
+"WaterfrontYN": true
+"Zoning": "R3"
+"DDFYN": true
+"Water": "Municipal"
+"GasYNA": "Available"
+"Sewage": array:1 [
0 => "Municipal Available"
]
+"CableYNA": "Available"
+"HeatType": "Forced Air"
+"LotDepth": 186.0
+"LotWidth": 40.0
+"SewerYNA": "Available"
+"WaterYNA": "Available"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12503398')"
+"Shoreline": array:1 [
0 => "Unknown"
]
+"WaterView": array:1 [
0 => "Direct"
]
+"GarageType": "None"
+"HeatSource": "Gas"
+"RollNumber": "300610002407200"
+"SurveyType": "Unknown"
+"Waterfront": array:1 [
0 => "Direct"
]
+"DockingType": array:1 [
0 => "None"
]
+"ElectricYNA": "Available"
+"RentalItems": "hot water tank"
+"HoldoverDays": 90
+"LaundryLevel": "Lower Level"
+"TelephoneYNA": "Available"
+"KitchensTotal": 1
+"ParkingSpaces": 2
+"WaterBodyType": "River"
+"provider_name": "TRREB"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [
0 => "Included In"
]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"DenFamilyroomYN": true
+"LivingAreaRange": "1500-2000"
+"RoomsAboveGrade": 9
+"AccessToProperty": array:1 [
0 => "Other"
]
+"AlternativePower": array:1 [
0 => "None"
]
+"PossessionDetails": "Flex"
+"WashroomsType1Pcs": 4
+"WashroomsType2Pcs": 4
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"KitchensAboveGrade": 1
+"ShorelineAllowance": "None"
+"SpecialDesignation": array:1 [
0 => "Unknown"
]
+"WashroomsType1Level": "Second"
+"WashroomsType2Level": "Main"
+"WaterfrontAccessory": array:1 [
0 => "Not Applicable"
]
+"MediaChangeTimestamp": "2025-11-06T14:00:42Z"
+"SystemModificationTimestamp": "2025-11-11T03:52:20.790852Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:42 [
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]
]
+"ID": "618569"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14103
+post_id: "618545"
+post_author: 1
+"ListingKey": "X12503306"
+"ListingId": "X12503306"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-11T03:52:08Z"
+"RFModificationTimestamp": "2025-11-11T03:57:29Z"
+"ListPrice": 3000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Cambridge"
+"PostalCode": "N3H 1J2"
+"UnparsedAddress": "401 Fountain Street S, Cambridge, ON N3H 1J2"
+"Coordinates": array:2 [
0 => -80.3679953
1 => 43.405575
]
+"Latitude": 43.405575
+"Longitude": -80.3679953
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX REAL ESTATE CENTRE INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Absolutely Fantastic-->> Top to Bottom Fully Renovated -->>This fully renovated house invites you to experience the perfect blend of modern luxury and natural beauty-->> This home exudes contemporary charm while embracing the tranquil ambiance of its waterfront setting-->> Newly Upgraded Hardwood Flooring !!! Oak Stair case !!! Polished Porcelain tiles in the elegant kitchen, boasting flawless quartz countertops and high-end stainless steel appliances and Matching Quartz Backsplash!!! Formal Dinning room with accent wall -->> 3 Good size Bedrooms plus a Den on Main level -->> Finished Attic gives plenty of extra living space -->> Finished basement with vinyl floors and LED pot lights give Tons of Space of storage -->> Huge LOT with Gorgeous Deck in the backyard and Backing at Grand River!!! New wiring with new Electrical panel !!! New windows and Doors !!! Newly done water proofing !!! New drywalls !!! New Heat Pump !!! List Goes on and On -->> You Can Not miss this Stunning Property"
+"ArchitecturalStyle": "2 1/2 Storey"
+"Basement": array:1 [
0 => "Finished"
]
+"ConstructionMaterials": array:1 [
0 => "Brick"
]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CreationDate": "2025-11-08T03:52:18.771151+00:00"
+"CrossStreet": "Fountain st S/Shantz hill rd"
+"DirectionFaces": "North"
+"Directions": "From Front door"
+"Disclosures": array:1 [
0 => "Unknown"
]
+"ExpirationDate": "2026-02-28"
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Furnished": "Unfurnished"
+"InteriorFeatures": "Water Heater"
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [
0 => "In-Suite Laundry"
]
+"LeaseTerm": "12 Months"
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-11-03"
+"MainOfficeKey": "079800"
+"MajorChangeTimestamp": "2025-11-03T17:20:34Z"
+"MlsStatus": "New"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2025-11-03T17:20:34Z"
+"OriginalListPrice": 3000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3214264"
+"ParkingFeatures": "Private"
+"ParkingTotal": "2.0"
+"PhotosChangeTimestamp": "2025-11-03T17:20:34Z"
+"PoolFeatures": "None"
+"RentIncludes": array:1 [
0 => "Parking"
]
+"Roof": "Asphalt Shingle"
+"Sewer": "Sewer"
+"ShowingRequirements": array:2 [
0 => "Go Direct"
1 => "Lockbox"
]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "S"
+"StreetName": "Fountain"
+"StreetNumber": "401"
+"StreetSuffix": "Street"
+"TransactionBrokerCompensation": "half month rent"
+"TransactionType": "For Lease"
+"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=8g IK9ZA0Ukg"
+"WaterBodyName": "Grand River"
+"WaterfrontFeatures": "River Access"
+"WaterfrontYN": true
+"DDFYN": true
+"Water": "Municipal"
+"GasYNA": "Available"
+"CableYNA": "Available"
+"HeatType": "Forced Air"
+"SewerYNA": "Available"
+"WaterYNA": "Available"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12503306')"
+"Shoreline": array:1 [
0 => "Unknown"
]
+"WaterView": array:1 [
0 => "Direct"
]
+"GarageType": "None"
+"HeatSource": "Gas"
+"SurveyType": "Unknown"
+"Waterfront": array:1 [
0 => "Direct"
]
+"BuyOptionYN": true
+"DockingType": array:1 [
0 => "None"
]
+"ElectricYNA": "Available"
+"RentalItems": "hot water tank"
+"HoldoverDays": 90
+"TelephoneYNA": "Available"
+"CreditCheckYN": true
+"ParkingSpaces": 2
+"WaterBodyType": "River"
+"provider_name": "TRREB"
+"ContractStatus": "Available"
+"PossessionDate": "2025-12-01"
+"PossessionType": "1-29 days"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"DenFamilyroomYN": true
+"DepositRequired": true
+"LivingAreaRange": "1500-2000"
+"RoomsAboveGrade": 8
+"AccessToProperty": array:1 [
0 => "Public Road"
]
+"AlternativePower": array:1 [
0 => "None"
]
+"LeaseAgreementYN": true
+"PaymentFrequency": "Monthly"
+"PrivateEntranceYN": true
+"WashroomsType1Pcs": 3
+"WashroomsType2Pcs": 3
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"EmploymentLetterYN": true
+"ShorelineAllowance": "None"
+"SpecialDesignation": array:1 [
0 => "Unknown"
]
+"RentalApplicationYN": true
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Second"
+"WaterfrontAccessory": array:1 [
0 => "Not Applicable"
]
+"MediaChangeTimestamp": "2025-11-03T17:20:34Z"
+"PortionPropertyLease": array:1 [
0 => "Entire Property"
]
+"ReferencesRequiredYN": true
+"SystemModificationTimestamp": "2025-11-11T03:52:08.723587Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:33 [
0 => array:26 [ …26]
1 => array:26 [ …26]
2 => array:26 [ …26]
3 => array:26 [ …26]
4 => array:26 [ …26]
5 => array:26 [ …26]
6 => array:26 [ …26]
7 => array:26 [ …26]
8 => array:26 [ …26]
9 => array:26 [ …26]
10 => array:26 [ …26]
11 => array:26 [ …26]
12 => array:26 [ …26]
13 => array:26 [ …26]
14 => array:26 [ …26]
15 => array:26 [ …26]
16 => array:26 [ …26]
17 => array:26 [ …26]
18 => array:26 [ …26]
19 => array:26 [ …26]
20 => array:26 [ …26]
21 => array:26 [ …26]
22 => array:26 [ …26]
23 => array:26 [ …26]
24 => array:26 [ …26]
25 => array:26 [ …26]
26 => array:26 [ …26]
27 => array:26 [ …26]
28 => array:26 [ …26]
29 => array:26 [ …26]
30 => array:26 [ …26]
31 => array:26 [ …26]
32 => array:26 [ …26]
]
+"ID": "618545"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14267
+post_id: "618964"
+post_author: 1
+"ListingKey": "X12503298"
+"ListingId": "X12503298"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-11T03:52:02Z"
+"RFModificationTimestamp": "2025-11-11T03:57:29Z"
+"ListPrice": 1099000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2R 0S5"
+"UnparsedAddress": "43 Sugar Trail, Kitchener, ON N2R 0S5"
+"Coordinates": array:2 [
0 => -80.4844324
1 => 43.3772357
]
+"Latitude": 43.3772357
+"Longitude": -80.4844324
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "EXP REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to 43 Sugar Trail, Kitchener - a stunning "Rahi" model detached home offering the perfect blend of elegance, space, and functionality in one of Kitchener's most desirable neighbourhoods. This beautiful residence features 4 spacious bedrooms, 2.5 bathrooms, and approximately 2,350 sq. ft. of thoughtfully designed living space. The main floor showcases a bright open-concept layout with modern finishes, ideal for both everyday living and entertaining. Upstairs, generously sized bedrooms and well-appointed bathrooms provide ultimate comfort, while the full walk-out basement offers endless possibilities for future customization or additional living space. With a double car garage and a driveway for two extra vehicles, this home ensures ample parking and convenience. Priced at $1,099,000, this exquisite property is a perfect opportunity to own a luxurious family home in a prime Kitchener location close to parks, schools, and all amenities."
+"ArchitecturalStyle": "2-Storey"
+"Basement": array:2 [
0 => "Full"
1 => "Walk-Out"
]
+"ConstructionMaterials": array:2 [
0 => "Brick"
1 => "Vinyl Siding"
]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "2.0"
+"CreationDate": "2025-11-03T17:38:57.786788+00:00"
+"CrossStreet": "Broadacre To Sugar Trail"
+"DirectionFaces": "East"
+"Directions": "Broadacre To Sugar Trail"
+"ExpirationDate": "2026-02-03"
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"GarageYN": true
+"Inclusions": "Dishwasher, Dryer, Range Hood, Refrigerator, Stove, Washer"
+"InteriorFeatures": "Sump Pump"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-11-03"
+"MainOfficeKey": "285400"
+"MajorChangeTimestamp": "2025-11-03T17:19:21Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2025-11-03T17:19:21Z"
+"OriginalListPrice": 1099000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3210510"
+"ParcelNumber": "227223422"
+"ParkingFeatures": "Private Double"
+"ParkingTotal": "4.0"
+"PhotosChangeTimestamp": "2025-11-03T20:34:26Z"
+"PoolFeatures": "None"
+"Roof": "Asphalt Shingle"
+"Sewer": "Other"
+"ShowingRequirements": array:2 [
0 => "See Brokerage Remarks"
1 => "Showing System"
]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Sugar"
+"StreetNumber": "43"
+"StreetSuffix": "Trail"
+"TaxAnnualAmount": "6770.0"
+"TaxLegalDescription": "LOT 38, PLAN 58M682 SUBJECT TO AN EASEMENT FOR ENTRY AS IN WR1407240 CITY OF KITCHENER"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2.5%+HST"
+"TransactionType": "For Sale"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/43_sugar_trl_kitchener_on/"
+"Zoning": "Res-5 73 2R(M)"
+"DDFYN": true
+"Water": "Municipal"
+"LinkYN": true
+"HeatType": "Forced Air"
+"LotDepth": 104.99
+"LotWidth": 39.37
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12503298')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "301206001123748"
+"SurveyType": "Unknown"
+"HoldoverDays": 60
+"KitchensTotal": 1
+"ParkingSpaces": 2
+"provider_name": "TRREB"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [
0 => "Included In"
]
+"PossessionType": "1-29 days"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 2
+"DenFamilyroomYN": true
+"LivingAreaRange": "2000-2500"
+"RoomsAboveGrade": 11
+"PossessionDetails": "1 - 29 Days"
+"WashroomsType1Pcs": 2
+"WashroomsType2Pcs": 3
+"BedroomsAboveGrade": 4
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [
0 => "Unknown"
]
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Second"
+"MediaChangeTimestamp": "2025-11-03T20:34:26Z"
+"SystemModificationTimestamp": "2025-11-11T03:52:02.686335Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:47 [
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]
…5
]
+"ID": "618964"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14266
+post_id: "618571"
+post_author: 1
+"ListingKey": "X12503220"
+"ListingId": "X12503220"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-11T03:51:56Z"
+"RFModificationTimestamp": "2025-11-11T03:57:29Z"
+"ListPrice": 3100.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K 4G2"
+"UnparsedAddress": "543 Chesapeake Crescent, Waterloo, ON N2K 4G2"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.5119021
+"Longitude": -80.5160969
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "e Xp Realty"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Family Home in Coveted Eastbridge Neighbourhood! Tucked away at the end of a peaceful crescent, this home boasts an inviting open-concept layout featuring rich hardwood floors, ceramic tile, and plenty of natural light. The kitchen features sleek quartz countertops, a stylish backsplash, and stainless steel appliances. It opens seamlessly to the dining and living areas, creating the perfect space for entertaining. From the dinette, patio doors lead to a spacious deck overlooking a private, fully fenced backyard - with no rear neighbours and plenty of room to relax or host summer gatherings. Upstairs offers three generous bedrooms, including a bright primary suite with a full ensuite bath, as well as an additional full bathroom for family or guests. The lower level is fully finished and designed for comfort, featuring a large recreation area, a wet bar, and a stunning gas fireplace framed by a fieldstone mantel. Surrounded by trails, top-rated schools, RIM Park, St. Jacobs Market, and the LRT, this move-in-ready property delivers the perfect blend of privacy, style, and convenience."
+"ArchitecturalStyle": "2-Storey"
+"Basement": array:1 [ …1]
+"CoListOfficeName": "EXP REALTY"
+"CoListOfficePhone": "866-530-7737"
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.5"
+"CreationDate": "2025-11-03T17:37:55.004091+00:00"
+"CrossStreet": "Northfield Dr E and Bridge St W"
+"DirectionFaces": "East"
+"Directions": "Bridge St W to Chesapeake Dr to Chesapeake Cres"
+"Exclusions": "Tenants Responsible for Utilities"
+"ExpirationDate": "2026-01-28"
+"FireplaceFeatures": array:1 [ …1]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [ …1]
+"Furnished": "Unfurnished"
+"GarageYN": true
+"Inclusions": "Fridge, Stove, Washer, Dryer"
+"InteriorFeatures": "None"
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"LeaseTerm": "12 Months"
+"ListAOR": "One Point Association of REALTORS"
+"ListingContractDate": "2025-11-03"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "562100"
+"MajorChangeTimestamp": "2025-11-03T17:07:53Z"
+"MlsStatus": "New"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2025-11-03T17:07:53Z"
+"OriginalListPrice": 3100.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3213980"
+"ParcelNumber": "227071284"
+"ParkingFeatures": "Private"
+"ParkingTotal": "3.0"
+"PhotosChangeTimestamp": "2025-11-03T17:07:53Z"
+"PoolFeatures": "None"
+"RentIncludes": array:1 [ …1]
+"Roof": "Asphalt Shingle"
+"Sewer": "Sewer"
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Chesapeake"
+"StreetNumber": "543"
+"StreetSuffix": "Crescent"
+"TransactionBrokerCompensation": "1/2 Month Rent+HST"
+"TransactionType": "For Lease"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 111.0
+"LotWidth": 32.95
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12503220')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "301601077531900"
+"SurveyType": "None"
+"RentalItems": "Hot Water Heater"
+"HoldoverDays": 60
+"CreditCheckYN": true
+"KitchensTotal": 1
+"ParkingSpaces": 2
+"provider_name": "TRREB"
+"ContractStatus": "Available"
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"WashroomsType4": 1
+"DepositRequired": true
+"LivingAreaRange": "1500-2000"
+"RoomsAboveGrade": 5
+"RoomsBelowGrade": 1
+"LeaseAgreementYN": true
+"PossessionDetails": "Flexible"
+"PrivateEntranceYN": true
+"WashroomsType1Pcs": 2
+"WashroomsType2Pcs": 3
+"WashroomsType3Pcs": 4
+"WashroomsType4Pcs": 2
+"BedroomsAboveGrade": 3
+"EmploymentLetterYN": true
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"RentalApplicationYN": true
+"ShowingAppointments": "Please book showing via Brokerbay. If you need assistance please email [email protected]"
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Second"
+"WashroomsType3Level": "Second"
+"WashroomsType4Level": "Basement"
+"MediaChangeTimestamp": "2025-11-03T17:07:53Z"
+"PortionPropertyLease": array:1 [ …1]
+"ReferencesRequiredYN": true
+"SystemModificationTimestamp": "2025-11-11T03:51:56.660661Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:23 [ …23]
+"ID": "618571"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14042
+post_id: "618555"
+post_author: 1
+"ListingKey": "X12503142"
+"ListingId": "X12503142"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-11T03:51:50Z"
+"RFModificationTimestamp": "2025-11-11T03:57:29Z"
+"ListPrice": 1800.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Brantford"
+"PostalCode": "N3S 4J4"
+"UnparsedAddress": "415 Chatham Street Upper, Brantford, ON N3S 4J4"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.1408157
+"Longitude": -80.2631733
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "REVEL REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome home to 415 Chatham Street. This 2 bedroom, 1 bathroom, second-floor unit has been recently renovated and is ready for its next tenant. Equipped with newer appliances, in-suite laundry, your own separate entrance and a designated 2-car driveway. Enjoy a large shared backyard that's maintained for you. Water is included, and tenants are responsible for all other utilities. Conveniently located close to public transit, schools, parks, and shopping - what a great place to call home!"
+"ArchitecturalStyle": "2-Storey"
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": "None"
+"CountyOrParish": "Brantford"
+"CreationDate": "2025-11-08T03:52:10.683197+00:00"
+"CrossStreet": "Second Ave"
+"DirectionFaces": "South"
+"Directions": "Colborne St E to Second Ave to Chatham St"
+"ExpirationDate": "2026-05-03"
+"FoundationDetails": array:1 [ …1]
+"Furnished": "Unfurnished"
+"Inclusions": "Carbon Monoxide Detector, Dishwasher, Dryer, Refrigerator, Smoke Detector, Stove, Washer"
+"InteriorFeatures": "None"
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"LeaseTerm": "12 Months"
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-11-03"
+"LotSizeSource": "Geo Warehouse"
+"MainOfficeKey": "344700"
+"MajorChangeTimestamp": "2025-11-03T17:00:06Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2025-11-03T17:00:06Z"
+"OriginalListPrice": 1800.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3212214"
+"ParcelNumber": "321240088"
+"ParkingFeatures": "Private"
+"ParkingTotal": "2.0"
+"PhotosChangeTimestamp": "2025-11-03T17:00:06Z"
+"PoolFeatures": "None"
+"RentIncludes": array:2 [ …2]
+"Roof": "Asphalt Shingle"
+"SecurityFeatures": array:2 [ …2]
+"Sewer": "Sewer"
+"ShowingRequirements": array:2 [ …2]
+"SignOnPropertyYN": true
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Chatham"
+"StreetNumber": "415"
+"StreetSuffix": "Street"
+"Topography": array:1 [ …1]
+"TransactionBrokerCompensation": "1/2 months rent + HST"
+"TransactionType": "For Lease"
+"UnitNumber": "UPPER"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Other"
+"LotDepth": 126.0
+"LotWidth": 50.0
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12503142')"
+"GarageType": "None"
+"HeatSource": "Electric"
+"RollNumber": "290604001206100"
+"SurveyType": "Unknown"
+"HoldoverDays": 30
+"CreditCheckYN": true
+"KitchensTotal": 1
+"ParkingSpaces": 2
+"provider_name": "TRREB"
+"ApproximateAge": "51-99"
+"ContractStatus": "Available"
+"PossessionDate": "2026-01-01"
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"DepositRequired": true
+"LivingAreaRange": "1500-2000"
+"RoomsAboveGrade": 5
+"LeaseAgreementYN": true
+"PaymentFrequency": "Monthly"
+"PropertyFeatures": array:2 [ …2]
+"LotSizeRangeAcres": "< .50"
+"PossessionDetails": "Immediate"
+"PrivateEntranceYN": true
+"WashroomsType1Pcs": 4
+"BedroomsAboveGrade": 2
+"EmploymentLetterYN": true
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"RentalApplicationYN": true
+"ShowingAppointments": "PLEASE USE BROKERBAY TO BOOK APPOINTMENTS. If you do not have access to BROKERBAY, call office cell Monday to Friday 8am-5pm. Outside of those hours contact the LA directly at 226-583-4770."
+"WashroomsType1Level": "Second"
+"MediaChangeTimestamp": "2025-11-03T17:00:06Z"
+"PortionPropertyLease": array:1 [ …1]
+"ReferencesRequiredYN": true
+"SystemModificationTimestamp": "2025-11-11T03:51:50.626421Z"
+"Media": array:16 [ …16]
+"ID": "618555"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14272
+post_id: "618572"
+post_author: 1
+"ListingKey": "X12503118"
+"ListingId": "X12503118"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-11T03:51:44Z"
+"RFModificationTimestamp": "2025-11-11T03:57:29Z"
+"ListPrice": 850000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K 3J9"
+"UnparsedAddress": "298 Auburn Drive, Waterloo, ON N2K 3J9"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4927406
+"Longitude": -80.4940005
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "ENGEL & VOLKERS WATERLOO REGION"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to Your Dream Home in the Heart of Lexington - 298 Auburn Dr. Nestled in the highly sought-after, family-friendly Lexington neighbourhood, this impeccably maintained detached home offers the perfect blend of comfort, style, and convenience. Double-car garage and spacious double driveway provide ample parking and privacy. Step onto the charming covered front porch and into a warm, inviting foyer that opens to a bright, open-concept living and dining area - ideal for both everyday living and entertaining. The well-appointed kitchen features stainless steel appliances, abundant cabinetry, and a sunny breakfast area overlooking the Bomberger Woodlot - a stunning, 2.5-acre protected greenbelt with walking trails and beautiful natural scenery and exceptional privacy, a sense of connection to nature rarely found in the city. Step out onto the large deck and enjoy the serenity - perfect for relaxation, morning coffee, or hosting gatherings surrounded by greenery. The expansive family room, filled with natural light, offers a cozy retreat for family time or quiet evenings. The main floor is finished with elegant hardwood and vinyl tile flooring, and includes a powder room and convenient laundry area for added functionality. Upstairs, the primary suite is a true sanctuary, featuring double closets and a luxurious, upgraded 5-piece ensuite. Two additional spacious bedrooms share a beautifully appointed 4-piece bathroom, perfect for family or guests. Basement extends your living space with a large recreation room, ample storage, and a cold room, providing flexibility for hobbies, entertainment, or a home office. Ideally located within walking distance to Lexington and St. Matthew schools, parks, shopping, public transit, the library, and with easy access to major highways, this home offers the perfect combination of tranquility and accessibility."
+"ArchitecturalStyle": "2-Storey"
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "2.0"
+"CreationDate": "2025-11-07T21:18:01.212353+00:00"
+"CrossStreet": "UNIVERSITY AVE. E."
+"DirectionFaces": "West"
+"Directions": "UNIVERISTY AVE. E. TO AUBURN DR."
+"Exclusions": "TV in the living room and primary bedroom. Camera at the front door. Curtains in the primary bedroom."
+"ExpirationDate": "2026-01-05"
+"ExteriorFeatures": "Backs On Green Belt,Privacy,Deck"
+"FireplaceFeatures": array:1 [ …1]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "TV wall mounts in the living room and primary bedroom."
+"InteriorFeatures": "Auto Garage Door Remote,Sewage Pump,Storage"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-11-03"
+"LotSizeSource": "Geo Warehouse"
+"MainOfficeKey": "399200"
+"MajorChangeTimestamp": "2025-11-03T16:58:05Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2025-11-03T16:58:05Z"
+"OriginalListPrice": 850000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3213838"
+"ParcelNumber": "227200103"
+"ParkingFeatures": "Private Double"
+"ParkingTotal": "4.0"
+"PhotosChangeTimestamp": "2025-11-03T16:58:05Z"
+"PoolFeatures": "None"
+"Roof": "Asphalt Shingle"
+"Sewer": "Sewer"
+"ShowingRequirements": array:2 [ …2]
+"SignOnPropertyYN": true
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "AUBURN"
+"StreetNumber": "298"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "5626.0"
+"TaxAssessedValue": 412000
+"TaxLegalDescription": "LT 24 PL 1565 CITY OF WATERLOO; S/T 798608; WATERLOO"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2%+HST"
+"TransactionType": "For Sale"
+"View": array:3 [ …3]
+"VirtualTourURLBranded": "https://media.visualadvantage.ca/298-Auburn-Dr"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/298-Auburn-Dr/idx"
+"Zoning": "R1"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 114.0
+"LotWidth": 51.0
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12503118')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "301601016000162"
+"SurveyType": "None"
+"RentalItems": "Hot Water Heater, Water Purifier, Water Softener"
+"HoldoverDays": 30
+"LaundryLevel": "Main Level"
+"KitchensTotal": 1
+"ParkingSpaces": 2
+"UnderContract": array:3 [ …3]
+"provider_name": "TRREB"
+"ApproximateAge": "31-50"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"DenFamilyroomYN": true
+"LivingAreaRange": "1500-2000"
+"RoomsAboveGrade": 12
+"RoomsBelowGrade": 3
+"PropertyFeatures": array:5 [ …5]
+"LotSizeRangeAcres": "< .50"
+"PossessionDetails": "IMMEDIATE"
+"WashroomsType1Pcs": 2
+"WashroomsType2Pcs": 4
+"WashroomsType3Pcs": 5
+"BedroomsAboveGrade": 3
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "Please remove shoes, leave all lights on, leave business card, and lock doors."
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Second"
+"WashroomsType3Level": "Second"
+"MediaChangeTimestamp": "2025-11-03T16:58:05Z"
+"SystemModificationTimestamp": "2025-11-11T03:51:44.598021Z"
+"Media": array:47 [ …47]
+"ID": "618572"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14268
+post_id: "618573"
+post_author: 1
+"ListingKey": "X12503108"
+"ListingId": "X12503108"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-11T03:51:38Z"
+"RFModificationTimestamp": "2025-11-11T03:57:29Z"
+"ListPrice": 599900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Cambridge"
+"PostalCode": "N1S 2B4"
+"UnparsedAddress": "97 First Avenue, Cambridge, ON N1S 2B4"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.346088
+"Longitude": -80.3241623
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX REAL ESTATE CENTRE INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to this charming all-brick bungalow, perfectly situated on a fully fenced lot with mature trees, offering both privacy and a serene setting. The home exudes warmth and character from the moment you step inside, with gleaming hardwood floors throughout the main level, creating an inviting, cohesive living space. The bright, functional kitchen is designed for everyday living, featuring durable laminate countertops, convenient remote-controlled under-cabinet lighting, and high-quality Samsung stainless steel appliances, including a stove, refrigerator, and microwave with range hood-ideal for everything from quick meals to gourmet dinners. With four bedrooms-three on the main floor and one finished bedroom in the lower level-this home provides ample space for a growing family, guests, or a home office. The finished basement offers incredible versatility, featuring a cozy gas-burning fireplace, a wet bar with double sink, and a stylish 3-piece bathroom. This space is perfect for entertaining, creating a comfortable in-law suite, or designing a recreation area for family fun. Step outside to a lovely patio, seamlessly blending with the beautifully landscaped, treed backyard. Whether relaxing with morning coffee, hosting summer gatherings, or enjoying quiet evenings, this outdoor space provides charm and functionality. The fully fenced yard ensures privacy and safety, ideal for children, pets, or peace of mind. This meticulously maintained home balances comfort and practicality, offering a welcoming atmosphere, versatile living spaces, and a prime location. Combining classic design, modern amenities, and thoughtful upgrades throughout, it's an ideal place to create lasting memories, entertain effortlessly, and enjoy the tranquility of a well-established, treed setting. A truly inviting property that blends charm, function, and warmth in every corner."
+"ArchitecturalStyle": "Bungalow"
+"Basement": array:2 [ …2]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CreationDate": "2025-11-07T21:26:51.386330+00:00"
+"CrossStreet": "Glenmorris/Tait"
+"DirectionFaces": "West"
+"Directions": "TAIT ST. TO FIRST AVE"
+"Exclusions": "FREEZER IN BASEMENT, ALL BEDROOM CURTAINS."
+"ExpirationDate": "2026-01-31"
+"ExteriorFeatures": "Patio"
+"FireplaceFeatures": array:1 [ …1]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [ …1]
+"Inclusions": "Built-in Microwave, Dryer, Range Hood, Refrigerator, Stove, Washer, ALL CURTAIN RODS, GAZEBO WITH LIGHTS ON PATIO, BAR & BAR FRIDGE IN BASEMENT, 3 BAR STOOLS,"
+"InteriorFeatures": "In-Law Capability,Primary Bedroom - Main Floor"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-11-03"
+"MainOfficeKey": "079800"
+"MajorChangeTimestamp": "2025-11-03T16:57:34Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2025-11-03T16:57:34Z"
+"OriginalListPrice": 599900.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3213714"
+"ParcelNumber": "226680053"
+"ParkingFeatures": "Available,Tandem"
+"ParkingTotal": "4.0"
+"PhotosChangeTimestamp": "2025-11-03T16:57:34Z"
+"PoolFeatures": "None"
+"Roof": "Asphalt Shingle"
+"Sewer": "Sewer"
+"ShowingRequirements": array:1 [ …1]
+"SignOnPropertyYN": true
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "First"
+"StreetNumber": "97"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "3482.0"
+"TaxLegalDescription": "LT 66 PL 185 CAMBRIDGE; CAMBRIDGE"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2.5% + HST"
+"TransactionType": "For Sale"
+"VirtualTourURLBranded": "https://youriguide.com/97_1st_ave_cambridge_on/"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/97_1st_ave_cambridge_on/"
+"Zoning": "R5"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 115.0
+"LotWidth": 40.0
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12503108')"
+"GarageType": "None"
+"HeatSource": "Gas"
+"RollNumber": "300605006304103"
+"SurveyType": "Unknown"
+"RentalItems": "Hot Water Heater and Air Conditioner"
+"HoldoverDays": 60
+"LaundryLevel": "Lower Level"
+"KitchensTotal": 1
+"ParkingSpaces": 4
+"UnderContract": array:2 [ …2]
+"provider_name": "TRREB"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "30-59 days"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"DenFamilyroomYN": true
+"LivingAreaRange": "700-1100"
+"RoomsAboveGrade": 12
+"PropertyFeatures": array:6 [ …6]
+"PossessionDetails": "30-59 days"
+"WashroomsType1Pcs": 4
+"WashroomsType2Pcs": 3
+"BedroomsAboveGrade": 4
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "PLEASE BE COURTEOUS: MUST REMOVE SHOES, LEAVE LIGHTS AS YOU FOUND THEM, MUST ENSURE ALL DOORS FRONT, BACK AND SIDE ARE LOCKED. DO NOT USE BATHROOMS."
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Basement"
+"MediaChangeTimestamp": "2025-11-03T16:57:34Z"
+"SystemModificationTimestamp": "2025-11-11T03:51:38.56685Z"
+"Media": array:50 [ …50]
+"ID": "618573"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14269
+post_id: "619151"
+post_author: 1
+"ListingKey": "X12502838"
+"ListingId": "X12502838"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-11T03:51:26Z"
+"RFModificationTimestamp": "2025-11-11T03:57:29Z"
+"ListPrice": 1116900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2E 0C9"
+"UnparsedAddress": "200 Benninger Drive, Kitchener, ON N2E 0C9"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4073803
+"Longitude": -80.536844
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX REAL ESTATE CENTRE INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "***FINISHED BASEMENT INCLUDED*** Perfect for Multi-Generational Families. Welcome to the Foxdale Model, offering 2,280 sq. ft. of thoughtful design and upscale features. The Foxdale impresses with 9 ceilings and engineered hardwood floors on the main level, quartz countertops throughout the kitchen and baths, and an elegant quartz backsplash. Featuring four bedrooms, two primary en-suites, and a Jack and Jill bathroom, it's a true generational home. Additional highlights include soft-close kitchen cabinets, upper laundry cabinetry, a tiled ensuite shower with glass enclosure, central air conditioning, and a walkout basement with rough-in for future customization."
+"ArchitecturalStyle": "2-Storey"
+"Basement": array:2 [ …2]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": "Central Air"
+"Country": "CA"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "2.0"
+"CreationDate": "2025-11-08T03:53:08.337453+00:00"
+"CrossStreet": "Trussler"
+"DirectionFaces": "North"
+"Directions": "Nathalie"
+"ExpirationDate": "2026-01-29"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"InteriorFeatures": "Water Heater"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-11-03"
+"MainOfficeKey": "079800"
+"MajorChangeTimestamp": "2025-11-03T16:25:50Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2025-11-03T16:25:50Z"
+"OriginalListPrice": 1116900.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3162420"
+"ParcelNumber": "224671440"
+"ParkingFeatures": "Private Double"
+"ParkingTotal": "4.0"
+"PhotosChangeTimestamp": "2025-11-03T16:25:50Z"
+"PoolFeatures": "None"
+"Roof": "Asphalt Shingle"
+"Sewer": "Sewer"
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Benninger"
+"StreetNumber": "200"
+"StreetSuffix": "Drive"
+"TaxLegalDescription": "PART BLOCK 14, PLAN 58M643, PART 166 PLAN 58R21833"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2% of Base Price Net OF HST"
+"TransactionType": "For Sale"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 100.0
+"LotWidth": 32.0
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12502838')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"SurveyType": "Available"
+"HoldoverDays": 30
+"KitchensTotal": 1
+"ParkingSpaces": 2
+"provider_name": "TRREB"
+"ApproximateAge": "New"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionDate": "2026-04-30"
+"PossessionType": "Other"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"WashroomsType4": 1
+"LivingAreaRange": "2000-2500"
+"RoomsAboveGrade": 12
+"WashroomsType1Pcs": 2
+"WashroomsType2Pcs": 4
+"WashroomsType3Pcs": 4
+"WashroomsType4Pcs": 4
+"BedroomsAboveGrade": 4
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Second"
+"WashroomsType3Level": "Second"
+"WashroomsType4Level": "Second"
+"MediaChangeTimestamp": "2025-11-03T16:25:50Z"
+"SystemModificationTimestamp": "2025-11-11T03:51:26.493944Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:38 [ …38]
+"ID": "619151"
}
]
+success: true
+page_size: 9
+page_count: 7722
+count: 69491
+after_key: ""
}
"RF Response Time" => "0.5 seconds"
]
"RF Cache Key: 78362a9585d1ba7e00fe53757b82a891d464601acccaa8b95f5d3ad0ad6760e0" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#14344
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#15402
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12503514"
+"ListingId": "X12503514"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-11T03:52:32Z"
+"RFModificationTimestamp": "2025-11-11T03:57:29Z"
+"ListPrice": 579900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2C 1R2"
+"UnparsedAddress": "195 Sixth Avenue, Kitchener, ON N2C 1R2"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4289909
+"Longitude": -80.4528245
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "Howie Schmidt Realty Inc"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "All you have to do is place your furniture! You will LOVE this bright, open concept 1.5 story home! Spacious Livingroom, separate dining room with walk-out to the rear covered patio overlooking the 132' deep yard!! The upper level with Primary & second bedroom. The lower level is fully finished with gas F/p and a separate office area! Plenty of room for parking with access to build a garage/shop space!"
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CreationDate": "2025-11-03T18:19:41.244949+00:00"
+"CrossStreet": "Kingsway"
+"DirectionFaces": "East"
+"Directions": "Kingsway Drive to Sixth Avenue, property on left"
+"ExpirationDate": "2026-02-03"
+"FireplaceYN": true
+"FoundationDetails": array:1 [ …1]
+"Inclusions": "Central Vac, Dishwasher, Dryer, Microwave, Refrigerator, Stove, Washer, Negotiable"
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "One Point Association of REALTORS"
+"ListingContractDate": "2025-11-03"
+"MainOfficeKey": "578100"
+"MajorChangeTimestamp": "2025-11-03T17:45:16Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2025-11-03T17:45:16Z"
+"OriginalListPrice": 579900.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3214288"
+"OtherStructures": array:2 [ …2]
+"ParcelNumber": "225860076"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "4.0"
+"PhotosChangeTimestamp": "2025-11-03T17:45:16Z"
+"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": "Sixth"
+"StreetNumber": "195"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "3405.21"
+"TaxAssessedValue": 251000
+"TaxLegalDescription": "LT 7 PL 918 KITCHENER; KITCHENER"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2.0%+HST"
+"TransactionType": "For Sale"
+"VirtualTourURLBranded": "https://youriguide.com/195_sixth_ave_kitchener_on/"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/195_sixth_ave_kitchener_on/"
+"VirtualTourURLUnbranded2": "https://youriguide.com/195_sixth_ave_kitchener_on/doc/floorplan_imperial.pdf"
+"Zoning": "R2B"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 132.0
+"LotWidth": 50.0
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12503514')"
+"GarageType": "None"
+"HeatSource": "Gas"
+"RollNumber": "301204002415000"
+"SurveyType": "None"
+"RentalItems": "Hot Water Heater"
+"HoldoverDays": 120
+"LaundryLevel": "Lower Level"
+"WaterMeterYN": true
+"KitchensTotal": 1
+"ParkingSpaces": 4
+"provider_name": "TRREB"
+"ApproximateAge": "51-99"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionDate": "2025-10-31"
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"LivingAreaRange": "700-1100"
+"RoomsAboveGrade": 7
+"PropertyFeatures": array:3 [ …3]
+"PossessionDetails": "Immidiate"
+"WashroomsType1Pcs": 4
+"BedroomsAboveGrade": 2
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "All Appts VIA Showingtime, Please watch for a 2nd email "Extra Info" incl. a Realtor listing & insts for Sentriconnect. NO ONE DAY CODES will be provided. Ensure listing notifications are turned on, this is the only format for listing updates"
+"WashroomsType1Level": "Ground"
+"MediaChangeTimestamp": "2025-11-03T17:45:16Z"
+"SystemModificationTimestamp": "2025-11-11T03:52:32.847674Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:47 [ …47]
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#15401
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12503398"
+"ListingId": "X12503398"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-11T03:52:20Z"
+"RFModificationTimestamp": "2025-11-11T03:57:29Z"
+"ListPrice": 750000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Cambridge"
+"PostalCode": "N3H 1J2"
+"UnparsedAddress": "401 Fountain Street S, Cambridge, ON N3H 1J2"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.405575
+"Longitude": -80.3679953
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX REAL ESTATE CENTRE INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Absolutely Fantastic! Top-to-bottom fully renovated, this stunning home offers the perfect blend of modern luxury and natural beauty, backing directly onto the Grand River. Every detail has been thoughtfully upgraded to deliver style, comfort, and peace of mind. Featuring new hardwood flooring (2024), an oak staircase, and polished porcelain tiles throughout the elegant kitchen with quartz countertops, matching backsplash, and premium stainless steel appliances. The formal dining room with a custom accent wall adds sophistication and charm. The main level boasts spacious bedroom Facing the Grand river with full washroom-->> Separate living and dinning area -->> 2nd Floor has 3 Bedrooms with access to Full WR -->>Finished attic provides extra living or office space.-->> New Windows -->> New entrance door (2024)-->> upgraded Roof shingles-->> A fully finished basement with vinyl floors and LED pot lights offers generous storage and functionality.--->> (New Furnace and Heat pump (2024)-->> New Electrical pannel upgraded in 2024-->>Set on a large lot with a beautiful deck overlooking the Grand River, this home defines tranquil living. Major updates include new electrical wiring and panel, new windows and doors, waterproofing, new drywalls (2024).Truly a showstopper-move-in ready and waiting for you to call it home!"
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:2 [ …2]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CreationDate": "2025-11-07T20:33:15.811963+00:00"
+"CrossStreet": "Shantz Rd right onto Fountain"
+"DirectionFaces": "South"
+"Directions": "From front door"
+"Disclosures": array:1 [ …1]
+"ExpirationDate": "2026-02-28"
+"FoundationDetails": array:1 [ …1]
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-11-03"
+"MainOfficeKey": "079800"
+"MajorChangeTimestamp": "2025-11-03T17:32:23Z"
+"MlsStatus": "New"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2025-11-03T17:32:23Z"
+"OriginalListPrice": 750000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3214394"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "2.0"
+"PhotosChangeTimestamp": "2025-11-03T17:32:23Z"
+"PoolFeatures": array:1 [ …1]
+"Roof": array:1 [ …1]
+"Sewer": array:1 [ …1]
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "S"
+"StreetName": "Fountain"
+"StreetNumber": "401"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3474.0"
+"TaxLegalDescription": "Lt 44 Pl 731 Cambridge"
+"TaxYear": "2024"
+"TransactionBrokerCompensation": "2.5"
+"TransactionType": "For Sale"
+"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=8g IK9ZA0Ukg"
+"WaterBodyName": "Grand River"
+"WaterfrontFeatures": array:1 [ …1]
+"WaterfrontYN": true
+"Zoning": "R3"
+"DDFYN": true
+"Water": "Municipal"
+"GasYNA": "Available"
+"Sewage": array:1 [ …1]
+"CableYNA": "Available"
+"HeatType": "Forced Air"
+"LotDepth": 186.0
+"LotWidth": 40.0
+"SewerYNA": "Available"
+"WaterYNA": "Available"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12503398')"
+"Shoreline": array:1 [ …1]
+"WaterView": array:1 [ …1]
+"GarageType": "None"
+"HeatSource": "Gas"
+"RollNumber": "300610002407200"
+"SurveyType": "Unknown"
+"Waterfront": array:1 [ …1]
+"DockingType": array:1 [ …1]
+"ElectricYNA": "Available"
+"RentalItems": "hot water tank"
+"HoldoverDays": 90
+"LaundryLevel": "Lower Level"
+"TelephoneYNA": "Available"
+"KitchensTotal": 1
+"ParkingSpaces": 2
+"WaterBodyType": "River"
+"provider_name": "TRREB"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"DenFamilyroomYN": true
+"LivingAreaRange": "1500-2000"
+"RoomsAboveGrade": 9
+"AccessToProperty": array:1 [ …1]
+"AlternativePower": array:1 [ …1]
+"PossessionDetails": "Flex"
+"WashroomsType1Pcs": 4
+"WashroomsType2Pcs": 4
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"KitchensAboveGrade": 1
+"ShorelineAllowance": "None"
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Second"
+"WashroomsType2Level": "Main"
+"WaterfrontAccessory": array:1 [ …1]
+"MediaChangeTimestamp": "2025-11-06T14:00:42Z"
+"SystemModificationTimestamp": "2025-11-11T03:52:20.790852Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:42 [ …42]
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#15400
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12503306"
+"ListingId": "X12503306"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-11T03:52:08Z"
+"RFModificationTimestamp": "2025-11-11T03:57:29Z"
+"ListPrice": 3000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Cambridge"
+"PostalCode": "N3H 1J2"
+"UnparsedAddress": "401 Fountain Street S, Cambridge, ON N3H 1J2"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.405575
+"Longitude": -80.3679953
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX REAL ESTATE CENTRE INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Absolutely Fantastic-->> Top to Bottom Fully Renovated -->>This fully renovated house invites you to experience the perfect blend of modern luxury and natural beauty-->> This home exudes contemporary charm while embracing the tranquil ambiance of its waterfront setting-->> Newly Upgraded Hardwood Flooring !!! Oak Stair case !!! Polished Porcelain tiles in the elegant kitchen, boasting flawless quartz countertops and high-end stainless steel appliances and Matching Quartz Backsplash!!! Formal Dinning room with accent wall -->> 3 Good size Bedrooms plus a Den on Main level -->> Finished Attic gives plenty of extra living space -->> Finished basement with vinyl floors and LED pot lights give Tons of Space of storage -->> Huge LOT with Gorgeous Deck in the backyard and Backing at Grand River!!! New wiring with new Electrical panel !!! New windows and Doors !!! Newly done water proofing !!! New drywalls !!! New Heat Pump !!! List Goes on and On -->> You Can Not miss this Stunning Property"
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CreationDate": "2025-11-08T03:52:18.771151+00:00"
+"CrossStreet": "Fountain st S/Shantz hill rd"
+"DirectionFaces": "North"
+"Directions": "From Front door"
+"Disclosures": array:1 [ …1]
+"ExpirationDate": "2026-02-28"
+"FoundationDetails": array:1 [ …1]
+"Furnished": "Unfurnished"
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"LeaseTerm": "12 Months"
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-11-03"
+"MainOfficeKey": "079800"
+"MajorChangeTimestamp": "2025-11-03T17:20:34Z"
+"MlsStatus": "New"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2025-11-03T17:20:34Z"
+"OriginalListPrice": 3000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3214264"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "2.0"
+"PhotosChangeTimestamp": "2025-11-03T17:20:34Z"
+"PoolFeatures": array:1 [ …1]
+"RentIncludes": array:1 [ …1]
+"Roof": array:1 [ …1]
+"Sewer": array:1 [ …1]
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "S"
+"StreetName": "Fountain"
+"StreetNumber": "401"
+"StreetSuffix": "Street"
+"TransactionBrokerCompensation": "half month rent"
+"TransactionType": "For Lease"
+"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=8g IK9ZA0Ukg"
+"WaterBodyName": "Grand River"
+"WaterfrontFeatures": array:1 [ …1]
+"WaterfrontYN": true
+"DDFYN": true
+"Water": "Municipal"
+"GasYNA": "Available"
+"CableYNA": "Available"
+"HeatType": "Forced Air"
+"SewerYNA": "Available"
+"WaterYNA": "Available"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12503306')"
+"Shoreline": array:1 [ …1]
+"WaterView": array:1 [ …1]
+"GarageType": "None"
+"HeatSource": "Gas"
+"SurveyType": "Unknown"
+"Waterfront": array:1 [ …1]
+"BuyOptionYN": true
+"DockingType": array:1 [ …1]
+"ElectricYNA": "Available"
+"RentalItems": "hot water tank"
+"HoldoverDays": 90
+"TelephoneYNA": "Available"
+"CreditCheckYN": true
+"ParkingSpaces": 2
+"WaterBodyType": "River"
+"provider_name": "TRREB"
+"ContractStatus": "Available"
+"PossessionDate": "2025-12-01"
+"PossessionType": "1-29 days"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"DenFamilyroomYN": true
+"DepositRequired": true
+"LivingAreaRange": "1500-2000"
+"RoomsAboveGrade": 8
+"AccessToProperty": array:1 [ …1]
+"AlternativePower": array:1 [ …1]
+"LeaseAgreementYN": true
+"PaymentFrequency": "Monthly"
+"PrivateEntranceYN": true
+"WashroomsType1Pcs": 3
+"WashroomsType2Pcs": 3
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"EmploymentLetterYN": true
+"ShorelineAllowance": "None"
+"SpecialDesignation": array:1 [ …1]
+"RentalApplicationYN": true
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Second"
+"WaterfrontAccessory": array:1 [ …1]
+"MediaChangeTimestamp": "2025-11-03T17:20:34Z"
+"PortionPropertyLease": array:1 [ …1]
+"ReferencesRequiredYN": true
+"SystemModificationTimestamp": "2025-11-11T03:52:08.723587Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:33 [ …33]
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#15399
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12503298"
+"ListingId": "X12503298"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-11T03:52:02Z"
+"RFModificationTimestamp": "2025-11-11T03:57:29Z"
+"ListPrice": 1099000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2R 0S5"
+"UnparsedAddress": "43 Sugar Trail, Kitchener, ON N2R 0S5"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.3772357
+"Longitude": -80.4844324
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "EXP REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to 43 Sugar Trail, Kitchener - a stunning "Rahi" model detached home offering the perfect blend of elegance, space, and functionality in one of Kitchener's most desirable neighbourhoods. This beautiful residence features 4 spacious bedrooms, 2.5 bathrooms, and approximately 2,350 sq. ft. of thoughtfully designed living space. The main floor showcases a bright open-concept layout with modern finishes, ideal for both everyday living and entertaining. Upstairs, generously sized bedrooms and well-appointed bathrooms provide ultimate comfort, while the full walk-out basement offers endless possibilities for future customization or additional living space. With a double car garage and a driveway for two extra vehicles, this home ensures ample parking and convenience. Priced at $1,099,000, this exquisite property is a perfect opportunity to own a luxurious family home in a prime Kitchener location close to parks, schools, and all amenities."
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:2 [ …2]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "2.0"
+"CreationDate": "2025-11-03T17:38:57.786788+00:00"
+"CrossStreet": "Broadacre To Sugar Trail"
+"DirectionFaces": "East"
+"Directions": "Broadacre To Sugar Trail"
+"ExpirationDate": "2026-02-03"
+"FireplaceYN": true
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "Dishwasher, Dryer, Range Hood, Refrigerator, Stove, Washer"
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-11-03"
+"MainOfficeKey": "285400"
+"MajorChangeTimestamp": "2025-11-03T17:19:21Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2025-11-03T17:19:21Z"
+"OriginalListPrice": 1099000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3210510"
+"ParcelNumber": "227223422"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "4.0"
+"PhotosChangeTimestamp": "2025-11-03T20:34:26Z"
+"PoolFeatures": array:1 [ …1]
+"Roof": array:1 [ …1]
+"Sewer": array:1 [ …1]
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Sugar"
+"StreetNumber": "43"
+"StreetSuffix": "Trail"
+"TaxAnnualAmount": "6770.0"
+"TaxLegalDescription": "LOT 38, PLAN 58M682 SUBJECT TO AN EASEMENT FOR ENTRY AS IN WR1407240 CITY OF KITCHENER"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2.5%+HST"
+"TransactionType": "For Sale"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/43_sugar_trl_kitchener_on/"
+"Zoning": "Res-5 73 2R(M)"
+"DDFYN": true
+"Water": "Municipal"
+"LinkYN": true
+"HeatType": "Forced Air"
+"LotDepth": 104.99
+"LotWidth": 39.37
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12503298')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "301206001123748"
+"SurveyType": "Unknown"
+"HoldoverDays": 60
+"KitchensTotal": 1
+"ParkingSpaces": 2
+"provider_name": "TRREB"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "1-29 days"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 2
+"DenFamilyroomYN": true
+"LivingAreaRange": "2000-2500"
+"RoomsAboveGrade": 11
+"PossessionDetails": "1 - 29 Days"
+"WashroomsType1Pcs": 2
+"WashroomsType2Pcs": 3
+"BedroomsAboveGrade": 4
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Second"
+"MediaChangeTimestamp": "2025-11-03T20:34:26Z"
+"SystemModificationTimestamp": "2025-11-11T03:52:02.686335Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:47 [ …47]
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#15398
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12503220"
+"ListingId": "X12503220"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-11T03:51:56Z"
+"RFModificationTimestamp": "2025-11-11T03:57:29Z"
+"ListPrice": 3100.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K 4G2"
+"UnparsedAddress": "543 Chesapeake Crescent, Waterloo, ON N2K 4G2"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.5119021
+"Longitude": -80.5160969
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "e Xp Realty"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Family Home in Coveted Eastbridge Neighbourhood! Tucked away at the end of a peaceful crescent, this home boasts an inviting open-concept layout featuring rich hardwood floors, ceramic tile, and plenty of natural light. The kitchen features sleek quartz countertops, a stylish backsplash, and stainless steel appliances. It opens seamlessly to the dining and living areas, creating the perfect space for entertaining. From the dinette, patio doors lead to a spacious deck overlooking a private, fully fenced backyard - with no rear neighbours and plenty of room to relax or host summer gatherings. Upstairs offers three generous bedrooms, including a bright primary suite with a full ensuite bath, as well as an additional full bathroom for family or guests. The lower level is fully finished and designed for comfort, featuring a large recreation area, a wet bar, and a stunning gas fireplace framed by a fieldstone mantel. Surrounded by trails, top-rated schools, RIM Park, St. Jacobs Market, and the LRT, this move-in-ready property delivers the perfect blend of privacy, style, and convenience."
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:1 [ …1]
+"CoListOfficeName": "EXP REALTY"
+"CoListOfficePhone": "866-530-7737"
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.5"
+"CreationDate": "2025-11-03T17:37:55.004091+00:00"
+"CrossStreet": "Northfield Dr E and Bridge St W"
+"DirectionFaces": "East"
+"Directions": "Bridge St W to Chesapeake Dr to Chesapeake Cres"
+"Exclusions": "Tenants Responsible for Utilities"
+"ExpirationDate": "2026-01-28"
+"FireplaceFeatures": array:1 [ …1]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [ …1]
+"Furnished": "Unfurnished"
+"GarageYN": true
+"Inclusions": "Fridge, Stove, Washer, Dryer"
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"LeaseTerm": "12 Months"
+"ListAOR": "One Point Association of REALTORS"
+"ListingContractDate": "2025-11-03"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "562100"
+"MajorChangeTimestamp": "2025-11-03T17:07:53Z"
+"MlsStatus": "New"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2025-11-03T17:07:53Z"
+"OriginalListPrice": 3100.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3213980"
+"ParcelNumber": "227071284"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "3.0"
+"PhotosChangeTimestamp": "2025-11-03T17:07:53Z"
+"PoolFeatures": array:1 [ …1]
+"RentIncludes": array:1 [ …1]
+"Roof": array:1 [ …1]
+"Sewer": array:1 [ …1]
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Chesapeake"
+"StreetNumber": "543"
+"StreetSuffix": "Crescent"
+"TransactionBrokerCompensation": "1/2 Month Rent+HST"
+"TransactionType": "For Lease"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 111.0
+"LotWidth": 32.95
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12503220')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "301601077531900"
+"SurveyType": "None"
+"RentalItems": "Hot Water Heater"
+"HoldoverDays": 60
+"CreditCheckYN": true
+"KitchensTotal": 1
+"ParkingSpaces": 2
+"provider_name": "TRREB"
+"ContractStatus": "Available"
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"WashroomsType4": 1
+"DepositRequired": true
+"LivingAreaRange": "1500-2000"
+"RoomsAboveGrade": 5
+"RoomsBelowGrade": 1
+"LeaseAgreementYN": true
+"PossessionDetails": "Flexible"
+"PrivateEntranceYN": true
+"WashroomsType1Pcs": 2
+"WashroomsType2Pcs": 3
+"WashroomsType3Pcs": 4
+"WashroomsType4Pcs": 2
+"BedroomsAboveGrade": 3
+"EmploymentLetterYN": true
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"RentalApplicationYN": true
+"ShowingAppointments": "Please book showing via Brokerbay. If you need assistance please email [email protected]"
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Second"
+"WashroomsType3Level": "Second"
+"WashroomsType4Level": "Basement"
+"MediaChangeTimestamp": "2025-11-03T17:07:53Z"
+"PortionPropertyLease": array:1 [ …1]
+"ReferencesRequiredYN": true
+"SystemModificationTimestamp": "2025-11-11T03:51:56.660661Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:23 [ …23]
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#15397
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12503142"
+"ListingId": "X12503142"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-11T03:51:50Z"
+"RFModificationTimestamp": "2025-11-11T03:57:29Z"
+"ListPrice": 1800.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Brantford"
+"PostalCode": "N3S 4J4"
+"UnparsedAddress": "415 Chatham Street Upper, Brantford, ON N3S 4J4"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.1408157
+"Longitude": -80.2631733
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "REVEL REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome home to 415 Chatham Street. This 2 bedroom, 1 bathroom, second-floor unit has been recently renovated and is ready for its next tenant. Equipped with newer appliances, in-suite laundry, your own separate entrance and a designated 2-car driveway. Enjoy a large shared backyard that's maintained for you. Water is included, and tenants are responsible for all other utilities. Conveniently located close to public transit, schools, parks, and shopping - what a great place to call home!"
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Brantford"
+"CreationDate": "2025-11-08T03:52:10.683197+00:00"
+"CrossStreet": "Second Ave"
+"DirectionFaces": "South"
+"Directions": "Colborne St E to Second Ave to Chatham St"
+"ExpirationDate": "2026-05-03"
+"FoundationDetails": array:1 [ …1]
+"Furnished": "Unfurnished"
+"Inclusions": "Carbon Monoxide Detector, Dishwasher, Dryer, Refrigerator, Smoke Detector, Stove, Washer"
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"LeaseTerm": "12 Months"
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-11-03"
+"LotSizeSource": "Geo Warehouse"
+"MainOfficeKey": "344700"
+"MajorChangeTimestamp": "2025-11-03T17:00:06Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2025-11-03T17:00:06Z"
+"OriginalListPrice": 1800.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3212214"
+"ParcelNumber": "321240088"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "2.0"
+"PhotosChangeTimestamp": "2025-11-03T17:00:06Z"
+"PoolFeatures": array:1 [ …1]
+"RentIncludes": array:2 [ …2]
+"Roof": array:1 [ …1]
+"SecurityFeatures": array:2 [ …2]
+"Sewer": array:1 [ …1]
+"ShowingRequirements": array:2 [ …2]
+"SignOnPropertyYN": true
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Chatham"
+"StreetNumber": "415"
+"StreetSuffix": "Street"
+"Topography": array:1 [ …1]
+"TransactionBrokerCompensation": "1/2 months rent + HST"
+"TransactionType": "For Lease"
+"UnitNumber": "UPPER"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Other"
+"LotDepth": 126.0
+"LotWidth": 50.0
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12503142')"
+"GarageType": "None"
+"HeatSource": "Electric"
+"RollNumber": "290604001206100"
+"SurveyType": "Unknown"
+"HoldoverDays": 30
+"CreditCheckYN": true
+"KitchensTotal": 1
+"ParkingSpaces": 2
+"provider_name": "TRREB"
+"ApproximateAge": "51-99"
+"ContractStatus": "Available"
+"PossessionDate": "2026-01-01"
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"DepositRequired": true
+"LivingAreaRange": "1500-2000"
+"RoomsAboveGrade": 5
+"LeaseAgreementYN": true
+"PaymentFrequency": "Monthly"
+"PropertyFeatures": array:2 [ …2]
+"LotSizeRangeAcres": "< .50"
+"PossessionDetails": "Immediate"
+"PrivateEntranceYN": true
+"WashroomsType1Pcs": 4
+"BedroomsAboveGrade": 2
+"EmploymentLetterYN": true
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"RentalApplicationYN": true
+"ShowingAppointments": "PLEASE USE BROKERBAY TO BOOK APPOINTMENTS. If you do not have access to BROKERBAY, call office cell Monday to Friday 8am-5pm. Outside of those hours contact the LA directly at 226-583-4770."
+"WashroomsType1Level": "Second"
+"MediaChangeTimestamp": "2025-11-03T17:00:06Z"
+"PortionPropertyLease": array:1 [ …1]
+"ReferencesRequiredYN": true
+"SystemModificationTimestamp": "2025-11-11T03:51:50.626421Z"
+"Media": array:16 [ …16]
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#15396
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12503118"
+"ListingId": "X12503118"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-11T03:51:44Z"
+"RFModificationTimestamp": "2025-11-11T03:57:29Z"
+"ListPrice": 850000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K 3J9"
+"UnparsedAddress": "298 Auburn Drive, Waterloo, ON N2K 3J9"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4927406
+"Longitude": -80.4940005
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "ENGEL & VOLKERS WATERLOO REGION"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to Your Dream Home in the Heart of Lexington - 298 Auburn Dr. Nestled in the highly sought-after, family-friendly Lexington neighbourhood, this impeccably maintained detached home offers the perfect blend of comfort, style, and convenience. Double-car garage and spacious double driveway provide ample parking and privacy. Step onto the charming covered front porch and into a warm, inviting foyer that opens to a bright, open-concept living and dining area - ideal for both everyday living and entertaining. The well-appointed kitchen features stainless steel appliances, abundant cabinetry, and a sunny breakfast area overlooking the Bomberger Woodlot - a stunning, 2.5-acre protected greenbelt with walking trails and beautiful natural scenery and exceptional privacy, a sense of connection to nature rarely found in the city. Step out onto the large deck and enjoy the serenity - perfect for relaxation, morning coffee, or hosting gatherings surrounded by greenery. The expansive family room, filled with natural light, offers a cozy retreat for family time or quiet evenings. The main floor is finished with elegant hardwood and vinyl tile flooring, and includes a powder room and convenient laundry area for added functionality. Upstairs, the primary suite is a true sanctuary, featuring double closets and a luxurious, upgraded 5-piece ensuite. Two additional spacious bedrooms share a beautifully appointed 4-piece bathroom, perfect for family or guests. Basement extends your living space with a large recreation room, ample storage, and a cold room, providing flexibility for hobbies, entertainment, or a home office. Ideally located within walking distance to Lexington and St. Matthew schools, parks, shopping, public transit, the library, and with easy access to major highways, this home offers the perfect combination of tranquility and accessibility."
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "2.0"
+"CreationDate": "2025-11-07T21:18:01.212353+00:00"
+"CrossStreet": "UNIVERSITY AVE. E."
+"DirectionFaces": "West"
+"Directions": "UNIVERISTY AVE. E. TO AUBURN DR."
+"Exclusions": "TV in the living room and primary bedroom. Camera at the front door. Curtains in the primary bedroom."
+"ExpirationDate": "2026-01-05"
+"ExteriorFeatures": array:3 [ …3]
+"FireplaceFeatures": array:1 [ …1]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "TV wall mounts in the living room and primary bedroom."
+"InteriorFeatures": array:3 [ …3]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-11-03"
+"LotSizeSource": "Geo Warehouse"
+"MainOfficeKey": "399200"
+"MajorChangeTimestamp": "2025-11-03T16:58:05Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2025-11-03T16:58:05Z"
+"OriginalListPrice": 850000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3213838"
+"ParcelNumber": "227200103"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "4.0"
+"PhotosChangeTimestamp": "2025-11-03T16:58:05Z"
+"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": "AUBURN"
+"StreetNumber": "298"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "5626.0"
+"TaxAssessedValue": 412000
+"TaxLegalDescription": "LT 24 PL 1565 CITY OF WATERLOO; S/T 798608; WATERLOO"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2%+HST"
+"TransactionType": "For Sale"
+"View": array:3 [ …3]
+"VirtualTourURLBranded": "https://media.visualadvantage.ca/298-Auburn-Dr"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/298-Auburn-Dr/idx"
+"Zoning": "R1"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 114.0
+"LotWidth": 51.0
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12503118')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "301601016000162"
+"SurveyType": "None"
+"RentalItems": "Hot Water Heater, Water Purifier, Water Softener"
+"HoldoverDays": 30
+"LaundryLevel": "Main Level"
+"KitchensTotal": 1
+"ParkingSpaces": 2
+"UnderContract": array:3 [ …3]
+"provider_name": "TRREB"
+"ApproximateAge": "31-50"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"DenFamilyroomYN": true
+"LivingAreaRange": "1500-2000"
+"RoomsAboveGrade": 12
+"RoomsBelowGrade": 3
+"PropertyFeatures": array:5 [ …5]
+"LotSizeRangeAcres": "< .50"
+"PossessionDetails": "IMMEDIATE"
+"WashroomsType1Pcs": 2
+"WashroomsType2Pcs": 4
+"WashroomsType3Pcs": 5
+"BedroomsAboveGrade": 3
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "Please remove shoes, leave all lights on, leave business card, and lock doors."
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Second"
+"WashroomsType3Level": "Second"
+"MediaChangeTimestamp": "2025-11-03T16:58:05Z"
+"SystemModificationTimestamp": "2025-11-11T03:51:44.598021Z"
+"Media": array:47 [ …47]
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#15395
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12503108"
+"ListingId": "X12503108"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-11T03:51:38Z"
+"RFModificationTimestamp": "2025-11-11T03:57:29Z"
+"ListPrice": 599900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Cambridge"
+"PostalCode": "N1S 2B4"
+"UnparsedAddress": "97 First Avenue, Cambridge, ON N1S 2B4"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.346088
+"Longitude": -80.3241623
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX REAL ESTATE CENTRE INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to this charming all-brick bungalow, perfectly situated on a fully fenced lot with mature trees, offering both privacy and a serene setting. The home exudes warmth and character from the moment you step inside, with gleaming hardwood floors throughout the main level, creating an inviting, cohesive living space. The bright, functional kitchen is designed for everyday living, featuring durable laminate countertops, convenient remote-controlled under-cabinet lighting, and high-quality Samsung stainless steel appliances, including a stove, refrigerator, and microwave with range hood-ideal for everything from quick meals to gourmet dinners. With four bedrooms-three on the main floor and one finished bedroom in the lower level-this home provides ample space for a growing family, guests, or a home office. The finished basement offers incredible versatility, featuring a cozy gas-burning fireplace, a wet bar with double sink, and a stylish 3-piece bathroom. This space is perfect for entertaining, creating a comfortable in-law suite, or designing a recreation area for family fun. Step outside to a lovely patio, seamlessly blending with the beautifully landscaped, treed backyard. Whether relaxing with morning coffee, hosting summer gatherings, or enjoying quiet evenings, this outdoor space provides charm and functionality. The fully fenced yard ensures privacy and safety, ideal for children, pets, or peace of mind. This meticulously maintained home balances comfort and practicality, offering a welcoming atmosphere, versatile living spaces, and a prime location. Combining classic design, modern amenities, and thoughtful upgrades throughout, it's an ideal place to create lasting memories, entertain effortlessly, and enjoy the tranquility of a well-established, treed setting. A truly inviting property that blends charm, function, and warmth in every corner."
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:2 [ …2]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CreationDate": "2025-11-07T21:26:51.386330+00:00"
+"CrossStreet": "Glenmorris/Tait"
+"DirectionFaces": "West"
+"Directions": "TAIT ST. TO FIRST AVE"
+"Exclusions": "FREEZER IN BASEMENT, ALL BEDROOM CURTAINS."
+"ExpirationDate": "2026-01-31"
+"ExteriorFeatures": array:1 [ …1]
+"FireplaceFeatures": array:1 [ …1]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [ …1]
+"Inclusions": "Built-in Microwave, Dryer, Range Hood, Refrigerator, Stove, Washer, ALL CURTAIN RODS, GAZEBO WITH LIGHTS ON PATIO, BAR & BAR FRIDGE IN BASEMENT, 3 BAR STOOLS,"
+"InteriorFeatures": array:2 [ …2]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-11-03"
+"MainOfficeKey": "079800"
+"MajorChangeTimestamp": "2025-11-03T16:57:34Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2025-11-03T16:57:34Z"
+"OriginalListPrice": 599900.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3213714"
+"ParcelNumber": "226680053"
+"ParkingFeatures": array:2 [ …2]
+"ParkingTotal": "4.0"
+"PhotosChangeTimestamp": "2025-11-03T16:57:34Z"
+"PoolFeatures": 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": "First"
+"StreetNumber": "97"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "3482.0"
+"TaxLegalDescription": "LT 66 PL 185 CAMBRIDGE; CAMBRIDGE"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2.5% + HST"
+"TransactionType": "For Sale"
+"VirtualTourURLBranded": "https://youriguide.com/97_1st_ave_cambridge_on/"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/97_1st_ave_cambridge_on/"
+"Zoning": "R5"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 115.0
+"LotWidth": 40.0
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12503108')"
+"GarageType": "None"
+"HeatSource": "Gas"
+"RollNumber": "300605006304103"
+"SurveyType": "Unknown"
+"RentalItems": "Hot Water Heater and Air Conditioner"
+"HoldoverDays": 60
+"LaundryLevel": "Lower Level"
+"KitchensTotal": 1
+"ParkingSpaces": 4
+"UnderContract": array:2 [ …2]
+"provider_name": "TRREB"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "30-59 days"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"DenFamilyroomYN": true
+"LivingAreaRange": "700-1100"
+"RoomsAboveGrade": 12
+"PropertyFeatures": array:6 [ …6]
+"PossessionDetails": "30-59 days"
+"WashroomsType1Pcs": 4
+"WashroomsType2Pcs": 3
+"BedroomsAboveGrade": 4
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "PLEASE BE COURTEOUS: MUST REMOVE SHOES, LEAVE LIGHTS AS YOU FOUND THEM, MUST ENSURE ALL DOORS FRONT, BACK AND SIDE ARE LOCKED. DO NOT USE BATHROOMS."
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Basement"
+"MediaChangeTimestamp": "2025-11-03T16:57:34Z"
+"SystemModificationTimestamp": "2025-11-11T03:51:38.56685Z"
+"Media": array:50 [ …50]
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#15394
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12502838"
+"ListingId": "X12502838"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-11T03:51:26Z"
+"RFModificationTimestamp": "2025-11-11T03:57:29Z"
+"ListPrice": 1116900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2E 0C9"
+"UnparsedAddress": "200 Benninger Drive, Kitchener, ON N2E 0C9"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4073803
+"Longitude": -80.536844
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX REAL ESTATE CENTRE INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "***FINISHED BASEMENT INCLUDED*** Perfect for Multi-Generational Families. Welcome to the Foxdale Model, offering 2,280 sq. ft. of thoughtful design and upscale features. The Foxdale impresses with 9 ceilings and engineered hardwood floors on the main level, quartz countertops throughout the kitchen and baths, and an elegant quartz backsplash. Featuring four bedrooms, two primary en-suites, and a Jack and Jill bathroom, it's a true generational home. Additional highlights include soft-close kitchen cabinets, upper laundry cabinetry, a tiled ensuite shower with glass enclosure, central air conditioning, and a walkout basement with rough-in for future customization."
+"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-11-08T03:53:08.337453+00:00"
+"CrossStreet": "Trussler"
+"DirectionFaces": "North"
+"Directions": "Nathalie"
+"ExpirationDate": "2026-01-29"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-11-03"
+"MainOfficeKey": "079800"
+"MajorChangeTimestamp": "2025-11-03T16:25:50Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2025-11-03T16:25:50Z"
+"OriginalListPrice": 1116900.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3162420"
+"ParcelNumber": "224671440"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "4.0"
+"PhotosChangeTimestamp": "2025-11-03T16:25:50Z"
+"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": "Benninger"
+"StreetNumber": "200"
+"StreetSuffix": "Drive"
+"TaxLegalDescription": "PART BLOCK 14, PLAN 58M643, PART 166 PLAN 58R21833"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2% of Base Price Net OF HST"
+"TransactionType": "For Sale"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 100.0
+"LotWidth": 32.0
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12502838')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"SurveyType": "Available"
+"HoldoverDays": 30
+"KitchensTotal": 1
+"ParkingSpaces": 2
+"provider_name": "TRREB"
+"ApproximateAge": "New"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionDate": "2026-04-30"
+"PossessionType": "Other"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"WashroomsType4": 1
+"LivingAreaRange": "2000-2500"
+"RoomsAboveGrade": 12
+"WashroomsType1Pcs": 2
+"WashroomsType2Pcs": 4
+"WashroomsType3Pcs": 4
+"WashroomsType4Pcs": 4
+"BedroomsAboveGrade": 4
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Second"
+"WashroomsType3Level": "Second"
+"WashroomsType4Level": "Second"
+"MediaChangeTimestamp": "2025-11-03T16:25:50Z"
+"SystemModificationTimestamp": "2025-11-11T03:51:26.493944Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:38 [ …38]
}
]
+success: true
+page_size: 9
+page_count: 7722
+count: 69491
+after_key: ""
}
]
]
