Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty Object
(
[post_id] => 1792963
[post_author] => 1
[ListingKey] => 1187633403
[ListingId] => RLS20111474
[PropertyType] => Residential
[PropertySubType] => Single Family Residence
[StandardStatus] => Active
[ModificationTimestamp] => 2026-09-03T15:19:41Z
[RFModificationTimestamp] => 2026-09-03T15:22:20Z
[ListPrice] => 779000
[BathroomsTotalInteger] => 2
[BathroomsHalf] => 0
[BedroomsTotal] => 3
[LotSizeArea] => 1800
[LivingArea] => 1500
[BuildingAreaTotal] => 1500
[City] => New York City
[PostalCode] => 11697
[UnparsedAddress] => 2-49 Hillside Avenue, New York City, New York 11697
[Coordinates] => Array
(
[0] => -73.8905401
[1] => 40.5668638
)
[Latitude] => 40.5668638
[Longitude] => -73.8905401
[YearBuilt] => 1938
[InternetAddressDisplayYN] => 1
[FeedTypes] => IDX
[ListAgentFullName] => Kelly A Brunton
[ListOfficeName] => Corcoran Group
[ListAgentMlsId] => 36298
[ListOfficeMlsId] => 40076
[OriginatingSystemName] => RLS
[PublicRemarks] => Welcome to 249 Hillside Avenue in Roxbury. This charming two-story home offers three spacious bedrooms, two full bathrooms and is in close proximity to the bay and parking. The bright, open layout on the first floor seamlessly connects the kitchen, dining and living areas to a sizable screened-in porch and large front deck. The kitchen features stainless-steel appliances, a generous island with seating, plenty of cabinet space and flows right into the dining area. The living room has sliders that lead out to the screened in porch allowing you to easily expand your living space. First-floor amenities include radiant heating and central air, while abundant natural light enhances the open design. There is also a full bathroom, coat closet and access to the mechanicals on this floor.
Upstairs, you'll find three generous bedrooms with large closets, along with a full bathroom and a convenient washer/dryer. Additional features of the home include an outdoor shower, two attic storage spaces, and an unfinished basement with versatile potential. Conveniently located near the bay and parking makes this home just perfect.
[ActivationDate] => 2026-08-21
[AssociationFeeFrequency] => Monthly
[BathroomsFull] => 2
[BuildingAreaUnits] => Square Feet
[CLIP] => 1122832139
[CityRegion] => Queens
[CoListAgentAOR] => Real Estate Board of New York
[CoListAgentDirectPhone] => (917) 309-4246
[CoListAgentEmail] => kristin.neinast@corcoran.com
[CoListAgentFirstName] => Kristin
[CoListAgentFullName] => Kristin M Obrien
[CoListAgentKey] => 25250963
[CoListAgentKeyNumeric] => 25250963
[CoListAgentLastName] => Obrien
[CoListAgentMiddleName] => M
[CoListAgentMlsId] => 52612
[CoListAgentPreferredPhone] => (917) 309-4246
[CoListOfficeAOR] => Real Estate Board of New York
[CoListOfficeEmail] => info@corcoran.com
[CoListOfficeKey] => 6607384
[CoListOfficeKeyNumeric] => 6607384
[CoListOfficeMlsId] => 40076
[CoListOfficeName] => Corcoran Group
[CoListOfficePhone] => 7184993700
[CommonInterest] => None
[ContractStatusChangeDate] => 2026-08-21
[CountyOrParish] => Queens
[CreationDate] => 2026-08-27T22:50:33.872093+00:00
[DocumentsChangeTimestamp] => 2026-09-03T11:18:59Z
[DocumentsCount] => 1
[EntryLevel] => 1
[ExteriorFeatures] => Private Outdoor Space Over 60 Sqft
[Furnished] => Unfurnished
[HumanModifiedYN] => 1
[RFTransactionType] => For Sale
[InternetAutomatedValuationDisplayYN] => 1
[InternetConsumerCommentYN] => 1
[InternetEntireListingDisplayYN] => 1
[LaundryFeatures] => See Remarks
[Levels] => Two
[ListAgentAOR] => Real Estate Board of New York
[ListAgentDirectPhone] => (646) 345-3431
[ListAgentEmail] => kkn@corcoran.com
[ListAgentFirstName] => Kelly
[ListAgentKey] => 25256584
[ListAgentKeyNumeric] => 25256584
[ListAgentLastName] => Brunton
[ListAgentMiddleName] => A
[ListAgentPreferredPhone] => (646) 345-3431
[ListOfficeAOR] => Real Estate Board of New York
[ListOfficeEmail] => info@corcoran.com
[ListOfficeKey] => 6607384
[ListOfficeKeyNumeric] => 6607384
[ListOfficePhone] => 7184993700
[ListingAgreement] => Exclusive Agency
[ListingContractDate] => 2026-08-21
[ListingKeyNumeric] => 1187633403
[ListingURL] => https://www.corcoran.com/search/for-sale?address=2-49+Hillside+Ave&viewBox=40.9152,-73.7002,40.4961,-74.2557
[LotSizeDimensions] => 1800 x 1
[MajorChangeTimestamp] => 2026-08-27T18:49:06Z
[MajorChangeType] => New Listing
[NumberOfUnitsTotal] => 1
[OnMarketDate] => 2026-08-27
[OnMarketTimestamp] => 2026-08-27T00:00:00Z
[OriginalEntryTimestamp] => 2026-08-27T18:49:06Z
[OriginalListPrice] => 779000
[OriginatingSystemKey] => 34700657
[OriginatingSystemModificationTimestamp] => 2026-09-03T11:18:59Z
[OriginatingSystemSubName] => RLS_REBNY
[Permission] => IDX
[PetsAllowed] => Building No,No
[PhotosChangeTimestamp] => 2026-09-03T15:20:01Z
[PhotosCount] => 12
[PostalCity] => Queens
[PriceChangeTimestamp] => 2026-08-27T18:49:06Z
[RoomsTotal] => 8
[SourceSystemID] => TRESTLE
[StateOrProvince] => NY
[StatusChangeTimestamp] => 2026-08-27T18:49:06Z
[Stories] => 2
[StoriesTotal] => 2
[StreetName] => Hillside
[StreetNumber] => 2-49
[StreetNumberNumeric] => 2
[StreetSuffix] => Avenue
[StructureType] => House
[SubdivisionName] => Breezy Point
[TaxBlock] => 16340
[TaxLot] => 0050
[VideosChangeTimestamp] => 2026-09-03T15:20:01Z
[CustomFields] => {
"ElevatorsTotal": "0",
"PercentOfCommonElements": "100.00",
"LandmarkStatusYN": "0",
"TaxAbatementYN": "0",
"BuildingTaxLot": "0050",
"AttendanceType": "None",
"PrivateOutdoorSpaceSize": "GreaterThan60SqFt",
"FurnishedListPrice": "779000.00",
"MaximumFinancingPercent": "100.00",
"SponsorUnitYN": "0",
"ListingKey": "1187633403"
}
[AdditionalFeeYN] =>
[FractionalShare] => 100.00
[SourceFloorPlansCount] => 0
[BuildingSizeDimensions] => 16.5x35
[@odata.id] => https://api.realtyfeed.com/realtyfeed/odata/Property('1187633403')
[CurrentPrice] => 779000
[PetsComments] => ,
[provider_name] => REBNY
[RecordSignature] => 375452206
[ListAgentNickname] => Kelly
[CountrySubdivision] => 36081
[CoListAgentNickname] => Kristin
[OriginatingSystemListOfficeKey] => 33959233
[OriginatingSystemCoListOfficeKey] => 33959233
[OriginatingSystemListAgentMemberKey] => 1242293
[OriginatingSystemCoListAgentMemberKey] => 1252165
[Media] => Array
(
[0] => Array
(
[Order] => 1
[ImageOf] =>
[ListAOR] =>
[MediaKey] => 2005942072795
[MediaURL] => https://cdn.realtyfeed.com/cdn/76/1187633403/3d7af3c83c103f088de58f44b939f446.webp
[ClassName] =>
[MediaHTML] =>
[MediaSize] => 494742
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/76/1187633403/thumbnail-3d7af3c83c103f088de58f44b939f446.webp
[ImageWidth] =>
[Permission] =>
[ImageHeight] =>
[MediaStatus] => Active
[SyndicateTo] =>
[ListAgentKey] => 25256584
[PropertyType] => Residential
[ResourceName] => Property
[ListOfficeKey] => 6607384
[MediaCategory] => Photo
[MediaObjectID] =>
[OffMarketDate] =>
[X_MediaStream] =>
[SourceSystemID] => TRESTLE
[StandardStatus] => Active
[HumanModifiedYN] =>
[ListOfficeMlsId] => 40076
[LongDescription] =>
[MediaAlteration] =>
[MediaKeyNumeric] => 2005942072795
[PropertySubType] => Single Family Residence
[RecordSignature] => 619326689
[OriginalMediaUrl] =>
[PreferredPhotoYN] =>
[ResourceRecordID] => RLS20111474
[ShortDescription] =>
[SourceSystemName] =>
[ChangedByMemberID] =>
[ListingPermission] => IDX
[ResourceRecordKey] => 1187633403
[ChangedByMemberKey] =>
[MediaClassification] => PHOTO
[OriginatingSystemID] =>
[ImageSizeDescription] =>
[SourceSystemMediaKey] =>
[ModificationTimestamp] => 2026-08-27T23:06:53.930-00:00
[OriginatingSystemName] => RLS
[MediaStatusDescription] =>
[OriginatingSystemSubName] => RLS_REBNY
[ResourceRecordKeyNumeric] => 1187633403
[ChangedByMemberKeyNumeric] =>
[OriginatingSystemMediaKey] => 34700658
[PropertySubTypeAdditional] =>
[MediaModificationTimestamp] => 2026-08-27T23:06:00.000-00:00
[SourceSystemResourceRecordKey] =>
[InternetEntireListingDisplayYN] => 1
[OriginatingSystemResourceRecordId] =>
[OriginatingSystemResourceRecordKey] => 34700657
)
[1] => Array
(
[Order] => 2
[ImageOf] =>
[ListAOR] =>
[MediaKey] => 2005942072796
[MediaURL] => https://cdn.realtyfeed.com/cdn/76/1187633403/d0382a27b557dcf444d26ade104ceaa5.webp
[ClassName] =>
[MediaHTML] =>
[MediaSize] => 260846
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/76/1187633403/thumbnail-d0382a27b557dcf444d26ade104ceaa5.webp
[ImageWidth] =>
[Permission] =>
[ImageHeight] =>
[MediaStatus] => Active
[SyndicateTo] =>
[ListAgentKey] => 25256584
[PropertyType] => Residential
[ResourceName] => Property
[ListOfficeKey] => 6607384
[MediaCategory] => Photo
[MediaObjectID] =>
[OffMarketDate] =>
[X_MediaStream] =>
[SourceSystemID] => TRESTLE
[StandardStatus] => Active
[HumanModifiedYN] =>
[ListOfficeMlsId] => 40076
[LongDescription] =>
[MediaAlteration] =>
[MediaKeyNumeric] => 2005942072796
[PropertySubType] => Single Family Residence
[RecordSignature] => 619326689
[OriginalMediaUrl] =>
[PreferredPhotoYN] =>
[ResourceRecordID] => RLS20111474
[ShortDescription] =>
[SourceSystemName] =>
[ChangedByMemberID] =>
[ListingPermission] => IDX
[ResourceRecordKey] => 1187633403
[ChangedByMemberKey] =>
[MediaClassification] => PHOTO
[OriginatingSystemID] =>
[ImageSizeDescription] =>
[SourceSystemMediaKey] =>
[ModificationTimestamp] => 2026-08-27T23:06:53.930-00:00
[OriginatingSystemName] => RLS
[MediaStatusDescription] =>
[OriginatingSystemSubName] => RLS_REBNY
[ResourceRecordKeyNumeric] => 1187633403
[ChangedByMemberKeyNumeric] =>
[OriginatingSystemMediaKey] => 34700659
[PropertySubTypeAdditional] =>
[MediaModificationTimestamp] => 2026-08-27T23:06:00.000-00:00
[SourceSystemResourceRecordKey] =>
[InternetEntireListingDisplayYN] => 1
[OriginatingSystemResourceRecordId] =>
[OriginatingSystemResourceRecordKey] => 34700657
)
[2] => Array
(
[Order] => 3
[ImageOf] =>
[ListAOR] =>
[MediaKey] => 2005942072797
[MediaURL] => https://cdn.realtyfeed.com/cdn/76/1187633403/4c83284e224720dcc55b841296fc79d3.webp
[ClassName] =>
[MediaHTML] =>
[MediaSize] => 260175
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/76/1187633403/thumbnail-4c83284e224720dcc55b841296fc79d3.webp
[ImageWidth] =>
[Permission] =>
[ImageHeight] =>
[MediaStatus] => Active
[SyndicateTo] =>
[ListAgentKey] => 25256584
[PropertyType] => Residential
[ResourceName] => Property
[ListOfficeKey] => 6607384
[MediaCategory] => Photo
[MediaObjectID] =>
[OffMarketDate] =>
[X_MediaStream] =>
[SourceSystemID] => TRESTLE
[StandardStatus] => Active
[HumanModifiedYN] =>
[ListOfficeMlsId] => 40076
[LongDescription] =>
[MediaAlteration] =>
[MediaKeyNumeric] => 2005942072797
[PropertySubType] => Single Family Residence
[RecordSignature] => 619326689
[OriginalMediaUrl] =>
[PreferredPhotoYN] =>
[ResourceRecordID] => RLS20111474
[ShortDescription] =>
[SourceSystemName] =>
[ChangedByMemberID] =>
[ListingPermission] => IDX
[ResourceRecordKey] => 1187633403
[ChangedByMemberKey] =>
[MediaClassification] => PHOTO
[OriginatingSystemID] =>
[ImageSizeDescription] =>
[SourceSystemMediaKey] =>
[ModificationTimestamp] => 2026-08-27T23:06:53.930-00:00
[OriginatingSystemName] => RLS
[MediaStatusDescription] =>
[OriginatingSystemSubName] => RLS_REBNY
[ResourceRecordKeyNumeric] => 1187633403
[ChangedByMemberKeyNumeric] =>
[OriginatingSystemMediaKey] => 34700660
[PropertySubTypeAdditional] =>
[MediaModificationTimestamp] => 2026-08-27T23:06:00.000-00:00
[SourceSystemResourceRecordKey] =>
[InternetEntireListingDisplayYN] => 1
[OriginatingSystemResourceRecordId] =>
[OriginatingSystemResourceRecordKey] => 34700657
)
[3] => Array
(
[Order] => 4
[ImageOf] =>
[ListAOR] =>
[MediaKey] => 2005942072798
[MediaURL] => https://cdn.realtyfeed.com/cdn/76/1187633403/adf020767f470210c65441e878184374.webp
[ClassName] =>
[MediaHTML] =>
[MediaSize] => 265838
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/76/1187633403/thumbnail-adf020767f470210c65441e878184374.webp
[ImageWidth] =>
[Permission] =>
[ImageHeight] =>
[MediaStatus] => Active
[SyndicateTo] =>
[ListAgentKey] => 25256584
[PropertyType] => Residential
[ResourceName] => Property
[ListOfficeKey] => 6607384
[MediaCategory] => Photo
[MediaObjectID] =>
[OffMarketDate] =>
[X_MediaStream] =>
[SourceSystemID] => TRESTLE
[StandardStatus] => Active
[HumanModifiedYN] =>
[ListOfficeMlsId] => 40076
[LongDescription] =>
[MediaAlteration] =>
[MediaKeyNumeric] => 2005942072798
[PropertySubType] => Single Family Residence
[RecordSignature] => 619326689
[OriginalMediaUrl] =>
[PreferredPhotoYN] =>
[ResourceRecordID] => RLS20111474
[ShortDescription] =>
[SourceSystemName] =>
[ChangedByMemberID] =>
[ListingPermission] => IDX
[ResourceRecordKey] => 1187633403
[ChangedByMemberKey] =>
[MediaClassification] => PHOTO
[OriginatingSystemID] =>
[ImageSizeDescription] =>
[SourceSystemMediaKey] =>
[ModificationTimestamp] => 2026-08-27T23:06:53.930-00:00
[OriginatingSystemName] => RLS
[MediaStatusDescription] =>
[OriginatingSystemSubName] => RLS_REBNY
[ResourceRecordKeyNumeric] => 1187633403
[ChangedByMemberKeyNumeric] =>
[OriginatingSystemMediaKey] => 34700661
[PropertySubTypeAdditional] =>
[MediaModificationTimestamp] => 2026-08-27T23:06:00.000-00:00
[SourceSystemResourceRecordKey] =>
[InternetEntireListingDisplayYN] => 1
[OriginatingSystemResourceRecordId] =>
[OriginatingSystemResourceRecordKey] => 34700657
)
[4] => Array
(
[Order] => 5
[ImageOf] =>
[ListAOR] =>
[MediaKey] => 2005942072799
[MediaURL] => https://cdn.realtyfeed.com/cdn/76/1187633403/bd2b2be8937c71676a5f7c03a6df56dd.webp
[ClassName] =>
[MediaHTML] =>
[MediaSize] => 252397
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/76/1187633403/thumbnail-bd2b2be8937c71676a5f7c03a6df56dd.webp
[ImageWidth] =>
[Permission] =>
[ImageHeight] =>
[MediaStatus] => Active
[SyndicateTo] =>
[ListAgentKey] => 25256584
[PropertyType] => Residential
[ResourceName] => Property
[ListOfficeKey] => 6607384
[MediaCategory] => Photo
[MediaObjectID] =>
[OffMarketDate] =>
[X_MediaStream] =>
[SourceSystemID] => TRESTLE
[StandardStatus] => Active
[HumanModifiedYN] =>
[ListOfficeMlsId] => 40076
[LongDescription] =>
[MediaAlteration] =>
[MediaKeyNumeric] => 2005942072799
[PropertySubType] => Single Family Residence
[RecordSignature] => 619326689
[OriginalMediaUrl] =>
[PreferredPhotoYN] =>
[ResourceRecordID] => RLS20111474
[ShortDescription] =>
[SourceSystemName] =>
[ChangedByMemberID] =>
[ListingPermission] => IDX
[ResourceRecordKey] => 1187633403
[ChangedByMemberKey] =>
[MediaClassification] => PHOTO
[OriginatingSystemID] =>
[ImageSizeDescription] =>
[SourceSystemMediaKey] =>
[ModificationTimestamp] => 2026-08-27T23:06:53.930-00:00
[OriginatingSystemName] => RLS
[MediaStatusDescription] =>
[OriginatingSystemSubName] => RLS_REBNY
[ResourceRecordKeyNumeric] => 1187633403
[ChangedByMemberKeyNumeric] =>
[OriginatingSystemMediaKey] => 34700662
[PropertySubTypeAdditional] =>
[MediaModificationTimestamp] => 2026-08-27T23:06:00.000-00:00
[SourceSystemResourceRecordKey] =>
[InternetEntireListingDisplayYN] => 1
[OriginatingSystemResourceRecordId] =>
[OriginatingSystemResourceRecordKey] => 34700657
)
[5] => Array
(
[Order] => 6
[ImageOf] =>
[ListAOR] =>
[MediaKey] => 2005942072800
[MediaURL] => https://cdn.realtyfeed.com/cdn/76/1187633403/3cb5cd1e9b4c3bb9ad60e2852764930c.webp
[ClassName] =>
[MediaHTML] =>
[MediaSize] => 260029
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/76/1187633403/thumbnail-3cb5cd1e9b4c3bb9ad60e2852764930c.webp
[ImageWidth] =>
[Permission] =>
[ImageHeight] =>
[MediaStatus] => Active
[SyndicateTo] =>
[ListAgentKey] => 25256584
[PropertyType] => Residential
[ResourceName] => Property
[ListOfficeKey] => 6607384
[MediaCategory] => Photo
[MediaObjectID] =>
[OffMarketDate] =>
[X_MediaStream] =>
[SourceSystemID] => TRESTLE
[StandardStatus] => Active
[HumanModifiedYN] =>
[ListOfficeMlsId] => 40076
[LongDescription] =>
[MediaAlteration] =>
[MediaKeyNumeric] => 2005942072800
[PropertySubType] => Single Family Residence
[RecordSignature] => 619326689
[OriginalMediaUrl] =>
[PreferredPhotoYN] =>
[ResourceRecordID] => RLS20111474
[ShortDescription] =>
[SourceSystemName] =>
[ChangedByMemberID] =>
[ListingPermission] => IDX
[ResourceRecordKey] => 1187633403
[ChangedByMemberKey] =>
[MediaClassification] => PHOTO
[OriginatingSystemID] =>
[ImageSizeDescription] =>
[SourceSystemMediaKey] =>
[ModificationTimestamp] => 2026-08-27T23:06:53.930-00:00
[OriginatingSystemName] => RLS
[MediaStatusDescription] =>
[OriginatingSystemSubName] => RLS_REBNY
[ResourceRecordKeyNumeric] => 1187633403
[ChangedByMemberKeyNumeric] =>
[OriginatingSystemMediaKey] => 34700663
[PropertySubTypeAdditional] =>
[MediaModificationTimestamp] => 2026-08-27T23:06:00.000-00:00
[SourceSystemResourceRecordKey] =>
[InternetEntireListingDisplayYN] => 1
[OriginatingSystemResourceRecordId] =>
[OriginatingSystemResourceRecordKey] => 34700657
)
[6] => Array
(
[Order] => 7
[ImageOf] =>
[ListAOR] =>
[MediaKey] => 2005942072801
[MediaURL] => https://cdn.realtyfeed.com/cdn/76/1187633403/4ae9fc1b5610bccca571b5bcad95f7bc.webp
[ClassName] =>
[MediaHTML] =>
[MediaSize] => 261845
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/76/1187633403/thumbnail-4ae9fc1b5610bccca571b5bcad95f7bc.webp
[ImageWidth] =>
[Permission] =>
[ImageHeight] =>
[MediaStatus] => Active
[SyndicateTo] =>
[ListAgentKey] => 25256584
[PropertyType] => Residential
[ResourceName] => Property
[ListOfficeKey] => 6607384
[MediaCategory] => Photo
[MediaObjectID] =>
[OffMarketDate] =>
[X_MediaStream] =>
[SourceSystemID] => TRESTLE
[StandardStatus] => Active
[HumanModifiedYN] =>
[ListOfficeMlsId] => 40076
[LongDescription] =>
[MediaAlteration] =>
[MediaKeyNumeric] => 2005942072801
[PropertySubType] => Single Family Residence
[RecordSignature] => 619326689
[OriginalMediaUrl] =>
[PreferredPhotoYN] =>
[ResourceRecordID] => RLS20111474
[ShortDescription] =>
[SourceSystemName] =>
[ChangedByMemberID] =>
[ListingPermission] => IDX
[ResourceRecordKey] => 1187633403
[ChangedByMemberKey] =>
[MediaClassification] => PHOTO
[OriginatingSystemID] =>
[ImageSizeDescription] =>
[SourceSystemMediaKey] =>
[ModificationTimestamp] => 2026-08-27T23:06:53.930-00:00
[OriginatingSystemName] => RLS
[MediaStatusDescription] =>
[OriginatingSystemSubName] => RLS_REBNY
[ResourceRecordKeyNumeric] => 1187633403
[ChangedByMemberKeyNumeric] =>
[OriginatingSystemMediaKey] => 34700664
[PropertySubTypeAdditional] =>
[MediaModificationTimestamp] => 2026-08-27T23:06:00.000-00:00
[SourceSystemResourceRecordKey] =>
[InternetEntireListingDisplayYN] => 1
[OriginatingSystemResourceRecordId] =>
[OriginatingSystemResourceRecordKey] => 34700657
)
[7] => Array
(
[Order] => 8
[ImageOf] =>
[ListAOR] =>
[MediaKey] => 2005942072802
[MediaURL] => https://cdn.realtyfeed.com/cdn/76/1187633403/6e9c0abd617916995ff5d325fb6a6423.webp
[ClassName] =>
[MediaHTML] =>
[MediaSize] => 215766
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/76/1187633403/thumbnail-6e9c0abd617916995ff5d325fb6a6423.webp
[ImageWidth] =>
[Permission] =>
[ImageHeight] =>
[MediaStatus] => Active
[SyndicateTo] =>
[ListAgentKey] => 25256584
[PropertyType] => Residential
[ResourceName] => Property
[ListOfficeKey] => 6607384
[MediaCategory] => Photo
[MediaObjectID] =>
[OffMarketDate] =>
[X_MediaStream] =>
[SourceSystemID] => TRESTLE
[StandardStatus] => Active
[HumanModifiedYN] =>
[ListOfficeMlsId] => 40076
[LongDescription] =>
[MediaAlteration] =>
[MediaKeyNumeric] => 2005942072802
[PropertySubType] => Single Family Residence
[RecordSignature] => 619326689
[OriginalMediaUrl] =>
[PreferredPhotoYN] =>
[ResourceRecordID] => RLS20111474
[ShortDescription] =>
[SourceSystemName] =>
[ChangedByMemberID] =>
[ListingPermission] => IDX
[ResourceRecordKey] => 1187633403
[ChangedByMemberKey] =>
[MediaClassification] => PHOTO
[OriginatingSystemID] =>
[ImageSizeDescription] =>
[SourceSystemMediaKey] =>
[ModificationTimestamp] => 2026-08-27T23:06:53.930-00:00
[OriginatingSystemName] => RLS
[MediaStatusDescription] =>
[OriginatingSystemSubName] => RLS_REBNY
[ResourceRecordKeyNumeric] => 1187633403
[ChangedByMemberKeyNumeric] =>
[OriginatingSystemMediaKey] => 34700665
[PropertySubTypeAdditional] =>
[MediaModificationTimestamp] => 2026-08-27T23:06:00.000-00:00
[SourceSystemResourceRecordKey] =>
[InternetEntireListingDisplayYN] => 1
[OriginatingSystemResourceRecordId] =>
[OriginatingSystemResourceRecordKey] => 34700657
)
[8] => Array
(
[Order] => 9
[ImageOf] =>
[ListAOR] =>
[MediaKey] => 2005942072791
[MediaURL] => https://cdn.realtyfeed.com/cdn/76/1187633403/9d9d79f95af1dbd9f4d2ea9e632d3ac7.webp
[ClassName] =>
[MediaHTML] =>
[MediaSize] => 234194
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/76/1187633403/thumbnail-9d9d79f95af1dbd9f4d2ea9e632d3ac7.webp
[ImageWidth] =>
[Permission] =>
[ImageHeight] =>
[MediaStatus] => Active
[SyndicateTo] =>
[ListAgentKey] => 25256584
[PropertyType] => Residential
[ResourceName] => Property
[ListOfficeKey] => 6607384
[MediaCategory] => Photo
[MediaObjectID] =>
[OffMarketDate] =>
[X_MediaStream] =>
[SourceSystemID] => TRESTLE
[StandardStatus] => Active
[HumanModifiedYN] =>
[ListOfficeMlsId] => 40076
[LongDescription] =>
[MediaAlteration] =>
[MediaKeyNumeric] => 2005942072791
[PropertySubType] => Single Family Residence
[RecordSignature] => 619326689
[OriginalMediaUrl] =>
[PreferredPhotoYN] =>
[ResourceRecordID] => RLS20111474
[ShortDescription] =>
[SourceSystemName] =>
[ChangedByMemberID] =>
[ListingPermission] => IDX
[ResourceRecordKey] => 1187633403
[ChangedByMemberKey] =>
[MediaClassification] => PHOTO
[OriginatingSystemID] =>
[ImageSizeDescription] =>
[SourceSystemMediaKey] =>
[ModificationTimestamp] => 2026-08-27T23:06:53.930-00:00
[OriginatingSystemName] => RLS
[MediaStatusDescription] =>
[OriginatingSystemSubName] => RLS_REBNY
[ResourceRecordKeyNumeric] => 1187633403
[ChangedByMemberKeyNumeric] =>
[OriginatingSystemMediaKey] => 34700666
[PropertySubTypeAdditional] =>
[MediaModificationTimestamp] => 2026-08-27T23:06:00.000-00:00
[SourceSystemResourceRecordKey] =>
[InternetEntireListingDisplayYN] => 1
[OriginatingSystemResourceRecordId] =>
[OriginatingSystemResourceRecordKey] => 34700657
)
[9] => Array
(
[Order] => 10
[ImageOf] =>
[ListAOR] =>
[MediaKey] => 2005942072792
[MediaURL] => https://cdn.realtyfeed.com/cdn/76/1187633403/37ac78d831276ef5b3d1375c8790ccb7.webp
[ClassName] =>
[MediaHTML] =>
[MediaSize] => 404773
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/76/1187633403/thumbnail-37ac78d831276ef5b3d1375c8790ccb7.webp
[ImageWidth] =>
[Permission] =>
[ImageHeight] =>
[MediaStatus] => Active
[SyndicateTo] =>
[ListAgentKey] => 25256584
[PropertyType] => Residential
[ResourceName] => Property
[ListOfficeKey] => 6607384
[MediaCategory] => Photo
[MediaObjectID] =>
[OffMarketDate] =>
[X_MediaStream] =>
[SourceSystemID] => TRESTLE
[StandardStatus] => Active
[HumanModifiedYN] =>
[ListOfficeMlsId] => 40076
[LongDescription] =>
[MediaAlteration] =>
[MediaKeyNumeric] => 2005942072792
[PropertySubType] => Single Family Residence
[RecordSignature] => 619326689
[OriginalMediaUrl] =>
[PreferredPhotoYN] =>
[ResourceRecordID] => RLS20111474
[ShortDescription] =>
[SourceSystemName] =>
[ChangedByMemberID] =>
[ListingPermission] => IDX
[ResourceRecordKey] => 1187633403
[ChangedByMemberKey] =>
[MediaClassification] => PHOTO
[OriginatingSystemID] =>
[ImageSizeDescription] =>
[SourceSystemMediaKey] =>
[ModificationTimestamp] => 2026-08-27T23:06:53.930-00:00
[OriginatingSystemName] => RLS
[MediaStatusDescription] =>
[OriginatingSystemSubName] => RLS_REBNY
[ResourceRecordKeyNumeric] => 1187633403
[ChangedByMemberKeyNumeric] =>
[OriginatingSystemMediaKey] => 34700667
[PropertySubTypeAdditional] =>
[MediaModificationTimestamp] => 2026-08-27T23:06:00.000-00:00
[SourceSystemResourceRecordKey] =>
[InternetEntireListingDisplayYN] => 1
[OriginatingSystemResourceRecordId] =>
[OriginatingSystemResourceRecordKey] => 34700657
)
[10] => Array
(
[Order] => 11
[ImageOf] =>
[ListAOR] =>
[MediaKey] => 2005942072793
[MediaURL] => https://cdn.realtyfeed.com/cdn/76/1187633403/25659e3df304376dba8286dc70c29642.webp
[ClassName] =>
[MediaHTML] =>
[MediaSize] => 533726
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/76/1187633403/thumbnail-25659e3df304376dba8286dc70c29642.webp
[ImageWidth] =>
[Permission] =>
[ImageHeight] =>
[MediaStatus] => Active
[SyndicateTo] =>
[ListAgentKey] => 25256584
[PropertyType] => Residential
[ResourceName] => Property
[ListOfficeKey] => 6607384
[MediaCategory] => Photo
[MediaObjectID] =>
[OffMarketDate] =>
[X_MediaStream] =>
[SourceSystemID] => TRESTLE
[StandardStatus] => Active
[HumanModifiedYN] =>
[ListOfficeMlsId] => 40076
[LongDescription] =>
[MediaAlteration] =>
[MediaKeyNumeric] => 2005942072793
[PropertySubType] => Single Family Residence
[RecordSignature] => 619326689
[OriginalMediaUrl] =>
[PreferredPhotoYN] =>
[ResourceRecordID] => RLS20111474
[ShortDescription] =>
[SourceSystemName] =>
[ChangedByMemberID] =>
[ListingPermission] => IDX
[ResourceRecordKey] => 1187633403
[ChangedByMemberKey] =>
[MediaClassification] => PHOTO
[OriginatingSystemID] =>
[ImageSizeDescription] =>
[SourceSystemMediaKey] =>
[ModificationTimestamp] => 2026-08-27T23:06:53.930-00:00
[OriginatingSystemName] => RLS
[MediaStatusDescription] =>
[OriginatingSystemSubName] => RLS_REBNY
[ResourceRecordKeyNumeric] => 1187633403
[ChangedByMemberKeyNumeric] =>
[OriginatingSystemMediaKey] => 34700668
[PropertySubTypeAdditional] =>
[MediaModificationTimestamp] => 2026-08-27T23:06:00.000-00:00
[SourceSystemResourceRecordKey] =>
[InternetEntireListingDisplayYN] => 1
[OriginatingSystemResourceRecordId] =>
[OriginatingSystemResourceRecordKey] => 34700657
)
)
[DaysOnMarket] => 55
[ID] => 1792963
)
Description
Welcome to 249 Hillside Avenue in Roxbury. This charming two-story home offers three spacious bedrooms, two full bathrooms and is in close proximity to the bay and parking. The bright, open layout on the first floor seamlessly connects the kitchen, dining and living areas to a sizable screened-in porch and large front deck. The kitchen features stainless-steel appliances, a generous island with seating, plenty of cabinet space and flows right into the dining area. The living room has sliders that lead out to the screened in porch allowing you to easily expand your living space. First-floor amenities include radiant heating and central air, while abundant natural light enhances the open design. There is also a full bathroom, coat closet and access to the mechanicals on this floor. Upstairs, you’ll find three generous bedrooms with large closets, along with a full bathroom and a convenient washer/dryer. Additional features of the home include an outdoor shower, two attic storage spaces, and an unfinished basement with versatile potential. Conveniently located near the bay and parking makes this home just perfect.
Address
Open on Google Maps-
Address: 2-49 Hillside Avenue
-
City: New York City
-
State/county: NY
-
Zip/Postal Code: 11697
-
Area: Breezy Point
Details
Updated on September 3, 2026 at 3:19 pm-
Property ID RLS20111474
-
Price $779,000
-
Property Size 1500 Sqft
-
Bedrooms 3
-
Rooms 8
-
Bathrooms 2
-
Garage Size x x
-
Year Built 1938
-
Type Single Family Residence, Residential
-
Property Status Active, For Sale
Additional details
-
County Queens
-
Property Type Residential
Features
Mortgage Calculator
-
Down Payment
-
Loan Amount
-
Monthly Mortgage Payment
-
Property Tax
-
Home Insurance
-
PMI
-
Monthly HOA Fees
