array:3 [
"RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(StandardStatus eq 'Active') and City eq 'Waterloo'/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(StandardStatus eq 'Active') and City eq 'Waterloo'&$expand=Media/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(StandardStatus eq 'Active') and City eq 'Waterloo'/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=10&$filter=(StandardStatus eq 'Active') and City eq 'Waterloo'&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#2869
+items: array:10 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2862
+post_id: "255219"
+post_author: 1
+"ListingKey": "X12164273"
+"ListingId": "X12164273"
+"PropertyType": "Residential"
+"PropertySubType": "Common Element Condo"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-06-20T15:38:35Z"
+"RFModificationTimestamp": "2025-06-20T16:31:32.825085+00:00"
+"ListPrice": 524500.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J 0E9"
+"UnparsedAddress": "#908 - 128 King Street, Waterloo, ON N2J 0E9"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4652699
+"Longitude": -80.5222961
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "META REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to ONE28 A Contemporary Condominium Residence in the Heart of Waterloo Presenting a refined opportunity to own a luxurious 1-bedroom + den suite in ONE28, an upscale 3-year-old condominium ideally situated just steps from Wilfrid Laurier University and mere minutes from the University of Waterloo. Designed for modern urban living, this meticulously maintained residence boasts exceptionally low maintenance fees and access to premium, resort-style amenities. Spanning over 680 square feet of open-concept living space, this sun-drenched unit features an expansive layout with a private balcony offering unobstructed eastern views. The thoughtfully designed foyer leads into an upgraded L-shaped kitchen adorned with full-sized stainless steel appliances, tall cabinetry, quartz countertops, double sinks, and a stylish backsplash. The generously sized living and dining area seamlessly extends to the balcony perfect for entertaining or quiet enjoyment. The primary bedroom serves as a serene retreat with floor-to-ceiling windows, full walk in closet, while the den offers flexibility to function as a home office or potential second bedroom. Additional features include in-suite laundry conveniently located beside a spa-inspired 4-piece bathroom, one designated parking space, and a secure locker for added storage. Enjoy access to a wealth of high-end amenities including:24/7 concierge services. Fully equipped fitness center and yoga studio Media/party room Rooftop terrace with BBQ stations. Secure bike storage and EV charging stations ***Deco White Black out draper added in the bedroom, Living Room & Balcony, Home Depot Installed Worth $2000***"
+"ArchitecturalStyle": "Apartment"
+"AssociationFee": "457.41"
+"AssociationFeeIncludes": array:2 [ …2]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2025-05-22T01:58:28.131191+00:00"
+"CrossStreet": "Regina/King St"
+"Directions": "King St/ Elgin St"
+"ExpirationDate": "2025-08-22"
+"GarageYN": true
+"Inclusions": "Fridge, stove, Washer, Dryer, Black Out Drapper"
+"InteriorFeatures": "Storage,Storage Area Lockers,Carpet Free"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-05-21"
+"MainOfficeKey": "422100"
+"MajorChangeTimestamp": "2025-05-25T01:30:08Z"
+"MlsStatus": "Price Change"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2025-05-22T01:52:59Z"
+"OriginalListPrice": 525000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft2428434"
+"ParkingFeatures": "Underground"
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2025-05-27T15:48:30Z"
+"PreviousListPrice": 524900.0
+"PriceChangeTimestamp": "2025-05-25T01:30:08Z"
+"Roof": "Unknown"
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "king"
+"StreetNumber": "128"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3791.0"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2%"
+"TransactionType": "For Sale"
+"UnitNumber": "908"
+"View": array:1 [ …1]
+"DDFYN": true
+"Locker": "Owned"
+"Exposure": "West"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12164273')"
+"ElevatorYN": true
+"GarageType": "Underground"
+"HeatSource": "Other"
+"SurveyType": "Available"
+"BalconyType": "Enclosed"
+"HoldoverDays": 180
+"LaundryLevel": "Main Level"
+"LegalStories": "9"
+"ParkingType1": "Owned"
+"KitchensTotal": 1
+"ParkingSpaces": 1
+"provider_name": "TRREB"
+"ApproximateAge": "0-5"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionDate": "2025-07-02"
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Suspended"
+"WashroomsType1": 1
+"CondoCorpNumber": 747
+"DenFamilyroomYN": true
+"LivingAreaRange": "600-699"
+"RoomsAboveGrade": 3
+"EnsuiteLaundryYN": true
+"SquareFootSource": "MPAC"
+"WashroomsType1Pcs": 3
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Flat"
+"LegalApartmentNumber": "908"
+"MediaChangeTimestamp": "2025-05-27T15:48:30Z"
+"SuspendedEntryTimestamp": "2025-05-23T01:38:53Z"
+"PropertyManagementCompany": "Cie Property Management & Consultants"
+"SystemModificationTimestamp": "2025-06-20T15:38:38.738562Z"
+"VendorPropertyInfoStatement": true
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:10 [ …10]
+"ID": "255219"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2864
+post_id: "285929"
+post_author: 1
+"ListingKey": "X12216811"
+"ListingId": "X12216811"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-06-20T15:37:36Z"
+"RFModificationTimestamp": "2025-06-20T16:43:03.190961+00:00"
+"ListPrice": 655000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T 1G3"
+"UnparsedAddress": "459 Drummerhill Crescent, Waterloo, ON N2T 1G3"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4461167
+"Longitude": -80.5504324
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "KELLER WILLIAMS INNOVATION REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to family-friendly Westvale! This thoughtfully updated 4-level backsplit is nestled on a quiet crescent-just steps from parks, playgrounds, walking trails, and top-rated schools. With 3 bedrooms, 2 full baths, and a functional layout, this detached home is designed for comfortable, modern living. The main level features a bright kitchen with a breakfast area, a spacious formal dining room, and sliding doors that lead to a large deck-perfect for outdoor dining and entertaining. Upstairs, you'll find three generously sized bedrooms and a 4-piece main bath. The lower level offers a warm and inviting rec room, ideal for family movie nights or casual get-togethers. Just a few steps down is a 3-piece bath, laundry area, and a finished bonus space currently used as a fourth bedroom. Enjoy the fully fenced backyard-your own private oasis shaded by mature trees. Notable updates include Furnace & A/C (2015), water softener (2019 - rented), basement flooring (2019), and basement bathroom (2019), upper level bathroom. Ideally located just minutes from Costco, The Boardwalk, shopping, dining, and entertainment-this move-in ready home is a rare opportunity to enjoy the best of Westvale living!"
+"ArchitecturalStyle": "Backsplit 4"
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": "Central Air"
+"Country": "CA"
+"CountyOrParish": "Waterloo"
+"CreationDate": "2025-06-12T23:52:06.632134+00:00"
+"CrossStreet": "THORNDALE DRIVE"
+"DirectionFaces": "North"
+"Directions": "THORNDALE DRIVE TO WESTVALE DRIVE TO DRUMMERHILL CRES"
+"ExpirationDate": "2025-08-12"
+"FireplaceYN": true
+"FoundationDetails": array:1 [ …1]
+"Inclusions": "Dishwasher, Dryer, Microwave, Range Hood, Refrigerator, Stove, Washer"
+"InteriorFeatures": "Central Vacuum,Water Heater Owned,Water Softener"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-06-12"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "350800"
+"MajorChangeTimestamp": "2025-06-20T15:37:36Z"
+"MlsStatus": "Price Change"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2025-06-12T19:01:15Z"
+"OriginalListPrice": 599000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft2546464"
+"ParcelNumber": "223950211"
+"ParkingTotal": "2.0"
+"PhotosChangeTimestamp": "2025-06-12T19:01:15Z"
+"PoolFeatures": "None"
+"PreviousListPrice": 599000.0
+"PriceChangeTimestamp": "2025-06-20T15:37:36Z"
+"Roof": "Asphalt Shingle"
+"Sewer": "Sewer"
+"ShowingRequirements": array:1 [ …1]
+"SignOnPropertyYN": true
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Drummerhill"
+"StreetNumber": "459"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "3410.0"
+"TaxLegalDescription": "LT 46 RCP 1752 CITY OF WATERLOO S/T RIGHT IN 748330; T/W 958027; S/T 669014; WATERLOO"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2% + HST"
+"TransactionType": "For Sale"
+"VirtualTourURLBranded": "https://youriguide.com/459_drummerhill_crescent_waterloo_on/"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/459_drummerhill_crescent_waterloo_on/"
+"Zoning": "R4"
+"DDFYN": true
+"Water": "Municipal"
+"GasYNA": "No"
+"HeatType": "Forced Air"
+"LotDepth": 105.06
+"LotShape": "Rectangular"
+"LotWidth": 33.2
+"WaterYNA": "Yes"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12216811')"
+"GarageType": "None"
+"HeatSource": "Gas"
+"RollNumber": "301603067501122"
+"SurveyType": "None"
+"RentalItems": "Water Softener"
+"HoldoverDays": 60
+"KitchensTotal": 1
+"ParkingSpaces": 2
+"UnderContract": array:1 [ …1]
+"provider_name": "TRREB"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "New"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"CentralVacuumYN": true
+"DenFamilyroomYN": true
+"LivingAreaRange": "700-1100"
+"RoomsAboveGrade": 3
+"PossessionDetails": "Flexible"
+"WashroomsType1Pcs": 4
+"WashroomsType2Pcs": 3
+"BedroomsAboveGrade": 3
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Second"
+"WashroomsType2Level": "Basement"
+"MediaChangeTimestamp": "2025-06-12T19:01:15Z"
+"SystemModificationTimestamp": "2025-06-20T15:37:39.089729Z"
+"Media": array:47 [ …47]
+"ID": "285929"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2861
+post_id: 294152
+post_author: 1
+"ListingKey": "X12226521"
+"ListingId": "X12226521"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-06-20T14:51:14Z"
+"RFModificationTimestamp": "2025-06-20T15:14:37.697477+00:00"
+"ListPrice": 799900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K 4L4"
+"UnparsedAddress": "831 Whitecap Avenue, Waterloo, ON N2K 4L4"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.5154314
+"Longitude": -80.5045007
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "HOMELIFE/MIRACLE REALTY LTD"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "*Welcome to 831 Whitecap Avenue* Located in the heart of the family-friendly Eastbridge neighborhood. This beautifully updated 4-bedroom, 4-bathroom detached home offers the perfect blend of style, space, and convenience. The open-concept main floor is bathed in natural light and features a kitchen with stainless steel appliances, granite counter-top and seamless flow into the living and dining areas ideal for both everyday living and entertaining. Upstairs, the spacious primary suite boasts a 3-piece en-suite and walk-in closet, while two additional bedrooms share a well-appointed 4-piece bath. The fully finished basement adds versatility with an extra bedroom, full bathroom, and flexible rec room. Updates include #1. Furnace 2025 #2. AC 2025 #3. Fresh Paint #4. Wi-Fi Garage Door Opener 2025 #5. Roof 2016 #6. Flooring, Stairs and Railings #7. Light Fixtures. Take advantage of a prime location close to top-rated schools, parks, shopping, public transit, and major highways. This move-in-ready home truly has it all."
+"ArchitecturalStyle": "2-Storey"
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2025-06-17T18:53:44.548668+00:00"
+"CrossStreet": "New Hampsphire St and Whitecap Ave"
+"DirectionFaces": "West"
+"Directions": "New Hampsphire St and Whitecap Ave"
+"ExpirationDate": "2025-10-31"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "Fridge, Stove, Dishwasher, Dryer, Wahser and Blinds"
+"InteriorFeatures": "Auto Garage Door Remote,Central Vacuum,Rough-In Bath"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-06-17"
+"MainOfficeKey": "406000"
+"MajorChangeTimestamp": "2025-06-17T16:16:58Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2025-06-17T16:16:58Z"
+"OriginalListPrice": 799900.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft2575440"
+"ParcelNumber": "227072107"
+"ParkingFeatures": "Private"
+"ParkingTotal": "2.0"
+"PhotosChangeTimestamp": "2025-06-20T14:51:13Z"
+"PoolFeatures": "None"
+"Roof": "Asphalt Shingle"
+"Sewer": "Sewer"
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Whitecap"
+"StreetNumber": "831"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "4861.27"
+"TaxLegalDescription": "LOT 140, PLAN 58M-204. S/T EASE LT68559 IN FAVOR OF UNION GAS LIMITED AND THE CORPORATION OF THE CITY OF WATERLOO OVER PART OF SAID LOT BEING PART 140 ON 58R-13184 CITY OF WATERLOO"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2% -$50 Marketing Fees + HST"
+"TransactionType": "For Sale"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/831_whitecap_ave_waterloo_on/"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotWidth": 32.23
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12226521')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "301601121900532"
+"SurveyType": "None"
+"RentalItems": "Hot Water Heater"
+"HoldoverDays": 90
+"LaundryLevel": "Lower Level"
+"KitchensTotal": 1
+"ParkingSpaces": 1
+"provider_name": "TRREB"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"WashroomsType4": 1
+"CentralVacuumYN": true
+"LivingAreaRange": "1500-2000"
+"RoomsAboveGrade": 6
+"RoomsBelowGrade": 2
+"LotSizeAreaUnits": "Square Feet"
+"PropertyFeatures": array:2 [ …2]
+"LotSizeRangeAcres": "< .50"
+"PossessionDetails": "Flexible"
+"WashroomsType1Pcs": 2
+"WashroomsType2Pcs": 3
+"WashroomsType3Pcs": 4
+"WashroomsType4Pcs": 4
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "Lockbox on Front Door."
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Second"
+"WashroomsType3Level": "Second"
+"WashroomsType4Level": "Basement"
+"MediaChangeTimestamp": "2025-06-20T14:51:13Z"
+"SystemModificationTimestamp": "2025-06-20T14:51:17.676008Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:35 [ …35]
+"ID": 294152
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2865
+post_id: 294153
+post_author: 1
+"ListingKey": "X12233919"
+"ListingId": "X12233919"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-06-20T14:39:11Z"
+"RFModificationTimestamp": "2025-06-20T15:07:37.961126+00:00"
+"ListPrice": 999900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.18
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T 2H1"
+"UnparsedAddress": "485 Beckwith Court, Waterloo, ON N2T 2H1"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4572168
+"Longitude": -80.566121
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "ENGEL & VOLKERS WATERLOO REGION"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Beautifully Renovated Home in Prime Beechwood Location! Welcome to this stunning, renovated home offering an exceptional blend of space, comfort, and style from top to bottom. Ideally situated in the highly sought-after Beechwood neighbourhood, this residence is just a 1-minute walk to Mary Johnston Public School and close to parks, amenities, and transit. Step into a welcoming foyer that opens to a spacious and thoughtfully designed layout. The double-height living and dining room is bright and airy, perfect for entertaining or relaxing in style. The large eat-in kitchen is ideal for family meals, offering plenty of room to cook, dine, and gather. Adjacent is a well-appointed family room, highlighted by a cozy gas fireplace and a walk-out to the backyarda perfect blend of indoor and outdoor living. Upstairs, you'll find three king-size bedrooms and three modern bathrooms, including a spa-like 5-piece en-suite in the primary bedroom. The upper-floor laundry adds convenience , while the large mudroom with backyard access adds functionality for busy families. The finished basement offers additional living space, a bar and a rec room, home gym, or playroom, and a 4th bathroom. The home also features an oversized double-car garage with direct entry and a driveway that fits 4 cars, with no sidewalk to maintaina rare and practical advantage. Notable updates include new flooring, fresh paint and many other improvements throughout such as : New A/C & New Furnace (2022),New flooring, baseboards, and California ceilings throughout (2023) New deck, new fence, and stylish pergola perfect for outdoor entertaining (2023).New driveway and new garage doors enhance curb appeal (2024). 220V outlet in the garage for EV charging(2024)."
+"ArchitecturalStyle": "2-Storey"
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": "Central Air"
+"Country": "CA"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "2.0"
+"CreationDate": "2025-06-20T02:54:18.851931+00:00"
+"CrossStreet": "Keats way"
+"DirectionFaces": "North"
+"Directions": "keats way to Beckwith Crescent"
+"ExpirationDate": "2025-08-18"
+"FireplaceFeatures": array:1 [ …1]
+"FireplaceYN": true
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "Dishwasher, Dryer, Garage Door Opener, Refrigerator, Stove, Washer, Window Coverings"
+"InteriorFeatures": "Water Softener"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-06-19"
+"LotSizeSource": "Geo Warehouse"
+"MainOfficeKey": "399200"
+"MajorChangeTimestamp": "2025-06-19T20:50:07Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2025-06-19T20:50:07Z"
+"OriginalListPrice": 999900.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft2583808"
+"ParcelNumber": "226850104"
+"ParkingFeatures": "Private Double"
+"ParkingTotal": "6.0"
+"PhotosChangeTimestamp": "2025-06-19T20:50:36Z"
+"PoolFeatures": "None"
+"Roof": "Asphalt Shingle"
+"Sewer": "Sewer"
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Beckwith"
+"StreetNumber": "485"
+"StreetSuffix": "Court"
+"TaxAnnualAmount": "8261.43"
+"TaxLegalDescription": "PT BLK 97 PL 1637 CITY OF WATERLOO PTS 15 & 18, 58R6254; S/T 680512, 886238, 962185; WATERLOO"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2%"
+"TransactionType": "For Sale"
+"Zoning": "SR2"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 113.19
+"LotWidth": 69.22
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12233919')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "301604046001400"
+"SurveyType": "None"
+"KitchensTotal": 1
+"ParkingSpaces": 4
+"provider_name": "TRREB"
+"AssessmentYear": 2024
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"LivingAreaRange": "2500-3000"
+"RoomsAboveGrade": 10
+"RoomsBelowGrade": 2
+"PossessionDetails": "Flexible"
+"WashroomsType1Pcs": 2
+"WashroomsType2Pcs": 4
+"WashroomsType3Pcs": 5
+"BedroomsAboveGrade": 3
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "Lockbox is located on the gas meter on the side of the house"
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Second"
+"WashroomsType3Level": "Second"
+"MediaChangeTimestamp": "2025-06-19T20:50:36Z"
+"SystemModificationTimestamp": "2025-06-20T14:39:14.316949Z"
+"Media": array:50 [ …50]
+"ID": 294153
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2863
+post_id: 294154
+post_author: 1
+"ListingKey": "X12226178"
+"ListingId": "X12226178"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-06-20T14:38:03Z"
+"RFModificationTimestamp": "2025-06-20T15:16:41.001495+00:00"
+"ListPrice": 1199000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V 1R5"
+"UnparsedAddress": "642 Red Pine Drive, Waterloo, ON N2V 1R5"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.5012586
+"Longitude": -80.5568728
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "SAM MCDADI REAL ESTATE INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "This Exquisite Four+1 -Bedroom one and a half Style Home Features A Versatile Extension Above The Garage, Currently Utilized As A Primary Bedroom, Or Effortlessly Converted Into A Spacious Family Room Or Separate Dwelling With Minor Modifications, Boasting Three Bathrooms And 1867 Square Feet Of Above-Grade, Over 3000 Square Feet Living Space, Providing Ample Room For Growing or Multigenerational Families Or Entertaining. With Recent Renovations And Addition Above The Garage Valued At Approximately $400,000. Having Upgraded The Kitchens, Bathrooms, And Flooring. Highlighting Operable Skylights With Remote Controlled Blinds, Upgraded Windows, Doors, And Hardwood Flooring, A Basement Bathroom With Radiant Heating, Hot Tub Hookup, And Pot Lights, As Well As Multiple Levels Of Outdoor Living Space, Including A Multi Level Deck And 2 Terraces, On A Meticulously Maintained And Updated Property With Notable Improvements Such As A New Steel Railing, Upgraded Bathrooms, Additional AC, Second Fireplace, Sump Pump, Roof, Gutters, And Driveway, Along With Outdoor Features Including A Shed, Gazebo, Patio Lighting And Stone Pathways Throughout Very Large Backyard, And Natural Gas Hookup For BBQ, And The Addition Above The Garage, A New Build Finished In 2022, Features A New Bathroom And Kitchenette, Spray-Foam Insulation, Hardwood Flooring, An Operable Skylight, Gas Fireplace, And AC, With Barn And French Doors. This Home Is Ideally Located In a Very Quiet family-friendly neighbourhood Nestled In Nature, Walking Distance To Northlake Woods PS, Grocery Shopping, LRT -Streetcar, Transit, Restaurants, Gyms & Laurel Creek Conservation Area And St. Jacobs Farmers Market."
+"ArchitecturalStyle": "1 1/2 Storey"
+"Basement": array:2 [ …2]
+"CoListOfficeName": "SAM MCDADI REAL ESTATE INC."
+"CoListOfficePhone": "905-502-1500"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "2.0"
+"CreationDate": "2025-06-17T16:00:32.072221+00:00"
+"CrossStreet": "Benjamin Road & Weber Street N"
+"DirectionFaces": "North"
+"Directions": "SW Corner of Benjamin Road & Weber Street N"
+"ExpirationDate": "2025-10-16"
+"FireplaceFeatures": array:1 [ …1]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "Three fridges, two stoves, two dishwashers, washer, dryer, all electrical, light fixtures, blinds"
+"InteriorFeatures": "Carpet Free,Water Heater,In-Law Suite,Sump Pump"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-06-17"
+"MainOfficeKey": "193800"
+"MajorChangeTimestamp": "2025-06-17T15:12:01Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2025-06-17T15:12:01Z"
+"OriginalListPrice": 1199000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft2575772"
+"ParcelNumber": "222601119"
+"ParkingFeatures": "Private"
+"ParkingTotal": "4.0"
+"PhotosChangeTimestamp": "2025-06-17T15:12:02Z"
+"PoolFeatures": "None"
+"Roof": "Asphalt Shingle"
+"Sewer": "Sewer"
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Red Pine"
+"StreetNumber": "642"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "8411.63"
+"TaxLegalDescription": "LOT 44 PLAN 1587 EXCEPT PTS 1 & 2 58R14971;S/T EASEMENT AS IN 831604; WATERLOO"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2% + Hst*"
+"TransactionType": "For Sale"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/642_red_pine_dr_waterloo_on/"
+"Zoning": "SR1"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 149.57
+"LotShape": "Rectangular"
+"LotWidth": 62.74
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12226178')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "301604363302000"
+"SurveyType": "Unknown"
+"HoldoverDays": 180
+"KitchensTotal": 2
+"ParkingSpaces": 2
+"provider_name": "TRREB"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"DenFamilyroomYN": true
+"LivingAreaRange": "1500-2000"
+"RoomsAboveGrade": 10
+"RoomsBelowGrade": 4
+"PossessionDetails": "Flexible"
+"WashroomsType1Pcs": 4
+"WashroomsType2Pcs": 3
+"WashroomsType3Pcs": 3
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"KitchensAboveGrade": 1
+"KitchensBelowGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Ground"
+"WashroomsType2Level": "Second"
+"WashroomsType3Level": "Lower"
+"MediaChangeTimestamp": "2025-06-17T15:12:02Z"
+"SystemModificationTimestamp": "2025-06-20T14:38:05.900847Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:39 [ …39]
+"ID": 294154
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2856
+post_id: "286627"
+post_author: 1
+"ListingKey": "X12139700"
+"ListingId": "X12139700"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-06-20T14:29:24Z"
+"RFModificationTimestamp": "2025-06-20T14:42:45.544470+00:00"
+"ListPrice": 649900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J 2K7"
+"UnparsedAddress": "227 Bridgeport Road, Waterloo, On N2j 2k7"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.472216
+"Longitude": -80.5039636
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "Red And White Realty Inc"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "OPEN HOUSE SAT. JUNE 21, 1:00-3:00. Are you looking to invest in a family home that is centrally located? 227 Bridgeport Rd. E. is walkable to Up Town Waterloo, which is the destination for shops, restaurants, cafes, the LRT, the Waterloo Public Library, Waterloo Park, and so much more. This home is also close to schools, more parks, grocery stores, and a quick drive to the Expressway, Grand River Hospital, the Universities, and even St. Jacob's if you want to visit the market. With 1287 TOTAL Sq Ft this home has 3+1 bedrooms and 2.5 bathrooms - this is perfect for first time home buyers and investors. It is located on a large 62'x148' lot and has a 16'x30' detached garage w/ hydro...which is a dream to store your big toys or use as a workshop. The spacious backyard is fully fenced, so its perfect for your kiddos and pets to run around. This house has a lot of character, yet many updates have been done. Some highlights include: a modern kitchen with quartz counter tops, a newer roof, a main floor powder room, 200 amp electrical, and a fully finished basement with an additional bedroom and bathroom."
+"ArchitecturalStyle": "1 1/2 Storey"
+"Basement": array:2 [ …2]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": "Central Air"
+"Country": "CA"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "2.0"
+"CreationDate": "2025-05-10T18:40:42.254864+00:00"
+"CrossStreet": "Margaret"
+"DirectionFaces": "North"
+"Directions": "BETWEEN BLUEVALE AND MARGARET. Bridgeport is a ONE WAY St."
+"ExpirationDate": "2025-07-31"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "Dishwasher, Dryer, Hot Water Tank Owned, Microwave, Refrigerator, Stove, Washer, Water Softener"
+"InteriorFeatures": "Water Heater Owned"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "One Point Association of REALTORS"
+"ListingContractDate": "2025-05-10"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "575000"
+"MajorChangeTimestamp": "2025-06-16T22:15:35Z"
+"MlsStatus": "Price Change"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2025-05-10T18:10:29Z"
+"OriginalListPrice": 699900.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft2370676"
+"ParcelNumber": "223490173"
+"ParkingFeatures": "Private Double"
+"ParkingTotal": "8.0"
+"PhotosChangeTimestamp": "2025-06-20T14:27:26Z"
+"PoolFeatures": "None"
+"PreviousListPrice": 699900.0
+"PriceChangeTimestamp": "2025-06-16T22:15:35Z"
+"Roof": "Asphalt Shingle"
+"Sewer": "Sewer"
+"ShowingRequirements": array:2 [ …2]
+"SignOnPropertyYN": true
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "E"
+"StreetName": "Bridgeport"
+"StreetNumber": "227"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "3474.0"
+"TaxAssessedValue": 273000
+"TaxLegalDescription": "LT 17 SUBDIVISION OF LT 5 GERMAN COMPANY TRACT CITY OF WATERLOO; PT LT 18 SUBDIVISION OF LT 5 GERMAN COMPANY TRACT CITY OF WATERLOO AS IN 837992; WATERLOO"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2%"
+"TransactionType": "For Sale"
+"VirtualTourURLBranded": "https://www.youtube.com/watch?v=2u9q G9h4Ec M"
+"Zoning": "SR2"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 148.0
+"LotShape": "Rectangular"
+"LotWidth": 62.0
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12139700')"
+"GarageType": "Detached"
+"HeatSource": "Gas"
+"RollNumber": "301601045015600"
+"SurveyType": "None"
+"HoldoverDays": 90
+"LaundryLevel": "Lower Level"
+"KitchensTotal": 1
+"ParkingSpaces": 6
+"provider_name": "TRREB"
+"ApproximateAge": "51-99"
+"AssessmentYear": 2024
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "New"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"DenFamilyroomYN": true
+"LivingAreaRange": "700-1100"
+"RoomsAboveGrade": 11
+"LotSizeAreaUnits": "Acres"
+"PropertyFeatures": array:6 [ …6]
+"LotSizeRangeAcres": "< .50"
+"PossessionDetails": "45-60 days"
+"WashroomsType1Pcs": 4
+"WashroomsType2Pcs": 2
+"WashroomsType3Pcs": 3
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "Out of Town agents must have Sentri Connect Ap for LB."
+"WashroomsType1Level": "Second"
+"WashroomsType2Level": "Main"
+"WashroomsType3Level": "Basement"
+"MediaChangeTimestamp": "2025-06-20T14:27:26Z"
+"SystemModificationTimestamp": "2025-06-20T14:29:27.679721Z"
+"Media": array:37 [ …37]
+"ID": "286627"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2854
+post_id: "210553"
+post_author: 1
+"ListingKey": "X12103856"
+"ListingId": "X12103856"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Sale Of Business"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-06-20T11:32:41Z"
+"RFModificationTimestamp": "2025-06-20T11:35:56.919706+00:00"
+"ListPrice": 280000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 1477.02
+"City": "Waterloo"
+"PostalCode": "N2L 6J3"
+"UnparsedAddress": "#1b - 140 University Avenue, Waterloo, On N2l 6j3"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4730414
+"Longitude": -80.5353937
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX EPIC REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Seize the chance to own one of the worlds most coveted bubble tea franchises! Ideally situated between Wilfrid Laurier University and the University of Waterloo, this prime location enjoys an impressive daily foot traffic of over 40,000. The bustling area is teeming with diverse businesses that attract a constant flow of students and visitors. Dont miss out on this exceptional opportunity to invest in a highly sought-after brand with immense potential! Key advantages include a prime location with low rent, excellent support, low maintenance, and flexible working hours. Perfect for both new and experienced entrepreneurs, this is an incredible chance to benefit from a strong brand presence in a high-traffic area."
+"BuildingAreaUnits": "Square Feet"
+"BusinessType": array:1 [ …1]
+"CoListOfficeName": "RE/MAX EPIC REALTY"
+"CoListOfficePhone": "905-604-6646"
+"Cooling": "Yes"
+"CountyOrParish": "Waterloo"
+"CreationDate": "2025-04-25T14:37:28.034222+00:00"
+"CrossStreet": "University Ave W And Phillip"
+"Directions": "W"
+"ExpirationDate": "2025-07-22"
+"HoursDaysOfOperation": array:1 [ …1]
+"HoursDaysOfOperationDescription": "10"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-04-25"
+"MainOfficeKey": "352300"
+"MajorChangeTimestamp": "2025-04-25T14:20:57Z"
+"MlsStatus": "New"
+"NumberOfFullTimeEmployees": 20
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2025-04-25T14:20:57Z"
+"OriginalListPrice": 280000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft2287960"
+"ParcelNumber": "223650200"
+"PhotosChangeTimestamp": "2025-04-25T14:20:58Z"
+"SeatingCapacity": "10"
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "W"
+"StreetName": "University"
+"StreetNumber": "140"
+"StreetSuffix": "Avenue"
+"TaxYear": "2024"
+"TransactionBrokerCompensation": "4%+hst"
+"TransactionType": "For Sale"
+"UnitNumber": "1B"
+"Utilities": "Available"
+"Zoning": "C4 COMMERCIAL"
+"DDFYN": true
+"Water": "Municipal"
+"LotType": "Unit"
+"TaxType": "N/A"
+"HeatType": "Gas Forced Air Closed"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12103856')"
+"ChattelsYN": true
+"GarageType": "Plaza"
+"RetailArea": 1477.02
+"FranchiseYN": true
+"PropertyUse": "Without Property"
+"RentalItems": "HVAC 326.57 per month"
+"HoldoverDays": 90
+"ListPriceUnit": "For Sale"
+"provider_name": "TRREB"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionDate": "2025-05-29"
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"RetailAreaCode": "Sq Ft"
+"MediaChangeTimestamp": "2025-04-25T14:20:58Z"
+"SystemModificationTimestamp": "2025-06-20T11:32:41.228539Z"
+"FinancialStatementAvailableYN": true
+"Media": array:8 [ …8]
+"ID": "210553"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2866
+post_id: 294155
+post_author: 1
+"ListingKey": "X12234535"
+"ListingId": "X12234535"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-06-20T04:29:28Z"
+"RFModificationTimestamp": "2025-06-21T01:00:34.245060+00:00"
+"ListPrice": 2150.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J 2X9"
+"UnparsedAddress": "#710 - 128 King Street, Waterloo, ON N2J 2X9"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4652699
+"Longitude": -80.5222961
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX ULTIMATE REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome To One28 Condos On King Street. This Newest Uptown Waterloo Condo Comes With 9 Feet Ceiling. Amazing 1 Bed+Den Unit Used As 2 Bedroom On 7th Floor Comes With Very Open Concept. Spacious Living, Dining, Kitchen Area & Walk Out To Balcony, Stainless Steel Appliances, Quartz Countertops - In-Suite Laundry - Laminate Floors. Nice Size Bedroom With East View From Balcony, Easy Access To Ion Lrt Transit, Close Proximity To Waterloo And Laurier University, Downtown Waterloo, Shops & Nice Restaurants."
+"ArchitecturalStyle": "Apartment"
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CreationDate": "2025-06-20T04:41:40.169899+00:00"
+"CrossStreet": "King Street North & Elgin St."
+"Directions": "King Street North & Elgin St."
+"ExpirationDate": "2025-09-19"
+"Furnished": "Unfurnished"
+"Inclusions": "Stainless Steel Appliances - Fridge, Stove, Dishwasher, Microwave. Many Amenities In The Building - Party Room, Fitness Room , Yoga Room, Green Roof, Outdoor Terrace With Bbq Facility!"
+"InteriorFeatures": "None"
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"LeaseTerm": "12 Months"
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-06-20"
+"MainOfficeKey": "498700"
+"MajorChangeTimestamp": "2025-06-20T04:29:28Z"
+"MlsStatus": "New"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2025-06-20T04:29:28Z"
+"OriginalListPrice": 2150.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft2508784"
+"ParkingFeatures": "None"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2025-06-20T04:29:28Z"
+"RentIncludes": array:1 [ …1]
+"ShowingRequirements": array:1 [ …1]
+"SignOnPropertyYN": true
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "N"
+"StreetName": "King"
+"StreetNumber": "128"
+"StreetSuffix": "Street"
+"TransactionBrokerCompensation": "1/2 Mon"
+"TransactionType": "For Lease"
+"UnitNumber": "710"
+"DDFYN": true
+"Locker": "Exclusive"
+"Exposure": "East"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12234535')"
+"GarageType": "None"
+"HeatSource": "Gas"
+"LockerUnit": "19"
+"SurveyType": "None"
+"BalconyType": "Terrace"
+"LockerLevel": "4"
+"HoldoverDays": 90
+"LegalStories": "7"
+"ParkingType1": "None"
+"CreditCheckYN": true
+"KitchensTotal": 1
+"PaymentMethod": "Cheque"
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2J 2X9, CA"
+"ContractStatus": "Available"
+"PossessionDate": "2025-08-01"
+"PossessionType": "30-59 days"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"CondoCorpNumber": 747
+"DepositRequired": true
+"LivingAreaRange": "600-699"
+"RoomsAboveGrade": 6
+"EnsuiteLaundryYN": true
+"LeaseAgreementYN": true
+"PaymentFrequency": "Monthly"
+"SquareFootSource": "Builder"
+"PossessionDetails": "TBA"
+"PrivateEntranceYN": true
+"WashroomsType1Pcs": 4
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"EmploymentLetterYN": true
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"RentalApplicationYN": true
+"WashroomsType1Level": "Main"
+"LegalApartmentNumber": "10"
+"MediaChangeTimestamp": "2025-06-20T04:29:28Z"
+"PortionPropertyLease": array:1 [ …1]
+"ReferencesRequiredYN": true
+"PropertyManagementCompany": "Cie Property Mngt & Consu"
+"SystemModificationTimestamp": "2025-06-20T04:29:28.8285Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:27 [ …27]
+"ID": 294155
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2867
+post_id: "258358"
+post_author: 1
+"ListingKey": "X12152785"
+"ListingId": "X12152785"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-06-20T02:10:32Z"
+"RFModificationTimestamp": "2025-06-20T04:48:03.331974+00:00"
+"ListPrice": 779900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 0J8"
+"UnparsedAddress": "#710 - 155 Caroline Street, Waterloo, ON N2L 0J8"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4652699
+"Longitude": -80.5222961
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "CRIMSON REALTY POINT INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Nicely Kept Two Bed Plus Den Condo Apartment In The Prestigious Caroline Street Private Residences In Uptown Waterloo With Owned Parking And Locker. 943 Square feet of luxury plus a balcony of 85 Square feet. Spacious Principal Bedroom With 4Pc En-Suite. A Second Bedroom And a Den Plus Another Full Bathroom. Spacious Kitchen And Living Area. Classy Amenities Including Exercise Room, Games Room, Guest Suites, Media Room, Party/Meeting Room, Concierge And Visitor Parking. Unit rented for $2800 p.m. to a very responsible and clean tenant. Buyer to assume Tenant until end of his current lease on July 31, 2025. Tenant would like to continue leasing. Great income opportunity."
+"ArchitecturalStyle": "Apartment"
+"AssociationFee": "635.53"
+"AssociationFeeIncludes": array:3 [ …3]
+"Basement": array:1 [ …1]
+"BuildingName": "Caroline Street Private Residences"
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2025-05-16T04:48:08.467324+00:00"
+"CrossStreet": "King / John W"
+"Directions": "King Street to John St W- right to Caroline"
+"ExpirationDate": "2025-10-30"
+"Inclusions": "S/S Fridge, Stove, Built-In Dish Washer, Microwave Exhaust, Clothes Washer & Dryer, Ceramic Backsplash. Spacious Balcony, Owned Parking And Locker."
+"InteriorFeatures": "None"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-05-15"
+"MainOfficeKey": "232000"
+"MajorChangeTimestamp": "2025-05-16T02:51:34Z"
+"MlsStatus": "New"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2025-05-16T02:51:34Z"
+"OriginalListPrice": 779900.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft2401822"
+"ParcelNumber": "236770319"
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2025-05-16T02:51:35Z"
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "S"
+"StreetName": "Caroline"
+"StreetNumber": "155"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4631.92"
+"TaxYear": "2024"
+"TransactionBrokerCompensation": "2.25% + HST and Thanks"
+"TransactionType": "For Sale"
+"UnitNumber": "710"
+"View": array:1 [ …1]
+"DDFYN": true
+"Locker": "Owned"
+"Exposure": "South"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12152785')"
+"GarageType": "Underground"
+"HeatSource": "Gas"
+"RollNumber": "301603045002268"
+"SurveyType": "None"
+"BalconyType": "Open"
+"LockerLevel": "A"
+"RentalItems": "fan Coil - $ 81.81 p.m."
+"HoldoverDays": 60
+"LaundryLevel": "Main Level"
+"LegalStories": "7"
+"LockerNumber": "173"
+"ParkingSpot1": "44"
+"ParkingType1": "Owned"
+"KitchensTotal": 1
+"provider_name": "TRREB"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionDate": "2025-05-30"
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"CondoCorpNumber": 677
+"LivingAreaRange": "900-999"
+"RoomsAboveGrade": 7
+"SquareFootSource": "Builder"
+"ParkingLevelUnit1": "A"
+"PossessionDetails": "Take over Tenant"
+"WashroomsType1Pcs": 4
+"WashroomsType2Pcs": 4
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"StatusCertificateYN": true
+"WashroomsType1Level": "Flat"
+"WashroomsType2Level": "Flat"
+"LegalApartmentNumber": "10"
+"MediaChangeTimestamp": "2025-05-16T02:51:35Z"
+"PropertyManagementCompany": "Weigel Property Management - 519-893-4411"
+"SystemModificationTimestamp": "2025-06-20T02:10:34.718385Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:24 [ …24]
+"ID": "258358"
}
9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2868
+post_id: "193371"
+post_author: 1
+"ListingKey": "X12060069"
+"ListingId": "X12060069"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Townhouse"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-06-20T01:10:44Z"
+"RFModificationTimestamp": "2025-06-20T05:15:21.930313+00:00"
+"ListPrice": 499000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T 2G7"
+"UnparsedAddress": "523 Beechwood Drive, Waterloo, On N2t 2g7"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.450926210743
+"Longitude": -80.561687865141
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX TWIN CITY REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to Beechwood Classics, an Executive Townhouse community located in Waterloo's prestigious Beechwood West neighbourhood. Unit 4 offers a single car garage, private driveway, visitor parking in close proximity and a private backyard facing greenery. Inside you will find 3 Bedrooms, 4 Bathrooms, and over 2300 sqft of finished living space. Recent upgrades include fresh paint (2025), a new heat pump with extended warranty (Nov 2024), renovated bathrooms (2021 & 2024), a stunning main level natural gas fireplace (2017), and a Safe Bathing Accessible Tub (Nov 2021). Special additional features include California shutters, central vac, basement walkout, and a luxuriously sized primary bedroom complete with a walk-in closet and 5-piece ensuite. The prime location of this home also cannot be beat with close proximity to walking trails, parks, top rated schools, the Zehrs complex, and all the amenities the West End has to offer including The Boardwalk, Shoppers Drug Mart Complex, and Costco. This home truly has it all. Don't miss the virtual tour!"
+"ArchitecturalStyle": "2-Storey"
+"AssociationFee": "742.0"
+"AssociationFeeIncludes": array:2 [ …2]
+"Basement": array:2 [ …2]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2025-04-04T06:52:00.158292+00:00"
+"CrossStreet": "Maple Forest"
+"Directions": "Erb Street West to Beechwood Drive."
+"Exclusions": "Basement Fridge, Basement Freezer."
+"ExpirationDate": "2025-07-04"
+"FireplaceYN": true
+"GarageYN": true
+"Inclusions": "Central Vac, Dishwasher, Dryer, Garage Door Opener, Range Hood, Refrigerator, Stove, Washer, Window Coverings, All Existing Light Fixtures, 2 Garage Door Remotes, Projector Screen & Speakers (Basement)."
+"InteriorFeatures": "Water Softener"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-04-03"
+"MainOfficeKey": "360900"
+"MajorChangeTimestamp": "2025-06-20T01:10:44Z"
+"MlsStatus": "Price Change"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2025-04-03T17:30:50Z"
+"OriginalListPrice": 585000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft2187022"
+"ParcelNumber": "231250004"
+"ParkingTotal": "2.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2025-05-31T17:01:23Z"
+"PreviousListPrice": 545000.0
+"PriceChangeTimestamp": "2025-06-20T01:10:44Z"
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Beechwood"
+"StreetNumber": "523"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "3359.41"
+"TaxYear": "2024"
+"TransactionBrokerCompensation": "2.0% + HST"
+"TransactionType": "For Sale"
+"UnitNumber": "4"
+"VirtualTourURLBranded": "https://youriguide.com/4_523_beechwood_dr_waterloo_on/"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "East"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12060069')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "301604051509204"
+"SurveyType": "None"
+"BalconyType": "None"
+"RentalItems": "Hot Water Heater, Water Softener"
+"HoldoverDays": 60
+"LegalStories": "Level 1"
+"ParkingType1": "Exclusive"
+"KitchensTotal": 1
+"ParkingSpaces": 1
+"UnderContract": array:2 [ …2]
+"provider_name": "TRREB"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "New"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"WashroomsType4": 1
+"CondoCorpNumber": 125
+"DenFamilyroomYN": true
+"LivingAreaRange": "1600-1799"
+"RoomsAboveGrade": 6
+"RoomsBelowGrade": 1
+"SquareFootSource": "i Guide"
+"PossessionDetails": "Flexible"
+"WashroomsType1Pcs": 3
+"WashroomsType2Pcs": 2
+"WashroomsType3Pcs": 4
+"WashroomsType4Pcs": 5
+"BedroomsAboveGrade": 3
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "Showing Time"
+"StatusCertificateYN": true
+"WashroomsType1Level": "Basement"
+"WashroomsType2Level": "Main"
+"WashroomsType3Level": "Second"
+"WashroomsType4Level": "Second"
+"LegalApartmentNumber": "Unit 4"
+"MediaChangeTimestamp": "2025-05-31T17:01:23Z"
+"PropertyManagementCompany": "LMS"
+"SystemModificationTimestamp": "2025-06-20T01:10:46.33196Z"
+"Media": array:33 [ …33]
+"ID": "193371"
}
]
+success: true
+page_size: 10
+page_count: 71
+count: 705
+after_key: ""
}
"RF Response Time" => "0.63 seconds"
]
"RF Cache Key: 5d358a8bb6dd0ac7946520a26328ed68e3e4970f428522983cf6e3c0f7c9c105" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#3115
+items: array:10 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4306
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12164273"
+"ListingId": "X12164273"
+"PropertyType": "Residential"
+"PropertySubType": "Common Element Condo"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-06-20T15:38:35Z"
+"RFModificationTimestamp": "2025-06-20T16:31:32.825085+00:00"
+"ListPrice": 524500.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J 0E9"
+"UnparsedAddress": "#908 - 128 King Street, Waterloo, ON N2J 0E9"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4652699
+"Longitude": -80.5222961
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "META REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to ONE28 A Contemporary Condominium Residence in the Heart of Waterloo Presenting a refined opportunity to own a luxurious 1-bedroom + den suite in ONE28, an upscale 3-year-old condominium ideally situated just steps from Wilfrid Laurier University and mere minutes from the University of Waterloo. Designed for modern urban living, this meticulously maintained residence boasts exceptionally low maintenance fees and access to premium, resort-style amenities. Spanning over 680 square feet of open-concept living space, this sun-drenched unit features an expansive layout with a private balcony offering unobstructed eastern views. The thoughtfully designed foyer leads into an upgraded L-shaped kitchen adorned with full-sized stainless steel appliances, tall cabinetry, quartz countertops, double sinks, and a stylish backsplash. The generously sized living and dining area seamlessly extends to the balcony perfect for entertaining or quiet enjoyment. The primary bedroom serves as a serene retreat with floor-to-ceiling windows, full walk in closet, while the den offers flexibility to function as a home office or potential second bedroom. Additional features include in-suite laundry conveniently located beside a spa-inspired 4-piece bathroom, one designated parking space, and a secure locker for added storage. Enjoy access to a wealth of high-end amenities including:24/7 concierge services. Fully equipped fitness center and yoga studio Media/party room Rooftop terrace with BBQ stations. Secure bike storage and EV charging stations ***Deco White Black out draper added in the bedroom, Living Room & Balcony, Home Depot Installed Worth $2000***"
+"ArchitecturalStyle": array:1 [ …1]
+"AssociationFee": "457.41"
+"AssociationFeeIncludes": array:2 [ …2]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2025-05-22T01:58:28.131191+00:00"
+"CrossStreet": "Regina/King St"
+"Directions": "King St/ Elgin St"
+"ExpirationDate": "2025-08-22"
+"GarageYN": true
+"Inclusions": "Fridge, stove, Washer, Dryer, Black Out Drapper"
+"InteriorFeatures": array:3 [ …3]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-05-21"
+"MainOfficeKey": "422100"
+"MajorChangeTimestamp": "2025-05-25T01:30:08Z"
+"MlsStatus": "Price Change"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2025-05-22T01:52:59Z"
+"OriginalListPrice": 525000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft2428434"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2025-05-27T15:48:30Z"
+"PreviousListPrice": 524900.0
+"PriceChangeTimestamp": "2025-05-25T01:30:08Z"
+"Roof": array:1 [ …1]
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "king"
+"StreetNumber": "128"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3791.0"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2%"
+"TransactionType": "For Sale"
+"UnitNumber": "908"
+"View": array:1 [ …1]
+"DDFYN": true
+"Locker": "Owned"
+"Exposure": "West"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12164273')"
+"ElevatorYN": true
+"GarageType": "Underground"
+"HeatSource": "Other"
+"SurveyType": "Available"
+"BalconyType": "Enclosed"
+"HoldoverDays": 180
+"LaundryLevel": "Main Level"
+"LegalStories": "9"
+"ParkingType1": "Owned"
+"KitchensTotal": 1
+"ParkingSpaces": 1
+"provider_name": "TRREB"
+"ApproximateAge": "0-5"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionDate": "2025-07-02"
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Suspended"
+"WashroomsType1": 1
+"CondoCorpNumber": 747
+"DenFamilyroomYN": true
+"LivingAreaRange": "600-699"
+"RoomsAboveGrade": 3
+"EnsuiteLaundryYN": true
+"SquareFootSource": "MPAC"
+"WashroomsType1Pcs": 3
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Flat"
+"LegalApartmentNumber": "908"
+"MediaChangeTimestamp": "2025-05-27T15:48:30Z"
+"SuspendedEntryTimestamp": "2025-05-23T01:38:53Z"
+"PropertyManagementCompany": "Cie Property Management & Consultants"
+"SystemModificationTimestamp": "2025-06-20T15:38:38.738562Z"
+"VendorPropertyInfoStatement": true
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:10 [ …10]
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4307
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12216811"
+"ListingId": "X12216811"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-06-20T15:37:36Z"
+"RFModificationTimestamp": "2025-06-20T16:43:03.190961+00:00"
+"ListPrice": 655000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T 1G3"
+"UnparsedAddress": "459 Drummerhill Crescent, Waterloo, ON N2T 1G3"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4461167
+"Longitude": -80.5504324
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "KELLER WILLIAMS INNOVATION REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to family-friendly Westvale! This thoughtfully updated 4-level backsplit is nestled on a quiet crescent-just steps from parks, playgrounds, walking trails, and top-rated schools. With 3 bedrooms, 2 full baths, and a functional layout, this detached home is designed for comfortable, modern living. The main level features a bright kitchen with a breakfast area, a spacious formal dining room, and sliding doors that lead to a large deck-perfect for outdoor dining and entertaining. Upstairs, you'll find three generously sized bedrooms and a 4-piece main bath. The lower level offers a warm and inviting rec room, ideal for family movie nights or casual get-togethers. Just a few steps down is a 3-piece bath, laundry area, and a finished bonus space currently used as a fourth bedroom. Enjoy the fully fenced backyard-your own private oasis shaded by mature trees. Notable updates include Furnace & A/C (2015), water softener (2019 - rented), basement flooring (2019), and basement bathroom (2019), upper level bathroom. Ideally located just minutes from Costco, The Boardwalk, shopping, dining, and entertainment-this move-in ready home is a rare opportunity to enjoy the best of Westvale living!"
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"Country": "CA"
+"CountyOrParish": "Waterloo"
+"CreationDate": "2025-06-12T23:52:06.632134+00:00"
+"CrossStreet": "THORNDALE DRIVE"
+"DirectionFaces": "North"
+"Directions": "THORNDALE DRIVE TO WESTVALE DRIVE TO DRUMMERHILL CRES"
+"ExpirationDate": "2025-08-12"
+"FireplaceYN": true
+"FoundationDetails": array:1 [ …1]
+"Inclusions": "Dishwasher, Dryer, Microwave, Range Hood, Refrigerator, Stove, Washer"
+"InteriorFeatures": array:3 [ …3]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-06-12"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "350800"
+"MajorChangeTimestamp": "2025-06-20T15:37:36Z"
+"MlsStatus": "Price Change"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2025-06-12T19:01:15Z"
+"OriginalListPrice": 599000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft2546464"
+"ParcelNumber": "223950211"
+"ParkingTotal": "2.0"
+"PhotosChangeTimestamp": "2025-06-12T19:01:15Z"
+"PoolFeatures": array:1 [ …1]
+"PreviousListPrice": 599000.0
+"PriceChangeTimestamp": "2025-06-20T15:37:36Z"
+"Roof": array:1 [ …1]
+"Sewer": array:1 [ …1]
+"ShowingRequirements": array:1 [ …1]
+"SignOnPropertyYN": true
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Drummerhill"
+"StreetNumber": "459"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "3410.0"
+"TaxLegalDescription": "LT 46 RCP 1752 CITY OF WATERLOO S/T RIGHT IN 748330; T/W 958027; S/T 669014; WATERLOO"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2% + HST"
+"TransactionType": "For Sale"
+"VirtualTourURLBranded": "https://youriguide.com/459_drummerhill_crescent_waterloo_on/"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/459_drummerhill_crescent_waterloo_on/"
+"Zoning": "R4"
+"DDFYN": true
+"Water": "Municipal"
+"GasYNA": "No"
+"HeatType": "Forced Air"
+"LotDepth": 105.06
+"LotShape": "Rectangular"
+"LotWidth": 33.2
+"WaterYNA": "Yes"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12216811')"
+"GarageType": "None"
+"HeatSource": "Gas"
+"RollNumber": "301603067501122"
+"SurveyType": "None"
+"RentalItems": "Water Softener"
+"HoldoverDays": 60
+"KitchensTotal": 1
+"ParkingSpaces": 2
+"UnderContract": array:1 [ …1]
+"provider_name": "TRREB"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "New"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"CentralVacuumYN": true
+"DenFamilyroomYN": true
+"LivingAreaRange": "700-1100"
+"RoomsAboveGrade": 3
+"PossessionDetails": "Flexible"
+"WashroomsType1Pcs": 4
+"WashroomsType2Pcs": 3
+"BedroomsAboveGrade": 3
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Second"
+"WashroomsType2Level": "Basement"
+"MediaChangeTimestamp": "2025-06-12T19:01:15Z"
+"SystemModificationTimestamp": "2025-06-20T15:37:39.089729Z"
+"Media": array:47 [ …47]
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4310
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12226521"
+"ListingId": "X12226521"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-06-20T14:51:14Z"
+"RFModificationTimestamp": "2025-06-20T15:14:37.697477+00:00"
+"ListPrice": 799900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K 4L4"
+"UnparsedAddress": "831 Whitecap Avenue, Waterloo, ON N2K 4L4"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.5154314
+"Longitude": -80.5045007
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "HOMELIFE/MIRACLE REALTY LTD"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "*Welcome to 831 Whitecap Avenue* Located in the heart of the family-friendly Eastbridge neighborhood. This beautifully updated 4-bedroom, 4-bathroom detached home offers the perfect blend of style, space, and convenience. The open-concept main floor is bathed in natural light and features a kitchen with stainless steel appliances, granite counter-top and seamless flow into the living and dining areas ideal for both everyday living and entertaining. Upstairs, the spacious primary suite boasts a 3-piece en-suite and walk-in closet, while two additional bedrooms share a well-appointed 4-piece bath. The fully finished basement adds versatility with an extra bedroom, full bathroom, and flexible rec room. Updates include #1. Furnace 2025 #2. AC 2025 #3. Fresh Paint #4. Wi-Fi Garage Door Opener 2025 #5. Roof 2016 #6. Flooring, Stairs and Railings #7. Light Fixtures. Take advantage of a prime location close to top-rated schools, parks, shopping, public transit, and major highways. This move-in-ready home truly has it all."
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2025-06-17T18:53:44.548668+00:00"
+"CrossStreet": "New Hampsphire St and Whitecap Ave"
+"DirectionFaces": "West"
+"Directions": "New Hampsphire St and Whitecap Ave"
+"ExpirationDate": "2025-10-31"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "Fridge, Stove, Dishwasher, Dryer, Wahser and Blinds"
+"InteriorFeatures": array:3 [ …3]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-06-17"
+"MainOfficeKey": "406000"
+"MajorChangeTimestamp": "2025-06-17T16:16:58Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2025-06-17T16:16:58Z"
+"OriginalListPrice": 799900.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft2575440"
+"ParcelNumber": "227072107"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "2.0"
+"PhotosChangeTimestamp": "2025-06-20T14:51:13Z"
+"PoolFeatures": array:1 [ …1]
+"Roof": array:1 [ …1]
+"Sewer": array:1 [ …1]
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Whitecap"
+"StreetNumber": "831"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "4861.27"
+"TaxLegalDescription": "LOT 140, PLAN 58M-204. S/T EASE LT68559 IN FAVOR OF UNION GAS LIMITED AND THE CORPORATION OF THE CITY OF WATERLOO OVER PART OF SAID LOT BEING PART 140 ON 58R-13184 CITY OF WATERLOO"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2% -$50 Marketing Fees + HST"
+"TransactionType": "For Sale"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/831_whitecap_ave_waterloo_on/"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotWidth": 32.23
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12226521')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "301601121900532"
+"SurveyType": "None"
+"RentalItems": "Hot Water Heater"
+"HoldoverDays": 90
+"LaundryLevel": "Lower Level"
+"KitchensTotal": 1
+"ParkingSpaces": 1
+"provider_name": "TRREB"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"WashroomsType4": 1
+"CentralVacuumYN": true
+"LivingAreaRange": "1500-2000"
+"RoomsAboveGrade": 6
+"RoomsBelowGrade": 2
+"LotSizeAreaUnits": "Square Feet"
+"PropertyFeatures": array:2 [ …2]
+"LotSizeRangeAcres": "< .50"
+"PossessionDetails": "Flexible"
+"WashroomsType1Pcs": 2
+"WashroomsType2Pcs": 3
+"WashroomsType3Pcs": 4
+"WashroomsType4Pcs": 4
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "Lockbox on Front Door."
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Second"
+"WashroomsType3Level": "Second"
+"WashroomsType4Level": "Basement"
+"MediaChangeTimestamp": "2025-06-20T14:51:13Z"
+"SystemModificationTimestamp": "2025-06-20T14:51:17.676008Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:35 [ …35]
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4309
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12233919"
+"ListingId": "X12233919"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-06-20T14:39:11Z"
+"RFModificationTimestamp": "2025-06-20T15:07:37.961126+00:00"
+"ListPrice": 999900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.18
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T 2H1"
+"UnparsedAddress": "485 Beckwith Court, Waterloo, ON N2T 2H1"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4572168
+"Longitude": -80.566121
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "ENGEL & VOLKERS WATERLOO REGION"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Beautifully Renovated Home in Prime Beechwood Location! Welcome to this stunning, renovated home offering an exceptional blend of space, comfort, and style from top to bottom. Ideally situated in the highly sought-after Beechwood neighbourhood, this residence is just a 1-minute walk to Mary Johnston Public School and close to parks, amenities, and transit. Step into a welcoming foyer that opens to a spacious and thoughtfully designed layout. The double-height living and dining room is bright and airy, perfect for entertaining or relaxing in style. The large eat-in kitchen is ideal for family meals, offering plenty of room to cook, dine, and gather. Adjacent is a well-appointed family room, highlighted by a cozy gas fireplace and a walk-out to the backyarda perfect blend of indoor and outdoor living. Upstairs, you'll find three king-size bedrooms and three modern bathrooms, including a spa-like 5-piece en-suite in the primary bedroom. The upper-floor laundry adds convenience , while the large mudroom with backyard access adds functionality for busy families. The finished basement offers additional living space, a bar and a rec room, home gym, or playroom, and a 4th bathroom. The home also features an oversized double-car garage with direct entry and a driveway that fits 4 cars, with no sidewalk to maintaina rare and practical advantage. Notable updates include new flooring, fresh paint and many other improvements throughout such as : New A/C & New Furnace (2022),New flooring, baseboards, and California ceilings throughout (2023) New deck, new fence, and stylish pergola perfect for outdoor entertaining (2023).New driveway and new garage doors enhance curb appeal (2024). 220V outlet in the garage for EV charging(2024)."
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"Country": "CA"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "2.0"
+"CreationDate": "2025-06-20T02:54:18.851931+00:00"
+"CrossStreet": "Keats way"
+"DirectionFaces": "North"
+"Directions": "keats way to Beckwith Crescent"
+"ExpirationDate": "2025-08-18"
+"FireplaceFeatures": array:1 [ …1]
+"FireplaceYN": true
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "Dishwasher, Dryer, Garage Door Opener, Refrigerator, Stove, Washer, Window Coverings"
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-06-19"
+"LotSizeSource": "Geo Warehouse"
+"MainOfficeKey": "399200"
+"MajorChangeTimestamp": "2025-06-19T20:50:07Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2025-06-19T20:50:07Z"
+"OriginalListPrice": 999900.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft2583808"
+"ParcelNumber": "226850104"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "6.0"
+"PhotosChangeTimestamp": "2025-06-19T20:50:36Z"
+"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": "Beckwith"
+"StreetNumber": "485"
+"StreetSuffix": "Court"
+"TaxAnnualAmount": "8261.43"
+"TaxLegalDescription": "PT BLK 97 PL 1637 CITY OF WATERLOO PTS 15 & 18, 58R6254; S/T 680512, 886238, 962185; WATERLOO"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2%"
+"TransactionType": "For Sale"
+"Zoning": "SR2"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 113.19
+"LotWidth": 69.22
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12233919')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "301604046001400"
+"SurveyType": "None"
+"KitchensTotal": 1
+"ParkingSpaces": 4
+"provider_name": "TRREB"
+"AssessmentYear": 2024
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"LivingAreaRange": "2500-3000"
+"RoomsAboveGrade": 10
+"RoomsBelowGrade": 2
+"PossessionDetails": "Flexible"
+"WashroomsType1Pcs": 2
+"WashroomsType2Pcs": 4
+"WashroomsType3Pcs": 5
+"BedroomsAboveGrade": 3
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "Lockbox is located on the gas meter on the side of the house"
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Second"
+"WashroomsType3Level": "Second"
+"MediaChangeTimestamp": "2025-06-19T20:50:36Z"
+"SystemModificationTimestamp": "2025-06-20T14:39:14.316949Z"
+"Media": array:50 [ …50]
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4308
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12226178"
+"ListingId": "X12226178"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-06-20T14:38:03Z"
+"RFModificationTimestamp": "2025-06-20T15:16:41.001495+00:00"
+"ListPrice": 1199000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V 1R5"
+"UnparsedAddress": "642 Red Pine Drive, Waterloo, ON N2V 1R5"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.5012586
+"Longitude": -80.5568728
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "SAM MCDADI REAL ESTATE INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "This Exquisite Four+1 -Bedroom one and a half Style Home Features A Versatile Extension Above The Garage, Currently Utilized As A Primary Bedroom, Or Effortlessly Converted Into A Spacious Family Room Or Separate Dwelling With Minor Modifications, Boasting Three Bathrooms And 1867 Square Feet Of Above-Grade, Over 3000 Square Feet Living Space, Providing Ample Room For Growing or Multigenerational Families Or Entertaining. With Recent Renovations And Addition Above The Garage Valued At Approximately $400,000. Having Upgraded The Kitchens, Bathrooms, And Flooring. Highlighting Operable Skylights With Remote Controlled Blinds, Upgraded Windows, Doors, And Hardwood Flooring, A Basement Bathroom With Radiant Heating, Hot Tub Hookup, And Pot Lights, As Well As Multiple Levels Of Outdoor Living Space, Including A Multi Level Deck And 2 Terraces, On A Meticulously Maintained And Updated Property With Notable Improvements Such As A New Steel Railing, Upgraded Bathrooms, Additional AC, Second Fireplace, Sump Pump, Roof, Gutters, And Driveway, Along With Outdoor Features Including A Shed, Gazebo, Patio Lighting And Stone Pathways Throughout Very Large Backyard, And Natural Gas Hookup For BBQ, And The Addition Above The Garage, A New Build Finished In 2022, Features A New Bathroom And Kitchenette, Spray-Foam Insulation, Hardwood Flooring, An Operable Skylight, Gas Fireplace, And AC, With Barn And French Doors. This Home Is Ideally Located In a Very Quiet family-friendly neighbourhood Nestled In Nature, Walking Distance To Northlake Woods PS, Grocery Shopping, LRT -Streetcar, Transit, Restaurants, Gyms & Laurel Creek Conservation Area And St. Jacobs Farmers Market."
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:2 [ …2]
+"CoListOfficeName": "SAM MCDADI REAL ESTATE INC."
+"CoListOfficePhone": "905-502-1500"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "2.0"
+"CreationDate": "2025-06-17T16:00:32.072221+00:00"
+"CrossStreet": "Benjamin Road & Weber Street N"
+"DirectionFaces": "North"
+"Directions": "SW Corner of Benjamin Road & Weber Street N"
+"ExpirationDate": "2025-10-16"
+"FireplaceFeatures": array:1 [ …1]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "Three fridges, two stoves, two dishwashers, washer, dryer, all electrical, light fixtures, blinds"
+"InteriorFeatures": array:4 [ …4]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-06-17"
+"MainOfficeKey": "193800"
+"MajorChangeTimestamp": "2025-06-17T15:12:01Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2025-06-17T15:12:01Z"
+"OriginalListPrice": 1199000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft2575772"
+"ParcelNumber": "222601119"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "4.0"
+"PhotosChangeTimestamp": "2025-06-17T15:12:02Z"
+"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": "Red Pine"
+"StreetNumber": "642"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "8411.63"
+"TaxLegalDescription": "LOT 44 PLAN 1587 EXCEPT PTS 1 & 2 58R14971;S/T EASEMENT AS IN 831604; WATERLOO"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2% + Hst*"
+"TransactionType": "For Sale"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/642_red_pine_dr_waterloo_on/"
+"Zoning": "SR1"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 149.57
+"LotShape": "Rectangular"
+"LotWidth": 62.74
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12226178')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "301604363302000"
+"SurveyType": "Unknown"
+"HoldoverDays": 180
+"KitchensTotal": 2
+"ParkingSpaces": 2
+"provider_name": "TRREB"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"DenFamilyroomYN": true
+"LivingAreaRange": "1500-2000"
+"RoomsAboveGrade": 10
+"RoomsBelowGrade": 4
+"PossessionDetails": "Flexible"
+"WashroomsType1Pcs": 4
+"WashroomsType2Pcs": 3
+"WashroomsType3Pcs": 3
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"KitchensAboveGrade": 1
+"KitchensBelowGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Ground"
+"WashroomsType2Level": "Second"
+"WashroomsType3Level": "Lower"
+"MediaChangeTimestamp": "2025-06-17T15:12:02Z"
+"SystemModificationTimestamp": "2025-06-20T14:38:05.900847Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:39 [ …39]
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4305
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12139700"
+"ListingId": "X12139700"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-06-20T14:29:24Z"
+"RFModificationTimestamp": "2025-06-20T14:42:45.544470+00:00"
+"ListPrice": 649900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J 2K7"
+"UnparsedAddress": "227 Bridgeport Road, Waterloo, On N2j 2k7"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.472216
+"Longitude": -80.5039636
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "Red And White Realty Inc"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "OPEN HOUSE SAT. JUNE 21, 1:00-3:00. Are you looking to invest in a family home that is centrally located? 227 Bridgeport Rd. E. is walkable to Up Town Waterloo, which is the destination for shops, restaurants, cafes, the LRT, the Waterloo Public Library, Waterloo Park, and so much more. This home is also close to schools, more parks, grocery stores, and a quick drive to the Expressway, Grand River Hospital, the Universities, and even St. Jacob's if you want to visit the market. With 1287 TOTAL Sq Ft this home has 3+1 bedrooms and 2.5 bathrooms - this is perfect for first time home buyers and investors. It is located on a large 62'x148' lot and has a 16'x30' detached garage w/ hydro...which is a dream to store your big toys or use as a workshop. The spacious backyard is fully fenced, so its perfect for your kiddos and pets to run around. This house has a lot of character, yet many updates have been done. Some highlights include: a modern kitchen with quartz counter tops, a newer roof, a main floor powder room, 200 amp electrical, and a fully finished basement with an additional bedroom and bathroom."
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:2 [ …2]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"Country": "CA"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "2.0"
+"CreationDate": "2025-05-10T18:40:42.254864+00:00"
+"CrossStreet": "Margaret"
+"DirectionFaces": "North"
+"Directions": "BETWEEN BLUEVALE AND MARGARET. Bridgeport is a ONE WAY St."
+"ExpirationDate": "2025-07-31"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "Dishwasher, Dryer, Hot Water Tank Owned, Microwave, Refrigerator, Stove, Washer, Water Softener"
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "One Point Association of REALTORS"
+"ListingContractDate": "2025-05-10"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "575000"
+"MajorChangeTimestamp": "2025-06-16T22:15:35Z"
+"MlsStatus": "Price Change"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2025-05-10T18:10:29Z"
+"OriginalListPrice": 699900.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft2370676"
+"ParcelNumber": "223490173"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "8.0"
+"PhotosChangeTimestamp": "2025-06-20T14:27:26Z"
+"PoolFeatures": array:1 [ …1]
+"PreviousListPrice": 699900.0
+"PriceChangeTimestamp": "2025-06-16T22:15:35Z"
+"Roof": array:1 [ …1]
+"Sewer": array:1 [ …1]
+"ShowingRequirements": array:2 [ …2]
+"SignOnPropertyYN": true
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "E"
+"StreetName": "Bridgeport"
+"StreetNumber": "227"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "3474.0"
+"TaxAssessedValue": 273000
+"TaxLegalDescription": "LT 17 SUBDIVISION OF LT 5 GERMAN COMPANY TRACT CITY OF WATERLOO; PT LT 18 SUBDIVISION OF LT 5 GERMAN COMPANY TRACT CITY OF WATERLOO AS IN 837992; WATERLOO"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2%"
+"TransactionType": "For Sale"
+"VirtualTourURLBranded": "https://www.youtube.com/watch?v=2u9q G9h4Ec M"
+"Zoning": "SR2"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 148.0
+"LotShape": "Rectangular"
+"LotWidth": 62.0
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12139700')"
+"GarageType": "Detached"
+"HeatSource": "Gas"
+"RollNumber": "301601045015600"
+"SurveyType": "None"
+"HoldoverDays": 90
+"LaundryLevel": "Lower Level"
+"KitchensTotal": 1
+"ParkingSpaces": 6
+"provider_name": "TRREB"
+"ApproximateAge": "51-99"
+"AssessmentYear": 2024
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "New"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"DenFamilyroomYN": true
+"LivingAreaRange": "700-1100"
+"RoomsAboveGrade": 11
+"LotSizeAreaUnits": "Acres"
+"PropertyFeatures": array:6 [ …6]
+"LotSizeRangeAcres": "< .50"
+"PossessionDetails": "45-60 days"
+"WashroomsType1Pcs": 4
+"WashroomsType2Pcs": 2
+"WashroomsType3Pcs": 3
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "Out of Town agents must have Sentri Connect Ap for LB."
+"WashroomsType1Level": "Second"
+"WashroomsType2Level": "Main"
+"WashroomsType3Level": "Basement"
+"MediaChangeTimestamp": "2025-06-20T14:27:26Z"
+"SystemModificationTimestamp": "2025-06-20T14:29:27.679721Z"
+"Media": array:37 [ …37]
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4304
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12103856"
+"ListingId": "X12103856"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Sale Of Business"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-06-20T11:32:41Z"
+"RFModificationTimestamp": "2025-06-20T11:35:56.919706+00:00"
+"ListPrice": 280000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 1477.02
+"City": "Waterloo"
+"PostalCode": "N2L 6J3"
+"UnparsedAddress": "#1b - 140 University Avenue, Waterloo, On N2l 6j3"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4730414
+"Longitude": -80.5353937
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX EPIC REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Seize the chance to own one of the worlds most coveted bubble tea franchises! Ideally situated between Wilfrid Laurier University and the University of Waterloo, this prime location enjoys an impressive daily foot traffic of over 40,000. The bustling area is teeming with diverse businesses that attract a constant flow of students and visitors. Dont miss out on this exceptional opportunity to invest in a highly sought-after brand with immense potential! Key advantages include a prime location with low rent, excellent support, low maintenance, and flexible working hours. Perfect for both new and experienced entrepreneurs, this is an incredible chance to benefit from a strong brand presence in a high-traffic area."
+"BuildingAreaUnits": "Square Feet"
+"BusinessType": array:1 [ …1]
+"CoListOfficeName": "RE/MAX EPIC REALTY"
+"CoListOfficePhone": "905-604-6646"
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CreationDate": "2025-04-25T14:37:28.034222+00:00"
+"CrossStreet": "University Ave W And Phillip"
+"Directions": "W"
+"ExpirationDate": "2025-07-22"
+"HoursDaysOfOperation": array:1 [ …1]
+"HoursDaysOfOperationDescription": "10"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-04-25"
+"MainOfficeKey": "352300"
+"MajorChangeTimestamp": "2025-04-25T14:20:57Z"
+"MlsStatus": "New"
+"NumberOfFullTimeEmployees": 20
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2025-04-25T14:20:57Z"
+"OriginalListPrice": 280000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft2287960"
+"ParcelNumber": "223650200"
+"PhotosChangeTimestamp": "2025-04-25T14:20:58Z"
+"SeatingCapacity": "10"
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "W"
+"StreetName": "University"
+"StreetNumber": "140"
+"StreetSuffix": "Avenue"
+"TaxYear": "2024"
+"TransactionBrokerCompensation": "4%+hst"
+"TransactionType": "For Sale"
+"UnitNumber": "1B"
+"Utilities": array:1 [ …1]
+"Zoning": "C4 COMMERCIAL"
+"DDFYN": true
+"Water": "Municipal"
+"LotType": "Unit"
+"TaxType": "N/A"
+"HeatType": "Gas Forced Air Closed"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12103856')"
+"ChattelsYN": true
+"GarageType": "Plaza"
+"RetailArea": 1477.02
+"FranchiseYN": true
+"PropertyUse": "Without Property"
+"RentalItems": "HVAC 326.57 per month"
+"HoldoverDays": 90
+"ListPriceUnit": "For Sale"
+"provider_name": "TRREB"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionDate": "2025-05-29"
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"RetailAreaCode": "Sq Ft"
+"MediaChangeTimestamp": "2025-04-25T14:20:58Z"
+"SystemModificationTimestamp": "2025-06-20T11:32:41.228539Z"
+"FinancialStatementAvailableYN": true
+"Media": array:8 [ …8]
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4303
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12234535"
+"ListingId": "X12234535"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-06-20T04:29:28Z"
+"RFModificationTimestamp": "2025-06-21T01:00:34.245060+00:00"
+"ListPrice": 2150.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J 2X9"
+"UnparsedAddress": "#710 - 128 King Street, Waterloo, ON N2J 2X9"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4652699
+"Longitude": -80.5222961
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX ULTIMATE REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome To One28 Condos On King Street. This Newest Uptown Waterloo Condo Comes With 9 Feet Ceiling. Amazing 1 Bed+Den Unit Used As 2 Bedroom On 7th Floor Comes With Very Open Concept. Spacious Living, Dining, Kitchen Area & Walk Out To Balcony, Stainless Steel Appliances, Quartz Countertops - In-Suite Laundry - Laminate Floors. Nice Size Bedroom With East View From Balcony, Easy Access To Ion Lrt Transit, Close Proximity To Waterloo And Laurier University, Downtown Waterloo, Shops & Nice Restaurants."
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CreationDate": "2025-06-20T04:41:40.169899+00:00"
+"CrossStreet": "King Street North & Elgin St."
+"Directions": "King Street North & Elgin St."
+"ExpirationDate": "2025-09-19"
+"Furnished": "Unfurnished"
+"Inclusions": "Stainless Steel Appliances - Fridge, Stove, Dishwasher, Microwave. Many Amenities In The Building - Party Room, Fitness Room , Yoga Room, Green Roof, Outdoor Terrace With Bbq Facility!"
+"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-20"
+"MainOfficeKey": "498700"
+"MajorChangeTimestamp": "2025-06-20T04:29:28Z"
+"MlsStatus": "New"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2025-06-20T04:29:28Z"
+"OriginalListPrice": 2150.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft2508784"
+"ParkingFeatures": array:1 [ …1]
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2025-06-20T04:29:28Z"
+"RentIncludes": array:1 [ …1]
+"ShowingRequirements": array:1 [ …1]
+"SignOnPropertyYN": true
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "N"
+"StreetName": "King"
+"StreetNumber": "128"
+"StreetSuffix": "Street"
+"TransactionBrokerCompensation": "1/2 Mon"
+"TransactionType": "For Lease"
+"UnitNumber": "710"
+"DDFYN": true
+"Locker": "Exclusive"
+"Exposure": "East"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12234535')"
+"GarageType": "None"
+"HeatSource": "Gas"
+"LockerUnit": "19"
+"SurveyType": "None"
+"BalconyType": "Terrace"
+"LockerLevel": "4"
+"HoldoverDays": 90
+"LegalStories": "7"
+"ParkingType1": "None"
+"CreditCheckYN": true
+"KitchensTotal": 1
+"PaymentMethod": "Cheque"
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2J 2X9, CA"
+"ContractStatus": "Available"
+"PossessionDate": "2025-08-01"
+"PossessionType": "30-59 days"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"CondoCorpNumber": 747
+"DepositRequired": true
+"LivingAreaRange": "600-699"
+"RoomsAboveGrade": 6
+"EnsuiteLaundryYN": true
+"LeaseAgreementYN": true
+"PaymentFrequency": "Monthly"
+"SquareFootSource": "Builder"
+"PossessionDetails": "TBA"
+"PrivateEntranceYN": true
+"WashroomsType1Pcs": 4
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"EmploymentLetterYN": true
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"RentalApplicationYN": true
+"WashroomsType1Level": "Main"
+"LegalApartmentNumber": "10"
+"MediaChangeTimestamp": "2025-06-20T04:29:28Z"
+"PortionPropertyLease": array:1 [ …1]
+"ReferencesRequiredYN": true
+"PropertyManagementCompany": "Cie Property Mngt & Consu"
+"SystemModificationTimestamp": "2025-06-20T04:29:28.8285Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:27 [ …27]
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4302
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12152785"
+"ListingId": "X12152785"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-06-20T02:10:32Z"
+"RFModificationTimestamp": "2025-06-20T04:48:03.331974+00:00"
+"ListPrice": 779900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 0J8"
+"UnparsedAddress": "#710 - 155 Caroline Street, Waterloo, ON N2L 0J8"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4652699
+"Longitude": -80.5222961
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "CRIMSON REALTY POINT INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Nicely Kept Two Bed Plus Den Condo Apartment In The Prestigious Caroline Street Private Residences In Uptown Waterloo With Owned Parking And Locker. 943 Square feet of luxury plus a balcony of 85 Square feet. Spacious Principal Bedroom With 4Pc En-Suite. A Second Bedroom And a Den Plus Another Full Bathroom. Spacious Kitchen And Living Area. Classy Amenities Including Exercise Room, Games Room, Guest Suites, Media Room, Party/Meeting Room, Concierge And Visitor Parking. Unit rented for $2800 p.m. to a very responsible and clean tenant. Buyer to assume Tenant until end of his current lease on July 31, 2025. Tenant would like to continue leasing. Great income opportunity."
+"ArchitecturalStyle": array:1 [ …1]
+"AssociationFee": "635.53"
+"AssociationFeeIncludes": array:3 [ …3]
+"Basement": array:1 [ …1]
+"BuildingName": "Caroline Street Private Residences"
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2025-05-16T04:48:08.467324+00:00"
+"CrossStreet": "King / John W"
+"Directions": "King Street to John St W- right to Caroline"
+"ExpirationDate": "2025-10-30"
+"Inclusions": "S/S Fridge, Stove, Built-In Dish Washer, Microwave Exhaust, Clothes Washer & Dryer, Ceramic Backsplash. Spacious Balcony, Owned Parking And Locker."
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-05-15"
+"MainOfficeKey": "232000"
+"MajorChangeTimestamp": "2025-05-16T02:51:34Z"
+"MlsStatus": "New"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2025-05-16T02:51:34Z"
+"OriginalListPrice": 779900.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft2401822"
+"ParcelNumber": "236770319"
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2025-05-16T02:51:35Z"
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "S"
+"StreetName": "Caroline"
+"StreetNumber": "155"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4631.92"
+"TaxYear": "2024"
+"TransactionBrokerCompensation": "2.25% + HST and Thanks"
+"TransactionType": "For Sale"
+"UnitNumber": "710"
+"View": array:1 [ …1]
+"DDFYN": true
+"Locker": "Owned"
+"Exposure": "South"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12152785')"
+"GarageType": "Underground"
+"HeatSource": "Gas"
+"RollNumber": "301603045002268"
+"SurveyType": "None"
+"BalconyType": "Open"
+"LockerLevel": "A"
+"RentalItems": "fan Coil - $ 81.81 p.m."
+"HoldoverDays": 60
+"LaundryLevel": "Main Level"
+"LegalStories": "7"
+"LockerNumber": "173"
+"ParkingSpot1": "44"
+"ParkingType1": "Owned"
+"KitchensTotal": 1
+"provider_name": "TRREB"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionDate": "2025-05-30"
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"CondoCorpNumber": 677
+"LivingAreaRange": "900-999"
+"RoomsAboveGrade": 7
+"SquareFootSource": "Builder"
+"ParkingLevelUnit1": "A"
+"PossessionDetails": "Take over Tenant"
+"WashroomsType1Pcs": 4
+"WashroomsType2Pcs": 4
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"StatusCertificateYN": true
+"WashroomsType1Level": "Flat"
+"WashroomsType2Level": "Flat"
+"LegalApartmentNumber": "10"
+"MediaChangeTimestamp": "2025-05-16T02:51:35Z"
+"PropertyManagementCompany": "Weigel Property Management - 519-893-4411"
+"SystemModificationTimestamp": "2025-06-20T02:10:34.718385Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:24 [ …24]
}
9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4301
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12060069"
+"ListingId": "X12060069"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Townhouse"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-06-20T01:10:44Z"
+"RFModificationTimestamp": "2025-06-20T05:15:21.930313+00:00"
+"ListPrice": 499000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T 2G7"
+"UnparsedAddress": "523 Beechwood Drive, Waterloo, On N2t 2g7"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.450926210743
+"Longitude": -80.561687865141
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX TWIN CITY REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to Beechwood Classics, an Executive Townhouse community located in Waterloo's prestigious Beechwood West neighbourhood. Unit 4 offers a single car garage, private driveway, visitor parking in close proximity and a private backyard facing greenery. Inside you will find 3 Bedrooms, 4 Bathrooms, and over 2300 sqft of finished living space. Recent upgrades include fresh paint (2025), a new heat pump with extended warranty (Nov 2024), renovated bathrooms (2021 & 2024), a stunning main level natural gas fireplace (2017), and a Safe Bathing Accessible Tub (Nov 2021). Special additional features include California shutters, central vac, basement walkout, and a luxuriously sized primary bedroom complete with a walk-in closet and 5-piece ensuite. The prime location of this home also cannot be beat with close proximity to walking trails, parks, top rated schools, the Zehrs complex, and all the amenities the West End has to offer including The Boardwalk, Shoppers Drug Mart Complex, and Costco. This home truly has it all. Don't miss the virtual tour!"
+"ArchitecturalStyle": array:1 [ …1]
+"AssociationFee": "742.0"
+"AssociationFeeIncludes": array:2 [ …2]
+"Basement": array:2 [ …2]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2025-04-04T06:52:00.158292+00:00"
+"CrossStreet": "Maple Forest"
+"Directions": "Erb Street West to Beechwood Drive."
+"Exclusions": "Basement Fridge, Basement Freezer."
+"ExpirationDate": "2025-07-04"
+"FireplaceYN": true
+"GarageYN": true
+"Inclusions": "Central Vac, Dishwasher, Dryer, Garage Door Opener, Range Hood, Refrigerator, Stove, Washer, Window Coverings, All Existing Light Fixtures, 2 Garage Door Remotes, Projector Screen & Speakers (Basement)."
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2025-04-03"
+"MainOfficeKey": "360900"
+"MajorChangeTimestamp": "2025-06-20T01:10:44Z"
+"MlsStatus": "Price Change"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2025-04-03T17:30:50Z"
+"OriginalListPrice": 585000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft2187022"
+"ParcelNumber": "231250004"
+"ParkingTotal": "2.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2025-05-31T17:01:23Z"
+"PreviousListPrice": 545000.0
+"PriceChangeTimestamp": "2025-06-20T01:10:44Z"
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Beechwood"
+"StreetNumber": "523"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "3359.41"
+"TaxYear": "2024"
+"TransactionBrokerCompensation": "2.0% + HST"
+"TransactionType": "For Sale"
+"UnitNumber": "4"
+"VirtualTourURLBranded": "https://youriguide.com/4_523_beechwood_dr_waterloo_on/"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "East"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12060069')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "301604051509204"
+"SurveyType": "None"
+"BalconyType": "None"
+"RentalItems": "Hot Water Heater, Water Softener"
+"HoldoverDays": 60
+"LegalStories": "Level 1"
+"ParkingType1": "Exclusive"
+"KitchensTotal": 1
+"ParkingSpaces": 1
+"UnderContract": array:2 [ …2]
+"provider_name": "TRREB"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "New"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"WashroomsType4": 1
+"CondoCorpNumber": 125
+"DenFamilyroomYN": true
+"LivingAreaRange": "1600-1799"
+"RoomsAboveGrade": 6
+"RoomsBelowGrade": 1
+"SquareFootSource": "i Guide"
+"PossessionDetails": "Flexible"
+"WashroomsType1Pcs": 3
+"WashroomsType2Pcs": 2
+"WashroomsType3Pcs": 4
+"WashroomsType4Pcs": 5
+"BedroomsAboveGrade": 3
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "Showing Time"
+"StatusCertificateYN": true
+"WashroomsType1Level": "Basement"
+"WashroomsType2Level": "Main"
+"WashroomsType3Level": "Second"
+"WashroomsType4Level": "Second"
+"LegalApartmentNumber": "Unit 4"
+"MediaChangeTimestamp": "2025-05-31T17:01:23Z"
+"PropertyManagementCompany": "LMS"
+"SystemModificationTimestamp": "2025-06-20T01:10:46.33196Z"
+"Media": array:33 [ …33]
}
]
+success: true
+page_size: 10
+page_count: 71
+count: 705
+after_key: ""
}
]
"RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=5&$filter=(StandardStatus eq 'Active')/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=5&$filter=(StandardStatus eq 'Active')&$expand=Media/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=5&$filter=(StandardStatus eq 'Active')/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=5&$filter=(StandardStatus eq 'Active')&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#4080
+items: array:5 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4082
+post_id: 294156
+post_author: 1
+"ListingKey": "E12225243"
+"ListingId": "E12225243"
+"PropertyType": "Residential"
+"PropertySubType": "Att/Row/Townhouse"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-06-21T05:24:36Z"
+"RFModificationTimestamp": "2025-06-21T05:28:08.315121+00:00"
+"ListPrice": 799899.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Ajax"
+"PostalCode": "L1S 0M5"
+"UnparsedAddress": "1169 Church Street, Ajax, ON L1S 0M5"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.8505287
+"Longitude": -79.0208814
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RIGHT AT HOME REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Executive 1950sqf plus 3-Bedroom, 3-Bath Townhouse in Northwest Ajax** Welcome to this stunning executive townhouse nestled in the highly sought-double car garage after community in Northwest Ajax. Offering the perfect blend of modern design and functional living, this spacious 3-bedroom, 3-bath home is sure to impress. Boasts a spacious open-concept layout that is perfect for entertaining or enjoying time with family. The expansive family, breakfast, living and dining areas, hardwood floor on main level, are flooded with natural light, creating a bright and inviting atmosphere. The chef-inspired kitchen is designed with both style and practicality in mind, featuring premium finishes and ample counter space for all your culinary creations, Freshly painted , pot lights, and much more, close to, 401 and 412, schools, shopping mall, worship place, goodlife and all you have in mind!!! potl fee is 165 per month"
+"ArchitecturalStyle": "2-Storey"
+"AttachedGarageYN": true
+"Basement": array:1 [ …1]
+"CityRegion": "Northwest Ajax"
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": "Central Air"
+"Country": "CA"
+"CountyOrParish": "Durham"
+"CoveredSpaces": "2.0"
+"CreationDate": "2025-06-17T05:12:41.679868+00:00"
+"CrossStreet": "Church St N & Rossland Rd W"
+"DirectionFaces": "East"
+"Directions": "east"
+"ExpirationDate": "2025-08-16"
+"FireplaceYN": true
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"HeatingYN": true
+"Inclusions": "S/S appliances, fridge, stove, dishwasher, hood range, washer and dryer A/C, furnace, lights and fixtures, window coverings"
+"InteriorFeatures": "Water Heater,Water Meter"
…94
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4098 …115}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4081 …115}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4099 …119}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4083 …116}
]
+success: true
+page_size: 5
+page_count: 24133
+count: 120662
+after_key: ""
}
"RF Response Time" => "0.57 seconds"
]
]
