array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29804673 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23360
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23362
+post_id: "1462486"
+post_author: 1
+"ListingKey": "29804673"
+"ListingId": "NB140271"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-31T17:36:08Z"
+"RFModificationTimestamp": "2026-05-31T17:38:09Z"
+"ListPrice": 569900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 4.0
+"LotSizeArea": 11237.52
+"LivingArea": 2791.0
+"BuildingAreaTotal": 0
+"City": "Quispamsis"
+"PostalCode": "E2E0E4"
+"UnparsedAddress": "10 Granite Drive, Quispamsis, New Brunswick E2E0E4"
+"Coordinates": array:2 [
0 => -65.949153
1 => 45.412076
]
+"Latitude": 45.412076
+"Longitude": -65.949153
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Located in a very popular, central Quispamsis neighbourhood, this stunning two-storey home offers space and a layout designed for family living! Featuring 3+1 bedrooms and 4 bathrooms, this home has room for everyone. The bright open concept kitchen and family room create the heart of the home. The main floor also has a designated laundry area, half bath and a separate living room and dining room providing additional space for entertaining or relaxing. Upstairs has two bedrooms, a full bath and a large primary suite with a spacious walk-in closet and a large four piece ensuite bath. The fully finished, walk out basement adds even more flexibility with extra living space, an additional bedroom, and bathroom. Outside, enjoy the convenience of a double car garage and all the benefits of living in one of the areas most desirable neighbourhoods. A fantastic opportunity to own a beautiful family home in Cedar Ridge Park! (id:62650)"
+"BathroomsPartial": 2
+"Cooling": array:1 [
0 => "Heat Pump"
]
+"CreationDate": "2026-05-26T15:41:51.708465+00:00"
+"Directions": "Hampton Road to Autumn to Summer Court/Fairholme to Granite OR Millennium Drive to Concorde to Granite"
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"Flooring": array:2 [
0 => "Hardwood"
1 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Baseboard heaters"
2 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1948403"
+"ListOfficeKey": "269605"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "11237.52"
+"ParcelNumber": "30239198"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-05-26T13:29:58Z"
+"PhotosCount": 45
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-05-31T17:13:34Z"
+"Stories": "2.0"
+"TaxAnnualAmount": "5819.54"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [
"RoomKey" => "1647902029"
"RoomType" => "4pc Bathroom"
"ListingId" => "NB140271"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29804673"
"RoomLength" => null
"RoomDimensions" => "8'6'' x 7'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-05-31T17:13:34.36Z"
]
1 => array:11 [
"RoomKey" => "1647902030"
"RoomType" => "4pc Bathroom"
"ListingId" => "NB140271"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29804673"
"RoomLength" => null
"RoomDimensions" => "8'10'' x 9'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-05-31T17:13:34.36Z"
]
2 => array:11 [
"RoomKey" => "1647902031"
"RoomType" => "Bedroom"
"ListingId" => "NB140271"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29804673"
"RoomLength" => null
"RoomDimensions" => "9'10'' x 11'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-05-31T17:13:34.37Z"
]
3 => array:11 [
"RoomKey" => "1647902032"
"RoomType" => "Bedroom"
"ListingId" => "NB140271"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29804673"
"RoomLength" => null
"RoomDimensions" => "13'1'' x 9'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-05-31T17:13:34.37Z"
]
4 => array:11 [
"RoomKey" => "1647902033"
"RoomType" => "Bedroom"
"ListingId" => "NB140271"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29804673"
"RoomLength" => null
"RoomDimensions" => "22'7'' x 11'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-05-31T17:13:34.37Z"
]
5 => array:11 [
"RoomKey" => "1647902034"
"RoomType" => "Laundry room"
"ListingId" => "NB140271"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29804673"
"RoomLength" => null
"RoomDimensions" => "9'4'' x 7'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-05-31T17:13:34.37Z"
]
6 => array:11 [
"RoomKey" => "1647902035"
"RoomType" => "Living room"
"ListingId" => "NB140271"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29804673"
"RoomLength" => null
"RoomDimensions" => "17'3'' x 11'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-05-31T17:13:34.37Z"
]
7 => array:11 [
"RoomKey" => "1647902036"
"RoomType" => "Dining room"
"ListingId" => "NB140271"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29804673"
"RoomLength" => null
"RoomDimensions" => "9'7'' x 11'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-05-31T17:13:34.37Z"
]
8 => array:11 [
"RoomKey" => "1647902037"
"RoomType" => "Family room"
"ListingId" => "NB140271"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29804673"
"RoomLength" => null
"RoomDimensions" => "12'4'' x 20'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-05-31T17:13:34.37Z"
]
9 => array:11 [
"RoomKey" => "1647902038"
"RoomType" => "Kitchen/Dining room"
"ListingId" => "NB140271"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29804673"
"RoomLength" => null
"RoomDimensions" => "14'0'' x 19'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-05-31T17:13:34.37Z"
]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29804673/10-granite-drive-quispamsis"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 1812
+"OriginalEntryTimestamp": "2026-05-26T13:29:58.03Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1242926"
+"ListOfficeNationalAssociationId": "1243995"
+"Media": array:45 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29804673_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29804673/2fcf8893e1ebd59574737a97d0f66989.webp"
"MediaSize" => 110120
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29804673/thumbnail-2fcf8893e1ebd59574737a97d0f66989.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "NB140271"
"ResourceRecordKey" => "29804673"
"ModificationTimestamp" => "2026-05-26T13:29:58.03Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29804673_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29804673/6715d058ceb5a74721fcaf639af51539.webp"
"MediaSize" => 123335
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29804673/thumbnail-6715d058ceb5a74721fcaf639af51539.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140271"
"ResourceRecordKey" => "29804673"
"ModificationTimestamp" => "2026-05-26T13:29:58.03Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29804673_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29804673/0eeff98768eb145c6ad6db9678dce560.webp"
"MediaSize" => 72701
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29804673/thumbnail-0eeff98768eb145c6ad6db9678dce560.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140271"
"ResourceRecordKey" => "29804673"
"ModificationTimestamp" => "2026-05-26T13:29:58.03Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29804673_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29804673/70935dd3c9ddf9041999eb9390e42966.webp"
"MediaSize" => 77572
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29804673/thumbnail-70935dd3c9ddf9041999eb9390e42966.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140271"
"ResourceRecordKey" => "29804673"
"ModificationTimestamp" => "2026-05-26T13:29:58.03Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29804673_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29804673/520f692f6d29c8de04cf6056eb2791af.webp"
"MediaSize" => 110368
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29804673/thumbnail-520f692f6d29c8de04cf6056eb2791af.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140271"
"ResourceRecordKey" => "29804673"
"ModificationTimestamp" => "2026-05-26T13:29:58.03Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29804673_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29804673/723bc44fc6d6f918874b052469bcb6f7.webp"
"MediaSize" => 98324
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29804673/thumbnail-723bc44fc6d6f918874b052469bcb6f7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140271"
"ResourceRecordKey" => "29804673"
"ModificationTimestamp" => "2026-05-26T13:29:58.03Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29804673_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29804673/bf1441323379feb8de1954ec4bcf74e2.webp"
"MediaSize" => 95627
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29804673/thumbnail-bf1441323379feb8de1954ec4bcf74e2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140271"
"ResourceRecordKey" => "29804673"
"ModificationTimestamp" => "2026-05-26T13:29:58.03Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29804673_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29804673/b1430a35b6c40e31c7c33d9f344aa28b.webp"
"MediaSize" => 99479
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29804673/thumbnail-b1430a35b6c40e31c7c33d9f344aa28b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140271"
"ResourceRecordKey" => "29804673"
"ModificationTimestamp" => "2026-05-26T13:29:58.03Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29804673_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29804673/676c02170d02f863125b5515922e9d9a.webp"
"MediaSize" => 99299
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29804673/thumbnail-676c02170d02f863125b5515922e9d9a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140271"
"ResourceRecordKey" => "29804673"
"ModificationTimestamp" => "2026-05-26T13:29:58.03Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29804673_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29804673/9401a2ea59f7c8b8e98395edf6bb1969.webp"
"MediaSize" => 85832
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29804673/thumbnail-9401a2ea59f7c8b8e98395edf6bb1969.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140271"
"ResourceRecordKey" => "29804673"
"ModificationTimestamp" => "2026-05-26T13:29:58.03Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29804673_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29804673/79c579f046fea58198f77f1c1f0eb208.webp"
"MediaSize" => 85414
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29804673/thumbnail-79c579f046fea58198f77f1c1f0eb208.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140271"
"ResourceRecordKey" => "29804673"
"ModificationTimestamp" => "2026-05-26T13:29:58.03Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29804673_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29804673/7abc60395f31cd4ea7e91c653a6409c6.webp"
"MediaSize" => 72876
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29804673/thumbnail-7abc60395f31cd4ea7e91c653a6409c6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140271"
"ResourceRecordKey" => "29804673"
"ModificationTimestamp" => "2026-05-26T13:29:58.03Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29804673_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29804673/9d28871c588aef4b6549a82647b83783.webp"
"MediaSize" => 77417
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29804673/thumbnail-9d28871c588aef4b6549a82647b83783.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140271"
"ResourceRecordKey" => "29804673"
"ModificationTimestamp" => "2026-05-26T13:29:58.03Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29804673_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29804673/720990de2140c2239fcfea50958fee86.webp"
"MediaSize" => 77204
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29804673/thumbnail-720990de2140c2239fcfea50958fee86.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140271"
"ResourceRecordKey" => "29804673"
"ModificationTimestamp" => "2026-05-26T13:29:58.03Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29804673_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29804673/ffcb5e553e547304a12ee7254b95572c.webp"
"MediaSize" => 87456
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29804673/thumbnail-ffcb5e553e547304a12ee7254b95572c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140271"
"ResourceRecordKey" => "29804673"
"ModificationTimestamp" => "2026-05-26T13:29:58.03Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29804673_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29804673/73f1d303dc164fa22db67bfb5f600dc1.webp"
"MediaSize" => 81021
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29804673/thumbnail-73f1d303dc164fa22db67bfb5f600dc1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140271"
"ResourceRecordKey" => "29804673"
"ModificationTimestamp" => "2026-05-26T13:29:58.03Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29804673_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29804673/aefd204e8b8bfa238578db809c0a0479.webp"
"MediaSize" => 69079
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29804673/thumbnail-aefd204e8b8bfa238578db809c0a0479.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140271"
"ResourceRecordKey" => "29804673"
"ModificationTimestamp" => "2026-05-26T13:29:58.03Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29804673_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29804673/f0a46e9b9cf7982e75fd7672f267ff7b.webp"
"MediaSize" => 73367
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29804673/thumbnail-f0a46e9b9cf7982e75fd7672f267ff7b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140271"
"ResourceRecordKey" => "29804673"
"ModificationTimestamp" => "2026-05-26T13:29:58.03Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29804673_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29804673/fb6cfa4e6070182cfe29205e2515f204.webp"
"MediaSize" => 80053
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29804673/thumbnail-fb6cfa4e6070182cfe29205e2515f204.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140271"
"ResourceRecordKey" => "29804673"
"ModificationTimestamp" => "2026-05-26T13:29:58.03Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29804673_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29804673/891687763158f0a72120c6f38919d0e5.webp"
"MediaSize" => 78458
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29804673/thumbnail-891687763158f0a72120c6f38919d0e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140271"
"ResourceRecordKey" => "29804673"
"ModificationTimestamp" => "2026-05-26T13:29:58.03Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29804673_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29804673/a067a56ebfd35d97489b73197b8bcc93.webp"
"MediaSize" => 72245
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29804673/thumbnail-a067a56ebfd35d97489b73197b8bcc93.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140271"
"ResourceRecordKey" => "29804673"
"ModificationTimestamp" => "2026-05-26T13:29:58.03Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29804673_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29804673/f630614b8edf90844651f0eb023d3581.webp"
"MediaSize" => 87535
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29804673/thumbnail-f630614b8edf90844651f0eb023d3581.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140271"
"ResourceRecordKey" => "29804673"
"ModificationTimestamp" => "2026-05-26T13:29:58.03Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29804673_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29804673/1a3d87eec9a97995a85ab2f895a03121.webp"
"MediaSize" => 89214
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29804673/thumbnail-1a3d87eec9a97995a85ab2f895a03121.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140271"
"ResourceRecordKey" => "29804673"
"ModificationTimestamp" => "2026-05-26T13:29:58.03Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29804673_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29804673/33df5402bfd0fab00a6e4cd13048aa7a.webp"
"MediaSize" => 60524
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29804673/thumbnail-33df5402bfd0fab00a6e4cd13048aa7a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140271"
"ResourceRecordKey" => "29804673"
"ModificationTimestamp" => "2026-05-26T13:29:58.03Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29804673_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29804673/ffba98efe0dae2cccb84740d857c859d.webp"
"MediaSize" => 73458
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29804673/thumbnail-ffba98efe0dae2cccb84740d857c859d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140271"
"ResourceRecordKey" => "29804673"
"ModificationTimestamp" => "2026-05-26T13:29:58.03Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29804673_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29804673/108217a6e95bb261194eb22eafea6411.webp"
"MediaSize" => 73559
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29804673/thumbnail-108217a6e95bb261194eb22eafea6411.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140271"
"ResourceRecordKey" => "29804673"
"ModificationTimestamp" => "2026-05-26T13:29:58.03Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29804673_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29804673/e5f7520f195ff4dc73c4d45ad6dc8e41.webp"
"MediaSize" => 62039
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29804673/thumbnail-e5f7520f195ff4dc73c4d45ad6dc8e41.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140271"
"ResourceRecordKey" => "29804673"
"ModificationTimestamp" => "2026-05-26T13:29:58.03Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29804673_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29804673/5d1ca7d54d76cc05c68c46c00be6d918.webp"
"MediaSize" => 68445
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29804673/thumbnail-5d1ca7d54d76cc05c68c46c00be6d918.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140271"
"ResourceRecordKey" => "29804673"
"ModificationTimestamp" => "2026-05-26T13:29:58.03Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29804673_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29804673/7e2fce10138fad5f541f4c5d04aaed14.webp"
"MediaSize" => 61082
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29804673/thumbnail-7e2fce10138fad5f541f4c5d04aaed14.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140271"
"ResourceRecordKey" => "29804673"
"ModificationTimestamp" => "2026-05-26T13:29:58.03Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29804673_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29804673/8ae7c079d5fbb24d01a52f6635b7d5a7.webp"
"MediaSize" => 57314
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29804673/thumbnail-8ae7c079d5fbb24d01a52f6635b7d5a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140271"
"ResourceRecordKey" => "29804673"
"ModificationTimestamp" => "2026-05-26T13:29:58.03Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29804673_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29804673/0fdd0e2a99e595bc495d161bba94c717.webp"
"MediaSize" => 68445
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29804673/thumbnail-0fdd0e2a99e595bc495d161bba94c717.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140271"
"ResourceRecordKey" => "29804673"
"ModificationTimestamp" => "2026-05-26T13:29:58.03Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29804673_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29804673/9a1486ada23ed733ffc2fedbf6a7ba82.webp"
"MediaSize" => 68254
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29804673/thumbnail-9a1486ada23ed733ffc2fedbf6a7ba82.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140271"
"ResourceRecordKey" => "29804673"
"ModificationTimestamp" => "2026-05-26T13:29:58.03Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29804673_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29804673/bfc3e2bb51b1584d9510b6f35ce65bf8.webp"
"MediaSize" => 79336
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29804673/thumbnail-bfc3e2bb51b1584d9510b6f35ce65bf8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140271"
"ResourceRecordKey" => "29804673"
"ModificationTimestamp" => "2026-05-26T13:29:58.03Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29804673_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29804673/fd502b09edb55fba783bb932d2dee099.webp"
"MediaSize" => 53667
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29804673/thumbnail-fd502b09edb55fba783bb932d2dee099.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140271"
"ResourceRecordKey" => "29804673"
"ModificationTimestamp" => "2026-05-26T13:29:58.03Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29804673_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29804673/97cd8a06b1d8fd8472d1045f74dec63d.webp"
"MediaSize" => 134843
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29804673/thumbnail-97cd8a06b1d8fd8472d1045f74dec63d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140271"
"ResourceRecordKey" => "29804673"
"ModificationTimestamp" => "2026-05-26T13:29:58.03Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29804673_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29804673/ae2ebcc775d07cfd277e9e2686c87427.webp"
"MediaSize" => 131020
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29804673/thumbnail-ae2ebcc775d07cfd277e9e2686c87427.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140271"
"ResourceRecordKey" => "29804673"
"ModificationTimestamp" => "2026-05-26T13:29:58.03Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29804673_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29804673/55151330c15cecaa8515ca514aa48797.webp"
"MediaSize" => 162915
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29804673/thumbnail-55151330c15cecaa8515ca514aa48797.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140271"
"ResourceRecordKey" => "29804673"
"ModificationTimestamp" => "2026-05-26T13:29:58.03Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29804673_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29804673/8c444b150a01f01ec4e8bf09ef7c214b.webp"
"MediaSize" => 174191
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29804673/thumbnail-8c444b150a01f01ec4e8bf09ef7c214b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140271"
"ResourceRecordKey" => "29804673"
"ModificationTimestamp" => "2026-05-26T13:29:58.03Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29804673_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29804673/8aaf9d6ebb13553c9a4077e231fab677.webp"
"MediaSize" => 143170
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29804673/thumbnail-8aaf9d6ebb13553c9a4077e231fab677.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140271"
"ResourceRecordKey" => "29804673"
"ModificationTimestamp" => "2026-05-26T13:29:58.03Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29804673_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29804673/1aab0941af60a5da65346a35dbc8670f.webp"
"MediaSize" => 126043
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29804673/thumbnail-1aab0941af60a5da65346a35dbc8670f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140271"
"ResourceRecordKey" => "29804673"
"ModificationTimestamp" => "2026-05-26T13:29:58.03Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29804673_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29804673/6c2a4e3a11acf546fc61baaa4e0fb8d8.webp"
"MediaSize" => 144235
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29804673/thumbnail-6c2a4e3a11acf546fc61baaa4e0fb8d8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140271"
"ResourceRecordKey" => "29804673"
"ModificationTimestamp" => "2026-05-26T13:29:58.03Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29804673_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29804673/5dd393f5586896c2f8ac1c6231394945.webp"
"MediaSize" => 146579
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29804673/thumbnail-5dd393f5586896c2f8ac1c6231394945.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140271"
"ResourceRecordKey" => "29804673"
"ModificationTimestamp" => "2026-05-26T13:29:58.03Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29804673_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29804673/bb0123c4d0719c75d1e8e07e3fafdefc.webp"
"MediaSize" => 153956
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29804673/thumbnail-bb0123c4d0719c75d1e8e07e3fafdefc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140271"
"ResourceRecordKey" => "29804673"
"ModificationTimestamp" => "2026-05-26T13:29:58.03Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "29804673_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29804673/7c1d727589c2ad09797ff9abfde87326.webp"
"MediaSize" => 143204
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29804673/thumbnail-7c1d727589c2ad09797ff9abfde87326.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140271"
"ResourceRecordKey" => "29804673"
"ModificationTimestamp" => "2026-05-26T13:29:58.03Z"
]
44 => array:13 [
"Order" => 45
"MediaKey" => "29804673_4890_45"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29804673/a6733b30717947012d992d0daf146bfa.webp"
"MediaSize" => 150394
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29804673/thumbnail-a6733b30717947012d992d0daf146bfa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140271"
"ResourceRecordKey" => "29804673"
"ModificationTimestamp" => "2026-05-26T13:29:58.03Z"
]
]
+"DaysOnMarket": 21
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29804673')"
+"ID": "1462486"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 269605" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24811
+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 1948403" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24784
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29804673'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25130
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29804673'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25145
+items: array:2 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25146
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31181212"
+"ListingKey": "29804673"
+"ListingId": "NB140271"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-05-31"
+"OpenHouseStartTime": "2026-05-31T12:00:00Z"
+"OpenHouseEndTime": "2026-05-31T14:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-05-28T12:34:10Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31181212')"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25148
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31207082"
+"ListingKey": "29804673"
+"ListingId": "NB140271"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-05-31"
+"OpenHouseStartTime": "2026-05-31T12:00:00Z"
+"OpenHouseEndTime": "2026-05-31T14:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-05-31T13:19:06Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31207082')"
}
]
+success: true
+page_size: 2
+page_count: 1
+count: 2
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29804673' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-65.949153 45.412076)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25168
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25162
+post_id: "1535647"
+post_author: 1
+"ListingKey": "29908734"
+"ListingId": "NB141592"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T13:20:07Z"
+"RFModificationTimestamp": "2026-06-16T13:44:12Z"
+"ListPrice": 649900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0.278
+"LivingArea": 3472.0
+"BuildingAreaTotal": 0
+"City": "Quispamsis"
+"PostalCode": "E2E0E4"
+"UnparsedAddress": "32 Granite Drive, Quispamsis, New Brunswick E2E0E4"
+"Coordinates": array:2 [
0 => -65.952462
1 => 45.412254
]
+"Latitude": 45.412254
+"Longitude": -65.952462
+"YearBuilt": 2011
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Large 2 storey home! Need room for everyone, everything, and then some? This oversized 2 storey delivers in a big way. With 3 fully finished levels, 4/1 bedrooms, 4 bathrooms, and generously sized rooms throughout, theres no shortage of space to spread out. The private, tree lined backyard offers a peaceful escape, while the attached garage and sought-after family-friendly neighbourhood check all the practical boxes. Located within walking distance to schools and close to everyday amenities, this is the kind of home buyers wait for and wish theyd bought sooner. Bonus: a quick closing is available for those ready to make their move. You wont be disappointed in this one. (id:62783)"
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Heat Pump"
]
+"CreationDate": "2026-06-16T13:44:06.242816+00:00"
+"Directions": "Route 1 to Exit 141 (Millennium Drive). Turn onto Millennium Drive, take a right onto Concorde Drive, and then your first left onto Granite Drive."
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"Flooring": array:4 [
0 => "Laminate"
1 => "Carpeted"
2 => "Ceramic"
3 => "Wood"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Stove"
2 => "Wood"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1993846"
+"ListOfficeKey": "279450"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Treed"
1 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "0.278"
+"ParcelNumber": "30272017"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-16T13:14:24Z"
+"PhotosCount": 43
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-16T13:14:24Z"
+"TaxAnnualAmount": "7375.16"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=EFXk6tn4Lso&mls=1"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
0 => array:11 [
"RoomKey" => "1660433369"
"RoomType" => "2pc Bathroom"
"ListingId" => "NB141592"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29908734"
"RoomLength" => null
"RoomDimensions" => "2'11'' x 7'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T13:14:24.43Z"
]
1 => array:11 [
"RoomKey" => "1660433370"
"RoomType" => "3pc Bathroom"
"ListingId" => "NB141592"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29908734"
"RoomLength" => null
"RoomDimensions" => "8'0'' x 6'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T13:14:24.43Z"
]
2 => array:11 [
"RoomKey" => "1660433371"
"RoomType" => "Utility room"
"ListingId" => "NB141592"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29908734"
"RoomLength" => null
"RoomDimensions" => "19'1'' x 23'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T13:14:24.43Z"
]
3 => array:11 [
"RoomKey" => "1660433372"
"RoomType" => "Great room"
"ListingId" => "NB141592"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29908734"
"RoomLength" => null
"RoomDimensions" => "13'9'' x 30'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T13:14:24.43Z"
]
4 => array:11 [
"RoomKey" => "1660433373"
"RoomType" => "Bedroom"
"ListingId" => "NB141592"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29908734"
"RoomLength" => null
"RoomDimensions" => "23'11'' x 11'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T13:14:24.43Z"
]
5 => array:11 [
"RoomKey" => "1660433374"
"RoomType" => "Bedroom"
"ListingId" => "NB141592"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29908734"
"RoomLength" => null
"RoomDimensions" => "14'8'' x 11'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T13:14:24.43Z"
]
6 => array:11 [
"RoomKey" => "1660433375"
"RoomType" => "Bedroom"
"ListingId" => "NB141592"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29908734"
"RoomLength" => null
"RoomDimensions" => "13'8'' x 11'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T13:14:24.43Z"
]
7 => array:11 [
"RoomKey" => "1660433376"
"RoomType" => "3pc Bathroom"
"ListingId" => "NB141592"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29908734"
"RoomLength" => null
"RoomDimensions" => "5'0'' x 8'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T13:14:24.44Z"
]
8 => array:11 [
"RoomKey" => "1660433377"
"RoomType" => "Bedroom"
"ListingId" => "NB141592"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29908734"
"RoomLength" => null
"RoomDimensions" => "10'1'' x 12'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T13:14:24.44Z"
]
9 => array:11 [
"RoomKey" => "1660433378"
"RoomType" => "Other"
"ListingId" => "NB141592"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29908734"
"RoomLength" => null
"RoomDimensions" => "12'2'' x 7'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T13:14:24.44Z"
]
10 => array:11 [
"RoomKey" => "1660433379"
"RoomType" => "Primary Bedroom"
"ListingId" => "NB141592"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29908734"
"RoomLength" => null
"RoomDimensions" => "13'4'' x 20'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T13:14:24.44Z"
]
11 => array:11 [
"RoomKey" => "1660433380"
"RoomType" => "Laundry room"
"ListingId" => "NB141592"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29908734"
"RoomLength" => null
"RoomDimensions" => "8'7'' x 8'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T13:14:24.44Z"
]
12 => array:11 [
"RoomKey" => "1660433381"
"RoomType" => "Living room"
"ListingId" => "NB141592"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29908734"
"RoomLength" => null
"RoomDimensions" => "14'5'' x 15'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T13:14:24.44Z"
]
13 => array:11 [
"RoomKey" => "1660433382"
"RoomType" => "Dining nook"
"ListingId" => "NB141592"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29908734"
"RoomLength" => null
"RoomDimensions" => "13'5'' x 13'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T13:14:24.44Z"
]
14 => array:11 [
"RoomKey" => "1660433383"
"RoomType" => "Kitchen"
"ListingId" => "NB141592"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29908734"
"RoomLength" => null
"RoomDimensions" => "12'10'' x 12'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T13:14:24.44Z"
]
15 => array:11 [
"RoomKey" => "1660433384"
"RoomType" => "Dining room"
"ListingId" => "NB141592"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29908734"
"RoomLength" => null
"RoomDimensions" => "11'11'' x 14'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T13:14:24.44Z"
]
16 => array:11 [
"RoomKey" => "1660433385"
"RoomType" => "Family room"
"ListingId" => "NB141592"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29908734"
"RoomLength" => null
"RoomDimensions" => "15'3'' x 13'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T13:14:24.44Z"
]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29908734/32-granite-drive-quispamsis"
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2042899"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "279450"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 2318
+"OriginalEntryTimestamp": "2026-06-16T13:14:24.39Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1276894"
+"ListOfficeNationalAssociationId": "1304536"
+"CoListAgentNationalAssociationId": "1318802"
+"CoListOfficeNationalAssociationId": "1304536"
+"Media": array:43 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29908734_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908734/63886279c76b68e87c7dd3855c829d02.webp"
"MediaSize" => 127306
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908734/thumbnail-63886279c76b68e87c7dd3855c829d02.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "NB141592"
"ResourceRecordKey" => "29908734"
"ModificationTimestamp" => "2026-06-16T13:14:24.4Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29908734_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908734/f6334ef12c276ddf38ee16421c8d9a40.webp"
"MediaSize" => 83075
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908734/thumbnail-f6334ef12c276ddf38ee16421c8d9a40.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141592"
"ResourceRecordKey" => "29908734"
"ModificationTimestamp" => "2026-06-16T13:14:24.4Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29908734_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908734/c3159c72819619ce12cd41b1967727a0.webp"
"MediaSize" => 80538
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908734/thumbnail-c3159c72819619ce12cd41b1967727a0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141592"
"ResourceRecordKey" => "29908734"
"ModificationTimestamp" => "2026-06-16T13:14:24.4Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29908734_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908734/17f82ac09c2ea85b8acde2b252434a40.webp"
"MediaSize" => 74224
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908734/thumbnail-17f82ac09c2ea85b8acde2b252434a40.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141592"
"ResourceRecordKey" => "29908734"
"ModificationTimestamp" => "2026-06-16T13:14:24.4Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29908734_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908734/b5dbd34e2bbf6f35cfd5b3c14c78949b.webp"
"MediaSize" => 134478
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908734/thumbnail-b5dbd34e2bbf6f35cfd5b3c14c78949b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141592"
"ResourceRecordKey" => "29908734"
"ModificationTimestamp" => "2026-06-16T13:14:24.4Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29908734_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908734/df4fb32c860a05c00c6a230b40547a3b.webp"
"MediaSize" => 120280
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908734/thumbnail-df4fb32c860a05c00c6a230b40547a3b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141592"
"ResourceRecordKey" => "29908734"
"ModificationTimestamp" => "2026-06-16T13:14:24.4Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29908734_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908734/864e66e9cb25d54136a5c5d78e684b14.webp"
"MediaSize" => 107689
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908734/thumbnail-864e66e9cb25d54136a5c5d78e684b14.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141592"
"ResourceRecordKey" => "29908734"
"ModificationTimestamp" => "2026-06-16T13:14:24.4Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29908734_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908734/2813d0d34f22447d7e0a94b718837998.webp"
"MediaSize" => 66693
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908734/thumbnail-2813d0d34f22447d7e0a94b718837998.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141592"
"ResourceRecordKey" => "29908734"
"ModificationTimestamp" => "2026-06-16T13:14:24.4Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29908734_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908734/add410c0f2e20ecdf2da966e1c87cf43.webp"
"MediaSize" => 72919
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908734/thumbnail-add410c0f2e20ecdf2da966e1c87cf43.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141592"
"ResourceRecordKey" => "29908734"
"ModificationTimestamp" => "2026-06-16T13:14:24.4Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29908734_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908734/730fae426299920594c84ea7e5f4d448.webp"
"MediaSize" => 75056
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908734/thumbnail-730fae426299920594c84ea7e5f4d448.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141592"
"ResourceRecordKey" => "29908734"
"ModificationTimestamp" => "2026-06-16T13:14:24.4Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29908734_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908734/98e83e8a9c2d981c445c9db12fe1fb25.webp"
"MediaSize" => 64658
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908734/thumbnail-98e83e8a9c2d981c445c9db12fe1fb25.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141592"
"ResourceRecordKey" => "29908734"
"ModificationTimestamp" => "2026-06-16T13:14:24.4Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29908734_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908734/2f92a2850029a9dc6772244635d4ca37.webp"
"MediaSize" => 74438
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908734/thumbnail-2f92a2850029a9dc6772244635d4ca37.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141592"
"ResourceRecordKey" => "29908734"
"ModificationTimestamp" => "2026-06-16T13:14:24.4Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29908734_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908734/0de1b4c920252a315a3e711e80e5d865.webp"
"MediaSize" => 50565
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908734/thumbnail-0de1b4c920252a315a3e711e80e5d865.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141592"
"ResourceRecordKey" => "29908734"
"ModificationTimestamp" => "2026-06-16T13:14:24.4Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29908734_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908734/3b7dcbd0ec88976df6bd0823733742fd.webp"
"MediaSize" => 61955
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908734/thumbnail-3b7dcbd0ec88976df6bd0823733742fd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141592"
"ResourceRecordKey" => "29908734"
"ModificationTimestamp" => "2026-06-16T13:14:24.4Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29908734_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908734/56ff8ae86f6ccf670edc73471eb2f395.webp"
"MediaSize" => 64569
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908734/thumbnail-56ff8ae86f6ccf670edc73471eb2f395.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141592"
"ResourceRecordKey" => "29908734"
"ModificationTimestamp" => "2026-06-16T13:14:24.4Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29908734_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908734/fa754973f99280538172025c7363ae2a.webp"
"MediaSize" => 69495
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908734/thumbnail-fa754973f99280538172025c7363ae2a.webp"
"ResourceName" => "Property"
…6
]
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29908734')"
+"ID": "1535647"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25164
+post_id: "1533780"
+post_author: 1
+"ListingKey": "29902719"
+"ListingId": "NB141815"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T12:35:15Z"
+"RFModificationTimestamp": "2026-06-15T15:38:50Z"
+"ListPrice": 349900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 1.62
+"LivingArea": 1800.0
+"BuildingAreaTotal": 0
+"City": "Quispamsis"
+"PostalCode": "E2E6B1"
+"UnparsedAddress": "42 Lila Court, Quispamsis, New Brunswick E2E6B1"
+"Coordinates": array:2 [
0 => -65.971538
1 => 45.410002
]
+"Latitude": 45.410002
+"Longitude": -65.971538
+"YearBuilt": 1969
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Welcome to 42 Lila Court, a beautifully maintained family home nestled on a quiet court in the heart of Quispamsis. Situated on a private, landscaped lot with mature gardens and a paved driveway, this property offers the perfect combination of comfort, space, and convenience. Step inside to discover a bright and inviting open-concept main level designed for everyday living and entertaining. The spacious kitchen flows seamlessly into the dining and living areas, where large windows fill the home with natural light and create a warm, welcoming atmosphere. Down the hall, you'll find three generously sized bedrooms and a well-appointed full bathroom, providing plenty of room for a growing family. The lower level expands your living space with a large family room, a second full bathroom, and an additional room currently used as a bedroom (window is non-egress), making it ideal for guests, a home office, or hobby space. The unfinished portion of the basement offers exceptional storage and endless possibilities for a gym, workshop, or future development. A convenient walkout provides direct access to the private backyard. Located in one of Quispamsis' most desirable neighbourhoods, close to schools, parks, trails, and everyday amenities, this move-in-ready home offers outstanding value and versatility. If you've been searching for a property that combines space, privacy, and a prime location, 42 Lila Court is one you won't want to miss. Contact your REALTOR® today to arrange your private viewing. (id:62783)"
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"CreationDate": "2026-06-15T15:38:40.260544+00:00"
+"Directions": "Off Pettingill Rd"
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"Flooring": array:3 [
0 => "Laminate"
1 => "Ceramic"
2 => "Wood"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Baseboard heaters"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1834886"
+"ListOfficeKey": "51407"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Level lot"
1 => "Treed"
2 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "1.62"
+"ParcelNumber": "00254680"
+"PhotosChangeTimestamp": "2026-06-15T12:29:46Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-15T12:29:46Z"
+"TaxAnnualAmount": "3393.81"
+"VirtualTourURLUnbranded": "https://youtu.be/axs9JAZd9ys"
+"WaterSource": array:2 [
0 => "Drilled Well"
1 => "Well"
]
+"Rooms": array:12 [
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]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29902719/42-lila-court-quispamsis"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1288
+"OriginalEntryTimestamp": "2026-06-15T12:29:46.38Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1196834"
+"ListOfficeNationalAssociationId": "1007064"
+"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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29902719')"
+"ID": "1533780"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25161
+post_id: "1530010"
+post_author: 1
+"ListingKey": "29902842"
+"ListingId": "NB141611"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T13:40:09Z"
+"RFModificationTimestamp": "2026-06-15T13:47:58Z"
+"ListPrice": 489900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 52337.0
+"LivingArea": 1683.0
+"BuildingAreaTotal": 0
+"City": "Quispamsis"
+"PostalCode": "E2E4V5"
+"UnparsedAddress": "416 Hampton Road, Quispamsis, New Brunswick E2E4V5"
+"Coordinates": array:2 [
0 => -65.94985
1 => 45.42391
]
+"Latitude": 45.42391
+"Longitude": -65.94985
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Looking for space, flexibility, and a garage that can handle all your projects, toys, and equipment? This unique 1.2-acre property offers the perfect blend of comfortable family living and exceptional outdoor functionality. The 1.5-storey home features a practical and flexible floor plan with a spacious kitchen, inviting living room, full 4-piece bathroom, and an additional main-floor room that can easily serve as a formal dining room, home office, family room, or playroom. Upstairs, the original four-bedroom layout has been thoughtfully reconfigured into three bedrooms, creating a generously sized primary bedroom along with two additional bedrooms. The home offers year-round comfort with an updated propane furnace and a mini-split heat pump providing efficient heating and cooling. The concrete foundation basement offers excellent storage space and includes a wood stove for an additional heat source. Outside is where this property truly shines. The current owner has invested significant time and effort into developing the grounds, featuring custom rock walls, attractive landscaping, fencing, and extensive level parking areas with room for vehicles, trailers, RVs, boats, and recreational equipment. A heated and insulated carport provides additional sheltered workspace or parking. The standout feature is the impressive 58 x 24 insulated and heated garage; ideal for hobbyists, contractors, mechanics, or anyone needing serious storage and workspace. Adding even more functionality is a 16-foot shed roof running the full length of the garage, providing substantial covered storage for equipment, vehicles, firewood, or seasonal items. Whether youre searching for a family home with room to grow, a property that accommodates your hobbies and business needs, or simply a place with exceptional parking, storage, and workshop space, this versatile property is well worth a closer look. (id:62650)"
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:1 [
0 => "Full"
]
+"Cooling": array:1 [
0 => "Heat Pump"
]
+"CreationDate": "2026-06-15T13:47:49.124577+00:00"
+"Directions": "On Hampton Road across from Cannon Road."
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"Flooring": array:2 [
0 => "Hardwood"
1 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Forced air"
2 => "Propane"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1422717"
+"ListOfficeKey": "51407"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Level lot"
1 => "Visual exposure"
2 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "52337"
+"ParcelNumber": "30209480"
+"ParkingFeatures": array:4 [
0 => "Detached Garage"
1 => "Garage"
2 => "Carport"
3 => "Heated Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T13:15:30Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-15T13:32:14Z"
+"TaxAnnualAmount": "4916.74"
+"VirtualTourURLUnbranded": "https://youtu.be/Fmf2kYL2HyU"
+"WaterSource": array:2 [
0 => "Drilled Well"
1 => "Well"
]
+"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": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29902842/416-hampton-road-quispamsis"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1683
+"OriginalEntryTimestamp": "2026-06-15T13:15:30.37Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1086880"
+"ListOfficeNationalAssociationId": "1007064"
+"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('29902842')"
+"ID": "1530010"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25165
+post_id: "1483180"
+post_author: 1
+"ListingKey": "29831832"
+"ListingId": "NB140554"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-02T13:10:37Z"
+"RFModificationTimestamp": "2026-06-02T13:15:17Z"
+"ListPrice": 615000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0.164
+"LivingArea": 1361.0
+"BuildingAreaTotal": 0
+"City": "Quispamsis"
+"PostalCode": "E2E0Y9"
+"UnparsedAddress": "17 Wetmore Boulevard Unit# 24, Quispamsis, New Brunswick E2E0Y9"
+"Coordinates": array:2 [
0 => -65.970259
1 => 45.417853
]
+"Latitude": 45.417853
+"Longitude": -65.970259
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Welcome to premium, turnkey living in this brand-new, high-end semi-detached home featuring an attached garage in a highly desirable neighbourhood. Crafted explicitly for buyers seeking an upscale, low-maintenance lifestyle without compromising on visual style; this home is entirely move-in ready. The bright, open-concept layout seamlessly blends daily relaxation with effortless entertaining. This thoughtfully finished home offers two spacious bedrooms and two full bathrooms, highlighted by a private primary retreat complete with its own ensuite and an oversized walk-in closet designed with dressing-room functionality. Outside, the exterior showcases striking modern curb appeal, wrapped in dark vinyl siding and beautifully accented by bold, natural hemlock pillars for a timeless architectural statement. Enjoy true lock-and-leave convenience with low HOA fees of just $150 per month, which fully cover snow removal, driveway plowing, lawn care, grass mowing, and neighbourhood well maintenance. This is a flawless, worry-free option for working professionals, downsizing retirees, or frequent travelers seeking absolute peace of mind. (id:62650)"
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Cooling": array:1 [
0 => "Heat Pump"
]
+"CreationDate": "2026-06-01T14:06:20.338567+00:00"
+"Directions": "Hwy 1 to Gondola Point Arterial. 3rd exit on rotary to Alma Lane. Left on Quispamsis Road. Right on Pettingill. Left on Wetmore Blvd."
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"Flooring": array:2 [
0 => "Tile"
1 => "Wood"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Baseboard heaters"
2 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1993846"
+"ListOfficeKey": "279450"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "0.164"
+"ParcelNumber": "30368666"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-02T13:01:20Z"
+"PhotosCount": 24
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-02T13:01:20Z"
+"WaterSource": array:2 [
0 => "Drilled Well"
1 => "Well"
]
+"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": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29831832/17-wetmore-boulevard-unit-24-quispamsis"
+"StructureType": array:1 [
0 => "Garden Home"
]
+"CoListAgentKey": "2042899"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "279450"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1361
+"OriginalEntryTimestamp": "2026-06-01T13:45:14.5Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1276894"
+"ListOfficeNationalAssociationId": "1304536"
+"CoListAgentNationalAssociationId": "1318802"
+"CoListOfficeNationalAssociationId": "1304536"
+"Media": array:24 [
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]
]
+"DaysOnMarket": 15
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29831832')"
+"ID": "1483180"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25163
+post_id: "1479835"
+post_author: 1
+"ListingKey": "29831612"
+"ListingId": "NB138825"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-01T19:50:28Z"
+"RFModificationTimestamp": "2026-06-01T19:55:13Z"
+"ListPrice": 539000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 19225.0
+"LivingArea": 1400.0
+"BuildingAreaTotal": 0
+"City": "Quispamsis"
+"PostalCode": "E2E4V5"
+"UnparsedAddress": "412 Hampton Road, Quispamsis, New Brunswick E2E4V5"
+"Coordinates": array:2 [
0 => -65.950189
1 => 45.423508
]
+"Latitude": 45.423508
+"Longitude": -65.950189
+"YearBuilt": 2007
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Experience the ease of one-level living without compromising the privacy & independence of a detached home. Offering an exceptional low-maintenance lifestyle on your own beautifully landscaped lot, this immaculate bungalow is a wonderful alternative to garden home living; no shared walls, no cramped spaces, just comfort, privacy & room to enjoy life. With a generous 1400 sq ft open-concept floor plan, a newer built 24x24 detached garage & heated separate studio, this property is perfectly suited for empty nesters, single professionals, or anyone seeking the convenience of stair-free living in a peaceful setting.Surrounded by mature trees & attractive gardens, the property was created for outdoor enjoyment with a sunny deck, firepit area & partially fenced yard that could easily be fully enclosed for pets. Inside, comfort & efficiency go hand in hand. Home features in-floor radiant heat complemented by 2 ductless heat pumps providing both heating & cooling options while helping to keep utility costs low. Beautifully appointed kitchen showcases rich cherry cabinetry, granite countertops & a welcoming island where family & guests can gather-open to bright & airy great room this area is filled with natural light from tall south-facing windows overlooking the deck and wooded backyard. The charming standalone 14x12 studio offers endless flexibility; ideal as a home office, artists studio, fitness room or quiet creative space. The home offers three comfortable bedrooms, including a spacious primary suite with a beautifully refreshed ensuite bath plus garden door access to a warm, private sundeck. The second & third bedrooms are generously sized, with one currently serving as a peaceful den. Thoughtfully designed, highly maintained (roof shingles 2024) for those seeking quality; a love of the outdoors where your yard is your sancutary & perfect jump off location for walking & biking! Quispamsis is vibrant & active with trail systems, beaches & parks all close by! (id:62650)"
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Cooling": array:1 [
0 => "Heat Pump"
]
+"CreationDate": "2026-06-01T13:50:23.598850+00:00"
+"Directions": "On Hampton Road, past Milligan Drive"
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"Flooring": array:3 [
0 => "Tile"
1 => "Hardwood"
2 => "Carpeted"
]
+"FoundationDetails": array:2 [
0 => "Concrete Perimeter"
1 => "Concrete"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Radiant heat"
2 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1422684"
+"ListOfficeKey": "51407"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "19225"
+"ParcelNumber": "30209498"
+"ParkingFeatures": array:4 [
0 => "Detached Garage"
1 => "Garage"
2 => "Garage"
3 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-06-01T19:21:25Z"
+"PhotosCount": 44
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-01T19:43:20Z"
+"TaxAnnualAmount": "6122.73"
+"VirtualTourURLUnbranded": "https://youtu.be/8eUIyKYdT6Y"
+"WaterSource": array:2 [
0 => "Drilled Well"
1 => "Well"
]
+"Rooms": array:9 [
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]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29831612/412-hampton-road-quispamsis"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1400
+"OriginalEntryTimestamp": "2026-06-01T13:00:00.5Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1085897"
+"ListOfficeNationalAssociationId": "1007064"
+"Media": array:44 [
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]
]
+"DaysOnMarket": 15
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29831612')"
+"ID": "1479835"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25158
+post_id: "1472655"
+post_author: 1
+"ListingKey": "29820063"
+"ListingId": "NB140614"
+"PropertyType": "Residential"
+"PropertySubType": "Vacant Land"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-01T18:11:07Z"
+"RFModificationTimestamp": "2026-06-01T18:21:51Z"
+"ListPrice": 325000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 22.0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Rothesay"
+"PostalCode": "E2G1W3"
+"UnparsedAddress": "Downeast Drive, Rothesay, New Brunswick E2G1W3"
+"Coordinates": array:2 [
0 => -65.944531
1 => 45.411168
]
+"Latitude": 45.411168
+"Longitude": -65.944531
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Discover the rare opportunity to own 54 acres of pristine, private landnestled in nature yet only minutes from all the conveniences of Rothesay and Quispamsis. This unique parcel offers the best of both worlds: peaceful seclusion and quick access to top-tier schools, shopping, dining, and recreational amenities. Zoned for a single-family residence due to development restrictions, this property promises lasting privacy and tranquility. Imagine building your dream home tucked away in the woods, surrounded by rolling hills, mature trees, and wildlifeyour very own sanctuary just outside the city. Whether you envision a luxury country estate, a peaceful on or off-grid retreat, or a place to simply breathe and unwind, this expansive property is your blank canvas. Opportunities like this are raredon't miss your chance to create something truly special, just minutes from everything you need. Close to everything: 14 mins to YSJ, 9 minutes to the heart of Rothesay, 19 mins to Uptown Saint John. Details on development restrictions are in the supplements - contact your REALTOR® or Listing REALTOR® for details - Single Family Home can be built in Zone B (see last page of supplements). (id:62783)"
+"CreationDate": "2026-05-28T23:24:16.964647+00:00"
+"Directions": "Highway exit 141 to COMEX Parking Lot. Take adjacent gravel road Downeast Drive past civic number 140 (Quispamsis Wellfield Monitoring Building). Property is the next driveway. Driveway has steel gate."
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2148616"
+"ListOfficeKey": "94518"
+"LotSizeDimensions": "22"
+"ParcelNumber": "00243170"
+"PhotosChangeTimestamp": "2026-06-01T18:03:52Z"
+"PhotosCount": 8
+"Sewer": array:1 [
0 => "No sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-01T18:03:52Z"
+"TaxAnnualAmount": "657.28"
+"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=4Y5Kpx5-20Y"
+"WaterSource": array:1 [
0 => "None"
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29820063/downeast-drive-rothesay"
+"CoListAgentKey": "2234898"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "94518"
+"GeocodeManualYN": false
+"OriginalEntryTimestamp": "2026-05-28T19:12:38.57Z"
+"ListAgentNationalAssociationId": "1399601"
+"ListOfficeNationalAssociationId": "1159552"
+"CoListAgentNationalAssociationId": "1472710"
+"CoListOfficeNationalAssociationId": "1159552"
+"Media": array:8 [
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]
]
+"DaysOnMarket": 19
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29820063')"
+"ID": "1472655"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23374
+post_id: "1468510"
+post_author: 1
+"ListingKey": "29810601"
+"ListingId": "NB140321"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-27T14:00:39Z"
+"RFModificationTimestamp": "2026-05-27T18:01:17Z"
+"ListPrice": 439900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 572.0
+"LivingArea": 2000.0
+"BuildingAreaTotal": 0
+"City": "Quispamsis"
+"PostalCode": "E2E3R9"
+"UnparsedAddress": "65 Pettingill Road, Quispamsis, New Brunswick E2E3R9"
+"Coordinates": array:2 [
0 => -65.973612
1 => 45.412846
]
+"Latitude": 45.412846
+"Longitude": -65.973612
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Located in the heart of Quispamsis, and walking distance to many amenities, this beautiful three level home offers the perfect blend of comfort and convenience. Just a short walk to the popular Ritchie Lake, enjoy the outdoors right at your doorstep! Inside, the home features an oversized welcoming entryway, a spacious living room, modern kitchen with stunning quartz countertops including a custom hanging, rod iron pot rack. A dining area, and a convenient half bath also with quartz countertop complete the main floor. Upstairs, you'll find three well appointed bedrooms and a full bathroom, complete with laundry and more elegant quartz countertop. The fully finished basement offers even more living space with a custom double door shoe closet with multiple shelves, a full bathroom, and a spacious living area, along with a triple door wide closet for ample storage. Situated on a corner lot, the property offers two exterior faucets for easy outdoor maintenance and the one in the front yard is convenient for washing vehicles as well. Plus, lawn maintenance from ""the weed man"" is paid, for the remainder of the 2026 season! Stay comfortable year-round with two Heat Pumps for efficient heating and cooling. (id:62650)"
+"ArchitecturalStyle": array:1 [
0 => "3 Level"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Air Conditioned"
]
+"CreationDate": "2026-05-27T18:01:07.142961+00:00"
+"Directions": "Heading towards Quispamsis from Rothesay on Hampton Rd. turn left between RBC and MacDonalds, onto Pettingill Rd. House will be on your left. Corner of Pettingill Rd, and Wellington Court."
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"Flooring": array:3 [
0 => "Hardwood"
1 => "Laminate"
2 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:1 [
0 => "Baseboard heaters"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2227646"
+"ListOfficeKey": "258211"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "572"
+"ParcelNumber": "30265870"
+"PhotosChangeTimestamp": "2026-05-27T13:51:20Z"
+"PhotosCount": 28
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-05-27T13:51:20Z"
+"TaxAnnualAmount": "3779.05"
+"WaterSource": array:1 [
0 => "Well"
]
+"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": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29810601/65-pettingill-road-quispamsis"
+"CoListAgentKey": "1638647"
+"CoListAgentKey2": "2257227"
+"CoListOfficeKey": "258211"
+"GeocodeManualYN": false
+"CoListOfficeKey2": "258211"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1334
+"OriginalEntryTimestamp": "2026-05-27T13:51:20.22Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1470502"
+"ListOfficeNationalAssociationId": "1243998"
+"CoListAgentNationalAssociationId": "1177438"
+"CoListAgentNationalAssociationId2": "1496053"
+"CoListOfficeNationalAssociationId": "1243998"
+"CoListOfficeNationalAssociationId2": "1243998"
+"Media": array:28 [
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]
]
+"DaysOnMarket": 20
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29810601')"
+"ID": "1468510"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25166
+post_id: "1434902"
+post_author: 1
+"ListingKey": "29768256"
+"ListingId": "NB138785"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-24T17:26:07Z"
+"RFModificationTimestamp": "2026-05-24T17:30:09Z"
+"ListPrice": 425000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.47
+"LivingArea": 2520.0
+"BuildingAreaTotal": 0
+"City": "Quispamsis"
+"PostalCode": "E2E4X8"
+"UnparsedAddress": "71 Peat Drive, Quispamsis, New Brunswick E2E4X8"
+"Coordinates": array:2 [
0 => -65.957156
1 => 45.409351
]
+"Latitude": 45.409351
+"Longitude": -65.957156
+"YearBuilt": 1995
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Welcome to 71 Peat Drive, a very well-maintained three-plus-bedroom home with four baths, located in one of Quispamsis most sought-after neighbourhoods. Outside, youll find a beautifully landscaped property featuring a paved driveway, gardens, a private fenced backyard perfect for kids and pets, and a sunny rear deck ideal for relaxing or entertaining. Inside, the spacious entryway leads to a formal living room, an open-concept kitchen and dining area, plus access to the attached garage and bonus room. Note: The bonus room offers great potential for a home-based business. Down the hall are three good-sized bedrooms, including a primary suite with an ensuite, along with the main full bath. The lower level offers incredible additional living space, including a huge family room with a woodstove, a fourth bedroom (non-egress window), a third full bath, a large laundry/storage/utility room, and another oversized room perfect for a gym, playroom, office, or hobby space. Offering space, functionality, and a fantastic family-friendly location just minutes from schools, shopping, and amenities, this is a home you wont want to miss. Call today for full details and a private viewing. Note that the main level has hardwood under the carpets and in good shape. (id:62650)"
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"BathroomsPartial": 2
+"Cooling": array:1 [
0 => "Heat Pump"
]
+"CreationDate": "2026-05-19T14:35:49.204773+00:00"
+"Directions": "From Cedar Ridge Blvd to Peat Dr."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl"
]
+"Flooring": array:3 [
0 => "Laminate"
1 => "Carpeted"
2 => "Wood"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:5 [
0 => "Heat Pump"
1 => "Baseboard heaters"
2 => "Stove"
3 => "Electric"
4 => "Wood"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1834886"
+"ListOfficeKey": "51407"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "0.47"
+"ParcelNumber": "30108120"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-05-19T13:15:55Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-05-24T17:13:34Z"
+"TaxAnnualAmount": "4751.32"
+"VirtualTourURLUnbranded": "https://youtu.be/ABlTl4EAdtg"
+"WaterSource": array:2 [
0 => "Drilled Well"
1 => "Well"
]
+"Rooms": array:15 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29768256/71-peat-drive-quispamsis"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 1260
+"OriginalEntryTimestamp": "2026-05-19T13:15:54.96Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1196834"
+"ListOfficeNationalAssociationId": "1007064"
+"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": 28
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29768256')"
+"ID": "1434902"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25167
+post_id: "1412696"
+post_author: 1
+"ListingKey": "29736702"
+"ListingId": "NB139232"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-31T18:50:34Z"
+"RFModificationTimestamp": "2026-05-31T18:52:20Z"
+"ListPrice": 489900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 14708.0
+"LivingArea": 1750.0
+"BuildingAreaTotal": 0
+"City": "Quispamsis"
+"PostalCode": "E2G0A5"
+"UnparsedAddress": "16 Banshee Court, Quispamsis, New Brunswick E2G0A5"
+"Coordinates": array:2 [
0 => -65.942314
1 => 45.421214
]
+"Latitude": 45.421214
+"Longitude": -65.942314
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Nestled in the serene community of Quispamsis, this charming 3-bedroom split-entry home offers a perfect blend of comfort and convenience. Located at the end of a tranquil cul-de-sac, it ensures privacy while providing easy access to nearby highways for effortless commuting. Step inside to discover an inviting open-concept design that is highlighted by a stunning kitchen islandperfect for entertaining or enjoying casual family meals. The finished basement provides versatile space, ideal for a cozy family room or home office, tailored to your lifestyle needs. With two well-appointed bathrooms, mornings will be smooth for everyone in the household. Outside, the expansive lot presents endless possibilities; whether it's gardening, building a play area for kids, or simply relaxing under the sun, and also enjoy your back private deck. A spacious double garage adds further practicality and storage options, catering perfectly to families or hobbyists alike. This delightful property epitomizes suburban tranquility without sacrificing modern amenitiesa true gem waiting to welcome you home. Dont miss this opportunity; schedule your private tour today and experience all that this exquisite Quispamsis property has to offer! (id:62650)"
+"ArchitecturalStyle": array:1 [
0 => "Split entry bungalow"
]
+"CreationDate": "2026-05-12T14:37:05.229677+00:00"
+"Directions": "Monarch drive to to Chrysler"
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"Flooring": array:3 [
0 => "Hardwood"
1 => "Carpeted"
2 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Baseboard heaters"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1422666"
+"ListOfficeKey": "51407"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "14708"
+"ParcelNumber": "30254098"
+"PhotosChangeTimestamp": "2026-05-18T13:10:38Z"
+"PhotosCount": 45
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-05-31T18:43:05Z"
+"TaxAnnualAmount": "4582.45"
+"WaterSource": array:1 [
0 => "Well"
]
+"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": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29736702/16-banshee-court-quispamsis"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1288
+"OriginalEntryTimestamp": "2026-05-12T13:15:23.93Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1108665"
+"ListOfficeNationalAssociationId": "1007064"
+"Media": array:45 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
]
+"DaysOnMarket": 35
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29736702')"
+"ID": "1412696"
}
]
+success: true
+page_size: 9
+page_count: 2
+count: 14
+after_key: ""
}
"RF Response Time" => "0.21 seconds"
]
]