array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29937126 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23409
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23411
+post_id: "1554340"
+post_author: 1
+"ListingKey": "29937126"
+"ListingId": "X13474932"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T18:45:08Z"
+"RFModificationTimestamp": "2026-06-23T18:56:28Z"
+"ListPrice": 1495000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3R1"
+"UnparsedAddress": "612 STONEBURY CRESCENT, Waterloo, Ontario N2K3R1"
+"Coordinates": array:2 [
0 => -80.520918
1 => 43.50485
]
+"Latitude": 43.50485
+"Longitude": -80.520918
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "This is the home you've been waiting for! Located on one of Colonial Acres' most desirable crescents, this exceptional all-brick Georgian-style executive home offers 5,200+ SF of finished living space, 5 bedrms, 4 bathrms, & an ideal blend of timeless architecture, exceptional scale, & modern family functionality. A classic centre hall flr plan welcomes you into elegant formal living & dining rms, a dedicated main-flr office with closet, & a spacious kitchen & breakfast area featuring granite counters, premium appliances, abundant cabinetry, breakfast bar, & direct backyard access. Adjacent to the kitchen, the stunning great rm showcases soaring vaulted ceilings, exposed beams, a striking brick gas fireplace, custom built-ins, & expansive windows. A main-flr laundry/mud rm with garage access & 2-pc powder rm complete the level. Upstairs offers 5 spacious bedrms, a bright loft/den overlooking the great rm below, & a luxurious primary retreat with walk-in closet & 5-pc ensuite. 4 additional bedrms share a 4-pc main bath. The fully finished lower level offers a lrg rec rm with gas fireplace, games area, 2-pc bath (rough-in for future shower), & extensive storage. Meticulously maintained & updated throughout, featuring hand-scraped engineered hardwood & tile flring, furnace & steam humidifier (2023), upgraded attic insulation, & new soffits/eavestroughs/downspouts. Outside, professionally landscaped grounds create exceptional curb appeal & a private, pool-sized backyard retreat surrounded by mature trees. A lrg deck, gas BBQ hookup, & hot tub pad with wiring already in place create the perfect setting for outdoor enjoyment. Double garage with 220V electrical service (potential for EV charging). Located in the heart of Colonial Acres, you'll enjoy excellent schools, parks, trails, shopping, RIM Park, Grey Silo Golf Club, quick HWY access, & everyday amenities. Rarely does a home become available that offers this combination of size, layout, quality, updates & location. (id:62783)"
+"Appliances": array:14 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Oven"
6 => "Dryer"
7 => "Microwave"
8 => "Cooktop"
9 => "Hood Fan"
10 => "Window Coverings"
11 => "Garage door opener"
12 => "Garage door opener remote(s)"
13 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:2 [
0 => "Central air conditioning"
1 => "Air exchanger"
]
+"CreationDate": "2026-06-22T18:45:41.231307+00:00"
+"Directions": "Cross Streets: WISSLER ROAD. ** Directions: NORTHFIELD DRIVE E TO WISSLER ROAD, THEN STONEBURY CRESCENT."
+"ExteriorFeatures": array:1 [
0 => "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:2 [
0 => "Conservation/green belt"
1 => "Sump Pump"
]
+"LotSizeDimensions": "62.8 x 121.6 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-23T18:39:43Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T18:39:43Z"
+"Stories": "2.0"
+"StreetName": "Stonebury"
+"StreetNumber": "612"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "8965.95"
+"VirtualTourURLUnbranded": "https://youriguide.com/612_stonebury_crescent_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:20 [
0 => array:11 [
"RoomKey" => "1665502566"
"RoomType" => "Bedroom"
"ListingId" => "X13474932"
"RoomLevel" => "Second level"
"RoomWidth" => 4.05
"ListingKey" => "29937126"
"RoomLength" => 3.63
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-22T17:52:02.82Z"
]
1 => array:11 [
"RoomKey" => "1665502567"
"RoomType" => "Bedroom"
"ListingId" => "X13474932"
"RoomLevel" => "Second level"
"RoomWidth" => 4.89
"ListingKey" => "29937126"
"RoomLength" => 2.72
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-22T17:52:02.82Z"
]
2 => array:11 [
"RoomKey" => "1665502568"
"RoomType" => "Bedroom"
"ListingId" => "X13474932"
"RoomLevel" => "Second level"
"RoomWidth" => 4.45
"ListingKey" => "29937126"
"RoomLength" => 3.49
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-22T17:52:02.82Z"
]
3 => array:11 [
"RoomKey" => "1665502569"
"RoomType" => "Den"
"ListingId" => "X13474932"
"RoomLevel" => "Second level"
"RoomWidth" => 3.15
"ListingKey" => "29937126"
"RoomLength" => 5.87
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-22T17:52:02.83Z"
]
4 => array:11 [
"RoomKey" => "1665502570"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13474932"
"RoomLevel" => "Second level"
"RoomWidth" => 7.19
"ListingKey" => "29937126"
"RoomLength" => 3.51
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-22T17:52:02.83Z"
]
5 => array:11 [
"RoomKey" => "1665502571"
"RoomType" => "Bathroom"
"ListingId" => "X13474932"
"RoomLevel" => "Basement"
"RoomWidth" => 1.12
"ListingKey" => "29937126"
"RoomLength" => 2.41
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-22T17:52:02.83Z"
]
6 => array:11 [
"RoomKey" => "1665502572"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13474932"
"RoomLevel" => "Basement"
"RoomWidth" => 12.1
"ListingKey" => "29937126"
"RoomLength" => 11.83
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-22T17:52:02.83Z"
]
7 => array:11 [
"RoomKey" => "1665502573"
"RoomType" => "Other"
"ListingId" => "X13474932"
"RoomLevel" => "Basement"
"RoomWidth" => 9.99
"ListingKey" => "29937126"
"RoomLength" => 3.51
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-22T17:52:02.83Z"
]
8 => array:11 [
"RoomKey" => "1665502574"
"RoomType" => "Other"
"ListingId" => "X13474932"
"RoomLevel" => "Basement"
"RoomWidth" => 2.93
"ListingKey" => "29937126"
"RoomLength" => 6.01
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-22T17:52:02.83Z"
]
9 => array:11 [
"RoomKey" => "1665502575"
"RoomType" => "Dining room"
"ListingId" => "X13474932"
"RoomLevel" => "Main level"
"RoomWidth" => 4.26
"ListingKey" => "29937126"
"RoomLength" => 3.45
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-22T17:52:02.83Z"
]
10 => array:11 [
"RoomKey" => "1665502576"
"RoomType" => "Foyer"
"ListingId" => "X13474932"
"RoomLevel" => "Main level"
"RoomWidth" => 4.19
"ListingKey" => "29937126"
"RoomLength" => 3.24
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-22T17:52:02.83Z"
]
11 => array:11 [
"RoomKey" => "1665502577"
"RoomType" => "Great room"
"ListingId" => "X13474932"
"RoomLevel" => "Main level"
"RoomWidth" => 4.67
"ListingKey" => "29937126"
"RoomLength" => 5.87
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-22T17:52:02.83Z"
]
12 => array:11 [
"RoomKey" => "1665502578"
"RoomType" => "Kitchen"
"ListingId" => "X13474932"
"RoomLevel" => "Main level"
"RoomWidth" => 5.45
"ListingKey" => "29937126"
"RoomLength" => 5.96
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-22T17:52:02.83Z"
]
13 => array:11 [
"RoomKey" => "1665502579"
"RoomType" => "Laundry room"
"ListingId" => "X13474932"
"RoomLevel" => "Main level"
"RoomWidth" => 3.12
"ListingKey" => "29937126"
"RoomLength" => 2.92
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-22T17:52:02.83Z"
]
14 => array:11 [
"RoomKey" => "1665502580"
"RoomType" => "Living room"
"ListingId" => "X13474932"
"RoomLevel" => "Main level"
"RoomWidth" => 5.79
"ListingKey" => "29937126"
"RoomLength" => 3.45
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-22T17:52:02.83Z"
]
15 => array:11 [
"RoomKey" => "1665502581"
"RoomType" => "Office"
"ListingId" => "X13474932"
"RoomLevel" => "Main level"
"RoomWidth" => 4.07
"ListingKey" => "29937126"
"RoomLength" => 2.62
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-22T17:52:02.83Z"
]
16 => array:11 [
"RoomKey" => "1665502582"
"RoomType" => "Bathroom"
"ListingId" => "X13474932"
"RoomLevel" => "Second level"
"RoomWidth" => 3.35
"ListingKey" => "29937126"
"RoomLength" => 2.34
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-22T17:52:02.84Z"
]
17 => array:11 [
"RoomKey" => "1665502583"
"RoomType" => "Bathroom"
"ListingId" => "X13474932"
"RoomLevel" => "Second level"
"RoomWidth" => 2.88
"ListingKey" => "29937126"
"RoomLength" => 3.51
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-22T17:52:02.84Z"
]
18 => array:11 [
"RoomKey" => "1665502565"
"RoomType" => "Bedroom"
"ListingId" => "X13474932"
"RoomLevel" => "Second level"
"RoomWidth" => 6.59
"ListingKey" => "29937126"
"RoomLength" => 4.71
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-22T17:52:02.82Z"
]
19 => array:11 [
"RoomKey" => "1665502564"
"RoomType" => "Bathroom"
"ListingId" => "X13474932"
"RoomLevel" => "Main level"
"RoomWidth" => 1.93
"ListingKey" => "29937126"
"RoomLength" => 1.73
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-22T17:52:02.82Z"
]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29937126/612-stonebury-crescent-waterloo"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 5000
+"LivingAreaMinimum": 3500
+"BedroomsAboveGrade": 5
+"FrontageLengthNumeric": 62.9
+"OriginalEntryTimestamp": "2026-06-22T17:52:02.79Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1373322"
+"ListOfficeNationalAssociationId": "1385020"
+"Media": array:50 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29937126_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937126/6b4773c7ca55dd1e5ee8c12d988c309a.webp"
"MediaSize" => 344111
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937126/thumbnail-6b4773c7ca55dd1e5ee8c12d988c309a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13474932"
"ResourceRecordKey" => "29937126"
"ModificationTimestamp" => "2026-06-22T23:16:21.07Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29937126_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937126/33159cbf14c7fe2e9ab45d9a1b53cf8b.webp"
"MediaSize" => 410854
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937126/thumbnail-33159cbf14c7fe2e9ab45d9a1b53cf8b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474932"
"ResourceRecordKey" => "29937126"
"ModificationTimestamp" => "2026-06-22T23:15:46.79Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29937126_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937126/c43dbbef5716bd16cb242c2a21d7fca9.webp"
"MediaSize" => 356412
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937126/thumbnail-c43dbbef5716bd16cb242c2a21d7fca9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474932"
"ResourceRecordKey" => "29937126"
"ModificationTimestamp" => "2026-06-22T23:16:29.13Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29937126_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937126/8ca0513e5de29a83b5fcfbe7bac7e800.webp"
"MediaSize" => 441787
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937126/thumbnail-8ca0513e5de29a83b5fcfbe7bac7e800.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474932"
"ResourceRecordKey" => "29937126"
"ModificationTimestamp" => "2026-06-22T23:16:29.51Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29937126_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937126/490a845ff18fe857438b571b68437c31.webp"
"MediaSize" => 309603
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937126/thumbnail-490a845ff18fe857438b571b68437c31.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474932"
"ResourceRecordKey" => "29937126"
"ModificationTimestamp" => "2026-06-22T23:16:29.63Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29937126_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937126/6e2215f98c42723a6dddef0cd46320c6.webp"
"MediaSize" => 384154
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937126/thumbnail-6e2215f98c42723a6dddef0cd46320c6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474932"
"ResourceRecordKey" => "29937126"
"ModificationTimestamp" => "2026-06-22T23:16:24.14Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29937126_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937126/e95f28ff05ccf99917502b6dfd5bb8ec.webp"
"MediaSize" => 219703
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937126/thumbnail-e95f28ff05ccf99917502b6dfd5bb8ec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474932"
"ResourceRecordKey" => "29937126"
"ModificationTimestamp" => "2026-06-22T23:16:29.8Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29937126_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937126/2f2ac92c40c087c0c61bf2cdc5bf82ff.webp"
"MediaSize" => 196379
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937126/thumbnail-2f2ac92c40c087c0c61bf2cdc5bf82ff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474932"
"ResourceRecordKey" => "29937126"
"ModificationTimestamp" => "2026-06-22T23:16:29.79Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29937126_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937126/2d8d9296c83779c83977cecf454bec64.webp"
"MediaSize" => 201361
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937126/thumbnail-2d8d9296c83779c83977cecf454bec64.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474932"
"ResourceRecordKey" => "29937126"
"ModificationTimestamp" => "2026-06-22T23:15:59.12Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29937126_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937126/5cf7823422e1935a3c2baf62d27fc32e.webp"
"MediaSize" => 187254
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937126/thumbnail-5cf7823422e1935a3c2baf62d27fc32e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474932"
"ResourceRecordKey" => "29937126"
"ModificationTimestamp" => "2026-06-22T23:15:57.62Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29937126_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937126/4f1b988bd745028c372f49135f6c2167.webp"
"MediaSize" => 195883
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937126/thumbnail-4f1b988bd745028c372f49135f6c2167.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474932"
"ResourceRecordKey" => "29937126"
"ModificationTimestamp" => "2026-06-22T23:16:21.22Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29937126_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937126/fb52dcf5fd2919ceba1c3973ea6bd0d8.webp"
"MediaSize" => 174529
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937126/thumbnail-fb52dcf5fd2919ceba1c3973ea6bd0d8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474932"
"ResourceRecordKey" => "29937126"
"ModificationTimestamp" => "2026-06-22T23:16:28Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29937126_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937126/839ead853d741f7e4be094ab9911c7f4.webp"
"MediaSize" => 178908
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937126/thumbnail-839ead853d741f7e4be094ab9911c7f4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474932"
"ResourceRecordKey" => "29937126"
"ModificationTimestamp" => "2026-06-22T23:16:21.35Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29937126_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937126/b06edb2a3cc575fc7a78b7114c87f951.webp"
"MediaSize" => 203998
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937126/thumbnail-b06edb2a3cc575fc7a78b7114c87f951.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474932"
"ResourceRecordKey" => "29937126"
"ModificationTimestamp" => "2026-06-22T23:16:28.01Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29937126_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937126/54de340e8f1e97cd01c6391c7a337be0.webp"
"MediaSize" => 194430
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937126/thumbnail-54de340e8f1e97cd01c6391c7a337be0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474932"
"ResourceRecordKey" => "29937126"
"ModificationTimestamp" => "2026-06-22T23:16:21.42Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29937126_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937126/b08cc68e9c10804154c66fc01766e241.webp"
"MediaSize" => 182355
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937126/thumbnail-b08cc68e9c10804154c66fc01766e241.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474932"
"ResourceRecordKey" => "29937126"
"ModificationTimestamp" => "2026-06-22T23:16:21.45Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29937126_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937126/0dab997fe6bc73e1aab5b6eaf2d4e0ed.webp"
"MediaSize" => 229781
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937126/thumbnail-0dab997fe6bc73e1aab5b6eaf2d4e0ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474932"
"ResourceRecordKey" => "29937126"
"ModificationTimestamp" => "2026-06-22T23:15:46.45Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29937126_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937126/09ccf34cd251cc0f6b6a669e7cd1f44f.webp"
"MediaSize" => 206057
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937126/thumbnail-09ccf34cd251cc0f6b6a669e7cd1f44f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474932"
"ResourceRecordKey" => "29937126"
"ModificationTimestamp" => "2026-06-22T23:16:02.51Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29937126_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937126/e6c4bed7cb1554ab355b9bc12b9b1786.webp"
"MediaSize" => 231952
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937126/thumbnail-e6c4bed7cb1554ab355b9bc12b9b1786.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474932"
"ResourceRecordKey" => "29937126"
"ModificationTimestamp" => "2026-06-22T23:16:21.48Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29937126_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937126/37714704cf02904ccad4af5605e26ec5.webp"
"MediaSize" => 203683
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937126/thumbnail-37714704cf02904ccad4af5605e26ec5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474932"
"ResourceRecordKey" => "29937126"
"ModificationTimestamp" => "2026-06-22T23:16:15.11Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29937126_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937126/9a406c1521c6ac06e8341f1630a64d38.webp"
"MediaSize" => 219893
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937126/thumbnail-9a406c1521c6ac06e8341f1630a64d38.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474932"
"ResourceRecordKey" => "29937126"
"ModificationTimestamp" => "2026-06-22T23:16:22.88Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29937126_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937126/eead3fe19545ff2eac0f9b26fbf15349.webp"
"MediaSize" => 165296
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937126/thumbnail-eead3fe19545ff2eac0f9b26fbf15349.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474932"
"ResourceRecordKey" => "29937126"
"ModificationTimestamp" => "2026-06-22T23:16:28.11Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29937126_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937126/51f4c6644a5a11a9cc27fba187126282.webp"
"MediaSize" => 183856
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937126/thumbnail-51f4c6644a5a11a9cc27fba187126282.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474932"
"ResourceRecordKey" => "29937126"
"ModificationTimestamp" => "2026-06-22T23:16:10.09Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29937126_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937126/255510f16120f228ade6fa8afc615bec.webp"
"MediaSize" => 201733
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937126/thumbnail-255510f16120f228ade6fa8afc615bec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474932"
"ResourceRecordKey" => "29937126"
"ModificationTimestamp" => "2026-06-22T23:16:27.96Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29937126_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937126/b153cfda1899bb43d70f660f8f0500ea.webp"
"MediaSize" => 174828
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937126/thumbnail-b153cfda1899bb43d70f660f8f0500ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474932"
"ResourceRecordKey" => "29937126"
"ModificationTimestamp" => "2026-06-22T23:16:29Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29937126_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937126/3e12bca33fd77bf02c2e5b9833ef699e.webp"
"MediaSize" => 196736
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937126/thumbnail-3e12bca33fd77bf02c2e5b9833ef699e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474932"
"ResourceRecordKey" => "29937126"
"ModificationTimestamp" => "2026-06-22T23:16:29.13Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29937126_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937126/3338c81506a6bab0962c509e573b6378.webp"
"MediaSize" => 194454
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937126/thumbnail-3338c81506a6bab0962c509e573b6378.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474932"
"ResourceRecordKey" => "29937126"
"ModificationTimestamp" => "2026-06-22T23:16:29.05Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29937126_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937126/9ff62593ae62252b7a03640b560a7616.webp"
"MediaSize" => 206925
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937126/thumbnail-9ff62593ae62252b7a03640b560a7616.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474932"
"ResourceRecordKey" => "29937126"
"ModificationTimestamp" => "2026-06-22T23:16:29.12Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29937126_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937126/0da400e7427f74e222f028e2b4c49802.webp"
"MediaSize" => 197864
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937126/thumbnail-0da400e7427f74e222f028e2b4c49802.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474932"
"ResourceRecordKey" => "29937126"
"ModificationTimestamp" => "2026-06-22T23:16:23.02Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29937126_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937126/fe621038b4581cb13c2a888a8087b738.webp"
"MediaSize" => 181766
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937126/thumbnail-fe621038b4581cb13c2a888a8087b738.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474932"
"ResourceRecordKey" => "29937126"
"ModificationTimestamp" => "2026-06-22T23:16:29.18Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29937126_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937126/c6ff3688fa94d4104233357ee2efe75e.webp"
"MediaSize" => 191372
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937126/thumbnail-c6ff3688fa94d4104233357ee2efe75e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474932"
"ResourceRecordKey" => "29937126"
"ModificationTimestamp" => "2026-06-22T23:16:23.09Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29937126_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937126/834ec746d16193b77c48bcf479cc17f7.webp"
"MediaSize" => 175941
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937126/thumbnail-834ec746d16193b77c48bcf479cc17f7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474932"
"ResourceRecordKey" => "29937126"
"ModificationTimestamp" => "2026-06-22T23:16:29.23Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29937126_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937126/a4513301e2f60d9ced97db1662deca02.webp"
"MediaSize" => 188419
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937126/thumbnail-a4513301e2f60d9ced97db1662deca02.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474932"
"ResourceRecordKey" => "29937126"
"ModificationTimestamp" => "2026-06-22T23:16:23.46Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29937126_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937126/d61da3eb9671623d19607d3e9e817834.webp"
"MediaSize" => 192466
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937126/thumbnail-d61da3eb9671623d19607d3e9e817834.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474932"
"ResourceRecordKey" => "29937126"
"ModificationTimestamp" => "2026-06-22T23:16:29.22Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29937126_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937126/93933aa88d42c114e225504299e81b98.webp"
"MediaSize" => 208224
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937126/thumbnail-93933aa88d42c114e225504299e81b98.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474932"
"ResourceRecordKey" => "29937126"
"ModificationTimestamp" => "2026-06-22T23:16:29.47Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29937126_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937126/fbd214add21376620f8c9daf3b8a6ca2.webp"
"MediaSize" => 169122
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937126/thumbnail-fbd214add21376620f8c9daf3b8a6ca2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474932"
"ResourceRecordKey" => "29937126"
"ModificationTimestamp" => "2026-06-22T23:16:29.23Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29937126_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937126/54df03fae88415daa62c5f58492008af.webp"
"MediaSize" => 205549
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937126/thumbnail-54df03fae88415daa62c5f58492008af.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474932"
"ResourceRecordKey" => "29937126"
"ModificationTimestamp" => "2026-06-22T23:16:23.56Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29937126_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937126/18dbc03a17aba7dd64357814149c6880.webp"
"MediaSize" => 177929
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937126/thumbnail-18dbc03a17aba7dd64357814149c6880.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474932"
"ResourceRecordKey" => "29937126"
"ModificationTimestamp" => "2026-06-22T23:16:29.44Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29937126_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937126/a91b443d7e4a9b7ba8d5f1b66e387903.webp"
"MediaSize" => 202771
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937126/thumbnail-a91b443d7e4a9b7ba8d5f1b66e387903.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474932"
"ResourceRecordKey" => "29937126"
"ModificationTimestamp" => "2026-06-22T23:16:23.59Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29937126_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937126/431d76bef8af6758e43fcfa275a8ada2.webp"
"MediaSize" => 130924
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937126/thumbnail-431d76bef8af6758e43fcfa275a8ada2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474932"
"ResourceRecordKey" => "29937126"
"ModificationTimestamp" => "2026-06-22T23:16:29.45Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29937126_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937126/432be3c06a4dfb12059d6dce2658b6c0.webp"
"MediaSize" => 305877
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937126/thumbnail-432be3c06a4dfb12059d6dce2658b6c0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474932"
"ResourceRecordKey" => "29937126"
"ModificationTimestamp" => "2026-06-22T23:16:23.77Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29937126_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937126/57bd57e94685e915874f42e40499c95e.webp"
"MediaSize" => 407065
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937126/thumbnail-57bd57e94685e915874f42e40499c95e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474932"
"ResourceRecordKey" => "29937126"
"ModificationTimestamp" => "2026-06-22T23:16:23.69Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29937126_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937126/3d041fd231ca8e2d41a5c99ae7884e5f.webp"
"MediaSize" => 313020
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937126/thumbnail-3d041fd231ca8e2d41a5c99ae7884e5f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474932"
"ResourceRecordKey" => "29937126"
"ModificationTimestamp" => "2026-06-22T23:16:24.38Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "29937126_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937126/6ab4452a8d0706dc951026156a23fd83.webp"
"MediaSize" => 396176
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937126/thumbnail-6ab4452a8d0706dc951026156a23fd83.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474932"
"ResourceRecordKey" => "29937126"
"ModificationTimestamp" => "2026-06-22T23:16:17.78Z"
]
44 => array:13 [
"Order" => 45
"MediaKey" => "29937126_4890_45"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937126/a84aba1659d8d7bf61277cdbf36d7dd8.webp"
"MediaSize" => 385859
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937126/thumbnail-a84aba1659d8d7bf61277cdbf36d7dd8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474932"
"ResourceRecordKey" => "29937126"
"ModificationTimestamp" => "2026-06-22T23:15:58.94Z"
]
45 => array:13 [
"Order" => 46
"MediaKey" => "29937126_4890_46"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937126/4bc4c39112f20f81d3ad34e4c910f142.webp"
"MediaSize" => 433009
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937126/thumbnail-4bc4c39112f20f81d3ad34e4c910f142.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474932"
"ResourceRecordKey" => "29937126"
"ModificationTimestamp" => "2026-06-22T23:16:23.77Z"
]
46 => array:13 [
"Order" => 47
"MediaKey" => "29937126_4890_47"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937126/82270323020e17179f15a767cfcaf481.webp"
"MediaSize" => 438139
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937126/thumbnail-82270323020e17179f15a767cfcaf481.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13474932"
"ResourceRecordKey" => "29937126"
"ModificationTimestamp" => "2026-06-22T23:16:29.67Z"
]
47 => array:13 [
"Order" => 48
"MediaKey" => "29937126_4890_48"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937126/e02550c50b119bbe111a2bb4b2ae47b2.webp"
"MediaSize" => 453356
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937126/thumbnail-e02550c50b119bbe111a2bb4b2ae47b2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
…4
]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29937126')"
+"ID": "1554340"
}
]
+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=OfficeMlsId eq 290246" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24847
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2103799" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24856
+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 '29937126'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25261
+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 '29937126'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25277
+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 '29937126' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.520918 43.50485)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25367
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25344
+post_id: "1557351"
+post_author: 1
+"ListingKey": "29941712"
+"ListingId": "40842211"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T16:20:24Z"
+"RFModificationTimestamp": "2026-06-23T17:50:20Z"
+"ListPrice": 1199900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2400.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3J1"
+"UnparsedAddress": "391 TIMLOCK Place, Waterloo, Ontario N2K3J1"
+"Coordinates": array:2 [
0 => -80.5005194
1 => 43.4981893
]
+"Latitude": 43.4981893
+"Longitude": -80.5005194
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully updated family home tucked away on a quiet court in Waterloo's sought-after Lexington neighbourhood. Surrounded by mature trees, parks, trails, schools and a strong sense of community, this is the kind of neighbourhood where families put down roots and stay for years. Offering generous above-grade living space plus a finished basement, this 4-bedroom, 4-bathroom home blends comfort, functionality and timeless style. Freshly painted in neutral tones with recent basement updates, it has been well maintained with a new roof (2020), furnace (2014), air conditioner (2025) and many updated windows. The spacious kitchen is the heart of the home, with plenty of room for family and friends to gather. Multiple living areas on the main floor provide flexibility for everyday living and entertaining, including a welcoming family room, dining room and separate sitting room. Main floor laundry adds convenience. Upstairs, four generous bedrooms include a relaxing primary retreat with a beautifully updated ensuite bath. The finished basement adds valuable living space with a large recreation and games area, perfect for movie nights, gaming, ping pong, board games or simply spending time together. A separate bonus room works equally well as a home office, fitness room, guest space or hobby room. A two-piece bathroom and ample storage complete the lower level. Outside, the large private backyard offers plenty of room for children and pets to play, gardens to grow, or future outdoor living plans. A double garage and parking for four vehicles provide plenty of room for family and guests. Located minutes from Rim Park, recreation facilities, transit, shopping and everyday amenities, this home offers the perfect balance of peaceful suburban living and convenient city access. Beautifully maintained, thoughtfully updated and ideally located, this is a rare opportunity to own a home in one of Waterloo's most desirable family neighbourhoods. (id:62783)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Gas stove(s)"
5 => "Dishwasher"
6 => "Dryer"
7 => "Microwave"
8 => "Hood Fan"
9 => "Window Coverings"
10 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-23T17:50:07.259543+00:00"
+"Directions": "Bridge to Dansbury to Forestlawn to Timlock Pl"
+"ExteriorFeatures": array:2 [
0 => "Aluminum siding"
1 => "Brick Veneer"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1830254"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Cul-de-sac"
1 => "Paved driveway"
2 => "Sump Pump"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-23T16:11:30Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T16:11:30Z"
+"Stories": "2.0"
+"StreetName": "TIMLOCK"
+"StreetNumber": "391"
+"StreetSuffix": "Place"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"TaxAnnualAmount": "7963.37"
+"VirtualTourURLUnbranded": "https://youriguide.com/391_timlock_pl_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
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]
15 => array:11 [ …11]
16 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29941712/391-timlock-place-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SR2"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 60.0
+"AboveGradeFinishedArea": 2400
+"OriginalEntryTimestamp": "2026-06-23T16:11:30.38Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1195645"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:47 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29941712')"
+"ID": "1557351"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25346
+post_id: "1554233"
+post_author: 1
+"ListingKey": "29936648"
+"ListingId": "40841802"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-22T17:00:17Z"
+"RFModificationTimestamp": "2026-06-22T19:07:22Z"
+"ListPrice": 1495000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 5.0
+"LotSizeArea": 0.175
+"LivingArea": 5272.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3R1"
+"UnparsedAddress": "612 STONEBURY Crescent, Waterloo, Ontario N2K3R1"
+"Coordinates": array:2 [
0 => -80.5209485
1 => 43.5048669
]
+"Latitude": 43.5048669
+"Longitude": -80.5209485
+"YearBuilt": 1989
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This is the home you've been waiting for! Located on one of Colonial Acres' most desirable crescents, this exceptional all-brick Georgian-style executive home offers 5,200+ SF of finished living space, 5 bedrms, 4 bathrms, & an ideal blend of timeless architecture, exceptional scale, & modern family functionality. A classic centre hall flr plan welcomes you into elegant formal living & dining rms, a dedicated main-flr office with closet, & a spacious kitchen & breakfast area featuring granite counters, premium appliances, abundant cabinetry, breakfast bar, & direct backyard access. Adjacent to the kitchen, the stunning great rm showcases soaring vaulted ceilings, exposed beams, a striking brick gas fireplace, custom built-ins, & expansive windows. A main-flr laundry/mud rm with garage access & 2-pc powder rm complete the level. Upstairs offers 5 spacious bedrms, a bright loft/den overlooking the great rm below, & a luxurious primary retreat with walk-in closet & 5-pc ensuite. 4 additional bedrms share a 4-pc main bath. The fully finished lower level offers a lrg rec rm with gas fireplace, games area, 2-pc bath (rough-in for future shower), & extensive storage. Meticulously maintained & updated throughout, featuring hand-scraped engineered hardwood & tile flring, furnace & steam humidifier (2023), upgraded attic insulation, & new soffits/eavestroughs/downspouts. Outside, professionally landscaped grounds create exceptional curb appeal & a private, pool-sized backyard retreat surrounded by mature trees. A lrg deck, gas BBQ hookup, & hot tub pad with wiring already in place create the perfect setting for outdoor enjoyment. Double garage with 220V electrical service (potential for EV charging). Located in the heart of Colonial Acres, you'll enjoy excellent schools, parks, trails, shopping, RIM Park, Grey Silo Golf Club, quick HWY access, & everyday amenities. Rarely does a home become available that offers this combination of size, layout, quality, updates & location. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Dryer"
6 => "Microwave"
7 => "Hood Fan"
8 => "Window Coverings"
9 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-22T19:07:09.975486+00:00"
+"Directions": "NORTHFIELD DRIVE E TO WISSLER ROAD, THEN STONEBURY CRESCENT"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1932106"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.175"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-22T16:51:59Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-22T16:51:59Z"
+"Stories": "2.0"
+"StreetName": "STONEBURY"
+"StreetNumber": "612"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "8965.95"
+"VirtualTourURLUnbranded": "https://youriguide.com/612_stonebury_crescent_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:21 [
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]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
18 => array:11 [ …11]
19 => array:11 [ …11]
20 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29936648/612-stonebury-crescent-waterloo"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1975048"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "76789"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 63.0
+"AboveGradeFinishedArea": 3555
+"BelowGradeFinishedArea": 1717
+"OriginalEntryTimestamp": "2026-06-22T16:51:59.25Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1232419"
+"ListOfficeNationalAssociationId": "1384313"
+"CoListAgentNationalAssociationId": "1261853"
+"CoListOfficeNationalAssociationId": "1004357"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29936648')"
+"ID": "1554233"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25343
+post_id: "1538278"
+post_author: 1
+"ListingKey": "29914287"
+"ListingId": "40839253"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T18:00:17Z"
+"RFModificationTimestamp": "2026-06-23T19:54:52Z"
+"ListPrice": 875000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.094
+"LivingArea": 2571.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J4Z8"
+"UnparsedAddress": "212 SLEAFORD Street, Waterloo, Ontario N2J4Z8"
+"Coordinates": array:2 [
0 => -80.5224041
1 => 43.4908368
]
+"Latitude": 43.4908368
+"Longitude": -80.5224041
+"YearBuilt": 2006
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "**Welcome to 212 Sleaford Street, Waterloo!** LOCATION LOCATION LOCATION!! This inviting detached house with a double-car garage locates in one of the most desirable area in the City of Waterloo. It offers an exceptional combination of space, versatility, and convenience. The upper level features 3 comfortable bedrooms and a generously sized family room filled with natural light, make it an ideal space for relaxing, entertaining, or spending quality time with family members together. The finished basement expands the home’s possibilities with an additional bedroom, a 3-piece bathroom, and spacious recreation space. With its own separate entrance, the lower level offers excellent flexibility for extended family, guests, a private home office, or potential future rental use. Ideally situated just minutes from Conestoga Mall and HWY 85, provides convenient access to shopping, restaurants, public transit, major routes throughout Waterloo Region. It is also within easy reach of the University of Waterloo, Wilfrid Laurier University, and Conestoga College by public transit or a 10 mins drive, making it an attractive opportunity for first-time buyers, growing families, and investors alike. RIM Park Sportsplex is also nearby, provides family with easy access to various sports throughout the season (hockey, skating, indoor/outdoor soccer fields, basketball, badminton and more). Recent improvements include a new hot water tank installed in 2026 (owned), and a new water softener (owned, 2025). As an added bonus, ALL FURNITURE currently in the home can be INCLUDED, offering a truly convenient and move-in-ready opportunity. With its generous living space, versatile finished basement, double garage, and highly desirable Waterloo location, this is a home you will not want to miss!!! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Water softener"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T13:57:09.434616+00:00"
+"Directions": "Dearborn Blvd / Tealby Crt"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2168724"
+"ListOfficeKey": "253316"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Southern exposure"
1 => "Paved driveway"
2 => "Sump Pump"
3 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.094"
+"PhotosChangeTimestamp": "2026-06-19T21:41:14Z"
+"PhotosCount": 42
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T17:52:05Z"
+"Stories": "2.0"
+"StreetName": "SLEAFORD"
+"StreetNumber": "212"
+"StreetSuffix": "Street"
+"SubdivisionName": "116 - Glenridge/Lincoln Heights"
+"TaxAnnualAmount": "5421.13"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29914287/212-sleaford-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "50-R4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 36.0
+"AboveGradeFinishedArea": 1818
+"BelowGradeFinishedArea": 753
+"OriginalEntryTimestamp": "2026-06-17T11:50:23.7Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1419405"
+"ListOfficeNationalAssociationId": "1223329"
+"Media": array:42 [
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]
]
+"DaysOnMarket": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29914287')"
+"ID": "1538278"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25347
+post_id: "1538217"
+post_author: 1
+"ListingKey": "29914406"
+"ListingId": "X13454334"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-22T12:30:30Z"
+"RFModificationTimestamp": "2026-06-22T12:41:57Z"
+"ListPrice": 399000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0G9"
+"UnparsedAddress": "405 - 243 NORTHFIELD DRIVE E, Waterloo, Ontario N2K0G9"
+"Coordinates": array:2 [
0 => -80.522255
1 => 43.509258
]
+"Latitude": 43.509258
+"Longitude": -80.522255
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to Blackstone Condominiums in Waterloo! This modern, carpet-free 2-bedroom, 2-bathroom suite offers stylish finishes throughout, including custom cabinetry, quartz countertops, backsplash, in-suite laundry, and a spacious storage room. Enjoy exceptional building amenities including a fitness centre, co-working lounge, party room, rooftop terrace, bike storage, pet wash station, and landscaped outdoor spaces. High-speed internet is included in the condo fees. Conveniently located steps from Brown's Socialhouse, shopping, restaurants, and transit, with easy access to Conestoga Mall, ION LRT, RIM Park, Grey Silo Golf Club, St. Jacobs, universities, and colleges. A fantastic opportunity to own in one of Waterloo's most desirable communities. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
5 => "Hood Fan"
]
+"AssociationFee": "646"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T13:47:22.400606+00:00"
+"Directions": "Cross Streets: Northfield/bridge st w. ** Directions: on northfield dr e."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2249954"
+"ListOfficeKey": "292962"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Elevator"
1 => "Balcony"
2 => "Carpet Free"
3 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T12:16:42Z"
+"PhotosCount": 49
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-22T12:24:39Z"
+"StreetDirSuffix": "East"
+"StreetName": "Northfield"
+"StreetNumber": "243"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "3685"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/405_243_northfield_dr_e_waterloo_on"
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29914406/405-243-northfield-drive-e-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Five Rivers Property Mgmt"
+"GeocodeManualYN": false
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"LivingAreaMaximum": 899
+"LivingAreaMinimum": 800
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-06-17T12:16:42.75Z"
+"ListAgentNationalAssociationId": "1488846"
+"ListOfficeNationalAssociationId": "1420223"
+"Media": array:49 [
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]
]
+"DaysOnMarket": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29914406')"
+"ID": "1538217"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25345
+post_id: "1525405"
+post_author: 1
+"ListingKey": "29898015"
+"ListingId": "40839057"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T21:00:26Z"
+"RFModificationTimestamp": "2026-06-12T21:28:05Z"
+"ListPrice": 865000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2140.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K4B2"
+"UnparsedAddress": "180 OLD ABBEY Road Unit# 14, Waterloo, Ontario N2K4B2"
+"Coordinates": array:2 [
0 => -80.5259326
1 => 43.5008878
]
+"Latitude": 43.5008878
+"Longitude": -80.5259326
+"YearBuilt": 1998
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "WELCOME TO YOUR NEW HOME! Located in the best location in the hidden enclave of Abbey Woods, this bungalow townhome unit is the one you've been waiting for. Backing onto the greenspace, double car garage, finished basement and updates galore. As you enter you'll walk the enginerred hardwood floors right into the open concept main floor with The great room holds room for your living area, dining area, and large kitchen. The kitchen has been updated with newer countertops, sink and taps .All with large bright windows, pot lights, and a gas fireplace. The convenient patio doors go out to the greenspace and large deck with awning. The primary suite offers double closets, and updated 3 piece ensuite with a newer shower, newer counters, sink, taps, and lights. Rounding up the main floor is laundry and an updated extra 3 piece bathroom as well as a second bedroom or office. The space continues downstairs with a large guest room, rec room, and additional bathroom. A walk-in storage closet, and utility room with tons of extra storage. No need to garden or shovel here as condo fees cover so you can close up and enjoy spending time doing the things you love to do. Book your Showing TODAY! (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"AssociationFee": "640"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Parking"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T21:27:58.329526+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1666913"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Conservation/green belt"
1 => "No Pet Home"
2 => "Sump Pump"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-12T20:51:33Z"
+"PhotosCount": 47
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T20:51:33Z"
+"Stories": "1.0"
+"StreetName": "OLD ABBEY"
+"StreetNumber": "180"
+"StreetSuffix": "Road"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "5946"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/180-Old-Abbey-Rd-14"
+"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/29898015/180-old-abbey-road-unit-14-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "R8"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 1322
+"BelowGradeFinishedArea": 818
+"OriginalEntryTimestamp": "2026-06-12T20:51:33.62Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1169212"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:47 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
]
+"DaysOnMarket": 11
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29898015')"
+"ID": "1525405"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25340
+post_id: "1523441"
+post_author: 1
+"ListingKey": "29894120"
+"ListingId": "40838919"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T14:40:08Z"
+"RFModificationTimestamp": "2026-06-18T14:43:59Z"
+"ListPrice": 359900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 584.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0H2"
+"UnparsedAddress": "243 NORTHFIELD Drive E Unit# 408, Waterloo, Ontario N2K0H2"
+"Coordinates": array:2 [
0 => -80.5218062
1 => 43.510191
]
+"Latitude": 43.510191
+"Longitude": -80.5218062
+"YearBuilt": 2021
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Blackstone Condominiums, where modern design meets convenient Waterloo living. This owner-occupied, carpet-free one-bedroom suite has been beautifully maintained and thoughtfully upgraded throughout. The bright open-concept layout overlooks the peaceful courtyard and features a stylish kitchen with upgraded cabinetry, quartz countertops, stainless steel appliances, subway tile backsplash, custom island, and modern pot lighting. Additional highlights include a spacious four-piece bathroom, in-suite laundry, custom remote-controlled blinds, and an owned underground parking space. Residents enjoy exceptional amenities including a fitness center, co-working lounge, party room, rooftop terrace, bike storage, pet wash station, and landscaped outdoor spaces. High-speed Internet is included in the condo fees. Ideally located steps from Brown's Social House, shopping, restaurants, and everyday amenities, with easy access to Conestoga Mall, the ION LRT, RIM Park, Grey Silo Golf Club, St. Jacobs, and Waterloo's universities and colleges. A fantastic opportunity for first-time buyers, professionals or investors seeking a move-in-ready home in one of Waterloo's most desirable communities. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Window Coverings"
7 => "Microwave Built-in"
]
+"AssociationFee": "480"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Landscaping"
1 => "Property Management"
2 => "Heat"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T14:37:36.573103+00:00"
+"Directions": "Corner of Northfield Dr E & Bridge Street"
+"ExteriorFeatures": array:1 [
0 => "Steel"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2043154"
+"ListOfficeKey": "76807"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Balcony"
]
+"ParkingFeatures": array:3 [
0 => "Underground"
1 => "Open"
2 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-12T12:50:34Z"
+"PhotosCount": 35
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T14:32:28Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "NORTHFIELD"
+"StreetNumber": "243"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "3122.33"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29894120/243-northfield-drive-e-unit-408-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "r1"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 584
+"OriginalEntryTimestamp": "2026-06-12T12:50:34.28Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1318898"
+"ListOfficeNationalAssociationId": "1004370"
+"Media": array:35 [
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]
]
+"DaysOnMarket": 11
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29894120')"
+"ID": "1523441"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23423
+post_id: "1516116"
+post_author: 1
+"ListingKey": "29884502"
+"ListingId": "X13427654"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T14:05:05Z"
+"RFModificationTimestamp": "2026-06-12T14:05:47Z"
+"ListPrice": 450000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J4T2"
+"UnparsedAddress": "102 - 30 BLUE SPRINGS DRIVE, Waterloo, Ontario N2J4T2"
+"Coordinates": array:2 [
0 => -80.526045
1 => 43.488822
]
+"Latitude": 43.488822
+"Longitude": -80.526045
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "The Oakville, Milton & District Real Estate Board"
+"PublicRemarks": "Welcome to 30 Blue Springs Drive unit #102. Rare opportunity to own a main-floor condominium overlooking the water in Waterloo's highly sought-after Blue Springs community. Surrounded by mature trees, scenic walking trails, and tranquil ponds, this well-managed building offers a peaceful, nature-inspired setting while remaining just minutes from shopping, restaurants, transit, universities, and expressway access. Inside, the thoughtfully-designed floor plan offers approximately 1,000 square feet of comfortable living space, featuring two bedrooms and two full bathrooms. Large windows fill the unit with natural light and showcase beautiful views of the water and surrounding greenery, while the spacious living and dining area provides plenty of room for everyday living and entertaining. One of the home's most appealing features is its expansive private patio overlooking the pond, offering exceptional outdoor living space rarely found in condominium living. The split-bedroom layout places the bedrooms on opposite sides of the unit, providing privacy and flexibility for guests, family members, or multi-generational living. The primary suite features its own ensuite bathroom, while the second bedroom and full bath offer comfortable accommodation for visitors or a home office. Lovingly maintained and ready for its next chapter, this unit presents an excellent opportunity for buyers to move in and enjoy immediately or personalize the space over time. Additional features include in-suite laundry, an assigned underground parking space, a storage locker, and access to additional building amenities such as a rooftop terrace with BBQs, a guest suite, library, party room, controlled entry, and ample visitor parking. (id:62650)"
+"Appliances": array:1 [
0 => "Water Heater"
]
+"AssociationFee": "881.46"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Water"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-10T21:26:12.540217+00:00"
+"Directions": "Cross Streets: King Street North and Weber Street North. ** Directions: King Street N. to Blue Springs Dr."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2237748"
+"ListOfficeKey": "292802"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-10T19:25:43Z"
+"PhotosCount": 15
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T13:56:16Z"
+"StreetName": "Blue Springs"
+"StreetNumber": "30"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "2578.07"
+"View": "Direct Water View"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/102_30_blue_springs_dr_waterloo_on"
+"WaterBodyName": "Four Wells Lake"
+"Rooms": array:7 [
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]
]
+"ListAOR": "Oakville-Milton"
+"TaxYear": 2025
+"ListAORKey": "15"
+"ListingURL": "www.realtor.ca/real-estate/29884502/102-30-blue-springs-drive-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Sanderson Management"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"BedroomsAboveGrade": 2
+"WaterfrontFeatures": array:1 [
0 => "Waterfront"
]
+"OriginalEntryTimestamp": "2026-06-10T19:25:43.7Z"
+"ListAgentNationalAssociationId": "1475659"
+"ListOfficeNationalAssociationId": "1417590"
+"Media": array:15 [
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]
]
+"DaysOnMarket": 13
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29884502')"
+"ID": "1516116"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25348
+post_id: "1514962"
+post_author: 1
+"ListingKey": "29880685"
+"ListingId": "40823911"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T16:45:40Z"
+"RFModificationTimestamp": "2026-06-16T17:19:53Z"
+"ListPrice": 579000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1210.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K2G4"
+"UnparsedAddress": "435A LEE Avenue, Waterloo, Ontario N2K2G4"
+"Coordinates": array:2 [
0 => -80.5067851
1 => 43.4965407
]
+"Latitude": 43.4965407
+"Longitude": -80.5067851
+"YearBuilt": 1974
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this charming, lovingly maintained semi-detached home, proudly offered by its second owner and located in the highly desirable Lincoln Village neighbourhood. The bright eat-in kitchen features an attractive accent wall, ample cabinetry, and plenty of space for everyday family meals. The spacious open-concept living room is filled with natural light from the large bay window and offers room for both comfortable living and dining. This thoughtfully designed home boasts three generously sized bedrooms, two full bathrooms, and a functional layout that has been lovingly cared for over the years. The basement offers excellent potential for additional living space and includes a full bathroom, laundry area, and abundant storage. Adding to the appeal are the often-overlooked benefits of wonderful neighbours, a large lot, and the only carport on the street. Step outside to the covered deck overlooking the fully fenced backyard, which backs directly onto lush, park greenspace—providing added privacy and a beautiful setting for relaxing, entertaining, or enjoying family time outdoors. Ideally located close to the expressway, schools, shopping, and all amenities, this exceptional property presents a fantastic opportunity for families, first-time buyers, and investors alike. (id:62650)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-10T16:48:04.415942+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1908536"
+"ListOfficeKey": "274404"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-06-10T17:53:18Z"
+"PhotosCount": 41
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T16:35:36Z"
+"Stories": "2.0"
+"StreetName": "LEE"
+"StreetNumber": "435"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "3220"
+"VirtualTourURLUnbranded": "https://youriguide.com/a_435_lee_avenue_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"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": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29880685/435a-lee-avenue-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 1210
+"OriginalEntryTimestamp": "2026-06-10T11:52:28.19Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1221358"
+"ListOfficeNationalAssociationId": "1254957"
+"Media": array:41 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
]
+"DaysOnMarket": 14
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29880685')"
+"ID": "1514962"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25366
+post_id: "1510935"
+post_author: 1
+"ListingKey": "29876708"
+"ListingId": "X13420624"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-09T18:10:27Z"
+"RFModificationTimestamp": "2026-06-09T18:24:13Z"
+"ListPrice": 539900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0G9"
+"UnparsedAddress": "312 - 251 NORTHFIELD DRIVE E, Waterloo, Ontario N2K0G9"
+"Coordinates": array:2 [
0 => -80.5218383
1 => 43.5103022
]
+"Latitude": 43.5103022
+"Longitude": -80.5218383
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "OnePoint Association of REALTORS®"
+"PublicRemarks": "Beautiful residence nestled in one of Waterloo's most desirable communities, offering an exceptional blend of modern luxury, convenience, and lifestyle. Thoughtfully designed with elegant finishes throughout, this sophisticated 2-bed suite features expansive windows that flood the space with natural light, creating an airy and welcoming atmosphere. The primary bedroom features a spacious walk-through closet that leads to the ensuite bath. An additional full bathroom is perfect for guests or family. The stunning chef-inspired kitchen is complete with sleek stainless steel appliances, contemporary cabinetry, and stylish finishes that seamlessly flow into the open-concept living and dining areas. Rich laminate flooring extends throughout the unit, enhancing the home's refined aesthetic. Enjoy the two private balconies, including an exclusive retreat off the spacious primary bedroom; the perfect place to unwind with your morning coffee or evening glass of wine. Residents of Blackstone enjoy access to upscale amenities, including a residents' lounge and event space, co-working rooms, a fully equipped fitness studio, and beautifully designed outdoor terraces. This pet-friendly building even features a convenient dog washing station for your four-legged companions. High-speed internet is included in the condo fees for added value, and the owned parking space is an extra perk! Perfectly positioned near trails, RIM Park, St. Jacobs Farmer's Market, Conestoga Mall, and vibrant Uptown Waterloo this location offers effortless access to exceptional dining, shopping, recreation, and entertainment. Convenient highway access makes commuting simple, while the surrounding green spaces provide a peaceful connection to nature. Whether you are a professional seeking an elevated lifestyle, a first-time buyer looking for luxury and convenience, or an investor searching for a premium opportunity, this exceptional condo delivers. Experience sophisticated Waterloo living at its finest. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Hood Fan"
7 => "Window Coverings"
]
+"AssociationFee": "788"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Common Area Maintenance"
]
+"Basement": array:2 [
0 => "Apartment in basement"
1 => "N/A"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-09T18:02:32.806405+00:00"
+"Directions": "Cross Streets: Bridge St. ** Directions: NORTHFIELD DRIVE EAST."
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1934633"
+"ListOfficeKey": "285253"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Balcony"
1 => "Carpet Free"
2 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-09T17:02:24Z"
+"PhotosCount": 40
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-09T18:04:48Z"
+"StreetDirSuffix": "East"
+"StreetName": "NORTHFIELD"
+"StreetNumber": "251"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "4424.3"
+"VirtualTourURLUnbranded": "https://video-api.supreme.one/CrjpcP?branded=true"
+"ListAOR": "OnePoint"
+"TaxYear": 2026
+"ListAORKey": "47"
+"ListingURL": "www.realtor.ca/real-estate/29876708/312-251-northfield-drive-e-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "5 Rivers"
+"GeocodeManualYN": true
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"ZoningDescription": "RMU-20"
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-06-09T17:02:24.27Z"
+"ListAgentNationalAssociationId": "1234142"
+"ListOfficeNationalAssociationId": "1349485"
+"Media": array:40 [
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]
]
+"DaysOnMarket": 14
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29876708')"
+"ID": "1510935"
}
]
+success: true
+page_size: 9
+page_count: 7
+count: 57
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
]