array:2 [
"RF Cache Key: 8dc213495af6a34472a05d754ba7c9bfc4ef7be27df34cb122745962840e1f44" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#4244
+items: array:10 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4031
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12125986"
+"ListingId": "X12125986"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-05-07T14:38:30Z"
+"RFModificationTimestamp": "2025-05-07T14:56:15.781402+00:00"
+"ListPrice": 507000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 3W9"
+"UnparsedAddress": "#n608 - 330 Phillip Street, Waterloo, On N2l 3w9"
+"Coordinates": array:2 [
0 => -80.5391944
1 => 43.4759775
]
+"Latitude": 43.4759775
+"Longitude": -80.5391944
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RED AND WHITE REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "ATTENTION Investors & Parents! Excellent opportunity to own a premium unit in the luxurious ICON 330 building, which is the most desirable student living in Waterloo close to the University of Waterloo, Wilfred Laurier, and Conestoga College Waterloo campus. VACANT 6th Floor unit ensures you get full current market value rent, while allowing the flexibility for your own student to move in if necessary. The convenience of the 6th floor means you get use of all the elevator's, can walk through the building to either tower, balcony, and still have a great window view of the city. ONE BED + DEN UNIT with High End Finishes are sure to impress!!! The functional layout creates a feeling of openness making the space feel much more useful. The state-of-the-art condo amenities include: Fitness Centre, Basketball Court, FREE WIFI Study Area, Rooftop Patio, Movie Theatre, Yoga Studio, Sauna, Media Room/Movie Theatre, 24/7 Monitored Security, Cafe & Business Lounge with Fireplace. The unit itself has top quality finishes including Stainless Steel kitchen appliances, Laminate Floors, In-Suite Washer & Dryer and floor to ceiling Windows. Rental parking spaces are sometimes available through the property management company. This unit comes fully Furnished including Beds, Bedside Tables, Desks & Chairs, 42" Wall-mounted TVs, Sofa, Bar Stools and Coffee Table. Once again this desirable and trendy unit is walking distance to University of Waterloo, Wilfrid Laurier University, Public Transit, Light Rail Transit, Waterloo University Plaza and T&T Supermarket."
+"ArchitecturalStyle": array:1 [
0 => "Apartment"
]
+"AssociationAmenities": array:6 [
0 => "Concierge"
1 => "Exercise Room"
2 => "Elevator"
3 => "Gym"
4 => "Media Room"
5 => "Recreation Room"
]
+"AssociationFee": "283.08"
+"AssociationFeeIncludes": array:2 [
0 => "Building Insurance Included"
1 => "Common Elements Included"
]
+"Basement": array:1 [
0 => "None"
]
+"ConstructionMaterials": array:1 [
0 => "Concrete Poured"
]
+"Cooling": array:1 [
0 => "Central Air"
]
+"CountyOrParish": "Waterloo"
+"CreationDate": "2025-05-05T23:15:59.643539+00:00"
+"CrossStreet": "Columbia St W"
+"Directions": "Columbia --> Phillip St"
+"Exclusions": "None"
+"ExpirationDate": "2025-08-31"
+"ExteriorFeatures": array:2 [
0 => "Lighting"
1 => "Year Round Living"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"GarageYN": true
+"Inclusions": "Dryer, Microwave, Refrigerator, Stove, 2 beds, desks, tv's, a couch, coffee table, tv console, and 2 bar stools"
+"InteriorFeatures": array:1 [
0 => "Water Heater"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [
0 => "In-Suite Laundry"
]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-05-05"
+"LotSizeSource": "Geo Warehouse"
+"MainOfficeKey": "359200"
+"MajorChangeTimestamp": "2025-05-05T22:59:25Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2025-05-05T22:59:25Z"
+"OriginalListPrice": 507000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft2338818"
+"ParcelNumber": "236270194"
+"ParkingFeatures": array:1 [
0 => "Underground"
]
+"PetsAllowed": array:1 [
0 => "Restricted"
]
+"PhotosChangeTimestamp": "2025-05-05T22:59:26Z"
+"Roof": array:1 [
0 => "Flat"
]
+"SecurityFeatures": array:2 [
0 => "Concierge/Security"
1 => "Smoke Detector"
]
+"ShowingRequirements": array:3 [
0 => "Lockbox"
1 => "See Brokerage Remarks"
2 => "Showing System"
]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Phillip"
+"StreetNumber": "330"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3092.19"
+"TaxAssessedValue": 243000
+"TaxYear": "2024"
+"Topography": array:2 [
0 => "Dry"
1 => "Flat"
]
+"TransactionBrokerCompensation": "2.0%+HST"
+"TransactionType": "For Sale"
+"UnitNumber": "N608"
+"View": array:3 [
0 => "City"
1 => "Downtown"
2 => "Skyline"
]
+"Zoning": "RES"
+"UFFI": "No"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "North"
+"HeatType": "Forced Air"
+"LotShape": "Rectangular"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12125986')"
+"ElevatorYN": true
+"GarageType": "Underground"
+"HeatSource": "Other"
+"RollNumber": "301604350000966"
+"SurveyType": "Unknown"
+"BalconyType": "Open"
+"RentalItems": "None"
+"HoldoverDays": 60
+"LaundryLevel": "Main Level"
+"LegalStories": "5"
+"ParkingType1": "Rental"
+"WaterMeterYN": true
+"KitchensTotal": 1
+"provider_name": "TRREB"
+"ApproximateAge": "6-10"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [
0 => "Included In"
]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"CondoCorpNumber": 627
+"LivingAreaRange": "500-599"
+"RoomsAboveGrade": 4
+"RoomsBelowGrade": 1
+"EnsuiteLaundryYN": true
+"PropertyFeatures": array:6 [
0 => "Arts Centre"
1 => "Library"
2 => "Park"
3 => "Public Transit"
4 => "School"
5 => "Place Of Worship"
]
+"SquareFootSource": "Owner"
+"PossessionDetails": "Flexible"
+"WashroomsType1Pcs": 3
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [
0 => "Unknown"
]
+"ShowingAppointments": "SHOWING TIME ONLY"
+"StatusCertificateYN": true
+"WashroomsType1Level": "Main"
+"LegalApartmentNumber": "11"
+"MediaChangeTimestamp": "2025-05-05T22:59:26Z"
+"DevelopmentChargesPaid": array:1 [
0 => "Yes"
]
+"PropertyManagementCompany": "Craft Property Management"
+"SystemModificationTimestamp": "2025-05-07T14:38:31.344884Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:46 [
0 => array:26 [ …26]
1 => array:26 [ …26]
2 => array:26 [ …26]
3 => array:26 [ …26]
4 => array:26 [ …26]
5 => array:26 [ …26]
6 => array:26 [ …26]
7 => array:26 [ …26]
8 => array:26 [ …26]
9 => array:26 [ …26]
10 => array:26 [ …26]
11 => array:26 [ …26]
12 => array:26 [ …26]
13 => array:26 [ …26]
14 => array:26 [ …26]
15 => array:26 [ …26]
16 => array:26 [ …26]
17 => array:26 [ …26]
18 => array:26 [ …26]
19 => array:26 [ …26]
20 => array:26 [ …26]
21 => array:26 [ …26]
22 => array:26 [ …26]
23 => array:26 [ …26]
24 => array:26 [ …26]
25 => array:26 [ …26]
26 => array:26 [ …26]
27 => array:26 [ …26]
28 => array:26 [ …26]
29 => array:26 [ …26]
30 => array:26 [ …26]
31 => array:26 [ …26]
32 => array:26 [ …26]
33 => array:26 [ …26]
34 => array:26 [ …26]
35 => array:26 [ …26]
36 => array:26 [ …26]
37 => array:26 [ …26]
38 => array:26 [ …26]
39 => array:26 [ …26]
40 => array:26 [ …26]
41 => array:26 [ …26]
42 => array:26 [ …26]
43 => array:26 [ …26]
44 => array:26 [ …26]
45 => array:26 [ …26]
]
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4030
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12125377"
+"ListingId": "X12125377"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-05-07T00:23:41Z"
+"RFModificationTimestamp": "2025-05-07T04:38:44.866002+00:00"
+"ListPrice": 479900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 3R2"
+"UnparsedAddress": "#g510 - 275 Larch Street, Waterloo, On N2l 3r2"
+"Coordinates": array:2 [
0 => -80.5309208
1 => 43.47677
]
+"Latitude": 43.47677
+"Longitude": -80.5309208
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "HOMELIFE/MIRACLE REALTY LTD"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Turnkey Investment or Ideal Student Residence! Fully furnished 2-bedroom, 2-bath condo just minutes from Wilfrid Laurier University, University of Waterloo, and Conestoga College. Bright and modern layout featuring high ceilings, a stylish kitchen with stainless steel appliances (fridge, stove, microwave), and convenient en-suite laundry with front-loading washer and dryer. Unit comes fully equipped with flat-screen TV, TV stand, coffee table, side table, sofa, two beds, and two desks with chairs perfect for students or young professionals. Strong rental potential with current market rents around $2,200/month. Excellent opportunity for investors or parents looking for a secure and well-located space for their child's university years."
+"ArchitecturalStyle": array:1 [
0 => "Apartment"
]
+"AssociationFee": "383.47"
+"AssociationFeeIncludes": array:5 [
0 => "CAC Included"
1 => "Common Elements Included"
2 => "Heat Included"
3 => "Building Insurance Included"
4 => "Water Included"
]
+"AssociationYN": true
+"Basement": array:1 [
0 => "None"
]
+"ConstructionMaterials": array:1 [
0 => "Brick"
]
+"Cooling": array:1 [
0 => "Central Air"
]
+"CoolingYN": true
+"Country": "CA"
+"CountyOrParish": "Waterloo"
+"CreationDate": "2025-05-05T21:57:58.515171+00:00"
+"CrossStreet": "Hickory St W / Hemlock"
+"Directions": "East side of Larch St."
+"ExpirationDate": "2025-07-04"
+"HeatingYN": true
+"InteriorFeatures": array:1 [
0 => "Carpet Free"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [
0 => "Ensuite"
]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-05-05"
+"MainLevelBedrooms": 1
+"MainOfficeKey": "406000"
+"MajorChangeTimestamp": "2025-05-05T19:20:53Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2025-05-05T19:20:53Z"
+"OriginalListPrice": 479900.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft2336484"
+"ParkingFeatures": array:1 [
0 => "None"
]
+"PetsAllowed": array:1 [
0 => "Restricted"
]
+"PhotosChangeTimestamp": "2025-05-05T19:20:53Z"
+"PropertyAttachedYN": true
+"RoomsTotal": "6"
+"ShowingRequirements": array:1 [
0 => "Lockbox"
]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Larch"
+"StreetNumber": "275"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2570.46"
+"TaxBookNumber": "301604270001326"
+"TaxYear": "2024"
+"TransactionBrokerCompensation": "2.5% + hst"
+"TransactionType": "For Sale"
+"UnitNumber": "G510"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "South"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12125377')"
+"PictureYN": true
+"GarageType": "None"
+"HeatSource": "Gas"
+"RollNumber": "301604270001326"
+"SurveyType": "None"
+"BalconyType": "None"
+"HoldoverDays": 90
+"LegalStories": "6"
+"ParkingType1": "None"
+"KitchensTotal": 1
+"provider_name": "TRREB"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [
0 => "Included In"
]
+"PossessionDate": "2025-05-06"
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"CondoCorpNumber": 643
+"DenFamilyroomYN": true
+"LivingAreaRange": "600-699"
+"RoomsAboveGrade": 6
+"SquareFootSource": "Builder"
+"StreetSuffixCode": "St"
+"BoardPropertyType": "Condo"
+"WashroomsType1Pcs": 3
+"WashroomsType2Pcs": 4
+"BedroomsAboveGrade": 2
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [
0 => "Unknown"
]
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Main"
+"LegalApartmentNumber": "46"
+"MediaChangeTimestamp": "2025-05-07T00:23:40Z"
+"MLSAreaDistrictOldZone": "X11"
+"PropertyManagementCompany": "CMC Condo Management Corporation"
+"MLSAreaMunicipalityDistrict": "Waterloo"
+"SystemModificationTimestamp": "2025-05-07T00:23:42.613388Z"
+"Media": array:13 [
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]
]
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4004
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12076885"
+"ListingId": "X12076885"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Sale Of Business"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-05-06T13:11:30Z"
+"RFModificationTimestamp": "2025-05-06T13:25:46.229066+00:00"
+"ListPrice": 159000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 1227.0
+"City": "Waterloo"
+"PostalCode": "N2T 0A8"
+"UnparsedAddress": "#108 - 646 Erb Street, Cambridge, On N2t 0a8"
+"Coordinates": array:2 [
0 => -80.5707931
1 => 43.4467391
]
+"Latitude": 43.4467391
+"Longitude": -80.5707931
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "ROYAL LEPAGE MEADOWTOWNE REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Prime Investment Opportunity in Waterloo TMs West End!Presenting Unit 108 at 646 Erb Street West, a high-visibility, street-level commercial condo, currently tenanted by Freshii. Situated in the bustling West Quarter Plaza, this unit provides excellent exposure, consistent foot traffic, and abundant parking, making it an attractive location for any investor.This professionally managed complex is surrounded by thriving businesses and established residential communities such as Beechwood West, ensuring long-term value. The property offers an ideal opportunity for steady cash flow, with the potential for growth and rebranding should you wish to take over the existing Freshii franchise or transition to a new concept.Key Features:Location: 646 Erb Street West, Waterloo Tenant: Freshii (with an option to take over or rebrand)Lease Expiry: May 2026, with a 5-year renewal option Rent: $6,043 per month (including HST)Parking: Ample parking for customers Foot Traffic: High exposure and steady customer flow from surrounding businesses and residential areas Access: Easy access to public transit and major routes This is a turnkey investment opportunity for those seeking stable cash flow and long-term growth in a prime location. Sales Information available upon request.Don't miss out on this exceptional investment opportunity in the heart of Waterloo's West End!"
+"BuildingAreaUnits": "Square Feet"
+"BusinessType": array:1 [
0 => "Fast Food/Takeout"
]
+"Cooling": array:1 [
0 => "Yes"
]
+"CountyOrParish": "Waterloo"
+"CreationDate": "2025-04-13T08:25:05.634911+00:00"
+"CrossStreet": "ERB ST W AND ERBSVILLE RD"
+"Directions": "ERB ST W AND ERBSVILLE RD"
+"ExpirationDate": "2025-07-11"
+"HoursDaysOfOperationDescription": "7 Days a week 10:30am-8pm"
+"Inclusions": "Chattels, all equipment and smallware"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-04-11"
+"MainOfficeKey": "108800"
+"MajorChangeTimestamp": "2025-05-06T13:11:30Z"
+"MlsStatus": "Price Change"
+"NumberOfFullTimeEmployees": 4
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2025-04-11T13:32:22Z"
+"OriginalListPrice": 229000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft2225522"
+"PhotosChangeTimestamp": "2025-04-11T13:32:22Z"
+"PreviousListPrice": 229000.0
+"PriceChangeTimestamp": "2025-05-06T13:11:29Z"
+"SeatingCapacity": "12"
+"SecurityFeatures": array:1 [
0 => "Yes"
]
+"ShowingRequirements": array:1 [
0 => "Showing System"
]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "W"
+"StreetName": "Erb"
+"StreetNumber": "646"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "11854.52"
+"TaxYear": "2024"
+"TransactionBrokerCompensation": "5% of the sale price"
+"TransactionType": "For Sale"
+"UnitNumber": "108"
+"Utilities": array:1 [
0 => "Yes"
]
+"Zoning": "Commerical"
+"Rail": "No"
+"DDFYN": true
+"Water": "Municipal"
+"LotType": "Unit"
+"TaxType": "Annual"
+"HeatType": "Gas Forced Air Closed"
+"LotShape": "Irregular"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12076885')"
+"ChattelsYN": true
+"GarageType": "None"
+"RetailArea": 1225.0
+"FranchiseYN": true
+"PropertyUse": "Without Property"
+"HoldoverDays": 90
+"ListPriceUnit": "For Sale"
+"provider_name": "TRREB"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [
0 => "In Addition To"
]
+"PossessionType": "Immediate"
+"PriorMlsStatus": "New"
+"RetailAreaCode": "Sq Ft"
+"PossessionDetails": "TBD"
+"MediaChangeTimestamp": "2025-04-11T13:32:22Z"
+"SystemModificationTimestamp": "2025-05-06T13:11:30.156925Z"
+"FinancialStatementAvailableYN": true
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:6 [
0 => array:26 [ …26]
1 => array:26 [ …26]
2 => array:26 [ …26]
3 => array:26 [ …26]
4 => array:26 [ …26]
5 => array:26 [ …26]
]
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4007
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12122888"
+"ListingId": "X12122888"
+"PropertyType": "Residential"
+"PropertySubType": "Common Element Condo"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-05-05T19:09:52Z"
+"RFModificationTimestamp": "2025-05-05T22:07:18.522193+00:00"
+"ListPrice": 480000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J 4T2"
+"UnparsedAddress": "#411 - 30 Blue Springs Drive, Waterloo, On N2j 4t2"
+"Coordinates": array:2 [
0 => -80.5245166
1 => 43.4876478
]
+"Latitude": 43.4876478
+"Longitude": -80.5245166
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX WEST REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Discover the perfect blend of tranquility & convenience in this sought-after building, ideally located near Uptown Waterloo. Near an abundance of restaurants, shops, and amenities including Conestoga Mall & 3 grocery stores that are within a few minutes walk. West-facing view to enjoy stunning sunsets & warm, natural sunlight throughout the day. Nestled around kilometers of trails, ponds & streams. Close to the expressway, Conestoga College & both U of W & Wilfrid Laurier Universities. Conveniently located near the LRT station & a bus stop at King & Blue Springs Dr make commuting a breeze. Near the charming town of St. Jacob's & its famous Farmer's Market & Waterloo Park, perfect for outdoor activities & relaxation. This spacious condo boasts floor-to-ceiling window in the living room, providing beautiful views of the surrounding area. Enjoy new flooring throughout, an efficient galley kitchen, new stove, ample counter space & storage, a separate dining area, 2 generously sized bedrooms, & 2 full baths. Also includes in-suite laundry, allowing for ultimate convenience. Includes your own storage locker & 1 underground parking, with the option to rent an additional parking spot if needed. Take advantage of a wide range of building amenities, including controlled entry, newly updated balconies, a touch screen directory, elevators, a library, rooftop lounge with sun deck & gas BBQ for residents, a lower level party room to rent for a small fee, both equipped with kitchens & restrooms. The back pond has a pergola & coal BBQ for gatherings. One guest suite for overnight visitors for a fee, and plenty of visitor parking spots, 2 bike storage areas add even more convenience. Make this spacious condo your own with plenty of room to add your personal touches. The possibilities are endless! All measurements as per i Guide."
+"AccessibilityFeatures": array:9 [
0 => "Accessible Public Transit Nearby"
1 => "Elevator"
2 => "Raised Toilet"
3 => "Ramped Entrance"
4 => "Ramps"
5 => "Remote Devices"
6 => "Roll-In Shower"
7 => "Roll-Under Sink"
8 => "Wheelchair Access"
]
+"ArchitecturalStyle": array:1 [
0 => "Apartment"
]
+"AssociationAmenities": array:6 [
0 => "BBQs Allowed"
1 => "Bike Storage"
2 => "Communal Waterfront Area"
3 => "Community BBQ"
4 => "Game Room"
5 => "Gym"
]
+"AssociationFee": "859.03"
+"AssociationFeeIncludes": array:4 [
0 => "Common Elements Included"
1 => "Building Insurance Included"
2 => "Water Included"
3 => "Parking Included"
]
+"Basement": array:1 [
0 => "None"
]
+"BuildingName": "Waterford"
+"ConstructionMaterials": array:1 [
0 => "Brick"
]
+"Cooling": array:1 [
0 => "Central Air"
]
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2025-05-04T17:14:09.747292+00:00"
+"CrossStreet": "Blue Springs Dr and King st N"
+"Directions": "Blue Springs Dr and King st N"
+"Disclosures": array:1 [
0 => "Unknown"
]
+"Exclusions": "All existing appliances, refrigerator, stove, dishwasher, washer & dryer"
+"ExpirationDate": "2025-09-30"
+"ExteriorFeatures": array:2 [
0 => "Fishing"
1 => "Landscaped"
]
+"GarageYN": true
+"Inclusions": "Electrical light fixtures including one (1) ceiling fan, mirrors in bathrooms, window coverings."
+"InteriorFeatures": array:9 [
0 => "Atrium"
1 => "Auto Garage Door Remote"
2 => "Carpet Free"
3 => "Intercom"
4 => "Storage Area Lockers"
5 => "Ventilation System"
6 => "Water Heater"
7 => "Water Meter"
8 => "Wheelchair Access"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [
0 => "In-Suite Laundry"
]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-04-30"
+"MainOfficeKey": "494700"
+"MajorChangeTimestamp": "2025-05-04T15:09:14Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2025-05-04T15:09:14Z"
+"OriginalListPrice": 480000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft2317806"
+"ParcelNumber": "231690100"
+"ParkingFeatures": array:1 [
0 => "Reserved/Assigned"
]
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [
0 => "Restricted"
]
+"PhotosChangeTimestamp": "2025-05-04T20:26:19Z"
+"SecurityFeatures": array:4 [
0 => "Alarm System"
1 => "Carbon Monoxide Detectors"
2 => "Security System"
3 => "Smoke Detector"
]
+"ShowingRequirements": array:1 [
0 => "Lockbox"
]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Blue Springs"
+"StreetNumber": "30"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "2290.0"
+"TaxYear": "2024"
+"TransactionBrokerCompensation": "2%"
+"TransactionType": "For Sale"
+"UnitNumber": "411"
+"View": array:1 [
0 => "Water"
]
+"WaterBodyName": "Four Wells Lake"
+"WaterfrontFeatures": array:1 [
0 => "Other"
]
+"WaterfrontYN": true
+"DDFYN": true
+"Locker": "Owned"
+"Sewage": array:1 [
0 => "Municipal Available"
]
+"Exposure": "East"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12122888')"
+"Shoreline": array:1 [
0 => "Other"
]
+"WaterView": array:1 [
0 => "Unobstructive"
]
+"ElevatorYN": true
+"GarageType": "Underground"
+"HeatSource": "Electric"
+"RollNumber": "301601028600437"
+"SurveyType": "Unknown"
+"Waterfront": array:1 [
0 => "Waterfront Community"
]
+"BalconyType": "Open"
+"DockingType": array:1 [
0 => "None"
]
+"LockerLevel": "basement"
+"RentalItems": "Water Heater"
+"HoldoverDays": 30
+"LaundryLevel": "Main Level"
+"LegalStories": "4"
+"ParkingType1": "Owned"
+"KitchensTotal": 1
+"ParkingSpaces": 1
+"WaterBodyType": "Lake"
+"provider_name": "TRREB"
+"AssessmentYear": 2024
+"ContractStatus": "Available"
+"HSTApplication": array:1 [
0 => "In Addition To"
]
+"PossessionDate": "2025-06-01"
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 2
+"CondoCorpNumber": 169
+"DenFamilyroomYN": true
+"LivingAreaRange": "1000-1199"
+"RoomsAboveGrade": 7
+"AccessToProperty": array:1 [
0 => "Municipal Road"
]
+"AlternativePower": array:1 [
0 => "None"
]
+"EnsuiteLaundryYN": true
+"PropertyFeatures": array:3 [
0 => "Cul de Sac/Dead End"
1 => "Electric Car Charger"
2 => "Waterfront"
]
+"SquareFootSource": "MPAC"
+"PossessionDetails": "Immediate"
+"WashroomsType1Pcs": 4
+"BedroomsAboveGrade": 2
+"KitchensAboveGrade": 1
+"ShorelineAllowance": "None"
+"SpecialDesignation": array:1 [
0 => "Unknown"
]
+"StatusCertificateYN": true
+"WashroomsType1Level": "Main"
+"WaterfrontAccessory": array:1 [
0 => "Not Applicable"
]
+"LegalApartmentNumber": "411"
+"MediaChangeTimestamp": "2025-05-04T20:26:19Z"
+"PropertyManagementCompany": "Sanderson Management Inc."
+"SystemModificationTimestamp": "2025-05-05T19:09:53.562808Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:50 [
0 => array:26 [ …26]
1 => array:26 [ …26]
2 => array:26 [ …26]
3 => array:26 [ …26]
4 => array:26 [ …26]
5 => array:26 [ …26]
6 => array:26 [ …26]
7 => array:26 [ …26]
8 => array:26 [ …26]
9 => array:26 [ …26]
10 => array:26 [ …26]
11 => array:26 [ …26]
12 => array:26 [ …26]
13 => array:26 [ …26]
14 => array:26 [ …26]
15 => array:26 [ …26]
16 => array:26 [ …26]
17 => array:26 [ …26]
18 => array:26 [ …26]
19 => array:26 [ …26]
20 => array:26 [ …26]
21 => array:26 [ …26]
22 => array:26 [ …26]
23 => array:26 [ …26]
24 => array:26 [ …26]
25 => array:26 [ …26]
26 => array:26 [ …26]
27 => array:26 [ …26]
28 => array:26 [ …26]
29 => array:26 [ …26]
30 => array:26 [ …26]
31 => array:26 [ …26]
32 => array:26 [ …26]
33 => array:26 [ …26]
34 => array:26 [ …26]
35 => array:26 [ …26]
36 => array:26 [ …26]
37 => array:26 [ …26]
38 => array:26 [ …26]
39 => array:26 [ …26]
40 => array:26 [ …26]
41 => array:26 [ …26]
42 => array:26 [ …26]
43 => array:26 [ …26]
44 => array:26 [ …26]
45 => array:26 [ …26]
46 => array:26 [ …26]
47 => array:26 [ …26]
48 => array:26 [ …26]
49 => array:26 [ …26]
]
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4032
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12125065"
+"ListingId": "X12125065"
+"PropertyType": "Residential"
+"PropertySubType": "Modular Home"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-05-05T18:07:56Z"
+"RFModificationTimestamp": "2025-05-06T03:38:31.277947+00:00"
+"ListPrice": 139000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J 3Z4"
+"UnparsedAddress": "#21 - 580 Beaver Creek Road, Waterloo, On N2j 3z4"
+"Coordinates": array:2 [
0 => -80.5799088
1 => 43.4724151
]
+"Latitude": 43.4724151
+"Longitude": -80.5799088
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "SOTHEBY'S INTERNATIONAL REALTY CANADA"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome home to 580 Beaver Creek Road Lot #21. This property is quietly located within Green Acre Park Waterloo - minutes from Universities, St. Jacobs, major highways, and Laurel Creek Conservation. This 47x12 Northlander Supreme mobile home features 914 sq. ft. of living space offering one bedroom and one bathroom with an oversized deck that is perfect for a remedy for any relaxing morning. Beautifully maintained, the spacious living and dining room open concept floor plan includes a 10"x32" addition that allows conversion for a second bedroom. The newly painted kitchen includes ample storage with plenty of counter space. The primary bedroom provides built-in wardrobes for extra storage and mirrored closet doors, and the mudroom offers a laundry facility for your convenience. This home also features double paned glass windows for extra insulation and a large hot water heater. The outdoor space features a 10x12 shed and patio area with a fire pit for those evenings to roast marshmallows. The outdoor deck has been power washed and repainted. Enjoy the comforts of 10 MONTHS seasonal living (park closed Jan and Feb) with a turn key home, surrounded by nature, old growth trees and a spacious lot. Green Acre Park features a community swimming pool, hot tubs, a games room, a catch and release fishing pond for plenty of outdoor activities and all of your entertaining needs. This property is the perfect getaway for the ultimate cottage feel with the modern convenience of amenities around the corner. Welcome home to 580 Beaver Creek Road, your new adventure awaits here at Lot 21. Park fee is $11,175.70 for the year including HST and water, $931.31 monthly."
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:1 [
0 => "None"
]
+"ConstructionMaterials": array:1 [
0 => "Aluminum Siding"
]
+"Cooling": array:1 [
0 => "Window Unit(s)"
]
+"CountyOrParish": "Waterloo"
+"CreationDate": "2025-05-05T22:57:49.299349+00:00"
+"CrossStreet": "Conservation Drive"
+"DirectionFaces": "West"
+"Directions": "Hwy 85 to Northfield to Westmount to Conservation Dr to Beaver Creek"
+"ExpirationDate": "2025-10-31"
+"ExteriorFeatures": array:4 [
0 => "Deck"
1 => "Security Gate"
2 => "Recreational Area"
3 => "Seasonal Living"
]
+"FoundationDetails": array:1 [
0 => "Concrete Block"
]
+"Inclusions": "Dryer, Refrigerator, Stove, Washer, Furniture negotiable."
+"InteriorFeatures": array:1 [
0 => "Water Heater Owned"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-05-05"
+"MainOfficeKey": "118900"
+"MajorChangeTimestamp": "2025-05-05T18:07:56Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2025-05-05T18:07:56Z"
+"OriginalListPrice": 139000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft2337660"
+"OtherStructures": array:1 [
0 => "Garden Shed"
]
+"ParkingFeatures": array:2 [
0 => "Private"
1 => "Front Yard Parking"
]
+"ParkingTotal": "1.0"
+"PhotosChangeTimestamp": "2025-05-05T18:07:56Z"
+"PoolFeatures": array:1 [
0 => "Community"
]
+"Roof": array:1 [
0 => "Membrane"
]
+"Sewer": array:1 [
0 => "Septic"
]
+"ShowingRequirements": array:2 [
0 => "Lockbox"
1 => "Showing System"
]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Beaver Creek"
+"StreetNumber": "580"
+"StreetSuffix": "Road"
+"TaxLegalDescription": "Northlander Supreme Serial #490486987"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2"
+"TransactionType": "For Sale"
+"UnitNumber": "21"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12125065')"
+"GarageType": "None"
+"HeatSource": "Propane"
+"SurveyType": "None"
+"Waterfront": array:1 [
0 => "None"
]
+"RentalItems": "Propane Tank"
+"HoldoverDays": 90
+"LaundryLevel": "Main Level"
+"KitchensTotal": 1
+"LeasedLandFee": 11175.7
+"ParkingSpaces": 1
+"UnderContract": array:1 [
0 => "Propane Tank"
]
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2J 3Z4, CA"
+"ApproximateAge": "31-50"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [
0 => "Included In"
]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"LivingAreaRange": "700-1100"
+"RoomsAboveGrade": 6
+"PossessionDetails": "Flexible"
+"WashroomsType1Pcs": 4
+"BedroomsAboveGrade": 1
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [
0 => "Unknown"
]
+"WashroomsType1Level": "Main"
+"MediaChangeTimestamp": "2025-05-05T18:07:56Z"
+"SystemModificationTimestamp": "2025-05-05T18:07:57.296119Z"
+"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]
]
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4033
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12124813"
+"ListingId": "X12124813"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-05-05T17:13:27Z"
+"RFModificationTimestamp": "2025-05-06T06:59:55.303577+00:00"
+"ListPrice": 2000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 3R2"
+"UnparsedAddress": "#g316 - 275 Larch Street, Waterloo, On N2l 3r2"
+"Coordinates": array:2 [
0 => -80.5309208
1 => 43.47677
]
+"Latitude": 43.47677
+"Longitude": -80.5309208
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "KINGSWAY REAL ESTATE"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Modern and fully furnished 2-bedroom, 1-bathroom apartment just a short walk from both the University of Waterloo and Wilfrid Laurier University, perfect for students or young professionals. This bright, open-concept unit features large windows for plenty of natural light, 2 beds with mattresses, 2 desks with chairs, a cozy 3-seater sofa, in-suite laundry, and a dishwasher. All utilities are included, just cover your own internet. Located in the heart of Waterloo, you'll be steps away from grocery stores, restaurants, cafés, gyms, transit stops, and Waterloo Park. Enjoy easy, comfortable living in a vibrant, walkable neighborhood. Don't miss outreach out today!"
+"ArchitecturalStyle": array:1 [
0 => "Apartment"
]
+"Basement": array:1 [
0 => "None"
]
+"ConstructionMaterials": array:1 [
0 => "Brick"
]
+"Cooling": array:1 [
0 => "Central Air"
]
+"Country": "CA"
+"CountyOrParish": "Waterloo"
+"CreationDate": "2025-05-06T01:51:53.640526+00:00"
+"CrossStreet": "Hickory Street & Larch Street"
+"Directions": "Hickory Street & Larch Street"
+"ExpirationDate": "2025-07-31"
+"Furnished": "Furnished"
+"Inclusions": "Fridge, stove, built-in dishwasher, washer, dryer"
+"InteriorFeatures": array:1 [
0 => "None"
]
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [
0 => "Ensuite"
]
+"LeaseTerm": "12 Months"
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-05-05"
+"MainOfficeKey": "101400"
+"MajorChangeTimestamp": "2025-05-05T17:13:27Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2025-05-05T17:13:27Z"
+"OriginalListPrice": 2000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft2337174"
+"ParkingFeatures": array:1 [
0 => "None"
]
+"PetsAllowed": array:1 [
0 => "No"
]
+"PhotosChangeTimestamp": "2025-05-05T17:13:27Z"
+"RentIncludes": array:1 [
0 => "All Inclusive"
]
+"ShowingRequirements": array:1 [
0 => "Lockbox"
]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Larch"
+"StreetNumber": "275"
+"StreetSuffix": "Street"
+"TransactionBrokerCompensation": "Half Month's Rent + HST"
+"TransactionType": "For Lease"
+"UnitNumber": "G316"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "East"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12124813')"
+"GarageType": "None"
+"HeatSource": "Electric"
+"SurveyType": "None"
+"BalconyType": "Open"
+"HoldoverDays": 90
+"LegalStories": "4"
+"ParkingType1": "None"
+"CreditCheckYN": true
+"KitchensTotal": 1
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2L 3R2, CA"
+"ContractStatus": "Available"
+"PossessionDate": "2025-05-09"
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"CondoCorpNumber": 643
+"DepositRequired": true
+"LivingAreaRange": "500-599"
+"RoomsAboveGrade": 5
+"LeaseAgreementYN": true
+"SquareFootSource": "Landlord"
+"PrivateEntranceYN": true
+"WashroomsType1Pcs": 4
+"BedroomsAboveGrade": 2
+"EmploymentLetterYN": true
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [
0 => "Unknown"
]
+"RentalApplicationYN": true
+"WashroomsType1Level": "Main"
+"LegalApartmentNumber": "41"
+"MediaChangeTimestamp": "2025-05-05T17:13:27Z"
+"PortionPropertyLease": array:1 [
0 => "Entire Property"
]
+"ReferencesRequiredYN": true
+"PropertyManagementCompany": "Wilson Blanchard Management Co"
+"SystemModificationTimestamp": "2025-05-05T17:13:28.587945Z"
+"PermissionToContactListingBrokerToAdvertise": 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]
]
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4034
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12124181"
+"ListingId": "X12124181"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-05-05T15:40:35Z"
+"RFModificationTimestamp": "2025-05-06T06:59:55.303577+00:00"
+"ListPrice": 340000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 3W5"
+"UnparsedAddress": "#718 - 250 Albert Street, Waterloo, On N2l 3w5"
+"Coordinates": array:2 [
0 => -80.5395921
1 => 43.4843569
]
+"Latitude": 43.4843569
+"Longitude": -80.5395921
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "ROYAL LEPAGE SIGNATURE REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to this stylish 1-bedroom, 1-bath condo featuring a space-efficient layout designed for everyday comfort and modern living. The thoughtfully planned interior includes a sleek kitchen with ample storage, contemporary finishes, and in-suite laundry for added convenience. A Juliette balcony fills the space with natural light and fresh air, creating a bright and airy atmosphere. Perfectly situated near universities, colleges, top restaurants, shopping, and daily essentials, this location is ideal for students, professionals, and anyone seeking vibrant city living. Enjoy easy access to public transit (bus), making commuting effortless. The building offers a full suite of amenities designed to elevate your lifestyle, including an exercise room, media room, rooftop deck/garden, visitor parking, game room, bike storage, party/meeting room, and a security system. Fire up the BBQ on the rooftop or unwind in the lounge areas with views of the city. This is urban living at its finest."
+"ArchitecturalStyle": array:1 [
0 => "Apartment"
]
+"AssociationAmenities": array:1 [
0 => "Exercise Room"
]
+"AssociationFee": "281.75"
+"AssociationFeeIncludes": array:1 [
0 => "Common Elements Included"
]
+"Basement": array:1 [
0 => "None"
]
+"CoListOfficeName": "COLDWELL BANKER THE REAL ESTATE CENTRE"
+"CoListOfficePhone": "705-436-5111"
+"ConstructionMaterials": array:1 [
0 => "Brick"
]
+"Cooling": array:1 [
0 => "Central Air"
]
+"CountyOrParish": "Waterloo"
+"CreationDate": "2025-05-06T03:36:44.515675+00:00"
+"CrossStreet": "University Ave & King St N"
+"Directions": "University Ave & King St N"
+"ExpirationDate": "2025-08-29"
+"GarageYN": true
+"Inclusions": "Stainless Steel Refrigerator, Oven, Dishwasher, Hood Range. Window Coverings"
+"InteriorFeatures": array:1 [
0 => "None"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [
0 => "In-Suite Laundry"
]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-05-05"
+"MainOfficeKey": "572000"
+"MajorChangeTimestamp": "2025-05-05T14:58:42Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2025-05-05T14:58:42Z"
+"OriginalListPrice": 340000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft2298466"
+"ParkingFeatures": array:1 [
0 => "None"
]
+"PetsAllowed": array:1 [
0 => "Restricted"
]
+"PhotosChangeTimestamp": "2025-05-05T14:58:43Z"
+"ShowingRequirements": array:1 [
0 => "Lockbox"
]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Albert"
+"StreetNumber": "250"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2151.0"
+"TaxYear": "2024"
+"TransactionBrokerCompensation": "2 + HST"
+"TransactionType": "For Sale"
+"UnitNumber": "718"
+"VirtualTourURLBranded": "https://iguidephotos.com/718_250_albert_street_waterloo_on/"
+"VirtualTourURLUnbranded": "https://unbranded.iguidephotos.com/718_250_albert_street_waterloo_on/"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "South East"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12124181')"
+"ElevatorYN": true
+"GarageType": "Underground"
+"HeatSource": "Gas"
+"SurveyType": "Unknown"
+"BalconyType": "Juliette"
+"HoldoverDays": 90
+"LaundryLevel": "Main Level"
+"LegalStories": "6"
+"ParkingType1": "None"
+"KitchensTotal": 1
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2L 3W5, CA"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [
0 => "Included In"
]
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"CondoCorpNumber": 659
+"LivingAreaRange": "0-499"
+"RoomsAboveGrade": 4
+"EnsuiteLaundryYN": true
+"PropertyFeatures": array:6 [
0 => "Arts Centre"
1 => "Hospital"
2 => "Library"
3 => "Park"
4 => "Place Of Worship"
5 => "Public Transit"
]
+"SquareFootSource": "Builder"
+"PossessionDetails": "Immediate"
+"WashroomsType1Pcs": 4
+"BedroomsAboveGrade": 1
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [
0 => "Unknown"
]
+"WashroomsType1Level": "Main"
+"LegalApartmentNumber": "12"
+"MediaChangeTimestamp": "2025-05-05T14:58:43Z"
+"PropertyManagementCompany": "Wilson Blanchard Management Inc 519-620-8776"
+"SystemModificationTimestamp": "2025-05-05T15:40:36.333067Z"
+"Media": array:23 [
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]
]
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4035
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12017777"
+"ListingId": "X12017777"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-05-04T23:18:48Z"
+"RFModificationTimestamp": "2025-05-04T23:23:20.737782+00:00"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J 4S2"
+"UnparsedAddress": "#302 - 4 Willow Street, Waterloo, On N2j 4s2"
+"Coordinates": array:2 [
0 => -80.5172088
1 => 43.4652949
]
+"Latitude": 43.4652949
+"Longitude": -80.5172088
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "ROYAL LEPAGE WOLLE REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to Water Park Place, where luxury condo living meets convenience and tranquility! Designed with professionals and retirees in mind, this spacious and elegant suite offers carefree, turnkey living in a highly sought-after location. With over 1400+ square feet of thoughtfully designed space, its perfect for those seeking to downsize without compromising on comfort. The layout boasts two bedrooms positioned at opposite ends of the suite for enhanced privacy, making it ideal for live-work arrangements or hosting overnight guests. The master bedroom features an ensuite, two closets, and a private slider to the extensive balcony with south eastern views. The eat-in kitchen also provides balcony access, while the open-concept living/dining area includes a unique enclosed sunroomperfect for hobbyists or a home office. Additional highlights include new luxury vinyl plank flooring throughout. Suite has been painted in the last couple of years. HVAC unit replaced in 2024. Water Park Place pampers its residents with an array of amenities: an indoor pool, sauna, billiards room, fitness center, library, outdoor barbecue area, guest suites, and abundant visitor parking. Nestled on 3.2 acres of park-like surroundings, enjoy walking paths, ponds, and lush landscaping. With a Walk Score of 84, this location offers unparalleled conveniencesteps from the LRT, Uptown Waterloos vibrant shops and restaurants, universities, and scenic trails. Complete with two, tandem, underground parking spots and a storage locker, this condo promises a refined lifestyle with the perfect balance of urban vibrancy and serene living. Dont miss this opportunityschedule your private viewing today!"
+"AccessibilityFeatures": array:1 [
0 => "Elevator"
]
+"ArchitecturalStyle": array:1 [
0 => "1 Storey/Apt"
]
+"AssociationAmenities": array:5 [
0 => "Visitor Parking"
1 => "Indoor Pool"
2 => "Guest Suites"
3 => "Bike Storage"
4 => "Party Room/Meeting Room"
]
+"AssociationFee": "1019.11"
+"AssociationFeeIncludes": array:3 [
0 => "Water Included"
1 => "Building Insurance Included"
2 => "Common Elements Included"
]
+"Basement": array:1 [
0 => "None"
]
+"BuildingName": "Water Park"
+"ConstructionMaterials": array:1 [
0 => "Brick"
]
+"Cooling": array:1 [
0 => "Central Air"
]
+"Country": "CA"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "2.0"
+"CreationDate": "2025-03-13T20:01:48.254475+00:00"
+"CrossStreet": "Corner of Willow Street and Erb Street East"
+"Directions": "Located at the corner of Willow Street and Erb Street East. Note that Erb Street East is one way."
+"Exclusions": "None"
+"ExpirationDate": "2025-09-10"
+"Inclusions": "Dishwasher, Dryer, Garage Door Opener, Garbage Disposal, Range Hood, Refrigerator, Stove, Washer, Window Coverings"
+"InteriorFeatures": array:1 [
0 => "Intercom"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [
0 => "In-Suite Laundry"
]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-03-12"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "356100"
+"MajorChangeTimestamp": "2025-05-04T23:18:48Z"
+"MlsStatus": "Price Change"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2025-03-13T18:22:28Z"
+"OriginalListPrice": 765000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft2082822"
+"ParcelNumber": "231450015"
+"ParkingTotal": "2.0"
+"PetsAllowed": array:1 [
0 => "No"
]
+"PhotosChangeTimestamp": "2025-03-13T18:22:28Z"
+"PreviousListPrice": 765000.0
+"PriceChangeTimestamp": "2025-05-04T23:18:48Z"
+"Roof": array:1 [
0 => "Other"
]
+"SeniorCommunityYN": true
+"ShowingRequirements": array:3 [
0 => "Lockbox"
1 => "See Brokerage Remarks"
2 => "Showing System"
]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Willow"
+"StreetNumber": "4"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4568.0"
+"TaxAssessedValue": 359000
+"TaxYear": "2024"
+"TransactionBrokerCompensation": "2.25% + HST"
+"TransactionType": "For Sale"
+"UnitNumber": "302"
+"View": array:2 [
0 => "Downtown"
1 => "City"
]
+"VirtualTourURLBranded": "https://youriguide.com/ggxvu_4_willow_st_waterloo_on/"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/ggxvu_4_willow_st_waterloo_on/"
+"Zoning": "RMU-81"
+"DDFYN": true
+"Locker": "Exclusive"
+"Exposure": "South East"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12017777')"
+"ElevatorYN": true
+"GarageType": "Underground"
+"HeatSource": "Electric"
+"LockerUnit": "A73"
+"RollNumber": "301602165000212"
+"SurveyType": "None"
+"BalconyType": "Open"
+"LockerLevel": "P1"
+"RentalItems": "None"
+"HoldoverDays": 10
+"LaundryLevel": "Main Level"
+"LegalStories": "3"
+"ParkingSpot1": "3A"
+"ParkingSpot2": "3B"
+"ParkingType1": "Exclusive"
+"ParkingType2": "Exclusive"
+"KitchensTotal": 1
+"UnderContract": array:1 [
0 => "None"
]
+"provider_name": "TRREB"
+"ApproximateAge": "31-50"
+"AssessmentYear": 2024
+"ContractStatus": "Available"
+"HSTApplication": array:1 [
0 => "Not Subject to HST"
]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "New"
+"WashroomsType1": 2
+"CondoCorpNumber": 145
+"LivingAreaRange": "1400-1599"
+"RoomsAboveGrade": 10
+"EnsuiteLaundryYN": true
+"SquareFootSource": "As per iguide"
+"ParkingLevelUnit1": "P2"
+"ParkingLevelUnit2": "P2"
+"PossessionDetails": "immediate"
+"WashroomsType1Pcs": 4
+"BedroomsAboveGrade": 2
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [
0 => "Unknown"
]
+"LeaseToOwnEquipment": array:1 [
0 => "None"
]
+"ShowingAppointments": "Showing Time"
+"WashroomsType1Level": "Main"
+"LegalApartmentNumber": "2"
+"MediaChangeTimestamp": "2025-03-14T14:45:27Z"
+"PropertyManagementCompany": "T&Co. Property Managment"
+"SystemModificationTimestamp": "2025-05-04T23:18:49.391955Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:46 [
0 => array:26 [ …26]
1 => array:26 [ …26]
2 => array:26 [ …26]
3 => array:26 [ …26]
4 => array:26 [ …26]
5 => array:26 [ …26]
6 => array:26 [ …26]
7 => array:26 [ …26]
8 => array:26 [ …26]
9 => array:26 [ …26]
10 => array:26 [ …26]
11 => array:26 [ …26]
12 => array:26 [ …26]
13 => array:26 [ …26]
14 => array:26 [ …26]
15 => array:26 [ …26]
16 => array:26 [ …26]
17 => array:26 [ …26]
18 => array:26 [ …26]
19 => array:26 [ …26]
20 => array:26 [ …26]
21 => array:26 [ …26]
22 => array:26 [ …26]
23 => array:26 [ …26]
24 => array:26 [ …26]
25 => array:26 [ …26]
26 => array:26 [ …26]
27 => array:26 [ …26]
28 => array:26 [ …26]
29 => array:26 [ …26]
30 => array:26 [ …26]
31 => array:26 [ …26]
32 => array:26 [ …26]
33 => array:26 [ …26]
34 => array:26 [ …26]
35 => array:26 [ …26]
36 => array:26 [ …26]
37 => array:26 [ …26]
38 => array:26 [ …26]
39 => array:26 [ …26]
40 => array:26 [ …26]
41 => array:26 [ …26]
42 => array:26 [ …26]
43 => array:26 [ …26]
44 => array:26 [ …26]
45 => array:26 [ …26]
]
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4036
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12122939"
+"ListingId": "X12122939"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-05-04T16:13:21Z"
+"RFModificationTimestamp": "2025-05-05T09:17:45.532427+00:00"
+"ListPrice": 698800.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 3W9"
+"UnparsedAddress": "#n2502 - 330 Phillip Street, Waterloo, On N2l 3w9"
+"Coordinates": array:2 [
0 => -80.5391944
1 => 43.4759775
]
+"Latitude": 43.4759775
+"Longitude": -80.5391944
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX IMPERIAL REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "**Experience Luxury Living at the Icon Condo** Discover upscale living in this impressive unit located in the prestigious Icon Condominium, ideally positioned directly across from the University of Waterloo and just a short walk to Wilfrid Laurier University. Perfect for students, professionals, or investors, this location offers unbeatable convenience.The bright and spacious unit features an open-concept layout flooded with natural light from expansive windows. It is literally a 3 bedrooms (builder call it a 2-bedroom plus den, the den includes a window) and functions perfectly as a third bedroom ideal for maximizing rental potential. Enjoy resort-style amenities, including a rooftop patio with stunning views, a fully equipped fitness center, basketball court, sauna, yoga studio, game room, study lounge, and 24/7 security for peace of mind. Pet-friendly (cats and dogs allowed) and includes one locker for extra storage. Whether you're looking to live in or invest, this is luxury, comfort, and convenience all in one. One locker included!"
+"ArchitecturalStyle": array:1 [
0 => "Apartment"
]
+"AssociationFee": "466.23"
+"AssociationFeeIncludes": array:4 [
0 => "Building Insurance Included"
1 => "Water Included"
2 => "Heat Included"
3 => "Common Elements Included"
]
+"Basement": array:1 [
0 => "None"
]
+"ConstructionMaterials": array:1 [
0 => "Concrete"
]
+"Cooling": array:1 [
0 => "Central Air"
]
+"Country": "CA"
+"CountyOrParish": "Waterloo"
+"CreationDate": "2025-05-04T17:07:36.608712+00:00"
+"CrossStreet": "University and Phillip"
+"Directions": "University and Phillip"
+"ExpirationDate": "2025-12-31"
+"InteriorFeatures": array:1 [
0 => "None"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [
0 => "In-Suite Laundry"
]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-05-04"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "214800"
+"MajorChangeTimestamp": "2025-05-04T16:13:21Z"
+"MlsStatus": "New"
+"OccupantType": "Owner+Tenant"
+"OriginalEntryTimestamp": "2025-05-04T16:13:21Z"
+"OriginalListPrice": 698800.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft2330878"
+"PetsAllowed": array:1 [
0 => "No"
]
+"PhotosChangeTimestamp": "2025-05-04T16:13:21Z"
+"ShowingRequirements": array:1 [
0 => "Lockbox"
]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Phillip"
+"StreetNumber": "330"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3757.02"
+"TaxYear": "2024"
+"TransactionBrokerCompensation": "2.5%"
+"TransactionType": "For Sale"
+"UnitNumber": "N2502"
+"DDFYN": true
+"Locker": "Owned"
+"Exposure": "North South"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12122939')"
+"GarageType": "None"
+"HeatSource": "Gas"
+"LockerUnit": "723"
+"SurveyType": "None"
+"BalconyType": "Open"
+"LockerLevel": "A"
+"HoldoverDays": 90
+"LegalStories": "25"
+"ParkingType1": "None"
+"KitchensTotal": 1
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2L 3W9, CA"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [
0 => "Included In"
]
+"PossessionDate": "2025-07-31"
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"CondoCorpNumber": 627
+"LivingAreaRange": "800-899"
+"RoomsAboveGrade": 7
+"EnsuiteLaundryYN": true
+"SquareFootSource": "Builder"
+"WashroomsType1Pcs": 3
+"WashroomsType2Pcs": 3
+"BedroomsAboveGrade": 3
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [
0 => "Unknown"
]
+"StatusCertificateYN": true
+"WashroomsType1Level": "Flat"
+"WashroomsType2Level": "Flat"
+"LegalApartmentNumber": "N2502"
+"MediaChangeTimestamp": "2025-05-04T16:13:21Z"
+"PropertyManagementCompany": "Craft Property Group"
+"SystemModificationTimestamp": "2025-05-04T16:13:25.953147Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:31 [
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]
]
}
9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4037
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12077794"
+"ListingId": "X12077794"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-05-04T13:30:59Z"
+"RFModificationTimestamp": "2025-05-06T16:25:45.993252+00:00"
+"ListPrice": 414900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 0H6"
+"UnparsedAddress": "#ph1161 - 258a Sunview Street, Waterloo, On N2l 0h6"
+"Coordinates": array:2 [
0 => -80.5338211
1 => 43.4746725
]
+"Latitude": 43.4746725
+"Longitude": -80.5338211
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "SUTTON GROUP INCENTIVE REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "This well-appointed, 607 sq ft two-bedroom condo is an excellent investment opportunity for students, university staff, or working professionals. Featuring a thoughtfully designed split-bedroom floor plan for enhanced privacy, this unit also offers the convenience of in-suite laundry and modern finishes throughout. Ideally located within walking distance of the University of Waterloo, Wilfrid Laurier University, and Conestoga College, this property is surrounded by essential amenities and vibrant city life. Just steps from University Avenue, you'll find parks, restaurants, shops, banks, and grocery stores all within easy reach. Commuting is effortless with ION Light Rail, and GO Transit access nearby, connecting you to Uptown Waterloo, Downtown Kitchener, and beyond. Whether you're seeking a low-maintenance rental property or a home in the heart of Waterloos University District, this opportunity offers both comfort and strong rental potential."
+"ArchitecturalStyle": array:1 [
0 => "1 Storey/Apt"
]
+"AssociationAmenities": array:3 [
0 => "Visitor Parking"
1 => "Rooftop Deck/Garden"
2 => "Elevator"
]
+"AssociationFee": "367.95"
+"AssociationFeeIncludes": array:4 [
0 => "Heat Included"
1 => "Water Included"
2 => "Common Elements Included"
3 => "Building Insurance Included"
]
+"Basement": array:1 [
0 => "None"
]
+"ConstructionMaterials": array:1 [
0 => "Metal/Steel Siding"
]
+"Cooling": array:1 [
0 => "Central Air"
]
+"Country": "CA"
+"CountyOrParish": "Waterloo"
+"CreationDate": "2025-04-13T03:21:41.131000+00:00"
+"CrossStreet": "University Ave W / Sunview St"
+"Directions": "University Ave W to Sunview St"
+"ExpirationDate": "2025-06-30"
+"ExteriorFeatures": array:1 [
0 => "Year Round Living"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Inclusions": "Refrigerator, stove, dishwasher, washer, dryer"
+"InteriorFeatures": array:2 [
0 => "Water Heater"
1 => "Carpet Free"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [
0 => "In-Suite Laundry"
]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-04-11"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "097400"
+"MajorChangeTimestamp": "2025-05-04T13:30:59Z"
+"MlsStatus": "Price Change"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2025-04-11T16:50:45Z"
+"OriginalListPrice": 419900.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft2226714"
+"ParcelNumber": "236660378"
+"ParkingFeatures": array:1 [
0 => "Surface"
]
+"PetsAllowed": array:1 [
0 => "Restricted"
]
+"PhotosChangeTimestamp": "2025-04-11T16:50:45Z"
+"PreviousListPrice": 419900.0
+"PriceChangeTimestamp": "2025-05-04T13:30:59Z"
+"Roof": array:1 [
0 => "Flat"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detector"
]
+"ShowingRequirements": array:2 [
0 => "Lockbox"
1 => "Showing System"
]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Sunview"
+"StreetNumber": "258A"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3041.0"
+"TaxAssessedValue": 239000
+"TaxYear": "2024"
+"Topography": array:1 [
0 => "Flat"
]
+"TransactionBrokerCompensation": "2.25"
+"TransactionType": "For Sale"
+"UnitNumber": "PH1161"
+"View": array:1 [
0 => "City"
]
+"Zoning": "NMU-12"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "East"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12077794')"
+"ElevatorYN": true
+"GarageType": "None"
+"HeatSource": "Gas"
+"RollNumber": "301604435004328"
+"SurveyType": "None"
+"BalconyType": "Open"
+"RentalItems": "Hot Water Heater"
+"HoldoverDays": 90
+"LaundryLevel": "Main Level"
+"LegalStories": "13"
+"ParkingType1": "None"
+"KitchensTotal": 1
+"UnderContract": array:1 [
0 => "Hot Water Heater"
]
+"provider_name": "TRREB"
+"ApproximateAge": "6-10"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [
0 => "Included In"
]
+"PossessionType": "60-89 days"
+"PriorMlsStatus": "New"
+"WashroomsType1": 1
+"CondoCorpNumber": 666
+"LivingAreaRange": "600-699"
+"RoomsAboveGrade": 4
+"EnsuiteLaundryYN": true
+"PropertyFeatures": array:4 [
0 => "School"
1 => "Place Of Worship"
2 => "Park"
3 => "Other"
]
+"SquareFootSource": "Floor plans"
+"PossessionDetails": "60-89 days"
+"WashroomsType1Pcs": 3
+"BedroomsAboveGrade": 2
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [
0 => "Unknown"
]
+"ShowingAppointments": "All showings to be booked through Broker Bay. L/B is located at the front entrance on the wall with Realtor's name on the back of L/B."
+"WashroomsType1Level": "Main"
+"LegalApartmentNumber": "2"
+"MediaChangeTimestamp": "2025-04-11T16:50:45Z"
+"PropertyManagementCompany": "Wilson, Blanchard Management Inc."
+"SystemModificationTimestamp": "2025-05-04T13:31:01.22361Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:6 [
0 => array:26 [ …26]
1 => array:26 [ …26]
2 => array:26 [ …26]
3 => array:26 [ …26]
4 => array:26 [ …26]
5 => array:26 [ …26]
]
}
]
+success: true
+page_size: 10
+page_count: 71
+count: 706
+after_key: ""
}
]
"RF Cache Key: 5f2e4a03e397dfc059bb210a593ad47f69ea85b04d21be98c92a219c13d13a4a" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#4143
+items: array:5 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4058
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "N12196269"
+"ListingId": "N12196269"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-06-13T09:01:06Z"
+"RFModificationTimestamp": "2025-06-13T09:07:32.293712+00:00"
+"ListPrice": 1349900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.31
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "East Gwillimbury"
+"PostalCode": "L9N 1E5"
+"UnparsedAddress": "15 Earls Court, East Gwillimbury, ON L9N 1E5"
+"Coordinates": array:2 [
0 => -79.4835442
1 => 44.0955915
]
+"Latitude": 44.0955915
+"Longitude": -79.4835442
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "COLDWELL BANKER THE REAL ESTATE CENTRE"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Stunning home ,beautifully updated and maintained from top to bottom, in sought after Holland Landing! A fabulous picturesque location on a family friendly court, with no homes behind- steps tp conservation and the Nokiidaa Trail! This kitchen will wow you with a 15ft stone island and 6 burner gas Wolf stove range. Kitchen overlooks the family room (currently set as dining room )with its gas fireplace and w/o to deck - perfect for entertaining. Just a few steps up to 3 bedrooms that include the primary bedroom with gorgeous 3 piece ensuite with heated floors & built in wardrobe. The basement is bright & inviting, accented by unheard of 9 ft ceilings and 2 walk outs &access to garage. Room for a home office, recreation area and living room. Behind the sliding barn door is a spa like bathroom with heated floors and a w/o to the lower deck and area for a hot tub. Once outside you can enjoy the privacy of this lot lined with mature trees! Two level composite deck is sensational with the lower area canopied by a large Maple tree -Paradise! This home has space for growing families, work -from home & guest accommodations. Located just minutes form Newmarket and Bradford with easy access to schools, shopping transit and the Go Station. Other noteable upgrades in 2024: eavestrough, soffits& leave guards, insulated front door, composite deck! This is a home to fall in love with - All the work has been done!"
+"ArchitecturalStyle": array:1 [
0 => "Sidesplit 3"
]
+"Basement": array:1 [
0 => "Finished with Walk-Out"
]
+"CityRegion": "Holland Landing"
+"ConstructionMaterials": array:1 [
0 => "Brick"
]
+"Cooling": array:1 [
0 => "Central Air"
]
+"CountyOrParish": "York"
+"CoveredSpaces": "2.0"
+"CreationDate": "2025-06-04T19:21:34.653234+00:00"
+"CrossStreet": "Mt Albert Side Rd & Yonge"
+"DirectionFaces": "West"
+"Directions": "South off of Mt Albert Side Road West of Yonge St"
+"Exclusions": "Basement: feezer, murphy bed, kids climbing gym.Garage:hanging storage/shelving/toolbox . Hot Tub"
+"ExpirationDate": "2025-08-30"
+"ExteriorFeatures": array:3 [
0 => "Backs On Green Belt"
1 => "Deck"
2 => "Privacy"
]
+"FireplaceFeatures": array:2 [
0 => "Natural Gas"
1 => "Electric"
]
+"FireplaceYN": true
+"FireplacesTotal": "4"
+"FoundationDetails": array:1 [
0 => "Concrete Block"
]
+"GarageYN": true
+"Inclusions": "Modern light fixtures & ceiling fans, California shutters, 6 Burner Wolf Gas Stove, Fisher- Paykel 2 drawer dishwasher,B/I Micro, S/S side by side fridge, 2 zone beverage fridge, front load washer & dryer, 2 gas fireplaces, 2 electric fireplaces, heated floors in primary ensuite & basement bathroom, central air, hot water tank, garage door opener & remote, garden shed, invisible Dog fence"
+"InteriorFeatures": array:2 [
0 => "In-Law Capability"
1 => "Water Heater Owned"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-06-04"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "018600"
+"MajorChangeTimestamp": "2025-06-04T18:55:49Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2025-06-04T18:55:49Z"
+"OriginalListPrice": 1349900.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft2496596"
+"ParkingFeatures": array:1 [
0 => "Private Double"
]
+"ParkingTotal": "6.0"
+"PhotosChangeTimestamp": "2025-06-04T18:55:50Z"
+"PoolFeatures": array:1 [
0 => "None"
]
+"Roof": array:1 [
0 => "Asphalt Shingle"
]
+"Sewer": array:1 [
0 => "Sewer"
]
+"ShowingRequirements": array:1 [
0 => "Lockbox"
]
+"SignOnPropertyYN": true
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Earls"
+"StreetNumber": "15"
+"StreetSuffix": "Court"
+"TaxAnnualAmount": "4751.38"
+"TaxLegalDescription": "Plan 65M2168 LOT 13"
+"TaxYear": "2024"
+"TransactionBrokerCompensation": "2.5% plus HST"
+"TransactionType": "For Sale"
+"View": array:1 [
0 => "Panoramic"
]
+"VirtualTourURLUnbranded": "https://www.winsold.com/tour/408948"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 134.0
+"LotShape": "Irregular"
+"LotWidth": 49.0
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('N12196269')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"SurveyType": "Up-to-Date"
+"RentalItems": "none"
+"HoldoverDays": 60
+"LaundryLevel": "Main Level"
+"KitchensTotal": 1
+"ParkingSpaces": 4
+"provider_name": "TRREB"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [
0 => "Included In"
]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"WashroomsType4": 1
+"DenFamilyroomYN": true
+"LivingAreaRange": "1500-2000"
+"RoomsAboveGrade": 6
+"RoomsBelowGrade": 1
+"LotSizeAreaUnits": "Acres"
+"PropertyFeatures": array:2 [
0 => "Cul de Sac/Dead End"
1 => "Greenbelt/Conservation"
]
+"PossessionDetails": "TBA"
+"WashroomsType1Pcs": 2
+"WashroomsType2Pcs": 3
+"WashroomsType3Pcs": 4
+"WashroomsType4Pcs": 4
+"BedroomsAboveGrade": 3
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [
0 => "Unknown"
]
+"ShowingAppointments": "TLBO"
+"WashroomsType1Level": "Ground"
+"WashroomsType2Level": "Second"
+"WashroomsType3Level": "Second"
+"WashroomsType4Level": "Basement"
+"MediaChangeTimestamp": "2025-06-05T01:46:08Z"
+"SystemModificationTimestamp": "2025-06-13T09:01:08.737162Z"
+"Media": array:50 [
0 => array:26 [ …26]
1 => array:26 [ …26]
2 => array:26 [ …26]
3 => array:26 [ …26]
4 => array:26 [ …26]
5 => array:26 [ …26]
6 => array:26 [ …26]
7 => array:26 [ …26]
8 => array:26 [ …26]
9 => array:26 [ …26]
10 => array:26 [ …26]
11 => array:26 [ …26]
12 => array:26 [ …26]
13 => array:26 [ …26]
14 => array:26 [ …26]
15 => array:26 [ …26]
16 => array:26 [ …26]
17 => array:26 [ …26]
18 => array:26 [ …26]
19 => array:26 [ …26]
20 => array:26 [ …26]
21 => array:26 [ …26]
22 => array:26 [ …26]
23 => array:26 [ …26]
24 => array:26 [ …26]
25 => array:26 [ …26]
26 => array:26 [ …26]
27 => array:26 [ …26]
28 => array:26 [ …26]
29 => array:26 [ …26]
30 => array:26 [ …26]
31 => array:26 [ …26]
32 => array:26 [ …26]
33 => array:26 [ …26]
34 => array:26 [ …26]
35 => array:26 [ …26]
36 => array:26 [ …26]
37 => array:26 [ …26]
38 => array:26 [ …26]
39 => array:26 [ …26]
40 => array:26 [ …26]
41 => array:26 [ …26]
42 => array:26 [ …26]
43 => array:26 [ …26]
44 => array:26 [ …26]
45 => array:26 [ …26]
46 => array:26 [ …26]
47 => array:26 [ …26]
48 => array:26 [ …26]
49 => array:26 [ …26]
]
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4097
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "C12216918"
+"ListingId": "C12216918"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-06-13T08:59:26Z"
+"RFModificationTimestamp": "2025-06-13T09:02:53.408213+00:00"
+"ListPrice": 1900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Toronto C15"
+"PostalCode": "M2K 0B2"
+"UnparsedAddress": "#601 A - 19 Singer Court, Toronto C15, ON M2K 0B2"
+"Coordinates": array:2 [
0 => 0
1 => 0
]
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "HOMELIFE SUPERSTARS REAL ESTATE LIMITED"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Smart Open concept layout ## 1 Bed Room configuration ## Beautiful Unobstructed South East View of North York. Modern Eat in Kitchen with Expansive Stone Counter Top, Short walk to Public transit or major High ways at your door step!!!!! Myriad of amenities such as Pool , Gym, Cinema, Guest suites, karaoke, Party room ,BBQ area ,Pet Spa, Billiards, 24 Hour security and more !!!End less Amenities !!!shopping choices surround you bay view Village and Canadian Tire. List of amenities also attached AAA Tenant , Required Credit Check Equifax , Job Letter, Recent 2 Pay Stub, Reference, Tenant Insurance, Rental Application , First and Last month Deposit . Maintenance fee paid by Landlord, utility paid by Tenant. Close to Hwy 401/404 School, Colleges."
+"ArchitecturalStyle": array:1 [
0 => "Bachelor/Studio"
]
+"Basement": array:1 [
0 => "None"
]
+"CityRegion": "Bayview Village"
+"ConstructionMaterials": array:1 [
0 => "Concrete"
]
+"Cooling": array:1 [
0 => "Central Air"
]
+"Country": "CA"
+"CountyOrParish": "Toronto"
+"CreationDate": "2025-06-12T23:29:23.853119+00:00"
+"CrossStreet": "Leslie St / Sheppard Ave E"
+"Directions": "Provost Drive / Singer Court"
+"ExpirationDate": "2025-10-10"
+"Furnished": "Unfurnished"
+"GarageYN": true
+"InteriorFeatures": array:1 [
0 => "Storage Area Lockers"
]
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [
0 => "In-Suite Laundry"
]
+"LeaseTerm": "12 Months"
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-06-11"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "004200"
+"MajorChangeTimestamp": "2025-06-12T19:24:27Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2025-06-12T19:24:27Z"
+"OriginalListPrice": 1900.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft2554042"
+"ParcelNumber": "762310240"
+"PetsAllowed": array:1 [
0 => "Restricted"
]
+"PhotosChangeTimestamp": "2025-06-12T19:24:27Z"
+"RentIncludes": array:4 [
0 => "Building Insurance"
1 => "Building Maintenance"
2 => "Central Air Conditioning"
3 => "Water"
]
+"ShowingRequirements": array:1 [
0 => "Lockbox"
]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Singer"
+"StreetNumber": "19"
+"StreetSuffix": "Court"
+"TransactionBrokerCompensation": "1/2 month Rent"
+"TransactionType": "For Lease"
+"UnitNumber": "601 A"
+"UFFI": "No"
+"DDFYN": true
+"Locker": "Owned"
+"Exposure": "South East"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('C12216918')"
+"ElevatorYN": true
+"GarageType": "Underground"
+"HeatSource": "Gas"
+"RollNumber": "190811302016774"
+"SurveyType": "Unknown"
+"BalconyType": "Open"
+"LockerLevel": "L P1"
+"HoldoverDays": 90
+"LegalStories": "5"
+"LockerNumber": "073"
+"ParkingType1": "None"
+"CreditCheckYN": true
+"KitchensTotal": 1
+"PaymentMethod": "Cheque"
+"provider_name": "TRREB"
+"ApproximateAge": "11-15"
+"ContractStatus": "Available"
+"PossessionDate": "2025-07-01"
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"CondoCorpNumber": 2231
+"DepositRequired": true
+"LivingAreaRange": "500-599"
+"RoomsAboveGrade": 4
+"EnsuiteLaundryYN": true
+"LeaseAgreementYN": true
+"PaymentFrequency": "Monthly"
+"SquareFootSource": "Mpac"
+"PossessionDetails": "TBA"
+"WashroomsType1Pcs": 4
+"EmploymentLetterYN": true
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [
0 => "Unknown"
]
+"RentalApplicationYN": true
+"WashroomsType1Level": "Flat"
+"LegalApartmentNumber": "25"
+"MediaChangeTimestamp": "2025-06-13T08:59:25Z"
+"PortionPropertyLease": array:1 [
0 => "Entire Property"
]
+"ReferencesRequiredYN": true
+"PropertyManagementCompany": "First Residential Service"
+"SystemModificationTimestamp": "2025-06-13T08:59:28.171105Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:11 [
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]
]
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4095
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12177794"
+"ListingId": "X12177794"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-06-13T08:57:35Z"
+"RFModificationTimestamp": "2025-06-13T09:01:35.526532+00:00"
+"ListPrice": 449000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Welland"
+"PostalCode": "L3B 1N3"
+"UnparsedAddress": "483 Scholfield Avenue, Welland, ON L3B 1N3"
+"Coordinates": array:2 [
0 => -79.23352
1 => 42.995861
]
+"Latitude": 42.995861
+"Longitude": -79.23352
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "EXP REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to 483 Scholfield Avenue North, a move-in-ready gem in the heart of Welland. This updated bungalow is full of value and perfect for first-time buyers, downsizers, or anyone looking for a solid home on a quiet street with room to grow. It features a finished basement, a two-piece bathroom downstairs, an updated kitchen, and new laminate flooring throughout the main living area. This home truly checks all the boxes. Step inside and enjoy a bright and functional layout with a cozy living space, two comfortable bedrooms, and an eat-in kitchen that was thoughtfully renovated with timeless finishes. The fully finished basement adds a great rec room, extra storage, and a convenient second bathroom that is perfect for guests, teens, or a home office. Outside, you will find a private backyard and a detached 1.5-car garage with hydro and 100 amp service on breakers. Whether you need space for a workshop, storage, or hobbies, it is a great bonus feature. Located close to great schools, parks, shopping, and highway access, this home offers both lifestyle and convenience. Homes like this do not last long. Whether you are buying your first home or looking to simplify, 483 Scholfield Avenue North is an opportunity you do not want to miss. Book your private showing today and see the potential for yourself."
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:1 [
0 => "Full"
]
+"CityRegion": "768 - Welland Downtown"
+"CoListOfficeName": "EXP REALTY"
+"CoListOfficePhone": "866-530-7737"
+"ConstructionMaterials": array:1 [
0 => "Vinyl Siding"
]
+"Cooling": array:1 [
0 => "Central Air"
]
+"CoolingYN": true
+"Country": "CA"
+"CountyOrParish": "Niagara"
+"CoveredSpaces": "1.5"
+"CreationDate": "2025-05-28T11:44:34.866824+00:00"
+"CrossStreet": "East Main"
+"DirectionFaces": "East"
+"Directions": "East Main to Scholfield"
+"ExpirationDate": "2025-09-28"
+"FoundationDetails": array:1 [
0 => "Concrete Block"
]
+"GarageYN": true
+"Inclusions": "Fridge, Stove, Portable Dishwasher, Oven Range-Microwave, Washer, Dryer, Window Coverings"
+"InteriorFeatures": array:3 [
0 => "Storage"
1 => "Primary Bedroom - Main Floor"
2 => "Water Heater"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Niagara Association of REALTORS"
+"ListingContractDate": "2025-05-28"
+"LotSizeDimensions": "51.50 x 121.00"
+"MainOfficeKey": "285400"
+"MajorChangeTimestamp": "2025-06-13T08:57:35Z"
+"MlsStatus": "Price Change"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2025-05-28T11:40:35Z"
+"OriginalListPrice": 469000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft2432844"
+"ParcelNumber": "641150129"
+"ParkingTotal": "4.0"
+"PhotosChangeTimestamp": "2025-05-28T11:40:35Z"
+"PoolFeatures": array:1 [
0 => "None"
]
+"PreviousListPrice": 469000.0
+"PriceChangeTimestamp": "2025-06-13T08:57:35Z"
+"PropertyAttachedYN": true
+"Roof": array:1 [
0 => "Asphalt Shingle"
]
+"Sewer": array:1 [
0 => "Sewer"
]
+"ShowingRequirements": array:1 [
0 => "Lockbox"
]
+"SignOnPropertyYN": true
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "N"
+"StreetName": "SCHOLFIELD"
+"StreetNumber": "483"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "2742.0"
+"TaxLegalDescription": "PTL 255,254,PLAN 23,NP 945"
+"TaxYear": "2024"
+"TransactionBrokerCompensation": "2% Plus HST"
+"TransactionType": "For Sale"
+"VirtualTourURLBranded": "https://www.youtube.com/watch?v=29er03xtp9M"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=Ax Fu ZMxn1Vs"
+"Zoning": "R2"
+"UFFI": "No"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 121.0
+"LotWidth": 51.5
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12177794')"
+"GarageType": "Detached"
+"HeatSource": "Gas"
+"RollNumber": "271904000208100"
+"SurveyType": "None"
+"Waterfront": array:1 [
0 => "None"
]
+"Winterized": "Fully"
+"RentalItems": "Air Conditioner and Hot Water Heater"
+"WaterMeterYN": true
+"KitchensTotal": 1
+"ParkingSpaces": 3
+"UnderContract": array:2 [
0 => "Air Conditioner"
1 => "Hot Water Tank-Gas"
]
+"provider_name": "TRREB"
+"ApproximateAge": "51-99"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [
0 => "Included In"
]
+"PossessionDate": "2025-06-30"
+"PossessionType": "30-59 days"
+"PriorMlsStatus": "New"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"DenFamilyroomYN": true
+"LivingAreaRange": "700-1100"
+"RoomsAboveGrade": 8
+"PropertyFeatures": array:5 [
0 => "Arts Centre"
1 => "Library"
2 => "Park"
3 => "Public Transit"
4 => "School"
]
+"LotSizeRangeAcres": "< .50"
+"WashroomsType1Pcs": 4
+"WashroomsType2Pcs": 2
+"BedroomsAboveGrade": 2
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [
0 => "Unknown"
]
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Basement"
+"MediaChangeTimestamp": "2025-05-28T11:40:35Z"
+"SystemModificationTimestamp": "2025-06-13T08:57:37.059814Z"
+"Media": array:32 [
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]
]
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4093
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "E12201181"
+"ListingId": "E12201181"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-06-13T08:33:01Z"
+"RFModificationTimestamp": "2025-06-13T08:39:55.731567+00:00"
+"ListPrice": 1800.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 6383.0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Toronto E04"
+"PostalCode": "M1K 3S5"
+"UnparsedAddress": "#lower - 53 Treverton Drive, Toronto E04, ON M1K 3S5"
+"Coordinates": array:2 [
0 => -79.265161
1 => 43.735164
]
+"Latitude": 43.735164
+"Longitude": -79.265161
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "HC REALTY GROUP INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "1 Bed 1 Bath Apartment With Walk-up! Located At Kennedy Rd & Eglinton Ave. Short Walk To Kennedy Subway Station and Go Train. Nearby Amenities Include Banks/24-Hours Shoppers Drug Mart/No Frills/Public Library/Restaurants/Parks. Etc. **Please Note There is No Ensuite Laundry but there is a Laundromat 3 Min Walk Away and Landlord is allowing Tenant to bring Portable Laundry."
+"ArchitecturalStyle": array:1 [
0 => "Apartment"
]
+"Basement": array:2 [
0 => "Walk-Up"
…1
]
+"CityRegion": "Ionview"
+"CoListOfficeName": "HC REALTY GROUP INC."
+"CoListOfficePhone": "905-889-9969"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"Country": "CA"
+"CountyOrParish": "Toronto"
+"CreationDate": "2025-06-06T07:57:31.046203+00:00"
+"CrossStreet": "Kennedy Rd & Eglinton Ave E"
+"DirectionFaces": "East"
+"Directions": "Kennedy Rd & Eglinton Ave E"
+"Exclusions": "Chest Freezer"
+"ExpirationDate": "2025-10-31"
+"FireplaceYN": true
+"FoundationDetails": array:1 [ …1]
+"Furnished": "Partially"
+"Inclusions": "Murphy Bed"
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"LeaseTerm": "12 Months"
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-06-06"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "367200"
+"MajorChangeTimestamp": "2025-06-06T07:50:57Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2025-06-06T07:50:57Z"
+"OriginalListPrice": 1800.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft2516782"
+"ParcelNumber": "063470262"
+"PhotosChangeTimestamp": "2025-06-06T12:07:12Z"
+"PoolFeatures": array:1 [ …1]
+"RentIncludes": 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": "Treverton"
+"StreetNumber": "53"
+"StreetSuffix": "Drive"
+"TransactionBrokerCompensation": "Half month rent"
+"TransactionType": "For Lease"
+"UnitNumber": "Lower"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 126.0
+"LotWidth": 42.1
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('E12201181')"
+"GarageType": "None"
+"HeatSource": "Gas"
+"RollNumber": "190104242002100"
+"SurveyType": "None"
+"HoldoverDays": 90
+"CreditCheckYN": true
+"KitchensTotal": 1
+"provider_name": "TRREB"
+"ContractStatus": "Available"
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"DepositRequired": true
+"LivingAreaRange": "1500-2000"
+"RoomsAboveGrade": 4
+"LeaseAgreementYN": true
+"PaymentFrequency": "Monthly"
+"PossessionDetails": "0"
+"PrivateEntranceYN": true
+"WashroomsType1Pcs": 3
+"BedroomsAboveGrade": 1
+"EmploymentLetterYN": true
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"RentalApplicationYN": true
+"MediaChangeTimestamp": "2025-06-07T14:23:07Z"
+"PortionPropertyLease": array:1 [ …1]
+"ReferencesRequiredYN": true
+"SystemModificationTimestamp": "2025-06-13T08:33:02.775721Z"
+"Media": array:8 [ …8]
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4091
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "W12208698"
+"ListingId": "W12208698"
+"PropertyType": "Commercial Lease"
+"PropertySubType": "Commercial Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-06-13T07:58:18Z"
+"RFModificationTimestamp": "2025-06-13T08:08:47.115404+00:00"
+"ListPrice": 2750.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 740.0
+"City": "Toronto W02"
+"PostalCode": "M6P 3Z5"
+"UnparsedAddress": "#2nd Floor - 34 Sousa Mendes Street, Toronto W02, ON M6P 3Z5"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.661363
+"Longitude": -79.453918
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RIGHT AT HOME REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to this unique 740 sq ft second-floor professional office featuring soaring 15 ft ceilings, large industrial-style windows, and a wide open-concept layoutperfect for modern businesses that value both design and function.This thoughtfully designed unit includes a full kitchen, in-suite laundry, and a bathroom with showermaking it an ideal fit for creative professionals, design studios, therapists, consultants, boutique agencies, or remote-first teams needing a polished in-person space. Concrete floors with a laminate finish add durability and a contemporary aesthetic. Central heating and cooling offer year-round comfort.Leased as a gross lease TMI, utilities, and water are included. Internet negotiable. Street parking is available, and underground parking is being finalized.Location highlights:Situated in the fast-growing Junction-Wallace Emerson neighbourhood, a hub for independent businesses and creative industries.Just a 3-minute walk to Bloor GO/UP Station and close to the Dundas West subway, providing easy access to downtown and the GTA.Steps from the West Toronto Railpath, ideal for clients or employees commuting by foot or bike.Surrounded by restaurants, cafes, and neighbourhood servicesa vibrant, walkable area that reflects the spirit of modern Toronto.Built in 2018, offering modern mechanical systems and efficient operations.Preferred lease term: 2 years. Liability insurance required. This client-friendly unit offers exceptional value, flexibility, and a professional presence in one of Torontos most dynamic areas."
+"BuildingAreaUnits": "Square Feet"
+"CityRegion": "Dovercourt-Wallace Emerson-Junction"
+"CommunityFeatures": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"Country": "CA"
+"CountyOrParish": "Toronto"
+"CreationDate": "2025-06-10T08:18:19.096233+00:00"
+"CrossStreet": "Dupont & Dundas"
+"Directions": "South of Dupont & East of Dundas"
+"ExpirationDate": "2025-09-10"
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-06-10"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "062200"
+"MajorChangeTimestamp": "2025-06-10T08:13:42Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2025-06-10T08:13:42Z"
+"OriginalListPrice": 2750.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft2534692"
+"ParcelNumber": "767040005"
+"PhotosChangeTimestamp": "2025-06-13T07:58:17Z"
+"SecurityFeatures": array:1 [ …1]
+"ShowingRequirements": array:3 [ …3]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Sousa Mendes"
+"StreetNumber": "34"
+"StreetSuffix": "Street"
+"TaxYear": "2024"
+"TransactionBrokerCompensation": "Half Month Rent + HST"
+"TransactionType": "For Lease"
+"UnitNumber": "2nd Floor"
+"Utilities": array:1 [ …1]
+"Zoning": "Commercial"
+"DDFYN": true
+"Water": "Municipal"
+"LotType": "Building"
+"TaxType": "TMI"
+"HeatType": "Gas Forced Air Open"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('W12208698')"
+"GarageType": "Underground"
+"RetailArea": 740.0
+"RollNumber": "190401353000106"
+"PropertyUse": "Retail"
+"RentalItems": "None"
+"HoldoverDays": 90
+"ListPriceUnit": "Gross Lease"
+"provider_name": "TRREB"
+"ApproximateAge": "0-5"
+"AssessmentYear": 2024
+"ContractStatus": "Available"
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"RetailAreaCode": "Sq Ft"
+"WashroomsType1": 1
+"PossessionDetails": "Immediate"
+"MediaChangeTimestamp": "2025-06-13T07:58:17Z"
+"MaximumRentalMonthsTerm": 60
+"MinimumRentalTermMonths": 12
+"SystemModificationTimestamp": "2025-06-13T07:58:18.279472Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:35 [ …35]
}
]
+success: true
+page_size: 5
+page_count: 23973
+count: 119863
+after_key: ""
}
]
]
