array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29143240/Property?$select=ALL&$top=20&$filter=ListingKey eq 29143240&$expand=Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29143240/Property?$select=ALL&$top=20&$filter=ListingKey eq 29143240&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23308
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23310
+post_id: "449247"
+post_author: 1
+"ListingKey": "29143240"
+"ListingId": "40790704"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-27T19:45:34Z"
+"RFModificationTimestamp": "2025-11-27T20:15:52Z"
+"ListPrice": 1995000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 7.0
+"LotSizeArea": 0
+"LivingArea": 6334.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K1Z3"
+"UnparsedAddress": "348 OLD STONE Road, Waterloo, Ontario N2K1Z3"
+"Coordinates": array:2 [
0 => -80.5114374
1 => 43.5026033
]
+"Latitude": 43.5026033
+"Longitude": -80.5114374
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "A Home With Possibilities as Big as the Space It Offers. A home that fits your life, whether you have a large family, blended family, occasional long-term guests, or simply want room to breathe. 348 Old Stone Rd offers something rare in today’s market. Set on one of Waterloo’s most admired streets in prestigious Colonial Acres, this property delivers 5,000 sq. ft. of beautifully balanced living space wrapped in curb appeal, character, and privacy. One of the most remarkable aspects of this home is the 1,500 sq. ft. main-floor in-law suite, complete with kitchen, living area, bedroom and bath. While this is an incredible setup for multigenerational living, we recognize that not every buyer needs an in-law suite. To help buyers envision every possibility, we’ve created professional renderings, floor plan, and video showcasing how this wing can be transformed into a private luxury primary suite,sprawling rec room and bar, a guest retreat, or Studio. It’s rare to find a home that adapts so seamlessly. A tucked-away bonus room with its own staircase adds more versatility — an ideal teen space, rec room, office, music room, or playroom. The newly redesigned Chervin kitchen is the heart of the home, mixing modern style with warm, timeless elements. Perfect for hosting dinners, slow mornings, and long conversations. Step outside to private peaceful yard surrounded by towering trees. A large garage and workshop complete the exterior offerings. Location, Reputation, and Community in Waterloo’s most established and beloved neighbourhoods — close to trails, parks, the Grand River, top-ranked schools, University of Waterloo, and some of the region’s best golf. Homes on streets like this rarely come available. A Home With Presence. A Home With Options. A Home That Can Grow With You.If you’re looking for something beyond the typical, something with character, scale, and the ability to evolve and adapt to your lifestyle, 348 Old Stone Rd. deserves a visit. (id:62650)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Water softener"
4 => "Central Vacuum"
5 => "Dishwasher"
6 => "Stove"
7 => "Dryer"
8 => "Hood Fan"
9 => "Window Coverings"
10 => "Garage door opener"
11 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:2 [
0 => "Central air conditioning"
1 => "Ductless"
]
+"CreationDate": "2025-11-27T20:15:42.815291+00:00"
+"Directions": "Lexington to Lee, to Old Stone Rd"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stucco"
2 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "4"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:4 [
0 => "Radiant heat"
1 => "Forced air"
2 => "In Floor Heating"
3 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1889883"
+"ListOfficeKey": "274578"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Paved driveway"
1 => "Skylight"
2 => "Automatic Garage Door Opener"
3 => "In-Law Suite"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-27T19:38:38Z"
+"PhotosCount": 36
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-27T19:38:38Z"
+"Stories": "2.0"
+"StreetName": "OLD STONE"
+"StreetNumber": "348"
+"StreetSuffix": "Road"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "15626.35"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/348_old_stone_rd_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:30 [
0 => array:11 [
"RoomKey" => "1541006659"
"RoomType" => "Utility room"
"ListingId" => "40790704"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29143240"
"RoomLength" => null
"RoomDimensions" => "4'5'' x 2'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T19:38:38.3Z"
]
1 => array:11 [
"RoomKey" => "1541006660"
"RoomType" => "Utility room"
"ListingId" => "40790704"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29143240"
"RoomLength" => null
"RoomDimensions" => "7'2'' x 5'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T19:38:38.3Z"
]
2 => array:11 [
"RoomKey" => "1541006661"
"RoomType" => "Storage"
"ListingId" => "40790704"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29143240"
"RoomLength" => null
"RoomDimensions" => "9'7'' x 17'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T19:38:38.31Z"
]
3 => array:11 [
"RoomKey" => "1541006662"
"RoomType" => "Storage"
"ListingId" => "40790704"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29143240"
"RoomLength" => null
"RoomDimensions" => "11'4'' x 24'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T19:38:38.31Z"
]
4 => array:11 [
"RoomKey" => "1541006663"
"RoomType" => "Laundry room"
"ListingId" => "40790704"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29143240"
"RoomLength" => null
"RoomDimensions" => "21'11'' x 7'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T19:38:38.31Z"
]
5 => array:11 [
"RoomKey" => "1541006664"
"RoomType" => "Gym"
"ListingId" => "40790704"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29143240"
"RoomLength" => null
"RoomDimensions" => "12'9'' x 20'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T19:38:38.32Z"
]
6 => array:11 [
"RoomKey" => "1541006665"
"RoomType" => "Cold room"
"ListingId" => "40790704"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29143240"
"RoomLength" => null
"RoomDimensions" => "11'6'' x 4'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T19:38:38.32Z"
]
7 => array:11 [
"RoomKey" => "1541006666"
"RoomType" => "Bedroom"
"ListingId" => "40790704"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29143240"
"RoomLength" => null
"RoomDimensions" => "12'9'' x 9'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T19:38:38.33Z"
]
8 => array:11 [
"RoomKey" => "1541006667"
"RoomType" => "Storage"
"ListingId" => "40790704"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29143240"
"RoomLength" => null
"RoomDimensions" => "8'11'' x 7'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T19:38:38.33Z"
]
9 => array:11 [
"RoomKey" => "1541006668"
"RoomType" => "Loft"
"ListingId" => "40790704"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29143240"
"RoomLength" => null
"RoomDimensions" => "21'11'' x 31'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T19:38:38.34Z"
]
10 => array:11 [
"RoomKey" => "1541006669"
"RoomType" => "Primary Bedroom"
"ListingId" => "40790704"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29143240"
"RoomLength" => null
"RoomDimensions" => "15'1'' x 17'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T19:38:38.34Z"
]
11 => array:11 [
"RoomKey" => "1541006670"
"RoomType" => "Bedroom"
"ListingId" => "40790704"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29143240"
"RoomLength" => null
"RoomDimensions" => "11'11'' x 13'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T19:38:38.34Z"
]
12 => array:11 [
"RoomKey" => "1541006671"
"RoomType" => "Bedroom"
"ListingId" => "40790704"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29143240"
"RoomLength" => null
"RoomDimensions" => "11'11'' x 13'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T19:38:38.35Z"
]
13 => array:11 [
"RoomKey" => "1541006672"
"RoomType" => "Bedroom"
"ListingId" => "40790704"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29143240"
"RoomLength" => null
"RoomDimensions" => "11'10'' x 15'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T19:38:38.35Z"
]
14 => array:11 [
"RoomKey" => "1541006673"
"RoomType" => "4pc Bathroom"
"ListingId" => "40790704"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29143240"
"RoomLength" => null
"RoomDimensions" => "9'11'' x 8'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T19:38:38.36Z"
]
15 => array:11 [
"RoomKey" => "1541006674"
"RoomType" => "4pc Bathroom"
"ListingId" => "40790704"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29143240"
"RoomLength" => null
"RoomDimensions" => "11'4'' x 10'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T19:38:38.37Z"
]
16 => array:11 [
"RoomKey" => "1541006675"
"RoomType" => "Utility room"
"ListingId" => "40790704"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29143240"
"RoomLength" => null
"RoomDimensions" => "7'5'' x 5'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T19:38:38.37Z"
]
17 => array:11 [
"RoomKey" => "1541006676"
"RoomType" => "Storage"
"ListingId" => "40790704"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29143240"
"RoomLength" => null
"RoomDimensions" => "12'4'' x 11'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T19:38:38.38Z"
]
18 => array:11 [
"RoomKey" => "1541006677"
"RoomType" => "Bedroom"
"ListingId" => "40790704"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29143240"
"RoomLength" => null
"RoomDimensions" => "12'9'' x 10'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T19:38:38.38Z"
]
19 => array:11 [
"RoomKey" => "1541006678"
"RoomType" => "Mud room"
"ListingId" => "40790704"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29143240"
"RoomLength" => null
"RoomDimensions" => "13'3'' x 16'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T19:38:38.39Z"
]
20 => array:11 [
"RoomKey" => "1541006679"
"RoomType" => "Living room"
"ListingId" => "40790704"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29143240"
"RoomLength" => null
"RoomDimensions" => "13'3'' x 16'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T19:38:38.39Z"
]
21 => array:11 [
"RoomKey" => "1541006680"
"RoomType" => "Kitchen"
"ListingId" => "40790704"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29143240"
"RoomLength" => null
"RoomDimensions" => "16'7'' x 20'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T19:38:38.4Z"
]
22 => array:11 [
"RoomKey" => "1541006681"
"RoomType" => "Kitchen"
"ListingId" => "40790704"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29143240"
"RoomLength" => null
"RoomDimensions" => "12'8'' x 19'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T19:38:38.4Z"
]
23 => array:11 [
"RoomKey" => "1541006682"
"RoomType" => "Foyer"
"ListingId" => "40790704"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29143240"
"RoomLength" => null
"RoomDimensions" => "11'6'' x 12'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T19:38:38.4Z"
]
24 => array:11 [
"RoomKey" => "1541006683"
"RoomType" => "Family room"
"ListingId" => "40790704"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29143240"
"RoomLength" => null
"RoomDimensions" => "13'5'' x 31'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T19:38:38.41Z"
]
25 => array:11 [
"RoomKey" => "1541006684"
"RoomType" => "Dining room"
"ListingId" => "40790704"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29143240"
"RoomLength" => null
"RoomDimensions" => "8'4'' x 15'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T19:38:38.41Z"
]
26 => array:11 [
"RoomKey" => "1541006685"
"RoomType" => "Bonus Room"
"ListingId" => "40790704"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29143240"
"RoomLength" => null
"RoomDimensions" => "22'0'' x 10'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T19:38:38.42Z"
]
27 => array:11 [
"RoomKey" => "1541006686"
"RoomType" => "Bedroom"
"ListingId" => "40790704"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29143240"
"RoomLength" => null
"RoomDimensions" => "12'9'' x 11'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T19:38:38.42Z"
]
28 => array:11 [
"RoomKey" => "1541006687"
"RoomType" => "3pc Bathroom"
"ListingId" => "40790704"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29143240"
"RoomLength" => null
"RoomDimensions" => "6'7'' x 8'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T19:38:38.43Z"
]
29 => array:11 [
"RoomKey" => "1541006688"
"RoomType" => "3pc Bathroom"
"ListingId" => "40790704"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29143240"
"RoomLength" => null
"RoomDimensions" => "7'11'' x 11'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T19:38:38.43Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29143240/348-old-stone-road-waterloo"
+"ParkingTotal": 14
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "SR3"
+"BedroomsAboveGrade": 6
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 135.0
+"AboveGradeFinishedArea": 4933
+"BelowGradeFinishedArea": 1401
+"OriginalEntryTimestamp": "2025-11-27T19:38:38.11Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"Media": array:36 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6342973709"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143240/3a881c8afc6fe1811bfda5737463b0f1.webp"
"MediaSize" => 79788
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143240/thumbnail-3a881c8afc6fe1811bfda5737463b0f1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790704"
"ResourceRecordKey" => "29143240"
"ModificationTimestamp" => "2025-11-27T19:38:38.12Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6342973866"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143240/5e4e05d1de229a075aaafc7f23a8e8b3.webp"
"MediaSize" => 82049
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143240/thumbnail-5e4e05d1de229a075aaafc7f23a8e8b3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790704"
"ResourceRecordKey" => "29143240"
"ModificationTimestamp" => "2025-11-27T19:38:38.12Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6342973954"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143240/5429675f264ae3e3d497525f3d8efc83.webp"
"MediaSize" => 70032
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143240/thumbnail-5429675f264ae3e3d497525f3d8efc83.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790704"
"ResourceRecordKey" => "29143240"
"ModificationTimestamp" => "2025-11-27T19:38:38.12Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6342974008"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143240/daa5da0bee083847e2045488dad49c30.webp"
"MediaSize" => 196558
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143240/thumbnail-daa5da0bee083847e2045488dad49c30.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790704"
"ResourceRecordKey" => "29143240"
"ModificationTimestamp" => "2025-11-27T19:38:38.12Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6342974038"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143240/ac00f2da284d639fafc6027d41f228d0.webp"
"MediaSize" => 84587
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143240/thumbnail-ac00f2da284d639fafc6027d41f228d0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790704"
"ResourceRecordKey" => "29143240"
"ModificationTimestamp" => "2025-11-27T19:38:38.12Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6342974076"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143240/3cf74832ef5f3879a6952bfdf3503335.webp"
"MediaSize" => 84843
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143240/thumbnail-3cf74832ef5f3879a6952bfdf3503335.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790704"
"ResourceRecordKey" => "29143240"
"ModificationTimestamp" => "2025-11-27T19:38:38.12Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6342974122"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143240/55eaefc12efa0fd6ec0b8193f9c2ab61.webp"
"MediaSize" => 83534
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143240/thumbnail-55eaefc12efa0fd6ec0b8193f9c2ab61.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790704"
"ResourceRecordKey" => "29143240"
"ModificationTimestamp" => "2025-11-27T19:38:38.12Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6342974168"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143240/5047d6d245d1b62640b85eed2850eceb.webp"
"MediaSize" => 60696
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143240/thumbnail-5047d6d245d1b62640b85eed2850eceb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790704"
"ResourceRecordKey" => "29143240"
"ModificationTimestamp" => "2025-11-27T19:38:38.12Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6342974221"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143240/848730be7a3c6a25d3693881ea1c8ab3.webp"
"MediaSize" => 49018
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143240/thumbnail-848730be7a3c6a25d3693881ea1c8ab3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790704"
"ResourceRecordKey" => "29143240"
"ModificationTimestamp" => "2025-11-27T19:38:38.12Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6342974242"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143240/51299ceefb57e56b9953bf095a1c30ec.webp"
"MediaSize" => 71879
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143240/thumbnail-51299ceefb57e56b9953bf095a1c30ec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790704"
"ResourceRecordKey" => "29143240"
"ModificationTimestamp" => "2025-11-27T19:38:38.12Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6342974290"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143240/683cfcdb6bd3e670332a950b27e48cc2.webp"
"MediaSize" => 73469
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143240/thumbnail-683cfcdb6bd3e670332a950b27e48cc2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790704"
"ResourceRecordKey" => "29143240"
"ModificationTimestamp" => "2025-11-27T19:38:38.12Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6342974305"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143240/c389fb7d6901cacc2a9ad4f227f29fb1.webp"
"MediaSize" => 47094
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143240/thumbnail-c389fb7d6901cacc2a9ad4f227f29fb1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790704"
"ResourceRecordKey" => "29143240"
"ModificationTimestamp" => "2025-11-27T19:38:38.12Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6342974336"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143240/841f25cf6409d66586d0c2feef445f75.webp"
"MediaSize" => 95394
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143240/thumbnail-841f25cf6409d66586d0c2feef445f75.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790704"
"ResourceRecordKey" => "29143240"
"ModificationTimestamp" => "2025-11-27T19:38:38.12Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6342974363"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143240/40a7dc49e81aa00703db9c5585862b27.webp"
"MediaSize" => 78272
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143240/thumbnail-40a7dc49e81aa00703db9c5585862b27.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790704"
"ResourceRecordKey" => "29143240"
"ModificationTimestamp" => "2025-11-27T19:38:38.12Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6342974376"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143240/793b495845a7893b98896c57f90a6d58.webp"
"MediaSize" => 69050
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143240/thumbnail-793b495845a7893b98896c57f90a6d58.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790704"
"ResourceRecordKey" => "29143240"
"ModificationTimestamp" => "2025-11-27T19:38:38.12Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6342974403"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143240/3f76cc4672e3bab2c66d65fed1e77dee.webp"
"MediaSize" => 50779
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143240/thumbnail-3f76cc4672e3bab2c66d65fed1e77dee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790704"
"ResourceRecordKey" => "29143240"
"ModificationTimestamp" => "2025-11-27T19:38:38.12Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6342974438"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143240/fb3d6b2897014259c0dc5d0d1dbaa80d.webp"
"MediaSize" => 39029
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143240/thumbnail-fb3d6b2897014259c0dc5d0d1dbaa80d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790704"
"ResourceRecordKey" => "29143240"
"ModificationTimestamp" => "2025-11-27T19:38:38.12Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6342974454"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143240/4ba152f5b8b3d41415b2c54786710607.webp"
"MediaSize" => 70471
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143240/thumbnail-4ba152f5b8b3d41415b2c54786710607.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790704"
"ResourceRecordKey" => "29143240"
"ModificationTimestamp" => "2025-11-27T19:38:38.12Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6342974472"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143240/8d01af329e438b4526999058838856a2.webp"
"MediaSize" => 84308
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143240/thumbnail-8d01af329e438b4526999058838856a2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790704"
"ResourceRecordKey" => "29143240"
"ModificationTimestamp" => "2025-11-27T19:38:38.12Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6342974498"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143240/cf7dda66e4b0ba26ea35ae2e56a0977e.webp"
"MediaSize" => 135815
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143240/thumbnail-cf7dda66e4b0ba26ea35ae2e56a0977e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40790704"
"ResourceRecordKey" => "29143240"
"ModificationTimestamp" => "2025-11-27T19:38:38.12Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6342974521"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143240/357a8592183991c55af9118d14dfcfca.webp"
"MediaSize" => 76107
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143240/thumbnail-357a8592183991c55af9118d14dfcfca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790704"
"ResourceRecordKey" => "29143240"
"ModificationTimestamp" => "2025-11-27T19:38:38.12Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6342974547"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143240/7ac7939cf6a7c3453799dde8c96d1186.webp"
"MediaSize" => 34776
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143240/thumbnail-7ac7939cf6a7c3453799dde8c96d1186.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790704"
"ResourceRecordKey" => "29143240"
"ModificationTimestamp" => "2025-11-27T19:38:38.12Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6342974575"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143240/26b8af7a775d6a405622f67392c597ad.webp"
"MediaSize" => 40621
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143240/thumbnail-26b8af7a775d6a405622f67392c597ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790704"
"ResourceRecordKey" => "29143240"
"ModificationTimestamp" => "2025-11-27T19:38:38.12Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6342974614"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143240/40722b7c0700c1a2e85c2ada9e566ead.webp"
"MediaSize" => 202519
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143240/thumbnail-40722b7c0700c1a2e85c2ada9e566ead.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790704"
"ResourceRecordKey" => "29143240"
"ModificationTimestamp" => "2025-11-27T19:38:38.12Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6342974640"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143240/918278d23190007e15f0311b382b7b6f.webp"
"MediaSize" => 47525
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143240/thumbnail-918278d23190007e15f0311b382b7b6f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790704"
"ResourceRecordKey" => "29143240"
"ModificationTimestamp" => "2025-11-27T19:38:38.12Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6342974657"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143240/2b3d8bf5e8ca7e9365f33ee1422da32e.webp"
"MediaSize" => 83798
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143240/thumbnail-2b3d8bf5e8ca7e9365f33ee1422da32e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790704"
"ResourceRecordKey" => "29143240"
"ModificationTimestamp" => "2025-11-27T19:38:38.12Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6342974664"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143240/e3371c98189c3eb2ce48029a4e65d0f8.webp"
"MediaSize" => 73390
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143240/thumbnail-e3371c98189c3eb2ce48029a4e65d0f8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790704"
"ResourceRecordKey" => "29143240"
"ModificationTimestamp" => "2025-11-27T19:38:38.12Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6342974685"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143240/5fa29288e999c8948347d27d856370b5.webp"
"MediaSize" => 80800
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143240/thumbnail-5fa29288e999c8948347d27d856370b5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790704"
"ResourceRecordKey" => "29143240"
"ModificationTimestamp" => "2025-11-27T19:38:38.12Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6342974692"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143240/3c3e879a6e7d6ad695096ca4ec2ffd3d.webp"
"MediaSize" => 83153
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143240/thumbnail-3c3e879a6e7d6ad695096ca4ec2ffd3d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790704"
"ResourceRecordKey" => "29143240"
"ModificationTimestamp" => "2025-11-27T19:38:38.12Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6342974710"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143240/67d0bbdea814147bb155b314f515a575.webp"
"MediaSize" => 65434
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143240/thumbnail-67d0bbdea814147bb155b314f515a575.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790704"
"ResourceRecordKey" => "29143240"
"ModificationTimestamp" => "2025-11-27T19:38:38.12Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6342974736"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143240/9740fb92e6965ab1dd11091b6d425b7e.webp"
"MediaSize" => 82420
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143240/thumbnail-9740fb92e6965ab1dd11091b6d425b7e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790704"
"ResourceRecordKey" => "29143240"
"ModificationTimestamp" => "2025-11-27T19:38:38.12Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6342974777"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143240/53aa5de7b29922e5a687272675a6843d.webp"
"MediaSize" => 194908
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143240/thumbnail-53aa5de7b29922e5a687272675a6843d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790704"
"ResourceRecordKey" => "29143240"
"ModificationTimestamp" => "2025-11-27T19:38:38.12Z"
]
32 => array:13 [
"Order" => 32
"MediaKey" => "6342974802"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143240/019ce44eab80e2f520cc023319fa5bb0.webp"
"MediaSize" => 72085
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143240/thumbnail-019ce44eab80e2f520cc023319fa5bb0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790704"
"ResourceRecordKey" => "29143240"
"ModificationTimestamp" => "2025-11-27T19:38:38.12Z"
]
33 => array:13 [
"Order" => 33
"MediaKey" => "6342974825"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143240/1c1f6b671a9b1e7c3cb552eebedd6c84.webp"
"MediaSize" => 69653
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143240/thumbnail-1c1f6b671a9b1e7c3cb552eebedd6c84.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790704"
"ResourceRecordKey" => "29143240"
"ModificationTimestamp" => "2025-11-27T19:38:38.12Z"
]
34 => array:13 [
"Order" => 34
"MediaKey" => "6342974836"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143240/57d61bee369cb5ab84313e35b0203b5f.webp"
"MediaSize" => 76734
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143240/thumbnail-57d61bee369cb5ab84313e35b0203b5f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790704"
"ResourceRecordKey" => "29143240"
"ModificationTimestamp" => "2025-11-27T19:38:38.12Z"
]
35 => array:13 [
"Order" => 35
"MediaKey" => "6342974859"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143240/7bc6e9d4df9ef50588cdaccec187c2e5.webp"
"MediaSize" => 92900
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143240/thumbnail-7bc6e9d4df9ef50588cdaccec187c2e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790704"
"ResourceRecordKey" => "29143240"
"ModificationTimestamp" => "2025-11-27T19:38:38.12Z"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29143240')"
+"ID": "449247"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 274578/Office?$select=ALL&$top=10&$filter=OfficeKey eq 274578&$expand=Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 274578/Office?$select=ALL&$top=10&$filter=OfficeKey eq 274578&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25157
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25159
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "Keller Williams Home Group Realty, Brokerage"
+"OfficeEmail": null
+"OfficePhone": "226-780-0202"
+"OfficeMlsId": "KW22"
+"ModificationTimestamp": "2025-08-19T15:50:12Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "274578"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "5 Edinburgh Road South, Unit 1C"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Guelph"
+"OfficePostalCode": "N1H5N"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone - Hamilton-Burlington"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1256495"
+"OriginalEntryTimestamp": "2014-01-15T14:28:00Z"
+"Media": array:1 [
0 => array:10 [
"Order" => 1
"MediaKey" => "6130797807"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/office-274578/10777f5ddd38a7ed3ef9319ca3466895.webp"
"ResourceName" => "Office"
"MediaCategory" => "Office Logo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "KW22"
"ResourceRecordKey" => "274578"
"ModificationTimestamp" => "2025-08-19T15:27:00Z"
]
]
+"OfficeFax": "226-780-0203"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "7979"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "274578"
"SocialMediaUrlOrId" => "http://homegrouprealty.ca/"
"ModificationTimestamp" => "2025-08-19T15:27:00Z"
]
]
+"FranchiseNationalAssociationId": "1230713"
+"OfficeBrokerNationalAssociationId": "1255978"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('274578')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1889883/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1889883&$expand=Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1889883/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1889883&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25162
+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 29143240" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24752
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29143240/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29143240&$expand=Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29143240/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29143240&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24732
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29143240 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5114374 43.5026033)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29143240 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5114374 43.5026033)) le 2000m&$expand=Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29143240 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5114374 43.5026033)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29143240 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5114374 43.5026033)) le 2000m&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25003
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24604
+post_id: "454818"
+post_author: 1
+"ListingKey": "29151028"
+"ListingId": "40791491"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-01T19:00:52Z"
+"RFModificationTimestamp": "2025-12-01T19:53:58Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1400.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3Y8"
+"UnparsedAddress": "540 MARINER Drive, Waterloo, Ontario N2K3Y8"
+"Coordinates": array:2 [
0 => -80.507857
1 => 43.5060424
]
+"Latitude": 43.5060424
+"Longitude": -80.507857
+"YearBuilt": 1997
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "A Beautiful 3 bed , 3.5 bath Freehold Townhome backing on green space with fully finished basement available for sale in Eastbridge neighborhood of Waterloo! Upon entrance through the foyer, you will find open concept main floor with spacious kitchen featuring plenty of kitchen cabinets, breakfast bar, glass tile backsplash, a powder room and a bright and spacious living room. Second floor features a huge master bedroom with 4 pc ensuite bathroom and huge closet. 2 more good sized bedrooms with huge closets and another 4 pc family bathroom. Very spacious Fully finished basement with rec room and full bath. Total 2 parking spaces - Single car garage and an asphalt private single driveway. Conveniently located close to public schools, short walk to bus stop, parks, few minutes drive to Conestoga mall, Restaurants, Highway 85, Conestoga College,University of Waterloo, Wilfrid Laurier University And Other Major Amenities. (id:62650)"
+"Appliances": array:2 [
0 => "Water softener"
1 => "Central Vacuum"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-01T18:41:26.600917+00:00"
+"Directions": "Eastbridge Blvd. & Mariner Drive."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2000528"
+"ListOfficeKey": "291992"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Backs on greenbelt"
1 => "Paved driveway"
2 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0"
+"PhotosChangeTimestamp": "2025-12-01T17:30:24Z"
+"PhotosCount": 1
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-01T18:49:20Z"
+"Stories": "2.0"
+"StreetName": "MARINER"
+"StreetNumber": "540"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "3782.5"
+"Utilities": array:1 [
0 => "Cable"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1543249144"
"RoomType" => "4pc Bathroom"
"ListingId" => "40791491"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29151028"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-01T18:49:20.85Z"
]
1 => array:11 [
"RoomKey" => "1543249145"
"RoomType" => "4pc Bathroom"
"ListingId" => "40791491"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29151028"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-01T18:49:20.86Z"
]
2 => array:11 [
"RoomKey" => "1543249146"
"RoomType" => "Bedroom"
"ListingId" => "40791491"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29151028"
"RoomLength" => null
"RoomDimensions" => "7'8'' x 10'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-01T18:49:20.86Z"
]
3 => array:11 [
"RoomKey" => "1543249147"
"RoomType" => "Bedroom"
"ListingId" => "40791491"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29151028"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 11'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-01T18:49:20.87Z"
]
4 => array:11 [
"RoomKey" => "1543249148"
"RoomType" => "Primary Bedroom"
"ListingId" => "40791491"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29151028"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 18'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-01T18:49:20.87Z"
]
5 => array:11 [
"RoomKey" => "1543249149"
"RoomType" => "2pc Bathroom"
"ListingId" => "40791491"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29151028"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-01T18:49:20.88Z"
]
6 => array:11 [
"RoomKey" => "1543249150"
"RoomType" => "Kitchen"
"ListingId" => "40791491"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29151028"
"RoomLength" => null
"RoomDimensions" => "6'6'' x 8'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-01T18:49:20.88Z"
]
7 => array:11 [
"RoomKey" => "1543249151"
"RoomType" => "Living room/Dining room"
"ListingId" => "40791491"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29151028"
"RoomLength" => null
"RoomDimensions" => "12'6'' x 18'0''"
…3
]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29151028/540-mariner-drive-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "MD3"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 22.0
+"AboveGradeFinishedArea": 1400
+"OriginalEntryTimestamp": "2025-12-01T17:30:24.07Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"Media": array:1 [
0 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29151028')"
+"ID": "454818"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24999
+post_id: "454669"
+post_author: 1
+"ListingKey": "29150063"
+"ListingId": "40791159"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-01T13:35:16Z"
+"RFModificationTimestamp": "2025-12-01T17:43:38Z"
+"ListPrice": 450000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1119.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J4T3"
+"UnparsedAddress": "55 BLUE SPRINGS Drive Unit# 706, Waterloo, Ontario N2J4T3"
+"Coordinates": array:2 [
0 => -80.5225571
1 => 43.4871516
]
+"Latitude": 43.4871516
+"Longitude": -80.5225571
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Discover tranquil, sophisticated condo living at The Atriums. Nestled in a peaceful setting, you are surrounded by scenic trails yet minutes from major conveniences: Conestoga Mall, the LRT, prestigious Universities, and quick access to the expressway. This unit is a stunningly updated, bright, and spacious retreat. The gorgeous open-concept kitchen anchors the living space, featuring quartz counters, a tiled backsplash, built-in pantry, oversized pot drawers, soft-close cabinets, and high-end stainless steel appliances. Modern flooring, contemporary fixtures, and designer decor elevate the entire unit. Enjoy an abundance of natural light and wonderful forest views through the large windows. This sought-after unit offers 2 bedrooms, 2 full updated bathrooms, convenient in-suite laundry, and a storage locker. A rare find, it includes TWO owned parking spaces! Upgrades abound, including new laminate flooring and LED pot lights throughout. The expansive living/dining area is perfect for entertaining and family gatherings. The primary bedroom boasts an updated 4-piece ensuite and a double closet walk-through. The building's amenities enhance your lifestyle: controlled entry, library, workshop, underground parking, bicycle storage, a fantastic rooftop lounge/sun deck, two party rooms with full facilities, and a dedicated Guest Suite for visitors. Don't miss out on this exceptional opportunity! Call your agent today to schedule your private viewing. Note some photos are virtually staged. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "730.84"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Property Management"
2 => "Water"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-01T17:43:24.616911+00:00"
+"Directions": "King St N to Blue Springs Dr, turn right into ""The Atriums"", visitor parking is above the parking garage (stay right). From the parking lot, take the stairs down to the main front entrance."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564578"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Visual exposure"
1 => "Paved driveway"
]
+"ParkingFeatures": array:3 [
0 => "Underground"
1 => "Covered"
2 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2025-12-01T13:29:27Z"
+"PhotosCount": 46
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-01T13:29:27Z"
+"Stories": "1.0"
+"StreetName": "BLUE SPRINGS"
+"StreetNumber": "55"
+"StreetSuffix": "Drive"
+"SubdivisionName": "116 - Glenridge/Lincoln Heights"
+"TaxAnnualAmount": "3195"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/55_blue_springs_dr_706_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"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": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29150063/55-blue-springs-drive-unit-706-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Guest Suite"
1 => "Party Room"
]
+"ZoningDescription": "GR"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1119
+"OriginalEntryTimestamp": "2025-12-01T13:29:27.53Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"Media": array:46 [
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29150063')"
+"ID": "454669"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25014
+post_id: "451060"
+post_author: 1
+"ListingKey": "29146143"
+"ListingId": "X12585240"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-28T18:31:01Z"
+"RFModificationTimestamp": "2025-11-28T19:04:54Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0G9"
+"UnparsedAddress": "322 - 251 NORTHFIELD DRIVE E, Waterloo, Ontario N2K0G9"
+"Coordinates": array:2 [
0 => -80.521738
1 => 43.509974
]
+"Latitude": 43.509974
+"Longitude": -80.521738
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Step into the realm of contemporary sophistication with this stylish 2-bedroom, 2-bathroom condominium, ideally positioned near all conveniences and mere moments from the highway, catering perfectly to commuters. This modern space exudes an irresistible charm, accentuated by its underground parking, ensuring ease and safety for residents. Meticulously crafted, this unit offers not just a residence but a lifestyle. The sleek kitchen and bathroom are adorned with the latest fixtures and finishes, evoking an ambiance of refined elegance. The bedroom serves as a tranquil sanctuary, while the impeccably designed bathroom boasts contemporary elements. Adding to the appeal, the unit includes both an underground parking spot and an extra storage locker. The balcony provides a secluded outdoor retreat, ideal for relishing morning coffee or captivating sunsets. Moreover, revel in the convenience of an in-suite laundry, simplifying day-to-day living. Stay fit in the well equipped gym, unwind in the stylish lounge area, or boost productivity in the dedicated office space - all within the comfort of your own residence. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-28T19:04:34.760076+00:00"
+"Directions": "Northfield Dr E & Bridge St W"
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Stone"
]
+"FireplaceYN": true
+"Flooring": array:2 [
0 => "Laminate"
1 => "Carpeted"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2080076"
+"ListOfficeKey": "286296"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2025-11-28T18:00:53Z"
+"PhotosCount": 42
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-28T18:00:53Z"
+"StreetDirSuffix": "East"
+"StreetName": "Northfield"
+"StreetNumber": "251"
+"StreetSuffix": "Drive"
+"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"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29146143/322-251-northfield-drive-e-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2141698"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Waterloo Standard Condominium Corporation"
+"CoListAgentKey2": "2182290"
+"CoListOfficeKey": "286296"
+"GeocodeManualYN": false
+"TotalActualRent": 2450
+"BuildingFeatures": array:3 [
0 => "Exercise Centre"
1 => "Party Room"
2 => "Visitor Parking"
]
+"CoListOfficeKey2": "286296"
+"LivingAreaMaximum": 899
+"LivingAreaMinimum": 800
+"BedroomsAboveGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2025-11-28T18:00:53.78Z"
+"MapCoordinateVerifiedYN": false
+"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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29146143')"
+"ID": "451060"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25000
+post_id: "450704"
+post_author: 1
+"ListingKey": "29145460"
+"ListingId": "X12584864"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-28T16:20:43Z"
+"RFModificationTimestamp": "2025-11-28T16:37:58Z"
+"ListPrice": 1995000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K1Z3"
+"UnparsedAddress": "348 OLD STONE ROAD, Waterloo, Ontario N2K1Z3"
+"Coordinates": array:2 [
0 => -80.5114497
1 => 43.5023835
]
+"Latitude": 43.5023835
+"Longitude": -80.5114497
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "OnePoint Association of REALTORS®"
+"PublicRemarks": "A Home With Possibilities as Big as the Space It Offers. A home that fits your life, whether you have a large family, blended family, occasional long-term guests, or simply want room to breathe. 348 Old Stone Rd offers something rare in today's market. Set on one of Waterloo's most admired streets in prestigious Colonial Acres, this property delivers 5,000 sq. ft. of beautifully balanced living space wrapped in curb appeal, character, and privacy. One of the most remarkable aspects of this home is the 1,500 sq. ft. main-floor in-law suite, complete with kitchen, living area, bedroom and bath. While this is an incredible setup for multigenerational living, we recognize that not every buyer needs an in-law suite. To help buyers envision every possibility, we've created professional renderings, floor plan, and video showcasing how this wing can be transformed into a private luxury primary suite,sprawling rec room and bar, a guest retreat, or Studio. It's rare to find a home that adapts so seamlessly. A tucked-away bonus room with its own staircase adds more versatility - an ideal teen space, rec room, office, music room, or playroom. The newly redesigned Chervin kitchen is the heart of the home, mixing modern style with warm, timeless elements. Perfect for hosting dinners, slow mornings, and long conversations. Step outside to private peaceful yard surrounded by towering trees. A large garage and workshop complete the exterior offerings. Location, Reputation, and Community in Waterloo's most established and beloved neighbourhoods - close to trails, parks, the Grand River, top-ranked schools, University of Waterloo, and some of the region's best golf. Homes on streets like this rarely come available. A Home With Presence. A Home With Options. A Home That Can Grow With You.If you're looking for something beyond the typical, something with character, scale, and the ability to evolve and adapt to your lifestyle, 348 Old Stone Rd. deserves a visit. (id:62650)"
+"Appliances": array:13 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Hood Fan"
9 => "Window Coverings"
10 => "Garage door opener"
11 => "Garage door opener remote(s)"
12 => "Water Heater"
]
+"Basement": array:1 [
0 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-28T16:37:40.228806+00:00"
+"Directions": "Cross Streets: Lee & Old Stone Rd. ** Directions: Lexington to Lee, to Old Stone Rd."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"FireplaceYN": true
+"FireplacesTotal": "4"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2240105"
+"ListOfficeKey": "284058"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In-Law Suite"
]
+"LotSizeDimensions": "135 x 137 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-11-28T16:05:31Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-28T16:05:31Z"
+"Stories": "2.0"
+"StreetName": "Old Stone"
+"StreetNumber": "348"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "15626.35"
+"VirtualTourURLUnbranded": "https://youriguide.com/348_old_stone_rd_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:28 [
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]
21 => array:11 [ …11]
22 => array:11 [ …11]
23 => array:11 [ …11]
24 => array:11 [ …11]
25 => array:11 [ …11]
26 => array:11 [ …11]
27 => array:11 [ …11]
]
+"ListAOR": "OnePoint"
+"ListAORKey": "47"
+"ListingURL": "www.realtor.ca/real-estate/29145460/348-old-stone-road-waterloo"
+"ParkingTotal": 14
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 5000
+"LivingAreaMinimum": 3500
+"ZoningDescription": "SR3"
+"BedroomsAboveGrade": 6
+"FrontageLengthNumeric": 135.0
+"OriginalEntryTimestamp": "2025-11-28T16:05:31.77Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29145460')"
+"ID": "450704"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24995
+post_id: "446901"
+post_author: 1
+"ListingKey": "29139754"
+"ListingId": "X12579244"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T20:06:03Z"
+"RFModificationTimestamp": "2025-11-26T23:42:30Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J3Y3"
+"UnparsedAddress": "334 DALE CRESCENT, Waterloo, Ontario N2J3Y3"
+"Coordinates": array:2 [
0 => -80.5083195
1 => 43.4860722
]
+"Latitude": 43.4860722
+"Longitude": -80.5083195
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Extremely Clean Detached Home. 3 Bedrooms Sparkling Hardwood Floors, Garage, 5 Appliances, HUGE Back Yard! University Ave E. near Hwy 85 Conestoga Parkway, Waterloo. 3 FREE PARKING INCLUDED!VERY LARGE OPEN CONCEPT 3 BEDROOM UNIT *PRIVATE LAUNDRY*. NOTHING SHARED! So many features to list: Professional Property Management - Well Maintained Home and Fast Repairs! Spotless and very well maintained! Hardwood Floors + Hardwood Stairs, Garage with garage door opener + parking for 3 cars total included. 5 Appliances - Fridge, Stove, Dishwasher, Washer, Dryer, Large Kitchen with Large Eating Area, Bright with Large Windows throughout! Huge Back yard with Storage Shed. On very quiet tree lined street with great neighbours. Close to Schools, Parks Shopping, Transit and Highways. YOU MUST SEE THIS HOME TO BELIEVE!!!! ....SPOTLESS - NOTHING TO DO - JUST MOVE IN! No Smoking inside home and no dogs please (noise issue). Looking for clean and responsible tenants. Tenants to pay 50% of utilities. (id:62650)"
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2025-11-26T23:42:15.233841+00:00"
+"Directions": "Cross Streets: University Ave E/Conestoga Par. ** Directions: Turn onto Dale from University avenue."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:1 [
0 => "Hardwood"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Radiant heat"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1941043"
+"ListOfficeKey": "50449"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-11-26T19:58:54Z"
+"PhotosCount": 10
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T19:58:54Z"
+"StreetName": "Dale"
+"StreetNumber": "334"
+"StreetSuffix": "Crescent"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
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]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29139754/334-dale-crescent-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 2495
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2025-11-26T19:58:54.63Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:10 [
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29139754')"
+"ID": "446901"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24612
+post_id: "446181"
+post_author: 1
+"ListingKey": "29139457"
+"ListingId": "X12579086"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-30T18:35:35Z"
+"RFModificationTimestamp": "2025-11-30T18:37:22Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3Z6"
+"UnparsedAddress": "MAIN - 579 WINDJAMMER WAY, Waterloo, Ontario N2K3Z6"
+"Coordinates": array:2 [
0 => -80.5029887
1 => 43.5084069
]
+"Latitude": 43.5084069
+"Longitude": -80.5029887
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Beautiful main-floor unit in Waterloo's highly desirable East Bridge community. Bright open-concept layout with an updated kitchen featuring stone countertops and new appliances. Enjoy a cozy family room with a fireplace and a primary bedroom with a 3-piece ensuite. Private Laundry. Private backyard backing onto a park and school. Minutes to top-rated schools, RIM Park, Conestoga Mall, UW, Conestoga College, and highway access. Double garage and wide driveway, parking 1 on driveway 2 in garage! Tenants pay 80% utilities (id:62650)"
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-26T19:40:52.761761+00:00"
+"Directions": "Eastbridge Blvd"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"Flooring": array:2 [
0 => "Laminate"
1 => "Vinyl"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2023409"
+"ListOfficeKey": "278195"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2025-11-26T19:01:42Z"
+"PhotosCount": 37
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-30T18:19:27Z"
+"Stories": "2.0"
+"StreetName": "Windjammer"
+"StreetNumber": "579"
+"StreetSuffix": "Way"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
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]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29139457/main-579-windjammer-way-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 3000
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2025-11-26T19:01:42.59Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:37 [
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29139457')"
+"ID": "446181"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23322
+post_id: "446183"
+post_author: 1
+"ListingKey": "29139074"
+"ListingId": "40790705"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T18:30:52Z"
+"RFModificationTimestamp": "2025-11-26T18:56:49Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1991.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3Z6"
+"UnparsedAddress": "579 WINDJAMMER Way Unit# Main, Waterloo, Ontario N2K3Z6"
+"Coordinates": array:2 [
0 => -80.5028784
1 => 43.5080285
]
+"Latitude": 43.5080285
+"Longitude": -80.5028784
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Beautiful main-floor unit in Waterloo’s highly desirable East Bridge community. Bright open-concept layout with an updated kitchen featuring stone countertops and new appliances. Enjoy a cozy family room with a fireplace and a primary bedroom with a 3-piece ensuite. PrivauPrivate backyard backing onto a park and school. Minutes to top-rated schools, RIM Park, Conestoga Mall, UW, Conestoga College, and highway access. Double garage and wide driveway included—an ideal place to call home! (id:62650)"
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-26T18:56:33.467036+00:00"
+"Directions": "Eastbridge Blvd"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2129629"
+"ListOfficeKey": "283262"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-26T18:11:43Z"
+"PhotosCount": 37
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T18:11:43Z"
+"Stories": "2.0"
+"StreetName": "WINDJAMMER"
+"StreetNumber": "579"
+"StreetSuffix": "Way"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29139074/579-windjammer-way-unit-main-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 3000
+"ZoningDescription": "R"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 36.0
+"AboveGradeFinishedArea": 1991
+"OriginalEntryTimestamp": "2025-11-26T18:08:41.84Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"Media": array:37 [
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29139074')"
+"ID": "446183"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25001
+post_id: "446184"
+post_author: 1
+"ListingKey": "29138905"
+"ListingId": "40790707"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T17:50:15Z"
+"RFModificationTimestamp": "2025-11-26T18:32:43Z"
+"ListPrice": 1775000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 4544.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3H9"
+"UnparsedAddress": "250 GREY SQUIRREL Place, Waterloo, Ontario N2K3H9"
+"Coordinates": array:2 [
0 => -80.520379
1 => 43.508525
]
+"Latitude": 43.508525
+"Longitude": -80.520379
+"YearBuilt": 1988
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 250 Grey Squirrel Place—an elegant family home tucked along a quiet crescent in one of Waterloo’s most desirable neighbourhoods, Colonial Acres, where warmth, space, and sophistication meet. Set on a rare double lot, this property offers exceptional outdoor space and privacy. The moment you step inside, you’re met with a stunning view of the main floor: a vaulted 14-foot ceiling in the front living room anchored by a wood-burning fireplace and framed by gleaming hardwood floors. A second wood fireplace enhances the cozy atmosphere in the main-level family room, while a dedicated office provides a quiet workspace. The mudroom/laundry room, conveniently located by the garage entrance, adds everyday practicality. The kitchen is designed for connection and function, featuring granite counters, Bosch stove and Miele appliances, and a walkout to the brand-new 2025 tiered wood deck overlooking the double-sized backyard—complete with a sports court, two Honeycrisp apple trees, and a peach tree, offering the perfect space for family play, gardening, or summer entertaining. Upstairs, you’ll find four generous bedrooms, including a serene primary suite with an ensuite, along with a second full washroom. The fully finished basement extends your living space with two additional bedrooms, a three-piece bathroom, and a large recreation room perfect for movie nights or weekend gatherings. With a double-car garage, interlock driveway, and mature trees surrounding the property, every detail speaks to comfort and quality. Ideally located minutes from Uptown Waterloo, the University of Waterloo, and Waterloo Park, with quick access to The Boardwalk, RIM Park, and Grey Silo Golf Course, this home offers the perfect balance of family living and professional convenience. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Gas stove(s)"
5 => "Dishwasher"
6 => "Dryer"
7 => "Microwave"
8 => "Hood Fan"
9 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-26T18:32:38.425964+00:00"
+"Directions": "Deer Run Dr to Grey Squirrel Pl"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceFeatures": array:2 [
0 => "Wood"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2152269"
+"ListOfficeKey": "76789"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-26T17:38:46Z"
+"PhotosCount": 36
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T17:38:46Z"
+"Stories": "2.0"
+"StreetName": "GREY SQUIRREL"
+"StreetNumber": "250"
+"StreetSuffix": "Place"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "9353.85"
+"VirtualTourURLUnbranded": "https://youriguide.com/250_grey_squirrel_pl_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:22 [
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]
21 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29138905/250-grey-squirrel-place-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Alarm system"
]
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 114.0
+"AboveGradeFinishedArea": 2883
+"BelowGradeFinishedArea": 1661
+"OriginalEntryTimestamp": "2025-11-26T17:38:46.01Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"Media": array:36 [
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29138905')"
+"ID": "446184"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25002
+post_id: "444319"
+post_author: 1
+"ListingKey": "29135950"
+"ListingId": "40790469"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-30T21:41:08Z"
+"RFModificationTimestamp": "2025-11-30T21:45:08Z"
+"ListPrice": 1199000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.2
+"LivingArea": 3215.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3J4"
+"UnparsedAddress": "391 STRAWBERRY Crescent, Waterloo, Ontario N2K3J4"
+"Coordinates": array:2 [
0 => -80.4934622
1 => 43.4902953
]
+"Latitude": 43.4902953
+"Longitude": -80.4934622
+"YearBuilt": 1987
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully updated 3-bedroom, 4-bathroom home tucked into one of Waterloo’s most family-friendly neighbourhoods. Inside, you’re greeted by a bright and airy sunken living room with cathedral ceilings, perfect for relaxing or hosting friends. The formal dining room is great for family dinners, and the custom-renovated kitchen (2024) is a true showpiece—with quartz countertops, high-end appliances, and beautiful cabinetry that combine style and function. The family room is cozy yet modern, featuring built-in shelving, a gas fireplace, and an integrated sound system—a perfect spot for movie nights or quiet evenings in. Upstairs, a loft/office offers a flexible space for working or studying from home. The primary bedroom feels like a retreat, complete with a spa-like ensuite (2025). Two additional bedrooms and a refreshed family bathroom (2021) complete the upper level. The finished basement adds even more living space, featuring a built-in bar, 3-piece bathroom, cold cellar, and plenty of room for enjoyment. Step outside to your fully fenced backyard—ideal for summer evenings or weekend gatherings. The double car garage and recent exterior updates (2023) including new siding, eaves, front and garage doors, add curb appeal and convenience. You’re never far from anything here—University Downs Plaza is just around the corner, and Conestoga Mall is only a short drive away for shopping and dining, and nearby parks offering sports fields, trails, playgrounds, and a dog park for outdoor fun. Families will appreciate being close to some of the region’s best schools. With aluminum-clad windows (2014), roof (2016), furnace (2009), A/C (2018), and so many thoughtful updates, this home is move-in ready and made for family living. Everything you need—schools, parks, shops, and community amenities—is just minutes from your doorstep in this welcoming neighbourhood. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Hood Fan"
8 => "Window Coverings"
9 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-26T00:08:34.904068+00:00"
+"Directions": "University Ave E. to Auburn Drive, first left on Strawberry Crescent OR Bridge Street West to Crimson Drive, right on Auburn Drive, right on Strawberry Crescent"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2086058"
+"ListOfficeKey": "103841"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Cul-de-sac"
1 => "Automatic Garage Door Opener"
2 => "Private Yard"
]
+"LotSizeDimensions": "0.2"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-25T19:38:26Z"
+"PhotosCount": 48
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-30T21:29:58Z"
+"Stories": "2.0"
+"StreetName": "STRAWBERRY"
+"StreetNumber": "391"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"TaxAnnualAmount": "6425"
+"VirtualTourURLUnbranded": "https://youriguide.com/391_strawberry_crescent_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:18 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29135950/391-strawberry-crescent-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 60.0
+"AboveGradeFinishedArea": 2176
+"BelowGradeFinishedArea": 1039
+"OriginalEntryTimestamp": "2025-11-25T19:38:25.76Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"Media": array:48 [
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29135950')"
+"ID": "444319"
}
]
+success: true
+page_size: 9
+page_count: 11
+count: 98
+after_key: ""
}
"RF Response Time" => "0.22 seconds"
]
]
