array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 30038060 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: "1637099"
+post_author: 1
+"ListingKey": "30038060"
+"ListingId": "40848404"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T20:20:08Z"
+"RFModificationTimestamp": "2026-07-17T20:40:34Z"
+"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-16T20:03:30Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T20:09: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
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038060/thumbnail-5ccaee3319923eec11ae263665b3f49c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848404"
"ResourceRecordKey" => "30038060"
"ModificationTimestamp" => "2026-07-16T20:03:29.35Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "30038060_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038060/435be7bcb2046ee13a29c4e3e706fb2a.webp"
"MediaSize" => 192673
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038060/thumbnail-435be7bcb2046ee13a29c4e3e706fb2a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848404"
"ResourceRecordKey" => "30038060"
"ModificationTimestamp" => "2026-07-16T20:03:28.84Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "30038060_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038060/67e989cb1cce9dbcf3f458ab561148a0.webp"
"MediaSize" => 150279
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038060/thumbnail-67e989cb1cce9dbcf3f458ab561148a0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848404"
"ResourceRecordKey" => "30038060"
"ModificationTimestamp" => "2026-07-16T20:03:28.7Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "30038060_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038060/3e0aa2f81aebf3cd5a2fde857696db8d.webp"
"MediaSize" => 152061
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038060/thumbnail-3e0aa2f81aebf3cd5a2fde857696db8d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848404"
"ResourceRecordKey" => "30038060"
"ModificationTimestamp" => "2026-07-16T20:03:26.94Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "30038060_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038060/ea54600dbc6216f6fc84153f30bcea69.webp"
"MediaSize" => 164095
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038060/thumbnail-ea54600dbc6216f6fc84153f30bcea69.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848404"
"ResourceRecordKey" => "30038060"
"ModificationTimestamp" => "2026-07-16T20:03:28.8Z"
]
44 => array:13 [
"Order" => 45
"MediaKey" => "30038060_4890_45"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038060/47b6bd6f8f266e425f8b7e34f02f4676.webp"
"MediaSize" => 117752
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038060/thumbnail-47b6bd6f8f266e425f8b7e34f02f4676.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848404"
"ResourceRecordKey" => "30038060"
"ModificationTimestamp" => "2026-07-16T20:03:26.94Z"
]
45 => array:13 [
"Order" => 46
"MediaKey" => "30038060_4890_46"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038060/cfa1fde4fe392d0e2986b7f0b40c14fc.webp"
"MediaSize" => 173192
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038060/thumbnail-cfa1fde4fe392d0e2986b7f0b40c14fc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848404"
"ResourceRecordKey" => "30038060"
"ModificationTimestamp" => "2026-07-16T20:03:28.7Z"
]
46 => array:13 [
"Order" => 47
"MediaKey" => "30038060_4890_47"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038060/55ebd2e95ba567ef06386625d52bd841.webp"
"MediaSize" => 175901
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038060/thumbnail-55ebd2e95ba567ef06386625d52bd841.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848404"
"ResourceRecordKey" => "30038060"
"ModificationTimestamp" => "2026-07-16T20:03:28.79Z"
]
47 => array:13 [
"Order" => 48
"MediaKey" => "30038060_4890_48"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038060/7f7aa25ebec862b0c5f3b73d9553a0d7.webp"
"MediaSize" => 194704
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038060/thumbnail-7f7aa25ebec862b0c5f3b73d9553a0d7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848404"
"ResourceRecordKey" => "30038060"
"ModificationTimestamp" => "2026-07-16T20:03:28.65Z"
]
48 => array:13 [
"Order" => 49
"MediaKey" => "30038060_4890_49"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038060/a73d5bdee06cd8edb76bcfdf7945ca7b.webp"
"MediaSize" => 154329
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038060/thumbnail-a73d5bdee06cd8edb76bcfdf7945ca7b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848404"
"ResourceRecordKey" => "30038060"
"ModificationTimestamp" => "2026-07-16T20:03:28.62Z"
]
49 => array:13 [
"Order" => 50
"MediaKey" => "30038060_4890_50"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30038060/0298dbedf1e8ac6bc1a76ef98b482db9.webp"
"MediaSize" => 228959
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30038060/thumbnail-0298dbedf1e8ac6bc1a76ef98b482db9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848404"
"ResourceRecordKey" => "30038060"
"ModificationTimestamp" => "2026-07-16T20:03:28.83Z"
]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30038060')"
+"ID": "1637099"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 290168" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25014
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24958
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "RE/MAX TWIN CITY REALTY INC."
+"OfficeEmail": null
+"OfficePhone": "519-885-0200"
+"OfficeMlsId": "KW357"
+"ModificationTimestamp": "2026-03-24T17:19:30Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "290168"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "83 ERB STREET W, SUITE B"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "WATERLOO"
+"OfficePostalCode": "N2L6C"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1384313"
+"OriginalEntryTimestamp": "2021-04-15T13:36:00Z"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "431113"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "290168"
"SocialMediaUrlOrId" => "http://www.remaxtwincity.com/"
"ModificationTimestamp" => "2026-03-24T16:37:00Z"
]
]
+"FranchiseNationalAssociationId": "1183864"
+"OfficeBrokerNationalAssociationId": "1069905"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('290168')"
}
]
+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 1932106" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24968
+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 '30038060'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25324
+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 '30038060' AND OpenHouseDate ge '2026-07-17'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25340
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '30038060' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5513334 43.4621325)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25413
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25407
+post_id: "1637579"
+post_author: 1
+"ListingKey": "30050486"
+"ListingId": "X13579042"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T21:45:05Z"
+"RFModificationTimestamp": "2026-07-17T22:43:55Z"
+"ListPrice": 350000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0H6"
+"UnparsedAddress": "125 - 258A SUNVIEW STREET, Waterloo, Ontario N2L0H6"
+"Coordinates": array:2 [
0 => -80.532991
1 => 43.474108
]
+"Latitude": 43.474108
+"Longitude": -80.532991
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this turnkey, fully furnished 2-bedroom condominium offering modern, low-maintenance living in one of Waterloo's most desirable communities. The thoughtfully designed open-concept layout features two spacious bedrooms, a modern kitchen, in-suite laundry and contemporary finishes throughout. This suite presents an exceptional opportunity for investors looking to generate strong rental income, parents purchasing for a university student, or first-time buyers seeking an affordable entry into Waterloo's thriving real estate market. With strong demand from students and professionals alike, this property offers excellent rental potential and long-term value. Condo fees include high-speed Internet, heat, water, air conditioning, building insurance and common elements. Residents enjoy an impressive selection of building amenities including a rooftop terrace, study lounges, secure key fob entry, elevator access, bike storage and visitor parking. Ideally situated near the University of Waterloo, Wilfrid Laurier University, Conestoga College Waterloo Campus, the ION LRT and everyday amenities, this location also offers convenient access to Uptown Waterloo, major highways and the Region's renowned technology corridor, including Google, OpenText, Shopify and Deloitte. An exceptional opportunity to own a move-in ready property, don't miss your chance to make this sought-after location your next investment! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Furniture"
]
+"AssociationFee": "323.75"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Water"
2 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets not Allowed"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-17T22:43:47.899937+00:00"
+"Directions": "Cross Streets: King St N and University Ave W. ** Directions: NW of Sunview St and University Ave W."
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2076954"
+"ListOfficeKey": "275987"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Carpet Free"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-17T21:39:28Z"
+"PhotosCount": 25
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T21:39:28Z"
+"StreetName": "Sunview"
+"StreetNumber": "258A"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3004.16"
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1687081202"
"RoomType" => "Living room"
…9
]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30050486/125-258a-sunview-street-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-07-17T21:39:28.8Z"
+"ListAgentNationalAssociationId": "1352117"
+"ListOfficeNationalAssociationId": "1269835"
+"Media": array:25 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30050486')"
+"ID": "1637579"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25409
+post_id: "1637039"
+post_author: 1
+"ListingKey": "30035744"
+"ListingId": "40848279"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T20:20:07Z"
+"RFModificationTimestamp": "2026-07-17T20:41:24Z"
+"ListPrice": 370000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 602.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0H6"
+"UnparsedAddress": "258A SUNVIEW Street Unit# 198, Waterloo, Ontario N2L0H6"
+"Coordinates": array:2 [
0 => -80.5339417
1 => 43.474243
]
+"Latitude": 43.474243
+"Longitude": -80.5339417
+"YearBuilt": 2018
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to #198-258A Sunview Street, a fantastic opportunity to own a beautifully maintained, fully furnished two bedroom condo in one of Waterloo’s most sought after locations. Ideally situated just steps from Wilfrid Laurier University and only minutes to the University of Waterloo, this property is perfect for students, university staff, professionals, or investors seeking strong rental appeal and exceptional convenience. Lovingly maintained and occupied by only one owner, this bright and inviting unit offers a functional layout with two spacious bedrooms and modern finishes throughout. Move in with ease or start generating rental income immediately, as all furnishings are included. The location truly sets this property apart. Enjoy being within walking distance to restaurants, cafe's, shopping, public transit, and the ION LRT, with Conestoga Mall, Uptown Waterloo, major tech hubs, and Highway 7/8 all just minutes away. Whether you are commuting, studying, shopping, or enjoying the vibrant local amenities, everything you need is right at your doorstep. Offering unbeatable convenience, excellent investment potential, and a central Waterloo address, this turnkey condo is an exceptional opportunity you will not want to miss. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
]
+"AssociationFee": "367.37"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Water"
1 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"ConstructionMaterials": array:2 [
0 => "Concrete block"
1 => "Concrete Walls"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-17T20:41:15.780591+00:00"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Metal"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1750682"
+"ListOfficeKey": "289792"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "None"
]
+"PhotosChangeTimestamp": "2026-07-15T21:23:17Z"
+"PhotosCount": 31
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T20:09:37Z"
+"Stories": "1.0"
+"StreetName": "SUNVIEW"
+"StreetNumber": "258"
+"StreetSuffix": "Street"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "3263.61"
+"VirtualTourURLUnbranded": "https://youriguide.com/198_258a_sunview_street_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30035744/258a-sunview-street-unit-198-waterloo"
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2041614"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "156376"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Party Room"
]
+"ZoningDescription": "NMU-12"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 602
+"OriginalEntryTimestamp": "2026-07-15T15:18:28.24Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1164848"
+"ListOfficeNationalAssociationId": "1381240"
+"CoListAgentNationalAssociationId": "1317527"
+"CoListOfficeNationalAssociationId": "1003925"
+"Media": array:31 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30035744')"
+"ID": "1637039"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25406
+post_id: "1637100"
+post_author: 1
+"ListingKey": "30039981"
+"ListingId": "40848617"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T21:20:02Z"
+"RFModificationTimestamp": "2026-07-17T21:40:08Z"
+"ListPrice": 649900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1435.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T1K2"
+"UnparsedAddress": "584 WESTVALE Drive, Waterloo, Ontario N2T1K2"
+"Coordinates": array:2 [
0 => -80.5500108
1 => 43.446597
]
+"Latitude": 43.446597
+"Longitude": -80.5500108
+"YearBuilt": 1986
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully updated raised bungalow in family-friendly Westvale, one of the area's most popular neighbourhoods. Step inside to a bright, modern open-concept main floor designed for everyday living, offering three bedrooms and two full bathrooms. The spacious kitchen features a generous island that flows seamlessly into the dining and living areas, creating the perfect gathering space for family and friends. Sliding doors off the dining area lead to a large private deck, complete with a hot tub (2022) and plenty of room for outdoor dining, relaxing, and entertaining. The lower level offers a bright, spacious rec room with a cozy gas stove, second full bath plus a huge bonus space, perfect for your home gym, crafts or even another bedroom or two. The backyard is a private retreat, featuring mature trees, a fully fenced yard with a large shed and a side gate providing convenient access for your trailer or maintenance. Thoughtfully maintained and move-in ready, this home has seen numerous recent updates, including windows (2022), shingles (2021) and furnace (2021), offering peace of mind for years to come. Located in a highly sought-after neighbourhood, you'll be just minutes from parks, schools, scenic walking trails, public transit, The Boardwalk shopping, Costco, and a wide variety of amenities. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Hot Tub"
4 => "Dishwasher"
5 => "Dryer"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-17T20:38:01.536897+00:00"
+"Directions": "Fischer Hallman to Thorndale Drive, to Westvale Drive"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2049459"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Sump Pump"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-17T21:11:25Z"
+"PhotosCount": 45
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T21:11:25Z"
+"Stories": "1.0"
+"StreetName": "WESTVALE"
+"StreetNumber": "584"
+"StreetSuffix": "Drive"
+"SubdivisionName": "439 - Westvale"
+"TaxAnnualAmount": "4468.65"
+"VirtualTourURLUnbranded": "https://youriguide.com/584_westvale_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30039981/584-westvale-drive-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SR1A"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 62.0
+"AboveGradeFinishedArea": 1134
+"BelowGradeFinishedArea": 301
+"OriginalEntryTimestamp": "2026-07-16T01:48:15.45Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1324839"
+"ListOfficeNationalAssociationId": "1384313"
+"Media": array:45 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30039981')"
+"ID": "1637100"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25410
+post_id: "1635569"
+post_author: 1
+"ListingKey": "30046734"
+"ListingId": "X13575452"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T13:45:03Z"
+"RFModificationTimestamp": "2026-07-17T17:39:00Z"
+"ListPrice": 509000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3W6"
+"UnparsedAddress": "101 - 253 LESTER STREET, Waterloo, Ontario N2L3W6"
+"Coordinates": array:2 [
0 => -80.53499
1 => 43.4738
]
+"Latitude": 43.4738
+"Longitude": -80.53499
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Incredible turnkey investment in the heart of Waterloo's university district! This purpose-built 5-bedroom, 2-bathroom condo at 253 Lester St has the potential to generate over $49,000/year in gross rental income with positive monthly cash flow. Just steps to Wilfrid Laurier University and the University of Waterloo, this high-demand location ensures consistent tenancy. Features include a spacious open-concept living area, two full baths, included furniture, and professional property management options for a completely hands-off experience. Condo fees include heat and water, and the building offers parking, shared laundry, elevator access, and proximity to transit, shops, and amenities. (id:62650)"
+"Appliances": array:5 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Hood Fan"
4 => "Window Coverings"
]
+"AssociationFee": "802"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Water"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-17T17:38:47.258343+00:00"
+"Directions": "University Ave W/Lester St"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2045015"
+"ListOfficeKey": "275784"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Laundry- Coin operated"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-17T13:39:06Z"
+"PhotosCount": 34
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T13:39:05Z"
+"StreetName": "Lester"
+"StreetNumber": "253"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3950"
+"Rooms": array:10 [
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]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30046734/101-253-lester-street-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2022731"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "CIE Property Management"
+"CoListOfficeKey": "278195"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"BedroomsAboveGrade": 5
+"OriginalEntryTimestamp": "2026-07-17T13:39:05.97Z"
+"ListAgentNationalAssociationId": "1320619"
+"ListOfficeNationalAssociationId": "1268183"
+"CoListAgentNationalAssociationId": "1302336"
+"CoListOfficeNationalAssociationId": "1290805"
+"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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30046734')"
+"ID": "1635569"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25408
+post_id: "1634495"
+post_author: 1
+"ListingKey": "30046352"
+"ListingId": "40849006"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T15:20:06Z"
+"RFModificationTimestamp": "2026-07-17T15:22:50Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1358.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T1G3"
+"UnparsedAddress": "543 DRUMMERHILL Crescent, Waterloo, Ontario N2T1G3"
+"Coordinates": array:2 [
0 => -80.553139
1 => 43.4461149
]
+"Latitude": 43.4461149
+"Longitude": -80.553139
+"YearBuilt": 1985
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Great Location! Welcome to this beautiful detached home in the highly sought-after Westvale neighbourhood. Situated on a quiet, family-friendly crescent, this carpet-free home is conveniently located near top-rated schools, shopping, parks, trails, transit, and just minutes from Uptown Waterloo, the University of Waterloo, Costco, Walmart, medical centres, restaurants, and highway access. This well-maintained single-family home features 3 bedrooms, 2 bathrooms, a single-car garage, parking for three vehicles, and a finished recreation room. The bright main floor offers hardwood flooring, a 2-piece powder room, direct garage access, and sliding doors leading to a fully fenced backyard with a spacious deck—perfect for family gatherings and outdoor entertaining. Upstairs, you'll find three generous bedrooms and a beautifully renovated bathroom. The basement is nearly complete, featuring a finished rec room and a framed 3-piece bathroom rough-in, offering excellent potential for additional living space. Move-in ready and located in one of Waterloo's most desirable family communities, this is a fantastic opportunity you won't want to miss! (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
7 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-17T13:55:25.143676+00:00"
+"Directions": "Fischer-Hallman to Thorndale, left onto Westvale, right onto Drummerhill Crescent"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1955745"
+"ListOfficeKey": "295659"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Sump Pump"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-17T15:13:22Z"
+"PhotosCount": 34
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T15:18:20Z"
+"Stories": "2.0"
+"StreetName": "DRUMMERHILL"
+"StreetNumber": "543"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "439 - Westvale"
+"TaxAnnualAmount": "3852.78"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30046352/543-drummerhill-crescent-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "SD-1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 28.0
+"AboveGradeFinishedArea": 1108
+"BelowGradeFinishedArea": 250
+"OriginalEntryTimestamp": "2026-07-17T11:49:29.53Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1247419"
+"ListOfficeNationalAssociationId": "1452740"
+"Media": array:34 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30046352')"
+"ID": "1634495"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25403
+post_id: "1634560"
+post_author: 1
+"ListingKey": "30046391"
+"ListingId": "40841569"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T12:05:02Z"
+"RFModificationTimestamp": "2026-07-17T13:51:41Z"
+"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-17T11:59:05Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T11:59:05Z"
+"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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30046391')"
+"ID": "1634560"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23486
+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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30040607')"
+"ID": "1630375"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25411
+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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30038706')"
+"ID": "1629363"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25412
+post_id: "1628925"
+post_author: 1
+"ListingKey": "30038709"
+"ListingId": "X13568656"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-15T21:20:04Z"
+"RFModificationTimestamp": "2026-07-15T23:09:37Z"
+"ListPrice": 370000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0H6"
+"UnparsedAddress": "198 - 258A SUNVIEW STREET, Waterloo, Ontario N2L0H6"
+"Coordinates": array:2 [
0 => -80.532991
1 => 43.474108
]
+"Latitude": 43.474108
+"Longitude": -80.532991
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to #198-258A Sunview Street, a fantastic opportunity to own a beautifully maintained, fully furnished two bedroom condo in one of Waterloo's most sought after locations. Ideally situated just steps from Wilfrid Laurier University and only minutes to the University of Waterloo, this property is perfect for students, university staff, professionals, or investors seeking strong rental appeal and exceptional convenience. Lovingly maintained and occupied by only one owner, this bright and inviting unit offers a functional layout with two spacious bedrooms and modern finishes throughout. Move in with ease or start generating rental income immediately, as all furnishings are included. The location truly sets this property apart. Enjoy being within walking distance to restaurants, cafe's, shopping, public transit, and the ION LRT, with Conestoga Mall, Uptown Waterloo, major tech hubs, and Highway 7/8 all just minutes away. Whether you are commuting, studying, shopping, or enjoying the vibrant local amenities, everything you need is right at your doorstep. Offering unbeatable convenience, excellent investment potential, and a central Waterloo address, this turnkey condo is an exceptional opportunity you will not want to miss. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Furniture"
7 => "Window Coverings"
]
+"AssociationFee": "367.37"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Water"
1 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-15T23:09:22.960605+00:00"
+"Directions": "Cross Streets: UNIVERSITY AVE W / SUNVIEW ST. ** Directions: UNIVERSITY AVE W TO SUNVIEW ST."
+"ExteriorFeatures": array:2 [
0 => "Steel"
1 => "Concrete Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2182896"
+"ListOfficeKey": "289816"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-15T21:10:26Z"
+"PhotosCount": 31
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-15T21:10:25Z"
+"StreetName": "SUNVIEW"
+"StreetNumber": "258A"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3263.61"
+"VirtualTourURLUnbranded": "https://youriguide.com/198_258a_sunview_street_waterloo_on/"
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30038709/198-258a-sunview-street-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "WILSON BLANCHARD"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 600
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-07-15T21:10:25.84Z"
+"ListAgentNationalAssociationId": "1432697"
+"ListOfficeNationalAssociationId": "1381521"
+"Media": array:31 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30038709')"
+"ID": "1628925"
}
]
+success: true
+page_size: 9
+page_count: 21
+count: 185
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]