MLS GRID
Start: 1.2
https://api.mlsgrid.com/v2/Property?&$expand=Media,Rooms,UnitTypes&$skip=0&$top=1&$count=true&$filter=( (OriginatingSystemName eq 'onekey2') or ( StandardStatus eq 'Active' ) or ( StandardStatus eq 'Active Under Contract' ) or ( StandardStatus eq 'Expired' ) and ( MlgCanView eq true ) and (ModificationTimestamp gt 2020-12-30T23:59:59.99Z) )
1
Array
(
[source] => MLS GRID
[log] => Array
(
[skipped] => New York
[listing_key] => KEY161603343
[mls_number] => KEYH6333254
)
)
Array
(
[0] => Array
(
[ID] => 195602
[post_status] => 1
[post_type] => listing
[post_title] => Old Main, Southampton
[post_content] => Discover the potential of this prime vacant land at 34 Old Main Road, Quogue, NY. With building permits already secured, envision your dream home spanning 6,535 square feet with three levels of finished living space featuring 8 bedrooms and 7 bathrooms. The expansive 56,192 square foot lot offers permitted space for a luxurious lifestyle, including a pool, pool house, and room for tennis court. The private outdoor space promises tranquility and privacy, perfect for relaxation or entertaining. Embrace the opportunity to create a bespoke residence in a coveted location, tailored to your vision of comfort and elegance.
[raw_info] => {"@odata.id":"https:\/\/api.mlsgrid.com\/v2\/Property('KEY418591225')","ListingKey":"KEY418591225","AttributionContact":"631-905-2199","BuildingAreaUnits":"Square Feet","City":"Southampton","CoListAgentAOR":"LIBOR","CoListAgentDirectPhone":"631-255-5580","CoListAgentEmail":"Nicole.weiss@compass.com","CoListAgentFullName":"Nicole S. Weiss","CoListAgentKey":"KEY326195555","CoListAgentMlsId":"KEY185380","CoListOfficeKey":"KEY326110414","CoListOfficeMlsId":"KEYCMPA17","CoListOfficeName":"Compass Greater NY LLC","CoListOfficePhone":"631-629-7675","CountyOrParish":"Suffolk County","CumulativeDaysOnMarket":0,"KEY_CurrentPrice":"2899995.00","CurrentUse":["Vacant"],"DaysOnMarket":0,"ElementarySchool":"Quogue Elementary School","ExpirationDate":"2025-03-05","HighSchool":"Contact Agent","InternetAddressDisplayYN":true,"InternetAutomatedValuationDisplayYN":false,"InternetConsumerCommentYN":false,"InternetEntireListingDisplayYN":true,"ListAOR":"LIBOR","ListAgentAOR":"LIBOR","ListAgentDirectPhone":"631-905-2199","ListAgentEmail":"Tim.Morabito@compass.com","ListAgentFullName":"Timothy Allen Morabito","ListAgentKey":"KEY326173728","ListAgentMlsId":"KEY161780","ListOfficeAOR":"LIBOR","ListOfficeKey":"KEY326110414","ListOfficeMlsId":"KEYCMPA17","ListOfficeName":"Compass Greater NY LLC","ListOfficePhone":"631-629-7675","ListPrice":2899995,"ListingAgreement":"Exclusive Right To Sell","ListingContractDate":"2025-01-31","ListingId":"KEY819533","LotSizeAcres":1.29,"LotSizeSquareFeet":56192,"MajorChangeTimestamp":"2025-01-31T18:30:40.000Z","MajorChangeType":"New Listing","MiddleOrJuniorSchool":"Contact Agent","KEY_MlsMajorChangeType":"New Listing","MlsStatus":"Active","OriginatingSystemModificationTimestamp":"2025-01-31T18:30:41.000Z","OnMarketDate":"2025-01-31","OriginalEntryTimestamp":"2025-01-31T18:30:40.000Z","OriginalListPrice":2899995,"OriginatingSystemName":"onekey2","OwnerName":"334 Old Main LLC","ParcelNumber":"0902-003-00-02-00-012-000","PhotosChangeTimestamp":"2025-01-31T18:32:36.568Z","PhotosCount":3,"PostalCity":"Quogue","PostalCode":"11959","PostalCodePlus4":"4200","PriceChangeTimestamp":"2025-01-31T18:30:40.000Z","PropertyType":"Land","PublicRemarks":"Discover the potential of this prime vacant land at 34 Old Main Road, Quogue, NY. With building permits already secured, envision your dream home spanning 6,535 square feet with three levels of finished living space featuring 8 bedrooms and 7 bathrooms. The expansive 56,192 square foot lot offers permitted space for a luxurious lifestyle, including a pool, pool house, and room for tennis court. The private outdoor space promises tranquility and privacy, perfect for relaxation or entertaining. Embrace the opportunity to create a bespoke residence in a coveted location, tailored to your vision of comfort and elegance.","KEY_RATIO_ListPrice_By_LotSizeAcres":"2248058.1395","KEY_RATIO_ListPrice_By_OriginalListPrice":"1.00000","HighSchoolDistrict":"Quogue","SeniorCommunityYN":false,"Sewer":["None"],"ShowingContactPhone":"631-905-2199","KEY_ShowingContactPhone2":"631-255-5580","ShowingInstructions":"Call listing agnets","ShowingRequirements":["Call Listing Agent"],"KEY_SourceSystemModificationTimestamp":"2025-01-31T13:30:40.777","SourceSystemName":"KEY","SpecialListingConditions":["None"],"StandardStatus":"Active","StateOrProvince":"NY","StatusChangeTimestamp":"2025-01-31T18:30:40.000Z","StreetName":"Old Main","StreetNumber":"34","StreetNumberNumeric":34,"StreetSuffix":"Road","SyndicateTo":["Realtor.com"],"TaxAnnualAmount":3496.16,"TaxAssessedValue":842000,"KEY_TaxSource":"Municipality","TaxYear":2024,"KEY_Village":"Quogue","ModificationTimestamp":"2025-01-31T18:32:36.568Z","Media":[{"ResourceRecordKey":"418591225","Permission":["Public"],"LongDescription":"Aerial view featuring a water view","ShortDescription":"Aerial View","Order":0,"ImageWidth":2048,"ImageHeight":1365,"ImageSizeDescription":"2048x1365","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY418591225\/1c462c18-9350-4371-83e0-439063e120bc.jpeg","MediaModificationTimestamp":"2025-01-31T18:31:40.336Z","MediaKey":"679d170cfb9feb1f3fdf566f"},{"ResourceRecordKey":"418591225","Permission":["Public"],"LongDescription":"Drone \/ aerial view featuring a water view","ShortDescription":"Aerial View","Order":1,"ImageWidth":2048,"ImageHeight":1365,"ImageSizeDescription":"2048x1365","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY418591225\/9b2c4c6a-98ae-4ff1-9943-f98f68f565c1.jpeg","MediaModificationTimestamp":"2025-01-31T18:31:40.299Z","MediaKey":"679d170cfb9feb1f3fdf5670"},{"ResourceRecordKey":"418591225","Permission":["Public"],"LongDescription":"Floor plan","ShortDescription":"Floor Plan","Order":2,"ImageWidth":1920,"ImageHeight":1341,"ImageSizeDescription":"1920x1341","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY418591225\/9efc4e0d-e939-41e4-9b06-b3803a29c40c.jpeg","MediaModificationTimestamp":"2025-01-31T18:31:40.268Z","MediaKey":"679d170cfb9feb1f3fdf5671"}],"MlgCanView":true,"MlgCanUse":["IDX"]}
[listing_info] => {"list_price":2899995,"sold_price":"","rental_price":2899995,"currency":"Dollar","hide_address":"","street_number":"34","street_name":"Old Main Road","city":"Southampton","state":"NY","province":"","zip_code":"11959","country":"Quogue","full_address":"34 Old Main Road, Southampton, NY 11959","mls_number":"KEY819533","listing_broker":"","bedrooms":"","bathrooms":"","garage_spaces":"","year_built":"","building_size":"","lot_size":"","acres_size":"1.29","building_size_unit":"","lot_size_unit":"","virtual_tour":""}
[api_type] => 1
[api_class] => Land
[rets_prop_type] =>
[rets_prop_status] => Active
[out_prop_type] =>
[out_prop_status] =>
[api_prop_features] =>
[open_house] =>
[list_price] => 2900000
[rental_price] => 2900000
[sold_price] => 0
[state] => NY
[city] => Southampton
[zip_code] => 11959
[mls_number] => KEY819533
[bedrooms] => 0
[house_size] => 0
[property_size] => 1.29
[bathrooms] => 0
[full_address] => 34 Old Main Road, Southampton, NY 11959
[street_name] => 34 Old Main Road
[broker] => Compass Greater NY LLC
[listing_key] => KEY418591225
[listing_agent_key] => KEY326173728
[colisting_agent_key1] => KEY326195555
[colisting_agent_key2] =>
[full_street_address] => 34 Old Main
[listing_images] => ["https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY418591225\/1c462c18-9350-4371-83e0-439063e120bc.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY418591225\/9b2c4c6a-98ae-4ff1-9943-f98f68f565c1.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY418591225\/9efc4e0d-e939-41e4-9b06-b3803a29c40c.jpeg"]
[SaleOrRent] =>
[RentAmtAugLaborDay] => 0
[RentAmtJulyAug] => 0
[RentAmtJuly] => 0
[RentAmtJune] => 0
[RentAmtMemLaborDay] => 0
[RentAmtOffSeason] => 0
[RentAmtYearRoundMonthly] => 0
[RentAmtjun_jul] => 0
[RentAmtsht_term] => 0
[RentAmtwinter] => 0
[RentAmtSept] => 0
[RentAmtSeptOct] => 0
[RentAmtOct] => 0
[RentAmtNov] => 0
[RentAmtDec] => 0
[RentAmtWeekly] => 0
[RentAmtTwoWeeks] => 0
[RentAmtAugust] => 0
[RentAmtApril] => 0
[RentAmtMay] => 0
[RentAmtAprilMay] => 0
[RentAmtAprilLD] => 0
[RentAmtJulyAugustLD] => 0
[last_modified] => 2025-01-31T18:32:36.568Z
[date_added] => 2025-02-07 06:59:40
)
[1] => Array
(
[ID] => 194827
[post_status] => 1
[post_type] => listing
[post_title] => Old Country, Southampton
[post_content] => Calling All Investors, Developers & End-Users!!! Magnificent 134 Acre Development Site In Eastport For Sale!!! The Property Spans 3 Miles From Old Country Road To Route 27 (Sunrise Hwy.) Near The Speonk LIRR Station & The Francis S. Gabreski Airport!!! The Property Features Great Exposure, Excellent Signage, 2,800 Parking Spaces, 11 Lots, Strong Zoning, Low Property Taxes, +++!!! Neighbors Include Amazon, Starbucks, 7-Eleven, Dunkin’, King Kullen, Sherwin-Williams, Valero, +++!!! According To The Seller There’s A Potential Yield Of 20-22 Building Lots!!! The Property Offers HUGE Upside Potential!!! This Could Be Your Next Development Site / The Next Home For Your Business!!!
Taxes: $47,940.94 Ann.
[raw_info] => {"@odata.id":"https:\/\/api.mlsgrid.com\/v2\/Property('KEY418112565')","ListingKey":"KEY418112565","AttributionContact":"516-783-5600","BuildingAreaUnits":"Square Feet","City":"Southampton","CountyOrParish":"Suffolk County","CumulativeDaysOnMarket":2,"KEY_CurrentPrice":"2888000.00","CurrentUse":["Residential"],"DaysOnMarket":2,"ElementarySchool":"Eastport Elementary School","ExpirationDate":"2026-12-11","HighSchool":"Eastport-South Manor Jr-Sr Hs","InternetAddressDisplayYN":true,"InternetAutomatedValuationDisplayYN":false,"InternetConsumerCommentYN":false,"InternetEntireListingDisplayYN":true,"ListAOR":"LIBOR","ListAgentAOR":"LIBOR","ListAgentDirectPhone":"516-279-8828","ListAgentEmail":"matthewshane8828@gmail.com","ListAgentFullName":"Richard Matt Shane","ListAgentKey":"KEY326187240","ListAgentMlsId":"KEY176463","ListOfficeAOR":"LIBOR","ListOfficeKey":"KEY326110144","ListOfficeMlsId":"KEYCBE01","ListOfficeName":"All Island Estates Realty Corp","ListOfficePhone":"516-783-5600","ListPrice":2888000,"ListingAgreement":"Exclusive Right To Sell","ListingContractDate":"2024-12-11","ListingId":"KEY804808","LotSizeAcres":134,"LotSizeSquareFeet":5829000,"MajorChangeTimestamp":"2024-12-11T21:47:22.000Z","MajorChangeType":"New Listing","MiddleOrJuniorSchool":"Eastport-South Manor Jr-Sr Hs","KEY_MlsDistrictCode":"900","KEY_MlsMajorChangeType":"New Listing","MlsStatus":"Active","OriginatingSystemModificationTimestamp":"2024-12-12T17:22:30.000Z","NumberOfLots":11,"OnMarketDate":"2024-12-11","OriginalEntryTimestamp":"2024-12-11T21:47:22.000Z","OriginalListPrice":2888000,"OriginatingSystemName":"onekey2","OwnerName":"Victor Gallo","ParcelNumber":"473689","PhotosChangeTimestamp":"2024-12-13T07:22:36.903Z","PhotosCount":10,"PostalCity":"Eastport","PostalCode":"11941","PostalCodePlus4":"1194","PropertyType":"Land","PublicRemarks":"Calling All Investors, Developers & End-Users!!! Magnificent 134 Acre Development Site In Eastport For Sale!!! The Property Spans 3 Miles From Old Country Road To Route 27 (Sunrise Hwy.) Near The Speonk LIRR Station & The Francis S. Gabreski Airport!!! The Property Features Great Exposure, Excellent Signage, 2,800 Parking Spaces, 11 Lots, Strong Zoning, Low Property Taxes, +++!!! Neighbors Include Amazon, Starbucks, 7-Eleven, Dunkin\u2019, King Kullen, Sherwin-Williams, Valero, +++!!! According To The Seller There\u2019s A Potential Yield Of 20-22 Building Lots!!! The Property Offers HUGE Upside Potential!!! This Could Be Your Next Development Site \/ The Next Home For Your Business!!! \n\n\nTaxes: $47,940.94 Ann.","KEY_RATIO_ListPrice_By_LotSizeAcres":"21552.2388","KEY_RATIO_ListPrice_By_OriginalListPrice":"1.00000","HighSchoolDistrict":"Eastport-South Manor","SeniorCommunityYN":false,"Sewer":["Cesspool"],"ShowingContactPhone":"516-783-5600","ShowingInstructions":"Call Office for Appointment","KEY_ShowingTimeFlagYN":"1","KEY_SourceSystemModificationTimestamp":"2024-12-11T12:54:00.127","SourceSystemName":"KEY","SpecialListingConditions":["None"],"StandardStatus":"Active","StateOrProvince":"NY","StatusChangeTimestamp":"2024-12-11T21:47:22.000Z","StreetName":"Old Country","StreetNumber":"202-214","StreetNumberNumeric":202,"SyndicateTo":["Realtor.com"],"TaxAnnualAmount":47941,"TaxBlock":"0001","TaxLot":"002001","KEY_TaxSection":"326000","KEY_TaxSource":"Other","TaxYear":2024,"WaterfrontYN":false,"ModificationTimestamp":"2024-12-13T07:22:36.903Z","Media":[{"ResourceRecordKey":"418112565","Permission":["Public"],"LongDescription":"Map location","ShortDescription":"Other","Order":0,"ImageWidth":1280,"ImageHeight":768,"ImageSizeDescription":"1280x768","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY418112565\/11608019-9d2a-4087-8f54-b24765ab4760.jpeg","MediaModificationTimestamp":"2024-12-13T07:22:14.182Z","MediaKey":"675be0a68194bb69a91974af"},{"ResourceRecordKey":"418112565","Permission":["Public"],"LongDescription":"View of nature with a rural view","ShortDescription":"Other","Order":1,"ImageWidth":1280,"ImageHeight":507,"ImageSizeDescription":"1280x507","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY418112565\/14ed8604-9843-41b1-90ff-c57e0d4d5720.jpeg","MediaModificationTimestamp":"2024-12-13T07:22:14.018Z","MediaKey":"675be0a68194bb69a91974b0"},{"ResourceRecordKey":"418112565","Permission":["Public"],"LongDescription":"Map","ShortDescription":"Other","Order":2,"ImageWidth":1280,"ImageHeight":753,"ImageSizeDescription":"1280x753","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY418112565\/e91295ae-7d96-4e0e-8179-cb6d23a91245.jpeg","MediaModificationTimestamp":"2024-12-13T07:22:14.095Z","MediaKey":"675be0a68194bb69a91974b1"},{"ResourceRecordKey":"418112565","Permission":["Public"],"LongDescription":"View of yard featuring a rural view","ShortDescription":"Yard","Order":3,"ImageWidth":1280,"ImageHeight":508,"ImageSizeDescription":"1280x508","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY418112565\/572141ba-5e8f-450a-90a7-9c8d4c53b979.jpeg","MediaModificationTimestamp":"2024-12-13T07:22:14.067Z","MediaKey":"675be0a68194bb69a91974b2"},{"ResourceRecordKey":"418112565","Permission":["Public"],"LongDescription":"Map location","ShortDescription":"Other","Order":4,"ImageWidth":1280,"ImageHeight":772,"ImageSizeDescription":"1280x772","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY418112565\/efbf484c-b480-4db7-8fe1-941ccc6a2282.jpeg","MediaModificationTimestamp":"2024-12-13T07:22:14.108Z","MediaKey":"675be0a68194bb69a91974b3"},{"ResourceRecordKey":"418112565","Permission":["Public"],"LongDescription":"View of nature","ShortDescription":"Other","Order":5,"ImageWidth":1280,"ImageHeight":499,"ImageSizeDescription":"1280x499","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY418112565\/683e5281-ce20-4d8b-a539-db81d49e128a.jpeg","MediaModificationTimestamp":"2024-12-13T07:22:14.063Z","MediaKey":"675be0a68194bb69a91974b4"},{"ResourceRecordKey":"418112565","Permission":["Public"],"LongDescription":"Map","ShortDescription":"Other","Order":6,"ImageWidth":1280,"ImageHeight":786,"ImageSizeDescription":"1280x786","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY418112565\/270ae0c6-5632-4cb8-b596-b0c57d14e0ed.jpeg","MediaModificationTimestamp":"2024-12-13T07:22:14.124Z","MediaKey":"675be0a68194bb69a91974b5"},{"ResourceRecordKey":"418112565","Permission":["Public"],"LongDescription":"View of landscape","ShortDescription":"Other","Order":7,"ImageWidth":1280,"ImageHeight":502,"ImageSizeDescription":"1280x502","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY418112565\/794ced7c-d9b8-4f67-b041-c5b8392e5721.jpeg","MediaModificationTimestamp":"2024-12-13T07:22:14.064Z","MediaKey":"675be0a68194bb69a91974b6"},{"ResourceRecordKey":"418112565","Permission":["Public"],"LongDescription":"Map","ShortDescription":"Other","Order":8,"ImageWidth":1280,"ImageHeight":778,"ImageSizeDescription":"1280x778","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY418112565\/03355e72-bcdf-4300-93ef-67d4093aaaa5.jpeg","MediaModificationTimestamp":"2024-12-13T07:22:14.079Z","MediaKey":"675be0a68194bb69a91974b7"},{"ResourceRecordKey":"418112565","Permission":["Public"],"LongDescription":"View of local wilderness","ShortDescription":"Other","Order":9,"ImageWidth":1280,"ImageHeight":507,"ImageSizeDescription":"1280x507","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY418112565\/6e9fcf5c-6a77-4198-9ff9-9d09a77a6c03.jpeg","MediaModificationTimestamp":"2024-12-13T07:22:14.137Z","MediaKey":"675be0a68194bb69a91974b8"}],"MlgCanView":true,"MlgCanUse":["IDX"]}
[listing_info] => {"list_price":2888000,"sold_price":"","rental_price":2888000,"currency":"Dollar","hide_address":"","street_number":"202-214","street_name":"Old Country ","city":"Southampton","state":"NY","province":"","zip_code":"11941","country":"Eastport","full_address":"202-214 Old Country , Southampton, NY 11941","mls_number":"KEY804808","listing_broker":"","bedrooms":"","bathrooms":"","garage_spaces":"","year_built":"","building_size":"","lot_size":"","acres_size":"134","building_size_unit":"","lot_size_unit":"","virtual_tour":""}
[api_type] => 1
[api_class] => Land
[rets_prop_type] =>
[rets_prop_status] => Active
[out_prop_type] =>
[out_prop_status] =>
[api_prop_features] =>
[open_house] =>
[list_price] => 2888000
[rental_price] => 2888000
[sold_price] => 0
[state] => NY
[city] => Southampton
[zip_code] => 11941
[mls_number] => KEY804808
[bedrooms] => 0
[house_size] => 0
[property_size] => 134
[bathrooms] => 0
[full_address] => 202-214 Old Country , Southampton, NY 11941
[street_name] => 202-214 Old Country
[broker] => All Island Estates Realty Corp
[listing_key] => KEY418112565
[listing_agent_key] => KEY326187240
[colisting_agent_key1] =>
[colisting_agent_key2] =>
[full_street_address] => 202-214 Old Country
[listing_images] => ["https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY418112565\/11608019-9d2a-4087-8f54-b24765ab4760.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY418112565\/14ed8604-9843-41b1-90ff-c57e0d4d5720.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY418112565\/e91295ae-7d96-4e0e-8179-cb6d23a91245.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY418112565\/572141ba-5e8f-450a-90a7-9c8d4c53b979.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY418112565\/efbf484c-b480-4db7-8fe1-941ccc6a2282.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY418112565\/683e5281-ce20-4d8b-a539-db81d49e128a.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY418112565\/270ae0c6-5632-4cb8-b596-b0c57d14e0ed.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY418112565\/794ced7c-d9b8-4f67-b041-c5b8392e5721.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY418112565\/03355e72-bcdf-4300-93ef-67d4093aaaa5.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY418112565\/6e9fcf5c-6a77-4198-9ff9-9d09a77a6c03.jpeg"]
[SaleOrRent] =>
[RentAmtAugLaborDay] => 0
[RentAmtJulyAug] => 0
[RentAmtJuly] => 0
[RentAmtJune] => 0
[RentAmtMemLaborDay] => 0
[RentAmtOffSeason] => 0
[RentAmtYearRoundMonthly] => 0
[RentAmtjun_jul] => 0
[RentAmtsht_term] => 0
[RentAmtwinter] => 0
[RentAmtSept] => 0
[RentAmtSeptOct] => 0
[RentAmtOct] => 0
[RentAmtNov] => 0
[RentAmtDec] => 0
[RentAmtWeekly] => 0
[RentAmtTwoWeeks] => 0
[RentAmtAugust] => 0
[RentAmtApril] => 0
[RentAmtMay] => 0
[RentAmtAprilMay] => 0
[RentAmtAprilLD] => 0
[RentAmtJulyAugustLD] => 0
[last_modified] => 2024-12-13T07:22:36.903Z
[date_added] => 2025-02-07 06:55:13
)
[2] => Array
(
[ID] => 194869
[post_status] => 1
[post_type] => listing
[post_title] => Main, Southampton
[post_content] => Prime 2 acre building lot, close proximity to the Village of Westhampton Beach and ocean beaches! Property includes a 50' Gunite swimming pool installed in 2023.
[raw_info] => {"@odata.id":"https:\/\/api.mlsgrid.com\/v2\/Property('KEY406446540')","ListingKey":"KEY406446540","KEY_AdditionalFees":"0.00","KEY_AdditionalFeesYN":"0","KEY_AdditionalParcelYN":"0","AssociationYN":false,"AttributionContact":"631-288-6100","BasementYN":false,"BathroomsHalf":0,"City":"Southampton","KEY_ConcessionYN":"0","CountyOrParish":"Suffolk County","CrossStreet":"Meetinghouse La","CumulativeDaysOnMarket":106,"KEY_CurrentPrice":"2645000.00","DaysOnMarket":106,"DevelopmentStatus":["Partial Improvements"],"ElementarySchool":"Westhampton Beach Elem School","ExpirationDate":"2025-03-31","HighSchool":"Westhampton Beach Senior High Sch","InternetAddressDisplayYN":true,"InternetAutomatedValuationDisplayYN":true,"InternetConsumerCommentYN":true,"InternetEntireListingDisplayYN":true,"ListAOR":"LIBOR","ListAgentAOR":"LIBOR","ListAgentDirectPhone":"516-410-4184","ListAgentEmail":"Michael@hamptonproperties.com","ListAgentFullName":"Michael Stachnik","ListAgentKey":"KEY326176655","ListAgentMlsId":"KEY164993","ListOfficeAOR":"LIBOR","ListOfficeKey":"KEY326111913","ListOfficeMlsId":"KEYHAPR01","ListOfficeName":"Hampton Properties","ListOfficePhone":"631-288-6100","ListPrice":2645000,"ListingAgreement":"Exclusive Right To Sell","ListingContractDate":"2024-09-04","ListingId":"KEYL3576457","LotFeatures":["Cleared"],"LotSizeAcres":2.1,"LotSizeArea":2.1,"LotSizeDimensions":"2.1","LotSizeSquareFeet":91476,"MajorChangeTimestamp":"2024-11-20T17:53:18.000Z","MiddleOrJuniorSchool":"Westhampton Middle School","KEY_MlsDistrictCode":"900","KEY_MlsMajorChangeType":"Price Decrease","MlsStatus":"Active","OriginatingSystemModificationTimestamp":"2024-12-19T16:28:57.000Z","KEY_NumOf1BedRooms":"0","KEY_NumOf2BedRooms":"0","KEY_NumOf3BedRooms":"0","KEY_NumOf4BedRooms":"0","OnMarketDate":"2024-09-04","KEY_OpenHouseCount":"0","KEY_OpenHousePublicCount":"0","OriginalEntryTimestamp":"2024-09-04T18:58:29.000Z","OriginalListPrice":2495000,"OriginatingSystemID":"LIBOR","OriginatingSystemKey":"KEY3576457","OriginatingSystemName":"onekey2","KEY_OriginatingSystemTimestamp":"2024-11-20T12:37:33.000","OwnerName":"Sklar","ParcelNumber":"0900-378-00-01-00-012-005","PhotosChangeTimestamp":"2024-11-02T02:19:41.411Z","PhotosCount":2,"PoolPrivateYN":false,"PostalCity":"Westhampton Beach","PostalCode":"11978","PreviousListPrice":2795000,"PriceChangeTimestamp":"2024-11-20T17:37:20.000Z","PropertySubType":"Unimproved Land","PropertyType":"Land","PublicRemarks":"Prime 2 acre building lot, close proximity to the Village of Westhampton Beach and ocean beaches! Property includes a 50' Gunite swimming pool installed in 2023.","KEY_RATIO_ListPrice_By_LotSizeAcres":"1259523.8095","KEY_RATIO_ListPrice_By_OriginalListPrice":"1.06012","KEY_RentSpreeYN":"0","HighSchoolDistrict":"Westhampton Beach","KEY_SeasonalYN":"0","Sewer":["Cesspool"],"ShowingContactPhone":"631-288-6100","SourceSystemID":"3576457","SourceSystemKey":"KEY3576457","SpaYN":false,"StandardStatus":"Active","StateOrProvince":"NY","StreetName":"Main","StreetNumber":"553","StreetNumberNumeric":553,"StreetSuffix":"Street","SyndicateTo":["Realtor.com"],"TaxAnnualAmount":10217,"TaxBlock":"1","TaxLot":"12","KEY_TaxSection":"378","Utilities":["Water Available"],"View":["Water"],"WaterSource":["Public"],"Zoning":"Residential","ModificationTimestamp":"2024-12-19T16:30:36.592Z","Media":[{"ResourceRecordKey":"406446540","Permission":["Public"],"Order":0,"ImageWidth":1900,"ImageHeight":1425,"ImageSizeDescription":"1900x1425","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY406446540\/0131d74c-235f-4bd6-a270-613ef198b014.jpeg","MediaModificationTimestamp":"2024-10-22T11:40:32.244Z","MediaKey":"67178f300d4b0416784ea236"},{"ResourceRecordKey":"406446540","Permission":["Public"],"Order":1,"ImageWidth":1237,"ImageHeight":956,"ImageSizeDescription":"1237x956","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY406446540\/50ecd540-deaf-41b1-b869-40d333fa716c.jpeg","MediaModificationTimestamp":"2024-10-22T11:40:32.279Z","MediaKey":"67178f300d4b0416784ea238"}],"MlgCanView":true,"MlgCanUse":["IDX"]}
[listing_info] => {"list_price":2645000,"sold_price":"","rental_price":2645000,"currency":"Dollar","hide_address":"","street_number":"553","street_name":"Main Street","city":"Southampton","state":"NY","province":"","zip_code":"11978","country":"Westhampton Beach","full_address":"553 Main Street, Southampton, NY 11978","mls_number":"KEYL3576457","listing_broker":"","bedrooms":"","bathrooms":"","garage_spaces":"","year_built":"","building_size":"","lot_size":2.1,"acres_size":"2.1","building_size_unit":"","lot_size_unit":"","virtual_tour":""}
[api_type] => 1
[api_class] => Land
[rets_prop_type] => Unimproved Land
[rets_prop_status] => Active
[out_prop_type] =>
[out_prop_status] =>
[api_prop_features] =>
[open_house] =>
[list_price] => 2645000
[rental_price] => 2645000
[sold_price] => 0
[state] => NY
[city] => Southampton
[zip_code] => 11978
[mls_number] => KEYL3576457
[bedrooms] => 0
[house_size] => 0
[property_size] => 2.1
[bathrooms] => 0
[full_address] => 553 Main Street, Southampton, NY 11978
[street_name] => 553 Main Street
[broker] => Hampton Properties
[listing_key] => KEY406446540
[listing_agent_key] => KEY326176655
[colisting_agent_key1] =>
[colisting_agent_key2] =>
[full_street_address] => 553 Main
[listing_images] => ["https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY406446540\/0131d74c-235f-4bd6-a270-613ef198b014.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY406446540\/50ecd540-deaf-41b1-b869-40d333fa716c.jpeg"]
[SaleOrRent] =>
[RentAmtAugLaborDay] => 0
[RentAmtJulyAug] => 0
[RentAmtJuly] => 0
[RentAmtJune] => 0
[RentAmtMemLaborDay] => 0
[RentAmtOffSeason] => 0
[RentAmtYearRoundMonthly] => 0
[RentAmtjun_jul] => 0
[RentAmtsht_term] => 0
[RentAmtwinter] => 0
[RentAmtSept] => 0
[RentAmtSeptOct] => 0
[RentAmtOct] => 0
[RentAmtNov] => 0
[RentAmtDec] => 0
[RentAmtWeekly] => 0
[RentAmtTwoWeeks] => 0
[RentAmtAugust] => 0
[RentAmtApril] => 0
[RentAmtMay] => 0
[RentAmtAprilMay] => 0
[RentAmtAprilLD] => 0
[RentAmtJulyAugustLD] => 0
[last_modified] => 2024-12-19T16:30:36.592Z
[date_added] => 2025-02-07 06:55:55
)
[3] => Array
(
[ID] => 194443
[post_status] => 1
[post_type] => listing
[post_title] => Bayberry, Southampton
[post_content] => Open Bayfront. Last of Its Kind!!! Bayview's & Sunset views Don't Get Any Better. Traditional Saltbox Home with 4 Bedrooms & 3 Baths. Located On A Quiet Cul De Sac. There is a Large Open Living Room With Fireplace, Eat-In Kitchen and a Bayside Heated Gunite Pool nestled in a Large Sprawling Lawn. This Property Is Ideal For An Expansive Renovation or Build your Bayfront Dream Home.
[raw_info] => {"@odata.id":"https:\/\/api.mlsgrid.com\/v2\/Property('KEY322498201')","ListingKey":"KEY322498201","KEY_AdditionalFees":"0.00","KEY_AdditionalFeesYN":"0","KEY_AdditionalParcelYN":"0","AssociationYN":false,"AttributionContact":"631-325-2132","BasementYN":false,"BathroomsHalf":0,"City":"Southampton","CoBuyerAgentDirectPhone":"631-235-7030","CoListAgentAOR":"LIBOR","CoListAgentDirectPhone":"631-325-2132","CoListAgentEmail":"roxanne@scalaproperties.com","CoListAgentFullName":"Roxanne Paino","CoListAgentKey":"KEY326154060","CoListAgentMlsId":"KEY140658","CoListOfficeKey":"KEY326115446","CoListOfficeMlsId":"KEYSCCU01","CoListOfficeName":"Scala Custom Properties LTD","CoListOfficePhone":"631-325-2132","KEY_ConcessionYN":"0","CountyOrParish":"Suffolk County","CrossStreet":"Tuthill Lane","CumulativeDaysOnMarket":238,"KEY_CurrentPrice":"2600000.00","DaysOnMarket":238,"Directions":"South Country Road to Tuthill Lane to Bayberry Lane","ElementarySchool":"Remsenburg-Speonk Elementary Sch","ExpirationDate":"2025-04-30","KEY_Hamlet":"Remsenburg","HighSchool":"Westhampton Beach Senior High Sch","InternetAddressDisplayYN":true,"InternetAutomatedValuationDisplayYN":true,"InternetConsumerCommentYN":true,"InternetEntireListingDisplayYN":true,"ListAOR":"LIBOR","ListAgentAOR":"LIBOR","ListAgentDirectPhone":"631-278-3767","ListAgentEmail":"ron@scalaproperties.com","ListAgentFullName":"Ron Scala","ListAgentKey":"KEY326153904","ListAgentMlsId":"KEY140495","ListOfficeAOR":"LIBOR","ListOfficeKey":"KEY326115446","ListOfficeMlsId":"KEYSCCU01","ListOfficeName":"Scala Custom Properties LTD","ListOfficePhone":"631-325-2132","ListPrice":2600000,"ListingAgreement":"Exclusive Agency","ListingContractDate":"2024-04-05","ListingId":"KEYL3542621","LotFeatures":["Cleared"],"LotSizeAcres":1,"LotSizeArea":1,"LotSizeDimensions":"1 acre","LotSizeSquareFeet":40075,"MajorChangeTimestamp":"2024-11-04T05:00:00.000Z","MajorChangeType":"Active","MiddleOrJuniorSchool":"Westhampton Middle School","KEY_MlsDistrictCode":"900","KEY_MlsMajorChangeType":"Expired","MlsStatus":"Active","OriginatingSystemModificationTimestamp":"2024-12-03T02:09:20.000Z","KEY_NumOf1BedRooms":"0","KEY_NumOf2BedRooms":"0","KEY_NumOf3BedRooms":"0","KEY_NumOf4BedRooms":"0","OffMarketDate":"2024-10-31","OnMarketDate":"2024-04-05","KEY_OpenHouseCount":"0","KEY_OpenHousePublicCount":"0","OriginalEntryTimestamp":"2024-04-05T04:00:00.000Z","OriginalListPrice":2600000,"OriginatingSystemID":"LIBOR","OriginatingSystemKey":"KEY3542621","OriginatingSystemName":"onekey2","KEY_OriginatingSystemTimestamp":"2024-11-04T14:33:08.000","OwnerName":"Sokolik","ParcelNumber":"0900-380-00-02-00-075-000","PhotosChangeTimestamp":"2024-11-02T02:09:19.281Z","PhotosCount":8,"PoolPrivateYN":false,"PostalCity":"Remsenburg","PostalCode":"11960","PropertySubType":"Unimproved Land","PropertyType":"Land","PublicRemarks":"Open Bayfront. Last of Its Kind!!! Bayview's & Sunset views Don't Get Any Better. Traditional Saltbox Home with 4 Bedrooms & 3 Baths. Located On A Quiet Cul De Sac. There is a Large Open Living Room With Fireplace, Eat-In Kitchen and a Bayside Heated Gunite Pool nestled in a Large Sprawling Lawn. This Property Is Ideal For An Expansive Renovation or Build your Bayfront Dream Home.","KEY_RATIO_ListPrice_By_LotSizeAcres":"2600000.0000","KEY_RATIO_ListPrice_By_OriginalListPrice":"1.00000","KEY_RentSpreeYN":"0","HighSchoolDistrict":"Remsenburg-Speonk","KEY_SeasonalYN":"0","Sewer":["Septic Tank"],"ShowingContactPhone":"631-278-3767","SourceSystemID":"3542621","SourceSystemKey":"KEY3542621","SpaYN":false,"SpecialListingConditions":["Real Estate Owned"],"StandardStatus":"Active","StateOrProvince":"NY","StreetName":"Bayberry","StreetNumber":"5","StreetNumberNumeric":5,"StreetSuffix":"Lane","SyndicateTo":["Realtor.com"],"TaxAnnualAmount":20062,"TaxBlock":"2","TaxLot":"75","View":["Water"],"WaterSource":["Public"],"WaterfrontFeatures":["Waterfront"],"YearBuilt":1994,"Zoning":"Residential","ModificationTimestamp":"2024-12-03T02:16:41.184Z","Media":[{"ResourceRecordKey":"322498201","Permission":["Public"],"Order":0,"ImageWidth":1215,"ImageHeight":880,"ImageSizeDescription":"1215x880","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY322498201\/b017cc2a-a9ae-446c-a865-d849c84401e0.jpeg","MediaModificationTimestamp":"2024-10-22T04:08:34.429Z","MediaKey":"67172542cd665f1a27fcddf2"},{"ResourceRecordKey":"322498201","Permission":["Public"],"Order":1,"ImageWidth":1198,"ImageHeight":853,"ImageSizeDescription":"1198x853","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY322498201\/54dac841-c597-46e9-803a-2833768bbbd7.jpeg","MediaModificationTimestamp":"2024-10-22T04:08:34.302Z","MediaKey":"67172542cd665f1a27fcddf4"},{"ResourceRecordKey":"322498201","Permission":["Public"],"Order":2,"ImageWidth":1016,"ImageHeight":667,"ImageSizeDescription":"1016x667","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY322498201\/5693828b-f653-4fb3-8890-b26ef7dc45e4.jpeg","MediaModificationTimestamp":"2024-10-22T04:08:34.377Z","MediaKey":"67172542cd665f1a27fcddf5"},{"ResourceRecordKey":"322498201","Permission":["Public"],"Order":3,"ImageWidth":1015,"ImageHeight":763,"ImageSizeDescription":"1015x763","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY322498201\/61542b0a-1155-4879-987d-963e759fbd8f.jpeg","MediaModificationTimestamp":"2024-10-22T04:08:34.370Z","MediaKey":"67172542cd665f1a27fcddf6"},{"ResourceRecordKey":"322498201","Permission":["Public"],"Order":4,"ImageWidth":1065,"ImageHeight":801,"ImageSizeDescription":"1065x801","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY322498201\/d3f3355b-e564-4d81-ac8c-c3cd22bebd79.jpeg","MediaModificationTimestamp":"2024-10-22T04:08:34.297Z","MediaKey":"67172542cd665f1a27fcddf7"},{"ResourceRecordKey":"322498201","Permission":["Public"],"Order":5,"ImageWidth":1020,"ImageHeight":755,"ImageSizeDescription":"1020x755","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY322498201\/eab1060e-439d-4b1c-9ab5-cb25ca886611.jpeg","MediaModificationTimestamp":"2024-10-22T04:08:34.290Z","MediaKey":"67172542cd665f1a27fcddf8"},{"ResourceRecordKey":"322498201","Permission":["Public"],"Order":6,"ImageWidth":1017,"ImageHeight":756,"ImageSizeDescription":"1017x756","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY322498201\/81fc50b2-0cb1-4e92-85c3-e5b327de68d0.jpeg","MediaModificationTimestamp":"2024-10-22T04:08:34.377Z","MediaKey":"67172542cd665f1a27fcddf9"},{"ResourceRecordKey":"322498201","Permission":["Public"],"Order":7,"ImageWidth":842,"ImageHeight":636,"ImageSizeDescription":"842x636","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY322498201\/3b8837b7-664c-48b9-a8ea-ea0a36e82e71.jpeg","MediaModificationTimestamp":"2024-10-22T04:08:34.303Z","MediaKey":"67172542cd665f1a27fcddfa"}],"MlgCanView":true,"MlgCanUse":["IDX"]}
[listing_info] => {"list_price":2600000,"sold_price":"","rental_price":2600000,"currency":"Dollar","hide_address":"","street_number":"5","street_name":"Bayberry Lane","city":"Southampton","state":"NY","province":"","zip_code":"11960","country":"Remsenburg","full_address":"5 Bayberry Lane, Southampton, NY 11960","mls_number":"KEYL3542621","listing_broker":"","bedrooms":"","bathrooms":"","garage_spaces":"","year_built":1994,"building_size":"","lot_size":1,"acres_size":"1","building_size_unit":"","lot_size_unit":"","virtual_tour":""}
[api_type] => 1
[api_class] => Land
[rets_prop_type] => Unimproved Land
[rets_prop_status] => Active
[out_prop_type] =>
[out_prop_status] =>
[api_prop_features] =>
[open_house] =>
[list_price] => 2600000
[rental_price] => 2600000
[sold_price] => 0
[state] => NY
[city] => Southampton
[zip_code] => 11960
[mls_number] => KEYL3542621
[bedrooms] => 0
[house_size] => 0
[property_size] => 1
[bathrooms] => 0
[full_address] => 5 Bayberry Lane, Southampton, NY 11960
[street_name] => 5 Bayberry Lane
[broker] => Scala Custom Properties LTD
[listing_key] => KEY322498201
[listing_agent_key] => KEY326153904
[colisting_agent_key1] => KEY326154060
[colisting_agent_key2] =>
[full_street_address] => 5 Bayberry
[listing_images] => ["https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY322498201\/b017cc2a-a9ae-446c-a865-d849c84401e0.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY322498201\/54dac841-c597-46e9-803a-2833768bbbd7.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY322498201\/5693828b-f653-4fb3-8890-b26ef7dc45e4.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY322498201\/61542b0a-1155-4879-987d-963e759fbd8f.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY322498201\/d3f3355b-e564-4d81-ac8c-c3cd22bebd79.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY322498201\/eab1060e-439d-4b1c-9ab5-cb25ca886611.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY322498201\/81fc50b2-0cb1-4e92-85c3-e5b327de68d0.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY322498201\/3b8837b7-664c-48b9-a8ea-ea0a36e82e71.jpeg"]
[SaleOrRent] =>
[RentAmtAugLaborDay] => 0
[RentAmtJulyAug] => 0
[RentAmtJuly] => 0
[RentAmtJune] => 0
[RentAmtMemLaborDay] => 0
[RentAmtOffSeason] => 0
[RentAmtYearRoundMonthly] => 0
[RentAmtjun_jul] => 0
[RentAmtsht_term] => 0
[RentAmtwinter] => 0
[RentAmtSept] => 0
[RentAmtSeptOct] => 0
[RentAmtOct] => 0
[RentAmtNov] => 0
[RentAmtDec] => 0
[RentAmtWeekly] => 0
[RentAmtTwoWeeks] => 0
[RentAmtAugust] => 0
[RentAmtApril] => 0
[RentAmtMay] => 0
[RentAmtAprilMay] => 0
[RentAmtAprilLD] => 0
[RentAmtJulyAugustLD] => 0
[last_modified] => 2024-12-03T02:16:41.184Z
[date_added] => 2025-02-07 06:53:44
)
[4] => Array
(
[ID] => 194941
[post_status] => 1
[post_type] => listing
[post_title] => Sound Ave, Riverhead
[post_content] => This is the opportunity to make your mark on the North Fork. 27 fully fenced acres with a pending 4 lot subdivision. An expansive lavender field, sunflowers, Italian chestnut trees and a collection of over 650 fruit bearing trees including Asian pear, pomegranate, fig, peaches, and 8 different apple varietals. Newly planted pumpkin, watermelon, and European butternut squash. No pesticides used. Great road frontage and visibility at major intersection.
[raw_info] => {"@odata.id":"https:\/\/api.mlsgrid.com\/v2\/Property('KEY322427994')","ListingKey":"KEY322427994","KEY_AdditionalFees":"0.00","KEY_AdditionalFeesYN":"0","KEY_AdditionalParcelYN":"0","AssociationYN":false,"AttributionContact":"631-848-7730","BasementYN":false,"BathroomsHalf":0,"City":"Riverhead","CoBuyerAgentDirectPhone":"914-602-3656","CoListAgentAOR":"LIBOR","CoListAgentDirectPhone":"914-602-3656","CoListAgentEmail":"John.Frangeskos@corcoran.com","CoListAgentFullName":"John G. Frangeskos","CoListAgentKey":"KEY326203128","CoListAgentMlsId":"KEY193338","CoListOfficeKey":"KEY326112438","CoListOfficeMlsId":"KEYJCHA01","CoListOfficeName":"Corcoran","CoListOfficePhone":"631-288-6900","KEY_ConcessionYN":"0","CountyOrParish":"Suffolk County","CrossStreet":"Roanoke Ave","CumulativeDaysOnMarket":619,"KEY_CurrentPrice":"2600000.00","CurrentUse":["Subdivision"],"DaysOnMarket":619,"DevelopmentStatus":["Permit Ap Pending"],"Directions":"On the corner of Sound Ave and Roanoke Ave","ExpirationDate":"2025-04-30","Fencing":["Fenced"],"HighSchool":"Riverhead Senior High School","InternetAddressDisplayYN":true,"InternetAutomatedValuationDisplayYN":false,"InternetConsumerCommentYN":false,"InternetEntireListingDisplayYN":true,"ListAOR":"LIBOR","ListAgentAOR":"LIBOR","ListAgentDirectPhone":"631-848-7730","ListAgentEmail":"swp@corcoran.com","ListAgentFullName":"Sheri Winter Parker","ListAgentKey":"KEY326137839","ListAgentMlsId":"KEY122689","ListOfficeAOR":"LIBOR","ListOfficeKey":"KEY326112439","ListOfficeMlsId":"KEYJCHA02","ListOfficeName":"Corcoran","ListOfficePhone":"631-765-1300","ListPrice":2600000,"ListingAgreement":"Exclusive Right To Sell","ListingContractDate":"2023-04-13","ListingId":"KEYL3471042","LotFeatures":["Cleared","Corner Lot","Part Wooded"],"LotSizeAcres":27.07,"LotSizeArea":27.07,"LotSizeDimensions":"27.07","LotSizeSquareFeet":1179169,"MajorChangeTimestamp":"2024-10-23T04:00:00.000Z","MajorChangeType":"Active","MiddleOrJuniorSchool":"Riverhead Middle School","KEY_MlsMajorChangeType":"Price Decrease","MlsStatus":"Active","OriginatingSystemModificationTimestamp":"2024-12-23T22:48:17.000Z","KEY_NumOf1BedRooms":"0","KEY_NumOf2BedRooms":"0","KEY_NumOf3BedRooms":"0","KEY_NumOf4BedRooms":"0","OnMarketDate":"2023-04-14","KEY_OpenHouseCount":"0","KEY_OpenHousePublicCount":"0","OriginalEntryTimestamp":"2023-04-13T18:29:19.000Z","OriginalListPrice":2950000,"OriginatingSystemID":"LIBOR","OriginatingSystemKey":"KEY3471042","OriginatingSystemName":"onekey2","KEY_OriginatingSystemTimestamp":"2024-10-23T13:47:08.000","OtherStructures":["Outbuilding","Shed(s)"],"OwnerName":"Maris","ParcelNumber":"0600-017-00-01-00-006-002","PhotosChangeTimestamp":"2024-11-02T01:47:59.346Z","PhotosCount":22,"PoolPrivateYN":false,"PostalCity":"Riverhead","PostalCode":"11901","PreviousListPrice":2950000,"PriceChangeTimestamp":"2024-10-23T17:46:44.000Z","PropertySubType":"Unimproved Land","PropertyType":"Land","PublicRemarks":"This is the opportunity to make your mark on the North Fork. 27 fully fenced acres with a pending 4 lot subdivision. An expansive lavender field, sunflowers, Italian chestnut trees and a collection of over 650 fruit bearing trees including Asian pear, pomegranate, fig, peaches, and 8 different apple varietals. Newly planted pumpkin, watermelon, and European butternut squash. No pesticides used. Great road frontage and visibility at major intersection.","KEY_RATIO_ListPrice_By_LotSizeAcres":"96047.2848","KEY_RATIO_ListPrice_By_OriginalListPrice":"0.88136","KEY_RentSpreeYN":"0","RoadFrontageType":["County Road"],"HighSchoolDistrict":"Riverhead","KEY_SeasonalYN":"0","Sewer":["None"],"ShowingContactPhone":"631-848-7730","SourceSystemID":"3471042","SourceSystemKey":"KEY3471042","SpaYN":false,"StandardStatus":"Active","StateOrProvince":"NY","StreetName":"Sound Ave","StreetNumber":"3360","StreetNumberNumeric":3360,"SyndicateTo":["Realtor.com"],"TaxAnnualAmount":17478.58,"TaxBlock":"17","TaxLot":"6.2","KEY_TaxSection":"0600","WaterSource":["Drilled Well"],"Zoning":"Other","ModificationTimestamp":"2024-12-23T22:49:36.329Z","Media":[{"ResourceRecordKey":"322427994","Permission":["Public"],"LongDescription":"Farm Stand","Order":0,"ImageWidth":1900,"ImageHeight":1266,"ImageSizeDescription":"1900x1266","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY322427994\/ac0a6053-3f70-4e30-a1c1-055e7093b436.jpeg","MediaModificationTimestamp":"2024-10-24T09:39:10.536Z","MediaKey":"671a15be5fd0eb2efbd44a4c"},{"ResourceRecordKey":"322427994","Permission":["Public"],"LongDescription":"Lavender","Order":1,"ImageWidth":1900,"ImageHeight":1266,"ImageSizeDescription":"1900x1266","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY322427994\/a4db99f2-b30d-4eb7-a0fe-fa5a162be513.jpeg","MediaModificationTimestamp":"2024-10-24T09:39:10.618Z","MediaKey":"671a15be5fd0eb2efbd44a4e"},{"ResourceRecordKey":"322427994","Permission":["Public"],"LongDescription":"Sunflowers","Order":2,"ImageWidth":1900,"ImageHeight":1266,"ImageSizeDescription":"1900x1266","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY322427994\/a36000e3-a0c2-4672-aea1-5a1729c61257.jpeg","MediaModificationTimestamp":"2024-10-24T09:39:10.547Z","MediaKey":"671a15be5fd0eb2efbd44a4f"},{"ResourceRecordKey":"322427994","Permission":["Public"],"LongDescription":"Lavender","Order":3,"ImageWidth":1900,"ImageHeight":1266,"ImageSizeDescription":"1900x1266","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY322427994\/6f39abb5-8eaf-428b-9876-c41239756f67.jpeg","MediaModificationTimestamp":"2024-10-24T09:39:10.541Z","MediaKey":"671a15be5fd0eb2efbd44a50"},{"ResourceRecordKey":"322427994","Permission":["Public"],"LongDescription":"Farm Stand","Order":4,"ImageWidth":1900,"ImageHeight":1266,"ImageSizeDescription":"1900x1266","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY322427994\/fb54e173-e072-4f1b-b69b-fa97fcc6169c.jpeg","MediaModificationTimestamp":"2024-10-24T09:39:10.430Z","MediaKey":"671a15be5fd0eb2efbd44a51"},{"ResourceRecordKey":"322427994","Permission":["Public"],"LongDescription":"Farm Stand","Order":5,"ImageWidth":1900,"ImageHeight":1266,"ImageSizeDescription":"1900x1266","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY322427994\/e1bffd55-c8f6-4c74-a66e-ae6ee67a9545.jpeg","MediaModificationTimestamp":"2024-10-24T09:39:10.454Z","MediaKey":"671a15be5fd0eb2efbd44a52"},{"ResourceRecordKey":"322427994","Permission":["Public"],"LongDescription":"Greenhouse","Order":6,"ImageWidth":1900,"ImageHeight":1266,"ImageSizeDescription":"1900x1266","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY322427994\/072885c0-cbdb-4054-a252-f1951594fea5.jpeg","MediaModificationTimestamp":"2024-10-24T09:39:10.474Z","MediaKey":"671a15be5fd0eb2efbd44a53"},{"ResourceRecordKey":"322427994","Permission":["Public"],"LongDescription":"3360 Sound Avenue","Order":7,"ImageWidth":1900,"ImageHeight":1266,"ImageSizeDescription":"1900x1266","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY322427994\/68f824ac-4c12-4339-9a11-807353a03b6e.jpeg","MediaModificationTimestamp":"2024-10-24T09:39:10.602Z","MediaKey":"671a15be5fd0eb2efbd44a54"},{"ResourceRecordKey":"322427994","Permission":["Public"],"LongDescription":"Lavender","Order":8,"ImageWidth":1900,"ImageHeight":1266,"ImageSizeDescription":"1900x1266","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY322427994\/58b7b88f-0e70-466d-8f25-e9cd7376630b.jpeg","MediaModificationTimestamp":"2024-10-24T09:39:10.440Z","MediaKey":"671a15be5fd0eb2efbd44a55"},{"ResourceRecordKey":"322427994","Permission":["Public"],"LongDescription":"Fruit Trees","Order":9,"ImageWidth":1900,"ImageHeight":1266,"ImageSizeDescription":"1900x1266","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY322427994\/7c69b8ef-9209-4429-b6bd-d54a356185d4.jpeg","MediaModificationTimestamp":"2024-10-24T09:39:10.486Z","MediaKey":"671a15be5fd0eb2efbd44a56"},{"ResourceRecordKey":"322427994","Permission":["Public"],"LongDescription":"Fruit Trees","Order":10,"ImageWidth":1900,"ImageHeight":1266,"ImageSizeDescription":"1900x1266","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY322427994\/f067b9cc-2c06-4355-bfa6-6057fb9b717e.jpeg","MediaModificationTimestamp":"2024-10-24T09:39:10.519Z","MediaKey":"671a15be5fd0eb2efbd44a57"},{"ResourceRecordKey":"322427994","Permission":["Public"],"LongDescription":"3360 Sound Avenue","Order":11,"ImageWidth":1900,"ImageHeight":1266,"ImageSizeDescription":"1900x1266","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY322427994\/f5642c81-e3d3-40fc-9556-6605b988291a.jpeg","MediaModificationTimestamp":"2024-10-24T09:39:10.511Z","MediaKey":"671a15be5fd0eb2efbd44a58"},{"ResourceRecordKey":"322427994","Permission":["Public"],"LongDescription":"27 Acres","Order":12,"ImageWidth":1900,"ImageHeight":1067,"ImageSizeDescription":"1900x1067","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY322427994\/566d8706-94e9-45b9-90e1-bdef0c8a8ec3.jpeg","MediaModificationTimestamp":"2024-10-24T09:39:10.464Z","MediaKey":"671a15be5fd0eb2efbd44a59"},{"ResourceRecordKey":"322427994","Permission":["Public"],"LongDescription":"Lavender","Order":13,"ImageWidth":1900,"ImageHeight":1067,"ImageSizeDescription":"1900x1067","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY322427994\/77eba8f9-a9ab-49ac-9e6d-564aaa380bb8.jpeg","MediaModificationTimestamp":"2024-10-24T09:39:10.519Z","MediaKey":"671a15be5fd0eb2efbd44a5a"},{"ResourceRecordKey":"322427994","Permission":["Public"],"LongDescription":"Fruit Trees","Order":14,"ImageWidth":1900,"ImageHeight":1067,"ImageSizeDescription":"1900x1067","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY322427994\/aa8fb2c9-d9c8-4c88-83f1-418f4568228c.jpeg","MediaModificationTimestamp":"2024-10-24T09:39:10.494Z","MediaKey":"671a15be5fd0eb2efbd44a5b"},{"ResourceRecordKey":"322427994","Permission":["Public"],"LongDescription":"3360 Sound Avenue","Order":15,"ImageWidth":1900,"ImageHeight":1067,"ImageSizeDescription":"1900x1067","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY322427994\/53d2c7c9-cabe-4835-a087-f9515b540490.jpeg","MediaModificationTimestamp":"2024-10-24T09:39:10.538Z","MediaKey":"671a15be5fd0eb2efbd44a5c"},{"ResourceRecordKey":"322427994","Permission":["Public"],"LongDescription":"3360 Sound Avenue","Order":16,"ImageWidth":1900,"ImageHeight":1067,"ImageSizeDescription":"1900x1067","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY322427994\/5a94aba3-4c4a-43a0-9e96-e98a8151ac16.jpeg","MediaModificationTimestamp":"2024-10-24T09:39:10.581Z","MediaKey":"671a15be5fd0eb2efbd44a5d"},{"ResourceRecordKey":"322427994","Permission":["Public"],"LongDescription":"3360 Sound Avenue","Order":17,"ImageWidth":1900,"ImageHeight":1067,"ImageSizeDescription":"1900x1067","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY322427994\/d8842d6a-2d2b-435b-81ee-44cf479136ae.jpeg","MediaModificationTimestamp":"2024-10-24T09:39:10.604Z","MediaKey":"671a15be5fd0eb2efbd44a5e"},{"ResourceRecordKey":"322427994","Permission":["Public"],"LongDescription":"Farm and buildable lot","Order":18,"ImageWidth":1900,"ImageHeight":1067,"ImageSizeDescription":"1900x1067","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY322427994\/a071b9bf-a308-4635-8426-246e7c60cb57.jpeg","MediaModificationTimestamp":"2024-10-24T09:39:10.564Z","MediaKey":"671a15be5fd0eb2efbd44a5f"},{"ResourceRecordKey":"322427994","Permission":["Public"],"LongDescription":"Farm and buildable lot","Order":19,"ImageWidth":1900,"ImageHeight":1067,"ImageSizeDescription":"1900x1067","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY322427994\/395c4e12-0316-4f15-959e-88f2dbbd0135.jpeg","MediaModificationTimestamp":"2024-10-24T09:39:10.497Z","MediaKey":"671a15be5fd0eb2efbd44a60"},{"ResourceRecordKey":"322427994","Permission":["Public"],"LongDescription":"3360 Sound Avenue","Order":20,"ImageWidth":1900,"ImageHeight":1067,"ImageSizeDescription":"1900x1067","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY322427994\/b9c42088-80b8-469f-be4b-9fd884ce3f57.jpeg","MediaModificationTimestamp":"2024-10-24T09:39:10.498Z","MediaKey":"671a15be5fd0eb2efbd44a61"},{"ResourceRecordKey":"322427994","Permission":["Public"],"LongDescription":"3360 Sound Avenue","Order":21,"ImageWidth":1900,"ImageHeight":1067,"ImageSizeDescription":"1900x1067","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY322427994\/fcb50181-6688-4dcc-8929-c1e216ace99a.jpeg","MediaModificationTimestamp":"2024-10-24T09:39:10.464Z","MediaKey":"671a15be5fd0eb2efbd44a62"}],"MlgCanView":true,"MlgCanUse":["IDX"]}
[listing_info] => {"list_price":2600000,"sold_price":"","rental_price":2600000,"currency":"Dollar","hide_address":"","street_number":"3360","street_name":"Sound Ave ","city":"Riverhead","state":"NY","province":"","zip_code":"11901","country":"Riverhead","full_address":"3360 Sound Ave , Riverhead, NY 11901","mls_number":"KEYL3471042","listing_broker":"","bedrooms":"","bathrooms":"","garage_spaces":"","year_built":"","building_size":"","lot_size":27.07,"acres_size":"27.07","building_size_unit":"","lot_size_unit":"","virtual_tour":""}
[api_type] => 1
[api_class] => Land
[rets_prop_type] => Unimproved Land
[rets_prop_status] => Active
[out_prop_type] =>
[out_prop_status] =>
[api_prop_features] =>
[open_house] =>
[list_price] => 2600000
[rental_price] => 2600000
[sold_price] => 0
[state] => NY
[city] => Riverhead
[zip_code] => 11901
[mls_number] => KEYL3471042
[bedrooms] => 0
[house_size] => 0
[property_size] => 27.07
[bathrooms] => 0
[full_address] => 3360 Sound Ave , Riverhead, NY 11901
[street_name] => 3360 Sound Ave
[broker] => Corcoran
[listing_key] => KEY322427994
[listing_agent_key] => KEY326137839
[colisting_agent_key1] => KEY326203128
[colisting_agent_key2] =>
[full_street_address] => 3360 Sound Ave
[listing_images] => ["https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY322427994\/ac0a6053-3f70-4e30-a1c1-055e7093b436.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY322427994\/a4db99f2-b30d-4eb7-a0fe-fa5a162be513.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY322427994\/a36000e3-a0c2-4672-aea1-5a1729c61257.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY322427994\/6f39abb5-8eaf-428b-9876-c41239756f67.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY322427994\/fb54e173-e072-4f1b-b69b-fa97fcc6169c.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY322427994\/e1bffd55-c8f6-4c74-a66e-ae6ee67a9545.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY322427994\/072885c0-cbdb-4054-a252-f1951594fea5.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY322427994\/68f824ac-4c12-4339-9a11-807353a03b6e.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY322427994\/58b7b88f-0e70-466d-8f25-e9cd7376630b.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY322427994\/7c69b8ef-9209-4429-b6bd-d54a356185d4.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY322427994\/f067b9cc-2c06-4355-bfa6-6057fb9b717e.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY322427994\/f5642c81-e3d3-40fc-9556-6605b988291a.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY322427994\/566d8706-94e9-45b9-90e1-bdef0c8a8ec3.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY322427994\/77eba8f9-a9ab-49ac-9e6d-564aaa380bb8.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY322427994\/aa8fb2c9-d9c8-4c88-83f1-418f4568228c.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY322427994\/53d2c7c9-cabe-4835-a087-f9515b540490.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY322427994\/5a94aba3-4c4a-43a0-9e96-e98a8151ac16.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY322427994\/d8842d6a-2d2b-435b-81ee-44cf479136ae.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY322427994\/a071b9bf-a308-4635-8426-246e7c60cb57.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY322427994\/395c4e12-0316-4f15-959e-88f2dbbd0135.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY322427994\/b9c42088-80b8-469f-be4b-9fd884ce3f57.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY322427994\/fcb50181-6688-4dcc-8929-c1e216ace99a.jpeg"]
[SaleOrRent] =>
[RentAmtAugLaborDay] => 0
[RentAmtJulyAug] => 0
[RentAmtJuly] => 0
[RentAmtJune] => 0
[RentAmtMemLaborDay] => 0
[RentAmtOffSeason] => 0
[RentAmtYearRoundMonthly] => 0
[RentAmtjun_jul] => 0
[RentAmtsht_term] => 0
[RentAmtwinter] => 0
[RentAmtSept] => 0
[RentAmtSeptOct] => 0
[RentAmtOct] => 0
[RentAmtNov] => 0
[RentAmtDec] => 0
[RentAmtWeekly] => 0
[RentAmtTwoWeeks] => 0
[RentAmtAugust] => 0
[RentAmtApril] => 0
[RentAmtMay] => 0
[RentAmtAprilMay] => 0
[RentAmtAprilLD] => 0
[RentAmtJulyAugustLD] => 0
[last_modified] => 2024-12-23T22:49:36.329Z
[date_added] => 2025-02-07 06:55:58
)
[5] => Array
(
[ID] => 164028
[post_status] => 1
[post_type] => listing
[post_title] => Two Holes of Water, East Hampton
[post_content] => 1.7+ acre lot at 316 Two Holes of Water, East Hampton has room for tennis and pool. Privacy and convenience close to East Hampton Village, shopping and beaches. Southern exposure, beautiful trees, perfect topography. and adjacent to a 33.44 acre farm...a must see. www.316twoholesofwaterroad.com
[raw_info] => {"AboveArea":"0","MemberId":"526221","CoListMemberId":"526293","CoListMemberId2":"526259","Address":"316 Two Holes of Water","PublicRemarks":"1.7+ acre lot at 316 Two Holes of Water, East Hampton has room for tennis and pool. Privacy and convenience close to East Hampton Village, shopping and beaches. Southern exposure, beautiful trees, perfect topography. and adjacent to a 33.44 acre farm...a must see. www.316twoholesofwaterroad.com","ApDishwasher":"","ApDisposal":"","ApDryer":"","ApFridge":"","ApHotWaterHeater":"","ApMicrowave":"","ApOven":"","ApStainlessSteel":"","ApWasher":"","ApartmentType":"0","AtticAccess":"0","AtticType":"0","AuctionEndDatetime":"","AuctionStartDatetime":"","AuctionUrl":"","AvailDate":"","BasementType":"0","Beds":"0","Bld55over":"0","BldBasement":"0","BldBike":"0","BldClubhouse":"0","BldConcierge":"0","BldDoorman":"0","BldElevator":"0","BldGated":"0","BldGolf":"0","BldGym":"0","BldLaundry":"0","BldParking":"0","BldPets":"0","BldPlayground":"0","BldPool":"0","BldPostWar":"0","BldPreWar":"0","BldRecRoom":"0","BldRooftop":"0","BldSauna":"0","BldScreening":"0","BldSecurity":"0","BldSmoking":"0","BldStorage":"0","BldTennisCourt":"0","BmArea":"","BmBaths":"","BmBeds":"","BmBilco":"","BmFinished":"","BmGarage":"","BmKitchen":"","BmNoAccess":"","BmPartlyFinished":"","BmUnfinished":"","BmWalkout":"","BuildingStyle":"0","BuyerAgentCompany":"","BuyerMemberId":"0","BuyerAgentName":"","BuyerOfficeId":"0","CentralAc":"0","City":"East Hampton","CommercialType":"0","CommissionComments":"Broker Agent: 2.5","ComplexName":"","ConstructionType":"0","Contractdate":"","County":"36103","CurrentStatusTime":"2024-11-18T14:51:57","Directions":"","ExAttachedPark":"0","ExCorner":"0","ExCoveredPorch":"0","ExCulDeSac":"0","ExDeck":"0","ExDriveway":"0","ExEnclosedPorch":"0","ExEquestrian":"0","ExExteriorMaterial":"","ExFence":"0","ExGolf":"0","ExOpenPorch":"0","ExOutdoorShower":"0","ExPatio":"0","ExPermit":"0","ExRoomForGarage":"0","ExRoomForPool":"1","ExRoomForTennis":"1","ExScreenPorch":"0","ExSprinklerSystem":"0","ExSubdivision":"","ExSurvey":"1","ExTennis":"0","ExTennisCourtSurface":"","ExTrees":"1","ExUtilities":"0","Expiredate":"2025-12-31T05:00:00","Fireplaces":"0","FlCarpet":"","FlGranite":"","FlHardwood":"","FlLaminate":"","FlLinoleum":"","FlMarble":"","FlStone":"","FlTile":"","FlVinyl":"","FloorNum":"","FullBaths":"0","Furnished":"0","GarageSpaces":"0","GarageType":"0","H2oAccess":"0","H2oBay":"0","H2oBeachRights":"0","H2oCanal":"0","H2oCreek":"0","H2oDeepWaterDock":"0","H2oDock":"0","H2oDockDepth":"","H2oDockRights":"0","H2oFrontage":"","H2oHarbor":"0","H2oInlet":"0","H2oKill":"0","H2oLake":"0","H2oOcean":"0","H2oPond":"0","H2oRiver":"0","H2oSound":"0","H2oStream":"0","H2oWaterName":"","HalfBaths":"0","HamletId":"0","Handicap":"0","HasPool":"0","HfCoal":"","HfElectric":"","HfGas":"","HfKerosene":"","HfNaturalGas":"","HfOil":"","HfPropane":"","HfSolar":"","HfWood":"","HiddenDraft":"0","Hoa":"0","HoaDevelopment":"","HoaFee":"0","HoaName":"","HoaPhone":"","HowSold":"Unknown","HtBaseboard":"","HtForcedAir":"","HtGeoThermal":"","HtHeatAcZones":"","HtHotWater":"","HtHydroAir":"","HtNoHeat":"","HtOther":"","HtPump":"","HtRadiant":"","HtSteam":"","InAlarm":"","InAmps":"","InSprinklers":"","InStaffBaths":"","InStaffBeds":"","IsAbsoluteAuction":"","IsCompanyPrivate":"0","IsLandLease":"0","IsOnlineOnlyAuction":"","IsSeasonal":"0","IsWaterView":"0","IsWaterfront":"0","KitchenCounter":"0","KitchenType":"0","LandFrontage":"0","LandLeaseFee":"0","LastPriceTime":"2021-09-13T12:14:21","LastPriceValue":"2650000","LastStatusTime":"2024-10-01T04:00:00","LastStatusValue":"300","Latitude":"40.977233","Listdate":"2018-01-02T05:00:00","ListingType":"Exclusive","ListingUrl":"","Created":"2019-05-17T19:03:07","ListingId":"50945","Modified":"2024-11-19T05:15:01","Longitude":"-72.227192","LotSize":"1.75","LotSqft":"0","MarketHeadline":"316 Two Holes of Water, East Hampton, NY","MaxTerm":"","MinTerm":"","MlsName":"EastEndLI","MotAuction":"0","MotBank":"0","MotEstate":"0","MotForeclosure":"0","MotPreforeclosure":"0","MotShortsale":"0","NaturalGas":"0","NearBus":"0","NearSchool":"0","NearTrain":"0","Neighborhood":"EH Northwest","NewConstruction":"0","NoFee":"0","NumLots":"0","NumPhotos":"2","NumRooms":"0","NumUnits":"0","Occupancy":"0","Offerdate":"","OfficeId":"120088","OhBarn":"0","OhCabana":"0","OhCarport":"0","OhGeneral":"0","OhGreenhouse":"0","OhGuestHouse":"0","OhGym":"0","OhOffice":"0","OhPoolHouse":"0","OhRidingRing":"0","OhShed":"0","OhStable":"0","OhStudio":"0","OhWorkshop":"0","Parcel":"0300-157.00-02.00-001.001","PctTaxDeduct":"0","PhotosTimestamp":"2021-09-13T18:50:42","PoolAboveGround":"0","PoolChildProof":"0","PoolGunite":"0","PoolHeated":"0","PoolInGround":"0","PoolIndoor":"0","PoolInfinity":"0","PoolSaltWater":"0","PoolSauna":"0","PoolSize":"","PoolSolar":"0","PoolSpa":"0","PoolVinyl":"0","Price":"2500000","PriceOriginal":"2500000","PriceSale":"0","PrivateRemarks":"Location Comments:<\/b> Near East Hampton Village
Taxes Comments:<\/b> TBD
Privacy Comments:<\/b> can access fr Old Two Holes
DEC Comments:<\/b> for house pool garage pool house.. variance required for tennis
Lot Features Comments:<\/b> southern exposure
","PropertyClass":"","PropertyType":"Vacant Land","RenovationComments":"","RenovationYear":"0","RentInternet":"","RentLandlordShow":"","RentLinens":"","RentMaxPeople":"","RentPetNotes":"","RentPets":"","RentRegExpireDate":"","RentRegNum":"","RentSmoking":"","RentTv":"","Rentdate":"","ResidentialStyle":"0","RetsBrokerWeb":"1","RetsHamptonsRe":"1","RetsIdx":"0","RfAsphalt":"0","RfCedar":"0","RfFlat":"0","RfMetal":"0","RfRubber":"0","RfSlate":"0","RfTar":"0","RfTile":"0","RmArtStudio":"","RmBonus":"","RmBreakfast":"","RmDen":"","RmDining":"","RmEnSuite":"","RmFamily":"","RmFirstFloorBath":"","RmFirstFloorMaster":"","RmFormal":"","RmFoyer":"","RmGreat":"","RmGym":"","RmKitchen":"","RmLaundry":"","RmLibrary":"","RmLiving":"","RmLoft":"","RmMasterBedroom":"","RmMedia":"","RmPrivateGuest":"","RmStudy":"","RmWalkInCloset":"","SaleRent":"S","Saledate":"","SchoolDistrict":"000000","SdAluminum":"0","SdAsbestos":"0","SdBrick":"0","SdCedarClapboard":"0","SdCedarShake":"0","SdCement":"0","SdHardi":"0","SdLog":"0","SdMasonry":"0","SdStone":"0","SdStucco":"0","SdT111":"0","SdVinyl":"0","SdWood":"0","SectionId":"520","SewerType":"0","ShowPrice":"1","Soh":"0","SourceMlsid":"L30289","SourceMlsid2":"11626","SourceName":"TWNC","StPellet":"","StPropane":"","StWood":"","State":"NY","Status":"Active","Stories":"0","StreetName":"Two Holes of Water","StreetNum":"316","TaxTotal":"0","TaxYear":"0","Tempoffmktdate":"","TotalCommission":"5","Township":"East Hampton","UfBalcony":"0","UfCentralVac":"0","UfCorner":"0","UfFireEscape":"0","UfGarden":"0","UfGroundFloor":"0","UfIntercom":"0","UfLaundry":"0","UfTerrace":"0","UfUpperFloor":"0","UndisclosedAddress":"0","UnitNum":"","VirtualTour":"","VwBay":"0","VwCanal":"0","VwCity":"0","VwCreek":"0","VwFarm":"0","VwHarbor":"0","VwInlet":"0","VwLake":"0","VwMountain":"0","VwOcean":"0","VwPark":"0","VwPond":"0","VwPrivate":"0","VwRiver":"0","VwScenic":"0","VwSound":"0","VwStream":"0","VwStreet":"0","VwWater":"0","VwWooded":"0","WallwinAc":"0","WaterType":"0","WebId":"3974","Withdrawdate":"","YearBuilt":"0","YoutubeVideoId":"","Zip":"11937","Zone":"0"}
[listing_info] => {"list_price":"2500000","sold_price":"","rental_price":"2500000","currency":"Dollar","hide_address":"","street_number":"316","street_name":"Two Holes of Water","city":"East Hampton","state":"NY","province":"NY","zip_code":"11937","country":"","full_address":"316 Two Holes of Water, East Hampton, NY 11937","mls_number":"50945","listing_broker":"Broker Agent: 2.5","bedrooms":"0","bathrooms":0,"garage_spaces":"0","year_built":"0","building_size":null,"lot_size":"0","acres_size":"1.75","building_size_unit":"","lot_size_unit":"","virtual_tour":""}
[api_type] => 2
[api_class] => ForSale
[rets_prop_type] =>
[rets_prop_status] =>
[out_prop_type] => land
[out_prop_status] => for-sale
[api_prop_features] => []
[open_house] =>
[list_price] => 2500000
[rental_price] => 2500000
[sold_price] => 0
[state] => NY
[city] => East Hampton
[zip_code] => 11937
[mls_number] => 3974
[bedrooms] => 0
[house_size] => 0
[property_size] => 1.75
[bathrooms] => 0
[full_address] => 316 Two Holes of Water, East Hampton, NY 11937
[street_name] => 316 Two Holes of Water
[broker] => Broker Agent: 2.5
[listing_key] => 50945
[listing_agent_key] => 526221
[colisting_agent_key1] => 526293
[colisting_agent_key2] => 526259
[full_street_address] => 316 Two Holes of Water
[listing_images] => ["https:\/\/c8df8a41cf6851329c37-1626a054a54d8cef02a324905c73d1b4.ssl.cf5.rackcdn.com\/5\/45\/EELI_LSTHD1\/50945\/50945-MCkDZBYvJ5DjbSvm.jpg","https:\/\/cdn.dovetaildata.com\/images\/LSTIMG\/TWNC\/PH\/11\/19917979\/11626-1.jpg"]
[SaleOrRent] => S
[RentAmtAugLaborDay] => 0
[RentAmtJulyAug] => 0
[RentAmtJuly] => 0
[RentAmtJune] => 0
[RentAmtMemLaborDay] => 0
[RentAmtOffSeason] => 0
[RentAmtYearRoundMonthly] => 0
[RentAmtjun_jul] => 0
[RentAmtsht_term] => 0
[RentAmtwinter] => 0
[RentAmtSept] => 0
[RentAmtSeptOct] => 0
[RentAmtOct] => 0
[RentAmtNov] => 0
[RentAmtDec] => 0
[RentAmtWeekly] => 0
[RentAmtTwoWeeks] => 0
[RentAmtAugust] => 0
[RentAmtApril] => 0
[RentAmtMay] => 0
[RentAmtAprilMay] => 0
[RentAmtAprilLD] => 0
[RentAmtJulyAugustLD] => 0
[last_modified] => 2024-11-19T05:15:01
[date_added] => 2020-05-26 02:13:35
)
[6] => Array
(
[ID] => 188280
[post_status] => 1
[post_type] => listing
[post_title] => Oak View Highway, East Hampton
[post_content] => 4+ ACRE PARCEL IN EAST HAMPTON VILLAGE FRINGE, located at 154 Oak View Highway. An incredible opportunity that rarely comes along, this 4.1 acre flat vacant parcel is located less than 1 mile to East Hampton Village. This secluded property is nestled amongst horse farms and other multiple acre lots with over 14,000 sq. ft. of building coverage and 40,000 sq. ft. of lot coverage allowed. www.154OakViewHighway.com
[raw_info] => {"AboveArea":"0","MemberId":"526259","CoListMemberId":"527700","CoListMemberId2":"528491","Address":"154 Oak View Highway","PublicRemarks":"4+ ACRE PARCEL IN EAST HAMPTON VILLAGE FRINGE, located at 154 Oak View Highway. An incredible opportunity that rarely comes along, this 4.1 acre flat vacant parcel is located less than 1 mile to East Hampton Village. This secluded property is nestled amongst horse farms and other multiple acre lots with over 14,000 sq. ft. of building coverage and 40,000 sq. ft. of lot coverage allowed. www.154OakViewHighway.com","ApDishwasher":"","ApDisposal":"","ApDryer":"","ApFridge":"","ApHotWaterHeater":"","ApMicrowave":"","ApOven":"","ApStainlessSteel":"","ApWasher":"","ApartmentType":"0","AtticAccess":"0","AtticType":"0","AuctionEndDatetime":"","AuctionStartDatetime":"","AuctionUrl":"","AvailDate":"","BasementType":"0","Beds":"0","Bld55over":"","BldBasement":"","BldBike":"","BldClubhouse":"","BldConcierge":"","BldDoorman":"","BldElevator":"","BldGated":"","BldGolf":"","BldGym":"","BldLaundry":"","BldParking":"","BldPets":"","BldPlayground":"","BldPool":"","BldPostWar":"","BldPreWar":"","BldRecRoom":"","BldRooftop":"","BldSauna":"","BldScreening":"","BldSecurity":"","BldSmoking":"","BldStorage":"","BldTennisCourt":"","BmArea":"","BmBaths":"","BmBeds":"","BmBilco":"","BmFinished":"","BmGarage":"","BmKitchen":"","BmNoAccess":"","BmPartlyFinished":"","BmUnfinished":"","BmWalkout":"","BuildingStyle":"0","BuyerAgentCompany":"","BuyerMemberId":"0","BuyerAgentName":"","BuyerOfficeId":"0","CentralAc":"0","City":"East Hampton","CommercialType":"0","CommissionComments":"2.25","ComplexName":"","ConstructionType":"0","Contractdate":"","County":"36103","CurrentStatusTime":"","Directions":"","ExAttachedPark":"","ExCorner":"","ExCoveredPorch":"","ExCulDeSac":"","ExDeck":"","ExDriveway":"","ExEnclosedPorch":"","ExEquestrian":"","ExExteriorMaterial":"","ExFence":"","ExGolf":"","ExOpenPorch":"","ExOutdoorShower":"","ExPatio":"","ExPermit":"","ExRoomForGarage":"","ExRoomForPool":"","ExRoomForTennis":"","ExScreenPorch":"","ExSprinklerSystem":"","ExSubdivision":"","ExSurvey":"","ExTennis":"","ExTennisCourtSurface":"","ExTrees":"","ExUtilities":"","Expiredate":"2025-05-31T04:00:00","Fireplaces":"0","FlCarpet":"","FlGranite":"","FlHardwood":"","FlLaminate":"","FlLinoleum":"","FlMarble":"","FlStone":"","FlTile":"","FlVinyl":"","FloorNum":"","FullBaths":"0","Furnished":"0","GarageSpaces":"0","GarageType":"0","H2oAccess":"","H2oBay":"","H2oBeachRights":"","H2oCanal":"","H2oCreek":"","H2oDeepWaterDock":"","H2oDock":"","H2oDockDepth":"","H2oDockRights":"","H2oFrontage":"","H2oHarbor":"","H2oInlet":"","H2oKill":"","H2oLake":"","H2oOcean":"","H2oPond":"","H2oRiver":"","H2oSound":"","H2oStream":"","H2oWaterName":"","HalfBaths":"0","HamletId":"108","Handicap":"0","HasPool":"0","HfCoal":"","HfElectric":"","HfGas":"","HfKerosene":"","HfNaturalGas":"","HfOil":"","HfPropane":"","HfSolar":"","HfWood":"","HiddenDraft":"0","Hoa":"0","HoaDevelopment":"","HoaFee":"","HoaName":"","HoaPhone":"","HowSold":"Unknown","HtBaseboard":"","HtForcedAir":"","HtGeoThermal":"","HtHeatAcZones":"","HtHotWater":"","HtHydroAir":"","HtNoHeat":"","HtOther":"","HtPump":"","HtRadiant":"","HtSteam":"","InAlarm":"","InAmps":"","InSprinklers":"","InStaffBaths":"","InStaffBeds":"","IsAbsoluteAuction":"","IsCompanyPrivate":"0","IsLandLease":"0","IsOnlineOnlyAuction":"","IsSeasonal":"0","IsWaterView":"0","IsWaterfront":"0","KitchenCounter":"0","KitchenType":"0","LandFrontage":"0","LandLeaseFee":"0","LastPriceTime":"2023-08-16T04:00:00","LastPriceValue":"2600000","LastStatusTime":"","LastStatusValue":"0","Latitude":"40.981336","Listdate":"2023-08-16T04:00:00","ListingType":"Exclusive","ListingUrl":"","Created":"2023-08-16T12:13:33","ListingId":"904472","Modified":"2024-07-23T16:47:46","Longitude":"-72.193716","LotSize":"4.10","LotSqft":"0","MarketHeadline":"154 Oak View Highway, East Hampton","MaxTerm":"","MinTerm":"","MlsName":"EastEndLI","MotAuction":"0","MotBank":"0","MotEstate":"0","MotForeclosure":"0","MotPreforeclosure":"0","MotShortsale":"0","NaturalGas":"0","NearBus":"0","NearSchool":"0","NearTrain":"0","Neighborhood":"","NewConstruction":"0","NoFee":"0","NumLots":"0","NumPhotos":"2","NumRooms":"0","NumUnits":"0","Occupancy":"0","Offerdate":"","OfficeId":"120088","OhBarn":"","OhCabana":"","OhCarport":"","OhGeneral":"","OhGreenhouse":"","OhGuestHouse":"","OhGym":"","OhOffice":"","OhPoolHouse":"","OhRidingRing":"","OhShed":"","OhStable":"","OhStudio":"","OhWorkshop":"","Parcel":"0300-159.000-0003-002.002","PctTaxDeduct":"0","PhotosTimestamp":"2023-08-16T13:57:03","PoolAboveGround":"","PoolChildProof":"","PoolGunite":"","PoolHeated":"","PoolInGround":"","PoolIndoor":"","PoolInfinity":"","PoolSaltWater":"","PoolSauna":"","PoolSize":"","PoolSolar":"","PoolSpa":"","PoolVinyl":"","Price":"2500000","PriceOriginal":"2600000","PriceSale":"0","PrivateRemarks":"","PropertyClass":"311","PropertyType":"Vacant Land","RenovationComments":"","RenovationYear":"0","RentInternet":"","RentLandlordShow":"","RentLinens":"","RentMaxPeople":"","RentPetNotes":"","RentPets":"","RentRegExpireDate":"","RentRegNum":"","RentSmoking":"","RentTv":"","Rentdate":"","ResidentialStyle":"0","RetsBrokerWeb":"1","RetsHamptonsRe":"1","RetsIdx":"0","RfAsphalt":"","RfCedar":"","RfFlat":"","RfMetal":"","RfRubber":"","RfSlate":"","RfTar":"","RfTile":"","RmArtStudio":"","RmBonus":"","RmBreakfast":"","RmDen":"","RmDining":"","RmEnSuite":"","RmFamily":"","RmFirstFloorBath":"","RmFirstFloorMaster":"","RmFormal":"","RmFoyer":"","RmGreat":"","RmGym":"","RmKitchen":"","RmLaundry":"","RmLibrary":"","RmLiving":"","RmLoft":"","RmMasterBedroom":"","RmMedia":"","RmPrivateGuest":"","RmStudy":"","RmWalkInCloset":"","SaleRent":"S","Saledate":"","SchoolDistrict":"000000","SdAluminum":"","SdAsbestos":"","SdBrick":"","SdCedarClapboard":"","SdCedarShake":"","SdCement":"","SdHardi":"","SdLog":"","SdMasonry":"","SdStone":"","SdStucco":"","SdT111":"","SdVinyl":"","SdWood":"","SectionId":"516","SewerType":"0","ShowPrice":"1","Soh":"0","SourceMlsid":"","SourceMlsid2":"","SourceName":"PRO","StPellet":"","StPropane":"","StWood":"","State":"NY","Status":"Active","Stories":"0","StreetName":"Oak View Highway","StreetNum":"154","TaxTotal":"0","TaxYear":"0","Tempoffmktdate":"","TotalCommission":"4.5","Township":"East Hampton","UfBalcony":"","UfCentralVac":"","UfCorner":"","UfFireEscape":"","UfGarden":"","UfGroundFloor":"","UfIntercom":"","UfLaundry":"","UfTerrace":"","UfUpperFloor":"","UndisclosedAddress":"0","UnitNum":"","VirtualTour":"","VwBay":"","VwCanal":"","VwCity":"","VwCreek":"","VwFarm":"","VwHarbor":"","VwInlet":"","VwLake":"","VwMountain":"","VwOcean":"","VwPark":"","VwPond":"","VwPrivate":"","VwRiver":"","VwScenic":"","VwSound":"","VwStream":"","VwStreet":"","VwWater":"","VwWooded":"","WallwinAc":"0","WaterType":"0","WebId":"","Withdrawdate":"","YearBuilt":"0","YoutubeVideoId":"","Zip":"11937","Zone":"0"}
[listing_info] => {"list_price":"2500000","sold_price":"","rental_price":"2500000","currency":"Dollar","hide_address":"","street_number":"154","street_name":"Oak View Highway","city":"East Hampton","state":"NY","province":"NY","zip_code":"11937","country":"","full_address":"154 Oak View Highway, East Hampton, NY 11937","mls_number":"904472","listing_broker":"2.25","bedrooms":"0","bathrooms":0,"garage_spaces":"0","year_built":"0","building_size":null,"lot_size":"0","acres_size":"4.10","building_size_unit":"","lot_size_unit":"","virtual_tour":""}
[api_type] => 2
[api_class] => ForSale
[rets_prop_type] =>
[rets_prop_status] =>
[out_prop_type] => land
[out_prop_status] => for-sale
[api_prop_features] => []
[open_house] =>
[list_price] => 2500000
[rental_price] => 2500000
[sold_price] => 0
[state] => NY
[city] => East Hampton
[zip_code] => 11937
[mls_number] =>
[bedrooms] => 0
[house_size] => 0
[property_size] => 4.1
[bathrooms] => 0
[full_address] => 154 Oak View Highway, East Hampton, NY 11937
[street_name] => 154 Oak View Highway
[broker] => 2.25
[listing_key] => 904472
[listing_agent_key] => 526259
[colisting_agent_key1] => 527700
[colisting_agent_key2] => 528491
[full_street_address] => 154 Oak View
[listing_images] => ["https:\/\/c8df8a41cf6851329c37-1626a054a54d8cef02a324905c73d1b4.ssl.cf5.rackcdn.com\/90\/72\/EELI_LSTHD1\/904472\/904472-njmmZdjLNqFnFr5V.jpg","https:\/\/c8df8a41cf6851329c37-1626a054a54d8cef02a324905c73d1b4.ssl.cf5.rackcdn.com\/90\/72\/EELI_LSTHD1\/904472\/904472-ymW4qJrB5btZjDhz.jpg"]
[SaleOrRent] => S
[RentAmtAugLaborDay] => 0
[RentAmtJulyAug] => 0
[RentAmtJuly] => 0
[RentAmtJune] => 0
[RentAmtMemLaborDay] => 0
[RentAmtOffSeason] => 0
[RentAmtYearRoundMonthly] => 0
[RentAmtjun_jul] => 0
[RentAmtsht_term] => 0
[RentAmtwinter] => 0
[RentAmtSept] => 0
[RentAmtSeptOct] => 0
[RentAmtOct] => 0
[RentAmtNov] => 0
[RentAmtDec] => 0
[RentAmtWeekly] => 0
[RentAmtTwoWeeks] => 0
[RentAmtAugust] => 0
[RentAmtApril] => 0
[RentAmtMay] => 0
[RentAmtAprilMay] => 0
[RentAmtAprilLD] => 0
[RentAmtJulyAugustLD] => 0
[last_modified] => 2024-07-23T16:47:46
[date_added] => 2023-08-16 10:30:06
)
[7] => Array
(
[ID] => 195971
[post_status] => 1
[post_type] => listing
[post_title] => Sound, Riverhead
[post_content] => OPPORTUNITY ABOUNDS!
Step into the epitome of luxury and charm at Big E farm, a former thoroughbred horse-breeding ranch and home to Robert Entenmann. Perfectly situated on over 19 acres, this exceptional property is brimming with opportunity and potential revenue streams. Multiple outbuildings, full development rights, APZ zoning. Let your vision unfold…
[raw_info] => {"@odata.id":"https:\/\/api.mlsgrid.com\/v2\/Property('KEY418699594')","ListingKey":"KEY418699594","AttributionContact":"631-848-7730","BuildingAreaUnits":"Square Feet","City":"Riverhead","CountyOrParish":"Suffolk County","CumulativeDaysOnMarket":9,"KEY_CurrentPrice":"2500000.00","CurrentUse":["Agricultural"],"DaysOnMarket":9,"ElementarySchool":"Contact Agent","ExpirationDate":"2025-05-31","HighSchool":"Contact Agent","InternetAddressDisplayYN":true,"InternetAutomatedValuationDisplayYN":false,"InternetConsumerCommentYN":false,"InternetEntireListingDisplayYN":true,"ListAOR":"LIBOR","ListAgentAOR":"LIBOR","ListAgentDirectPhone":"631-848-7730","ListAgentEmail":"swp@corcoran.com","ListAgentFullName":"Sheri Winter Parker","ListAgentKey":"KEY326137839","ListAgentMlsId":"KEY122689","ListOfficeAOR":"LIBOR","ListOfficeKey":"KEY326112439","ListOfficeMlsId":"KEYJCHA02","ListOfficeName":"Corcoran","ListOfficePhone":"631-765-1300","ListPrice":2500000,"ListingAgreement":"Exclusive Right To Sell","ListingContractDate":"2025-02-10","ListingId":"KEY823059","LotSizeAcres":19.31,"LotSizeSquareFeet":841144,"MajorChangeTimestamp":"2025-02-10T22:37:56.000Z","MajorChangeType":"New Listing","MiddleOrJuniorSchool":"Contact Agent","KEY_MlsMajorChangeType":"New Listing","MlsStatus":"Active","OriginatingSystemModificationTimestamp":"2025-02-19T22:22:48.000Z","OriginalEntryTimestamp":"2025-02-10T22:37:56.000Z","OriginalListPrice":2500000,"OriginatingSystemName":"onekey2","OwnerName":"LLC","ParcelNumber":"0600-009-00-01-00-011-005","PhotosChangeTimestamp":"2025-02-19T22:24:36.981Z","PhotosCount":10,"PostalCity":"Riverhead","PostalCode":"11901","PropertyType":"Land","PublicRemarks":"OPPORTUNITY ABOUNDS!\nStep into the epitome of luxury and charm at Big E farm, a former thoroughbred horse-breeding ranch and home to Robert Entenmann. Perfectly situated on over 19 acres, this exceptional property is brimming with opportunity and potential revenue streams. Multiple outbuildings, full development rights, APZ zoning. Let your vision unfold\u2026","KEY_RATIO_ListPrice_By_LotSizeAcres":"129466.5976","KEY_RATIO_ListPrice_By_OriginalListPrice":"1.00000","HighSchoolDistrict":"Riverhead","SeniorCommunityYN":false,"Sewer":["None"],"ShowingContactPhone":"(631)848-7730","ShowingInstructions":"Text Sheri: 631.848.7730 By appointment only.","ShowingRequirements":["Appointment Only","See Remarks"],"KEY_SourceSystemModificationTimestamp":"2025-02-10T16:17:38.517","SourceSystemName":"KEY","SpecialListingConditions":["None"],"StandardStatus":"Active","StateOrProvince":"NY","StatusChangeTimestamp":"2025-02-10T22:37:56.000Z","StreetName":"Sound","StreetNumber":"6145","StreetNumberNumeric":6145,"StreetSuffix":"Avenue","SyndicateTo":["Realtor.com"],"TaxAnnualAmount":41397.96,"TaxAssessedValue":200000,"KEY_TaxSource":"Other","TaxYear":2025,"ModificationTimestamp":"2025-02-19T22:24:36.981Z","Media":[{"ResourceRecordKey":"418699594","Permission":["Public"],"LongDescription":"6145 Sound Avenue - 19+ acres - Aerial","ShortDescription":"Aerial View","Order":0,"ImageWidth":2048,"ImageHeight":1364,"ImageSizeDescription":"2048x1364","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY418699594\/86f9c8cf-5eba-47b7-9e68-2cc44851d4d2.jpeg","MediaModificationTimestamp":"2025-02-10T22:38:40.575Z","MediaKey":"67aa7ff01e924e220171540a"},{"ResourceRecordKey":"418699594","Permission":["Public"],"LongDescription":"6145 Sound Avenue - 19+ acres - Aerial","ShortDescription":"Aerial View","Order":1,"ImageWidth":2048,"ImageHeight":1364,"ImageSizeDescription":"2048x1364","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY418699594\/5035115d-7517-452d-8548-82f46d0a8a42.jpeg","MediaModificationTimestamp":"2025-02-10T22:38:40.580Z","MediaKey":"67aa7ff01e924e220171540b"},{"ResourceRecordKey":"418699594","Permission":["Public"],"LongDescription":"6145 Sound Avenue - 19+ acres - Aerial","ShortDescription":"Aerial View","Order":2,"ImageWidth":2048,"ImageHeight":1364,"ImageSizeDescription":"2048x1364","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY418699594\/c175b8ea-ac58-4b33-aaef-cd4eaf439351.jpeg","MediaModificationTimestamp":"2025-02-10T22:38:40.593Z","MediaKey":"67aa7ff01e924e220171540c"},{"ResourceRecordKey":"418699594","Permission":["Public"],"LongDescription":"6145 Sound Avenue - 19+ acres - Aerial","ShortDescription":"Aerial View","Order":3,"ImageWidth":2048,"ImageHeight":1365,"ImageSizeDescription":"2048x1365","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY418699594\/6baed0b1-9f25-4ac3-a6a7-2b456a4dbb41.jpeg","MediaModificationTimestamp":"2025-02-19T22:23:41.939Z","MediaKey":"67b659edcac71e3a8091cf76"},{"ResourceRecordKey":"418699594","Permission":["Public"],"LongDescription":"6145 Sound Avenue - 19+ acres - Aerial","ShortDescription":"Aerial View","Order":4,"ImageWidth":2048,"ImageHeight":1365,"ImageSizeDescription":"2048x1365","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY418699594\/5df6a1ce-e5fe-41fe-97cc-40c0c1ba935c.jpeg","MediaModificationTimestamp":"2025-02-19T22:23:41.899Z","MediaKey":"67b659edcac71e3a8091cf77"},{"ResourceRecordKey":"418699594","Permission":["Public"],"LongDescription":"6145 Sound Avenue - 19+ acres - Aerial","ShortDescription":"Aerial View","Order":5,"ImageWidth":2048,"ImageHeight":1365,"ImageSizeDescription":"2048x1365","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY418699594\/c1b7a970-ad2c-4374-b11f-b851a5963b27.jpeg","MediaModificationTimestamp":"2025-02-19T22:23:41.944Z","MediaKey":"67b659edcac71e3a8091cf78"},{"ResourceRecordKey":"418699594","Permission":["Public"],"LongDescription":"6145 Sound Avenue - 19+ acres - Aerial","ShortDescription":"Aerial View","Order":6,"ImageWidth":2048,"ImageHeight":1365,"ImageSizeDescription":"2048x1365","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY418699594\/a424fe62-fc04-494f-84d8-7b9f6143ab8b.jpeg","MediaModificationTimestamp":"2025-02-19T22:23:41.909Z","MediaKey":"67b659edcac71e3a8091cf79"},{"ResourceRecordKey":"418699594","Permission":["Public"],"LongDescription":"6145 Sound Avenue - 19+ acres - Aerial","ShortDescription":"Aerial View","Order":7,"ImageWidth":2048,"ImageHeight":1365,"ImageSizeDescription":"2048x1365","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY418699594\/e5084242-c21c-428b-a469-d27ca74806b9.jpeg","MediaModificationTimestamp":"2025-02-19T22:23:41.929Z","MediaKey":"67b659edcac71e3a8091cf7a"},{"ResourceRecordKey":"418699594","Permission":["Public"],"LongDescription":"6145 Sound Avenue - 19+ acres - Aerial","ShortDescription":"Aerial View","Order":8,"ImageWidth":2048,"ImageHeight":1365,"ImageSizeDescription":"2048x1365","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY418699594\/99f25c85-99e0-4cf6-9017-e1e63dd9a762.jpeg","MediaModificationTimestamp":"2025-02-19T22:23:41.978Z","MediaKey":"67b659edcac71e3a8091cf7b"},{"ResourceRecordKey":"418699594","Permission":["Public"],"LongDescription":"6145 Sound Avenue - 19+ acres - Aerial","ShortDescription":"Aerial View","Order":9,"ImageWidth":2048,"ImageHeight":1365,"ImageSizeDescription":"2048x1365","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY418699594\/3a2f3d21-7a13-47ff-8632-f8d90f4a0c05.jpeg","MediaModificationTimestamp":"2025-02-19T22:23:41.942Z","MediaKey":"67b659edcac71e3a8091cf7c"}],"MlgCanView":true,"MlgCanUse":["IDX"]}
[listing_info] => {"list_price":2500000,"sold_price":"","rental_price":2500000,"currency":"Dollar","hide_address":"","street_number":"6145","street_name":"Sound Avenue","city":"Riverhead","state":"NY","province":"","zip_code":"11901","country":"Riverhead","full_address":"6145 Sound Avenue, Riverhead, NY 11901","mls_number":"KEY823059","listing_broker":"","bedrooms":"","bathrooms":"","garage_spaces":"","year_built":"","building_size":"","lot_size":"","acres_size":"19.31","building_size_unit":"","lot_size_unit":"","virtual_tour":""}
[api_type] => 1
[api_class] => Land
[rets_prop_type] =>
[rets_prop_status] => Active
[out_prop_type] =>
[out_prop_status] =>
[api_prop_features] =>
[open_house] =>
[list_price] => 2500000
[rental_price] => 2500000
[sold_price] => 0
[state] => NY
[city] => Riverhead
[zip_code] => 11901
[mls_number] => KEY823059
[bedrooms] => 0
[house_size] => 0
[property_size] => 19.31
[bathrooms] => 0
[full_address] => 6145 Sound Avenue, Riverhead, NY 11901
[street_name] => 6145 Sound Avenue
[broker] => Corcoran
[listing_key] => KEY418699594
[listing_agent_key] => KEY326137839
[colisting_agent_key1] =>
[colisting_agent_key2] =>
[full_street_address] => 6145 Sound
[listing_images] => ["https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY418699594\/86f9c8cf-5eba-47b7-9e68-2cc44851d4d2.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY418699594\/5035115d-7517-452d-8548-82f46d0a8a42.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY418699594\/c175b8ea-ac58-4b33-aaef-cd4eaf439351.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY418699594\/6baed0b1-9f25-4ac3-a6a7-2b456a4dbb41.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY418699594\/5df6a1ce-e5fe-41fe-97cc-40c0c1ba935c.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY418699594\/c1b7a970-ad2c-4374-b11f-b851a5963b27.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY418699594\/a424fe62-fc04-494f-84d8-7b9f6143ab8b.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY418699594\/e5084242-c21c-428b-a469-d27ca74806b9.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY418699594\/99f25c85-99e0-4cf6-9017-e1e63dd9a762.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY418699594\/3a2f3d21-7a13-47ff-8632-f8d90f4a0c05.jpeg"]
[SaleOrRent] =>
[RentAmtAugLaborDay] => 0
[RentAmtJulyAug] => 0
[RentAmtJuly] => 0
[RentAmtJune] => 0
[RentAmtMemLaborDay] => 0
[RentAmtOffSeason] => 0
[RentAmtYearRoundMonthly] => 0
[RentAmtjun_jul] => 0
[RentAmtsht_term] => 0
[RentAmtwinter] => 0
[RentAmtSept] => 0
[RentAmtSeptOct] => 0
[RentAmtOct] => 0
[RentAmtNov] => 0
[RentAmtDec] => 0
[RentAmtWeekly] => 0
[RentAmtTwoWeeks] => 0
[RentAmtAugust] => 0
[RentAmtApril] => 0
[RentAmtMay] => 0
[RentAmtAprilMay] => 0
[RentAmtAprilLD] => 0
[RentAmtJulyAugustLD] => 0
[last_modified] => 2025-02-19T22:24:36.981Z
[date_added] => 2025-02-11 07:04:03
)
[8] => Array
(
[ID] => 194381
[post_status] => 1
[post_type] => listing
[post_title] => Main, Riverhead
[post_content] => Introducing an exceptional plot of land on Long Island's prestigious North Fork, perfect for building a luxurious private residence or a lucrative agricultural venture. This versatile property offers endless possibilities: create a generational farmstead, a sophisticated vineyard with a tasting room, or an equestrian compound. With a stunning pond, strategic roadside presence, and well-placed barns and woodshop, the land is both beautiful and functional. Zoned for Hamlet Residential and Rural Corridor, it supports various uses, from luxury homes to nurseries or farms. Maximize your investment by selling development rights to the county. The North Fork's reputation for vineyards, farms, and equestrian facilities ensures a thriving market and strong community support.
[raw_info] => {"@odata.id":"https:\/\/api.mlsgrid.com\/v2\/Property('KEY322513609')","ListingKey":"KEY322513609","KEY_AdditionalFees":"0.00","KEY_AdditionalFeesYN":"0","KEY_AdditionalParcelYN":"0","AssociationYN":false,"AttributionContact":"631-765-3800","BasementYN":false,"BathroomsHalf":0,"City":"Riverhead","KEY_ConcessionYN":"0","CountyOrParish":"Suffolk County","CrossStreet":"S. Jamesport Ave","CumulativeDaysOnMarket":180,"KEY_CurrentPrice":"2499000.00","DaysOnMarket":180,"ExpirationDate":"2025-03-20","KEY_Hamlet":"Jamesport","HighSchool":"Riverhead Senior High School","HorseYN":true,"InternetAddressDisplayYN":true,"InternetAutomatedValuationDisplayYN":true,"InternetConsumerCommentYN":true,"InternetEntireListingDisplayYN":true,"ListAOR":"LIBOR","ListAgentAOR":"LIBOR","ListAgentDirectPhone":"631-655-7999","ListAgentEmail":"jdivello@albertsonrealty.com","ListAgentFullName":"Joseph Divello","ListAgentKey":"KEY326184640","ListAgentMlsId":"KEY173649","ListOfficeAOR":"LIBOR","ListOfficeKey":"KEY326109252","ListOfficeMlsId":"KEYALBT01","ListOfficeName":"Century 21 Albertson Realty","ListOfficePhone":"631-765-3800","ListPrice":2499000,"ListingAgreement":"Exclusive Right To Sell","ListingContractDate":"2024-06-05","ListingId":"KEYL3557215","LotFeatures":["Level","Pasture","Part Wooded","Secluded","Views","Waterfront","Wooded"],"LotSizeAcres":21.98,"LotSizeArea":21.98,"LotSizeDimensions":"21.98","LotSizeSquareFeet":957448,"MajorChangeTimestamp":"2024-06-06T04:00:00.000Z","MajorChangeType":"Active","MiddleOrJuniorSchool":"Riverhead Middle School","KEY_MlsDistrictCode":"600","KEY_MlsMajorChangeType":"New Listing","MlsStatus":"Active","OriginatingSystemModificationTimestamp":"2024-12-03T02:07:23.000Z","KEY_NumOf1BedRooms":"0","KEY_NumOf2BedRooms":"0","KEY_NumOf3BedRooms":"0","KEY_NumOf4BedRooms":"0","OnMarketDate":"2024-06-05","KEY_OpenHouseCount":"0","KEY_OpenHousePublicCount":"0","OriginalEntryTimestamp":"2024-06-06T21:20:06.000Z","OriginalListPrice":2499000,"OriginatingSystemID":"LIBOR","OriginatingSystemKey":"KEY3557215","OriginatingSystemName":"onekey2","KEY_OriginatingSystemTimestamp":"2024-07-11T13:32:37.000","OtherStructures":["Barn(s)","Garage(s)","Outbuilding"],"OwnerName":"Nixon","ParcelNumber":"0600-068-00-01-00-029-002","PhotosChangeTimestamp":"2024-11-02T02:14:15.859Z","PhotosCount":9,"PoolPrivateYN":false,"PostalCity":"Jamesport","PostalCode":"11947","PropertySubType":"Unimproved Land","PropertyType":"Land","PublicRemarks":"Introducing an exceptional plot of land on Long Island's prestigious North Fork, perfect for building a luxurious private residence or a lucrative agricultural venture. This versatile property offers endless possibilities: create a generational farmstead, a sophisticated vineyard with a tasting room, or an equestrian compound. With a stunning pond, strategic roadside presence, and well-placed barns and woodshop, the land is both beautiful and functional. Zoned for Hamlet Residential and Rural Corridor, it supports various uses, from luxury homes to nurseries or farms. Maximize your investment by selling development rights to the county. The North Fork's reputation for vineyards, farms, and equestrian facilities ensures a thriving market and strong community support.","KEY_RATIO_ListPrice_By_LotSizeAcres":"113694.2675","KEY_RATIO_ListPrice_By_OriginalListPrice":"1.00000","KEY_RentSpreeYN":"0","HighSchoolDistrict":"Riverhead","KEY_SeasonalYN":"0","Sewer":["Other"],"ShowingContactPhone":"631-655-7999","SourceSystemID":"3557215","SourceSystemKey":"KEY3557215","SpaYN":false,"StandardStatus":"Active","StateOrProvince":"NY","StreetName":"Main","StreetNumber":"1408","StreetNumberNumeric":1408,"StreetSuffix":"Road","SyndicateTo":["Realtor.com"],"TaxAnnualAmount":7555.7,"TaxBlock":"100","TaxLot":"29.2","KEY_TaxSection":"68","View":["Other","Panoramic","Water"],"WaterfrontFeatures":["Lake Front","Pond"],"Zoning":"Other","ModificationTimestamp":"2024-12-03T02:09:42.620Z","Media":[{"ResourceRecordKey":"322513609","Permission":["Public"],"LongDescription":"The Perfect Estate Potential","Order":0,"ImageWidth":1900,"ImageHeight":1425,"ImageSizeDescription":"1900x1425","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY322513609\/58598bc1-5266-41ef-aefd-44bd052628f6.jpeg","MediaModificationTimestamp":"2024-10-22T07:14:59.586Z","MediaKey":"671750f3690ff217c4574b0c"},{"ResourceRecordKey":"322513609","Permission":["Public"],"LongDescription":"Aerial Outlined","Order":1,"ImageWidth":1900,"ImageHeight":1425,"ImageSizeDescription":"1900x1425","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY322513609\/cb75a71c-f7de-492a-a0dc-df3a4f6e3f84.jpeg","MediaModificationTimestamp":"2024-10-22T07:14:59.523Z","MediaKey":"671750f3690ff217c4574b0e"},{"ResourceRecordKey":"322513609","Permission":["Public"],"LongDescription":"Farmstand Or Tasting Room","Order":2,"ImageWidth":1900,"ImageHeight":1425,"ImageSizeDescription":"1900x1425","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY322513609\/a1583e55-2cd1-4058-8226-83c8712343d9.jpeg","MediaModificationTimestamp":"2024-10-22T07:14:59.520Z","MediaKey":"671750f3690ff217c4574b0f"},{"ResourceRecordKey":"322513609","Permission":["Public"],"LongDescription":"Wood Working Shop and Barn","Order":3,"ImageWidth":1900,"ImageHeight":1266,"ImageSizeDescription":"1900x1266","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY322513609\/700d4abb-ccff-4264-b1fc-87d7a63e9863.jpeg","MediaModificationTimestamp":"2024-10-22T07:14:59.495Z","MediaKey":"671750f3690ff217c4574b10"},{"ResourceRecordKey":"322513609","Permission":["Public"],"LongDescription":"Perfect Tasting Room","Order":4,"ImageWidth":1900,"ImageHeight":1266,"ImageSizeDescription":"1900x1266","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY322513609\/a5270fbc-bf11-4673-bd7d-d134a2b94ef7.jpeg","MediaModificationTimestamp":"2024-10-22T07:14:59.488Z","MediaKey":"671750f3690ff217c4574b11"},{"ResourceRecordKey":"322513609","Permission":["Public"],"LongDescription":"Zoning","Order":5,"ImageWidth":1900,"ImageHeight":1425,"ImageSizeDescription":"1900x1425","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY322513609\/c025f5ed-32ea-4d17-8e15-bcf7a63da744.jpeg","MediaModificationTimestamp":"2024-10-22T07:14:59.529Z","MediaKey":"671750f3690ff217c4574b12"},{"ResourceRecordKey":"322513609","Permission":["Public"],"LongDescription":"The Pond","Order":6,"ImageWidth":1900,"ImageHeight":1078,"ImageSizeDescription":"1900x1078","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY322513609\/ce27e998-c443-494c-a9db-0e537b7db686.jpeg","MediaModificationTimestamp":"2024-10-22T07:14:59.491Z","MediaKey":"671750f3690ff217c4574b13"},{"ResourceRecordKey":"322513609","Permission":["Public"],"LongDescription":"Close to the Beach","Order":7,"ImageWidth":1900,"ImageHeight":1425,"ImageSizeDescription":"1900x1425","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY322513609\/e410b36a-fe72-4d0b-9461-380f3a9b1254.jpeg","MediaModificationTimestamp":"2024-10-22T07:14:59.493Z","MediaKey":"671750f3690ff217c4574b14"},{"ResourceRecordKey":"322513609","Permission":["Public"],"LongDescription":"The Pond","Order":8,"ImageWidth":1900,"ImageHeight":1425,"ImageSizeDescription":"1900x1425","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY322513609\/e0165ab6-9ab0-4336-9710-111e402731a6.jpeg","MediaModificationTimestamp":"2024-10-22T07:14:59.532Z","MediaKey":"671750f3690ff217c4574b15"}],"MlgCanView":true,"MlgCanUse":["IDX"]}
[listing_info] => {"list_price":2499000,"sold_price":"","rental_price":2499000,"currency":"Dollar","hide_address":"","street_number":"1408","street_name":"Main Road","city":"Riverhead","state":"NY","province":"","zip_code":"11947","country":"Jamesport","full_address":"1408 Main Road, Riverhead, NY 11947","mls_number":"KEYL3557215","listing_broker":"","bedrooms":"","bathrooms":"","garage_spaces":"","year_built":"","building_size":"","lot_size":21.98,"acres_size":"21.98","building_size_unit":"","lot_size_unit":"","virtual_tour":""}
[api_type] => 1
[api_class] => Land
[rets_prop_type] => Unimproved Land
[rets_prop_status] => Active
[out_prop_type] =>
[out_prop_status] =>
[api_prop_features] =>
[open_house] =>
[list_price] => 2499000
[rental_price] => 2499000
[sold_price] => 0
[state] => NY
[city] => Riverhead
[zip_code] => 11947
[mls_number] => KEYL3557215
[bedrooms] => 0
[house_size] => 0
[property_size] => 21.98
[bathrooms] => 0
[full_address] => 1408 Main Road, Riverhead, NY 11947
[street_name] => 1408 Main Road
[broker] => Century 21 Albertson Realty
[listing_key] => KEY322513609
[listing_agent_key] => KEY326184640
[colisting_agent_key1] =>
[colisting_agent_key2] =>
[full_street_address] => 1408 Main
[listing_images] => ["https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY322513609\/58598bc1-5266-41ef-aefd-44bd052628f6.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY322513609\/cb75a71c-f7de-492a-a0dc-df3a4f6e3f84.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY322513609\/a1583e55-2cd1-4058-8226-83c8712343d9.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY322513609\/700d4abb-ccff-4264-b1fc-87d7a63e9863.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY322513609\/a5270fbc-bf11-4673-bd7d-d134a2b94ef7.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY322513609\/c025f5ed-32ea-4d17-8e15-bcf7a63da744.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY322513609\/ce27e998-c443-494c-a9db-0e537b7db686.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY322513609\/e410b36a-fe72-4d0b-9461-380f3a9b1254.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY322513609\/e0165ab6-9ab0-4336-9710-111e402731a6.jpeg"]
[SaleOrRent] =>
[RentAmtAugLaborDay] => 0
[RentAmtJulyAug] => 0
[RentAmtJuly] => 0
[RentAmtJune] => 0
[RentAmtMemLaborDay] => 0
[RentAmtOffSeason] => 0
[RentAmtYearRoundMonthly] => 0
[RentAmtjun_jul] => 0
[RentAmtsht_term] => 0
[RentAmtwinter] => 0
[RentAmtSept] => 0
[RentAmtSeptOct] => 0
[RentAmtOct] => 0
[RentAmtNov] => 0
[RentAmtDec] => 0
[RentAmtWeekly] => 0
[RentAmtTwoWeeks] => 0
[RentAmtAugust] => 0
[RentAmtApril] => 0
[RentAmtMay] => 0
[RentAmtAprilMay] => 0
[RentAmtAprilLD] => 0
[RentAmtJulyAugustLD] => 0
[last_modified] => 2024-12-03T02:09:42.620Z
[date_added] => 2025-02-07 06:53:42
)
[9] => Array
(
[ID] => 194938
[post_status] => 1
[post_type] => listing
[post_title] => Main Road, Riverhead
[post_content] => Formerly known as The Kubby Farm. This is a great opportunity to have multiple revenue streams or live/work. Over 24 acres with rural corridor use and Rb-80 zoning. There are multiple buildings on the property in need of TLC, including retail and a 1700's Farmhouse. Surrounded by development rights sold land yet close proximity to many amenities! Some uses include agricultural production, single family dwelling units with a cluster attached subdivision, schools, single & 2 family homes, and multiple special permit uses including bistros and B&B. This is an opportunity not to be missed!
[raw_info] => {"@odata.id":"https:\/\/api.mlsgrid.com\/v2\/Property('KEY417939685')","ListingKey":"KEY417939685","KEY_AdditionalFees":"0.00","KEY_AdditionalFeesYN":"0","KEY_AdditionalParcelYN":"0","AssociationYN":false,"AttributionContact":"631-848-7730","BathroomsHalf":0,"City":"Riverhead","KEY_ConcessionYN":"0","CountyOrParish":"Suffolk County","CrossStreet":"Tuthills Ln","CumulativeDaysOnMarket":1365,"KEY_CurrentPrice":"2400000.00","DaysOnMarket":31,"Directions":"Rt 25 going east - lot is on right","ExpirationDate":"2025-02-28","HighSchool":"Riverhead Senior High School","InternetAddressDisplayYN":true,"InternetAutomatedValuationDisplayYN":false,"InternetConsumerCommentYN":false,"InternetEntireListingDisplayYN":true,"ListAOR":"LIBOR","ListAgentAOR":"LIBOR","ListAgentDirectPhone":"631-848-7730","ListAgentEmail":"swp@corcoran.com","ListAgentFullName":"Sheri Winter Parker","ListAgentKey":"KEY326137839","ListAgentMlsId":"KEY122689","ListOfficeKey":"KEY326112439","ListOfficeMlsId":"KEYJCHA02","ListOfficeName":"Corcoran","ListOfficePhone":"631-765-1300","ListPrice":2400000,"ListingAgreement":"Exclusive Right To Sell","ListingContractDate":"2024-11-22","ListingId":"KEYL3592725","LotFeatures":["Cleared","Part Wooded","Views"],"LotSizeAcres":24.1,"LotSizeArea":24.1,"LotSizeDimensions":"24.1","LotSizeSquareFeet":1049796,"MajorChangeTimestamp":"2024-11-22T18:53:22.000Z","MiddleOrJuniorSchool":"Riverhead Middle School","KEY_MlsDistrictCode":"600","KEY_MlsMajorChangeType":"New Listing","MlsStatus":"Active","OriginatingSystemModificationTimestamp":"2024-12-23T21:24:49.000Z","KEY_NumOf1BedRooms":"0","KEY_NumOf2BedRooms":"0","KEY_NumOf3BedRooms":"0","KEY_NumOf4BedRooms":"0","OnMarketDate":"2024-11-22","OriginalEntryTimestamp":"2024-11-22T17:49:27.000Z","OriginalListPrice":2400000,"OriginatingSystemID":"LIBOR","OriginatingSystemKey":"KEY3592725","OriginatingSystemName":"onekey2","KEY_OriginatingSystemTimestamp":"2024-11-22T13:38:00.000","OtherStructures":["Barn(s)","Outbuilding","Shed(s)"],"OwnerName":"N&L Properties LP","ParcelNumber":"0600-068-00-03-00-002-000","PhotosChangeTimestamp":"2024-11-22T19:15:36.705Z","PhotosCount":14,"PoolPrivateYN":false,"PostalCity":"Riverhead","PostalCode":"11901","PropertySubType":"Unimproved Land","PropertyType":"Land","PublicRemarks":"Formerly known as The Kubby Farm. This is a great opportunity to have multiple revenue streams or live\/work. Over 24 acres with rural corridor use and Rb-80 zoning. There are multiple buildings on the property in need of TLC, including retail and a 1700's Farmhouse. Surrounded by development rights sold land yet close proximity to many amenities! Some uses include agricultural production, single family dwelling units with a cluster attached subdivision, schools, single & 2 family homes, and multiple special permit uses including bistros and B&B. This is an opportunity not to be missed!","KEY_RATIO_ListPrice_By_LotSizeAcres":"99585.0622","KEY_RATIO_ListPrice_By_OriginalListPrice":"1.00000","KEY_RentSpreeYN":"0","HighSchoolDistrict":"Riverhead","KEY_SeasonalYN":"0","Sewer":["Other"],"ShowingContactPhone":"631-848-7730","SourceSystemID":"3592725","SourceSystemKey":"KEY3592725","SpaYN":false,"StandardStatus":"Active","StateOrProvince":"NY","StreetName":"Main Road","StreetNumber":"1117","SyndicateTo":["Realtor.com"],"TaxAnnualAmount":31938.53,"TaxBlock":"3","TaxLot":"2","KEY_TaxSection":"68","VirtualTourURLUnbranded":"https:\/\/www.dropbox.com\/scl\/fi\/jugt8sx70m45515j5pow2\/1117-Main-Rd.-Riverhead-MLS.mp4?rlkey=lv3ruvk0efhxcbwvr5lfx4bhi&dl=0","Zoning":"Other","ModificationTimestamp":"2024-12-23T21:26:36.377Z","Media":[{"ResourceRecordKey":"417939685","Permission":["Public"],"LongDescription":"1117 Main Road","Order":0,"ImageWidth":1900,"ImageHeight":1266,"ImageSizeDescription":"1900x1266","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY417939685\/c9bcf16e-f5e7-4278-a6dd-2fa9ea5453b2.jpeg","MediaModificationTimestamp":"2024-11-22T19:14:38.105Z","MediaKey":"6740d81e3548682f4579cbab"},{"ResourceRecordKey":"417939685","Permission":["Public"],"LongDescription":"1117 Main Road - Back of Property","Order":1,"ImageWidth":1900,"ImageHeight":1266,"ImageSizeDescription":"1900x1266","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY417939685\/be8a77aa-e656-485e-ac7d-66cd581d80c2.jpeg","MediaModificationTimestamp":"2024-11-22T19:14:38.064Z","MediaKey":"6740d81e3548682f4579cbad"},{"ResourceRecordKey":"417939685","Permission":["Public"],"LongDescription":"1117 Main Road","Order":2,"ImageWidth":1900,"ImageHeight":1266,"ImageSizeDescription":"1900x1266","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY417939685\/d2b9ed4d-7b24-4f68-a28b-7047d25a2859.jpeg","MediaModificationTimestamp":"2024-11-22T19:14:37.994Z","MediaKey":"6740d81e3548682f4579cbae"},{"ResourceRecordKey":"417939685","Permission":["Public"],"LongDescription":"1117 Main Road","Order":3,"ImageWidth":1900,"ImageHeight":1266,"ImageSizeDescription":"1900x1266","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY417939685\/42b7d569-a908-48d7-a6c2-d622a542ad1e.jpeg","MediaModificationTimestamp":"2024-11-22T19:14:38.037Z","MediaKey":"6740d81e3548682f4579cbaf"},{"ResourceRecordKey":"417939685","Permission":["Public"],"LongDescription":"1117 Main Road","Order":4,"ImageWidth":1900,"ImageHeight":1266,"ImageSizeDescription":"1900x1266","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY417939685\/cfe367f3-00ab-4e1e-9726-53afb3505715.jpeg","MediaModificationTimestamp":"2024-11-22T19:14:38.130Z","MediaKey":"6740d81e3548682f4579cbb0"},{"ResourceRecordKey":"417939685","Permission":["Public"],"LongDescription":"1117 Main Road","Order":5,"ImageWidth":1900,"ImageHeight":1266,"ImageSizeDescription":"1900x1266","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY417939685\/72989f95-003f-41a8-b13c-236ed1a535a8.jpeg","MediaModificationTimestamp":"2024-11-22T19:14:38.164Z","MediaKey":"6740d81e3548682f4579cbb1"},{"ResourceRecordKey":"417939685","Permission":["Public"],"LongDescription":"1117 Main Road","Order":6,"ImageWidth":1900,"ImageHeight":1266,"ImageSizeDescription":"1900x1266","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY417939685\/2e501e9f-3e39-4e5b-bda6-0738aeeed916.jpeg","MediaModificationTimestamp":"2024-11-22T19:14:37.965Z","MediaKey":"6740d81e3548682f4579cbb2"},{"ResourceRecordKey":"417939685","Permission":["Public"],"LongDescription":"1117 Main Road","Order":7,"ImageWidth":1900,"ImageHeight":1266,"ImageSizeDescription":"1900x1266","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY417939685\/a7bb355a-709f-424d-8e5b-be0d8d544576.jpeg","MediaModificationTimestamp":"2024-11-22T19:14:37.962Z","MediaKey":"6740d81e3548682f4579cbb3"},{"ResourceRecordKey":"417939685","Permission":["Public"],"LongDescription":"1117 Main Road","Order":8,"ImageWidth":1900,"ImageHeight":1266,"ImageSizeDescription":"1900x1266","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY417939685\/3220eb45-0843-4412-949f-d889043fef36.jpeg","MediaModificationTimestamp":"2024-11-22T19:14:37.966Z","MediaKey":"6740d81e3548682f4579cbb4"},{"ResourceRecordKey":"417939685","Permission":["Public"],"LongDescription":"1117 Main Road","Order":9,"ImageWidth":1900,"ImageHeight":1266,"ImageSizeDescription":"1900x1266","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY417939685\/1775aced-cefd-4e41-a694-fc7f1f209129.jpeg","MediaModificationTimestamp":"2024-11-22T19:14:37.961Z","MediaKey":"6740d81e3548682f4579cbb5"},{"ResourceRecordKey":"417939685","Permission":["Public"],"LongDescription":"1117 Main Road","Order":10,"ImageWidth":1900,"ImageHeight":1266,"ImageSizeDescription":"1900x1266","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY417939685\/07d4401c-fb1c-4948-84f7-f1f366d37a92.jpeg","MediaModificationTimestamp":"2024-11-22T19:14:38.084Z","MediaKey":"6740d81e3548682f4579cbb6"},{"ResourceRecordKey":"417939685","Permission":["Public"],"LongDescription":"1117 Main Road","Order":11,"ImageWidth":1900,"ImageHeight":1266,"ImageSizeDescription":"1900x1266","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY417939685\/adb59dbf-9d8e-48ec-9949-ec9c3c416eb0.jpeg","MediaModificationTimestamp":"2024-11-22T19:14:38.002Z","MediaKey":"6740d81e3548682f4579cbb7"},{"ResourceRecordKey":"417939685","Permission":["Public"],"LongDescription":"1117 Main Road","Order":12,"ImageWidth":1900,"ImageHeight":1266,"ImageSizeDescription":"1900x1266","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY417939685\/dbfd060f-6fca-412f-9995-1fb43f50231f.jpeg","MediaModificationTimestamp":"2024-11-22T19:14:37.999Z","MediaKey":"6740d81e3548682f4579cbb8"},{"ResourceRecordKey":"417939685","Permission":["Public"],"LongDescription":"1117 Main Road","Order":13,"ImageWidth":1900,"ImageHeight":1266,"ImageSizeDescription":"1900x1266","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY417939685\/23c72463-cca3-4daa-b8c0-51d643a6baef.jpeg","MediaModificationTimestamp":"2024-11-22T19:14:38.068Z","MediaKey":"6740d81e3548682f4579cbb9"}],"MlgCanView":true,"MlgCanUse":["IDX"]}
[listing_info] => {"list_price":2400000,"sold_price":"","rental_price":2400000,"currency":"Dollar","hide_address":"","street_number":"1117","street_name":"Main Road ","city":"Riverhead","state":"NY","province":"","zip_code":"11901","country":"Riverhead","full_address":"1117 Main Road , Riverhead, NY 11901","mls_number":"KEYL3592725","listing_broker":"","bedrooms":"","bathrooms":"","garage_spaces":"","year_built":"","building_size":"","lot_size":24.1,"acres_size":"24.1","building_size_unit":"","lot_size_unit":"","virtual_tour":""}
[api_type] => 1
[api_class] => Land
[rets_prop_type] => Unimproved Land
[rets_prop_status] => Active
[out_prop_type] =>
[out_prop_status] =>
[api_prop_features] =>
[open_house] =>
[list_price] => 2400000
[rental_price] => 2400000
[sold_price] => 0
[state] => NY
[city] => Riverhead
[zip_code] => 11901
[mls_number] => KEYL3592725
[bedrooms] => 0
[house_size] => 0
[property_size] => 24.1
[bathrooms] => 0
[full_address] => 1117 Main Road , Riverhead, NY 11901
[street_name] => 1117 Main Road
[broker] => Corcoran
[listing_key] => KEY417939685
[listing_agent_key] => KEY326137839
[colisting_agent_key1] =>
[colisting_agent_key2] =>
[full_street_address] => 1117 Main Road
[listing_images] => ["https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY417939685\/c9bcf16e-f5e7-4278-a6dd-2fa9ea5453b2.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY417939685\/be8a77aa-e656-485e-ac7d-66cd581d80c2.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY417939685\/d2b9ed4d-7b24-4f68-a28b-7047d25a2859.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY417939685\/42b7d569-a908-48d7-a6c2-d622a542ad1e.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY417939685\/cfe367f3-00ab-4e1e-9726-53afb3505715.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY417939685\/72989f95-003f-41a8-b13c-236ed1a535a8.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY417939685\/2e501e9f-3e39-4e5b-bda6-0738aeeed916.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY417939685\/a7bb355a-709f-424d-8e5b-be0d8d544576.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY417939685\/3220eb45-0843-4412-949f-d889043fef36.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY417939685\/1775aced-cefd-4e41-a694-fc7f1f209129.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY417939685\/07d4401c-fb1c-4948-84f7-f1f366d37a92.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY417939685\/adb59dbf-9d8e-48ec-9949-ec9c3c416eb0.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY417939685\/dbfd060f-6fca-412f-9995-1fb43f50231f.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY417939685\/23c72463-cca3-4daa-b8c0-51d643a6baef.jpeg"]
[SaleOrRent] =>
[RentAmtAugLaborDay] => 0
[RentAmtJulyAug] => 0
[RentAmtJuly] => 0
[RentAmtJune] => 0
[RentAmtMemLaborDay] => 0
[RentAmtOffSeason] => 0
[RentAmtYearRoundMonthly] => 0
[RentAmtjun_jul] => 0
[RentAmtsht_term] => 0
[RentAmtwinter] => 0
[RentAmtSept] => 0
[RentAmtSeptOct] => 0
[RentAmtOct] => 0
[RentAmtNov] => 0
[RentAmtDec] => 0
[RentAmtWeekly] => 0
[RentAmtTwoWeeks] => 0
[RentAmtAugust] => 0
[RentAmtApril] => 0
[RentAmtMay] => 0
[RentAmtAprilMay] => 0
[RentAmtAprilLD] => 0
[RentAmtJulyAugustLD] => 0
[last_modified] => 2024-12-23T21:26:36.377Z
[date_added] => 2025-02-07 06:55:58
)
[10] => Array
(
[ID] => 180643
[post_status] => 1
[post_type] => listing
[post_title] => LA FORET LA, East Hampton
[post_content] => Amagansett Bell Estate Land opportunity. This 2.05 acre high flat site is the opportunity for your dream home.
[raw_info] => {"AboveArea":"0","MemberId":"526308","CoListMemberId":"0","CoListMemberId2":"0","Address":"45 LA FORET LA","PublicRemarks":"Amagansett Bell Estate Land opportunity. This 2.05 acre high flat site is the opportunity for your dream home.","ApDishwasher":"","ApDisposal":"","ApDryer":"","ApFridge":"","ApHotWaterHeater":"","ApMicrowave":"","ApOven":"","ApStainlessSteel":"","ApWasher":"","ApartmentType":"0","AtticAccess":"0","AtticType":"0","AuctionEndDatetime":"","AuctionStartDatetime":"","AuctionUrl":"","AvailDate":"","BasementType":"0","Beds":"0","Bld55over":"","BldBasement":"","BldBike":"","BldClubhouse":"","BldConcierge":"","BldDoorman":"","BldElevator":"","BldGated":"","BldGolf":"","BldGym":"","BldLaundry":"","BldParking":"","BldPets":"","BldPlayground":"","BldPool":"","BldPostWar":"","BldPreWar":"","BldRecRoom":"","BldRooftop":"","BldSauna":"","BldScreening":"","BldSecurity":"","BldSmoking":"","BldStorage":"","BldTennisCourt":"","BmArea":"","BmBaths":"","BmBeds":"","BmBilco":"","BmFinished":"","BmGarage":"","BmKitchen":"","BmNoAccess":"","BmPartlyFinished":"","BmUnfinished":"","BmWalkout":"","BuildingStyle":"0","BuyerAgentCompany":"","BuyerMemberId":"0","BuyerAgentName":"","BuyerOfficeId":"0","CentralAc":"0","City":"East Hampton","CommercialType":"0","CommissionComments":"","ComplexName":"","ConstructionType":"0","Contractdate":"","County":"36103","CurrentStatusTime":"","Directions":"","ExAttachedPark":"0","ExCorner":"0","ExCoveredPorch":"0","ExCulDeSac":"0","ExDeck":"0","ExDriveway":"0","ExEnclosedPorch":"0","ExEquestrian":"0","ExExteriorMaterial":"","ExFence":"0","ExGolf":"0","ExOpenPorch":"0","ExOutdoorShower":"0","ExPatio":"0","ExPermit":"0","ExRoomForGarage":"0","ExRoomForPool":"0","ExRoomForTennis":"0","ExScreenPorch":"0","ExSprinklerSystem":"0","ExSubdivision":"","ExSurvey":"0","ExTennis":"0","ExTennisCourtSurface":"","ExTrees":"0","ExUtilities":"0","Expiredate":"","Fireplaces":"0","FlCarpet":"","FlGranite":"","FlHardwood":"","FlLaminate":"","FlLinoleum":"","FlMarble":"","FlStone":"","FlTile":"","FlVinyl":"","FloorNum":"","FullBaths":"0","Furnished":"0","GarageSpaces":"0","GarageType":"0","H2oAccess":"0","H2oBay":"0","H2oBeachRights":"0","H2oCanal":"0","H2oCreek":"0","H2oDeepWaterDock":"0","H2oDock":"0","H2oDockDepth":"","H2oDockRights":"0","H2oFrontage":"","H2oHarbor":"0","H2oInlet":"0","H2oKill":"0","H2oLake":"0","H2oOcean":"0","H2oPond":"0","H2oRiver":"0","H2oSound":"0","H2oStream":"0","H2oWaterName":"","HalfBaths":"0","HamletId":"107","Handicap":"0","HasPool":"0","HfCoal":"","HfElectric":"","HfGas":"","HfKerosene":"","HfNaturalGas":"","HfOil":"","HfPropane":"","HfSolar":"","HfWood":"","HiddenDraft":"0","Hoa":"0","HoaDevelopment":"","HoaFee":"","HoaName":"","HoaPhone":"","HowSold":"Unknown","HtBaseboard":"","HtForcedAir":"","HtGeoThermal":"","HtHeatAcZones":"","HtHotWater":"","HtHydroAir":"","HtNoHeat":"","HtOther":"","HtPump":"","HtRadiant":"","HtSteam":"","InAlarm":"","InAmps":"","InSprinklers":"","InStaffBaths":"","InStaffBeds":"","IsAbsoluteAuction":"","IsCompanyPrivate":"1","IsLandLease":"0","IsOnlineOnlyAuction":"","IsSeasonal":"0","IsWaterView":"0","IsWaterfront":"0","KitchenCounter":"0","KitchenType":"0","LandFrontage":"0","LandLeaseFee":"0","LastPriceTime":"","LastPriceValue":"0","LastStatusTime":"","LastStatusValue":"0","Latitude":"40.992474","Listdate":"2022-04-18T04:00:00","ListingType":"Open","ListingUrl":"","Created":"2022-04-18T16:51:24","ListingId":"889203","Modified":"2022-04-19T15:56:39","Longitude":"-72.141168","LotSize":"2.05","LotSqft":"0","MarketHeadline":"Bell Estate Building Parcel","MaxTerm":"","MinTerm":"","MlsName":"EastEndLI","MotAuction":"0","MotBank":"0","MotEstate":"0","MotForeclosure":"0","MotPreforeclosure":"0","MotShortsale":"0","NaturalGas":"0","NearBus":"0","NearSchool":"0","NearTrain":"0","Neighborhood":"","NewConstruction":"0","NoFee":"0","NumLots":"0","NumPhotos":"2","NumRooms":"0","NumUnits":"0","Occupancy":"0","Offerdate":"","OfficeId":"120085","OhBarn":"0","OhCabana":"0","OhCarport":"0","OhGeneral":"0","OhGreenhouse":"0","OhGuestHouse":"0","OhGym":"0","OhOffice":"0","OhPoolHouse":"0","OhRidingRing":"0","OhShed":"0","OhStable":"0","OhStudio":"0","OhWorkshop":"0","Parcel":"0300-126.000-0001-014.031","PctTaxDeduct":"0","PhotosTimestamp":"2022-04-19T15:56:02","PoolAboveGround":"0","PoolChildProof":"0","PoolGunite":"0","PoolHeated":"0","PoolInGround":"0","PoolIndoor":"0","PoolInfinity":"0","PoolSaltWater":"0","PoolSauna":"0","PoolSize":"","PoolSolar":"0","PoolSpa":"0","PoolVinyl":"0","Price":"2200000","PriceOriginal":"2200000","PriceSale":"0","PrivateRemarks":"","PropertyClass":"311","PropertyType":"Vacant Land","RenovationComments":"","RenovationYear":"0","RentInternet":"","RentLandlordShow":"","RentLinens":"","RentMaxPeople":"","RentPetNotes":"","RentPets":"","RentRegExpireDate":"","RentRegNum":"","RentSmoking":"","RentTv":"","Rentdate":"","ResidentialStyle":"0","RetsBrokerWeb":"1","RetsHamptonsRe":"0","RetsIdx":"0","RfAsphalt":"0","RfCedar":"0","RfFlat":"0","RfMetal":"0","RfRubber":"0","RfSlate":"0","RfTar":"0","RfTile":"0","RmArtStudio":"","RmBonus":"","RmBreakfast":"","RmDen":"","RmDining":"","RmEnSuite":"","RmFamily":"","RmFirstFloorBath":"","RmFirstFloorMaster":"","RmFormal":"","RmFoyer":"","RmGreat":"","RmGym":"","RmKitchen":"","RmLaundry":"","RmLibrary":"","RmLiving":"","RmLoft":"","RmMasterBedroom":"","RmMedia":"","RmPrivateGuest":"","RmStudy":"","RmWalkInCloset":"","SaleRent":"S","Saledate":"","SchoolDistrict":"000000","SdAluminum":"0","SdAsbestos":"0","SdBrick":"0","SdCedarClapboard":"0","SdCedarShake":"0","SdCement":"0","SdHardi":"0","SdLog":"0","SdMasonry":"0","SdStone":"0","SdStucco":"0","SdT111":"0","SdVinyl":"0","SdWood":"0","SectionId":"0","SewerType":"0","ShowPrice":"1","Soh":"0","SourceMlsid":"","SourceMlsid2":"","SourceName":"PRO","StPellet":"","StPropane":"","StWood":"","State":"NY","Status":"Active","Stories":"0","StreetName":"LA FORET LA","StreetNum":"45","TaxTotal":"2433","TaxYear":"0","Tempoffmktdate":"","TotalCommission":"","Township":"East Hampton","UfBalcony":"","UfCentralVac":"","UfCorner":"","UfFireEscape":"","UfGarden":"","UfGroundFloor":"","UfIntercom":"","UfLaundry":"","UfTerrace":"","UfUpperFloor":"","UndisclosedAddress":"0","UnitNum":"","VirtualTour":"","VwBay":"0","VwCanal":"0","VwCity":"0","VwCreek":"0","VwFarm":"0","VwHarbor":"0","VwInlet":"0","VwLake":"0","VwMountain":"0","VwOcean":"0","VwPark":"0","VwPond":"0","VwPrivate":"0","VwRiver":"0","VwScenic":"0","VwSound":"0","VwStream":"0","VwStreet":"0","VwWater":"0","VwWooded":"0","WallwinAc":"0","WaterType":"0","WebId":"","Withdrawdate":"","YearBuilt":"0","YoutubeVideoId":"","Zip":"11930","Zone":"0"}
[listing_info] => {"list_price":"2200000","sold_price":"","rental_price":"2200000","currency":"Dollar","hide_address":"","street_number":"45","street_name":"LA FORET LA","city":"East Hampton","state":"NY","province":"NY","zip_code":"11930","country":"","full_address":"45 LA FORET LA, East Hampton, NY 11930","mls_number":"889203","listing_broker":"","bedrooms":"0","bathrooms":0,"garage_spaces":"0","year_built":"0","building_size":null,"lot_size":"0","acres_size":"2.05","building_size_unit":"","lot_size_unit":"","virtual_tour":""}
[api_type] => 2
[api_class] => ForSale
[rets_prop_type] =>
[rets_prop_status] =>
[out_prop_type] => land
[out_prop_status] => for-sale
[api_prop_features] => []
[open_house] =>
[list_price] => 2200000
[rental_price] => 2200000
[sold_price] => 0
[state] => NY
[city] => East Hampton
[zip_code] => 11930
[mls_number] =>
[bedrooms] => 0
[house_size] => 0
[property_size] => 2.05
[bathrooms] => 0
[full_address] => 45 LA FORET LA, East Hampton, NY 11930
[street_name] => 45 LA FORET LA
[broker] =>
[listing_key] => 889203
[listing_agent_key] => 526308
[colisting_agent_key1] =>
[colisting_agent_key2] =>
[full_street_address] => 45 LA FORET LA
[listing_images] => ["https:\/\/c8df8a41cf6851329c37-1626a054a54d8cef02a324905c73d1b4.ssl.cf5.rackcdn.com\/88\/03\/EELI_LSTHD1\/889203\/889203-4GBBgZlRBFBNQvH4.jpg","https:\/\/c8df8a41cf6851329c37-1626a054a54d8cef02a324905c73d1b4.ssl.cf5.rackcdn.com\/88\/03\/EELI_LSTHD1\/889203\/889203-GJ8YsZ9hlFp1gVtX.jpg"]
[SaleOrRent] => S
[RentAmtAugLaborDay] => 0
[RentAmtJulyAug] => 0
[RentAmtJuly] => 0
[RentAmtJune] => 0
[RentAmtMemLaborDay] => 0
[RentAmtOffSeason] => 0
[RentAmtYearRoundMonthly] => 0
[RentAmtjun_jul] => 0
[RentAmtsht_term] => 0
[RentAmtwinter] => 0
[RentAmtSept] => 0
[RentAmtSeptOct] => 0
[RentAmtOct] => 0
[RentAmtNov] => 0
[RentAmtDec] => 0
[RentAmtWeekly] => 0
[RentAmtTwoWeeks] => 0
[RentAmtAugust] => 0
[RentAmtApril] => 0
[RentAmtMay] => 0
[RentAmtAprilMay] => 0
[RentAmtAprilLD] => 0
[RentAmtJulyAugustLD] => 0
[last_modified] => 2022-04-19T15:56:39
[date_added] => 2022-04-19 14:00:06
)
[11] => Array
(
[ID] => 195764
[post_status] => 1
[post_type] => listing
[post_title] => Cedar, Southampton
[post_content] => Southampton South of The Highway Compound Opportunity
This unique building opportunity in Southampton contains four pre-existing structures on 1.12 acres, zoned R-15, South of The Highway, offering the ability to create a compound just steps away from the Shinnecock Bay and a short drive to the ocean and the Village. The site borders a scenic easement, allowing for privacy. Structures can be renovated or replaced with your desired project. Ask to see plans by BMA Architects Bridgehampton/Miami, for a 9,000 sf house/gym/garage or 7,000sf house/gym/garage. Room for pool and/or tennis/pickleball.
[raw_info] => {"@odata.id":"https:\/\/api.mlsgrid.com\/v2\/Property('KEY418629901')","ListingKey":"KEY418629901","AssociationYN":false,"AttributionContact":"631-537-5900","BuildingAreaUnits":"Square Feet","City":"Southampton","CoListAgentAOR":"LIBOR","CoListAgentDirectPhone":"917-863-3426","CoListAgentEmail":"julie.pinkwater@elliman.com","CoListAgentFullName":"Julie Pinkwater","CoListAgentKey":"KEY326216940","CoListAgentMlsId":"KEY207579","CoListOfficeKey":"KEY326110774","CoListOfficeMlsId":"KEYDERE46","CoListOfficeName":"Douglas Elliman Real Estate","CoListOfficePhone":"631-537-5900","CountyOrParish":"Suffolk County","CumulativeDaysOnMarket":1,"KEY_CurrentPrice":"2200000.00","CurrentUse":["Residential"],"DaysOnMarket":1,"ElementarySchool":"Southampton Elementary School","ExpirationDate":"2026-01-15","HighSchool":"Southampton High School","HorseYN":false,"InternetAddressDisplayYN":true,"InternetAutomatedValuationDisplayYN":false,"InternetConsumerCommentYN":false,"InternetEntireListingDisplayYN":true,"ListAOR":"LIBOR","ListAgentAOR":"LIBOR","ListAgentDirectPhone":"917-348-6917","ListAgentEmail":"will.metzger@elliman.com","ListAgentFullName":"Will A. Metzger","ListAgentKey":"KEY326217477","ListAgentMlsId":"KEY208126","ListOfficeAOR":"LIBOR","ListOfficeKey":"KEY326110774","ListOfficeMlsId":"KEYDERE46","ListOfficeName":"Douglas Elliman Real Estate","ListOfficePhone":"631-537-5900","ListPrice":2200000,"ListingAgreement":"Exclusive Right To Sell","ListingContractDate":"2025-02-01","ListingId":"KEY820820","LotSizeAcres":1.1,"LotSizeSquareFeet":47916,"MajorChangeTimestamp":"2025-02-04T17:42:02.000Z","MajorChangeType":"New Listing","MiddleOrJuniorSchool":"Contact Agent","KEY_MlsMajorChangeType":"New Listing","MlsStatus":"Active","OriginatingSystemModificationTimestamp":"2025-02-04T17:42:04.000Z","NumberOfLots":1,"OnMarketDate":"2025-02-04","OriginalEntryTimestamp":"2025-02-04T17:42:02.000Z","OriginalListPrice":2200000,"OriginatingSystemName":"onekey2","OwnerName":"39 Cedar","ParcelNumber":"0900-271-00-01-00-048-018","PhotosChangeTimestamp":"2025-02-04T17:43:36.468Z","PhotosCount":2,"PostalCity":"Southampton","PostalCode":"11968","PostalCodePlus4":"4226","PriceChangeTimestamp":"2025-02-04T17:42:02.000Z","PropertyType":"Land","PublicRemarks":"Southampton South of The Highway Compound Opportunity\nThis unique building opportunity in Southampton contains four pre-existing structures on 1.12 acres, zoned R-15, South of The Highway, offering the ability to create a compound just steps away from the Shinnecock Bay and a short drive to the ocean and the Village. The site borders a scenic easement, allowing for privacy. Structures can be renovated or replaced with your desired project. Ask to see plans by BMA Architects Bridgehampton\/Miami, for a 9,000 sf house\/gym\/garage or 7,000sf house\/gym\/garage. Room for pool and\/or tennis\/pickleball.","KEY_RATIO_ListPrice_By_LotSizeAcres":"2000000.0000","KEY_RATIO_ListPrice_By_OriginalListPrice":"1.00000","HighSchoolDistrict":"Southampton","SeniorCommunityYN":false,"Sewer":["Cesspool"],"ShowingContactPhone":"9173480917","KEY_ShowingContactPhone2":"9178633426","ShowingInstructions":"Call to preview or show. DO NOT walk property without an appointment.","ShowingRequirements":["Appointment Only"],"KEY_ShowingTimeFlagYN":"1","KEY_SourceSystemModificationTimestamp":"2025-02-04T12:42:02.623","SourceSystemName":"KEY","SpecialListingConditions":["None"],"StandardStatus":"Active","StateOrProvince":"NY","StatusChangeTimestamp":"2025-02-04T17:42:02.000Z","StreetName":"Cedar","StreetNumber":"39","StreetNumberNumeric":39,"StreetSuffix":"Drive","SyndicateTo":["Realtor.com"],"TaxAnnualAmount":12554,"TaxAssessedValue":1484600,"KEY_TaxSource":"Municipality","TaxYear":2025,"KEY_Village":"Southampton","KEY_WaterAccessYN":"0","WaterfrontYN":false,"ModificationTimestamp":"2025-02-05T07:07:39.224Z","Media":[{"ResourceRecordKey":"418629901","Permission":["Public"],"LongDescription":"Drone \/ aerial view with a water view","ShortDescription":"Aerial View","Order":0,"ImageWidth":1920,"ImageHeight":1440,"ImageSizeDescription":"1920x1440","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY418629901\/6ce7249c-787e-418e-83ec-6d8d09b89d0d.jpeg","MediaModificationTimestamp":"2025-02-04T17:42:43.263Z","MediaKey":"67a25193d555e202259d9ffe"},{"ResourceRecordKey":"418629901","Permission":["Public"],"LongDescription":"Map location","ShortDescription":"Other","Order":1,"ImageWidth":720,"ImageHeight":540,"ImageSizeDescription":"720x540","MediaURL":"https:\/\/s3.amazonaws.com\/mlsgrid\/images\/KEY418629901\/674ce396-9d06-49d0-b8b4-79633e4eee6e.jpeg","MediaModificationTimestamp":"2025-02-04T17:42:43.171Z","MediaKey":"67a25193d555e202259d9fff"}],"MlgCanView":true,"MlgCanUse":["IDX"]}
[listing_info] => {"list_price":2200000,"sold_price":"","rental_price":2200000,"currency":"Dollar","hide_address":"","street_number":"39","street_name":"Cedar Drive","city":"Southampton","state":"NY","province":"","zip_code":"11968","country":"Southampton","full_address":"39 Cedar Drive, Southampton, NY 11968","mls_number":"KEY820820","listing_broker":"","bedrooms":"","bathrooms":"","garage_spaces":"","year_built":"","building_size":"","lot_size":"","acres_size":"1.1","building_size_unit":"","lot_size_unit":"","virtual_tour":""}
[api_type] => 1
[api_class] => Land
[rets_prop_type] =>
[rets_prop_status] => Active
[out_prop_type] =>
[out_prop_status] =>
[api_prop_features] =>
[open_house] =>
[list_price] => 2200000
[rental_price] => 2200000
[sold_price] => 0
[state] => NY
[city] => Southampton
[zip_code] => 11968
[mls_number] => KEY820820
[bedrooms] => 0
[house_size] => 0
[property_size] => 1.1
[bathrooms] => 0
[full_address] => 39 Cedar Drive, Southampton, NY 11968
[street_name] => 39 Cedar Drive
[broker] => Douglas Elliman Real Estate
[listing_key] => KEY418629901
[listing_agent_key] => KEY326217477
[colisting_agent_key1] => KEY326216940
[colisting_agent_key2] =>
[full_street_address] => 39 Cedar
[listing_images] => ["https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY418629901\/6ce7249c-787e-418e-83ec-6d8d09b89d0d.jpeg","https:\/\/d4are2pf3qbp0.cloudfront.net\/images\/KEY418629901\/674ce396-9d06-49d0-b8b4-79633e4eee6e.jpeg"]
[SaleOrRent] =>
[RentAmtAugLaborDay] => 0
[RentAmtJulyAug] => 0
[RentAmtJuly] => 0
[RentAmtJune] => 0
[RentAmtMemLaborDay] => 0
[RentAmtOffSeason] => 0
[RentAmtYearRoundMonthly] => 0
[RentAmtjun_jul] => 0
[RentAmtsht_term] => 0
[RentAmtwinter] => 0
[RentAmtSept] => 0
[RentAmtSeptOct] => 0
[RentAmtOct] => 0
[RentAmtNov] => 0
[RentAmtDec] => 0
[RentAmtWeekly] => 0
[RentAmtTwoWeeks] => 0
[RentAmtAugust] => 0
[RentAmtApril] => 0
[RentAmtMay] => 0
[RentAmtAprilMay] => 0
[RentAmtAprilLD] => 0
[RentAmtJulyAugustLD] => 0
[last_modified] => 2025-02-05T07:07:39.224Z
[date_added] => 2025-02-07 07:01:08
)
)
