array:2 [
"RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=774&$filter=(StandardStatus eq 'Active')/Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=774&$filter=(StandardStatus eq 'Active')&$expand=Media/Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=774&$filter=(StandardStatus eq 'Active')/Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=774&$filter=(StandardStatus eq 'Active')&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#14266
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14271
+post_id: "595565"
+post_author: 1
+"ListingKey": "X12469073"
+"ListingId": "X12469073"
+"PropertyType": "Commercial"
+"PropertySubType": "Sale Of Business"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-11T02:24:18Z"
+"RFModificationTimestamp": "2025-11-11T02:29:49Z"
+"ListPrice": 525000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 9500.0
+"City": "Cambridge"
+"PostalCode": "N1R 6J8"
+"UnparsedAddress": "580 Hespeler Road Bldg E, Cambridge, ON N1R 6J8"
+"Coordinates": array:2 [
0 => -80.3123023
1 => 43.3600536
]
+"Latitude": 43.3600536
+"Longitude": -80.3123023
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX HALLMARK REALTY LTD."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Location! Location! Location! ***TURNKEY BUSINESS OPPORTUNITY *** A 9500 SQ. FT stand alone BAR building. Could this be your road to prosperity. The next EVENT CENTRE. Liquor License for over 900 people. 3 floors, 2 dance floors, ONE with a GLASS floor!!! Too much to include. Let us go see this BAR and discover the possibilities. Perfect Opportunity to a NEW owner / investor / manager. Perfect spot for a bar / dance club on the main floor and a hooka lounge on the upper floor. Upper floor dance floor is a glass dance floor open to below. ALL equipment, electronics, kitchen equipment are owned. Owners are selling the opportunity to own and operate a TURNKEY and fully set up and operational bar / food and beverage business location and NOT their specific business or company! Landlord will work with new BUYERS to negotiate a new lease agreement"
+"BuildingAreaUnits": "Square Feet"
+"BusinessType": array:1 [
0 => "Bar/Tavern/Pub"
]
+"Cooling": "Yes"
+"Country": "CA"
+"CountyOrParish": "Waterloo"
+"CreationDate": "2025-11-09T11:09:32.849783+00:00"
+"CrossStreet": "Eagle St. & Hespeler Rd."
+"Directions": "N"
+"Exclusions": "All Liquor, one black colour fridge in kitchen back storeroom."
+"ExpirationDate": "2026-03-12"
+"HoursDaysOfOperation": array:1 [
0 => "Open 1 Day"
]
+"HoursDaysOfOperationDescription": "22:00 TO 02:00"
+"Inclusions": "All Equipment, All TV and Electronics, CCTV and Security System, All Kitchen equipment"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-10-17"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "259000"
+"MajorChangeTimestamp": "2025-10-17T18:59:23Z"
+"MlsStatus": "New"
+"NumberOfFullTimeEmployees": 10
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2025-10-17T18:59:23Z"
+"OriginalListPrice": 525000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3148056"
+"ParcelNumber": "226430243"
+"PhotosChangeTimestamp": "2025-10-22T19:28:41Z"
+"SeatingCapacity": "930"
+"ShowingRequirements": array:1 [
0 => "List Salesperson"
]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Hespeler"
+"StreetNumber": "580"
+"StreetSuffix": "Road"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "5.00"
+"TransactionType": "For Sale"
+"UnitNumber": "Bldg E"
+"Zoning": "Commercial"
+"DDFYN": true
+"Water": "Municipal"
+"LotType": "Building"
+"TaxType": "TMI"
+"HeatType": "Gas Forced Air Open"
+"LotDepth": 678.52
+"LotWidth": 250.0
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12469073')"
+"ChattelsYN": true
+"GarageType": "Outside/Surface"
+"RetailArea": 9000.0
+"RollNumber": "300615001506750"
+"PropertyUse": "Without Property"
+"RentalItems": "NONE. All chattels and equipment are owned."
+"HoldoverDays": 120
+"ListPriceUnit": "For Sale"
+"provider_name": "TRREB"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"FreestandingYN": true
+"HSTApplication": array:1 [
0 => "In Addition To"
]
+"PossessionDate": "2025-11-01"
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"RetailAreaCode": "Sq Ft"
+"LiquorLicenseYN": true
+"MediaChangeTimestamp": "2025-10-22T19:28:41Z"
+"SystemModificationTimestamp": "2025-11-11T02:24:18.156434Z"
+"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": "595565"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14270
+post_id: "434170"
+post_author: 1
+"ListingKey": "N12265771"
+"ListingId": "N12265771"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-11T02:24:14Z"
+"RFModificationTimestamp": "2025-11-11T02:36:11Z"
+"ListPrice": 1499000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Richmond Hill"
+"PostalCode": "L4C 2P3"
+"UnparsedAddress": "460 Balkan Road, Richmond Hill, ON L4C 2P3"
+"Coordinates": array:2 [
0 => -79.4182964
1 => 43.8843779
]
+"Latitude": 43.8843779
+"Longitude": -79.4182964
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "CENTURY 21 ATRIA REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "One of the largest and most desirable detached bungalows in the Crosby area (almost 1,500 sq.ft. with extra bath on main), nestled on a massive 60' x 150' clean lot in the top-ranked Bayview Secondary School district! This fully upgraded home features a large legal addition adding approximately 300 Sq.ft. of extra living space to both the main floor and the basement. The main floor boasts hardwood flooring throughout, with a combined living room, family room and dining area; three bedrooms, including a spacious primary with ensuite; and a modern open-concept kitchen with tall cabinets, stone countertops, a center island, and stainless-steel appliances overlooking a large deck. The fully upgraded basement includes a separate entrance, large family room, two bright bedrooms, and open-concept kitchen with a dining/breakfast area and stainless-steel Appliances. Newer windows, doors, millwork, roof, A/C, Furnace, Roof, flooring, both kitchen, all 3 baths. Enjoy a large and private backyard oasis with a fully equipped in-ground swimming pool. No neighbour at the back for maximum privacy. The oversized driveway accommodates 6-7 cars. Conveniently located near Bayview Ave, shopping (Fresh Co, Walmart, Food Basics, Costco), public transit to Finch Station, and GO Train access to Union Station! Don't miss this rare opportunity to own a true gem in Richmond Hill!"
+"ArchitecturalStyle": "Bungalow"
+"Basement": array:2 [
0 => "Finished"
1 => "Separate Entrance"
]
+"CityRegion": "Crosby"
+"ConstructionMaterials": array:2 [
0 => "Stone"
1 => "Brick"
]
+"Cooling": "Central Air"
+"Country": "CA"
+"CountyOrParish": "York"
+"CreationDate": "2025-11-11T02:29:49.402501+00:00"
+"CrossStreet": "Bayview Ave & Crosby Ave"
+"DirectionFaces": "East"
+"Directions": "Bayview"
+"ExpirationDate": "2025-12-31"
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Inclusions": "Two S/S Stove, Two S/S Fridge, Two S/S Dishwasher, Two S/S Hood-range, White Washer & Dryer, All Existing Electrical Light Fixtures, All Existing Window Coverings."
+"InteriorFeatures": "In-Law Capability,Primary Bedroom - Main Floor,Upgraded Insulation,Storage"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-07-05"
+"LotSizeSource": "Geo Warehouse"
+"MainOfficeKey": "057600"
+"MajorChangeTimestamp": "2025-08-01T02:00:04Z"
+"MlsStatus": "Price Change"
+"OccupantType": "Owner+Tenant"
+"OriginalEntryTimestamp": "2025-07-06T01:24:51Z"
+"OriginalListPrice": 1599000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft2667538"
+"ParcelNumber": "031770101"
+"ParkingFeatures": "Private"
+"ParkingTotal": "7.0"
+"PhotosChangeTimestamp": "2025-11-11T02:24:14Z"
+"PoolFeatures": "Inground"
+"PreviousListPrice": 1599000.0
+"PriceChangeTimestamp": "2025-08-01T02:00:04Z"
+"Roof": "Asphalt Shingle"
+"Sewer": "Sewer"
+"ShowingRequirements": array:1 [
0 => "Lockbox"
]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Balkan"
+"StreetNumber": "460"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "6716.08"
+"TaxLegalDescription": "LT 4 PL 4839 RICHMOND HILL ; RICHMOND HILL"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2.5% + HST"
+"TransactionType": "For Sale"
+"VirtualTourURLUnbranded": "https://www.houssmax.ca/vtournb/h9119089"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 150.0
+"LotWidth": 60.0
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('N12265771')"
+"GarageType": "None"
+"HeatSource": "Gas"
+"RollNumber": "193802002003100"
+"SurveyType": "None"
+"HoldoverDays": 120
+"KitchensTotal": 2
+"ParkingSpaces": 7
+"provider_name": "TRREB"
+"short_address": "Richmond Hill, ON L4C 2P3, CA"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [
0 => "Not Subject to HST"
]
+"PossessionDate": "2025-09-30"
+"PossessionType": "60-89 days"
+"PriorMlsStatus": "New"
+"WashroomsType1": 2
+"WashroomsType2": 1
+"DenFamilyroomYN": true
+"LivingAreaRange": "1100-1500"
+"RoomsAboveGrade": 7
+"RoomsBelowGrade": 5
+"PossessionDetails": "TBA"
+"WashroomsType1Pcs": 3
+"WashroomsType2Pcs": 3
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"KitchensAboveGrade": 1
+"KitchensBelowGrade": 1
+"SpecialDesignation": array:1 [
0 => "Unknown"
]
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Basement"
+"MediaChangeTimestamp": "2025-11-11T02:24:14Z"
+"SystemModificationTimestamp": "2025-11-11T02:24:17.750649Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:4 [
0 => array:26 [ …26]
1 => array:26 [ …26]
2 => array:26 [ …26]
3 => array:26 [ …26]
]
+"ID": "434170"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14098
+post_id: "597665"
+post_author: 1
+"ListingKey": "X12469026"
+"ListingId": "X12469026"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-11T02:24:06Z"
+"RFModificationTimestamp": "2025-11-11T02:37:53Z"
+"ListPrice": 749000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J 3T5"
+"UnparsedAddress": "138 Chelford Crescent, Waterloo, ON N2J 3T5"
+"Coordinates": array:2 [
0 => -80.504803
1 => 43.479238
]
+"Latitude": 43.479238
+"Longitude": -80.504803
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "SKILL REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to your dream home! This beautifully updated bungalow Situated on a 62.01 x 120-foot , mature lot in one of Waterloos most desirable neighbourhoods.. This move-in ready home features 3 + 3 Beds and 2 Baths , central air, and shingles (all 2020), updated windows, stylish flooring, and a modern kitchen and bathroom. Bright walk-out basement offers excellent in-law suite potential. Enjoy a mature landscaped yard, ample parking, and AAA condition throughout. A rare find don't miss out!"
+"ArchitecturalStyle": "Bungalow"
+"Basement": array:1 [
0 => "Finished with Walk-Out"
]
+"ConstructionMaterials": array:1 [
0 => "Brick"
]
+"Cooling": "Central Air"
+"CoolingYN": true
+"Country": "CA"
+"CountyOrParish": "Waterloo"
+"CreationDate": "2025-11-11T02:32:03.471281+00:00"
+"CrossStreet": "Chelford / Meaford"
+"DirectionFaces": "West"
+"Directions": "Chelford / Meaford"
+"ExpirationDate": "2026-03-15"
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Brick"
]
+"HeatingYN": true
+"Inclusions": "Fridge, Stove , washer , Dryer, All existing llight fixtures"
+"InteriorFeatures": "Other"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-10-17"
+"LotDimensionsSource": "Other"
+"LotSizeDimensions": "62.01 x 120.00 Feet"
+"MainLevelBathrooms": 1
+"MainOfficeKey": "245400"
+"MajorChangeTimestamp": "2025-10-17T18:48:39Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2025-10-17T18:48:39Z"
+"OriginalListPrice": 749000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3148360"
+"ParkingFeatures": "Private"
+"ParkingTotal": "6.0"
+"PhotosChangeTimestamp": "2025-10-17T18:48:39Z"
+"PoolFeatures": "None"
+"Roof": "Unknown"
+"RoomsTotal": "8"
+"Sewer": "Sewer"
+"ShowingRequirements": array:1 [
0 => "Lockbox"
]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Chelford"
+"StreetNumber": "138"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "3996.0"
+"TaxLegalDescription": "Lt 39 Pl 1195 City Of Waterloo; S/T 324986 City Of Waterloo"
+"TaxYear": "2024"
+"TransactionBrokerCompensation": "2.5% + HST"
+"TransactionType": "For Sale"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 120.0
+"LotWidth": 62.01
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12469026')"
+"PictureYN": true
+"GarageType": "None"
+"HeatSource": "Gas"
+"SurveyType": "Unknown"
+"RentalItems": "Hot water Tank ( If rental )"
+"HoldoverDays": 30
+"KitchensTotal": 1
+"ParkingSpaces": 6
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2J 3T5, CA"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [
0 => "Included In"
]
+"PossessionDate": "2025-11-01"
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"LivingAreaRange": "700-1100"
+"RoomsAboveGrade": 8
+"PropertyFeatures": array:5 [
0 => "Park"
1 => "Place Of Worship"
2 => "Public Transit"
3 => "School"
4 => "School Bus Route"
]
+"StreetSuffixCode": "Cres"
+"BoardPropertyType": "Free"
+"WashroomsType1Pcs": 3
+"WashroomsType2Pcs": 3
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 3
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [
0 => "Unknown"
]
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Lower"
+"MediaChangeTimestamp": "2025-10-17T18:48:39Z"
+"MLSAreaDistrictOldZone": "X11"
+"MLSAreaMunicipalityDistrict": "Waterloo"
+"SystemModificationTimestamp": "2025-11-11T02:24:06.088757Z"
+"VendorPropertyInfoStatement": true
+"Media": array:28 [
0 => array:26 [ …26]
1 => array:26 [ …26]
2 => array:26 [ …26]
3 => array:26 [ …26]
4 => array:26 [ …26]
5 => array:26 [ …26]
6 => array:26 [ …26]
7 => array:26 [ …26]
8 => array:26 [ …26]
9 => array:26 [ …26]
10 => array:26 [ …26]
11 => array:26 [ …26]
12 => array:26 [ …26]
13 => array:26 [ …26]
14 => array:26 [ …26]
15 => array:26 [ …26]
16 => array:26 [ …26]
17 => array:26 [ …26]
18 => array:26 [ …26]
19 => array:26 [ …26]
20 => array:26 [ …26]
21 => array:26 [ …26]
22 => array:26 [ …26]
23 => array:26 [ …26]
24 => array:26 [ …26]
25 => array:26 [ …26]
26 => array:26 [ …26]
27 => array:26 [ …26]
]
+"ID": "597665"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14262
+post_id: "594449"
+post_author: 1
+"ListingKey": "X12469013"
+"ListingId": "X12469013"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-11T02:24:00Z"
+"RFModificationTimestamp": "2025-11-11T02:37:53Z"
+"ListPrice": 549000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.83
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Sault Ste Marie"
+"PostalCode": "P6A 2G7"
+"UnparsedAddress": "1638 Queen Street E, Sault Ste Marie, ON P6A 2G7"
+"Coordinates": array:2 [
0 => 0
1 => 0
]
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "PG DIRECT REALTY LTD."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Visit REALTOR website for additional information. Welcome to 1638 Queen Street East, a charming 3+1 bedroom, 2-bathroom home on a rare 0.83-acre lot in Sault Ste. Marie's East End. This property blends character, comfort, and nature - the perfect retreat in the city. Inside, enjoy an updated kitchen (2020) with modern appliances, a reverse osmosis water system, and hot water on demand. The main floor offers bright living and dining spaces with views of the trees and gardens outside. Upstairs has three bedrooms and a full four-piece bathroom, with seasonal water views from the windows. Public access to the river is just 250m away. The finished basement provides additional living space with a versatile rec room or optional fourth bedroom with a walk-in closet, a three-piece bathroom, a laundry/utility area, and a beautiful stone fireplace that adds warmth and character (requires WETT certification for use). Outdoors, the park-like setting shines with mature maple, birch, oak, serviceberry, and apple trees, raspberry bushes, and gardens throughout. Relax in your cedar wood-fired hot tub, entertain friends and family, or simply enjoy the privacy of your oversized lot. A detached garage, double carport, and versatile bunkie/workshop/she-shed provide extra storage and creative space. Additional features include central air conditioning, a John Deere riding lawn mower (2023) included, and immediate possession available. Located within walking distance to Algoma University, Bellevue Park, and the Sault Ste. Marie Golf Club, and the Hub Trail - with a bike lane at your door - this home combines modern updates, outdoor beauty, and convenience. With over 2,200 sg. ft. of finished living space and endless charm, this Bast End gen is move-in ready and waiting for you!"
+"ArchitecturalStyle": "1 1/2 Storey"
+"Basement": array:1 [
0 => "Finished"
]
+"ConstructionMaterials": array:1 [
0 => "Vinyl Siding"
]
+"Cooling": "Central Air"
+"Country": "CA"
+"CountyOrParish": "Algoma"
+"CoveredSpaces": "2.0"
+"CreationDate": "2025-11-11T02:30:29.794512+00:00"
+"CrossStreet": "Queen St. East & Shannon Rd"
+"DirectionFaces": "North"
+"Directions": "From Shannon Rd, turn left onto Queen St. East"
+"Exclusions": "None"
+"ExpirationDate": "2026-04-17"
+"ExteriorFeatures": "Hot Tub,Landscaped,Privacy"
+"FireplaceFeatures": array:3 [
0 => "Other"
1 => "Rec Room"
2 => "Wood"
]
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"GarageYN": true
+"Inclusions": "Fridge, Stove, Washer & Dryer, John Dryer, John Deere riding lawn Tractor with Bagger Accessory (2023), Cedar wood-fired, hot tub, Stone PP (as is)"
+"InteriorFeatures": "On Demand Water Heater"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-10-17"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "242800"
+"MajorChangeTimestamp": "2025-10-17T18:46:36Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2025-10-17T18:46:36Z"
+"OriginalListPrice": 549000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3147578"
+"OtherStructures": array:1 [
0 => "Workshop"
]
+"ParcelNumber": "314990066"
+"ParkingFeatures": "Covered,Inside Entry,RV/Truck"
+"ParkingTotal": "6.0"
+"PhotosChangeTimestamp": "2025-10-17T18:46:36Z"
+"PoolFeatures": "None"
+"Roof": "Asphalt Shingle"
+"SecurityFeatures": array:2 [
0 => "Carbon Monoxide Detectors"
1 => "Smoke Detector"
]
+"Sewer": "Sewer"
+"ShowingRequirements": array:1 [
0 => "Go Direct"
]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "E"
+"StreetName": "Queen"
+"StreetNumber": "1638"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3254.87"
+"TaxLegalDescription": "Lot 16 RCP H700 St. Mary's; Sault Ste. Marie"
+"TaxYear": "2025"
+"Topography": array:3 [
0 => "Flat"
1 => "Open Space"
2 => "Wooded/Treed"
]
+"TransactionBrokerCompensation": "1% by Seller $1 by LB"
+"TransactionType": "For Sale"
+"View": array:3 [
0 => "Garden"
1 => "River"
2 => "Trees/Woods"
]
+"Zoning": "R1 Single Detached"
+"DDFYN": true
+"Water": "Municipal"
+"GasYNA": "Yes"
+"CableYNA": "Available"
+"HeatType": "Forced Air"
+"LotDepth": 400.0
+"LotShape": "Rectangular"
+"LotWidth": 100.0
+"SewerYNA": "Yes"
+"WaterYNA": "Yes"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12469013')"
+"GarageType": "Detached"
+"HeatSource": "Gas"
+"RollNumber": "576101003005900"
+"SurveyType": "Unknown"
+"Waterfront": array:1 [
0 => "None"
]
+"ElectricYNA": "Yes"
+"RentalItems": "Hot water on demand, RO System, Central Air Conditioning"
+"LaundryLevel": "Lower Level"
+"TelephoneYNA": "Available"
+"KitchensTotal": 1
+"ParkingSpaces": 4
+"UnderContract": array:3 [
0 => "Air Conditioner"
1 => "On Demand Water Heater"
2 => "Water Purifier"
]
+"provider_name": "TRREB"
+"short_address": "Sault Ste Marie, ON P6A 2G7, CA"
+"ApproximateAge": "51-99"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [
0 => "Not Subject to HST"
]
+"PossessionDate": "2025-11-01"
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"LivingAreaRange": "1100-1500"
+"RoomsAboveGrade": 6
+"RoomsBelowGrade": 2
+"LotSizeAreaUnits": "Acres"
+"PropertyFeatures": array:6 [
0 => "Golf"
1 => "Marina"
2 => "Park"
3 => "Public Transit"
4 => "River/Stream"
5 => "Wooded/Treed"
]
+"LotSizeRangeAcres": ".50-1.99"
+"PossessionDetails": "Immediate Possession"
+"WashroomsType1Pcs": 4
+"WashroomsType2Pcs": 3
+"BedroomsAboveGrade": 3
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [
0 => "Unknown"
]
+"WashroomsType1Level": "Second"
+"WashroomsType2Level": "Basement"
+"MediaChangeTimestamp": "2025-10-17T18:46:36Z"
+"SystemModificationTimestamp": "2025-11-11T02:24:00.049626Z"
+"VendorPropertyInfoStatement": true
+"Media": array:8 [
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]
]
+"ID": "594449"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14261
+post_id: "594331"
+post_author: 1
+"ListingKey": "X12468793"
+"ListingId": "X12468793"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-11T02:23:41Z"
+"RFModificationTimestamp": "2025-11-11T02:30:10Z"
+"ListPrice": 2350.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K 3H4"
+"UnparsedAddress": "251 Northfield Drive E 402, Waterloo, ON N2K 3H4"
+"Coordinates": array:2 [
0 => -80.5472211
1 => 43.4965979
]
+"Latitude": 43.4965979
+"Longitude": -80.5472211
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "REAL BROKER ONTARIO LTD."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "**Move-in special: Get half off your first month's rent when you move in on November 1** Welcome to the Blackstone Condos, where chic and convenient urban living awaits you! Step into Unit 402 and immerse yourself in modern charm and style. This spacious 2-bedroom, 2-bathroom condo is well-lit and boasts a carpet-free interior adorned with contemporary finishes, new paint, sleek stainless steel appliances, and stunning quartz countertops throughout. Venture outside the unit and indulge in the building's premier amenities. Stay active in the fitness centre, socialize in the event lounge, find inspiration in the co-working space, and don't forget to experience a summer night with friends on the furnished rooftop terrace complete with an outdoor kitchen! It's also important to mention this building's prime location, as staying here means finding yourself just moments away from vibrant Uptown Waterloo, where a plethora of dining, shopping, and entertainment options await. Conestoga Mall, University of Waterloo, Wilfrid Laurier, Conestoga College, and Kitchener's Innovation District are all within easy reach as well, making this the perfect home for young professionals, and anyone seeking the ultimate urban lifestyle!"
+"ArchitecturalStyle": "1 Storey/Apt"
+"Basement": array:1 [
0 => "None"
]
+"CoListOfficeName": "REAL BROKER ONTARIO LTD."
+"CoListOfficePhone": "888-311-1172"
+"ConstructionMaterials": array:2 [
0 => "Aluminum Siding"
1 => "Stone"
]
+"Cooling": "Central Air"
+"Country": "CA"
+"CountyOrParish": "Waterloo"
+"CreationDate": "2025-10-17T18:00:26.746285+00:00"
+"CrossStreet": "Northfield Drive / Bridge St W"
+"Directions": "Northfield Drive / Bridge St W"
+"ExpirationDate": "2026-04-17"
+"Furnished": "Unfurnished"
+"Inclusions": "Dishwasher, Dryer, Refrigerator, Smoke Detector, Stove, Washer"
+"InteriorFeatures": "Other"
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [
0 => "Ensuite"
]
+"LeaseTerm": "12 Months"
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-10-17"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "384000"
+"MajorChangeTimestamp": "2025-10-17T17:49:06Z"
+"MlsStatus": "New"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2025-10-17T17:49:06Z"
+"OriginalListPrice": 2350.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3147692"
+"ParcelNumber": "237100262"
+"ParkingFeatures": "Surface"
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [
0 => "No"
]
+"PhotosChangeTimestamp": "2025-10-17T17:49:06Z"
+"RentIncludes": array:7 [
0 => "Building Insurance"
1 => "Building Maintenance"
2 => "Common Elements"
3 => "Exterior Maintenance"
4 => "Heat"
5 => "High Speed Internet"
6 => "Parking"
]
+"ShowingRequirements": array:1 [
0 => "Go Direct"
]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "E"
+"StreetName": "Northfield"
+"StreetNumber": "251"
+"StreetSuffix": "Drive"
+"TransactionBrokerCompensation": "1/2 Month's Rent + HST"
+"TransactionType": "For Lease"
+"UnitNumber": "402"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "East"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12468793')"
+"GarageType": "None"
+"HeatSource": "Gas"
+"RollNumber": "301601000104158"
+"SurveyType": "Unknown"
+"BalconyType": "Open"
+"LegalStories": "4"
+"ParkingType1": "Owned"
+"CreditCheckYN": true
+"KitchensTotal": 1
+"ParkingSpaces": 1
+"provider_name": "TRREB"
+"ApproximateAge": "0-5"
+"ContractStatus": "Available"
+"PossessionDate": "2025-11-01"
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 2
+"CondoCorpNumber": 710
+"DepositRequired": true
+"LivingAreaRange": "800-899"
+"RoomsAboveGrade": 6
+"LeaseAgreementYN": true
+"SquareFootSource": "Builder"
+"ParkingLevelUnit1": "32"
+"PrivateEntranceYN": true
+"WashroomsType1Pcs": 4
+"BedroomsAboveGrade": 2
+"EmploymentLetterYN": true
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [
0 => "Unknown"
]
+"RentalApplicationYN": true
+"WashroomsType1Level": "Main"
+"LegalApartmentNumber": "16"
+"MediaChangeTimestamp": "2025-10-17T17:49:06Z"
+"PortionPropertyLease": array:1 [
0 => "Main"
]
+"ReferencesRequiredYN": true
+"PropertyManagementCompany": "MF PROPERTY MGMT"
+"SystemModificationTimestamp": "2025-11-11T02:23:41.938494Z"
+"Media": array:21 [
0 => array:26 [ …26]
1 => array:26 [ …26]
2 => array:26 [ …26]
3 => array:26 [ …26]
4 => array:26 [ …26]
5 => array:26 [ …26]
6 => array:26 [ …26]
7 => array:26 [ …26]
8 => array:26 [ …26]
9 => array:26 [ …26]
10 => array:26 [ …26]
11 => array:26 [ …26]
12 => array:26 [ …26]
13 => array:26 [ …26]
14 => array:26 [ …26]
15 => array:26 [ …26]
16 => array:26 [ …26]
17 => array:26 [ …26]
18 => array:26 [ …26]
19 => array:26 [ …26]
20 => array:26 [ …26]
]
+"ID": "594331"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14037
+post_id: "594336"
+post_author: 1
+"ListingKey": "X12468787"
+"ListingId": "X12468787"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-11T02:23:35Z"
+"RFModificationTimestamp": "2025-11-11T02:30:10Z"
+"ListPrice": 1800.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2G 0G5"
+"UnparsedAddress": "25 Wellington Street S 1407, Kitchener, ON N2G 0G5"
+"Coordinates": array:2 [
0 => -80.5017706
1 => 43.4546527
]
+"Latitude": 43.4546527
+"Longitude": -80.5017706
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "CENTURY 21 GREEN REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "A Brand new and never lived in Condo in the heart of Downtown Kitchener. this condo is a full package of convenience , Lifestyle, Comfort and full of amenities. Steps to Public Transit. This offers 1 Bed and 1 Bath unit in a sought out location with a Walk - out balcony. A great opportunity you should not miss at all!!"
+"ArchitecturalStyle": "Apartment"
+"AssociationAmenities": array:4 [
0 => "Elevator"
1 => "Game Room"
2 => "Gym"
3 => "Party Room/Meeting Room"
]
+"Basement": array:1 [
0 => "None"
]
+"BuildingName": "DUO at Station Park"
+"ConstructionMaterials": array:1 [
0 => "Concrete"
]
+"Cooling": "Central Air"
+"Country": "CA"
+"CountyOrParish": "Waterloo"
+"CreationDate": "2025-10-17T18:00:48.331925+00:00"
+"CrossStreet": "Wellington St and King St"
+"Directions": "Wellington St and King St"
+"ExpirationDate": "2026-01-16"
+"Furnished": "Unfurnished"
+"InteriorFeatures": "Carpet Free,Primary Bedroom - Main Floor,Separate Heating Controls"
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [
0 => "In-Suite Laundry"
]
+"LeaseTerm": "12 Months"
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-10-17"
+"MainOfficeKey": "137100"
+"MajorChangeTimestamp": "2025-10-17T17:48:01Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2025-10-17T17:48:01Z"
+"OriginalListPrice": 1800.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3147748"
+"ParkingFeatures": "Underground"
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [
0 => "Yes-with Restrictions"
]
+"PhotosChangeTimestamp": "2025-10-17T17:48:01Z"
+"RentIncludes": array:5 [
0 => "Building Insurance"
1 => "Central Air Conditioning"
2 => "Common Elements"
3 => "Heat"
4 => "Parking"
]
+"ShowingRequirements": array:1 [
0 => "List Salesperson"
]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "S"
+"StreetName": "Wellington"
+"StreetNumber": "25"
+"StreetSuffix": "Street"
+"TransactionBrokerCompensation": "Half Month Rent + HST"
+"TransactionType": "For Lease"
+"UnitNumber": "1407"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "North West"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12468787')"
+"GarageType": "None"
+"HeatSource": "Gas"
+"SurveyType": "Unknown"
+"BalconyType": "Open"
+"HoldoverDays": 90
+"LegalStories": "14 Floor"
+"ParkingType1": "Owned"
+"CreditCheckYN": true
+"KitchensTotal": 1
+"ParkingSpaces": 1
+"provider_name": "TRREB"
+"ApproximateAge": "New"
+"ContractStatus": "Available"
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"CondoCorpNumber": 58
+"DepositRequired": true
+"LivingAreaRange": "500-599"
+"RoomsAboveGrade": 2
+"EnsuiteLaundryYN": true
+"LeaseAgreementYN": true
+"PaymentFrequency": "Monthly"
+"PropertyFeatures": array:4 [
0 => "Arts Centre"
1 => "Clear View"
2 => "Hospital"
3 => "Public Transit"
]
+"SquareFootSource": "Builder"
+"PossessionDetails": "Immediate"
+"PrivateEntranceYN": true
+"WashroomsType1Pcs": 3
+"BedroomsAboveGrade": 1
+"EmploymentLetterYN": true
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [
0 => "Unknown"
]
+"RentalApplicationYN": true
+"WashroomsType1Level": "Flat"
+"LegalApartmentNumber": "1407"
+"MediaChangeTimestamp": "2025-10-17T17:48:01Z"
+"PortionPropertyLease": array:1 [
0 => "Entire Property"
]
+"ReferencesRequiredYN": true
+"PropertyManagementCompany": "Wilson Blanchard"
+"SystemModificationTimestamp": "2025-11-11T02:23:35.906963Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:1 [
0 => array:26 [ …26]
]
+"ID": "594336"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14267
+post_id: "598365"
+post_author: 1
+"ListingKey": "X12468765"
+"ListingId": "X12468765"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-11T02:23:29Z"
+"RFModificationTimestamp": "2025-11-11T02:30:10Z"
+"ListPrice": 895000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Cambridge"
+"PostalCode": "N1S 4L6"
+"UnparsedAddress": "26 Esther Avenue, Cambridge, ON N1S 4L6"
+"Coordinates": array:2 [
0 => -80.335538
1 => 43.374683
]
+"Latitude": 43.374683
+"Longitude": -80.335538
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX TWIN CITY REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Tucked away on a quiet, family-friendly street in desirable West Galt, this 4-bedroom bungaloft invites you to slow down and savour the beauty of everyday living. Sunlight fills the open-concept main floor, where family dinners and late-night conversations happen naturally around the large kitchen island-the heart of the home. Upstairs, your private loft-level primary suite feels like a retreat all its own-a peaceful place to unwind, reflect, and recharge. The finished basement offers endless possibilities-movie nights, a creative studio, or the perfect space for guests. Step outside to your private backyard oasis, complete with a pool, lush gardens, and mature trees that ensure total privacy. It's easy to imagine morning coffee by the pool, lazy weekend afternoons, and starlit evenings that remind you what home should feel like. Set on a pie-shaped lot near top schools, downtown Galt, the Grand River, and scenic walking trails-26 Esther Ave blends comfort, charm, and lifestyle into one unforgettable address."
+"ArchitecturalStyle": "Bungaloft"
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"ConstructionMaterials": array:2 [
0 => "Brick"
1 => "Vinyl Siding"
]
+"Cooling": "Central Air"
+"Country": "CA"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2025-11-02T09:48:47.374347+00:00"
+"CrossStreet": "Blair Rd"
+"DirectionFaces": "West"
+"Directions": "Blair Rd"
+"ExpirationDate": "2025-12-31"
+"ExteriorFeatures": "Porch,Deck,Backs On Green Belt"
+"FireplaceFeatures": array:1 [
0 => "Wood"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"GarageYN": true
+"Inclusions": "Fridge, stove, dishwasher, washer and dryer"
+"InteriorFeatures": "Water Softener"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-10-17"
+"MainOfficeKey": "360900"
+"MajorChangeTimestamp": "2025-11-09T17:11:19Z"
+"MlsStatus": "Price Change"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2025-10-17T17:39:17Z"
+"OriginalListPrice": 959000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3125018"
+"OtherStructures": array:2 [
0 => "Fence - Full"
…1
]
+"ParcelNumber": "226620036"
+"ParkingFeatures": "Private Double"
+"ParkingTotal": "4.0"
+"PhotosChangeTimestamp": "2025-10-18T01:55:33Z"
+"PoolFeatures": "On Ground"
+"PreviousListPrice": 959000.0
+"PriceChangeTimestamp": "2025-11-09T17:11:19Z"
+"Roof": "Asphalt Shingle"
+"Sewer": "Sewer"
+"ShowingRequirements": array:2 [ …2]
+"SignOnPropertyYN": true
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Esther"
+"StreetNumber": "26"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "5929.18"
+"TaxAssessedValue": 406000
+"TaxLegalDescription": "LT 27 PL 1370 CAMBRIDGE; S/T WS557270; CAMBRIDGE"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2%"
+"TransactionType": "For Sale"
+"VirtualTourURLBranded": "https://youriguide.com/26_esther_ave_cambridge_on/"
+"VirtualTourURLBranded2": "https://youtu.be/h Xlx9IMslb M"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/26_esther_ave_cambridge_on/"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 120.48
+"LotShape": "Pie"
+"LotWidth": 39.41
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12468765')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "30060600555204"
+"SurveyType": "None"
+"HoldoverDays": 120
+"KitchensTotal": 1
+"ParkingSpaces": 3
+"UnderContract": array:1 [ …1]
+"provider_name": "TRREB"
+"ApproximateAge": "31-50"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "New"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"LivingAreaRange": "1500-2000"
+"RoomsAboveGrade": 18
+"PropertyFeatures": array:5 [ …5]
+"PossessionDetails": "Flexible"
+"WashroomsType1Pcs": 3
+"WashroomsType2Pcs": 4
+"WashroomsType3Pcs": 4
+"BedroomsAboveGrade": 4
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Basement"
+"WashroomsType2Level": "Main"
+"WashroomsType3Level": "Second"
+"MediaChangeTimestamp": "2025-11-09T17:14:11Z"
+"SystemModificationTimestamp": "2025-11-11T02:23:29.867834Z"
+"Media": array:48 [ …48]
+"ID": "598365"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14263
+post_id: "594428"
+post_author: 1
+"ListingKey": "X12468697"
+"ListingId": "X12468697"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-11T02:23:23Z"
+"RFModificationTimestamp": "2025-11-11T02:37:52Z"
+"ListPrice": 8950000.0
+"BathroomsTotalInteger": 7.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 122.0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Woolwich"
+"PostalCode": "N0B 2B0"
+"UnparsedAddress": "1546 Maryhill Road, Woolwich, ON N0B 2B0"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.5441039
+"Longitude": -80.398422
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "CORCORAN HORIZON REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Experience an extraordinary retreat set on over 120 acres of natural beauty. This custom stone bungalow, spanning 10,454.23 sq. ft., showcases high-quality finishes and thoughtful design. Step into the gourmet kitchen, equipped with Viking Professional appliances, Silestone Quartz surfaces, and striking Douglas fir beams. The dual islands invite gatherings, while the dining area offers seating for 14, overlooking a scenic ponds. High ceilings throughout the home create an open, inviting space, while the use of stone and wood details adds a warm, cozy atmosphere. Hand-chipped stone accents and skylights flood the interior with natural light, enhancing the home's connection to its surroundings. The primary suite opens directly to the swim ponds, offering indoor-outdoor living and a spa-like ensuite with a jacuzzi tub beside a gas fireplace. An indoor grilling area with heated floors offers year-round enjoyment, making it an ideal space for entertaining. The lower level is designed for fun and relaxation, featuring a full bar, billiards area, wine cellar, and a private cinema for movie nights. Outdoors, you'll find two ponds: one with a sandy beach and waterfall, and the other stocked for fishing. A heated, 4,000 sq. ft. exterior building with in-floor heating adds both function and flexibility to this expansive property. Explore the trails, unwind in the sitting areas, and enjoy this ultimate private getaway!"
+"ArchitecturalStyle": "Bungalow"
+"Basement": array:2 [ …2]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "3.0"
+"CreationDate": "2025-11-11T02:32:58.576077+00:00"
+"CrossStreet": "St.Charles St E"
+"DirectionFaces": "North"
+"Directions": "St. Charles St E to Maryhill Rd"
+"ExpirationDate": "2026-04-17"
+"ExteriorFeatures": "Built-In-BBQ,Fishing,Landscape Lighting,Landscaped,Lighting,Patio,Privacy,Recreational Area,Private Pond"
+"FireplaceYN": true
+"FireplacesTotal": "5"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "Built-in Microwave, Carbon Monoxide Detector, Central Vac, Dishwasher, Dryer, Freezer, Garage Door Opener, Gas Oven/Range, Gas Stove, Hot Water Tank Owned, Refrigerator, Washer"
+"InteriorFeatures": "Air Exchanger,Auto Garage Door Remote,Bar Fridge,Built-In Oven,Central Vacuum,Generator - Full,Sauna,Sump Pump,Water Softener,Water Treatment,Workbench"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-10-17"
+"LotSizeSource": "Geo Warehouse"
+"MainOfficeKey": "247700"
+"MajorChangeTimestamp": "2025-10-17T17:20:17Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2025-10-17T17:20:17Z"
+"OriginalListPrice": 8950000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3147028"
+"OtherStructures": array:2 [ …2]
+"ParcelNumber": "222450065"
+"ParkingFeatures": "Circular Drive,Private"
+"ParkingTotal": "25.0"
+"PhotosChangeTimestamp": "2025-10-17T17:20:18Z"
+"PoolFeatures": "Inground"
+"Roof": "Asphalt Shingle"
+"Sewer": "Septic"
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Maryhill"
+"StreetNumber": "1546"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "15978.0"
+"TaxAssessedValue": 2116000
+"TaxLegalDescription": "PT LT 79 GERMAN COMPANY TRACT TWP OF WATERLOO; PT LT 80 GERMAN COMPANY TRACT TWP OF WATERLOO PT 2, 3 & 4, 58R13260; S/T 1532277; T/W 1532277 EXCEPT T/W PT 1, 58R13260; WOOLWICH"
+"TaxYear": "2024"
+"TransactionBrokerCompensation": "2% + HST"
+"TransactionType": "For Sale"
+"View": array:3 [ …3]
+"VirtualTourURLBranded": "https://youriguide.com/1546_maryhill_rd_maryhill_on/"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/1546_maryhill_rd_maryhill_on/"
+"Zoning": "A"
+"UFFI": "No"
+"DDFYN": true
+"Water": "Well"
+"HeatType": "Forced Air"
+"LotDepth": 3131.75
+"LotShape": "Irregular"
+"LotWidth": 464.95
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12468697')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "302903000106800"
+"SurveyType": "Unknown"
+"RentalItems": "Propane Tank"
+"HoldoverDays": 60
+"LaundryLevel": "Main Level"
+"KitchensTotal": 2
+"ParkingSpaces": 20
+"UnderContract": array:1 [ …1]
+"WaterBodyType": "Pond"
+"provider_name": "TRREB"
+"short_address": "Woolwich, ON N0B 2B0, CA"
+"ApproximateAge": "6-15"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 2
+"WashroomsType2": 2
+"WashroomsType3": 1
+"WashroomsType4": 1
+"WashroomsType5": 1
+"CentralVacuumYN": true
+"DenFamilyroomYN": true
+"LivingAreaRange": "5000 +"
+"RoomsAboveGrade": 15
+"RoomsBelowGrade": 9
+"LotSizeAreaUnits": "Acres"
+"PropertyFeatures": array:5 [ …5]
+"LotSizeRangeAcres": "100 +"
+"PossessionDetails": "Flexible"
+"WashroomsType1Pcs": 2
+"WashroomsType2Pcs": 3
+"WashroomsType3Pcs": 4
+"WashroomsType4Pcs": 5
+"WashroomsType5Pcs": 2
+"BedroomsAboveGrade": 4
+"KitchensAboveGrade": 2
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "Listing agent to be present for all showings"
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Main"
+"WashroomsType3Level": "Main"
+"WashroomsType4Level": "Main"
+"WashroomsType5Level": "Basement"
+"MediaChangeTimestamp": "2025-10-17T17:20:18Z"
+"SystemModificationTimestamp": "2025-11-11T02:23:23.83099Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:50 [ …50]
+"ID": "594428"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14264
+post_id: "595820"
+post_author: 1
+"ListingKey": "X12468645"
+"ListingId": "X12468645"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-11T02:23:17Z"
+"RFModificationTimestamp": "2025-11-11T02:37:52Z"
+"ListPrice": 775000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J 2C1"
+"UnparsedAddress": "107 Ellis Crescent S, Waterloo, ON N2J 2C1"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.467371
+"Longitude": -80.504284
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "CENTURY 21 RED STAR REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to this well-maintained, move-in-ready detached corner bungalow ideally located near University Avenue West, Fischer Hallman Road, and the University of Waterloo. This charming home offers comfort, functionality, and excellent income potential, a rare opportunity for families, investors, or first time buyers. Step into a bright and spacious living room with gleaming hardwood floors and a modern, functional kitchen that makes everyday living effortless. The main level features three comfortable bedrooms, a full bathroom, and a sun filled family or sunroom that is perfect for year round enjoyment or relaxation. A separate entrance leads to two fully finished basement spaces, each with its own bedrooms, living area, and washroom. These versatile spaces are ideal for extended family, a home office, or income generating rental options subject to permitted uses. Altogether, the home offers five bedrooms, three living areas, and three full bathrooms, providing ample space for the entire family. Additional highlights include: Full home water filtration system plus separate filters on both floors 3 refrigerators included, Large backyard, perfect for outdoor gatherings or gardening, Private driveway with parking for up to four additional vehicles. Steps away from highway access, shopping, schools, parks, and public transit. This property checks every box location, layout, lifestyle, and long term value. Whether you are an investor seeking high rental potential or a family looking for a peaceful yet convenient neighbourhood, this home is a smart and rewarding choice. Don't miss this opportunity to own in one of Waterloos most desirable areas."
+"ArchitecturalStyle": "Bungalow"
+"AttachedGarageYN": true
+"Basement": array:2 [ …2]
+"CoListOfficeName": "CENTURY 21 RED STAR REALTY INC."
+"CoListOfficePhone": "416-740-5100"
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": "Central Air"
+"CoolingYN": true
+"Country": "CA"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2025-11-11T02:32:52.012442+00:00"
+"CrossStreet": "Bristol/Ellis Cres"
+"DirectionFaces": "South"
+"Directions": "Bristol/Ellis Cres"
+"Exclusions": "Hot Water Tank."
+"ExpirationDate": "2025-12-30"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"HeatingYN": true
+"Inclusions": "All Electrical Light Fixtures and existing appliances, 3 fridges."
+"InteriorFeatures": "In-Law Capability,Primary Bedroom - Main Floor,Carpet Free"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-10-17"
+"LotDimensionsSource": "Other"
+"LotSizeDimensions": "66.00 x 90.00 Feet"
+"LotSizeSource": "MPAC"
+"MainLevelBathrooms": 1
+"MainLevelBedrooms": 2
+"MainOfficeKey": "252100"
+"MajorChangeTimestamp": "2025-10-17T17:09:06Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2025-10-17T17:09:06Z"
+"OriginalListPrice": 775000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3147864"
+"OtherStructures": array:1 [ …1]
+"ParcelNumber": "223460192"
+"ParkingFeatures": "Front Yard Parking"
+"ParkingTotal": "6.0"
+"PhotosChangeTimestamp": "2025-10-17T19:34:38Z"
+"PoolFeatures": "None"
+"Roof": "Asphalt Shingle"
+"RoomsTotal": "10"
+"Sewer": "Sewer"
+"ShowingRequirements": array:1 [ …1]
+"SignOnPropertyYN": true
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "S"
+"StreetName": "Ellis"
+"StreetNumber": "107"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "4008.39"
+"TaxLegalDescription": "Lt 43 Pl 822 City Of Waterloo; Waterloo"
+"TaxYear": "2024"
+"TransactionBrokerCompensation": "2.5%"
+"TransactionType": "For Sale"
+"Zoning": "SR2"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 115.07
+"LotShape": "Irregular"
+"LotWidth": 66.7
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12468645')"
+"PictureYN": true
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "301602055004100"
+"SurveyType": "None"
+"HoldoverDays": 365
+"KitchensTotal": 2
+"ParkingSpaces": 5
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2J 2C1, CA"
+"ApproximateAge": "51-99"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"DenFamilyroomYN": true
+"LivingAreaRange": "1100-1500"
+"RoomsAboveGrade": 5
+"RoomsBelowGrade": 5
+"PropertyFeatures": array:4 [ …4]
+"StreetSuffixCode": "Cres"
+"BoardPropertyType": "Free"
+"LotIrregularities": "101.25 ft x 65.10 x 115.07 x 66.70"
+"LotSizeRangeAcres": "< .50"
+"PossessionDetails": "Immediate"
+"WashroomsType1Pcs": 4
+"WashroomsType2Pcs": 3
+"WashroomsType3Pcs": 3
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"KitchensAboveGrade": 1
+"KitchensBelowGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Basement"
+"WashroomsType3Level": "Main"
+"WashroomsType4Level": "Basement"
+"WashroomsType5Level": "Main"
+"MediaChangeTimestamp": "2025-10-17T19:34:38Z"
+"MLSAreaDistrictOldZone": "X11"
+"MLSAreaMunicipalityDistrict": "Waterloo"
+"SystemModificationTimestamp": "2025-11-11T02:23:17.796067Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:49 [ …49]
+"ID": "595820"
}
]
+success: true
+page_size: 9
+page_count: 7480
+count: 67316
+after_key: ""
}
"RF Response Time" => "0.25 seconds"
]
"RF Cache Key: a08f48a33ae4172ec6249b831fdd24a88bf42b4cbd7f23cc3f65c1adbf12802f" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#14125
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#15351
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12469073"
+"ListingId": "X12469073"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Sale Of Business"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-11T02:24:18Z"
+"RFModificationTimestamp": "2025-11-11T02:29:49Z"
+"ListPrice": 525000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 9500.0
+"City": "Cambridge"
+"PostalCode": "N1R 6J8"
+"UnparsedAddress": "580 Hespeler Road Bldg E, Cambridge, ON N1R 6J8"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.3600536
+"Longitude": -80.3123023
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX HALLMARK REALTY LTD."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Location! Location! Location! ***TURNKEY BUSINESS OPPORTUNITY *** A 9500 SQ. FT stand alone BAR building. Could this be your road to prosperity. The next EVENT CENTRE. Liquor License for over 900 people. 3 floors, 2 dance floors, ONE with a GLASS floor!!! Too much to include. Let us go see this BAR and discover the possibilities. Perfect Opportunity to a NEW owner / investor / manager. Perfect spot for a bar / dance club on the main floor and a hooka lounge on the upper floor. Upper floor dance floor is a glass dance floor open to below. ALL equipment, electronics, kitchen equipment are owned. Owners are selling the opportunity to own and operate a TURNKEY and fully set up and operational bar / food and beverage business location and NOT their specific business or company! Landlord will work with new BUYERS to negotiate a new lease agreement"
+"BuildingAreaUnits": "Square Feet"
+"BusinessType": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"Country": "CA"
+"CountyOrParish": "Waterloo"
+"CreationDate": "2025-11-09T11:09:32.849783+00:00"
+"CrossStreet": "Eagle St. & Hespeler Rd."
+"Directions": "N"
+"Exclusions": "All Liquor, one black colour fridge in kitchen back storeroom."
+"ExpirationDate": "2026-03-12"
+"HoursDaysOfOperation": array:1 [ …1]
+"HoursDaysOfOperationDescription": "22:00 TO 02:00"
+"Inclusions": "All Equipment, All TV and Electronics, CCTV and Security System, All Kitchen equipment"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-10-17"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "259000"
+"MajorChangeTimestamp": "2025-10-17T18:59:23Z"
+"MlsStatus": "New"
+"NumberOfFullTimeEmployees": 10
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2025-10-17T18:59:23Z"
+"OriginalListPrice": 525000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3148056"
+"ParcelNumber": "226430243"
+"PhotosChangeTimestamp": "2025-10-22T19:28:41Z"
+"SeatingCapacity": "930"
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Hespeler"
+"StreetNumber": "580"
+"StreetSuffix": "Road"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "5.00"
+"TransactionType": "For Sale"
+"UnitNumber": "Bldg E"
+"Zoning": "Commercial"
+"DDFYN": true
+"Water": "Municipal"
+"LotType": "Building"
+"TaxType": "TMI"
+"HeatType": "Gas Forced Air Open"
+"LotDepth": 678.52
+"LotWidth": 250.0
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12469073')"
+"ChattelsYN": true
+"GarageType": "Outside/Surface"
+"RetailArea": 9000.0
+"RollNumber": "300615001506750"
+"PropertyUse": "Without Property"
+"RentalItems": "NONE. All chattels and equipment are owned."
+"HoldoverDays": 120
+"ListPriceUnit": "For Sale"
+"provider_name": "TRREB"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"FreestandingYN": true
+"HSTApplication": array:1 [ …1]
+"PossessionDate": "2025-11-01"
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"RetailAreaCode": "Sq Ft"
+"LiquorLicenseYN": true
+"MediaChangeTimestamp": "2025-10-22T19:28:41Z"
+"SystemModificationTimestamp": "2025-11-11T02:24:18.156434Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:33 [ …33]
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#15350
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "N12265771"
+"ListingId": "N12265771"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-11T02:24:14Z"
+"RFModificationTimestamp": "2025-11-11T02:36:11Z"
+"ListPrice": 1499000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Richmond Hill"
+"PostalCode": "L4C 2P3"
+"UnparsedAddress": "460 Balkan Road, Richmond Hill, ON L4C 2P3"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.8843779
+"Longitude": -79.4182964
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "CENTURY 21 ATRIA REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "One of the largest and most desirable detached bungalows in the Crosby area (almost 1,500 sq.ft. with extra bath on main), nestled on a massive 60' x 150' clean lot in the top-ranked Bayview Secondary School district! This fully upgraded home features a large legal addition adding approximately 300 Sq.ft. of extra living space to both the main floor and the basement. The main floor boasts hardwood flooring throughout, with a combined living room, family room and dining area; three bedrooms, including a spacious primary with ensuite; and a modern open-concept kitchen with tall cabinets, stone countertops, a center island, and stainless-steel appliances overlooking a large deck. The fully upgraded basement includes a separate entrance, large family room, two bright bedrooms, and open-concept kitchen with a dining/breakfast area and stainless-steel Appliances. Newer windows, doors, millwork, roof, A/C, Furnace, Roof, flooring, both kitchen, all 3 baths. Enjoy a large and private backyard oasis with a fully equipped in-ground swimming pool. No neighbour at the back for maximum privacy. The oversized driveway accommodates 6-7 cars. Conveniently located near Bayview Ave, shopping (Fresh Co, Walmart, Food Basics, Costco), public transit to Finch Station, and GO Train access to Union Station! Don't miss this rare opportunity to own a true gem in Richmond Hill!"
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:2 [ …2]
+"CityRegion": "Crosby"
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"Country": "CA"
+"CountyOrParish": "York"
+"CreationDate": "2025-11-11T02:29:49.402501+00:00"
+"CrossStreet": "Bayview Ave & Crosby Ave"
+"DirectionFaces": "East"
+"Directions": "Bayview"
+"ExpirationDate": "2025-12-31"
+"FoundationDetails": array:1 [ …1]
+"Inclusions": "Two S/S Stove, Two S/S Fridge, Two S/S Dishwasher, Two S/S Hood-range, White Washer & Dryer, All Existing Electrical Light Fixtures, All Existing Window Coverings."
+"InteriorFeatures": array:4 [ …4]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-07-05"
+"LotSizeSource": "Geo Warehouse"
+"MainOfficeKey": "057600"
+"MajorChangeTimestamp": "2025-08-01T02:00:04Z"
+"MlsStatus": "Price Change"
+"OccupantType": "Owner+Tenant"
+"OriginalEntryTimestamp": "2025-07-06T01:24:51Z"
+"OriginalListPrice": 1599000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft2667538"
+"ParcelNumber": "031770101"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "7.0"
+"PhotosChangeTimestamp": "2025-11-11T02:24:14Z"
+"PoolFeatures": array:1 [ …1]
+"PreviousListPrice": 1599000.0
+"PriceChangeTimestamp": "2025-08-01T02:00:04Z"
+"Roof": array:1 [ …1]
+"Sewer": array:1 [ …1]
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Balkan"
+"StreetNumber": "460"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "6716.08"
+"TaxLegalDescription": "LT 4 PL 4839 RICHMOND HILL ; RICHMOND HILL"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2.5% + HST"
+"TransactionType": "For Sale"
+"VirtualTourURLUnbranded": "https://www.houssmax.ca/vtournb/h9119089"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 150.0
+"LotWidth": 60.0
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('N12265771')"
+"GarageType": "None"
+"HeatSource": "Gas"
+"RollNumber": "193802002003100"
+"SurveyType": "None"
+"HoldoverDays": 120
+"KitchensTotal": 2
+"ParkingSpaces": 7
+"provider_name": "TRREB"
+"short_address": "Richmond Hill, ON L4C 2P3, CA"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionDate": "2025-09-30"
+"PossessionType": "60-89 days"
+"PriorMlsStatus": "New"
+"WashroomsType1": 2
+"WashroomsType2": 1
+"DenFamilyroomYN": true
+"LivingAreaRange": "1100-1500"
+"RoomsAboveGrade": 7
+"RoomsBelowGrade": 5
+"PossessionDetails": "TBA"
+"WashroomsType1Pcs": 3
+"WashroomsType2Pcs": 3
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"KitchensAboveGrade": 1
+"KitchensBelowGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Basement"
+"MediaChangeTimestamp": "2025-11-11T02:24:14Z"
+"SystemModificationTimestamp": "2025-11-11T02:24:17.750649Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:4 [ …4]
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#15349
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12469026"
+"ListingId": "X12469026"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-11T02:24:06Z"
+"RFModificationTimestamp": "2025-11-11T02:37:53Z"
+"ListPrice": 749000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J 3T5"
+"UnparsedAddress": "138 Chelford Crescent, Waterloo, ON N2J 3T5"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.479238
+"Longitude": -80.504803
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "SKILL REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to your dream home! This beautifully updated bungalow Situated on a 62.01 x 120-foot , mature lot in one of Waterloos most desirable neighbourhoods.. This move-in ready home features 3 + 3 Beds and 2 Baths , central air, and shingles (all 2020), updated windows, stylish flooring, and a modern kitchen and bathroom. Bright walk-out basement offers excellent in-law suite potential. Enjoy a mature landscaped yard, ample parking, and AAA condition throughout. A rare find don't miss out!"
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CoolingYN": true
+"Country": "CA"
+"CountyOrParish": "Waterloo"
+"CreationDate": "2025-11-11T02:32:03.471281+00:00"
+"CrossStreet": "Chelford / Meaford"
+"DirectionFaces": "West"
+"Directions": "Chelford / Meaford"
+"ExpirationDate": "2026-03-15"
+"FireplaceYN": true
+"FoundationDetails": array:1 [ …1]
+"HeatingYN": true
+"Inclusions": "Fridge, Stove , washer , Dryer, All existing llight fixtures"
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-10-17"
+"LotDimensionsSource": "Other"
+"LotSizeDimensions": "62.01 x 120.00 Feet"
+"MainLevelBathrooms": 1
+"MainOfficeKey": "245400"
+"MajorChangeTimestamp": "2025-10-17T18:48:39Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2025-10-17T18:48:39Z"
+"OriginalListPrice": 749000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3148360"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "6.0"
+"PhotosChangeTimestamp": "2025-10-17T18:48:39Z"
+"PoolFeatures": array:1 [ …1]
+"Roof": array:1 [ …1]
+"RoomsTotal": "8"
+"Sewer": array:1 [ …1]
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Chelford"
+"StreetNumber": "138"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "3996.0"
+"TaxLegalDescription": "Lt 39 Pl 1195 City Of Waterloo; S/T 324986 City Of Waterloo"
+"TaxYear": "2024"
+"TransactionBrokerCompensation": "2.5% + HST"
+"TransactionType": "For Sale"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 120.0
+"LotWidth": 62.01
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12469026')"
+"PictureYN": true
+"GarageType": "None"
+"HeatSource": "Gas"
+"SurveyType": "Unknown"
+"RentalItems": "Hot water Tank ( If rental )"
+"HoldoverDays": 30
+"KitchensTotal": 1
+"ParkingSpaces": 6
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2J 3T5, CA"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionDate": "2025-11-01"
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"LivingAreaRange": "700-1100"
+"RoomsAboveGrade": 8
+"PropertyFeatures": array:5 [ …5]
+"StreetSuffixCode": "Cres"
+"BoardPropertyType": "Free"
+"WashroomsType1Pcs": 3
+"WashroomsType2Pcs": 3
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 3
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Lower"
+"MediaChangeTimestamp": "2025-10-17T18:48:39Z"
+"MLSAreaDistrictOldZone": "X11"
+"MLSAreaMunicipalityDistrict": "Waterloo"
+"SystemModificationTimestamp": "2025-11-11T02:24:06.088757Z"
+"VendorPropertyInfoStatement": true
+"Media": array:28 [ …28]
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#15348
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12469013"
+"ListingId": "X12469013"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-11T02:24:00Z"
+"RFModificationTimestamp": "2025-11-11T02:37:53Z"
+"ListPrice": 549000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.83
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Sault Ste Marie"
+"PostalCode": "P6A 2G7"
+"UnparsedAddress": "1638 Queen Street E, Sault Ste Marie, ON P6A 2G7"
+"Coordinates": array:2 [ …2]
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "PG DIRECT REALTY LTD."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Visit REALTOR website for additional information. Welcome to 1638 Queen Street East, a charming 3+1 bedroom, 2-bathroom home on a rare 0.83-acre lot in Sault Ste. Marie's East End. This property blends character, comfort, and nature - the perfect retreat in the city. Inside, enjoy an updated kitchen (2020) with modern appliances, a reverse osmosis water system, and hot water on demand. The main floor offers bright living and dining spaces with views of the trees and gardens outside. Upstairs has three bedrooms and a full four-piece bathroom, with seasonal water views from the windows. Public access to the river is just 250m away. The finished basement provides additional living space with a versatile rec room or optional fourth bedroom with a walk-in closet, a three-piece bathroom, a laundry/utility area, and a beautiful stone fireplace that adds warmth and character (requires WETT certification for use). Outdoors, the park-like setting shines with mature maple, birch, oak, serviceberry, and apple trees, raspberry bushes, and gardens throughout. Relax in your cedar wood-fired hot tub, entertain friends and family, or simply enjoy the privacy of your oversized lot. A detached garage, double carport, and versatile bunkie/workshop/she-shed provide extra storage and creative space. Additional features include central air conditioning, a John Deere riding lawn mower (2023) included, and immediate possession available. Located within walking distance to Algoma University, Bellevue Park, and the Sault Ste. Marie Golf Club, and the Hub Trail - with a bike lane at your door - this home combines modern updates, outdoor beauty, and convenience. With over 2,200 sg. ft. of finished living space and endless charm, this Bast End gen is move-in ready and waiting for you!"
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"Country": "CA"
+"CountyOrParish": "Algoma"
+"CoveredSpaces": "2.0"
+"CreationDate": "2025-11-11T02:30:29.794512+00:00"
+"CrossStreet": "Queen St. East & Shannon Rd"
+"DirectionFaces": "North"
+"Directions": "From Shannon Rd, turn left onto Queen St. East"
+"Exclusions": "None"
+"ExpirationDate": "2026-04-17"
+"ExteriorFeatures": array:3 [ …3]
+"FireplaceFeatures": array:3 [ …3]
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "Fridge, Stove, Washer & Dryer, John Dryer, John Deere riding lawn Tractor with Bagger Accessory (2023), Cedar wood-fired, hot tub, Stone PP (as is)"
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-10-17"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "242800"
+"MajorChangeTimestamp": "2025-10-17T18:46:36Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2025-10-17T18:46:36Z"
+"OriginalListPrice": 549000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3147578"
+"OtherStructures": array:1 [ …1]
+"ParcelNumber": "314990066"
+"ParkingFeatures": array:3 [ …3]
+"ParkingTotal": "6.0"
+"PhotosChangeTimestamp": "2025-10-17T18:46:36Z"
+"PoolFeatures": array:1 [ …1]
+"Roof": array:1 [ …1]
+"SecurityFeatures": array:2 [ …2]
+"Sewer": array:1 [ …1]
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "E"
+"StreetName": "Queen"
+"StreetNumber": "1638"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3254.87"
+"TaxLegalDescription": "Lot 16 RCP H700 St. Mary's; Sault Ste. Marie"
+"TaxYear": "2025"
+"Topography": array:3 [ …3]
+"TransactionBrokerCompensation": "1% by Seller $1 by LB"
+"TransactionType": "For Sale"
+"View": array:3 [ …3]
+"Zoning": "R1 Single Detached"
+"DDFYN": true
+"Water": "Municipal"
+"GasYNA": "Yes"
+"CableYNA": "Available"
+"HeatType": "Forced Air"
+"LotDepth": 400.0
+"LotShape": "Rectangular"
+"LotWidth": 100.0
+"SewerYNA": "Yes"
+"WaterYNA": "Yes"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12469013')"
+"GarageType": "Detached"
+"HeatSource": "Gas"
+"RollNumber": "576101003005900"
+"SurveyType": "Unknown"
+"Waterfront": array:1 [ …1]
+"ElectricYNA": "Yes"
+"RentalItems": "Hot water on demand, RO System, Central Air Conditioning"
+"LaundryLevel": "Lower Level"
+"TelephoneYNA": "Available"
+"KitchensTotal": 1
+"ParkingSpaces": 4
+"UnderContract": array:3 [ …3]
+"provider_name": "TRREB"
+"short_address": "Sault Ste Marie, ON P6A 2G7, CA"
+"ApproximateAge": "51-99"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionDate": "2025-11-01"
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"LivingAreaRange": "1100-1500"
+"RoomsAboveGrade": 6
+"RoomsBelowGrade": 2
+"LotSizeAreaUnits": "Acres"
+"PropertyFeatures": array:6 [ …6]
+"LotSizeRangeAcres": ".50-1.99"
+"PossessionDetails": "Immediate Possession"
+"WashroomsType1Pcs": 4
+"WashroomsType2Pcs": 3
+"BedroomsAboveGrade": 3
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Second"
+"WashroomsType2Level": "Basement"
+"MediaChangeTimestamp": "2025-10-17T18:46:36Z"
+"SystemModificationTimestamp": "2025-11-11T02:24:00.049626Z"
+"VendorPropertyInfoStatement": true
+"Media": array:8 [ …8]
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#15347
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12468793"
+"ListingId": "X12468793"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-11T02:23:41Z"
+"RFModificationTimestamp": "2025-11-11T02:30:10Z"
+"ListPrice": 2350.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K 3H4"
+"UnparsedAddress": "251 Northfield Drive E 402, Waterloo, ON N2K 3H4"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4965979
+"Longitude": -80.5472211
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "REAL BROKER ONTARIO LTD."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "**Move-in special: Get half off your first month's rent when you move in on November 1** Welcome to the Blackstone Condos, where chic and convenient urban living awaits you! Step into Unit 402 and immerse yourself in modern charm and style. This spacious 2-bedroom, 2-bathroom condo is well-lit and boasts a carpet-free interior adorned with contemporary finishes, new paint, sleek stainless steel appliances, and stunning quartz countertops throughout. Venture outside the unit and indulge in the building's premier amenities. Stay active in the fitness centre, socialize in the event lounge, find inspiration in the co-working space, and don't forget to experience a summer night with friends on the furnished rooftop terrace complete with an outdoor kitchen! It's also important to mention this building's prime location, as staying here means finding yourself just moments away from vibrant Uptown Waterloo, where a plethora of dining, shopping, and entertainment options await. Conestoga Mall, University of Waterloo, Wilfrid Laurier, Conestoga College, and Kitchener's Innovation District are all within easy reach as well, making this the perfect home for young professionals, and anyone seeking the ultimate urban lifestyle!"
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:1 [ …1]
+"CoListOfficeName": "REAL BROKER ONTARIO LTD."
+"CoListOfficePhone": "888-311-1172"
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"Country": "CA"
+"CountyOrParish": "Waterloo"
+"CreationDate": "2025-10-17T18:00:26.746285+00:00"
+"CrossStreet": "Northfield Drive / Bridge St W"
+"Directions": "Northfield Drive / Bridge St W"
+"ExpirationDate": "2026-04-17"
+"Furnished": "Unfurnished"
+"Inclusions": "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-10-17"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "384000"
+"MajorChangeTimestamp": "2025-10-17T17:49:06Z"
+"MlsStatus": "New"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2025-10-17T17:49:06Z"
+"OriginalListPrice": 2350.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3147692"
+"ParcelNumber": "237100262"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2025-10-17T17:49:06Z"
+"RentIncludes": array:7 [ …7]
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "E"
+"StreetName": "Northfield"
+"StreetNumber": "251"
+"StreetSuffix": "Drive"
+"TransactionBrokerCompensation": "1/2 Month's Rent + HST"
+"TransactionType": "For Lease"
+"UnitNumber": "402"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "East"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12468793')"
+"GarageType": "None"
+"HeatSource": "Gas"
+"RollNumber": "301601000104158"
+"SurveyType": "Unknown"
+"BalconyType": "Open"
+"LegalStories": "4"
+"ParkingType1": "Owned"
+"CreditCheckYN": true
+"KitchensTotal": 1
+"ParkingSpaces": 1
+"provider_name": "TRREB"
+"ApproximateAge": "0-5"
+"ContractStatus": "Available"
+"PossessionDate": "2025-11-01"
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 2
+"CondoCorpNumber": 710
+"DepositRequired": true
+"LivingAreaRange": "800-899"
+"RoomsAboveGrade": 6
+"LeaseAgreementYN": true
+"SquareFootSource": "Builder"
+"ParkingLevelUnit1": "32"
+"PrivateEntranceYN": true
+"WashroomsType1Pcs": 4
+"BedroomsAboveGrade": 2
+"EmploymentLetterYN": true
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"RentalApplicationYN": true
+"WashroomsType1Level": "Main"
+"LegalApartmentNumber": "16"
+"MediaChangeTimestamp": "2025-10-17T17:49:06Z"
+"PortionPropertyLease": array:1 [ …1]
+"ReferencesRequiredYN": true
+"PropertyManagementCompany": "MF PROPERTY MGMT"
+"SystemModificationTimestamp": "2025-11-11T02:23:41.938494Z"
+"Media": array:21 [ …21]
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#15346
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12468787"
+"ListingId": "X12468787"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-11T02:23:35Z"
+"RFModificationTimestamp": "2025-11-11T02:30:10Z"
+"ListPrice": 1800.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2G 0G5"
+"UnparsedAddress": "25 Wellington Street S 1407, Kitchener, ON N2G 0G5"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4546527
+"Longitude": -80.5017706
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "CENTURY 21 GREEN REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "A Brand new and never lived in Condo in the heart of Downtown Kitchener. this condo is a full package of convenience , Lifestyle, Comfort and full of amenities. Steps to Public Transit. This offers 1 Bed and 1 Bath unit in a sought out location with a Walk - out balcony. A great opportunity you should not miss at all!!"
+"ArchitecturalStyle": array:1 [ …1]
+"AssociationAmenities": array:4 [ …4]
+"Basement": array:1 [ …1]
+"BuildingName": "DUO at Station Park"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"Country": "CA"
+"CountyOrParish": "Waterloo"
+"CreationDate": "2025-10-17T18:00:48.331925+00:00"
+"CrossStreet": "Wellington St and King St"
+"Directions": "Wellington St and King St"
+"ExpirationDate": "2026-01-16"
+"Furnished": "Unfurnished"
+"InteriorFeatures": array:3 [ …3]
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"LeaseTerm": "12 Months"
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-10-17"
+"MainOfficeKey": "137100"
+"MajorChangeTimestamp": "2025-10-17T17:48:01Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2025-10-17T17:48:01Z"
+"OriginalListPrice": 1800.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3147748"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2025-10-17T17:48:01Z"
+"RentIncludes": array:5 [ …5]
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "S"
+"StreetName": "Wellington"
+"StreetNumber": "25"
+"StreetSuffix": "Street"
+"TransactionBrokerCompensation": "Half Month Rent + HST"
+"TransactionType": "For Lease"
+"UnitNumber": "1407"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "North West"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12468787')"
+"GarageType": "None"
+"HeatSource": "Gas"
+"SurveyType": "Unknown"
+"BalconyType": "Open"
+"HoldoverDays": 90
+"LegalStories": "14 Floor"
+"ParkingType1": "Owned"
+"CreditCheckYN": true
+"KitchensTotal": 1
+"ParkingSpaces": 1
+"provider_name": "TRREB"
+"ApproximateAge": "New"
+"ContractStatus": "Available"
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"CondoCorpNumber": 58
+"DepositRequired": true
+"LivingAreaRange": "500-599"
+"RoomsAboveGrade": 2
+"EnsuiteLaundryYN": true
+"LeaseAgreementYN": true
+"PaymentFrequency": "Monthly"
+"PropertyFeatures": array:4 [ …4]
+"SquareFootSource": "Builder"
+"PossessionDetails": "Immediate"
+"PrivateEntranceYN": true
+"WashroomsType1Pcs": 3
+"BedroomsAboveGrade": 1
+"EmploymentLetterYN": true
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"RentalApplicationYN": true
+"WashroomsType1Level": "Flat"
+"LegalApartmentNumber": "1407"
+"MediaChangeTimestamp": "2025-10-17T17:48:01Z"
+"PortionPropertyLease": array:1 [ …1]
+"ReferencesRequiredYN": true
+"PropertyManagementCompany": "Wilson Blanchard"
+"SystemModificationTimestamp": "2025-11-11T02:23:35.906963Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:1 [ …1]
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#15345
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12468765"
+"ListingId": "X12468765"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-11T02:23:29Z"
+"RFModificationTimestamp": "2025-11-11T02:30:10Z"
+"ListPrice": 895000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Cambridge"
+"PostalCode": "N1S 4L6"
+"UnparsedAddress": "26 Esther Avenue, Cambridge, ON N1S 4L6"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.374683
+"Longitude": -80.335538
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX TWIN CITY REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Tucked away on a quiet, family-friendly street in desirable West Galt, this 4-bedroom bungaloft invites you to slow down and savour the beauty of everyday living. Sunlight fills the open-concept main floor, where family dinners and late-night conversations happen naturally around the large kitchen island-the heart of the home. Upstairs, your private loft-level primary suite feels like a retreat all its own-a peaceful place to unwind, reflect, and recharge. The finished basement offers endless possibilities-movie nights, a creative studio, or the perfect space for guests. Step outside to your private backyard oasis, complete with a pool, lush gardens, and mature trees that ensure total privacy. It's easy to imagine morning coffee by the pool, lazy weekend afternoons, and starlit evenings that remind you what home should feel like. Set on a pie-shaped lot near top schools, downtown Galt, the Grand River, and scenic walking trails-26 Esther Ave blends comfort, charm, and lifestyle into one unforgettable address."
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:2 [ …2]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"Country": "CA"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2025-11-02T09:48:47.374347+00:00"
+"CrossStreet": "Blair Rd"
+"DirectionFaces": "West"
+"Directions": "Blair Rd"
+"ExpirationDate": "2025-12-31"
+"ExteriorFeatures": array:3 [ …3]
+"FireplaceFeatures": array:1 [ …1]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "Fridge, stove, dishwasher, washer and dryer"
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-10-17"
+"MainOfficeKey": "360900"
+"MajorChangeTimestamp": "2025-11-09T17:11:19Z"
+"MlsStatus": "Price Change"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2025-10-17T17:39:17Z"
+"OriginalListPrice": 959000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3125018"
+"OtherStructures": array:2 [ …2]
+"ParcelNumber": "226620036"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "4.0"
+"PhotosChangeTimestamp": "2025-10-18T01:55:33Z"
+"PoolFeatures": array:1 [ …1]
+"PreviousListPrice": 959000.0
+"PriceChangeTimestamp": "2025-11-09T17:11:19Z"
+"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": "Esther"
+"StreetNumber": "26"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "5929.18"
+"TaxAssessedValue": 406000
+"TaxLegalDescription": "LT 27 PL 1370 CAMBRIDGE; S/T WS557270; CAMBRIDGE"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2%"
+"TransactionType": "For Sale"
+"VirtualTourURLBranded": "https://youriguide.com/26_esther_ave_cambridge_on/"
+"VirtualTourURLBranded2": "https://youtu.be/h Xlx9IMslb M"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/26_esther_ave_cambridge_on/"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 120.48
+"LotShape": "Pie"
+"LotWidth": 39.41
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12468765')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "30060600555204"
+"SurveyType": "None"
+"HoldoverDays": 120
+"KitchensTotal": 1
+"ParkingSpaces": 3
+"UnderContract": array:1 [ …1]
+"provider_name": "TRREB"
+"ApproximateAge": "31-50"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "New"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"LivingAreaRange": "1500-2000"
+"RoomsAboveGrade": 18
+"PropertyFeatures": array:5 [ …5]
+"PossessionDetails": "Flexible"
+"WashroomsType1Pcs": 3
+"WashroomsType2Pcs": 4
+"WashroomsType3Pcs": 4
+"BedroomsAboveGrade": 4
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Basement"
+"WashroomsType2Level": "Main"
+"WashroomsType3Level": "Second"
+"MediaChangeTimestamp": "2025-11-09T17:14:11Z"
+"SystemModificationTimestamp": "2025-11-11T02:23:29.867834Z"
+"Media": array:48 [ …48]
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#15344
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12468697"
+"ListingId": "X12468697"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-11T02:23:23Z"
+"RFModificationTimestamp": "2025-11-11T02:37:52Z"
+"ListPrice": 8950000.0
+"BathroomsTotalInteger": 7.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 122.0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Woolwich"
+"PostalCode": "N0B 2B0"
+"UnparsedAddress": "1546 Maryhill Road, Woolwich, ON N0B 2B0"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.5441039
+"Longitude": -80.398422
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "CORCORAN HORIZON REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Experience an extraordinary retreat set on over 120 acres of natural beauty. This custom stone bungalow, spanning 10,454.23 sq. ft., showcases high-quality finishes and thoughtful design. Step into the gourmet kitchen, equipped with Viking Professional appliances, Silestone Quartz surfaces, and striking Douglas fir beams. The dual islands invite gatherings, while the dining area offers seating for 14, overlooking a scenic ponds. High ceilings throughout the home create an open, inviting space, while the use of stone and wood details adds a warm, cozy atmosphere. Hand-chipped stone accents and skylights flood the interior with natural light, enhancing the home's connection to its surroundings. The primary suite opens directly to the swim ponds, offering indoor-outdoor living and a spa-like ensuite with a jacuzzi tub beside a gas fireplace. An indoor grilling area with heated floors offers year-round enjoyment, making it an ideal space for entertaining. The lower level is designed for fun and relaxation, featuring a full bar, billiards area, wine cellar, and a private cinema for movie nights. Outdoors, you'll find two ponds: one with a sandy beach and waterfall, and the other stocked for fishing. A heated, 4,000 sq. ft. exterior building with in-floor heating adds both function and flexibility to this expansive property. Explore the trails, unwind in the sitting areas, and enjoy this ultimate private getaway!"
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:2 [ …2]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "3.0"
+"CreationDate": "2025-11-11T02:32:58.576077+00:00"
+"CrossStreet": "St.Charles St E"
+"DirectionFaces": "North"
+"Directions": "St. Charles St E to Maryhill Rd"
+"ExpirationDate": "2026-04-17"
+"ExteriorFeatures": array:9 [ …9]
+"FireplaceYN": true
+"FireplacesTotal": "5"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "Built-in Microwave, Carbon Monoxide Detector, Central Vac, Dishwasher, Dryer, Freezer, Garage Door Opener, Gas Oven/Range, Gas Stove, Hot Water Tank Owned, Refrigerator, Washer"
+"InteriorFeatures": array:11 [ …11]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-10-17"
+"LotSizeSource": "Geo Warehouse"
+"MainOfficeKey": "247700"
+"MajorChangeTimestamp": "2025-10-17T17:20:17Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2025-10-17T17:20:17Z"
+"OriginalListPrice": 8950000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3147028"
+"OtherStructures": array:2 [ …2]
+"ParcelNumber": "222450065"
+"ParkingFeatures": array:2 [ …2]
+"ParkingTotal": "25.0"
+"PhotosChangeTimestamp": "2025-10-17T17:20:18Z"
+"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": "Maryhill"
+"StreetNumber": "1546"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "15978.0"
+"TaxAssessedValue": 2116000
+"TaxLegalDescription": "PT LT 79 GERMAN COMPANY TRACT TWP OF WATERLOO; PT LT 80 GERMAN COMPANY TRACT TWP OF WATERLOO PT 2, 3 & 4, 58R13260; S/T 1532277; T/W 1532277 EXCEPT T/W PT 1, 58R13260; WOOLWICH"
+"TaxYear": "2024"
+"TransactionBrokerCompensation": "2% + HST"
+"TransactionType": "For Sale"
+"View": array:3 [ …3]
+"VirtualTourURLBranded": "https://youriguide.com/1546_maryhill_rd_maryhill_on/"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/1546_maryhill_rd_maryhill_on/"
+"Zoning": "A"
+"UFFI": "No"
+"DDFYN": true
+"Water": "Well"
+"HeatType": "Forced Air"
+"LotDepth": 3131.75
+"LotShape": "Irregular"
+"LotWidth": 464.95
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12468697')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "302903000106800"
+"SurveyType": "Unknown"
+"RentalItems": "Propane Tank"
+"HoldoverDays": 60
+"LaundryLevel": "Main Level"
+"KitchensTotal": 2
+"ParkingSpaces": 20
+"UnderContract": array:1 [ …1]
+"WaterBodyType": "Pond"
+"provider_name": "TRREB"
+"short_address": "Woolwich, ON N0B 2B0, CA"
+"ApproximateAge": "6-15"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 2
+"WashroomsType2": 2
+"WashroomsType3": 1
+"WashroomsType4": 1
+"WashroomsType5": 1
+"CentralVacuumYN": true
+"DenFamilyroomYN": true
+"LivingAreaRange": "5000 +"
+"RoomsAboveGrade": 15
+"RoomsBelowGrade": 9
+"LotSizeAreaUnits": "Acres"
+"PropertyFeatures": array:5 [ …5]
+"LotSizeRangeAcres": "100 +"
+"PossessionDetails": "Flexible"
+"WashroomsType1Pcs": 2
+"WashroomsType2Pcs": 3
+"WashroomsType3Pcs": 4
+"WashroomsType4Pcs": 5
+"WashroomsType5Pcs": 2
+"BedroomsAboveGrade": 4
+"KitchensAboveGrade": 2
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "Listing agent to be present for all showings"
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Main"
+"WashroomsType3Level": "Main"
+"WashroomsType4Level": "Main"
+"WashroomsType5Level": "Basement"
+"MediaChangeTimestamp": "2025-10-17T17:20:18Z"
+"SystemModificationTimestamp": "2025-11-11T02:23:23.83099Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:50 [ …50]
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#15343
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12468645"
+"ListingId": "X12468645"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-11T02:23:17Z"
+"RFModificationTimestamp": "2025-11-11T02:37:52Z"
+"ListPrice": 775000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J 2C1"
+"UnparsedAddress": "107 Ellis Crescent S, Waterloo, ON N2J 2C1"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.467371
+"Longitude": -80.504284
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "CENTURY 21 RED STAR REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to this well-maintained, move-in-ready detached corner bungalow ideally located near University Avenue West, Fischer Hallman Road, and the University of Waterloo. This charming home offers comfort, functionality, and excellent income potential, a rare opportunity for families, investors, or first time buyers. Step into a bright and spacious living room with gleaming hardwood floors and a modern, functional kitchen that makes everyday living effortless. The main level features three comfortable bedrooms, a full bathroom, and a sun filled family or sunroom that is perfect for year round enjoyment or relaxation. A separate entrance leads to two fully finished basement spaces, each with its own bedrooms, living area, and washroom. These versatile spaces are ideal for extended family, a home office, or income generating rental options subject to permitted uses. Altogether, the home offers five bedrooms, three living areas, and three full bathrooms, providing ample space for the entire family. Additional highlights include: Full home water filtration system plus separate filters on both floors 3 refrigerators included, Large backyard, perfect for outdoor gatherings or gardening, Private driveway with parking for up to four additional vehicles. Steps away from highway access, shopping, schools, parks, and public transit. This property checks every box location, layout, lifestyle, and long term value. Whether you are an investor seeking high rental potential or a family looking for a peaceful yet convenient neighbourhood, this home is a smart and rewarding choice. Don't miss this opportunity to own in one of Waterloos most desirable areas."
+"ArchitecturalStyle": array:1 [ …1]
+"AttachedGarageYN": true
+"Basement": array:2 [ …2]
+"CoListOfficeName": "CENTURY 21 RED STAR REALTY INC."
+"CoListOfficePhone": "416-740-5100"
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CoolingYN": true
+"Country": "CA"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2025-11-11T02:32:52.012442+00:00"
+"CrossStreet": "Bristol/Ellis Cres"
+"DirectionFaces": "South"
+"Directions": "Bristol/Ellis Cres"
+"Exclusions": "Hot Water Tank."
+"ExpirationDate": "2025-12-30"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"HeatingYN": true
+"Inclusions": "All Electrical Light Fixtures and existing appliances, 3 fridges."
+"InteriorFeatures": array:3 [ …3]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-10-17"
+"LotDimensionsSource": "Other"
+"LotSizeDimensions": "66.00 x 90.00 Feet"
+"LotSizeSource": "MPAC"
+"MainLevelBathrooms": 1
+"MainLevelBedrooms": 2
+"MainOfficeKey": "252100"
+"MajorChangeTimestamp": "2025-10-17T17:09:06Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2025-10-17T17:09:06Z"
+"OriginalListPrice": 775000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3147864"
+"OtherStructures": array:1 [ …1]
+"ParcelNumber": "223460192"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "6.0"
+"PhotosChangeTimestamp": "2025-10-17T19:34:38Z"
+"PoolFeatures": array:1 [ …1]
+"Roof": array:1 [ …1]
+"RoomsTotal": "10"
+"Sewer": array:1 [ …1]
+"ShowingRequirements": array:1 [ …1]
+"SignOnPropertyYN": true
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "S"
+"StreetName": "Ellis"
+"StreetNumber": "107"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "4008.39"
+"TaxLegalDescription": "Lt 43 Pl 822 City Of Waterloo; Waterloo"
+"TaxYear": "2024"
+"TransactionBrokerCompensation": "2.5%"
+"TransactionType": "For Sale"
+"Zoning": "SR2"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 115.07
+"LotShape": "Irregular"
+"LotWidth": 66.7
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12468645')"
+"PictureYN": true
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "301602055004100"
+"SurveyType": "None"
+"HoldoverDays": 365
+"KitchensTotal": 2
+"ParkingSpaces": 5
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2J 2C1, CA"
+"ApproximateAge": "51-99"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"DenFamilyroomYN": true
+"LivingAreaRange": "1100-1500"
+"RoomsAboveGrade": 5
+"RoomsBelowGrade": 5
+"PropertyFeatures": array:4 [ …4]
+"StreetSuffixCode": "Cres"
+"BoardPropertyType": "Free"
+"LotIrregularities": "101.25 ft x 65.10 x 115.07 x 66.70"
+"LotSizeRangeAcres": "< .50"
+"PossessionDetails": "Immediate"
+"WashroomsType1Pcs": 4
+"WashroomsType2Pcs": 3
+"WashroomsType3Pcs": 3
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"KitchensAboveGrade": 1
+"KitchensBelowGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Basement"
+"WashroomsType3Level": "Main"
+"WashroomsType4Level": "Basement"
+"WashroomsType5Level": "Main"
+"MediaChangeTimestamp": "2025-10-17T19:34:38Z"
+"MLSAreaDistrictOldZone": "X11"
+"MLSAreaMunicipalityDistrict": "Waterloo"
+"SystemModificationTimestamp": "2025-11-11T02:23:17.796067Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:49 [ …49]
}
]
+success: true
+page_size: 9
+page_count: 7480
+count: 67316
+after_key: ""
}
]
]