Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty Object
(
[post_id] => 1800209
[post_author] => 1
[ListingKey] => 1193954020
[ListingId] => RLS20122849
[PropertyType] => Residential
[PropertySubType] => Single Family Residence
[StandardStatus] => Active
[ModificationTimestamp] => 2026-11-05T04:22:33Z
[RFModificationTimestamp] => 2026-11-05T04:26:36Z
[ListPrice] => 1988888
[BathroomsTotalInteger] => 2
[BathroomsHalf] => 0
[BedroomsTotal] => 3
[LotSizeArea] => 5000
[LivingArea] => 0
[BuildingAreaTotal] => 0
[City] => New York City
[PostalCode] => 11363
[UnparsedAddress] => 41-08 Orient Avenue, New York City, New York 11363
[Coordinates] => Array
(
[0] => -73.7438687
[1] => 40.768404
)
[Latitude] => 40.768404
[Longitude] => -73.7438687
[YearBuilt] => 1950
[InternetAddressDisplayYN] => 1
[FeedTypes] => IDX
[ListAgentFullName] => CESAR A GUEVARA
[ListOfficeName] => Bond New York Properties LLC
[ListAgentMlsId] => 93816
[ListOfficeMlsId] => 5339
[OriginatingSystemName] => RLS
[PublicRemarks] => Turn-Key Luxury in Prime Douglaston<br>Welcome to this stunning, completely renovated Douglaston residence where custom craftsmanship, modern luxury, and exceptional outdoor living come together. Renovated from top to bottom, this beautifully appointed home is truly move-in ready and designed for todays lifestyle.<br>From the curb, the property impresses with gorgeous landscaping, extensive stonework, elegant outdoor lighting, and a heated driveway. Step inside to soaring cathedral ceilings, skylights, custom finishes, and a beautiful fireplace creating a warm and sophisticated ambiance.<br>The showstopping chefs kitchen features a large center island, beautiful finishes, and plenty of space for everyday living and entertaining. Smart-home technology, alarm system, and separate-zone A/C provide modern comfort and convenience throughout.<br>The outdoor space is an entertainers dream, featuring a built-in gas grill, outdoor speakers, and custom lighting, creating the perfect setting for summer gatherings, dinner parties, and unforgettable evenings.<br>This exceptional home offers 3 bedrooms, 2 full baths, a fully finished basement, and a 1-car garage. Every space has been thoughtfully renovated with attention to quality, style, and functionality.<br>Located on a quiet and desirable Douglaston block, conveniently near the Douglaston LIRR station and close to the prestigious Douglaston Manor, this home offers privacy and tranquility while keeping you close to transportation and neighborhood conveniences.<br>Beautifully renovated. Exceptionally finished. Designed to entertain. This is the Douglaston home youve been waiting for.<br><br>BOND New York Properties is a licensed real estate broker that proudly supports equal housing opportunity.
[ActivationDate] => 2026-10-26
[Appliances] => Dishwasher,Microwave,Stainless Steel Appliance(s),Wine Cooler
[AssociationFeeFrequency] => Monthly
[AvailabilityDate] => 2026-11-04
[BackOnMarketDate] => 2026-10-27
[BathroomsFull] => 2
[BuildingAreaUnits] => Square Feet
[CLIP] => 8815183849
[CityRegion] => Queens
[CoListAgentAOR] => Real Estate Board of New York
[CoListAgentDirectPhone] => (917) 903-9807
[CoListAgentEmail] => mguevara@bondnewyork.com
[CoListAgentFirstName] => TATEOSIAN
[CoListAgentFullName] => TATEOSIAN MARY GUEVARA
[CoListAgentKey] => 25254960
[CoListAgentKeyNumeric] => 25254960
[CoListAgentLastName] => GUEVARA
[CoListAgentMiddleName] => MARY
[CoListAgentMlsId] => 53398
[CoListAgentPreferredPhone] => (917) 903-9807
[CoListOfficeAOR] => Real Estate Board of New York
[CoListOfficeKey] => 5658935
[CoListOfficeKeyNumeric] => 5658935
[CoListOfficeMlsId] => 5339
[CoListOfficeName] => Bond New York Properties LLC
[CoListOfficePhone] => (212) 582-2009
[CoListOfficeURL] => www.bondnewyork.com
[CommonInterest] => None
[ContractStatusChangeDate] => 2026-10-26
[Cooling] => Central Air
[CoolingYN] => 1
[CountyOrParish] => Queens
[CreationDate] => 2026-10-27T03:25:58.079976+00:00
[CrossStreet] => 41st Avenue and 43rd Avenue
[DocumentsChangeTimestamp] => 2026-11-04T23:22:20Z
[DoorFeatures] => Sliding Doors
[ExteriorFeatures] => Building Garden,Garden,Private Entrance,Private Outdoor Space Under 60 Sqft
[FireplaceFeatures] => Other
[FireplaceYN] => 1
[FireplacesTotal] => 1
[Flooring] => Hardwood
[Furnished] => Unfurnished
[Heating] => Radiant
[HeatingYN] => 1
[HumanModifiedYN] => 1
[InteriorFeatures] => Breakfast Bar,Crown Molding,Eat-in Kitchen,High Ceilings,Pantry,Smart Home
[RFTransactionType] => For Sale
[InternetAutomatedValuationDisplayYN] => 1
[InternetConsumerCommentYN] => 1
[InternetEntireListingDisplayYN] => 1
[LaundryFeatures] => Building None,None
[ListAgentAOR] => Real Estate Board of New York
[ListAgentDirectPhone] => (917) 523-4681
[ListAgentEmail] => cguevara@bondnewyork.com
[ListAgentFirstName] => CESAR
[ListAgentKey] => 25264407
[ListAgentKeyNumeric] => 25264407
[ListAgentLastName] => GUEVARA
[ListAgentMiddleName] => A
[ListAgentPreferredPhone] => (917) 523-4681
[ListOfficeAOR] => Real Estate Board of New York
[ListOfficeKey] => 5658935
[ListOfficeKeyNumeric] => 5658935
[ListOfficePhone] => (212) 582-2009
[ListOfficeURL] => www.bondnewyork.com
[ListingAgreement] => Exclusive Agency
[ListingContractDate] => 2026-10-26
[ListingKeyNumeric] => 1193954020
[ListingURL] => https://www.bondnewyork.com/?page=details&id=1856449
[LotSizeDimensions] => 0X0
[MajorChangeTimestamp] => 2026-10-27T09:30:30Z
[MajorChangeType] => Back On Market
[NumberOfUnitsTotal] => 1
[OnMarketDate] => 2026-11-04
[OnMarketTimestamp] => 2026-10-26T00:00:00Z
[OriginalEntryTimestamp] => 2026-10-26T23:22:05Z
[OriginalListPrice] => 1988888
[OriginatingSystemKey] => 35071779
[OriginatingSystemModificationTimestamp] => 2026-11-04T23:22:20Z
[OriginatingSystemSubName] => RLS_REBNY
[ParkingFeatures] => Garage
[Permission] => IDX
[PetsAllowed] => Building Yes,Yes
[PhotosChangeTimestamp] => 2026-11-05T04:22:51Z
[PhotosCount] => 15
[PostalCity] => Queens
[PriceChangeTimestamp] => 2026-10-26T23:22:05Z
[RoomsTotal] => 6
[SourceSystemID] => TRESTLE
[StateOrProvince] => NY
[StatusChangeTimestamp] => 2026-10-27T09:30:30Z
[StreetName] => Orient
[StreetNumber] => 41-08
[StreetNumberNumeric] => 41
[StreetSuffix] => Avenue
[StructureType] => House,Multi Family
[SubdivisionName] => Bayside
[TaxAnnualAmount] => 14928.0
[TaxBlock] => 08105
[TaxLot] => 0044
[VideosChangeTimestamp] => 2026-11-05T04:22:51Z
[CustomFields] => {
"ElevatorsTotal": "0",
"FlipTaxRemarks": "ASK EXCL BROKER",
"FlipTax": "0.00",
"TaxAbatementYN": "0",
"BuildingTaxLot": "0044",
"AttendanceType": "None",
"BuildingSmokeFreeYN": "0",
"MaximumFinancingRemarks": "0 %",
"PrivateOutdoorSpaceSize": "LessThan60SqFt",
"MaximumFinancingPercent": "0.00",
"SponsorUnitYN": "0",
"ListingKey": "1193954020"
}
[AdditionalFeeYN] =>
[FractionalShare] => 0.00
[BuildingSizeDimensions] => 0X0
[@odata.id] => https://api.realtyfeed.com/realtyfeed/odata/Property('1193954020')
[CurrentPrice] => 1988888
[PetsComments] => ,
[provider_name] => REBNY
[RecordSignature] => 1723112050
[ListAgentNickname] => Cesar Guevara
[UniversalParcelId] => urn:reso:upi:2.0:US:36081:08105-0044
[CountrySubdivision] => 36081
[CoListAgentNickname] => Mary
[BackOnMarketTimestamp] => 2026-10-27T00:00:00.000-00:00
[OriginatingSystemListOfficeKey] => 1276846
[OriginatingSystemCoListOfficeKey] => 1276846
[OriginatingSystemListAgentMemberKey] => 1305880
[OriginatingSystemCoListAgentMemberKey] => 1304452
[Media] => Array
(
[0] => Array
(
[Order] => 1
[ImageOf] =>
[ListAOR] =>
[MediaKey] => 2006147863613
[MediaURL] => https://cdn.realtyfeed.com/cdn/76/1193954020/ca6555ea387ebbcc50de25215d73e609.webp
[ClassName] =>
[MediaHTML] =>
[MediaSize] => 1017622
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/76/1193954020/thumbnail-ca6555ea387ebbcc50de25215d73e609.webp
[ImageWidth] =>
[Permission] =>
[ImageHeight] =>
[MediaStatus] => Active
[SyndicateTo] =>
[ListAgentKey] => 25264407
[PropertyType] => Residential
[ResourceName] => Property
[ListOfficeKey] => 5658935
[MediaCategory] => Photo
[MediaObjectID] => 1856449_122047379.jpg
[OffMarketDate] =>
[X_MediaStream] =>
[SourceSystemID] => TRESTLE
[StandardStatus] => Active
[HumanModifiedYN] =>
[ListOfficeMlsId] => 5339
[LongDescription] => Photo 1
[MediaAlteration] =>
[MediaKeyNumeric] => 2006147863613
[PropertySubType] => Single Family Residence
[RecordSignature] => 1732817426
[OriginalMediaUrl] =>
[PreferredPhotoYN] =>
[ResourceRecordID] => RLS20122849
[ShortDescription] =>
[SourceSystemName] =>
[ChangedByMemberID] =>
[ListingPermission] => IDX
[ResourceRecordKey] => 1193954020
[ChangedByMemberKey] =>
[MediaClassification] => PHOTO
[OriginatingSystemID] =>
[ImageSizeDescription] =>
[SourceSystemMediaKey] => RLMX-00103122047379
[ModificationTimestamp] => 2026-10-27T06:36:48.773-00:00
[OriginatingSystemName] => RLS
[MediaStatusDescription] =>
[OriginatingSystemSubName] => RLS_REBNY
[ResourceRecordKeyNumeric] => 1193954020
[ChangedByMemberKeyNumeric] =>
[OriginatingSystemMediaKey] => 35071782
[PropertySubTypeAdditional] =>
[MediaModificationTimestamp] => 2026-10-27T06:36:00.000-00:00
[SourceSystemResourceRecordKey] =>
[InternetEntireListingDisplayYN] => 1
[OriginatingSystemResourceRecordId] =>
[OriginatingSystemResourceRecordKey] => 35071779
)
[1] => Array
(
[Order] => 2
[ImageOf] =>
[ListAOR] =>
[MediaKey] => 2006147863614
[MediaURL] => https://cdn.realtyfeed.com/cdn/76/1193954020/b98edc3fc1df6d14ed8a7e8d6370c5f6.webp
[ClassName] =>
[MediaHTML] =>
[MediaSize] => 1277560
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/76/1193954020/thumbnail-b98edc3fc1df6d14ed8a7e8d6370c5f6.webp
[ImageWidth] =>
[Permission] =>
[ImageHeight] =>
[MediaStatus] => Active
[SyndicateTo] =>
[ListAgentKey] => 25264407
[PropertyType] => Residential
[ResourceName] => Property
[ListOfficeKey] => 5658935
[MediaCategory] => Photo
[MediaObjectID] => 1856449_122047380.jpg
[OffMarketDate] =>
[X_MediaStream] =>
[SourceSystemID] => TRESTLE
[StandardStatus] => Active
[HumanModifiedYN] =>
[ListOfficeMlsId] => 5339
[LongDescription] => Photo 2
[MediaAlteration] =>
[MediaKeyNumeric] => 2006147863614
[PropertySubType] => Single Family Residence
[RecordSignature] => -444130555
[OriginalMediaUrl] =>
[PreferredPhotoYN] =>
[ResourceRecordID] => RLS20122849
[ShortDescription] =>
[SourceSystemName] =>
[ChangedByMemberID] =>
[ListingPermission] => IDX
[ResourceRecordKey] => 1193954020
[ChangedByMemberKey] =>
[MediaClassification] => PHOTO
[OriginatingSystemID] =>
[ImageSizeDescription] =>
[SourceSystemMediaKey] => RLMX-00103122047380
[ModificationTimestamp] => 2026-10-27T13:30:48.690-00:00
[OriginatingSystemName] => RLS
[MediaStatusDescription] =>
[OriginatingSystemSubName] => RLS_REBNY
[ResourceRecordKeyNumeric] => 1193954020
[ChangedByMemberKeyNumeric] =>
[OriginatingSystemMediaKey] => 35071783
[PropertySubTypeAdditional] =>
[MediaModificationTimestamp] => 2026-10-27T13:30:48.690-00:00
[SourceSystemResourceRecordKey] =>
[InternetEntireListingDisplayYN] => 1
[OriginatingSystemResourceRecordId] =>
[OriginatingSystemResourceRecordKey] => 35071779
)
[2] => Array
(
[Order] => 3
[ImageOf] =>
[ListAOR] =>
[MediaKey] => 2006147863615
[MediaURL] => https://cdn.realtyfeed.com/cdn/76/1193954020/92f3fc352777d1045f5580c099159835.webp
[ClassName] =>
[MediaHTML] =>
[MediaSize] => 953291
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/76/1193954020/thumbnail-92f3fc352777d1045f5580c099159835.webp
[ImageWidth] =>
[Permission] =>
[ImageHeight] =>
[MediaStatus] => Active
[SyndicateTo] =>
[ListAgentKey] => 25264407
[PropertyType] => Residential
[ResourceName] => Property
[ListOfficeKey] => 5658935
[MediaCategory] => Photo
[MediaObjectID] => 1856449_122047381.jpg
[OffMarketDate] =>
[X_MediaStream] =>
[SourceSystemID] => TRESTLE
[StandardStatus] => Active
[HumanModifiedYN] =>
[ListOfficeMlsId] => 5339
[LongDescription] => Photo 3
[MediaAlteration] =>
[MediaKeyNumeric] => 2006147863615
[PropertySubType] => Single Family Residence
[RecordSignature] => -444130555
[OriginalMediaUrl] =>
[PreferredPhotoYN] =>
[ResourceRecordID] => RLS20122849
[ShortDescription] =>
[SourceSystemName] =>
[ChangedByMemberID] =>
[ListingPermission] => IDX
[ResourceRecordKey] => 1193954020
[ChangedByMemberKey] =>
[MediaClassification] => PHOTO
[OriginatingSystemID] =>
[ImageSizeDescription] =>
[SourceSystemMediaKey] => RLMX-00103122047381
[ModificationTimestamp] => 2026-10-27T13:30:48.690-00:00
[OriginatingSystemName] => RLS
[MediaStatusDescription] =>
[OriginatingSystemSubName] => RLS_REBNY
[ResourceRecordKeyNumeric] => 1193954020
[ChangedByMemberKeyNumeric] =>
[OriginatingSystemMediaKey] => 35071784
[PropertySubTypeAdditional] =>
[MediaModificationTimestamp] => 2026-10-27T13:30:48.690-00:00
[SourceSystemResourceRecordKey] =>
[InternetEntireListingDisplayYN] => 1
[OriginatingSystemResourceRecordId] =>
[OriginatingSystemResourceRecordKey] => 35071779
)
[3] => Array
(
[Order] => 4
[ImageOf] =>
[ListAOR] =>
[MediaKey] => 2006147863616
[MediaURL] => https://cdn.realtyfeed.com/cdn/76/1193954020/d265ee3762b87dd205dcb2c1bd7285be.webp
[ClassName] =>
[MediaHTML] =>
[MediaSize] => 760648
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/76/1193954020/thumbnail-d265ee3762b87dd205dcb2c1bd7285be.webp
[ImageWidth] =>
[Permission] =>
[ImageHeight] =>
[MediaStatus] => Active
[SyndicateTo] =>
[ListAgentKey] => 25264407
[PropertyType] => Residential
[ResourceName] => Property
[ListOfficeKey] => 5658935
[MediaCategory] => Photo
[MediaObjectID] => 1856449_122047382.jpg
[OffMarketDate] =>
[X_MediaStream] =>
[SourceSystemID] => TRESTLE
[StandardStatus] => Active
[HumanModifiedYN] =>
[ListOfficeMlsId] => 5339
[LongDescription] => Photo 4
[MediaAlteration] =>
[MediaKeyNumeric] => 2006147863616
[PropertySubType] => Single Family Residence
[RecordSignature] => -444130555
[OriginalMediaUrl] =>
[PreferredPhotoYN] =>
[ResourceRecordID] => RLS20122849
[ShortDescription] =>
[SourceSystemName] =>
[ChangedByMemberID] =>
[ListingPermission] => IDX
[ResourceRecordKey] => 1193954020
[ChangedByMemberKey] =>
[MediaClassification] => PHOTO
[OriginatingSystemID] =>
[ImageSizeDescription] =>
[SourceSystemMediaKey] => RLMX-00103122047382
[ModificationTimestamp] => 2026-10-27T13:30:48.690-00:00
[OriginatingSystemName] => RLS
[MediaStatusDescription] =>
[OriginatingSystemSubName] => RLS_REBNY
[ResourceRecordKeyNumeric] => 1193954020
[ChangedByMemberKeyNumeric] =>
[OriginatingSystemMediaKey] => 35071785
[PropertySubTypeAdditional] =>
[MediaModificationTimestamp] => 2026-10-27T13:30:48.690-00:00
[SourceSystemResourceRecordKey] =>
[InternetEntireListingDisplayYN] => 1
[OriginatingSystemResourceRecordId] =>
[OriginatingSystemResourceRecordKey] => 35071779
)
[4] => Array
(
[Order] => 5
[ImageOf] =>
[ListAOR] =>
[MediaKey] => 2006147863617
[MediaURL] => https://cdn.realtyfeed.com/cdn/76/1193954020/5634fa9ce182c76132133b418d807f4b.webp
[ClassName] =>
[MediaHTML] =>
[MediaSize] => 816505
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/76/1193954020/thumbnail-5634fa9ce182c76132133b418d807f4b.webp
[ImageWidth] =>
[Permission] =>
[ImageHeight] =>
[MediaStatus] => Active
[SyndicateTo] =>
[ListAgentKey] => 25264407
[PropertyType] => Residential
[ResourceName] => Property
[ListOfficeKey] => 5658935
[MediaCategory] => Photo
[MediaObjectID] => 1856449_122047383.jpg
[OffMarketDate] =>
[X_MediaStream] =>
[SourceSystemID] => TRESTLE
[StandardStatus] => Active
[HumanModifiedYN] =>
[ListOfficeMlsId] => 5339
[LongDescription] => Photo 5
[MediaAlteration] =>
[MediaKeyNumeric] => 2006147863617
[PropertySubType] => Single Family Residence
[RecordSignature] => -444130555
[OriginalMediaUrl] =>
[PreferredPhotoYN] =>
[ResourceRecordID] => RLS20122849
[ShortDescription] =>
[SourceSystemName] =>
[ChangedByMemberID] =>
[ListingPermission] => IDX
[ResourceRecordKey] => 1193954020
[ChangedByMemberKey] =>
[MediaClassification] => PHOTO
[OriginatingSystemID] =>
[ImageSizeDescription] =>
[SourceSystemMediaKey] => RLMX-00103122047383
[ModificationTimestamp] => 2026-10-27T13:30:48.690-00:00
[OriginatingSystemName] => RLS
[MediaStatusDescription] =>
[OriginatingSystemSubName] => RLS_REBNY
[ResourceRecordKeyNumeric] => 1193954020
[ChangedByMemberKeyNumeric] =>
[OriginatingSystemMediaKey] => 35071786
[PropertySubTypeAdditional] =>
[MediaModificationTimestamp] => 2026-10-27T13:30:48.690-00:00
[SourceSystemResourceRecordKey] =>
[InternetEntireListingDisplayYN] => 1
[OriginatingSystemResourceRecordId] =>
[OriginatingSystemResourceRecordKey] => 35071779
)
[5] => Array
(
[Order] => 6
[ImageOf] =>
[ListAOR] =>
[MediaKey] => 2006147863618
[MediaURL] => https://cdn.realtyfeed.com/cdn/76/1193954020/35b3d213c402092a9ae00782a2498e0a.webp
[ClassName] =>
[MediaHTML] =>
[MediaSize] => 993727
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/76/1193954020/thumbnail-35b3d213c402092a9ae00782a2498e0a.webp
[ImageWidth] =>
[Permission] =>
[ImageHeight] =>
[MediaStatus] => Active
[SyndicateTo] =>
[ListAgentKey] => 25264407
[PropertyType] => Residential
[ResourceName] => Property
[ListOfficeKey] => 5658935
[MediaCategory] => Photo
[MediaObjectID] => 1856449_122047384.jpg
[OffMarketDate] =>
[X_MediaStream] =>
[SourceSystemID] => TRESTLE
[StandardStatus] => Active
[HumanModifiedYN] =>
[ListOfficeMlsId] => 5339
[LongDescription] => Photo 6
[MediaAlteration] =>
[MediaKeyNumeric] => 2006147863618
[PropertySubType] => Single Family Residence
[RecordSignature] => -444130555
[OriginalMediaUrl] =>
[PreferredPhotoYN] =>
[ResourceRecordID] => RLS20122849
[ShortDescription] =>
[SourceSystemName] =>
[ChangedByMemberID] =>
[ListingPermission] => IDX
[ResourceRecordKey] => 1193954020
[ChangedByMemberKey] =>
[MediaClassification] => PHOTO
[OriginatingSystemID] =>
[ImageSizeDescription] =>
[SourceSystemMediaKey] => RLMX-00103122047384
[ModificationTimestamp] => 2026-10-27T13:30:48.690-00:00
[OriginatingSystemName] => RLS
[MediaStatusDescription] =>
[OriginatingSystemSubName] => RLS_REBNY
[ResourceRecordKeyNumeric] => 1193954020
[ChangedByMemberKeyNumeric] =>
[OriginatingSystemMediaKey] => 35071787
[PropertySubTypeAdditional] =>
[MediaModificationTimestamp] => 2026-10-27T13:30:48.690-00:00
[SourceSystemResourceRecordKey] =>
[InternetEntireListingDisplayYN] => 1
[OriginatingSystemResourceRecordId] =>
[OriginatingSystemResourceRecordKey] => 35071779
)
[6] => Array
(
[Order] => 7
[ImageOf] =>
[ListAOR] =>
[MediaKey] => 2006147863619
[MediaURL] => https://cdn.realtyfeed.com/cdn/76/1193954020/ef9b5aba7c32ed09a4a8116a3362b30f.webp
[ClassName] =>
[MediaHTML] =>
[MediaSize] => 1207019
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/76/1193954020/thumbnail-ef9b5aba7c32ed09a4a8116a3362b30f.webp
[ImageWidth] =>
[Permission] =>
[ImageHeight] =>
[MediaStatus] => Active
[SyndicateTo] =>
[ListAgentKey] => 25264407
[PropertyType] => Residential
[ResourceName] => Property
[ListOfficeKey] => 5658935
[MediaCategory] => Photo
[MediaObjectID] => 1856449_122047386.jpg
[OffMarketDate] =>
[X_MediaStream] =>
[SourceSystemID] => TRESTLE
[StandardStatus] => Active
[HumanModifiedYN] =>
[ListOfficeMlsId] => 5339
[LongDescription] => Photo 7
[MediaAlteration] =>
[MediaKeyNumeric] => 2006147863619
[PropertySubType] => Single Family Residence
[RecordSignature] => -444130555
[OriginalMediaUrl] =>
[PreferredPhotoYN] =>
[ResourceRecordID] => RLS20122849
[ShortDescription] =>
[SourceSystemName] =>
[ChangedByMemberID] =>
[ListingPermission] => IDX
[ResourceRecordKey] => 1193954020
[ChangedByMemberKey] =>
[MediaClassification] => PHOTO
[OriginatingSystemID] =>
[ImageSizeDescription] =>
[SourceSystemMediaKey] => RLMX-00103122047386
[ModificationTimestamp] => 2026-10-27T13:30:48.690-00:00
[OriginatingSystemName] => RLS
[MediaStatusDescription] =>
[OriginatingSystemSubName] => RLS_REBNY
[ResourceRecordKeyNumeric] => 1193954020
[ChangedByMemberKeyNumeric] =>
[OriginatingSystemMediaKey] => 35071788
[PropertySubTypeAdditional] =>
[MediaModificationTimestamp] => 2026-10-27T13:30:48.690-00:00
[SourceSystemResourceRecordKey] =>
[InternetEntireListingDisplayYN] => 1
[OriginatingSystemResourceRecordId] =>
[OriginatingSystemResourceRecordKey] => 35071779
)
[7] => Array
(
[Order] => 8
[ImageOf] =>
[ListAOR] =>
[MediaKey] => 2006147863620
[MediaURL] => https://cdn.realtyfeed.com/cdn/76/1193954020/b17ab5fc2d94cb3fb13e3c88c60e1ee8.webp
[ClassName] =>
[MediaHTML] =>
[MediaSize] => 864546
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/76/1193954020/thumbnail-b17ab5fc2d94cb3fb13e3c88c60e1ee8.webp
[ImageWidth] =>
[Permission] =>
[ImageHeight] =>
[MediaStatus] => Active
[SyndicateTo] =>
[ListAgentKey] => 25264407
[PropertyType] => Residential
[ResourceName] => Property
[ListOfficeKey] => 5658935
[MediaCategory] => Photo
[MediaObjectID] => 1856449_122047389.jpg
[OffMarketDate] =>
[X_MediaStream] =>
[SourceSystemID] => TRESTLE
[StandardStatus] => Active
[HumanModifiedYN] =>
[ListOfficeMlsId] => 5339
[LongDescription] => Photo 8
[MediaAlteration] =>
[MediaKeyNumeric] => 2006147863620
[PropertySubType] => Single Family Residence
[RecordSignature] => -444130555
[OriginalMediaUrl] =>
[PreferredPhotoYN] =>
[ResourceRecordID] => RLS20122849
[ShortDescription] =>
[SourceSystemName] =>
[ChangedByMemberID] =>
[ListingPermission] => IDX
[ResourceRecordKey] => 1193954020
[ChangedByMemberKey] =>
[MediaClassification] => PHOTO
[OriginatingSystemID] =>
[ImageSizeDescription] =>
[SourceSystemMediaKey] => RLMX-00103122047389
[ModificationTimestamp] => 2026-10-27T13:30:48.690-00:00
[OriginatingSystemName] => RLS
[MediaStatusDescription] =>
[OriginatingSystemSubName] => RLS_REBNY
[ResourceRecordKeyNumeric] => 1193954020
[ChangedByMemberKeyNumeric] =>
[OriginatingSystemMediaKey] => 35071789
[PropertySubTypeAdditional] =>
[MediaModificationTimestamp] => 2026-10-27T13:30:48.690-00:00
[SourceSystemResourceRecordKey] =>
[InternetEntireListingDisplayYN] => 1
[OriginatingSystemResourceRecordId] =>
[OriginatingSystemResourceRecordKey] => 35071779
)
[8] => Array
(
[Order] => 9
[ImageOf] =>
[ListAOR] =>
[MediaKey] => 2006147863621
[MediaURL] => https://cdn.realtyfeed.com/cdn/76/1193954020/7945f398b37123639ce842de8db228b8.webp
[ClassName] =>
[MediaHTML] =>
[MediaSize] => 837396
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/76/1193954020/thumbnail-7945f398b37123639ce842de8db228b8.webp
[ImageWidth] =>
[Permission] =>
[ImageHeight] =>
[MediaStatus] => Active
[SyndicateTo] =>
[ListAgentKey] => 25264407
[PropertyType] => Residential
[ResourceName] => Property
[ListOfficeKey] => 5658935
[MediaCategory] => Photo
[MediaObjectID] => 1856449_122047390.jpg
[OffMarketDate] =>
[X_MediaStream] =>
[SourceSystemID] => TRESTLE
[StandardStatus] => Active
[HumanModifiedYN] =>
[ListOfficeMlsId] => 5339
[LongDescription] => Photo 9
[MediaAlteration] =>
[MediaKeyNumeric] => 2006147863621
[PropertySubType] => Single Family Residence
[RecordSignature] => -444130555
[OriginalMediaUrl] =>
[PreferredPhotoYN] =>
[ResourceRecordID] => RLS20122849
[ShortDescription] =>
[SourceSystemName] =>
[ChangedByMemberID] =>
[ListingPermission] => IDX
[ResourceRecordKey] => 1193954020
[ChangedByMemberKey] =>
[MediaClassification] => PHOTO
[OriginatingSystemID] =>
[ImageSizeDescription] =>
[SourceSystemMediaKey] => RLMX-00103122047390
[ModificationTimestamp] => 2026-10-27T13:30:48.690-00:00
[OriginatingSystemName] => RLS
[MediaStatusDescription] =>
[OriginatingSystemSubName] => RLS_REBNY
[ResourceRecordKeyNumeric] => 1193954020
[ChangedByMemberKeyNumeric] =>
[OriginatingSystemMediaKey] => 35071790
[PropertySubTypeAdditional] =>
[MediaModificationTimestamp] => 2026-10-27T13:30:48.690-00:00
[SourceSystemResourceRecordKey] =>
[InternetEntireListingDisplayYN] => 1
[OriginatingSystemResourceRecordId] =>
[OriginatingSystemResourceRecordKey] => 35071779
)
[9] => Array
(
[Order] => 10
[ImageOf] =>
[ListAOR] =>
[MediaKey] => 2006147863622
[MediaURL] => https://cdn.realtyfeed.com/cdn/76/1193954020/0cdd4b04aa28f6258512c2311d6c8b69.webp
[ClassName] =>
[MediaHTML] =>
[MediaSize] => 745657
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/76/1193954020/thumbnail-0cdd4b04aa28f6258512c2311d6c8b69.webp
[ImageWidth] =>
[Permission] =>
[ImageHeight] =>
[MediaStatus] => Active
[SyndicateTo] =>
[ListAgentKey] => 25264407
[PropertyType] => Residential
[ResourceName] => Property
[ListOfficeKey] => 5658935
[MediaCategory] => Photo
[MediaObjectID] => 1856449_122047387.jpg
[OffMarketDate] =>
[X_MediaStream] =>
[SourceSystemID] => TRESTLE
[StandardStatus] => Active
[HumanModifiedYN] =>
[ListOfficeMlsId] => 5339
[LongDescription] => Photo 10
[MediaAlteration] =>
[MediaKeyNumeric] => 2006147863622
[PropertySubType] => Single Family Residence
[RecordSignature] => -444130555
[OriginalMediaUrl] =>
[PreferredPhotoYN] =>
[ResourceRecordID] => RLS20122849
[ShortDescription] =>
[SourceSystemName] =>
[ChangedByMemberID] =>
[ListingPermission] => IDX
[ResourceRecordKey] => 1193954020
[ChangedByMemberKey] =>
[MediaClassification] => PHOTO
[OriginatingSystemID] =>
[ImageSizeDescription] =>
[SourceSystemMediaKey] => RLMX-00103122047387
[ModificationTimestamp] => 2026-10-27T13:30:48.690-00:00
[OriginatingSystemName] => RLS
[MediaStatusDescription] =>
[OriginatingSystemSubName] => RLS_REBNY
[ResourceRecordKeyNumeric] => 1193954020
[ChangedByMemberKeyNumeric] =>
[OriginatingSystemMediaKey] => 35071791
[PropertySubTypeAdditional] =>
[MediaModificationTimestamp] => 2026-10-27T13:30:48.690-00:00
[SourceSystemResourceRecordKey] =>
[InternetEntireListingDisplayYN] => 1
[OriginatingSystemResourceRecordId] =>
[OriginatingSystemResourceRecordKey] => 35071779
)
[10] => Array
(
[Order] => 11
[ImageOf] =>
[ListAOR] =>
[MediaKey] => 2006147863623
[MediaURL] => https://cdn.realtyfeed.com/cdn/76/1193954020/72f408742ae4abe2f8a0f4e6037e9272.webp
[ClassName] =>
[MediaHTML] =>
[MediaSize] => 825507
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/76/1193954020/thumbnail-72f408742ae4abe2f8a0f4e6037e9272.webp
[ImageWidth] =>
[Permission] =>
[ImageHeight] =>
[MediaStatus] => Active
[SyndicateTo] =>
[ListAgentKey] => 25264407
[PropertyType] => Residential
[ResourceName] => Property
[ListOfficeKey] => 5658935
[MediaCategory] => Photo
[MediaObjectID] => 1856449_122047391.jpg
[OffMarketDate] =>
[X_MediaStream] =>
[SourceSystemID] => TRESTLE
[StandardStatus] => Active
[HumanModifiedYN] =>
[ListOfficeMlsId] => 5339
[LongDescription] => Photo 11
[MediaAlteration] =>
[MediaKeyNumeric] => 2006147863623
[PropertySubType] => Single Family Residence
[RecordSignature] => -444130555
[OriginalMediaUrl] =>
[PreferredPhotoYN] =>
[ResourceRecordID] => RLS20122849
[ShortDescription] =>
[SourceSystemName] =>
[ChangedByMemberID] =>
[ListingPermission] => IDX
[ResourceRecordKey] => 1193954020
[ChangedByMemberKey] =>
[MediaClassification] => PHOTO
[OriginatingSystemID] =>
[ImageSizeDescription] =>
[SourceSystemMediaKey] => RLMX-00103122047391
[ModificationTimestamp] => 2026-10-27T13:30:48.690-00:00
[OriginatingSystemName] => RLS
[MediaStatusDescription] =>
[OriginatingSystemSubName] => RLS_REBNY
[ResourceRecordKeyNumeric] => 1193954020
[ChangedByMemberKeyNumeric] =>
[OriginatingSystemMediaKey] => 35071792
[PropertySubTypeAdditional] =>
[MediaModificationTimestamp] => 2026-10-27T13:30:48.690-00:00
[SourceSystemResourceRecordKey] =>
[InternetEntireListingDisplayYN] => 1
[OriginatingSystemResourceRecordId] =>
[OriginatingSystemResourceRecordKey] => 35071779
)
[11] => Array
(
[Order] => 12
[ImageOf] =>
[ListAOR] =>
[MediaKey] => 2006147863716
[MediaURL] => https://cdn.realtyfeed.com/cdn/76/1193954020/906d51bf5c5bc1afa10fc4bce2786c26.webp
[ClassName] =>
[MediaHTML] =>
[MediaSize] => 1395911
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/76/1193954020/thumbnail-906d51bf5c5bc1afa10fc4bce2786c26.webp
[ImageWidth] =>
[Permission] =>
[ImageHeight] =>
[MediaStatus] => Active
[SyndicateTo] =>
[ListAgentKey] => 25264407
[PropertyType] => Residential
[ResourceName] => Property
[ListOfficeKey] => 5658935
[MediaCategory] => Photo
[MediaObjectID] => 1856449_122047392.jpg
[OffMarketDate] =>
[X_MediaStream] =>
[SourceSystemID] => TRESTLE
[StandardStatus] => Active
[HumanModifiedYN] =>
[ListOfficeMlsId] => 5339
[LongDescription] => Photo 12
[MediaAlteration] =>
[MediaKeyNumeric] => 2006147863716
[PropertySubType] => Single Family Residence
[RecordSignature] => -444130555
[OriginalMediaUrl] =>
[PreferredPhotoYN] =>
[ResourceRecordID] => RLS20122849
[ShortDescription] =>
[SourceSystemName] =>
[ChangedByMemberID] =>
[ListingPermission] => IDX
[ResourceRecordKey] => 1193954020
[ChangedByMemberKey] =>
[MediaClassification] => PHOTO
[OriginatingSystemID] =>
[ImageSizeDescription] =>
[SourceSystemMediaKey] => RLMX-00103122047392
[ModificationTimestamp] => 2026-10-27T13:30:48.690-00:00
[OriginatingSystemName] => RLS
[MediaStatusDescription] =>
[OriginatingSystemSubName] => RLS_REBNY
[ResourceRecordKeyNumeric] => 1193954020
[ChangedByMemberKeyNumeric] =>
[OriginatingSystemMediaKey] => 35071793
[PropertySubTypeAdditional] =>
[MediaModificationTimestamp] => 2026-10-27T13:30:48.690-00:00
[SourceSystemResourceRecordKey] =>
[InternetEntireListingDisplayYN] => 1
[OriginatingSystemResourceRecordId] =>
[OriginatingSystemResourceRecordKey] => 35071779
)
[12] => Array
(
[Order] => 13
[ImageOf] =>
[ListAOR] =>
[MediaKey] => 2006147863717
[MediaURL] => https://cdn.realtyfeed.com/cdn/76/1193954020/9b8ae5b4f4a3a739638b07e46ed45c60.webp
[ClassName] =>
[MediaHTML] =>
[MediaSize] => 1202690
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/76/1193954020/thumbnail-9b8ae5b4f4a3a739638b07e46ed45c60.webp
[ImageWidth] =>
[Permission] =>
[ImageHeight] =>
[MediaStatus] => Active
[SyndicateTo] =>
[ListAgentKey] => 25264407
[PropertyType] => Residential
[ResourceName] => Property
[ListOfficeKey] => 5658935
[MediaCategory] => Photo
[MediaObjectID] => 1856449_122047395.jpg
[OffMarketDate] =>
[X_MediaStream] =>
[SourceSystemID] => TRESTLE
[StandardStatus] => Active
[HumanModifiedYN] =>
[ListOfficeMlsId] => 5339
[LongDescription] => Photo 13
[MediaAlteration] =>
[MediaKeyNumeric] => 2006147863717
[PropertySubType] => Single Family Residence
[RecordSignature] => -444130555
[OriginalMediaUrl] =>
[PreferredPhotoYN] =>
[ResourceRecordID] => RLS20122849
[ShortDescription] =>
[SourceSystemName] =>
[ChangedByMemberID] =>
[ListingPermission] => IDX
[ResourceRecordKey] => 1193954020
[ChangedByMemberKey] =>
[MediaClassification] => PHOTO
[OriginatingSystemID] =>
[ImageSizeDescription] =>
[SourceSystemMediaKey] => RLMX-00103122047395
[ModificationTimestamp] => 2026-10-27T13:30:48.690-00:00
[OriginatingSystemName] => RLS
[MediaStatusDescription] =>
[OriginatingSystemSubName] => RLS_REBNY
[ResourceRecordKeyNumeric] => 1193954020
[ChangedByMemberKeyNumeric] =>
[OriginatingSystemMediaKey] => 35071794
[PropertySubTypeAdditional] =>
[MediaModificationTimestamp] => 2026-10-27T13:30:48.690-00:00
[SourceSystemResourceRecordKey] =>
[InternetEntireListingDisplayYN] => 1
[OriginatingSystemResourceRecordId] =>
[OriginatingSystemResourceRecordKey] => 35071779
)
[13] => Array
(
[Order] => 14
[ImageOf] =>
[ListAOR] =>
[MediaKey] => 2006147863718
[MediaURL] => https://cdn.realtyfeed.com/cdn/76/1193954020/2d10b591231002922122f51d29fcdfed.webp
[ClassName] =>
[MediaHTML] =>
[MediaSize] => 1461079
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/76/1193954020/thumbnail-2d10b591231002922122f51d29fcdfed.webp
[ImageWidth] =>
[Permission] =>
[ImageHeight] =>
[MediaStatus] => Active
[SyndicateTo] =>
[ListAgentKey] => 25264407
[PropertyType] => Residential
[ResourceName] => Property
[ListOfficeKey] => 5658935
[MediaCategory] => Photo
[MediaObjectID] => 1856449_122047394.jpg
[OffMarketDate] =>
[X_MediaStream] =>
[SourceSystemID] => TRESTLE
[StandardStatus] => Active
[HumanModifiedYN] =>
[ListOfficeMlsId] => 5339
[LongDescription] => Photo 14
[MediaAlteration] =>
[MediaKeyNumeric] => 2006147863718
[PropertySubType] => Single Family Residence
[RecordSignature] => -444130555
[OriginalMediaUrl] =>
[PreferredPhotoYN] =>
[ResourceRecordID] => RLS20122849
[ShortDescription] =>
[SourceSystemName] =>
[ChangedByMemberID] =>
[ListingPermission] => IDX
[ResourceRecordKey] => 1193954020
[ChangedByMemberKey] =>
[MediaClassification] => PHOTO
[OriginatingSystemID] =>
[ImageSizeDescription] =>
[SourceSystemMediaKey] => RLMX-00103122047394
[ModificationTimestamp] => 2026-10-27T13:30:48.690-00:00
[OriginatingSystemName] => RLS
[MediaStatusDescription] =>
[OriginatingSystemSubName] => RLS_REBNY
[ResourceRecordKeyNumeric] => 1193954020
[ChangedByMemberKeyNumeric] =>
[OriginatingSystemMediaKey] => 35071795
[PropertySubTypeAdditional] =>
[MediaModificationTimestamp] => 2026-10-27T13:30:48.690-00:00
[SourceSystemResourceRecordKey] =>
[InternetEntireListingDisplayYN] => 1
[OriginatingSystemResourceRecordId] =>
[OriginatingSystemResourceRecordKey] => 35071779
)
[14] => Array
(
[Order] => 15
[ImageOf] =>
[ListAOR] =>
[MediaKey] => 2006147863719
[MediaURL] => https://cdn.realtyfeed.com/cdn/76/1193954020/f58c50ac3f9c83b2fa515539753c706a.webp
[ClassName] =>
[MediaHTML] =>
[MediaSize] => 1371681
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/76/1193954020/thumbnail-f58c50ac3f9c83b2fa515539753c706a.webp
[ImageWidth] =>
[Permission] =>
[ImageHeight] =>
[MediaStatus] => Active
[SyndicateTo] =>
[ListAgentKey] => 25264407
[PropertyType] => Residential
[ResourceName] => Property
[ListOfficeKey] => 5658935
[MediaCategory] => Photo
[MediaObjectID] => 1856449_122047393.jpg
[OffMarketDate] =>
[X_MediaStream] =>
[SourceSystemID] => TRESTLE
[StandardStatus] => Active
[HumanModifiedYN] =>
[ListOfficeMlsId] => 5339
[LongDescription] => Photo 15
[MediaAlteration] =>
[MediaKeyNumeric] => 2006147863719
[PropertySubType] => Single Family Residence
[RecordSignature] => -444130555
[OriginalMediaUrl] =>
[PreferredPhotoYN] =>
[ResourceRecordID] => RLS20122849
[ShortDescription] =>
[SourceSystemName] =>
[ChangedByMemberID] =>
[ListingPermission] => IDX
[ResourceRecordKey] => 1193954020
[ChangedByMemberKey] =>
[MediaClassification] => PHOTO
[OriginatingSystemID] =>
[ImageSizeDescription] =>
[SourceSystemMediaKey] => RLMX-00103122047393
[ModificationTimestamp] => 2026-10-27T13:30:48.690-00:00
[OriginatingSystemName] => RLS
[MediaStatusDescription] =>
[OriginatingSystemSubName] => RLS_REBNY
[ResourceRecordKeyNumeric] => 1193954020
[ChangedByMemberKeyNumeric] =>
[OriginatingSystemMediaKey] => 35071796
[PropertySubTypeAdditional] =>
[MediaModificationTimestamp] => 2026-10-27T13:30:48.690-00:00
[SourceSystemResourceRecordKey] =>
[InternetEntireListingDisplayYN] => 1
[OriginatingSystemResourceRecordId] =>
[OriginatingSystemResourceRecordKey] => 35071779
)
)
[DaysOnMarket] => 12
[ID] => 1800209
)
Description
Turn-Key Luxury in Prime Douglaston
Welcome to this stunning, completely renovated Douglaston residence where custom craftsmanship, modern luxury, and exceptional outdoor living come together. Renovated from top to bottom, this beautifully appointed home is truly move-in ready and designed for todays lifestyle.
From the curb, the property impresses with gorgeous landscaping, extensive stonework, elegant outdoor lighting, and a heated driveway. Step inside to soaring cathedral ceilings, skylights, custom finishes, and a beautiful fireplace creating a warm and sophisticated ambiance.
The showstopping chefs kitchen features a large center island, beautiful finishes, and plenty of space for everyday living and entertaining. Smart-home technology, alarm system, and separate-zone A/C provide modern comfort and convenience throughout.
The outdoor space is an entertainers dream, featuring a built-in gas grill, outdoor speakers, and custom lighting, creating the perfect setting for summer gatherings, dinner parties, and unforgettable evenings.
This exceptional home offers 3 bedrooms, 2 full baths, a fully finished basement, and a 1-car garage. Every space has been thoughtfully renovated with attention to quality, style, and functionality.
Located on a quiet and desirable Douglaston block, conveniently near the Douglaston LIRR station and close to the prestigious Douglaston Manor, this home offers privacy and tranquility while keeping you close to transportation and neighborhood conveniences.
Beautifully renovated. Exceptionally finished. Designed to entertain. This is the Douglaston home youve been waiting for.
BOND New York Properties is a licensed real estate broker that proudly supports equal housing opportunity.
Address
Open on Google Maps-
Address: 41-08 Orient Avenue
-
City: New York City
-
State/county: NY
-
Zip/Postal Code: 11363
-
Area: Bayside
Details
Updated on November 5, 2026 at 4:22 am-
Property ID RLS20122849
-
Price $1,988,888
-
Bedrooms 3
-
Rooms 6
-
Bathrooms 2
-
Garage Size x x
-
Year Built 1950
-
Type Single Family Residence, Residential
-
Property Status Active, For Sale
Additional details
-
Cooling Central Air
-
Heating Radiant
-
Flooring Hardwood
-
County Queens
-
Property Type Residential
-
Parking Garage
Mortgage Calculator
-
Down Payment
-
Loan Amount
-
Monthly Mortgage Payment
-
Property Tax
-
Home Insurance
-
PMI
-
Monthly HOA Fees
