array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 30052633 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: "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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30052633')"
+"ID": "1639781"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.31 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 271929" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24913
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24821
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "Century 21 People's Choice Realty Inc., Brokerage"
+"OfficeEmail": null
+"OfficePhone": "416-742-8000"
+"OfficeMlsId": "530800"
+"ModificationTimestamp": "2025-01-12T14:03:26Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "271929"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "1780 ALBION RD - UNIT 2A"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "TORONTO"
+"OfficePostalCode": "M9V1C"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Oakville-Milton"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1282872"
+"OriginalEntryTimestamp": "2012-10-09T22:02:00Z"
+"OfficeFax": "416-742-8101"
+"OfficeAORKey": "15"
+"FranchiseNationalAssociationId": "1205554"
+"OfficeBrokerNationalAssociationId": "1282666"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('271929')"
}
]
+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 2211281" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24894
+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 '30052633'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25177
+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 '30052633' AND OpenHouseDate ge '2026-07-18'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25193
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '30052633' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5479638 43.4563421)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25246
+items: array:9 [
0 => 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 [
"RoomKey" => "1686993478"
"RoomType" => "Utility room"
"ListingId" => "40848404"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30038060"
"RoomLength" => null
"RoomDimensions" => "16'0'' x 10'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:21.75Z"
]
1 => array:11 [
"RoomKey" => "1686993479"
"RoomType" => "Recreation room"
"ListingId" => "40848404"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30038060"
"RoomLength" => null
"RoomDimensions" => "16'8'' x 16'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:21.75Z"
]
2 => array:11 [
"RoomKey" => "1686993480"
"RoomType" => "1pc Bathroom"
"ListingId" => "40848404"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30038060"
"RoomLength" => null
"RoomDimensions" => "4'1'' x 3'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:21.75Z"
]
3 => array:11 [
"RoomKey" => "1686993481"
"RoomType" => "Primary Bedroom"
"ListingId" => "40848404"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30038060"
"RoomLength" => null
"RoomDimensions" => "16'4'' x 11'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:21.75Z"
]
4 => array:11 [
"RoomKey" => "1686993482"
"RoomType" => "Bedroom"
"ListingId" => "40848404"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30038060"
"RoomLength" => null
"RoomDimensions" => "10'11'' x 14'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:21.75Z"
]
5 => array:11 [
"RoomKey" => "1686993483"
"RoomType" => "Bedroom"
"ListingId" => "40848404"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30038060"
"RoomLength" => null
"RoomDimensions" => "14'10'' x 8'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:21.75Z"
]
6 => array:11 [
"RoomKey" => "1686993484"
"RoomType" => "4pc Bathroom"
"ListingId" => "40848404"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30038060"
"RoomLength" => null
"RoomDimensions" => "7'8'' x 4'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:21.75Z"
]
7 => array:11 [
"RoomKey" => "1686993485"
"RoomType" => "Full bathroom"
"ListingId" => "40848404"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30038060"
"RoomLength" => null
"RoomDimensions" => "7'8'' x 5'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:21.75Z"
]
8 => array:11 [
"RoomKey" => "1686993486"
"RoomType" => "Living room"
"ListingId" => "40848404"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30038060"
"RoomLength" => null
"RoomDimensions" => "19'0'' x 12'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:21.75Z"
]
9 => array:11 [
"RoomKey" => "1686993487"
"RoomType" => "Kitchen"
"ListingId" => "40848404"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30038060"
"RoomLength" => null
"RoomDimensions" => "14'5'' x 11'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:21.76Z"
]
10 => array:11 [
"RoomKey" => "1686993488"
"RoomType" => "Foyer"
"ListingId" => "40848404"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30038060"
"RoomLength" => null
"RoomDimensions" => "10'1'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:21.76Z"
]
11 => array:11 [
"RoomKey" => "1686993489"
"RoomType" => "Family room"
"ListingId" => "40848404"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30038060"
"RoomLength" => null
"RoomDimensions" => "14'0'' x 17'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:21.76Z"
]
12 => array:11 [
"RoomKey" => "1686993490"
"RoomType" => "Dining room"
"ListingId" => "40848404"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30038060"
"RoomLength" => null
"RoomDimensions" => "12'2'' x 13'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:21.76Z"
]
13 => array:11 [
"RoomKey" => "1686993491"
"RoomType" => "Breakfast"
"ListingId" => "40848404"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30038060"
"RoomLength" => null
"RoomDimensions" => "9'2'' x 11'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:21.76Z"
]
14 => array:11 [
"RoomKey" => "1686993492"
"RoomType" => "2pc Bathroom"
"ListingId" => "40848404"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30038060"
"RoomLength" => null
"RoomDimensions" => "8'1'' x 2'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:21.76Z"
]
]
+"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 [
"Order" => 1
"MediaKey" => "30038060_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038060/618bbb0af1be3774dff48e063ca9c9c6.webp"
"MediaSize" => 175223
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038060/thumbnail-618bbb0af1be3774dff48e063ca9c9c6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40848404"
"ResourceRecordKey" => "30038060"
"ModificationTimestamp" => "2026-07-16T20:03:27.97Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30038060_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038060/223945ca4d53041b9ce07faed42f12ab.webp"
"MediaSize" => 143628
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038060/thumbnail-223945ca4d53041b9ce07faed42f12ab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848404"
"ResourceRecordKey" => "30038060"
"ModificationTimestamp" => "2026-07-16T20:03:27.51Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30038060_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038060/1a5fae4e3eb1de675139155d15c690dc.webp"
"MediaSize" => 217730
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038060/thumbnail-1a5fae4e3eb1de675139155d15c690dc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848404"
"ResourceRecordKey" => "30038060"
"ModificationTimestamp" => "2026-07-16T20:03:26.56Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30038060_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038060/1f2cd87deea2f25589044aeab06f643c.webp"
"MediaSize" => 242437
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038060/thumbnail-1f2cd87deea2f25589044aeab06f643c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848404"
"ResourceRecordKey" => "30038060"
"ModificationTimestamp" => "2026-07-16T20:03:26.5Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30038060_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038060/afe5ac262732b3ec734e8892c732aebc.webp"
"MediaSize" => 183678
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038060/thumbnail-afe5ac262732b3ec734e8892c732aebc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848404"
"ResourceRecordKey" => "30038060"
"ModificationTimestamp" => "2026-07-16T20:03:27.47Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30038060_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038060/409922feeacebfb7753eda817b91ab95.webp"
"MediaSize" => 121583
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038060/thumbnail-409922feeacebfb7753eda817b91ab95.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848404"
"ResourceRecordKey" => "30038060"
"ModificationTimestamp" => "2026-07-16T20:03:26.5Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30038060_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038060/b092faf8494ac091e6d03e6970c0553e.webp"
"MediaSize" => 78175
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038060/thumbnail-b092faf8494ac091e6d03e6970c0553e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848404"
"ResourceRecordKey" => "30038060"
"ModificationTimestamp" => "2026-07-16T20:03:26.6Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30038060_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038060/8bcf68d98070a8139dbbf90ac08e271f.webp"
"MediaSize" => 105082
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038060/thumbnail-8bcf68d98070a8139dbbf90ac08e271f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848404"
"ResourceRecordKey" => "30038060"
"ModificationTimestamp" => "2026-07-16T20:03:27.46Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30038060_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038060/396f60b5ea530a81e224a95fef0e0ec1.webp"
"MediaSize" => 104543
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038060/thumbnail-396f60b5ea530a81e224a95fef0e0ec1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848404"
"ResourceRecordKey" => "30038060"
"ModificationTimestamp" => "2026-07-16T20:03:26.5Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30038060_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038060/aeb482785667dc92e1fa9bcb1a6309ed.webp"
"MediaSize" => 99801
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038060/thumbnail-aeb482785667dc92e1fa9bcb1a6309ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848404"
"ResourceRecordKey" => "30038060"
"ModificationTimestamp" => "2026-07-16T20:03:26.5Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30038060_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038060/73d6ddfb8c543b23cb8e4ad6bdbc68b9.webp"
"MediaSize" => 102489
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038060/thumbnail-73d6ddfb8c543b23cb8e4ad6bdbc68b9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848404"
"ResourceRecordKey" => "30038060"
"ModificationTimestamp" => "2026-07-16T20:03:26.5Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30038060_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038060/90a260c4db8bd179efa97846f68b7c8b.webp"
"MediaSize" => 114573
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038060/thumbnail-90a260c4db8bd179efa97846f68b7c8b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848404"
"ResourceRecordKey" => "30038060"
"ModificationTimestamp" => "2026-07-16T20:03:27.47Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30038060_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038060/b3196842650795fd609faeb88808dc2d.webp"
"MediaSize" => 87089
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038060/thumbnail-b3196842650795fd609faeb88808dc2d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848404"
"ResourceRecordKey" => "30038060"
"ModificationTimestamp" => "2026-07-16T20:03:27.47Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30038060_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038060/88ad20355fd0758d00ee189237fa2ea1.webp"
"MediaSize" => 72343
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038060/thumbnail-88ad20355fd0758d00ee189237fa2ea1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848404"
"ResourceRecordKey" => "30038060"
"ModificationTimestamp" => "2026-07-16T20:03:27.47Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30038060_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038060/95cd7ba53dd986c66fb177a737b89936.webp"
"MediaSize" => 79126
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038060/thumbnail-95cd7ba53dd986c66fb177a737b89936.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848404"
"ResourceRecordKey" => "30038060"
"ModificationTimestamp" => "2026-07-16T20:03:27.47Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30038060_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038060/541f82e571f805bfd4b2fb8e9af123a4.webp"
"MediaSize" => 94542
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038060/thumbnail-541f82e571f805bfd4b2fb8e9af123a4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848404"
"ResourceRecordKey" => "30038060"
"ModificationTimestamp" => "2026-07-16T20:03:27.44Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30038060_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038060/0e1cf3844a01869a938a2b0f4d4ce044.webp"
"MediaSize" => 88934
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038060/thumbnail-0e1cf3844a01869a938a2b0f4d4ce044.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848404"
"ResourceRecordKey" => "30038060"
"ModificationTimestamp" => "2026-07-16T20:03:27.47Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30038060_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038060/4f9c87ff7037dd0f9e1a6ef157b9eed2.webp"
"MediaSize" => 69557
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038060/thumbnail-4f9c87ff7037dd0f9e1a6ef157b9eed2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848404"
"ResourceRecordKey" => "30038060"
"ModificationTimestamp" => "2026-07-16T20:03:27.44Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30038060_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038060/9d463a2bdd36f2a2480cb349ca9ae1a4.webp"
"MediaSize" => 86806
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038060/thumbnail-9d463a2bdd36f2a2480cb349ca9ae1a4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848404"
"ResourceRecordKey" => "30038060"
"ModificationTimestamp" => "2026-07-16T20:03:27.44Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30038060_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038060/2ac3cf8071a527f86a0d82a3912686e5.webp"
"MediaSize" => 87080
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038060/thumbnail-2ac3cf8071a527f86a0d82a3912686e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848404"
"ResourceRecordKey" => "30038060"
"ModificationTimestamp" => "2026-07-16T20:03:27.44Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30038060_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038060/be0bd75aa5c2e2707113f17f83e6994e.webp"
"MediaSize" => 57643
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038060/thumbnail-be0bd75aa5c2e2707113f17f83e6994e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848404"
"ResourceRecordKey" => "30038060"
"ModificationTimestamp" => "2026-07-16T20:03:27.44Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30038060_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038060/425dcd72490c52dc689a1673b96dec10.webp"
"MediaSize" => 76357
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038060/thumbnail-425dcd72490c52dc689a1673b96dec10.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848404"
"ResourceRecordKey" => "30038060"
"ModificationTimestamp" => "2026-07-16T20:03:27.44Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "30038060_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038060/990463d67b243e4d3d7b8260e1c4912a.webp"
"MediaSize" => 70245
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038060/thumbnail-990463d67b243e4d3d7b8260e1c4912a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848404"
"ResourceRecordKey" => "30038060"
"ModificationTimestamp" => "2026-07-16T20:03:27.46Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "30038060_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038060/0819a5e25bfb1814d26eddeb179202a3.webp"
"MediaSize" => 69480
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038060/thumbnail-0819a5e25bfb1814d26eddeb179202a3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848404"
"ResourceRecordKey" => "30038060"
"ModificationTimestamp" => "2026-07-16T20:03:27.44Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "30038060_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038060/0ab19f2ecd917a2e7cd45075fbaba1c3.webp"
"MediaSize" => 75637
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038060/thumbnail-0ab19f2ecd917a2e7cd45075fbaba1c3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848404"
"ResourceRecordKey" => "30038060"
"ModificationTimestamp" => "2026-07-16T20:03:28.96Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "30038060_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038060/5aad2c0f4112db7fac0ab17ada32cb94.webp"
"MediaSize" => 86752
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038060/thumbnail-5aad2c0f4112db7fac0ab17ada32cb94.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848404"
"ResourceRecordKey" => "30038060"
"ModificationTimestamp" => "2026-07-16T20:03:30.24Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "30038060_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038060/e2a2b29b2406a19ea83d4a21dd7538e6.webp"
"MediaSize" => 77221
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038060/thumbnail-e2a2b29b2406a19ea83d4a21dd7538e6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848404"
"ResourceRecordKey" => "30038060"
"ModificationTimestamp" => "2026-07-16T20:03:26.95Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "30038060_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038060/4f912af75649ea7f84f855f22e2a0bbe.webp"
"MediaSize" => 75904
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038060/thumbnail-4f912af75649ea7f84f855f22e2a0bbe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848404"
"ResourceRecordKey" => "30038060"
"ModificationTimestamp" => "2026-07-16T20:03:27.06Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "30038060_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038060/4e2d31f6db45b4d899552bd989b9049b.webp"
"MediaSize" => 80030
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038060/thumbnail-4e2d31f6db45b4d899552bd989b9049b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848404"
"ResourceRecordKey" => "30038060"
"ModificationTimestamp" => "2026-07-16T20:03:26.94Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "30038060_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038060/3114b4217ac762f28a906028f5c5b0e5.webp"
"MediaSize" => 56713
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038060/thumbnail-3114b4217ac762f28a906028f5c5b0e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848404"
"ResourceRecordKey" => "30038060"
"ModificationTimestamp" => "2026-07-16T20:03:28.65Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "30038060_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038060/cf2d8ca85aa85d2c31bc9ee44b9a585e.webp"
"MediaSize" => 64737
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038060/thumbnail-cf2d8ca85aa85d2c31bc9ee44b9a585e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848404"
"ResourceRecordKey" => "30038060"
"ModificationTimestamp" => "2026-07-16T20:03:26.94Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "30038060_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038060/9f85549fc031894c677fd0db0ac57088.webp"
"MediaSize" => 43144
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038060/thumbnail-9f85549fc031894c677fd0db0ac57088.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848404"
"ResourceRecordKey" => "30038060"
"ModificationTimestamp" => "2026-07-16T20:03:29.68Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "30038060_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038060/559db875c3ee3c92d4312f4516149d76.webp"
"MediaSize" => 61589
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038060/thumbnail-559db875c3ee3c92d4312f4516149d76.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848404"
"ResourceRecordKey" => "30038060"
"ModificationTimestamp" => "2026-07-16T20:03:28.62Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "30038060_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038060/c7482880905794587243e7d1f9359f3b.webp"
"MediaSize" => 108669
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038060/thumbnail-c7482880905794587243e7d1f9359f3b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848404"
"ResourceRecordKey" => "30038060"
"ModificationTimestamp" => "2026-07-16T20:03:26.94Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "30038060_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038060/128b67f133d94a8a82b0ea62ee8ba6b7.webp"
"MediaSize" => 109997
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038060/thumbnail-128b67f133d94a8a82b0ea62ee8ba6b7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848404"
"ResourceRecordKey" => "30038060"
"ModificationTimestamp" => "2026-07-16T20:03:26.94Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "30038060_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038060/e3a45cb08e189e1672f26229c8b93c5d.webp"
"MediaSize" => 96643
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038060/thumbnail-e3a45cb08e189e1672f26229c8b93c5d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848404"
"ResourceRecordKey" => "30038060"
"ModificationTimestamp" => "2026-07-16T20:03:26.94Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "30038060_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038060/a54734f122ad56ed36552551e6c722c3.webp"
"MediaSize" => 99543
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038060/thumbnail-a54734f122ad56ed36552551e6c722c3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848404"
"ResourceRecordKey" => "30038060"
"ModificationTimestamp" => "2026-07-16T20:03:26.99Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "30038060_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038060/af8cda17fc87327f6f8bdb2daa9b5a44.webp"
"MediaSize" => 132260
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038060/thumbnail-af8cda17fc87327f6f8bdb2daa9b5a44.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848404"
"ResourceRecordKey" => "30038060"
"ModificationTimestamp" => "2026-07-16T20:03:29.35Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "30038060_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038060/9800e8853a5c290118a983faa038dd27.webp"
"MediaSize" => 139508
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038060/thumbnail-9800e8853a5c290118a983faa038dd27.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848404"
"ResourceRecordKey" => "30038060"
"ModificationTimestamp" => "2026-07-16T20:03:26.94Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "30038060_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038060/5ccaee3319923eec11ae263665b3f49c.webp"
"MediaSize" => 185065
…9
]
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": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30038060')"
+"ID": "1637099"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25242
+post_id: "1637100"
+post_author: 1
+"ListingKey": "30039981"
+"ListingId": "40848617"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-19T20:25:21Z"
+"RFModificationTimestamp": "2026-07-19T20:27:36Z"
+"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-19T20:18:24Z"
+"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"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25239
+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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30047262')"
+"ID": "1635644"
}
3 => 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-19T20:25:22Z"
+"RFModificationTimestamp": "2026-07-19T20:27:14Z"
+"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-19T20: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"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25241
+post_id: "1634560"
+post_author: 1
+"ListingKey": "30046391"
+"ListingId": "40841569"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-19T16:30:00Z"
+"RFModificationTimestamp": "2026-07-19T16:30: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-19T16:21:22Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-19T16:29:50Z"
+"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"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25236
+post_id: "1630375"
+post_author: 1
+"ListingKey": "30040607"
+"ListingId": "40847465"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T15:30:06Z"
+"RFModificationTimestamp": "2026-07-17T15:51:20Z"
+"ListPrice": 750000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2004.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L1S4"
+"UnparsedAddress": "210 DAWSON Street, Waterloo, Ontario N2L1S4"
+"Coordinates": array:2 [
0 => -80.5346811
1 => 43.4589909
]
+"Latitude": 43.4589909
+"Longitude": -80.5346811
+"YearBuilt": 1954
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "WESTMOUNT! Welcome to 210 Dawson St., Waterloo—a beautifully updated 3+1 bed bungalow with 2 full baths in one of Waterloo’s most established & desirable neighbourhoods. Thoughtfully maintained and move-in ready, this home offers a great blend of classic charm, smart upgrades, and flexible living space—plus an outdoor retreat you’ll love! Step inside to a welcoming main level anchored by a combined living/dining area with large picture windows at the front & rear. A gas fireplace adds warmth, and a built-in TV set in a picture-frame keeps the space tidy and functional. The updated kitchen features custom cabinetry, quartz countertops, and stainless-steel appliances. Three bedrooms with generous closet space, a primary 4-piece bathroom, and a convenient linen closet with its own interior cabinet light—making everyday routines effortless. With large windows and an open layout, the home offers comfortable, one-level flow. Downstairs, the fully finished lower level expands your options with a spacious family room, a 4th bed (3+1 setup), and a 2nd full 3-piece bath. You’ll also find bonus space suited for an office or workshop & a combo Laundry storage space. Ideal for guests, multigenerational living, or a growing family. Outside, enjoy privacy in a fully fenced backyard with a covered patio with a natural gas BBQ hook-up and outdoor TV—perfect for relaxing or entertaining. Mature trees frame the yard, and a small pond with a fountain adds a calming touch. The outdoor space is designed for three-season enjoyment, and the two storage sheds offer flexibility for storage or additional workshop space. Located in Westmount, you’re close to top-rated schools and within walking distance to Uptown Waterloo, cafes, restaurants, shopping, the LRT, and Waterloo Park—with everyday amenities right nearby. A fantastic opportunity to own a well-cared-for, updated bungalow in the heart of Westmount. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-16T14:53:34.930272+00:00"
+"Directions": "Dawson between Dietz & Westmount"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1967416"
+"ListOfficeKey": "299554"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Southern exposure"
1 => "Conservation/green belt"
2 => "Private Yard"
]
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-07-17T15:23:57Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T15:23:57Z"
+"Stories": "1.0"
+"StreetName": "DAWSON"
+"StreetNumber": "210"
+"StreetSuffix": "Street"
+"SubdivisionName": "415 - Uptown Waterloo/Westmount"
+"TaxAnnualAmount": "4712.13"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"View": "City view"
+"VirtualTourURLUnbranded": "https://youriguide.com/210_dawson_st_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/30040607/210-dawson-street-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "None"
]
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 53.0
+"AboveGradeFinishedArea": 1065
+"BelowGradeFinishedArea": 939
+"OriginalEntryTimestamp": "2026-07-16T12:28:49.75Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1255259"
+"ListOfficeNationalAssociationId": "1473831"
+"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('30040607')"
+"ID": "1630375"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23486
+post_id: "1629363"
+post_author: 1
+"ListingKey": "30038706"
+"ListingId": "X13568634"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-15T21:20:04Z"
+"RFModificationTimestamp": "2026-07-15T23:10:41Z"
+"ListPrice": 1149900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5A5"
+"UnparsedAddress": "337 MARLOWE DRIVE, Waterloo, Ontario N2L5A5"
+"Coordinates": array:2 [
0 => -80.551304
1 => 43.462117
]
+"Latitude": 43.462117
+"Longitude": -80.551304
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"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:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Window Coverings"
9 => "Garage door opener"
10 => "Garage door opener remote(s)"
11 => "Water Heater"
]
+"Basement": array:5 [
0 => "Finished"
1 => "Full"
2 => "Walk-up"
3 => "N/A"
4 => "N/A"
]
+"BathroomsPartial": 2
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-15T23:10:34.793879+00:00"
+"Directions": "Cross Streets: AMOS AVENUE. ** Directions: KEATS WAY TO AMOS AVENUE, THEN MARLOWE DRIVE."
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Brick"
]
+"Fencing": array:1 [
0 => "Fully Fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2103799"
+"ListOfficeKey": "290246"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Irregular lot size"
1 => "Conservation/green belt"
2 => "Lighting"
3 => "Sauna"
]
+"LotSizeDimensions": "77.7 x 134.5 FT ; 77.85 x 181.25 x 79.61 x 134.50"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-15T21:10:25Z"
+"PhotosCount": 50
+"PoolFeatures": array:2 [
0 => "Inground pool"
1 => "Outdoor pool"
]
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-15T21:10:25Z"
+"Stories": "2.0"
+"StreetName": "Marlowe"
+"StreetNumber": "337"
+"StreetSuffix": "Drive"
+"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": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30038706/337-marlowe-drive-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 77.8
+"OriginalEntryTimestamp": "2026-07-15T21:10:25.4Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1373322"
+"ListOfficeNationalAssociationId": "1385020"
+"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": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30038706')"
+"ID": "1629363"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25244
+post_id: "1626777"
+post_author: 1
+"ListingKey": "30035988"
+"ListingId": "X13565994"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-16T15:50:04Z"
+"RFModificationTimestamp": "2026-07-16T17:06:49Z"
+"ListPrice": 959000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T1R5"
+"UnparsedAddress": "298 ROXTON DRIVE, Waterloo, Ontario N2T1R5"
+"Coordinates": array:2 [
0 => -80.5631353
1 => 43.4630718
]
+"Latitude": 43.4630718
+"Longitude": -80.5631353
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 298 Roxton Drive, a spacious and versatile two-storey home nestled in Waterloo's sought-after Westwinds community. Thoughtfully designed for comfortable family living and entertaining, this well-appointed home offers an exceptional layout with generous principal rooms and endless potential. The main floor features a bright eat-in kitchen, inviting family room, formal living and dining rooms, a private den ideal for a home office, convenient main floor laundry, and a powder room. Upstairs, the expansive primary suite includes a walk-in closet with built-ins and a private 4-piece ensuite. A generous second bedroom, additional 4-piece bath, and a flexible loft and sitting area provide outstanding versatility - perfect for a media room, home gym, office, or easily converted third sleeping space. The oversized basement offers incredible additional living potential, highlighted by a massive L-shaped recreation room ready to be customized to suit your lifestyle - whether as a games room, home theatre, fitness area, or multi-generational living space. Ideally located close to both University of Waterloo and Wilfrid Laurier University, this home is situated in a desirable family-friendly neighbourhood near parks, schools, shopping, and everyday amenities. Community fees conveniently include landscaping and snow removal, offering added ease and low-maintenance living. This home presents a rare opportunity to create the space you've been looking for in one of Waterloo's most established communities. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"AssociationFee": "376.66"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Common Area Maintenance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-15T17:01:19.196208+00:00"
+"Directions": "Cross Streets: Fischer-Hallman. ** Directions: Fischer-Hallman and Roxton."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2099764"
+"ListOfficeKey": "290246"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-15T15:39:55Z"
+"PhotosCount": 33
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-16T15:40:25Z"
+"Stories": "2.0"
+"StreetName": "Roxton"
+"StreetNumber": "298"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "7118.33"
+"VirtualTourURLUnbranded": "https://youriguide.com/298_roxton_dr_waterloo_on/"
+"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": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30035988/298-roxton-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Self Managed"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Visitor Parking"
]
+"SecurityFeatures": array:1 [
0 => "Alarm system"
]
+"LivingAreaMaximum": 2499
+"LivingAreaMinimum": 2250
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"OriginalEntryTimestamp": "2026-07-15T15:39:55.35Z"
+"ListAgentNationalAssociationId": "1369922"
+"ListOfficeNationalAssociationId": "1385020"
+"Media": array:33 [
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]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30035988')"
+"ID": "1626777"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25245
+post_id: "1626349"
+post_author: 1
+"ListingKey": "30034713"
+"ListingId": "40846939"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-15T21:10:07Z"
+"RFModificationTimestamp": "2026-07-15T21:11:53Z"
+"ListPrice": 499900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1702.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T1Y7"
+"UnparsedAddress": "450 BEECHWOOD Place Unit# 6, Waterloo, Ontario N2T1Y7"
+"Coordinates": array:2 [
0 => -80.5573776
1 => 43.4527206
]
+"Latitude": 43.4527206
+"Longitude": -80.5573776
+"YearBuilt": 1986
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Rare opportunity in sought-after Beechwood! This exceptionally spacious townhome condo is one of the largest units in the complex and comes with an almost unheard of double car garage. Nestled in the desirable Beechwood West community backing onto the naturalized Clair Creek greenbelt, this home offers a bright, functional layout features a main floor primary bedroom with large ensuite, as well as an additional bedroom and loft space on the upper floor. The main level features spacious living and dining areas, and dual sliders to a private balcony perfect for morning coffee. The full basement offers a large rec room area, office, laundry, and abundant storage with built-in shelving. Enjoy carefree condo living with the community pool, visitor parking, and condo fees that include water, building maintenance, roof, windows and snow removal. Steps to Beechwood Plaza, minutes to The Boardwalk, top-rated schools, both universities, and ION transit. This unit is a blank canvas awaiting your personal touch, so bring your design ideas and get ready to build instant equity and make this home your own! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Garage door opener"
]
+"AssociationFee": "775"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:6 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Water"
4 => "Insurance"
5 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-15T13:55:49.362342+00:00"
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"FireplaceFeatures": array:2 [
0 => "Wood"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1926813"
+"ListOfficeKey": "299554"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Southern exposure"
1 => "Balcony"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-15T21:03:27Z"
+"PhotosCount": 47
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-15T21:03:27Z"
+"Stories": "2.0"
+"StreetName": "BEECHWOOD"
+"StreetNumber": "450"
+"StreetSuffix": "Place"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "4067"
+"VirtualTourURLUnbranded": "https://youriguide.com/6_450_beechwood_place_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/30034713/450-beechwood-place-unit-6-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1600707"
+"CommonInterest": "Condo/Strata"
+"CoListAgentKey2": "1563792"
+"CoListOfficeKey": "299554"
+"GeocodeManualYN": true
+"CoListOfficeKey2": "76831"
+"ZoningDescription": "MR150"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1702
+"OriginalEntryTimestamp": "2026-07-15T12:18:43.07Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1229829"
+"ListOfficeNationalAssociationId": "1473831"
+"CoListAgentNationalAssociationId": "1149297"
+"CoListAgentNationalAssociationId2": "1070179"
+"CoListOfficeNationalAssociationId": "1473831"
+"CoListOfficeNationalAssociationId2": "1004391"
+"Media": array:47 [
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]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30034713')"
+"ID": "1626349"
}
]
+success: true
+page_size: 9
+page_count: 15
+count: 133
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]