array:3 [
"RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=110&$filter=(StandardStatus eq 'Active') and City eq 'Waterloo'/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=110&$filter=(StandardStatus eq 'Active') and City eq 'Waterloo'&$expand=Media/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=110&$filter=(StandardStatus eq 'Active') and City eq 'Waterloo'/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=110&$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 {#2862
+items: array:10 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2855
+post_id: "623238"
+post_author: 1
+"ListingKey": "X12737814"
+"ListingId": "X12737814"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Townhouse"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-19T15:51:53Z"
+"RFModificationTimestamp": "2026-04-30T05:00:26Z"
+"ListPrice": 539900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T 1H8"
+"UnparsedAddress": "493 Beechwood Drive 4, Waterloo, ON N2T 1H8"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4516807
+"Longitude": -80.5601366
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX REAL ESTATE CENTRE INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Open house, Sunday, April 26th, 12:15 to 2:15! Enjoy executive condo living with no grass to cut and no snow to shovel-in the summer where you just lock the door and go relax on your stunning private terrace overlooking the in-ground pool and tennis courts, all within one of the area's most desirable condo communities in Waterloo and just 2 minutes from Ira Needles shopping. Welcome to this well-maintained 2-bedroom, 2-bathroom town home in the sought-after Beechwood Villas. Offering 1,283 sq. ft. of comfortable living space, the bright main floor features a cozy wood-burning fireplace, spacious living and dining areas, and sliding doors leading to a large balcony with serene courtyard views. The sunny eat-in kitchen is perfect for everyday living and entertaining. Upstairs, you'll find two generous bedrooms, including a primary suite with a walk-in closet and cheater ensuite 4-piece bath. The finished lower level offers a versatile rec room, laundry, excellent storage, and direct access to the single-car garage. Set in a quiet, well-managed complex, residents enjoy private tennis courts, an outdoor pool, visitor parking, and a pet-friendly, BBQ-friendly environment. Close to walking trails, parks, top-rated schools, The Boardwalk, Costco, Sobeys, Uptown Waterloo, both universities, and major highways. Original owner - first time on the market. A rare opportunity in a premium location."
+"ArchitecturalStyle": "2-Storey"
+"AssociationFee": "664.23"
+"AssociationFeeIncludes": array:3 [ …3]
+"Basement": array:2 [ …2]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": "None"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-19T15:55:05.416020+00:00"
+"CrossStreet": "erb/beechwood"
+"Directions": "erb street to beechwood"
+"Exclusions": "staging, gifts"
+"ExpirationDate": "2026-06-30"
+"FireplaceYN": true
+"GarageYN": true
+"Inclusions": "appliances all in as is condition"
+"InteriorFeatures": "None"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-01-28"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "079800"
+"MajorChangeTimestamp": "2026-04-19T15:51:53Z"
+"MlsStatus": "Price Change"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2026-01-29T04:57:47Z"
+"OriginalListPrice": 549900.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3492628"
+"ParcelNumber": "234030040"
+"ParkingTotal": "2.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-04-14T18:36:54Z"
+"PreviousListPrice": 549900.0
+"PriceChangeTimestamp": "2026-04-19T15:51:53Z"
+"ShowingRequirements": array:1 [ …1]
+"SignOnPropertyYN": true
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Beechwood"
+"StreetNumber": "493"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "3466.0"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2.0"
+"TransactionType": "For Sale"
+"UnitNumber": "4"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "West"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12737814')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "301604051507900"
+"SurveyType": "None"
+"BalconyType": "Terrace"
+"RentalItems": "water heater and water softner"
+"HoldoverDays": 120
+"LegalStories": "1"
+"ParkingType1": "Exclusive"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 1
+"UnderContract": array:2 [ …2]
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2T 1H8, CA"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "New"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"CondoCorpNumber": 403
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "1200-1399"
+"RoomsAboveGrade": 8
+"EnsuiteLaundryYN": true
+"SquareFootSource": "sqft"
+"PossessionDetails": "flexible"
+"WashroomsType1Pcs": 4
+"WashroomsType2Pcs": 2
+"BedroomsAboveGrade": 2
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Second"
+"WashroomsType2Level": "Main"
+"LegalApartmentNumber": "40"
+"MediaChangeTimestamp": "2026-04-14T18:36:54Z"
+"PropertyManagementCompany": "CMC management"
+"SystemModificationTimestamp": "2026-04-19T15:51:59.853316Z"
+"Media": array:47 [ …47]
+"ID": "623238"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2857
+post_id: "697171"
+post_author: 1
+"ListingKey": "X12986688"
+"ListingId": "X12986688"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Townhouse"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-18T20:46:38Z"
+"RFModificationTimestamp": "2026-04-30T05:01:36Z"
+"ListPrice": 445000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J 4J1"
+"UnparsedAddress": "121 University Avenue E 22, Waterloo, ON N2J 4J1"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.477687
+"Longitude": -80.516925
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX Solid Gold Realty (II) Ltd"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to Village on the Green, a well-established Waterloo community known for its mature trees, peaceful park-like setting, and rare blend of space, privacy, and convenience. Offering over 2,100 sq ft of total living space, this 4-bedroom, 2.5-bathroom end-unit townhome provides excellent flexibility for families, investors, or parents seeking housing near the universities. The functional multi-level layout features separate living and dining areas with great flow for everyday living and entertaining. The main living space is bright and welcoming with walkout access to the outdoor area, while the main floor bedroom works perfectly as a home office, guest room, or additional living space. Upstairs are three spacious bedrooms, including a large primary suite with walk-in closet and private ensuite, plus a separate family bathroom. The partially finished lower level offers additional recreation space, laundry, and plenty of storage, making the home highly practical for growing families or shared living arrangements. With $25,000 in recent updates, the home is clean, well-maintained, and move-in ready. Vacant possession with quick closing available. The layout supports strong rental potential with estimated income of approximately $3,600/month in a consistently high-demand location. Conveniently located: 2 minutes to the expressway 5 minutes or less to University of Waterloo, Wilfrid Laurier University, and Uptown Waterloo Directly across from Conestoga College Waterloo campus, close to transit, shopping, restaurants, parks, and walking trails1 owned underground parking space included, with additional parking available to rent ($50/month underground, $35/month surface). Condo fees include exterior maintenance, windows, and doors, offering a low-maintenance ownership experience in a highly desirable Waterloo neighbourhood."
+"ArchitecturalStyle": "2-Storey"
+"AssociationFee": "770.0"
+"AssociationFeeIncludes": array:3 [ …3]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-28T23:10:39.612573+00:00"
+"CrossStreet": "Marsland Avenue & University Avenue East"
+"Directions": "From highway, take the University ave W exit. after 1.5 kms, Village on the Green at 121 University is on the left just before Weber. unit 22 is 250 Metres up on the left."
+"ExpirationDate": "2026-07-22"
+"ExteriorFeatures": "Patio"
+"FoundationDetails": array:1 [ …1]
+"Inclusions": "Fridge, Stove, Dishwasher, Microwave, Hood vent, Washer, Dryer, Water Softener, Window coverings"
+"InteriorFeatures": "Sump Pump,Water Heater,Water Softener,Workbench"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:2 [ …2]
+"ListAOR": "One Point Association of REALTORS"
+"ListingContractDate": "2026-04-08"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "549200"
+"MajorChangeTimestamp": "2026-04-18T20:46:38Z"
+"MlsStatus": "Price Change"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2026-04-11T14:26:09Z"
+"OriginalListPrice": 399000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3669590"
+"ParcelNumber": "230230022"
+"ParkingFeatures": "Underground"
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-04-11T14:26:09Z"
+"PreviousListPrice": 399000.0
+"PriceChangeTimestamp": "2026-04-18T20:46:38Z"
+"Roof": "Asphalt Shingle"
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "E"
+"StreetName": "University"
+"StreetNumber": "121"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "3398.0"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2%"
+"TransactionType": "For Sale"
+"UnitNumber": "22"
+"VirtualTourURLBranded": "https://youriguide.com/22_121_university_avenue_east_waterloo_on/"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/22_121_university_avenue_east_waterloo_on/"
+"Zoning": "RMU-20"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "West"
+"HeatType": "Forced Air"
+"LotShape": "Rectangular"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12986688')"
+"GarageType": "Underground"
+"HeatSource": "Gas"
+"RollNumber": "301601380004221"
+"SurveyType": "None"
+"BalconyType": "None"
+"RentalItems": "Water Heater"
+"HoldoverDays": 90
+"LegalStories": "Ground"
+"ParkingSpot1": "22"
+"ParkingType1": "Exclusive"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"UnderContract": array:1 [ …1]
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2J 4J1, CA"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "New"
+"WashroomsType1": 1
+"WashroomsType2": 2
+"CondoCorpNumber": 23
+"DenFamilyroomYN": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "1400-1599"
+"RoomsAboveGrade": 9
+"RoomsBelowGrade": 3
+"SquareFootSource": "iguide"
+"PossessionDetails": "Unit is vacant"
+"WashroomsType1Pcs": 2
+"WashroomsType2Pcs": 4
+"BedroomsAboveGrade": 4
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Upper"
+"LegalApartmentNumber": "22"
+"MediaChangeTimestamp": "2026-04-11T14:26:09Z"
+"PropertyManagementCompany": "Onyx"
+"SystemModificationTimestamp": "2026-04-18T20:46:47.565185Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:28 [ …28]
+"ID": "697171"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2854
+post_id: "679267"
+post_author: 1
+"ListingKey": "X12967368"
+"ListingId": "X12967368"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-18T20:12:43Z"
+"RFModificationTimestamp": "2026-04-29T12:32:45Z"
+"ListPrice": 1200000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 3T9"
+"UnparsedAddress": "291 Albert Street, Waterloo, ON N2L 3T9"
+"Coordinates": array:2 [ …2]
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "ROYAL LEPAGE WOLLE REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Redevelopment Opportunity, Prime Location on High Traffic Albert Street. Can be purchased with 289 Albert Street. Adjacent properties at 285 and 293 Albert Street are also for sale for a larger parcel. Currently leased to provide income while you plan your redevelopment project. Zoning RN-6"
+"ArchitecturalStyle": "Bungalow"
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-28T23:11:31.156721+00:00"
+"CrossStreet": "Hickory"
+"DirectionFaces": "West"
+"Directions": "University to Albert"
+"Exclusions": "Tenant's Belongings."
+"ExpirationDate": "2026-10-07"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"InteriorFeatures": "Accessory Apartment"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-07"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "356100"
+"MajorChangeTimestamp": "2026-04-07T19:47:33Z"
+"MlsStatus": "New"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2026-04-07T19:47:33Z"
+"OriginalListPrice": 1200000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3705534"
+"ParcelNumber": "223640024"
+"ParkingTotal": "3.0"
+"PhotosChangeTimestamp": "2026-04-18T19:57:07Z"
+"PoolFeatures": "None"
+"Roof": "Asphalt Shingle"
+"Sewer": "Sewer"
+"ShowingRequirements": array:2 [ …2]
+"SignOnPropertyYN": true
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Albert"
+"StreetNumber": "291"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "6124.0"
+"TaxLegalDescription": "PT LT 6 SUBDIVISION OF LT 13 GERMAN COMPANY TRACT CITY OF WATERLOO AS IN 1322621; WATERLOO"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2% Plus HST"
+"TransactionType": "For Sale"
+"Zoning": "RN-6"
+"UFFI": "Removed"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 131.0
+"LotShape": "Irregular"
+"LotWidth": 54.0
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12967368')"
+"GarageType": "Detached"
+"HeatSource": "Gas"
+"RollNumber": "301604005015600"
+"SurveyType": "None"
+"HoldoverDays": 60
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 2
+"ParkingSpaces": 2
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2L 3T9, CA"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 2
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "1100-1500"
+"RoomsAboveGrade": 13
+"LotSizeAreaUnits": "Acres"
+"PossessionDetails": "Flexible"
+"WashroomsType1Pcs": 4
+"BedroomsAboveGrade": 5
+"KitchensAboveGrade": 2
+"SpecialDesignation": array:1 [ …1]
+"MediaChangeTimestamp": "2026-04-18T19:57:07Z"
+"SystemModificationTimestamp": "2026-04-18T20:12:43.080586Z"
+"Media": array:10 [ …10]
+"ID": "679267"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2858
+post_id: "683882"
+post_author: 1
+"ListingKey": "X13014718"
+"ListingId": "X13014718"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-18T15:59:15Z"
+"RFModificationTimestamp": "2026-04-29T12:33:37Z"
+"ListPrice": 1795000.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 10043.0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 5W3"
+"UnparsedAddress": "239 Corrie Crescent, Waterloo, ON N2L 5W3"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4832944
+"Longitude": -80.5498184
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX Solid Gold Realty (II) Ltd"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to a truly exceptional home on a quiet street in one of the area's most sought-after neighbourhoods. Extensively renovated, this residence offers a refined mix of modern design, quality finishes, and functional living space. From the striking exterior and landscaped approach to the dramatic curved staircase inside, every detail has been carefully considered. The main level is designed for both daily living and entertaining, featuring oversized windows, designer lighting, a formal living room, and a separate dining room. The chef's kitchen is a standout, with custom cabinetry, Jenn Air appliances, a pot filler, waterfall island with seating, and integrated storage. The family room includes a floor-to-ceiling fireplace, while a dedicated home office, laundry room, and powder room complete the level. Upstairs, you'll find four spacious bedrooms with hardwood flooring, floor-to-ceiling windows, and large closets. The primary suite offers a custom walk-in closet and a spa-inspired ensuite with heated floors, glass shower, and freestanding soaker tub. A second ensuite and cheater bath add comfort and convenience for family and guests. The finished lower level adds excellent flexibility with a large rec room, bar, fifth bedroom, full bathroom, and separate entrance, making it ideal for guests, teens, or extended family. Outside, mature trees and well-planned outdoor living areas create a peaceful space to relax or entertain. This is a rare opportunity to own a turnkey luxury home in an established neighbourhood."
+"ArchitecturalStyle": "2-Storey"
+"Basement": array:2 [ …2]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": "Central Air"
+"Country": "CA"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "2.0"
+"CreationDate": "2026-04-28T23:46:59.057812+00:00"
+"CrossStreet": "Bearinger Rd."
+"DirectionFaces": "West"
+"Directions": "Bearinger Rd. to Corrie Cres."
+"Exclusions": "Staging materials"
+"ExpirationDate": "2026-07-31"
+"ExteriorFeatures": "Deck,Landscaped,Lighting,Porch"
+"FireplaceFeatures": array:2 [ …2]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "Dishwasher, Dryer, Microwave, Refrigerator, Stove, Washer"
+"InteriorFeatures": "Storage,Sump Pump,Water Softener,Auto Garage Door Remote,Bar Fridge,Built-In Oven,Carpet Free,Countertop Range,In-Law Capability"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "One Point Association of REALTORS"
+"ListingContractDate": "2026-04-17"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "549200"
+"MajorChangeTimestamp": "2026-04-17T21:28:22Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2026-04-17T21:28:22Z"
+"OriginalListPrice": 1795000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3700200"
+"ParcelNumber": "222560015"
+"ParkingFeatures": "Private Double"
+"ParkingTotal": "8.0"
+"PhotosChangeTimestamp": "2026-04-17T21:28:22Z"
+"PoolFeatures": "None"
+"Roof": "Asphalt Shingle"
+"SecurityFeatures": array:4 [ …4]
+"Sewer": "Sewer"
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Corrie"
+"StreetNumber": "239"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "13381.0"
+"TaxLegalDescription": "LT 6 PL 1418 CITY OF WATERLOO; WATERLOO"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2.0% + hst"
+"TransactionType": "For Sale"
+"VirtualTourURLBranded": "https://youriguide.com/ex1ps_239_corrie_crescent_waterloo_on/"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/ex1ps_239_corrie_crescent_waterloo_on/"
+"Zoning": "R3"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 154.43
+"LotShape": "Rectangular"
+"LotWidth": 65.09
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13014718')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "301604136009200"
+"SurveyType": "None"
+"RentalItems": "Hot Water Heater"
+"HoldoverDays": 30
+"LaundryLevel": "Main Level"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 6
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2L 5W3, CA"
+"ApproximateAge": "31-50"
+"AssessmentYear": 2026
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"WashroomsType4": 1
+"WashroomsType5": 1
+"DenFamilyroomYN": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "3000-3500"
+"RoomsAboveGrade": 15
+"RoomsBelowGrade": 6
+"LotSizeAreaUnits": "Square Feet"
+"PropertyFeatures": array:6 [ …6]
+"PossessionDetails": "Immediate"
+"WashroomsType1Pcs": 3
+"WashroomsType2Pcs": 4
+"WashroomsType3Pcs": 5
+"WashroomsType4Pcs": 3
+"WashroomsType5Pcs": 2
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Second"
+"WashroomsType2Level": "Second"
+"WashroomsType3Level": "Second"
+"WashroomsType4Level": "Basement"
+"WashroomsType5Level": "Main"
+"MediaChangeTimestamp": "2026-04-17T21:28:22Z"
+"SystemModificationTimestamp": "2026-04-18T15:59:30.110786Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:50 [ …50]
+"ID": "683882"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2856
+post_id: "681974"
+post_author: 1
+"ListingKey": "X13010736"
+"ListingId": "X13010736"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-18T14:09:39Z"
+"RFModificationTimestamp": "2026-04-30T10:22:55Z"
+"ListPrice": 1149.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 3W9"
+"UnparsedAddress": "330 Phillip Street N207, Waterloo, ON N2L 3W9"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4762025
+"Longitude": -80.5389214
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "CENTURY 21 GREEN REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "GIRLS Only - Luxury Student Condo: 1-Bedroom Available in a 2-Bedroom Unit, shared common areas *Fully Furnished, Carpet-Free | The building offers excellent amenities, including a professional study lounge, study rooms, 24-hour security, rooftop patio, basketball court, gym, sauna, and games room | Conveniently located within walking distance to the University of Waterloo and Wilfrid Laurier University | Suitable for a girl student seeking a clean, respectful, and study-focused living environment OR a single lady working professional | The other bedroom is occupied by a co-op girl student ***"
+"ArchitecturalStyle": "Apartment"
+"AssociationFee": "302.2"
+"Basement": array:1 [ …1]
+"CoListOfficeName": "CENTURY 21 GREEN REALTY INC."
+"CoListOfficePhone": "905-565-9565"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-28T23:54:17.235807+00:00"
+"CrossStreet": "Columbia Street & Philip Street"
+"Directions": "From Columbia St, head south on Phillip St. 330 Phillip St will be on the west side."
+"ExpirationDate": "2026-06-30"
+"Furnished": "Furnished"
+"Inclusions": "Luxury, fully Furnished Accommodation for GIRLS ONLY | Seeking responsible, highly qualified tenants | No pets _ Non-smokers."
+"InteriorFeatures": "Carpet Free"
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"LeaseTerm": "12 Months"
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-17"
+"MainOfficeKey": "137100"
+"MajorChangeTimestamp": "2026-04-17T11:36:50Z"
+"MlsStatus": "New"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2026-04-17T11:36:50Z"
+"OriginalListPrice": 1149.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3780210"
+"ParcelNumber": "236270051"
+"ParkingFeatures": "Mutual"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-04-17T11:36:51Z"
+"RentIncludes": array:1 [ …1]
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Phillip"
+"StreetNumber": "330"
+"StreetSuffix": "Street"
+"TransactionBrokerCompensation": "1/2 Month REnt"
+"TransactionType": "For Lease"
+"UnitNumber": "N207"
+"View": array:1 [ …1]
+"VirtualTourURLBranded": "https://video-api.supreme.one/V6qpyf?branded=true"
+"VirtualTourURLUnbranded": "https://video-api.supreme.one/V6qpyf?branded=false"
+"UFFI": "No"
+"DDFYN": true
+"Locker": "Exclusive"
+"Exposure": "East"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13010736')"
+"ElevatorYN": true
+"GarageType": "None"
+"HeatSource": "Gas"
+"RollNumber": "301604350000925"
+"SurveyType": "Unknown"
+"Waterfront": array:1 [ …1]
+"BalconyType": "None"
+"LockerLevel": "A"
+"HoldoverDays": 90
+"LaundryLevel": "Main Level"
+"LegalStories": "2"
+"LockerNumber": "503"
+"ParkingType1": "None"
+"CreditCheckYN": true
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"PaymentMethod": "Cheque"
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2L 3W9, CA"
+"ApproximateAge": "6-10"
+"ContractStatus": "Available"
+"PossessionDate": "2026-06-01"
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"CondoCorpNumber": 627
+"DepositRequired": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "500-599"
+"RoomsAboveGrade": 4
+"LeaseAgreementYN": true
+"PaymentFrequency": "Monthly"
+"PropertyFeatures": array:2 [ …2]
+"SquareFootSource": "MPAC"
+"PossessionDetails": "Flexible"
+"PrivateEntranceYN": true
+"WashroomsType1Pcs": 3
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"EmploymentLetterYN": true
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"RentalApplicationYN": true
+"ShowingAppointments": "Broker Bay - Through L/A"
+"WashroomsType1Level": "Flat"
+"LegalApartmentNumber": "18"
+"MediaChangeTimestamp": "2026-04-18T14:09:39Z"
+"PortionLeaseComments": "Private Rm. in 2-bedroom aprt."
+"PortionPropertyLease": array:1 [ …1]
+"ReferencesRequiredYN": true
+"PropertyManagementCompany": "Craft Property Management"
+"SystemModificationTimestamp": "2026-04-18T14:09:42.193654Z"
+"GreenPropertyInformationStatement": true
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:19 [ …19]
+"ID": "681974"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2853
+post_id: "684310"
+post_author: 1
+"ListingKey": "X13014686"
+"ListingId": "X13014686"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Condo Townhouse"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-17T21:16:46Z"
+"RFModificationTimestamp": "2026-04-29T01:43:39Z"
+"ListPrice": 3199.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J 0G1"
+"UnparsedAddress": "99 Roger Street 50, Waterloo, ON N2J 0G1"
+"Coordinates": array:2 [ …2]
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "REAL BROKER ONTARIO LTD."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Experience Luxury And Spacious Living In This Impressive 1,810 Sq Ft Executive Townhouse With 3 Bedrooms And 2.5 Baths. Flooded With Natural Light From Large Picture Windows, This Home Boasts High 9 Ft Ceilings, Sophisticated Modern Finishes, Quartz Countertops, In-Suite Laundry, And Two Balconies. The Master Suite Offers A Serene Retreat With A Beautiful Ensuite Bathroom, A Walk-In Closet, And Its Own Balcony. Situated In A Prime Location, You're Just A Short Walk To The LRT And Minutes Away From Google, The Vibrant Tech Hub, Universities, Shopping, Uptown Waterloo, Downtown Kitchener, The Spur Line Trail, And The Hospital. Impeccably Maintained, Spacious, And Move-In Ready, With An Additional Balcony Off The Living Room. An Outstanding Property That Combines Convenience And Style."
+"ArchitecturalStyle": "3-Storey"
+"Basement": array:1 [ …1]
+"CoListOfficeName": "REAL BROKER ONTARIO LTD."
+"CoListOfficePhone": "888-311-1172"
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-29T00:44:29.615910+00:00"
+"CrossStreet": "Roger Street/Moore Ave S"
+"Directions": "Roger Street/Moore Ave S"
+"ExpirationDate": "2026-06-30"
+"Furnished": "Unfurnished"
+"GarageYN": true
+"InteriorFeatures": "Other"
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"LeaseTerm": "12 Months"
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-17"
+"MainOfficeKey": "384000"
+"MajorChangeTimestamp": "2026-04-17T21:16:46Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2026-04-17T21:16:46Z"
+"OriginalListPrice": 3199.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3834432"
+"ParcelNumber": "237730222"
+"ParkingFeatures": "Private,Surface"
+"ParkingTotal": "2.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-04-17T21:16:46Z"
+"RentIncludes": array:1 [ …1]
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Roger"
+"StreetNumber": "99"
+"StreetSuffix": "Street"
+"TransactionBrokerCompensation": "1/2 Month + HST"
+"TransactionType": "For Lease"
+"UnitNumber": "50"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "North East"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13014686')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"SurveyType": "None"
+"BalconyType": "Open"
+"HoldoverDays": 90
+"LegalStories": "1"
+"ParkingType1": "Owned"
+"CreditCheckYN": true
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 1
+"PaymentMethod": "Cheque"
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2J 0G1, CA"
+"ApproximateAge": "0-5"
+"ContractStatus": "Available"
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 2
+"CondoCorpNumber": 773
+"DepositRequired": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "1600-1799"
+"RoomsAboveGrade": 9
+"LeaseAgreementYN": true
+"PaymentFrequency": "Monthly"
+"SquareFootSource": "Builder"
+"PossessionDetails": "Immediate"
+"PrivateEntranceYN": true
+"WashroomsType1Pcs": 2
+"WashroomsType2Pcs": 3
+"BedroomsAboveGrade": 3
+"EmploymentLetterYN": true
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"RentalApplicationYN": true
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Second"
+"LegalApartmentNumber": "110"
+"MediaChangeTimestamp": "2026-04-17T21:16:46Z"
+"PortionPropertyLease": array:1 [ …1]
+"ReferencesRequiredYN": true
+"PropertyManagementCompany": "WSCP"
+"SystemModificationTimestamp": "2026-04-17T21:16:46.97348Z"
+"Media": array:27 [ …27]
+"ID": "684310"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2847
+post_id: "699881"
+post_author: 1
+"ListingKey": "X13013878"
+"ListingId": "X13013878"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-17T19:00:56Z"
+"RFModificationTimestamp": "2026-04-29T01:43:37Z"
+"ListPrice": 372000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2G 0C8"
+"UnparsedAddress": "104 Garment Street 16, Waterloo, ON N2G 0C8"
+"Coordinates": array:2 [ …2]
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "ROYAL LEPAGE WOLLE REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Perched high above the vibrant Kitchener skyline, this ONE-BED + DEN condo at 104 Garment St, Unit 1206 offers an exceptional opportunity in Downtown Kitchener's most sought-after addresses. BRIGHT OPEN-CONCEPT LAYOUT enhanced by PREMIUM FLOORING AND FRESHLY PAINTED neutral tones. The contemporary kitchen offers GENEROUS GRANITE COUNTERTOPS, STAINLESS STEEL APPLIANCES, A TASTEFUL TILE BACKSPLASH, & a breakfast bar that overlooks the main living area. The spacious living room is flooded with natural light from IMPRESSIVE FLOOR-TO-CEILING WINDOWS and offers direct access to a private balcony overlooking the terrace below. The PRIMARY BEDROOM IS BOTH COMFORTABLE AND FUNCTIONAL, featuring a large walk-in closet and a GENEROUS WINDOW FRAMING ELEVATED CITY VIEWS. A versatile den provides the perfect space for a home office, reading nook, or guest area, also offering a full 4-piece bathroom, convenient in-suite laundry, and additional storage. Residents of this highly desirable building enjoy an impressive array of PREMIUM AMENITIES INCLUDING A ROOFTOP TERRACE with stunning city views, a fully equipped fitness centre, private theatre room, party room, and a stylish media lounge-perfectly suited for today's dynamic professional lifestyle. The unit also comes complete with one underground parking space for added convenience. Ideally situated in the heart of Downtown Kitchener's Innovation District, this prime location places you just steps from the ION LRT, Grand River Hospital, Victoria Park, and an incredible selection of restaurants, cafés, and boutique shops. With major employers such as Google and the thriving tech hub nearby, THIS LOCATION IS PERFECTLY POSITIONED FOR PROFESSIONALS SEEKING BOTH CONNECTIVITY AND LIFESTYLE. Offering the perfect blend of modern design, functional living space, and unbeatable downtown convenience, this impressive condominium is a remarkable opportunity to enjoy the very best of city living."
+"ArchitecturalStyle": "Apartment"
+"AssociationAmenities": array:4 [ …4]
+"AssociationFee": "624.53"
+"AssociationFeeIncludes": array:3 [ …3]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-29T01:28:43.066273+00:00"
+"CrossStreet": "King Street"
+"Directions": "King Street & Victoria St"
+"ExpirationDate": "2026-07-31"
+"Inclusions": "Built-in Microwave, Dishwasher, Dryer, Refrigerator, Stove, Washer"
+"InteriorFeatures": "Carpet Free,Storage,Ventilation System"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-17"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "356100"
+"MajorChangeTimestamp": "2026-04-17T18:59:25Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2026-04-17T18:59:25Z"
+"OriginalListPrice": 372000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3832890"
+"ParcelNumber": "236700275"
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-04-17T18:59:25Z"
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Garment"
+"StreetNumber": "104"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3581.58"
+"TaxAssessedValue": 264000
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2%+HST reduced if shown by LA"
+"TransactionType": "For Sale"
+"UnitNumber": "16"
+"View": array:2 [ …2]
+"VirtualTourURLBranded": "https://sites.ground2airmedia.com/sites/104-garment-st-kitchener-on-n2g-0c8-22525279/branded"
+"VirtualTourURLBranded2": "https://youtube.com/shorts/JV9rc Ha90EI"
+"VirtualTourURLUnbranded": "https://sites.ground2airmedia.com/sites/rwnxozkx/unbranded"
+"VirtualTourURLUnbranded2": "https://youriguide.com/1206_104_garment_st_kitchener_on"
+"Zoning": "M2"
+"DDFYN": true
+"Locker": "Ensuite"
+"Exposure": "South"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13013878')"
+"GarageType": "Underground"
+"HeatSource": "Gas"
+"RollNumber": "301205000814386"
+"SurveyType": "None"
+"BalconyType": "Open"
+"HoldoverDays": 120
+"LegalStories": "12"
+"ParkingType1": "Exclusive"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2G 0C8, CA"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"CondoCorpNumber": 670
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "700-799"
+"RoomsAboveGrade": 4
+"EnsuiteLaundryYN": true
+"PropertyFeatures": array:1 [ …1]
+"SalesBrochureUrl": "https://bit.ly/104Garment Unit1206Brochure"
+"SquareFootSource": "Plans"
+"PossessionDetails": "Immediate"
+"WashroomsType1Pcs": 4
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Main"
+"LegalApartmentNumber": "1206"
+"MediaChangeTimestamp": "2026-04-17T18:59:25Z"
+"PropertyManagementCompany": "Wilson Blanchard"
+"SystemModificationTimestamp": "2026-04-17T19:00:59.584643Z"
+"Media": array:34 [ …34]
+"ID": "699881"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2859
+post_id: "659519"
+post_author: 1
+"ListingKey": "X12946870"
+"ListingId": "X12946870"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-17T18:39:40Z"
+"RFModificationTimestamp": "2026-04-29T01:43:04Z"
+"ListPrice": 800000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 4K1"
+"UnparsedAddress": "627 Glen Forrest Boulevard, Waterloo, ON N2L 4K1"
+"Coordinates": array:2 [ …2]
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "KELLER WILLIAMS INNOVATION REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "627 Glen Forrest - Fully Renovated Raised Bungalow with Exceptional Versatility! Located in one of the area's most popular neighborhoods, this beautifully updated home is perfect for families, multi-family living, or investors alike. Enjoy the convenience of nearby schools, shopping, scenic trails, and more - just a 5-minute drive to the U of W and Wilfrid Laurier University, and only 2 minutes to the Expressway for effortless commuting. From the moment you arrive, the extensive exterior upgrades are evident. The home features a newly poured concrete driveway extending to the backyard, a 500 sq ft concrete back pad, and a stunning two-tier deck (approx. $20,000) ideal for entertaining. The aggregate stone porch with covered roof creates a welcoming entrance. Additional updates: newer windows (3 years old), new exterior paint, new front and patio doors, new garage door, new railings (inside and out - approx. $15,000), and pot lights enhancing both curb appeal and functionality.Bright, one-level living on the main floor. The fully renovated open-concept layout seamlessly connects the kitchen, living, and dining areas. The modern kitchen features a large island with quartz countertops, stone backsplash, and brand-new appliances (fridge, stove, dishwasher). New flooring, trim, doors, pot lights, and fresh paint throughout complete the contemporary feel. The main level includes three spacious bedrooms and a beautifully renovated full bathroom. The lower level benefits from large above-grade windows, allowing for abundant natural light. This level offers a generous rec room/living area, 2 additional bedrooms and a full bathroom- making it ideal for extended family, multi-generational living, or strong rental potential. Major mechanical upgrades include all new electrical wiring and panel, and a new furnace (only 2 months old). $150,000 in Total Updates! Must See!"
+"ArchitecturalStyle": "Bungalow-Raised"
+"Basement": array:4 [ …4]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-29T01:37:51.614412+00:00"
+"CrossStreet": "northfield/weber"
+"DirectionFaces": "West"
+"Directions": "NORTHFIELD TO WEBER SOUTH THEN WEST ONTO GLENFORREST IT IS ON THE RIGHT AFTER GLENDENE CRESCENT"
+"ExpirationDate": "2026-07-31"
+"ExteriorFeatures": "Deck"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "Dishwasher, Dryer, Refrigerator, Stove, Washer"
+"InteriorFeatures": "In-Law Suite,In-Law Capability,Primary Bedroom - Main Floor"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-01"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "350800"
+"MajorChangeTimestamp": "2026-04-01T18:54:58Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2026-04-01T18:54:58Z"
+"OriginalListPrice": 800000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3754348"
+"ParcelNumber": "222640119"
+"ParkingFeatures": "Private Double"
+"ParkingTotal": "3.0"
+"PhotosChangeTimestamp": "2026-04-01T18:54:58Z"
+"PoolFeatures": "None"
+"Roof": "Shingles,Asphalt Shingle"
+"Sewer": "Sewer"
+"ShowingRequirements": array:2 [ …2]
+"SignOnPropertyYN": true
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Glen Forrest"
+"StreetNumber": "627"
+"StreetSuffix": "Boulevard"
+"TaxAnnualAmount": "4410.0"
+"TaxAssessedValue": 323000
+"TaxLegalDescription": "LOT 19 PLAN 1281 CITY OF WATERLOO S/T 404395 WATERLOO"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2% plus hst"
+"TransactionType": "For Sale"
+"VirtualTourURLBranded": "https://youriguide.com/627_glen_forest_blvd_waterloo_on/"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/627_glen_forest_blvd_waterloo_on/"
+"Zoning": "R1"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 130.0
+"LotWidth": 50.0
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12946870')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "301604190010300"
+"SurveyType": "Unknown"
+"RentalItems": "hot water heater"
+"HoldoverDays": 60
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 2
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2L 4K1, CA"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionDate": "2026-05-15"
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"DenFamilyroomYN": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "700-1100"
+"MortgageComment": "Consider Clear"
+"RoomsAboveGrade": 6
+"RoomsBelowGrade": 7
+"PossessionDetails": "immediate/flexible"
+"WashroomsType1Pcs": 4
+"WashroomsType2Pcs": 3
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "book using brokerbay"
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Basement"
+"MediaChangeTimestamp": "2026-04-01T18:54:58Z"
+"SystemModificationTimestamp": "2026-04-17T18:39:49.77026Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:50 [ …50]
+"ID": "659519"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2860
+post_id: "683668"
+post_author: 1
+"ListingKey": "X13013648"
+"ListingId": "X13013648"
+"PropertyType": "Residential"
+"PropertySubType": "Semi-Detached Condo"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-17T18:32:35Z"
+"RFModificationTimestamp": "2026-04-29T06:28:31Z"
+"ListPrice": 699000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J 4M5"
+"UnparsedAddress": "20 Mayfield Avenue 2, Waterloo, ON N2J 4M5"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.479432
+"Longitude": -80.499694
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "HOMELIFE/MIRACLE REALTY LTD"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Semi-Detached Home in Prime Waterloo Location! Welcome to this beautifully updated 3 Bedroom, Semi-detached home, perfectly situated in one of Waterloo's most sought after neighborhoods. This move in ready gem features a modern open-concept layout with stylish finishes and thoughtful upgrades throughout. The main floor boasts a bright and spacious living area, a contemporary kitchen with sleek cabinetry, and a dining space ideal for entertaining. Upstairs, you'll find three generous bedrooms with ample closet space Perfect for growing families or work-from-home flexibility. Enjoy peace of mind with all major updates completed, including flooring, lightings and much more! Located close to schools, universities, parks, shopping, and transit, this home offers the perfect blend of comfort, style, and convenience. Don't miss your chance to own this turnkey property in the heart of Waterloo!"
+"ArchitecturalStyle": "2-Storey"
+"AssociationAmenities": array:1 [ …1]
+"AssociationFee": "305.05"
+"AssociationFeeIncludes": array:2 [ …2]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": "None"
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-29T01:39:25.416921+00:00"
+"CrossStreet": "Mayfield & Bluevale"
+"Directions": "Mayfield & Bluevale"
+"Exclusions": "None"
+"ExpirationDate": "2026-06-30"
+"FoundationDetails": array:1 [ …1]
+"Inclusions": "FRIDGE , STOVE,DISHWASHER, DRYER AND ALL ELF'S"
+"InteriorFeatures": "Water Heater"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-17"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "406000"
+"MajorChangeTimestamp": "2026-04-17T18:32:35Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2026-04-17T18:32:35Z"
+"OriginalListPrice": 699000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3833518"
+"ParcelNumber": "235890002"
+"ParkingFeatures": "Private"
+"ParkingTotal": "2.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-04-17T18:32:35Z"
+"Roof": "Asphalt Shingle"
+"SecurityFeatures": array:2 [ …2]
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Mayfield"
+"StreetNumber": "20"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "2593.0"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2.5%-$50 Markting Fee"
+"TransactionType": "For Sale"
+"UnitNumber": "2"
+"DDFYN": true
+"Locker": "Ensuite"
+"Exposure": "East"
+"HeatType": "Baseboard"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13013648')"
+"GarageType": "None"
+"HeatSource": "Electric"
+"RollNumber": "301601250000212"
+"SurveyType": "Unknown"
+"BalconyType": "None"
+"RentalItems": "Hot Water Tank if rental"
+"HoldoverDays": 90
+"LaundryLevel": "Upper Level"
+"LegalStories": "1"
+"ParkingType1": "Exclusive"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 2
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2J 4M5, CA"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"CondoCorpNumber": 589
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "1000-1199"
+"RoomsAboveGrade": 6
+"PropertyFeatures": array:1 [ …1]
+"SquareFootSource": "MPAC"
+"PossessionDetails": "30/60"
+"WashroomsType1Pcs": 4
+"BedroomsAboveGrade": 3
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Second"
+"LegalApartmentNumber": "2"
+"MediaChangeTimestamp": "2026-04-17T18:32:35Z"
+"PropertyManagementCompany": "N/A"
+"SystemModificationTimestamp": "2026-04-17T18:32:35.371105Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:1 [ …1]
+"ID": "683668"
}
9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2861
+post_id: "712036"
+post_author: 1
+"ListingKey": "X12882820"
+"ListingId": "X12882820"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-17T18:11:01Z"
+"RFModificationTimestamp": "2026-04-29T03:30:33Z"
+"ListPrice": 839900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2N 3S4"
+"UnparsedAddress": "1273 Countrystone Drive, Waterloo, ON N2N 3S4"
+"Coordinates": array:2 [ …2]
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX REAL ESTATE CENTRE INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to this marvelous raised bungalow in the highly sought-after University Meadows neighbourhood of Kitchener. Built with versatility and modern living in mind, this beautifully maintained home offers an exceptional opportunity for multi-generational living, potential rental income or investment. The bright and spacious upper level showcases a contemporary open-concept design with elegant laminate flooring flowing through the living and dining areas into a stylish kitchen featuring custom cabinetry, granite countertops, and a sleek glass backsplash. Two generous bedrooms and a well-appointed 4-piece bathroom complete the main floor. A few steps up leads to a private primary retreat boasting its own ensuite bath and two oversized walk-in closets, providing abundant storage and comfort. The finished lower level offers a separate optional living space with two additional bedrooms, a full bathroom and a modern kitchen with granite countertops and laminate type flooring. With separate utilities and garage access, the layout is ideal for an in-law suite. Perfectly positioned, the home is just minutes from The Boardwalk shopping district, offering major retailers, restaurants, entertainment, and everyday conveniences. Residents also enjoy proximity to Country Stone Park and playground, scenic walking trails, excellent schools and quick access to University Avenue, Uptown Waterloo and the University of Waterloo campus. Major routes including Highway 7/8 and public transit are easily accessible, making commuting throughout the Waterloo Region seamless. With its modern finishes, flexible layout and unbeatable location, this exceptional property is a rare opportunity in one of Kitchener's most desirable communities. A must-see home offering lifestyle, convenience and investment potential."
+"ArchitecturalStyle": "Bungalow-Raised"
+"Basement": array:2 [ …2]
+"CoListOfficeName": "RE/MAX REAL ESTATE CENTRE INC."
+"CoListOfficePhone": "519-623-6200"
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": "Central Air"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "2.0"
+"CreationDate": "2026-04-29T01:46:38.190501+00:00"
+"CrossStreet": "Countrystone Cres"
+"DirectionFaces": "West"
+"Directions": "Countrystone Cres University- Countrystone Drive"
+"ExpirationDate": "2026-06-10"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"InteriorFeatures": "In-Law Capability,Other"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "London and St. Thomas Association of REALTORS"
+"ListingContractDate": "2026-03-13"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "079800"
+"MajorChangeTimestamp": "2026-04-17T18:11:01Z"
+"MlsStatus": "Price Change"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2026-03-13T23:31:07Z"
+"OriginalListPrice": 879900.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3659638"
+"ParcelNumber": "226981971"
+"ParkingTotal": "4.0"
+"PhotosChangeTimestamp": "2026-03-13T23:31:07Z"
+"PoolFeatures": "None"
+"PreviousListPrice": 879900.0
+"PriceChangeTimestamp": "2026-04-17T18:11:01Z"
+"Roof": "Asphalt Shingle"
+"Sewer": "Sewer"
+"ShowingRequirements": array:2 [ …2]
+"SignOnPropertyYN": true
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Countrystone"
+"StreetNumber": "1273"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "5739.0"
+"TaxAssessedValue": 423000
+"TaxLegalDescription": "LOT 43, PLAN 58M474, KITCHENER"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2% +HST"
+"TransactionType": "For Sale"
+"Zoning": "A"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 106.0
+"LotShape": "Irregular"
+"LotWidth": 44.52
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12882820')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "301206001203843"
+"SurveyType": "None"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 2
+"ParkingSpaces": 2
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2N 3S4, CA"
+"ApproximateAge": "6-15"
+"AssessmentYear": 2026
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Immediate"
+"PriorMlsStatus": "New"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "1500-2000"
+"MortgageComment": "Other"
+"RoomsAboveGrade": 5
+"RoomsBelowGrade": 4
+"ParcelOfTiedLand": "No"
+"LotIrregularities": "Irregular; Corner Lot"
+"PossessionDetails": "2 weeks from unconditional"
+"WashroomsType1Pcs": 4
+"WashroomsType2Pcs": 4
+"WashroomsType3Pcs": 4
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"KitchensAboveGrade": 1
+"KitchensBelowGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "TENANT will provide access, 48HR notice - LOCK ALL DOORS AND WINDOWS WHEN LEAVING PROPERTY - appointments through Broker Bay"
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Upper"
+"WashroomsType3Level": "Basement"
+"MediaChangeTimestamp": "2026-03-13T23:31:07Z"
+"DevelopmentChargesPaid": array:1 [ …1]
+"SystemModificationTimestamp": "2026-04-17T18:11:08.424236Z"
+"Media": array:2 [ …2]
+"ID": "712036"
}
]
+success: true
+page_size: 10
+page_count: 26
+count: 253
+after_key: ""
}
"RF Response Time" => "0.42 seconds"
]
"RF Cache Key: 593fd81bb3a7701e032e7201ad4b0a3d04129fccb02187acc5d741958a8ec433" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#3078
+items: array:10 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4273
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12737814"
+"ListingId": "X12737814"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Townhouse"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-19T15:51:53Z"
+"RFModificationTimestamp": "2026-04-30T05:00:26Z"
+"ListPrice": 539900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T 1H8"
+"UnparsedAddress": "493 Beechwood Drive 4, Waterloo, ON N2T 1H8"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4516807
+"Longitude": -80.5601366
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX REAL ESTATE CENTRE INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Open house, Sunday, April 26th, 12:15 to 2:15! Enjoy executive condo living with no grass to cut and no snow to shovel-in the summer where you just lock the door and go relax on your stunning private terrace overlooking the in-ground pool and tennis courts, all within one of the area's most desirable condo communities in Waterloo and just 2 minutes from Ira Needles shopping. Welcome to this well-maintained 2-bedroom, 2-bathroom town home in the sought-after Beechwood Villas. Offering 1,283 sq. ft. of comfortable living space, the bright main floor features a cozy wood-burning fireplace, spacious living and dining areas, and sliding doors leading to a large balcony with serene courtyard views. The sunny eat-in kitchen is perfect for everyday living and entertaining. Upstairs, you'll find two generous bedrooms, including a primary suite with a walk-in closet and cheater ensuite 4-piece bath. The finished lower level offers a versatile rec room, laundry, excellent storage, and direct access to the single-car garage. Set in a quiet, well-managed complex, residents enjoy private tennis courts, an outdoor pool, visitor parking, and a pet-friendly, BBQ-friendly environment. Close to walking trails, parks, top-rated schools, The Boardwalk, Costco, Sobeys, Uptown Waterloo, both universities, and major highways. Original owner - first time on the market. A rare opportunity in a premium location."
+"ArchitecturalStyle": array:1 [ …1]
+"AssociationFee": "664.23"
+"AssociationFeeIncludes": array:3 [ …3]
+"Basement": array:2 [ …2]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-19T15:55:05.416020+00:00"
+"CrossStreet": "erb/beechwood"
+"Directions": "erb street to beechwood"
+"Exclusions": "staging, gifts"
+"ExpirationDate": "2026-06-30"
+"FireplaceYN": true
+"GarageYN": true
+"Inclusions": "appliances all in as is condition"
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-01-28"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "079800"
+"MajorChangeTimestamp": "2026-04-19T15:51:53Z"
+"MlsStatus": "Price Change"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2026-01-29T04:57:47Z"
+"OriginalListPrice": 549900.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3492628"
+"ParcelNumber": "234030040"
+"ParkingTotal": "2.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-04-14T18:36:54Z"
+"PreviousListPrice": 549900.0
+"PriceChangeTimestamp": "2026-04-19T15:51:53Z"
+"ShowingRequirements": array:1 [ …1]
+"SignOnPropertyYN": true
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Beechwood"
+"StreetNumber": "493"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "3466.0"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2.0"
+"TransactionType": "For Sale"
+"UnitNumber": "4"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "West"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12737814')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "301604051507900"
+"SurveyType": "None"
+"BalconyType": "Terrace"
+"RentalItems": "water heater and water softner"
+"HoldoverDays": 120
+"LegalStories": "1"
+"ParkingType1": "Exclusive"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 1
+"UnderContract": array:2 [ …2]
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2T 1H8, CA"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "New"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"CondoCorpNumber": 403
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "1200-1399"
+"RoomsAboveGrade": 8
+"EnsuiteLaundryYN": true
+"SquareFootSource": "sqft"
+"PossessionDetails": "flexible"
+"WashroomsType1Pcs": 4
+"WashroomsType2Pcs": 2
+"BedroomsAboveGrade": 2
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Second"
+"WashroomsType2Level": "Main"
+"LegalApartmentNumber": "40"
+"MediaChangeTimestamp": "2026-04-14T18:36:54Z"
+"PropertyManagementCompany": "CMC management"
+"SystemModificationTimestamp": "2026-04-19T15:51:59.853316Z"
+"Media": array:47 [ …47]
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4274
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12986688"
+"ListingId": "X12986688"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Townhouse"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-18T20:46:38Z"
+"RFModificationTimestamp": "2026-04-30T05:01:36Z"
+"ListPrice": 445000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J 4J1"
+"UnparsedAddress": "121 University Avenue E 22, Waterloo, ON N2J 4J1"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.477687
+"Longitude": -80.516925
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX Solid Gold Realty (II) Ltd"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to Village on the Green, a well-established Waterloo community known for its mature trees, peaceful park-like setting, and rare blend of space, privacy, and convenience. Offering over 2,100 sq ft of total living space, this 4-bedroom, 2.5-bathroom end-unit townhome provides excellent flexibility for families, investors, or parents seeking housing near the universities. The functional multi-level layout features separate living and dining areas with great flow for everyday living and entertaining. The main living space is bright and welcoming with walkout access to the outdoor area, while the main floor bedroom works perfectly as a home office, guest room, or additional living space. Upstairs are three spacious bedrooms, including a large primary suite with walk-in closet and private ensuite, plus a separate family bathroom. The partially finished lower level offers additional recreation space, laundry, and plenty of storage, making the home highly practical for growing families or shared living arrangements. With $25,000 in recent updates, the home is clean, well-maintained, and move-in ready. Vacant possession with quick closing available. The layout supports strong rental potential with estimated income of approximately $3,600/month in a consistently high-demand location. Conveniently located: 2 minutes to the expressway 5 minutes or less to University of Waterloo, Wilfrid Laurier University, and Uptown Waterloo Directly across from Conestoga College Waterloo campus, close to transit, shopping, restaurants, parks, and walking trails1 owned underground parking space included, with additional parking available to rent ($50/month underground, $35/month surface). Condo fees include exterior maintenance, windows, and doors, offering a low-maintenance ownership experience in a highly desirable Waterloo neighbourhood."
+"ArchitecturalStyle": array:1 [ …1]
+"AssociationFee": "770.0"
+"AssociationFeeIncludes": array:3 [ …3]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-28T23:10:39.612573+00:00"
+"CrossStreet": "Marsland Avenue & University Avenue East"
+"Directions": "From highway, take the University ave W exit. after 1.5 kms, Village on the Green at 121 University is on the left just before Weber. unit 22 is 250 Metres up on the left."
+"ExpirationDate": "2026-07-22"
+"ExteriorFeatures": array:1 [ …1]
+"FoundationDetails": array:1 [ …1]
+"Inclusions": "Fridge, Stove, Dishwasher, Microwave, Hood vent, Washer, Dryer, Water Softener, Window coverings"
+"InteriorFeatures": array:4 [ …4]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:2 [ …2]
+"ListAOR": "One Point Association of REALTORS"
+"ListingContractDate": "2026-04-08"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "549200"
+"MajorChangeTimestamp": "2026-04-18T20:46:38Z"
+"MlsStatus": "Price Change"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2026-04-11T14:26:09Z"
+"OriginalListPrice": 399000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3669590"
+"ParcelNumber": "230230022"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-04-11T14:26:09Z"
+"PreviousListPrice": 399000.0
+"PriceChangeTimestamp": "2026-04-18T20:46:38Z"
+"Roof": array:1 [ …1]
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "E"
+"StreetName": "University"
+"StreetNumber": "121"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "3398.0"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2%"
+"TransactionType": "For Sale"
+"UnitNumber": "22"
+"VirtualTourURLBranded": "https://youriguide.com/22_121_university_avenue_east_waterloo_on/"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/22_121_university_avenue_east_waterloo_on/"
+"Zoning": "RMU-20"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "West"
+"HeatType": "Forced Air"
+"LotShape": "Rectangular"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12986688')"
+"GarageType": "Underground"
+"HeatSource": "Gas"
+"RollNumber": "301601380004221"
+"SurveyType": "None"
+"BalconyType": "None"
+"RentalItems": "Water Heater"
+"HoldoverDays": 90
+"LegalStories": "Ground"
+"ParkingSpot1": "22"
+"ParkingType1": "Exclusive"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"UnderContract": array:1 [ …1]
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2J 4J1, CA"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "New"
+"WashroomsType1": 1
+"WashroomsType2": 2
+"CondoCorpNumber": 23
+"DenFamilyroomYN": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "1400-1599"
+"RoomsAboveGrade": 9
+"RoomsBelowGrade": 3
+"SquareFootSource": "iguide"
+"PossessionDetails": "Unit is vacant"
+"WashroomsType1Pcs": 2
+"WashroomsType2Pcs": 4
+"BedroomsAboveGrade": 4
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Upper"
+"LegalApartmentNumber": "22"
+"MediaChangeTimestamp": "2026-04-11T14:26:09Z"
+"PropertyManagementCompany": "Onyx"
+"SystemModificationTimestamp": "2026-04-18T20:46:47.565185Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:28 [ …28]
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4277
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12967368"
+"ListingId": "X12967368"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-18T20:12:43Z"
+"RFModificationTimestamp": "2026-04-29T12:32:45Z"
+"ListPrice": 1200000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 3T9"
+"UnparsedAddress": "291 Albert Street, Waterloo, ON N2L 3T9"
+"Coordinates": array:2 [ …2]
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "ROYAL LEPAGE WOLLE REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Redevelopment Opportunity, Prime Location on High Traffic Albert Street. Can be purchased with 289 Albert Street. Adjacent properties at 285 and 293 Albert Street are also for sale for a larger parcel. Currently leased to provide income while you plan your redevelopment project. Zoning RN-6"
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-28T23:11:31.156721+00:00"
+"CrossStreet": "Hickory"
+"DirectionFaces": "West"
+"Directions": "University to Albert"
+"Exclusions": "Tenant's Belongings."
+"ExpirationDate": "2026-10-07"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-07"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "356100"
+"MajorChangeTimestamp": "2026-04-07T19:47:33Z"
+"MlsStatus": "New"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2026-04-07T19:47:33Z"
+"OriginalListPrice": 1200000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3705534"
+"ParcelNumber": "223640024"
+"ParkingTotal": "3.0"
+"PhotosChangeTimestamp": "2026-04-18T19:57:07Z"
+"PoolFeatures": array:1 [ …1]
+"Roof": array:1 [ …1]
+"Sewer": array:1 [ …1]
+"ShowingRequirements": array:2 [ …2]
+"SignOnPropertyYN": true
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Albert"
+"StreetNumber": "291"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "6124.0"
+"TaxLegalDescription": "PT LT 6 SUBDIVISION OF LT 13 GERMAN COMPANY TRACT CITY OF WATERLOO AS IN 1322621; WATERLOO"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2% Plus HST"
+"TransactionType": "For Sale"
+"Zoning": "RN-6"
+"UFFI": "Removed"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 131.0
+"LotShape": "Irregular"
+"LotWidth": 54.0
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12967368')"
+"GarageType": "Detached"
+"HeatSource": "Gas"
+"RollNumber": "301604005015600"
+"SurveyType": "None"
+"HoldoverDays": 60
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 2
+"ParkingSpaces": 2
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2L 3T9, CA"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 2
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "1100-1500"
+"RoomsAboveGrade": 13
+"LotSizeAreaUnits": "Acres"
+"PossessionDetails": "Flexible"
+"WashroomsType1Pcs": 4
+"BedroomsAboveGrade": 5
+"KitchensAboveGrade": 2
+"SpecialDesignation": array:1 [ …1]
+"MediaChangeTimestamp": "2026-04-18T19:57:07Z"
+"SystemModificationTimestamp": "2026-04-18T20:12:43.080586Z"
+"Media": array:10 [ …10]
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4276
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X13014718"
+"ListingId": "X13014718"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-18T15:59:15Z"
+"RFModificationTimestamp": "2026-04-29T12:33:37Z"
+"ListPrice": 1795000.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 10043.0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 5W3"
+"UnparsedAddress": "239 Corrie Crescent, Waterloo, ON N2L 5W3"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4832944
+"Longitude": -80.5498184
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX Solid Gold Realty (II) Ltd"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to a truly exceptional home on a quiet street in one of the area's most sought-after neighbourhoods. Extensively renovated, this residence offers a refined mix of modern design, quality finishes, and functional living space. From the striking exterior and landscaped approach to the dramatic curved staircase inside, every detail has been carefully considered. The main level is designed for both daily living and entertaining, featuring oversized windows, designer lighting, a formal living room, and a separate dining room. The chef's kitchen is a standout, with custom cabinetry, Jenn Air appliances, a pot filler, waterfall island with seating, and integrated storage. The family room includes a floor-to-ceiling fireplace, while a dedicated home office, laundry room, and powder room complete the level. Upstairs, you'll find four spacious bedrooms with hardwood flooring, floor-to-ceiling windows, and large closets. The primary suite offers a custom walk-in closet and a spa-inspired ensuite with heated floors, glass shower, and freestanding soaker tub. A second ensuite and cheater bath add comfort and convenience for family and guests. The finished lower level adds excellent flexibility with a large rec room, bar, fifth bedroom, full bathroom, and separate entrance, making it ideal for guests, teens, or extended family. Outside, mature trees and well-planned outdoor living areas create a peaceful space to relax or entertain. This is a rare opportunity to own a turnkey luxury home in an established neighbourhood."
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:2 [ …2]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"Country": "CA"
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "2.0"
+"CreationDate": "2026-04-28T23:46:59.057812+00:00"
+"CrossStreet": "Bearinger Rd."
+"DirectionFaces": "West"
+"Directions": "Bearinger Rd. to Corrie Cres."
+"Exclusions": "Staging materials"
+"ExpirationDate": "2026-07-31"
+"ExteriorFeatures": array:4 [ …4]
+"FireplaceFeatures": array:2 [ …2]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "Dishwasher, Dryer, Microwave, Refrigerator, Stove, Washer"
+"InteriorFeatures": array:9 [ …9]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "One Point Association of REALTORS"
+"ListingContractDate": "2026-04-17"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "549200"
+"MajorChangeTimestamp": "2026-04-17T21:28:22Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2026-04-17T21:28:22Z"
+"OriginalListPrice": 1795000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3700200"
+"ParcelNumber": "222560015"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "8.0"
+"PhotosChangeTimestamp": "2026-04-17T21:28:22Z"
+"PoolFeatures": array:1 [ …1]
+"Roof": array:1 [ …1]
+"SecurityFeatures": array:4 [ …4]
+"Sewer": array:1 [ …1]
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Corrie"
+"StreetNumber": "239"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "13381.0"
+"TaxLegalDescription": "LT 6 PL 1418 CITY OF WATERLOO; WATERLOO"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2.0% + hst"
+"TransactionType": "For Sale"
+"VirtualTourURLBranded": "https://youriguide.com/ex1ps_239_corrie_crescent_waterloo_on/"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/ex1ps_239_corrie_crescent_waterloo_on/"
+"Zoning": "R3"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 154.43
+"LotShape": "Rectangular"
+"LotWidth": 65.09
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13014718')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "301604136009200"
+"SurveyType": "None"
+"RentalItems": "Hot Water Heater"
+"HoldoverDays": 30
+"LaundryLevel": "Main Level"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 6
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2L 5W3, CA"
+"ApproximateAge": "31-50"
+"AssessmentYear": 2026
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"WashroomsType3": 1
+"WashroomsType4": 1
+"WashroomsType5": 1
+"DenFamilyroomYN": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "3000-3500"
+"RoomsAboveGrade": 15
+"RoomsBelowGrade": 6
+"LotSizeAreaUnits": "Square Feet"
+"PropertyFeatures": array:6 [ …6]
+"PossessionDetails": "Immediate"
+"WashroomsType1Pcs": 3
+"WashroomsType2Pcs": 4
+"WashroomsType3Pcs": 5
+"WashroomsType4Pcs": 3
+"WashroomsType5Pcs": 2
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Second"
+"WashroomsType2Level": "Second"
+"WashroomsType3Level": "Second"
+"WashroomsType4Level": "Basement"
+"WashroomsType5Level": "Main"
+"MediaChangeTimestamp": "2026-04-17T21:28:22Z"
+"SystemModificationTimestamp": "2026-04-18T15:59:30.110786Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:50 [ …50]
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4275
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X13010736"
+"ListingId": "X13010736"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-18T14:09:39Z"
+"RFModificationTimestamp": "2026-04-30T10:22:55Z"
+"ListPrice": 1149.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 3W9"
+"UnparsedAddress": "330 Phillip Street N207, Waterloo, ON N2L 3W9"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.4762025
+"Longitude": -80.5389214
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "CENTURY 21 GREEN REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "GIRLS Only - Luxury Student Condo: 1-Bedroom Available in a 2-Bedroom Unit, shared common areas *Fully Furnished, Carpet-Free | The building offers excellent amenities, including a professional study lounge, study rooms, 24-hour security, rooftop patio, basketball court, gym, sauna, and games room | Conveniently located within walking distance to the University of Waterloo and Wilfrid Laurier University | Suitable for a girl student seeking a clean, respectful, and study-focused living environment OR a single lady working professional | The other bedroom is occupied by a co-op girl student ***"
+"ArchitecturalStyle": array:1 [ …1]
+"AssociationFee": "302.2"
+"Basement": array:1 [ …1]
+"CoListOfficeName": "CENTURY 21 GREEN REALTY INC."
+"CoListOfficePhone": "905-565-9565"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-28T23:54:17.235807+00:00"
+"CrossStreet": "Columbia Street & Philip Street"
+"Directions": "From Columbia St, head south on Phillip St. 330 Phillip St will be on the west side."
+"ExpirationDate": "2026-06-30"
+"Furnished": "Furnished"
+"Inclusions": "Luxury, fully Furnished Accommodation for GIRLS ONLY | Seeking responsible, highly qualified tenants | No pets _ Non-smokers."
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"LeaseTerm": "12 Months"
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-17"
+"MainOfficeKey": "137100"
+"MajorChangeTimestamp": "2026-04-17T11:36:50Z"
+"MlsStatus": "New"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2026-04-17T11:36:50Z"
+"OriginalListPrice": 1149.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3780210"
+"ParcelNumber": "236270051"
+"ParkingFeatures": array:1 [ …1]
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-04-17T11:36:51Z"
+"RentIncludes": array:1 [ …1]
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Phillip"
+"StreetNumber": "330"
+"StreetSuffix": "Street"
+"TransactionBrokerCompensation": "1/2 Month REnt"
+"TransactionType": "For Lease"
+"UnitNumber": "N207"
+"View": array:1 [ …1]
+"VirtualTourURLBranded": "https://video-api.supreme.one/V6qpyf?branded=true"
+"VirtualTourURLUnbranded": "https://video-api.supreme.one/V6qpyf?branded=false"
+"UFFI": "No"
+"DDFYN": true
+"Locker": "Exclusive"
+"Exposure": "East"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13010736')"
+"ElevatorYN": true
+"GarageType": "None"
+"HeatSource": "Gas"
+"RollNumber": "301604350000925"
+"SurveyType": "Unknown"
+"Waterfront": array:1 [ …1]
+"BalconyType": "None"
+"LockerLevel": "A"
+"HoldoverDays": 90
+"LaundryLevel": "Main Level"
+"LegalStories": "2"
+"LockerNumber": "503"
+"ParkingType1": "None"
+"CreditCheckYN": true
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"PaymentMethod": "Cheque"
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2L 3W9, CA"
+"ApproximateAge": "6-10"
+"ContractStatus": "Available"
+"PossessionDate": "2026-06-01"
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"CondoCorpNumber": 627
+"DepositRequired": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "500-599"
+"RoomsAboveGrade": 4
+"LeaseAgreementYN": true
+"PaymentFrequency": "Monthly"
+"PropertyFeatures": array:2 [ …2]
+"SquareFootSource": "MPAC"
+"PossessionDetails": "Flexible"
+"PrivateEntranceYN": true
+"WashroomsType1Pcs": 3
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"EmploymentLetterYN": true
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"RentalApplicationYN": true
+"ShowingAppointments": "Broker Bay - Through L/A"
+"WashroomsType1Level": "Flat"
+"LegalApartmentNumber": "18"
+"MediaChangeTimestamp": "2026-04-18T14:09:39Z"
+"PortionLeaseComments": "Private Rm. in 2-bedroom aprt."
+"PortionPropertyLease": array:1 [ …1]
+"ReferencesRequiredYN": true
+"PropertyManagementCompany": "Craft Property Management"
+"SystemModificationTimestamp": "2026-04-18T14:09:42.193654Z"
+"GreenPropertyInformationStatement": true
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:19 [ …19]
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4272
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X13014686"
+"ListingId": "X13014686"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Condo Townhouse"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-17T21:16:46Z"
+"RFModificationTimestamp": "2026-04-29T01:43:39Z"
+"ListPrice": 3199.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J 0G1"
+"UnparsedAddress": "99 Roger Street 50, Waterloo, ON N2J 0G1"
+"Coordinates": array:2 [ …2]
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "REAL BROKER ONTARIO LTD."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Experience Luxury And Spacious Living In This Impressive 1,810 Sq Ft Executive Townhouse With 3 Bedrooms And 2.5 Baths. Flooded With Natural Light From Large Picture Windows, This Home Boasts High 9 Ft Ceilings, Sophisticated Modern Finishes, Quartz Countertops, In-Suite Laundry, And Two Balconies. The Master Suite Offers A Serene Retreat With A Beautiful Ensuite Bathroom, A Walk-In Closet, And Its Own Balcony. Situated In A Prime Location, You're Just A Short Walk To The LRT And Minutes Away From Google, The Vibrant Tech Hub, Universities, Shopping, Uptown Waterloo, Downtown Kitchener, The Spur Line Trail, And The Hospital. Impeccably Maintained, Spacious, And Move-In Ready, With An Additional Balcony Off The Living Room. An Outstanding Property That Combines Convenience And Style."
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:1 [ …1]
+"CoListOfficeName": "REAL BROKER ONTARIO LTD."
+"CoListOfficePhone": "888-311-1172"
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-29T00:44:29.615910+00:00"
+"CrossStreet": "Roger Street/Moore Ave S"
+"Directions": "Roger Street/Moore Ave S"
+"ExpirationDate": "2026-06-30"
+"Furnished": "Unfurnished"
+"GarageYN": true
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"LeaseTerm": "12 Months"
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-17"
+"MainOfficeKey": "384000"
+"MajorChangeTimestamp": "2026-04-17T21:16:46Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2026-04-17T21:16:46Z"
+"OriginalListPrice": 3199.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3834432"
+"ParcelNumber": "237730222"
+"ParkingFeatures": array:2 [ …2]
+"ParkingTotal": "2.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-04-17T21:16:46Z"
+"RentIncludes": array:1 [ …1]
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Roger"
+"StreetNumber": "99"
+"StreetSuffix": "Street"
+"TransactionBrokerCompensation": "1/2 Month + HST"
+"TransactionType": "For Lease"
+"UnitNumber": "50"
+"DDFYN": true
+"Locker": "None"
+"Exposure": "North East"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13014686')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"SurveyType": "None"
+"BalconyType": "Open"
+"HoldoverDays": 90
+"LegalStories": "1"
+"ParkingType1": "Owned"
+"CreditCheckYN": true
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 1
+"PaymentMethod": "Cheque"
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2J 0G1, CA"
+"ApproximateAge": "0-5"
+"ContractStatus": "Available"
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 2
+"CondoCorpNumber": 773
+"DepositRequired": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "1600-1799"
+"RoomsAboveGrade": 9
+"LeaseAgreementYN": true
+"PaymentFrequency": "Monthly"
+"SquareFootSource": "Builder"
+"PossessionDetails": "Immediate"
+"PrivateEntranceYN": true
+"WashroomsType1Pcs": 2
+"WashroomsType2Pcs": 3
+"BedroomsAboveGrade": 3
+"EmploymentLetterYN": true
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"RentalApplicationYN": true
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Second"
+"LegalApartmentNumber": "110"
+"MediaChangeTimestamp": "2026-04-17T21:16:46Z"
+"PortionPropertyLease": array:1 [ …1]
+"ReferencesRequiredYN": true
+"PropertyManagementCompany": "WSCP"
+"SystemModificationTimestamp": "2026-04-17T21:16:46.97348Z"
+"Media": array:27 [ …27]
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4271
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X13013878"
+"ListingId": "X13013878"
+"PropertyType": "Residential"
+"PropertySubType": "Condo Apartment"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-17T19:00:56Z"
+"RFModificationTimestamp": "2026-04-29T01:43:37Z"
+"ListPrice": 372000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2G 0C8"
+"UnparsedAddress": "104 Garment Street 16, Waterloo, ON N2G 0C8"
+"Coordinates": array:2 [ …2]
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "ROYAL LEPAGE WOLLE REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Perched high above the vibrant Kitchener skyline, this ONE-BED + DEN condo at 104 Garment St, Unit 1206 offers an exceptional opportunity in Downtown Kitchener's most sought-after addresses. BRIGHT OPEN-CONCEPT LAYOUT enhanced by PREMIUM FLOORING AND FRESHLY PAINTED neutral tones. The contemporary kitchen offers GENEROUS GRANITE COUNTERTOPS, STAINLESS STEEL APPLIANCES, A TASTEFUL TILE BACKSPLASH, & a breakfast bar that overlooks the main living area. The spacious living room is flooded with natural light from IMPRESSIVE FLOOR-TO-CEILING WINDOWS and offers direct access to a private balcony overlooking the terrace below. The PRIMARY BEDROOM IS BOTH COMFORTABLE AND FUNCTIONAL, featuring a large walk-in closet and a GENEROUS WINDOW FRAMING ELEVATED CITY VIEWS. A versatile den provides the perfect space for a home office, reading nook, or guest area, also offering a full 4-piece bathroom, convenient in-suite laundry, and additional storage. Residents of this highly desirable building enjoy an impressive array of PREMIUM AMENITIES INCLUDING A ROOFTOP TERRACE with stunning city views, a fully equipped fitness centre, private theatre room, party room, and a stylish media lounge-perfectly suited for today's dynamic professional lifestyle. The unit also comes complete with one underground parking space for added convenience. Ideally situated in the heart of Downtown Kitchener's Innovation District, this prime location places you just steps from the ION LRT, Grand River Hospital, Victoria Park, and an incredible selection of restaurants, cafés, and boutique shops. With major employers such as Google and the thriving tech hub nearby, THIS LOCATION IS PERFECTLY POSITIONED FOR PROFESSIONALS SEEKING BOTH CONNECTIVITY AND LIFESTYLE. Offering the perfect blend of modern design, functional living space, and unbeatable downtown convenience, this impressive condominium is a remarkable opportunity to enjoy the very best of city living."
+"ArchitecturalStyle": array:1 [ …1]
+"AssociationAmenities": array:4 [ …4]
+"AssociationFee": "624.53"
+"AssociationFeeIncludes": array:3 [ …3]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-29T01:28:43.066273+00:00"
+"CrossStreet": "King Street"
+"Directions": "King Street & Victoria St"
+"ExpirationDate": "2026-07-31"
+"Inclusions": "Built-in Microwave, Dishwasher, Dryer, Refrigerator, Stove, Washer"
+"InteriorFeatures": array:3 [ …3]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-17"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "356100"
+"MajorChangeTimestamp": "2026-04-17T18:59:25Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2026-04-17T18:59:25Z"
+"OriginalListPrice": 372000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3832890"
+"ParcelNumber": "236700275"
+"ParkingTotal": "1.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-04-17T18:59:25Z"
+"ShowingRequirements": array:2 [ …2]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Garment"
+"StreetNumber": "104"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3581.58"
+"TaxAssessedValue": 264000
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2%+HST reduced if shown by LA"
+"TransactionType": "For Sale"
+"UnitNumber": "16"
+"View": array:2 [ …2]
+"VirtualTourURLBranded": "https://sites.ground2airmedia.com/sites/104-garment-st-kitchener-on-n2g-0c8-22525279/branded"
+"VirtualTourURLBranded2": "https://youtube.com/shorts/JV9rc Ha90EI"
+"VirtualTourURLUnbranded": "https://sites.ground2airmedia.com/sites/rwnxozkx/unbranded"
+"VirtualTourURLUnbranded2": "https://youriguide.com/1206_104_garment_st_kitchener_on"
+"Zoning": "M2"
+"DDFYN": true
+"Locker": "Ensuite"
+"Exposure": "South"
+"HeatType": "Forced Air"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13013878')"
+"GarageType": "Underground"
+"HeatSource": "Gas"
+"RollNumber": "301205000814386"
+"SurveyType": "None"
+"BalconyType": "Open"
+"HoldoverDays": 120
+"LegalStories": "12"
+"ParkingType1": "Exclusive"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2G 0C8, CA"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Immediate"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"CondoCorpNumber": 670
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "700-799"
+"RoomsAboveGrade": 4
+"EnsuiteLaundryYN": true
+"PropertyFeatures": array:1 [ …1]
+"SalesBrochureUrl": "https://bit.ly/104Garment Unit1206Brochure"
+"SquareFootSource": "Plans"
+"PossessionDetails": "Immediate"
+"WashroomsType1Pcs": 4
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Main"
+"LegalApartmentNumber": "1206"
+"MediaChangeTimestamp": "2026-04-17T18:59:25Z"
+"PropertyManagementCompany": "Wilson Blanchard"
+"SystemModificationTimestamp": "2026-04-17T19:00:59.584643Z"
+"Media": array:34 [ …34]
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4270
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12946870"
+"ListingId": "X12946870"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-17T18:39:40Z"
+"RFModificationTimestamp": "2026-04-29T01:43:04Z"
+"ListPrice": 800000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L 4K1"
+"UnparsedAddress": "627 Glen Forrest Boulevard, Waterloo, ON N2L 4K1"
+"Coordinates": array:2 [ …2]
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "KELLER WILLIAMS INNOVATION REALTY"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "627 Glen Forrest - Fully Renovated Raised Bungalow with Exceptional Versatility! Located in one of the area's most popular neighborhoods, this beautifully updated home is perfect for families, multi-family living, or investors alike. Enjoy the convenience of nearby schools, shopping, scenic trails, and more - just a 5-minute drive to the U of W and Wilfrid Laurier University, and only 2 minutes to the Expressway for effortless commuting. From the moment you arrive, the extensive exterior upgrades are evident. The home features a newly poured concrete driveway extending to the backyard, a 500 sq ft concrete back pad, and a stunning two-tier deck (approx. $20,000) ideal for entertaining. The aggregate stone porch with covered roof creates a welcoming entrance. Additional updates: newer windows (3 years old), new exterior paint, new front and patio doors, new garage door, new railings (inside and out - approx. $15,000), and pot lights enhancing both curb appeal and functionality.Bright, one-level living on the main floor. The fully renovated open-concept layout seamlessly connects the kitchen, living, and dining areas. The modern kitchen features a large island with quartz countertops, stone backsplash, and brand-new appliances (fridge, stove, dishwasher). New flooring, trim, doors, pot lights, and fresh paint throughout complete the contemporary feel. The main level includes three spacious bedrooms and a beautifully renovated full bathroom. The lower level benefits from large above-grade windows, allowing for abundant natural light. This level offers a generous rec room/living area, 2 additional bedrooms and a full bathroom- making it ideal for extended family, multi-generational living, or strong rental potential. Major mechanical upgrades include all new electrical wiring and panel, and a new furnace (only 2 months old). $150,000 in Total Updates! Must See!"
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:4 [ …4]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "1.0"
+"CreationDate": "2026-04-29T01:37:51.614412+00:00"
+"CrossStreet": "northfield/weber"
+"DirectionFaces": "West"
+"Directions": "NORTHFIELD TO WEBER SOUTH THEN WEST ONTO GLENFORREST IT IS ON THE RIGHT AFTER GLENDENE CRESCENT"
+"ExpirationDate": "2026-07-31"
+"ExteriorFeatures": array:1 [ …1]
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"Inclusions": "Dishwasher, Dryer, Refrigerator, Stove, Washer"
+"InteriorFeatures": array:3 [ …3]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-01"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "350800"
+"MajorChangeTimestamp": "2026-04-01T18:54:58Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2026-04-01T18:54:58Z"
+"OriginalListPrice": 800000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3754348"
+"ParcelNumber": "222640119"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "3.0"
+"PhotosChangeTimestamp": "2026-04-01T18:54:58Z"
+"PoolFeatures": array:1 [ …1]
+"Roof": array:2 [ …2]
+"Sewer": array:1 [ …1]
+"ShowingRequirements": array:2 [ …2]
+"SignOnPropertyYN": true
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Glen Forrest"
+"StreetNumber": "627"
+"StreetSuffix": "Boulevard"
+"TaxAnnualAmount": "4410.0"
+"TaxAssessedValue": 323000
+"TaxLegalDescription": "LOT 19 PLAN 1281 CITY OF WATERLOO S/T 404395 WATERLOO"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2% plus hst"
+"TransactionType": "For Sale"
+"VirtualTourURLBranded": "https://youriguide.com/627_glen_forest_blvd_waterloo_on/"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/627_glen_forest_blvd_waterloo_on/"
+"Zoning": "R1"
+"DDFYN": true
+"Water": "Municipal"
+"HeatType": "Forced Air"
+"LotDepth": 130.0
+"LotWidth": 50.0
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X12946870')"
+"GarageType": "Attached"
+"HeatSource": "Gas"
+"RollNumber": "301604190010300"
+"SurveyType": "Unknown"
+"RentalItems": "hot water heater"
+"HoldoverDays": 60
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 2
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2L 4K1, CA"
+"AssessmentYear": 2025
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionDate": "2026-05-15"
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"WashroomsType2": 1
+"DenFamilyroomYN": true
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "700-1100"
+"MortgageComment": "Consider Clear"
+"RoomsAboveGrade": 6
+"RoomsBelowGrade": 7
+"PossessionDetails": "immediate/flexible"
+"WashroomsType1Pcs": 4
+"WashroomsType2Pcs": 3
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"ShowingAppointments": "book using brokerbay"
+"WashroomsType1Level": "Main"
+"WashroomsType2Level": "Basement"
+"MediaChangeTimestamp": "2026-04-01T18:54:58Z"
+"SystemModificationTimestamp": "2026-04-17T18:39:49.77026Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:50 [ …50]
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4269
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X13013648"
+"ListingId": "X13013648"
+"PropertyType": "Residential"
+"PropertySubType": "Semi-Detached Condo"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-17T18:32:35Z"
+"RFModificationTimestamp": "2026-04-29T06:28:31Z"
+"ListPrice": 699000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J 4M5"
+"UnparsedAddress": "20 Mayfield Avenue 2, Waterloo, ON N2J 4M5"
+"Coordinates": array:2 [ …2]
+"Latitude": 43.479432
+"Longitude": -80.499694
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "HOMELIFE/MIRACLE REALTY LTD"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Semi-Detached Home in Prime Waterloo Location! Welcome to this beautifully updated 3 Bedroom, Semi-detached home, perfectly situated in one of Waterloo's most sought after neighborhoods. This move in ready gem features a modern open-concept layout with stylish finishes and thoughtful upgrades throughout. The main floor boasts a bright and spacious living area, a contemporary kitchen with sleek cabinetry, and a dining space ideal for entertaining. Upstairs, you'll find three generous bedrooms with ample closet space Perfect for growing families or work-from-home flexibility. Enjoy peace of mind with all major updates completed, including flooring, lightings and much more! Located close to schools, universities, parks, shopping, and transit, this home offers the perfect blend of comfort, style, and convenience. Don't miss your chance to own this turnkey property in the heart of Waterloo!"
+"ArchitecturalStyle": array:1 [ …1]
+"AssociationAmenities": array:1 [ …1]
+"AssociationFee": "305.05"
+"AssociationFeeIncludes": array:2 [ …2]
+"Basement": array:1 [ …1]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CreationDate": "2026-04-29T01:39:25.416921+00:00"
+"CrossStreet": "Mayfield & Bluevale"
+"Directions": "Mayfield & Bluevale"
+"Exclusions": "None"
+"ExpirationDate": "2026-06-30"
+"FoundationDetails": array:1 [ …1]
+"Inclusions": "FRIDGE , STOVE,DISHWASHER, DRYER AND ALL ELF'S"
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "Toronto Regional Real Estate Board"
+"ListingContractDate": "2026-04-17"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "406000"
+"MajorChangeTimestamp": "2026-04-17T18:32:35Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2026-04-17T18:32:35Z"
+"OriginalListPrice": 699000.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3833518"
+"ParcelNumber": "235890002"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "2.0"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-04-17T18:32:35Z"
+"Roof": array:1 [ …1]
+"SecurityFeatures": array:2 [ …2]
+"ShowingRequirements": array:1 [ …1]
+"SourceSystemID": "A00001796"
+"SourceSystemName": "Toronto Regional Real Estate Board"
+"StateOrProvince": "ON"
+"StreetName": "Mayfield"
+"StreetNumber": "20"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "2593.0"
+"TaxYear": "2025"
+"TransactionBrokerCompensation": "2.5%-$50 Markting Fee"
+"TransactionType": "For Sale"
+"UnitNumber": "2"
+"DDFYN": true
+"Locker": "Ensuite"
+"Exposure": "East"
+"HeatType": "Baseboard"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X13013648')"
+"GarageType": "None"
+"HeatSource": "Electric"
+"RollNumber": "301601250000212"
+"SurveyType": "Unknown"
+"BalconyType": "None"
+"RentalItems": "Hot Water Tank if rental"
+"HoldoverDays": 90
+"LaundryLevel": "Upper Level"
+"LegalStories": "1"
+"ParkingType1": "Exclusive"
+"HeatTypeMulti": array:1 [ …1]
+"KitchensTotal": 1
+"ParkingSpaces": 2
+"provider_name": "TRREB"
+"short_address": "Waterloo, ON N2J 4M5, CA"
+"ContractStatus": "Available"
+"HSTApplication": array:1 [ …1]
+"PossessionType": "Flexible"
+"PriorMlsStatus": "Draft"
+"WashroomsType1": 1
+"CondoCorpNumber": 589
+"HeatSourceMulti": array:1 [ …1]
+"LivingAreaRange": "1000-1199"
+"RoomsAboveGrade": 6
+"PropertyFeatures": array:1 [ …1]
+"SquareFootSource": "MPAC"
+"PossessionDetails": "30/60"
+"WashroomsType1Pcs": 4
+"BedroomsAboveGrade": 3
+"KitchensAboveGrade": 1
+"SpecialDesignation": array:1 [ …1]
+"WashroomsType1Level": "Second"
+"LegalApartmentNumber": "2"
+"MediaChangeTimestamp": "2026-04-17T18:32:35Z"
+"PropertyManagementCompany": "N/A"
+"SystemModificationTimestamp": "2026-04-17T18:32:35.371105Z"
+"PermissionToContactListingBrokerToAdvertise": true
+"Media": array:1 [ …1]
}
9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4268
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X12882820"
+"ListingId": "X12882820"
+"PropertyType": "Residential"
+"PropertySubType": "Detached"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-17T18:11:01Z"
+"RFModificationTimestamp": "2026-04-29T03:30:33Z"
+"ListPrice": 839900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2N 3S4"
+"UnparsedAddress": "1273 Countrystone Drive, Waterloo, ON N2N 3S4"
+"Coordinates": array:2 [ …2]
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX REAL ESTATE CENTRE INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to this marvelous raised bungalow in the highly sought-after University Meadows neighbourhood of Kitchener. Built with versatility and modern living in mind, this beautifully maintained home offers an exceptional opportunity for multi-generational living, potential rental income or investment. The bright and spacious upper level showcases a contemporary open-concept design with elegant laminate flooring flowing through the living and dining areas into a stylish kitchen featuring custom cabinetry, granite countertops, and a sleek glass backsplash. Two generous bedrooms and a well-appointed 4-piece bathroom complete the main floor. A few steps up leads to a private primary retreat boasting its own ensuite bath and two oversized walk-in closets, providing abundant storage and comfort. The finished lower level offers a separate optional living space with two additional bedrooms, a full bathroom and a modern kitchen with granite countertops and laminate type flooring. With separate utilities and garage access, the layout is ideal for an in-law suite. Perfectly positioned, the home is just minutes from The Boardwalk shopping district, offering major retailers, restaurants, entertainment, and everyday conveniences. Residents also enjoy proximity to Country Stone Park and playground, scenic walking trails, excellent schools and quick access to University Avenue, Uptown Waterloo and the University of Waterloo campus. Major routes including Highway 7/8 and public transit are easily accessible, making commuting throughout the Waterloo Region seamless. With its modern finishes, flexible layout and unbeatable location, this exceptional property is a rare opportunity in one of Kitchener's most desirable communities. A must-see home offering lifestyle, convenience and investment potential."
+"ArchitecturalStyle": array:1 [ …1]
+"Basement": array:2 [ …2]
+"CoListOfficeName": "RE/MAX REAL ESTATE CENTRE INC."
+"CoListOfficePhone": "519-623-6200"
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Waterloo"
+"CoveredSpaces": "2.0"
+"CreationDate": "2026-04-29T01:46:38.190501+00:00"
+"CrossStreet": "Countrystone Cres"
+"DirectionFaces": "West"
+"Directions": "Countrystone Cres University- Countrystone Drive"
+"ExpirationDate": "2026-06-10"
+"FoundationDetails": array:1 [ …1]
+"GarageYN": true
+"InteriorFeatures": array:2 [ …2]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "London and St. Thomas Association of REALTORS"
+"ListingContractDate": "2026-03-13"
+"LotSizeSource": "MPAC"
+"MainOfficeKey": "079800"
+"MajorChangeTimestamp": "2026-04-17T18:11:01Z"
+"MlsStatus": "Price Change"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2026-03-13T23:31:07Z"
+"OriginalListPrice": 879900.0
+"OriginatingSystemID": "A00001796"
+"OriginatingSystemKey": "Draft3659638"
+"ParcelNumber": "226981971"
+"ParkingTotal": "4.0"
+"PhotosChangeTimestamp": "2026-03-13T23:31:07Z"
…69
}
]
+success: true
+page_size: 10
+page_count: 26
+count: 253
+after_key: ""
}
]
"RF Cache Key: 5f2e4a03e397dfc059bb210a593ad47f69ea85b04d21be98c92a219c13d13a4a" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#4239
+items: array:5 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4093 …147}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4094 …126}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4095 …120}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4096 …120}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4097 …138}
]
+success: true
+page_size: 5
+page_count: 8226
+count: 41128
+after_key: ""
}
]
]
