array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 30032440 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23472
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23474
+post_id: "1625119"
+post_author: 1
+"ListingKey": "30032440"
+"ListingId": "X13562984"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-14T19:45:05Z"
+"RFModificationTimestamp": "2026-07-14T23:39:35Z"
+"ListPrice": 499000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L1W3"
+"UnparsedAddress": "501 - 312 ERB STREET, Waterloo, Ontario N2L1W3"
+"Coordinates": array:2 [
0 => -80.543468
1 => 43.456288
]
+"Latitude": 43.456288
+"Longitude": -80.543468
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this bright and spacious condo featuring the convenience of in-suite laundry and complimentary Bell internet. Filled with natural light, this thoughtfully designed unit offers two private balconies-one off the secondary bedroom, perfect for enjoying a quiet morning coffee, and a larger balcony accessible from the kitchen. This expansive outdoor space is ideal for summer entertaining, relaxing in the sunshine, or creating your own small garden oasis. Residents enjoy an excellent selection of amenities, including a spacious co-working lounge with private phone pods, a pet washing station, electronic parcel lockers, and a stylish party room with private event space for hosting family and friends. Conveniently located just minutes from the University of Waterloo, this is close to shopping and dining along Westmount Road, the Waterloo Recreation Centre, Waterloo Park, and the vibrant shops, restaurants, and cafés of Uptown Waterloo. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"AssociationFee": "581.01"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-14T23:39:26.406092+00:00"
+"Directions": "University Ave W/ Erb St W"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2081088"
+"ListOfficeKey": "74899"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-07-14T19:38:25Z"
+"PhotosCount": 1
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-14T19:38:25Z"
+"StreetName": "Erb"
+"StreetNumber": "312"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3535.71"
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30032440/501-312-erb-street-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-07-14T19:38:25.22Z"
+"ListAgentNationalAssociationId": "1355934"
+"ListOfficeNationalAssociationId": "1246437"
+"Media": array:1 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30032440_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30032440/dacded670095efb5968583112247c228.webp"
"MediaSize" => 19188
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30032440/thumbnail-dacded670095efb5968583112247c228.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13562984"
"ResourceRecordKey" => "30032440"
"ModificationTimestamp" => "2026-07-14T19:38:25.23Z"
]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30032440')"
+"ID": "1625119"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 74899" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24912
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24820
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "RE/MAX REALTY SPECIALISTS INC."
+"OfficeEmail": null
+"OfficePhone": "905-456-3232"
+"OfficeMlsId": "495301"
+"ModificationTimestamp": "2026-03-03T10:59:08Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "74899"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "490 BRAMALEA ROAD SUITE 400"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "BRAMPTON"
+"OfficePostalCode": "L6T0G"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Toronto"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1246437"
+"OriginalEntryTimestamp": null
+"OfficeFax": "905-455-7123"
+"OfficeAORKey": "82"
+"OfficeCountry": "Canada"
+"FranchiseNationalAssociationId": "1183864"
+"OfficeBrokerNationalAssociationId": "1227887"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('74899')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2081088" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24893
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '30032440'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25176
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '30032440' AND OpenHouseDate ge '2026-07-18'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25192
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '30032440' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.543468 43.456288)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25245
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25239
+post_id: "1639781"
+post_author: 1
+"ListingKey": "30052633"
+"ListingId": "X13581052"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-18T21:30:05Z"
+"RFModificationTimestamp": "2026-07-18T21:44:24Z"
+"ListPrice": 399000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L2X1"
+"UnparsedAddress": "111 CHURCHILL STREET, Waterloo, Ontario N2L2X1"
+"Coordinates": array:2 [
0 => -80.5479638
1 => 43.4563421
]
+"Latitude": 43.4563421
+"Longitude": -80.5479638
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "The Oakville, Milton & District Real Estate Board"
+"PublicRemarks": "Investors and parents take note of this great investment opportunity! excellent location! licensed 5 bedroom free hold- no condo fee student rental, walking distance to universities of waterloo and close to university of laurier as well as amenities. Main floor consists of good size eat-in kitchen, spacious living room and 2 bedrooms, walk out to backyard from living room. Upper level features 3 bedrooms with 4pc bathroom, lower level features 3 pcs bathroom, laundry area, storage and entry to the garage. Driveway parking for 2 cars plus 1 in the garage. Easy to rent, this townhouse is vacant and available for immediate purchase. Don't miss the excellent potential gross annual income opportunity of $ 33, 000. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Water Heater"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-18T21:44:14.911911+00:00"
+"Directions": "Cross Streets: keats way/ amos ave. ** Directions: Take University Ave S / King St S: Follow directional signs toward downtown Kitchener to smoothly merge onto King St S / University Ave S.Turn onto Churchill St: Continue until you reach 111 Churchill St."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2211281"
+"ListOfficeKey": "271929"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "24 x 110 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-18T21:24:55Z"
+"PhotosCount": 1
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-18T21:24:55Z"
+"Stories": "2.0"
+"StreetName": "Churchill"
+"StreetNumber": "111"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3891"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [
"RoomKey" => "1688030590"
"RoomType" => "Kitchen"
"ListingId" => "X13581052"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30052633"
"RoomLength" => 3.352
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-18T21:24:55.93Z"
]
1 => array:11 [
"RoomKey" => "1688030591"
"RoomType" => "Living room"
"ListingId" => "X13581052"
"RoomLevel" => "Main level"
"RoomWidth" => 3.352
"ListingKey" => "30052633"
"RoomLength" => 3.048
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-18T21:24:55.93Z"
]
2 => array:11 [
"RoomKey" => "1688030592"
"RoomType" => "Bedroom"
"ListingId" => "X13581052"
"RoomLevel" => "Main level"
"RoomWidth" => 2.438
"ListingKey" => "30052633"
"RoomLength" => 3.657
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-18T21:24:55.93Z"
]
3 => array:11 [
"RoomKey" => "1688030593"
"RoomType" => "Bedroom 2"
"ListingId" => "X13581052"
"RoomLevel" => "Main level"
"RoomWidth" => 2.438
"ListingKey" => "30052633"
"RoomLength" => 3.048
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-18T21:24:55.94Z"
]
4 => array:11 [
"RoomKey" => "1688030594"
"RoomType" => "Bedroom 3"
"ListingId" => "X13581052"
"RoomLevel" => "Second level"
"RoomWidth" => 3.657
"ListingKey" => "30052633"
"RoomLength" => 3.352
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-18T21:24:55.94Z"
]
5 => array:11 [
"RoomKey" => "1688030595"
"RoomType" => "Bedroom 4"
"ListingId" => "X13581052"
"RoomLevel" => "Second level"
"RoomWidth" => 2.743
"ListingKey" => "30052633"
"RoomLength" => 3.048
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-18T21:24:55.94Z"
]
6 => array:11 [
"RoomKey" => "1688030596"
"RoomType" => "Bedroom 5"
"ListingId" => "X13581052"
"RoomLevel" => "Second level"
"RoomWidth" => 3.352
"ListingKey" => "30052633"
"RoomLength" => 3.352
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-18T21:24:55.94Z"
]
]
+"ListAOR": "Oakville-Milton"
+"TaxYear": 2025
+"ListAORKey": "15"
+"ListingURL": "www.realtor.ca/real-estate/30052633/111-churchill-street-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "MD1"
+"BedroomsAboveGrade": 5
+"FrontageLengthNumeric": 24.0
+"OriginalEntryTimestamp": "2026-07-18T21:24:55.91Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1457176"
+"ListOfficeNationalAssociationId": "1282872"
+"Media": array:1 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30052633_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30052633/03b074b7dda6da881d4b200e7efb1bc9.webp"
"MediaSize" => 56450
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30052633/thumbnail-03b074b7dda6da881d4b200e7efb1bc9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13581052"
"ResourceRecordKey" => "30052633"
"ModificationTimestamp" => "2026-07-18T21:24:55.91Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30052633')"
+"ID": "1639781"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25241
+post_id: "1638246"
+post_author: 1
+"ListingKey": "30051129"
+"ListingId": "40848498"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-18T00:25:17Z"
+"RFModificationTimestamp": "2026-07-18T00:46:09Z"
+"ListPrice": 339900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 792.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J0E7"
+"UnparsedAddress": "181 KING Street S Unit# 1002, Waterloo, Ontario N2J0E7"
+"Coordinates": array:2 [
0 => -80.5200051
1 => 43.4605065
]
+"Latitude": 43.4605065
+"Longitude": -80.5200051
+"YearBuilt": 2019
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Elevated Urban Living at Circa 1877 - Welcome to one of Uptown Waterloo's most desirable condominium communities. Situated in the prestigious Bauer District, this beautifully finished 1-bedroom, 1-bathroom suite combines contemporary design, exceptional amenities, and an unbeatable walkable location. The bright open-concept layout is enhanced by floor-to-ceiling windows that fill the space with natural light, while the oversized private terrace provides the perfect place to enjoy your morning coffee or unwind at the end of the day. Inside, you'll find wide-plank flooring, soaring ceilings, quartz countertops, and a stylish 3-piece bathroom designed for modern living. Circa 1877 offers an exceptional collection of resort-inspired amenities, including a rooftop saltwater pool with cabanas, outdoor BBQs and fire tables, yoga studios, a 24/7 fitness centre, co-working lounges, an elegant party room with a wet bar, and guest suites for visiting family and friends. LaLa Social House, located within the building, completes the boutique hotel-style experience. Step outside and enjoy everything Uptown Waterloo has to offer. You're just moments from Vincenzo's, boutique shopping, cafés, restaurants, Grand River Hospital, and scenic walking trails. Both the University of Waterloo and Wilfrid Laurier University are nearby, along with Waterloo's thriving innovation district, home to leading employers including Google, Deloitte, and Sun Life. With the ION LRT right outside the door, commuting throughout Waterloo Region is effortless. Whether you're a first-time buyer, professional, downsizer, or investor, this exceptional home offers the perfect combination of luxury, convenience, and low-maintenance living in one of the region's most sought-after addresses. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Dryer"
4 => "Oven - Built-In"
5 => "Hood Fan"
]
+"AssociationFee": "661"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Landscaping"
1 => "Property Management"
2 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"ConstructionMaterials": array:2 [
0 => "Concrete block"
1 => "Concrete Walls"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-18T00:46:08.071284+00:00"
+"Directions": "Caroline x Allen X King"
+"ExteriorFeatures": array:4 [
0 => "Steel"
1 => "Concrete"
2 => "Brick"
3 => "Metal"
]
+"Heating": array:2 [
0 => "Heat Pump"
1 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1750629"
+"ListOfficeKey": "156288"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "None"
]
+"PhotosChangeTimestamp": "2026-07-18T00:18:17Z"
+"PhotosCount": 12
+"PoolFeatures": array:1 [
0 => "Outdoor pool"
]
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-18T00:18:17Z"
+"Stories": "1.0"
+"StreetDirSuffix": "South"
+"StreetName": "KING"
+"StreetNumber": "181"
+"StreetSuffix": "Street"
+"SubdivisionName": "415 - Uptown Waterloo/Westmount"
+"TaxAnnualAmount": "4357"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:3 [
0 => array:11 [
"RoomKey" => "1687220179"
"RoomType" => "Kitchen"
"ListingId" => "40848498"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30051129"
"RoomLength" => null
"RoomDimensions" => "15'2'' x 20'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T00:18:17.08Z"
]
1 => array:11 [
"RoomKey" => "1687220180"
"RoomType" => "4pc Bathroom"
"ListingId" => "40848498"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30051129"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T00:18:17.08Z"
]
2 => array:11 [
"RoomKey" => "1687220181"
"RoomType" => "Primary Bedroom"
"ListingId" => "40848498"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30051129"
"RoomLength" => null
"RoomDimensions" => "10'3'' x 12'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T00:18:17.08Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30051129/181-king-street-s-unit-1002-waterloo"
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1750669"
+"CommonInterest": "Condo/Strata"
+"CoListAgentKey2": "1750626"
+"CoListOfficeKey": "156288"
+"GeocodeManualYN": true
+"BuildingFeatures": array:3 [
0 => "Exercise Centre"
1 => "Guest Suite"
2 => "Party Room"
]
+"CoListOfficeKey2": "156288"
+"ZoningDescription": "I"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 0.0
+"AboveGradeFinishedArea": 792
+"OriginalEntryTimestamp": "2026-07-18T00:18:17.06Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1066267"
+"ListOfficeNationalAssociationId": "1112493"
+"CoListAgentNationalAssociationId": "1066273"
+"CoListAgentNationalAssociationId2": "1140202"
+"CoListOfficeNationalAssociationId": "1112493"
+"CoListOfficeNationalAssociationId2": "1112493"
+"Media": array:12 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30051129_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30051129/c74abd44035566c475f0e6bd3a402e87.webp"
"MediaSize" => 133513
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30051129/thumbnail-c74abd44035566c475f0e6bd3a402e87.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40848498"
"ResourceRecordKey" => "30051129"
"ModificationTimestamp" => "2026-07-18T00:18:17.06Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30051129_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30051129/3c631527d4c67825e4280f0bdf49cef8.webp"
"MediaSize" => 135563
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30051129/thumbnail-3c631527d4c67825e4280f0bdf49cef8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848498"
"ResourceRecordKey" => "30051129"
"ModificationTimestamp" => "2026-07-18T00:18:17.06Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30051129_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30051129/0c2205ecbfe4ed80f247e377e7dac3b2.webp"
"MediaSize" => 136170
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30051129/thumbnail-0c2205ecbfe4ed80f247e377e7dac3b2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848498"
"ResourceRecordKey" => "30051129"
"ModificationTimestamp" => "2026-07-18T00:18:17.06Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30051129_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30051129/df33f999ae6f05d6c711670421b1a719.webp"
"MediaSize" => 52419
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30051129/thumbnail-df33f999ae6f05d6c711670421b1a719.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848498"
"ResourceRecordKey" => "30051129"
"ModificationTimestamp" => "2026-07-18T00:18:17.06Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30051129_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30051129/d4fcc7fdd9e9de6ab36df0ab1c9c9453.webp"
"MediaSize" => 89849
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30051129/thumbnail-d4fcc7fdd9e9de6ab36df0ab1c9c9453.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848498"
"ResourceRecordKey" => "30051129"
"ModificationTimestamp" => "2026-07-18T00:18:17.06Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30051129_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30051129/bd53696b328c570bb4f88cabcbe6f154.webp"
"MediaSize" => 74612
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30051129/thumbnail-bd53696b328c570bb4f88cabcbe6f154.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848498"
"ResourceRecordKey" => "30051129"
"ModificationTimestamp" => "2026-07-18T00:18:17.06Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30051129_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30051129/05402a5c39e211009c964919beba386f.webp"
"MediaSize" => 115697
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30051129/thumbnail-05402a5c39e211009c964919beba386f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848498"
"ResourceRecordKey" => "30051129"
"ModificationTimestamp" => "2026-07-18T00:18:17.06Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30051129_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30051129/a43699ef4e38985ba2b8e0b59ecda74f.webp"
"MediaSize" => 136267
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30051129/thumbnail-a43699ef4e38985ba2b8e0b59ecda74f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848498"
"ResourceRecordKey" => "30051129"
"ModificationTimestamp" => "2026-07-18T00:18:17.06Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30051129_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30051129/a2d73e14016062a5a2a08b0814fda5ef.webp"
"MediaSize" => 144628
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30051129/thumbnail-a2d73e14016062a5a2a08b0814fda5ef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848498"
"ResourceRecordKey" => "30051129"
"ModificationTimestamp" => "2026-07-18T00:18:17.06Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30051129_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30051129/b867cf4d7ba07f75a0d8f5140df45f01.webp"
"MediaSize" => 147331
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30051129/thumbnail-b867cf4d7ba07f75a0d8f5140df45f01.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848498"
"ResourceRecordKey" => "30051129"
"ModificationTimestamp" => "2026-07-18T00:18:17.06Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30051129_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30051129/739bdd67c8b2548e0692174989b8ac21.webp"
"MediaSize" => 66469
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30051129/thumbnail-739bdd67c8b2548e0692174989b8ac21.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848498"
"ResourceRecordKey" => "30051129"
"ModificationTimestamp" => "2026-07-18T00:18:17.06Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30051129_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30051129/a06df3231cadf3dc3eaa8e55ae9d1047.webp"
"MediaSize" => 55335
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30051129/thumbnail-a06df3231cadf3dc3eaa8e55ae9d1047.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848498"
"ResourceRecordKey" => "30051129"
"ModificationTimestamp" => "2026-07-18T00:18:17.06Z"
]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30051129')"
+"ID": "1638246"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25238
+post_id: "1638247"
+post_author: 1
+"ListingKey": "30051132"
+"ListingId": "X13579662"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-18T00:30:00Z"
+"RFModificationTimestamp": "2026-07-18T00:45:34Z"
+"ListPrice": 339900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J0E7"
+"UnparsedAddress": "1002 - 181 KING STREET S, Waterloo, Ontario N2J0E7"
+"Coordinates": array:2 [
0 => -80.5200073
1 => 43.4605955
]
+"Latitude": 43.4605955
+"Longitude": -80.5200073
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "London and St. Thomas Association of REALTORS®"
+"PublicRemarks": "Elevated Urban Living at Circa 1877 - Welcome to one of Uptown Waterloo's most desirable condominium communities. Situated in the prestigious Bauer District, this beautifully finished 1-bedroom, 1-bathroom suite combines contemporary design, exceptional amenities, and an unbeatable walkable location. The bright open-concept layout is enhanced by floor-to-ceiling windows that fill the space with natural light, while the oversized private terrace provides the perfect place to enjoy your morning coffee or unwind at the end of the day. Inside, you'll find wide-plank flooring, soaring ceilings, quartz countertops, and a stylish 3-piece bathroom designed for modern living. Circa 1877 offers an exceptional collection of resort-inspired amenities, including a rooftop saltwater pool with cabanas, outdoor BBQs and fire tables, yoga studios, a 24/7 fitness centre, co-working lounges, an elegant party room with a wet bar, and guest suites for visiting family and friends. LaLa Social House, located within the building, completes the boutique hotel-style experience. Step outside and enjoy everything Uptown Waterloo has to offer. You're just moments from Vincenzo's, boutique shopping, cafés, restaurants, Grand River Hospital, and scenic walking trails. Both the University of Waterloo and Wilfrid Laurier University are nearby, along with Waterloo's thriving innovation district, home to leading employers including Google, Deloitte, and Sun Life. With the ION LRT right outside the door, commuting throughout Waterloo Region is effortless. Whether you're a first-time buyer, professional, downsizer, or investor, this exceptional home offers the perfect combination of luxury, convenience, and low-maintenance living in one of the region's most sought-after addresses. (id:62650)"
+"Appliances": array:1 [
0 => "Intercom"
]
+"AssociationFee": "661"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-18T00:45:27.038371+00:00"
+"Directions": "Cross Streets: King St S and Allen St W. ** Directions: between Allen St W and George St."
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2241047"
+"ListOfficeKey": "217401"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-18T00:28:14Z"
+"PhotosCount": 10
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-18T00:28:14Z"
+"StreetDirSuffix": "South"
+"StreetName": "King"
+"StreetNumber": "181"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4357"
+"ListAOR": "London and St. Thomas"
+"TaxYear": 2026
+"ListAORKey": "13"
+"ListingURL": "www.realtor.ca/real-estate/30051132/1002-181-king-street-s-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2004386"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "KING CONDO MANAGEMENT"
+"CoListOfficeKey": "217401"
+"GeocodeManualYN": true
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"ZoningDescription": "I"
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2026-07-18T00:20:34.3Z"
+"ListAgentNationalAssociationId": "1479201"
+"ListOfficeNationalAssociationId": "1316773"
+"CoListAgentNationalAssociationId": "1318742"
+"CoListOfficeNationalAssociationId": "1316773"
+"Media": array:10 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30051132_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30051132/fb5f2da9c48747bd0278737755bd6da0.webp"
"MediaSize" => 304200
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30051132/thumbnail-fb5f2da9c48747bd0278737755bd6da0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13579662"
"ResourceRecordKey" => "30051132"
"ModificationTimestamp" => "2026-07-18T00:28:14.78Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30051132_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30051132/776352ee982bbc95fe6ea1ad38b33bd7.webp"
"MediaSize" => 311186
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30051132/thumbnail-776352ee982bbc95fe6ea1ad38b33bd7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13579662"
"ResourceRecordKey" => "30051132"
"ModificationTimestamp" => "2026-07-18T00:28:13.57Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30051132_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30051132/38cdfffc690030a7fa3b95474253b0a0.webp"
"MediaSize" => 307368
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30051132/thumbnail-38cdfffc690030a7fa3b95474253b0a0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13579662"
"ResourceRecordKey" => "30051132"
"ModificationTimestamp" => "2026-07-18T00:28:14.39Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30051132_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30051132/170019943700d188dfa56a11f5dca75f.webp"
"MediaSize" => 133418
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30051132/thumbnail-170019943700d188dfa56a11f5dca75f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13579662"
"ResourceRecordKey" => "30051132"
"ModificationTimestamp" => "2026-07-18T00:28:14.46Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30051132_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30051132/117bdc1fa5a6947cf89503d2eba858ba.webp"
"MediaSize" => 206746
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30051132/thumbnail-117bdc1fa5a6947cf89503d2eba858ba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13579662"
"ResourceRecordKey" => "30051132"
"ModificationTimestamp" => "2026-07-18T00:28:14.4Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30051132_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30051132/e9e6353dd8999a2afa7a33aad920c9c0.webp"
"MediaSize" => 176747
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30051132/thumbnail-e9e6353dd8999a2afa7a33aad920c9c0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13579662"
"ResourceRecordKey" => "30051132"
"ModificationTimestamp" => "2026-07-18T00:28:14.37Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30051132_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30051132/f8c7b47b2e066f2bdf7b863c7dacce38.webp"
"MediaSize" => 263805
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30051132/thumbnail-f8c7b47b2e066f2bdf7b863c7dacce38.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13579662"
"ResourceRecordKey" => "30051132"
"ModificationTimestamp" => "2026-07-18T00:28:14.76Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30051132_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30051132/d72c3568aba5de80895a5968fd738990.webp"
"MediaSize" => 373175
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30051132/thumbnail-d72c3568aba5de80895a5968fd738990.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13579662"
"ResourceRecordKey" => "30051132"
"ModificationTimestamp" => "2026-07-18T00:28:14.72Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30051132_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30051132/e30ff5a8b191181b5f235c9bafcb8423.webp"
"MediaSize" => 151339
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30051132/thumbnail-e30ff5a8b191181b5f235c9bafcb8423.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13579662"
"ResourceRecordKey" => "30051132"
"ModificationTimestamp" => "2026-07-18T00:20:34.3Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30051132_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30051132/3c69bbfaaf91a836edeff6f848dbe893.webp"
"MediaSize" => 125818
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30051132/thumbnail-3c69bbfaaf91a836edeff6f848dbe893.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13579662"
"ResourceRecordKey" => "30051132"
"ModificationTimestamp" => "2026-07-18T00:20:34.3Z"
]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30051132')"
+"ID": "1638247"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25242
+post_id: "1637953"
+post_author: 1
+"ListingKey": "30035551"
+"ListingId": "40848363"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-18T19:25:23Z"
+"RFModificationTimestamp": "2026-07-18T19:28:30Z"
+"ListPrice": 1149900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 4014.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2N2P5"
+"UnparsedAddress": "48 LENNOX Crescent, Kitchener, Ontario N2N2P5"
+"Coordinates": array:2 [
0 => -80.5379175
1 => 43.439713
]
+"Latitude": 43.439713
+"Longitude": -80.5379175
+"YearBuilt": 1986
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 48 Lennox Crescent—where family memories begin. This beautifully maintained executive home offers over 4,000 sq. ft. of finished living space with 5 bedrooms, 4 bathrooms, and a spectacular backyard retreat. Thoughtfully designed for family living, it blends elegance, comfort, and functionality. Step inside to a grand two-storey foyer featuring a stunning staircase, Brazilian cherry hardwood flooring, California ceilings, and crown mouldings. A private office or den off the foyer can also serve as a main floor bedroom. The formal dining room flows into the spacious living room with a cozy gas fireplace and custom wall unit. The bright kitchen features granite countertops, stainless steel appliances, abundant cabinetry, and a sunny dining area overlooking the backyard. Main floor laundry with a separate side entrance and a 2-piece powder room add everyday convenience. Upstairs you'll find four generous bedrooms, including a spacious primary suite with an updated walk-in closet and beautifully renovated spa-inspired ensuite. An updated 4-piece bathroom completes the upper level. The finished basement expands the living space with a large rec room, custom bar, fifth bedroom, and full bathroom—ideal for guests, entertaining, or multi-generational living. Outside, enjoy your private backyard oasis featuring a heated inground pool, expansive deck, brick shed, mature landscaping, and a fully fenced yard with no rear neighbours. Updated exterior brick designed to resemble natural stone, an exposed aggregate driveway, double garage, and extensive updates (see supplements) complete the home. Located in prestigious Beechwood Forest, close to top-rated schools, scenic walking trails, parks, shopping, and all amenities, this exceptional home offers a rare combination of space, quality, privacy, and resort-style outdoor living. A truly special place you'll be proud to call home. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
6 => "Hood Fan"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-17T23:37:35.712387+00:00"
+"Directions": "Fischer Hallman Rd to Stoke Dr to Lennox Cres"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1908292"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-15T21:12:46Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-18T19:18:04Z"
+"Stories": "2.0"
+"StreetName": "LENNOX"
+"StreetNumber": "48"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "338 - Beechwood Forest/Highland W."
+"TaxAnnualAmount": "7128.41"
+"VirtualTourURLUnbranded": "https://youriguide.com/48_lennox_crescent_kitchener_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:21 [
0 => array:11 [
"RoomKey" => "1687921605"
"RoomType" => "Utility room"
"ListingId" => "40848363"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30035551"
"RoomLength" => null
"RoomDimensions" => "8'3'' x 11'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T19:18:04.86Z"
]
1 => array:11 [
"RoomKey" => "1687921606"
"RoomType" => "Storage"
"ListingId" => "40848363"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30035551"
"RoomLength" => null
"RoomDimensions" => "19'5'' x 11'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T19:18:04.86Z"
]
2 => array:11 [
"RoomKey" => "1687921607"
"RoomType" => "Recreation room"
"ListingId" => "40848363"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30035551"
"RoomLength" => null
"RoomDimensions" => "17'2'' x 34'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T19:18:04.86Z"
]
3 => array:11 [
"RoomKey" => "1687921608"
"RoomType" => "Bedroom"
"ListingId" => "40848363"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30035551"
"RoomLength" => null
"RoomDimensions" => "9'6'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T19:18:04.86Z"
]
4 => array:11 [
"RoomKey" => "1687921609"
"RoomType" => "Other"
"ListingId" => "40848363"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30035551"
"RoomLength" => null
"RoomDimensions" => "5'1'' x 10'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T19:18:04.86Z"
]
5 => array:11 [
"RoomKey" => "1687921610"
"RoomType" => "3pc Bathroom"
"ListingId" => "40848363"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30035551"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T19:18:04.86Z"
]
6 => array:11 [
"RoomKey" => "1687921611"
"RoomType" => "Other"
"ListingId" => "40848363"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30035551"
"RoomLength" => null
"RoomDimensions" => "9'8'' x 5'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T19:18:04.86Z"
]
7 => array:11 [
"RoomKey" => "1687921612"
"RoomType" => "Primary Bedroom"
"ListingId" => "40848363"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30035551"
"RoomLength" => null
"RoomDimensions" => "14'6'' x 11'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T19:18:04.86Z"
]
8 => array:11 [
"RoomKey" => "1687921613"
"RoomType" => "Sitting room"
"ListingId" => "40848363"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30035551"
"RoomLength" => null
"RoomDimensions" => "11'2'' x 11'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T19:18:04.86Z"
]
9 => array:11 [
"RoomKey" => "1687921614"
"RoomType" => "Bedroom"
"ListingId" => "40848363"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30035551"
"RoomLength" => null
"RoomDimensions" => "15'2'' x 11'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T19:18:04.86Z"
]
10 => array:11 [
"RoomKey" => "1687921615"
"RoomType" => "Bedroom"
"ListingId" => "40848363"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30035551"
"RoomLength" => null
"RoomDimensions" => "10'11'' x 11'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T19:18:04.86Z"
]
11 => array:11 [
"RoomKey" => "1687921616"
"RoomType" => "Bedroom"
"ListingId" => "40848363"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30035551"
"RoomLength" => null
"RoomDimensions" => "11'8'' x 11'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T19:18:04.86Z"
]
12 => array:11 [
"RoomKey" => "1687921617"
"RoomType" => "Full bathroom"
"ListingId" => "40848363"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30035551"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T19:18:04.86Z"
]
13 => array:11 [
"RoomKey" => "1687921618"
"RoomType" => "4pc Bathroom"
"ListingId" => "40848363"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30035551"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T19:18:04.86Z"
]
14 => array:11 [
"RoomKey" => "1687921619"
"RoomType" => "Office"
"ListingId" => "40848363"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30035551"
"RoomLength" => null
"RoomDimensions" => "13'7'' x 11'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T19:18:04.86Z"
]
15 => array:11 [
"RoomKey" => "1687921620"
"RoomType" => "Living room"
"ListingId" => "40848363"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30035551"
"RoomLength" => null
"RoomDimensions" => "18'3'' x 13'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T19:18:04.87Z"
]
16 => array:11 [
"RoomKey" => "1687921621"
"RoomType" => "Laundry room"
"ListingId" => "40848363"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30035551"
"RoomLength" => null
"RoomDimensions" => "8'8'' x 8'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T19:18:04.87Z"
]
17 => array:11 [
"RoomKey" => "1687921622"
"RoomType" => "Kitchen"
"ListingId" => "40848363"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30035551"
"RoomLength" => null
"RoomDimensions" => "9'5'' x 12'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T19:18:04.87Z"
]
18 => array:11 [
"RoomKey" => "1687921623"
"RoomType" => "Dining room"
"ListingId" => "40848363"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30035551"
"RoomLength" => null
"RoomDimensions" => "19'11'' x 11'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T19:18:04.87Z"
]
19 => array:11 [
"RoomKey" => "1687921624"
"RoomType" => "Breakfast"
"ListingId" => "40848363"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30035551"
"RoomLength" => null
"RoomDimensions" => "15'4'' x 11'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T19:18:04.87Z"
]
20 => array:11 [
"RoomKey" => "1687921625"
"RoomType" => "2pc Bathroom"
"ListingId" => "40848363"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30035551"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T19:18:04.87Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30035551/48-lennox-crescent-kitchener"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "RES-2"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 50.0
+"AboveGradeFinishedArea": 2641
+"BelowGradeFinishedArea": 1373
+"OriginalEntryTimestamp": "2026-07-15T14:48:27.1Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1221205"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:50 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30035551_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035551/e1954001a12b2661ff5274f5adeb215e.webp"
"MediaSize" => 120294
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035551/thumbnail-e1954001a12b2661ff5274f5adeb215e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40848363"
"ResourceRecordKey" => "30035551"
"ModificationTimestamp" => "2026-07-15T21:12:43.94Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30035551_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035551/029660eae724990aeef16a6abc142266.webp"
"MediaSize" => 160583
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035551/thumbnail-029660eae724990aeef16a6abc142266.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848363"
"ResourceRecordKey" => "30035551"
"ModificationTimestamp" => "2026-07-15T21:12:42.58Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30035551_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035551/e1efe62092649170d2e25b407a89f4db.webp"
"MediaSize" => 159757
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035551/thumbnail-e1efe62092649170d2e25b407a89f4db.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848363"
"ResourceRecordKey" => "30035551"
"ModificationTimestamp" => "2026-07-15T21:12:41.39Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30035551_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035551/8758e1dcf4751cb8b24491ff3b2330ad.webp"
"MediaSize" => 186548
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035551/thumbnail-8758e1dcf4751cb8b24491ff3b2330ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848363"
"ResourceRecordKey" => "30035551"
"ModificationTimestamp" => "2026-07-15T21:12:41.48Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30035551_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035551/7b044e3dac450f5debbefad3785b5b52.webp"
"MediaSize" => 69074
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035551/thumbnail-7b044e3dac450f5debbefad3785b5b52.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848363"
"ResourceRecordKey" => "30035551"
"ModificationTimestamp" => "2026-07-15T21:12:41.14Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30035551_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035551/fca12880d61ade243bc68b20ba764049.webp"
"MediaSize" => 104942
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035551/thumbnail-fca12880d61ade243bc68b20ba764049.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848363"
"ResourceRecordKey" => "30035551"
"ModificationTimestamp" => "2026-07-15T21:12:42.58Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30035551_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035551/14f39835ec1628414e02a4a7383968df.webp"
"MediaSize" => 84439
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035551/thumbnail-14f39835ec1628414e02a4a7383968df.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848363"
"ResourceRecordKey" => "30035551"
"ModificationTimestamp" => "2026-07-15T21:12:42.58Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30035551_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035551/b99e8bf82307c86133e34c0697ae8f92.webp"
"MediaSize" => 117627
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035551/thumbnail-b99e8bf82307c86133e34c0697ae8f92.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848363"
"ResourceRecordKey" => "30035551"
"ModificationTimestamp" => "2026-07-15T21:12:44Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30035551_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035551/a17c6e6c5b8598f167fa04b18e3338c9.webp"
"MediaSize" => 93372
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035551/thumbnail-a17c6e6c5b8598f167fa04b18e3338c9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "office room virtually staged as a bedroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848363"
"ResourceRecordKey" => "30035551"
"ModificationTimestamp" => "2026-07-15T21:12:43Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30035551_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035551/587a70ebaf8cd8973e38f95938d96ea0.webp"
"MediaSize" => 111397
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035551/thumbnail-587a70ebaf8cd8973e38f95938d96ea0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848363"
"ResourceRecordKey" => "30035551"
"ModificationTimestamp" => "2026-07-15T21:12:42.97Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30035551_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035551/e13af910096fc2ce1e38174531e1cf94.webp"
"MediaSize" => 152225
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035551/thumbnail-e13af910096fc2ce1e38174531e1cf94.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848363"
"ResourceRecordKey" => "30035551"
"ModificationTimestamp" => "2026-07-15T21:12:42.58Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30035551_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035551/813a57fd69ea3ab1dc3a3ff1d948d8eb.webp"
"MediaSize" => 128379
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035551/thumbnail-813a57fd69ea3ab1dc3a3ff1d948d8eb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848363"
"ResourceRecordKey" => "30035551"
"ModificationTimestamp" => "2026-07-15T21:12:42.58Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30035551_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035551/c115a1cf0cc346d68f9d12210db1e135.webp"
"MediaSize" => 120387
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035551/thumbnail-c115a1cf0cc346d68f9d12210db1e135.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848363"
"ResourceRecordKey" => "30035551"
"ModificationTimestamp" => "2026-07-15T21:12:41.4Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30035551_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035551/4a3776d9feafa2301f0c94f968126b72.webp"
"MediaSize" => 110425
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035551/thumbnail-4a3776d9feafa2301f0c94f968126b72.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848363"
"ResourceRecordKey" => "30035551"
"ModificationTimestamp" => "2026-07-15T21:12:42.43Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30035551_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035551/b245cf26da8071065a3ef404f60b5508.webp"
"MediaSize" => 103814
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035551/thumbnail-b245cf26da8071065a3ef404f60b5508.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848363"
"ResourceRecordKey" => "30035551"
"ModificationTimestamp" => "2026-07-15T21:12:41.4Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30035551_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035551/2e68384f58f1fd4df9cae63c4eefadb4.webp"
"MediaSize" => 81921
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035551/thumbnail-2e68384f58f1fd4df9cae63c4eefadb4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848363"
"ResourceRecordKey" => "30035551"
"ModificationTimestamp" => "2026-07-15T21:12:41.48Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30035551_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035551/5be93976be0ac258e1dfc153523fac55.webp"
"MediaSize" => 89971
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035551/thumbnail-5be93976be0ac258e1dfc153523fac55.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848363"
"ResourceRecordKey" => "30035551"
"ModificationTimestamp" => "2026-07-15T21:12:42.58Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30035551_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035551/e35a12502a56d9443a1eb07a5ea1ed63.webp"
"MediaSize" => 110639
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035551/thumbnail-e35a12502a56d9443a1eb07a5ea1ed63.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848363"
"ResourceRecordKey" => "30035551"
"ModificationTimestamp" => "2026-07-15T21:12:41.48Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30035551_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035551/8729785b511333a74c97e9bdc22e171f.webp"
"MediaSize" => 84485
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035551/thumbnail-8729785b511333a74c97e9bdc22e171f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848363"
"ResourceRecordKey" => "30035551"
"ModificationTimestamp" => "2026-07-15T21:12:42.43Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30035551_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035551/a04f164a2a533a85ebb4d886603a3c58.webp"
"MediaSize" => 113365
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035551/thumbnail-a04f164a2a533a85ebb4d886603a3c58.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848363"
"ResourceRecordKey" => "30035551"
"ModificationTimestamp" => "2026-07-15T21:12:42.43Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30035551_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035551/19d303cfd090978dc1f2c9204f3deb52.webp"
"MediaSize" => 98237
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035551/thumbnail-19d303cfd090978dc1f2c9204f3deb52.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848363"
"ResourceRecordKey" => "30035551"
"ModificationTimestamp" => "2026-07-15T21:12:43.95Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30035551_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035551/70b6c26256eae779107fdc1f1055bbda.webp"
"MediaSize" => 84992
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035551/thumbnail-70b6c26256eae779107fdc1f1055bbda.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848363"
"ResourceRecordKey" => "30035551"
"ModificationTimestamp" => "2026-07-15T21:12:41.14Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "30035551_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30035551/eb0d1dfc8ee81d5098ddaad3142b0d05.webp"
"MediaSize" => 95713
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30035551/thumbnail-eb0d1dfc8ee81d5098ddaad3142b0d05.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
…5
]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30035551')"
+"ID": "1637953"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25240
+post_id: "1637099"
+post_author: 1
+"ListingKey": "30038060"
+"ListingId": "40848404"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-18T12:20:00Z"
+"RFModificationTimestamp": "2026-07-18T12:23:26Z"
+"ListPrice": 1149900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.272
+"LivingArea": 2866.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5A5"
+"UnparsedAddress": "337 MARLOWE Drive, Waterloo, Ontario N2L5A5"
+"Coordinates": array:2 [
0 => -80.5513334
1 => 43.4621325
]
+"Latitude": 43.4621325
+"Longitude": -80.5513334
+"YearBuilt": 1973
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This is the Beechwood home you’ve been waiting for. Tucked beneath mature trees & set on an exceptional 78’ x 181’ lot spanning more than 1/4 acre, this distinctive 3-bed, 3-bath home offers 2,800+ SF of finished living space, a landscaped private backyard, inground pool W/ waterfall & finished walkout lower level in one of Waterloo’s most established neighbourhoods. The main flr features two gathering areas. The living rm has a vaulted wood-clad ceiling, expansive windows, built-in shelving & full-height stone gas fireplace, while the family rm offers a wood-burning fireplace & direct access to the deck & backyard. The updated custom kitchen features white cabinetry, quartz counters, stainless appliances, subway-tile backsplash, skylights & ample workspace & storage. The adjoining breakfast rm features custom pantry cabinetry, a quartz-topped serving station, open wood shelving & another walkout to the deck, while the separate dining rm offers ample space for hosting. Upstairs are 3 well-sized beds & 2 full baths, including a spacious primary W/ excellent closet space & private 3-pc ensuite, plus a 4-pc main bath. The finished walkout lower level adds a lrg rec rm, sauna, separate shower ideal for the pool, laundry/utility rm & storage. Surrounded by mature trees & lush perennial gardens, the backyard feels exceptionally private & peaceful. An expansive deck offers plenty of rm for outdoor dining & lounging, while stone pathways lead to the inground pool, waterfall & stone terrace. Multiple walkouts create an easy indoor-outdoor connection. Located on a quiet street, steps from Clair Lake, trails, parks & schools, & close to Uptown Waterloo, both universities, shopping, restaurants & major employers. Residents also enjoy access to Beechwood Park Homes Association amenities & the strong sense of community Beechwood is known for. A rare opportunity to own a private poolside family home on an extraordinary mature lot in one of Waterloo’s most desirable neighbourhoods. (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Sauna"
4 => "Central Vacuum"
5 => "Dishwasher"
6 => "Stove"
7 => "Dryer"
8 => "Window Coverings"
9 => "Garage door opener"
10 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"ConstructionMaterials": array:1 [
0 => "Wood frame"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-17T20:40:23.159836+00:00"
+"Directions": "KEATS WAY TO AMOS AVENUE, THEN MARLOWE DRIVE"
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Brick"
]
+"FireplaceFeatures": array:2 [
0 => "Wood"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1932106"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Southern exposure"
1 => "Conservation/green belt"
2 => "Paved driveway"
3 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.272"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-18T12:11:21Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-18T12:11:21Z"
+"Stories": "2.0"
+"StreetName": "MARLOWE"
+"StreetNumber": "337"
+"StreetSuffix": "Drive"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "7061.04"
+"VirtualTourURLUnbranded": "https://youriguide.com/337_marlowe_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30038060/337-marlowe-drive-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1975048"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "76789"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 78.0
+"AboveGradeFinishedArea": 2064
+"BelowGradeFinishedArea": 802
+"OriginalEntryTimestamp": "2026-07-15T19:48:18.36Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1232419"
+"ListOfficeNationalAssociationId": "1384313"
+"CoListAgentNationalAssociationId": "1261853"
+"CoListOfficeNationalAssociationId": "1004357"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30038060')"
+"ID": "1637099"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25235
+post_id: "1637100"
+post_author: 1
+"ListingKey": "30039981"
+"ListingId": "40848617"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T21:20:02Z"
+"RFModificationTimestamp": "2026-07-17T21:40:08Z"
+"ListPrice": 649900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1435.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T1K2"
+"UnparsedAddress": "584 WESTVALE Drive, Waterloo, Ontario N2T1K2"
+"Coordinates": array:2 [
0 => -80.5500108
1 => 43.446597
]
+"Latitude": 43.446597
+"Longitude": -80.5500108
+"YearBuilt": 1986
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully updated raised bungalow in family-friendly Westvale, one of the area's most popular neighbourhoods. Step inside to a bright, modern open-concept main floor designed for everyday living, offering three bedrooms and two full bathrooms. The spacious kitchen features a generous island that flows seamlessly into the dining and living areas, creating the perfect gathering space for family and friends. Sliding doors off the dining area lead to a large private deck, complete with a hot tub (2022) and plenty of room for outdoor dining, relaxing, and entertaining. The lower level offers a bright, spacious rec room with a cozy gas stove, second full bath plus a huge bonus space, perfect for your home gym, crafts or even another bedroom or two. The backyard is a private retreat, featuring mature trees, a fully fenced yard with a large shed and a side gate providing convenient access for your trailer or maintenance. Thoughtfully maintained and move-in ready, this home has seen numerous recent updates, including windows (2022), shingles (2021) and furnace (2021), offering peace of mind for years to come. Located in a highly sought-after neighbourhood, you'll be just minutes from parks, schools, scenic walking trails, public transit, The Boardwalk shopping, Costco, and a wide variety of amenities. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Hot Tub"
4 => "Dishwasher"
5 => "Dryer"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-17T20:38:01.536897+00:00"
+"Directions": "Fischer Hallman to Thorndale Drive, to Westvale Drive"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2049459"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Sump Pump"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-17T21:11:25Z"
+"PhotosCount": 45
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T21:11:25Z"
+"Stories": "1.0"
+"StreetName": "WESTVALE"
+"StreetNumber": "584"
+"StreetSuffix": "Drive"
+"SubdivisionName": "439 - Westvale"
+"TaxAnnualAmount": "4468.65"
+"VirtualTourURLUnbranded": "https://youriguide.com/584_westvale_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30039981/584-westvale-drive-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SR1A"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 62.0
+"AboveGradeFinishedArea": 1134
+"BelowGradeFinishedArea": 301
+"OriginalEntryTimestamp": "2026-07-16T01:48:15.45Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1324839"
+"ListOfficeNationalAssociationId": "1384313"
+"Media": array:45 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30039981')"
+"ID": "1637100"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23486
+post_id: "1635644"
+post_author: 1
+"ListingKey": "30047262"
+"ListingId": "40849067"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T14:55:22Z"
+"RFModificationTimestamp": "2026-07-17T17:13:28Z"
+"ListPrice": 399999.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1160.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2M5B5"
+"UnparsedAddress": "423 WESTWOOD Drive Unit# 43, Kitchener, Ontario N2M5B5"
+"Coordinates": array:2 [
0 => -80.5405456
1 => 43.4427505
]
+"Latitude": 43.4427505
+"Longitude": -80.5405456
+"YearBuilt": 1973
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully maintained condo townhouse located in Kitchener’s desirable Westwood neighbourhood. Surrounded by mature trees and quiet streets, this home offers a wonderful blend of space, comfort, and low-maintenance living. Step inside to a bright and inviting main floor featuring a spacious living area that’s perfect for both everyday living and entertaining. The eat-in kitchen offers ample cabinetry and workspace, creating a practical and welcoming hub for family meals and gatherings. A convenient 2pc powder room completes the main level. Upstairs, you’ll find well-sized bedrooms and a full bathroom. The finished lower level adds valuable flexibility with additional living space ideal for a family room, home office, or recreation area. This level also features a three-piece bathroom, laundry area, and extra storage. Enjoy the benefits of easy condo living, where exterior maintenance is taken care of, while still having your own private outdoor space to relax and unwind. Residents also enjoy access to an in-ground pool and playground, making this a great community for families and those who appreciate outdoor amenities. The location is exceptional — just minutes to The Boardwalk shopping district, parks, schools, public transit, and both universities. Commuters and investors alike will appreciate the convenience and strong rental appeal of this area. Whether you’re a first-time buyer, downsizer, or investor, Unit #43 offers outstanding value and an opportunity to own in a well-established community. Recent Updates include: Central Air (2024), Basement Finished (2023), Kitchen and Bathroom updates (2021). Condo fees include: water, 1 parking spot, pool maintenance, landscaping, snow removal, and general insurance (owners need to get their own content insurance). Pool is open May-October. 2nd parking spot is by waitlist with a monthly rental of approximately $40/month. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
]
+"AssociationFee": "611.98"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Landscaping"
1 => "Water"
2 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-17T17:13:21.383471+00:00"
+"Directions": "Glasgow St. to Westwood Dr."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2067711"
+"ListOfficeKey": "286933"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Southern exposure"
]
+"ParkingFeatures": array:2 [
0 => "Open"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-07-17T14:48:25Z"
+"PhotosCount": 41
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T14:48:25Z"
+"Stories": "2.0"
+"StreetName": "WESTWOOD"
+"StreetNumber": "423"
+"StreetSuffix": "Drive"
+"SubdivisionName": "415 - Uptown Waterloo/Westmount"
+"TaxAnnualAmount": "2333.95"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30047262/423-westwood-drive-unit-43-kitchener"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1564408"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "286933"
+"GeocodeManualYN": true
+"ZoningDescription": "R2B"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1160
+"OriginalEntryTimestamp": "2026-07-17T14:48:25.12Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1342782"
+"ListOfficeNationalAssociationId": "1364894"
+"CoListAgentNationalAssociationId": "1129302"
+"CoListOfficeNationalAssociationId": "1364894"
+"Media": array:41 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30047262')"
+"ID": "1635644"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25243
+post_id: "1634495"
+post_author: 1
+"ListingKey": "30046352"
+"ListingId": "40849006"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T15:20:06Z"
+"RFModificationTimestamp": "2026-07-17T15:22:50Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1358.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T1G3"
+"UnparsedAddress": "543 DRUMMERHILL Crescent, Waterloo, Ontario N2T1G3"
+"Coordinates": array:2 [
0 => -80.553139
1 => 43.4461149
]
+"Latitude": 43.4461149
+"Longitude": -80.553139
+"YearBuilt": 1985
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Great Location! Welcome to this beautiful detached home in the highly sought-after Westvale neighbourhood. Situated on a quiet, family-friendly crescent, this carpet-free home is conveniently located near top-rated schools, shopping, parks, trails, transit, and just minutes from Uptown Waterloo, the University of Waterloo, Costco, Walmart, medical centres, restaurants, and highway access. This well-maintained single-family home features 3 bedrooms, 2 bathrooms, a single-car garage, parking for three vehicles, and a finished recreation room. The bright main floor offers hardwood flooring, a 2-piece powder room, direct garage access, and sliding doors leading to a fully fenced backyard with a spacious deck—perfect for family gatherings and outdoor entertaining. Upstairs, you'll find three generous bedrooms and a beautifully renovated bathroom. The basement is nearly complete, featuring a finished rec room and a framed 3-piece bathroom rough-in, offering excellent potential for additional living space. Move-in ready and located in one of Waterloo's most desirable family communities, this is a fantastic opportunity you won't want to miss! (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
7 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-17T13:55:25.143676+00:00"
+"Directions": "Fischer-Hallman to Thorndale, left onto Westvale, right onto Drummerhill Crescent"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1955745"
+"ListOfficeKey": "295659"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Sump Pump"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-17T15:13:22Z"
+"PhotosCount": 34
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T15:18:20Z"
+"Stories": "2.0"
+"StreetName": "DRUMMERHILL"
+"StreetNumber": "543"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "439 - Westvale"
+"TaxAnnualAmount": "3852.78"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30046352/543-drummerhill-crescent-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "SD-1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 28.0
+"AboveGradeFinishedArea": 1108
+"BelowGradeFinishedArea": 250
+"OriginalEntryTimestamp": "2026-07-17T11:49:29.53Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1247419"
+"ListOfficeNationalAssociationId": "1452740"
+"Media": array:34 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30046352')"
+"ID": "1634495"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25244
+post_id: "1634560"
+post_author: 1
+"ListingKey": "30046391"
+"ListingId": "40841569"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-19T01:10:00Z"
+"RFModificationTimestamp": "2026-07-19T01:19:13Z"
+"ListPrice": 799000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 2
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.2
+"LivingArea": 2059.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L2L4"
+"UnparsedAddress": "97 WESTMOUNT Road S, Waterloo, Ontario N2L2L4"
+"Coordinates": array:2 [
0 => -80.5293259
1 => 43.4552615
]
+"Latitude": 43.4552615
+"Longitude": -80.5293259
+"YearBuilt": 1958
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Nestled in one of Waterloo's most sought-after neighbourhoods and backing onto Peter Roos Park, this lovingly maintained side-split offers the perfect blend of comfort, character, and location. Situated on a prominent corner lot at Westmount Road South and Stanley Drive, this home boasts exceptional curb appeal, a spacious double-car garage, and endless potential for growing families, renovators, or investors. Step inside to a bright and welcoming formal living room featuring a beautiful wood-burning fireplace, a separate formal dining room perfect for entertaining, and a renovated kitchen with convenient access to the back deck for effortless indoor-outdoor living. The inviting family room provides the ideal space to relax, complete with a cozy gas heating stove and walkout to a covered patio overlooking the private backyard. The upper level features generously sized bedrooms with hardwood flooring, while hardwood also lies beneath the hallway carpet. Large windows throughout fill the home with natural light, creating a warm and inviting atmosphere, while the mature lot offers privacy and timeless appeal. Ideally located close to excellent schools, parks, shopping, public transit, both universities, and vibrant Uptown Waterloo, this is a rare opportunity to own a quality home in an established neighbourhood renowned for its convenience, strong sense of community, and enduring value. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 2
+"ConstructionMaterials": array:1 [
0 => "Wood frame"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-07-17T13:51:30.645808+00:00"
+"Directions": "Corner of Stanley and Westmount Rd S, behind Peter Boos Park"
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Brick Veneer"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:1 [
0 => "Hot water radiator heat"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564567"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Corner Site"
1 => "Paved driveway"
2 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.2"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-19T01:01:04Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-19T01:01:04Z"
+"Stories": "3.0"
+"StreetDirSuffix": "South"
+"StreetName": "WESTMOUNT"
+"StreetNumber": "97"
+"StreetSuffix": "Road"
+"SubdivisionName": "415 - Uptown Waterloo/Westmount"
+"TaxAnnualAmount": "5494"
+"VirtualTourURLUnbranded": "https://youriguide.com/97_westmount_road_south_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30046391/97-westmount-road-s-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SR3"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 80.0
+"AboveGradeFinishedArea": 2059
+"OriginalEntryTimestamp": "2026-07-17T11:59:05.28Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Measurement follows RMS"
+"ListAgentNationalAssociationId": "1069579"
+"ListOfficeNationalAssociationId": "1384313"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30046391')"
+"ID": "1634560"
}
]
+success: true
+page_size: 9
+page_count: 19
+count: 169
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]