• My Account
  • My Wish List
  • Sign In
  • Compare Products
  • Create an Account
Toggle Nav
Cart ()
Menu
Account

  • Buy

  • logo

    • Buy

    • Neighborhood
    • Bedrooms
    • Baths
    • Price
    • Square Footage
    • Property Type
    • More Filters
    string(2426) "SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, IF(at_trestle.value_id > 0, at_trestle.value, at_trestle_default.value) AS `trestle`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1' INNER JOIN `catalog_product_entity_int` AS `at_trestle_default` ON (`at_trestle_default`.`entity_id` = `e`.`entity_id`) AND (`at_trestle_default`.`attribute_id` = '437') AND `at_trestle_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_int` AS `at_trestle` ON (`at_trestle`.`entity_id` = `e`.`entity_id`) AND (`at_trestle`.`attribute_id` = '437') AND (`at_trestle`.`store_id` = 1) LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product')) INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1 WHERE (IF(at_trestle.value_id > 0, at_trestle.value, at_trestle_default.value) IS NOT NULL) AND (stock_status_index.stock_status = 1) AND (e.entity_id IN (77491, 77492, 77493, 77495, 77496, 77497, 77498, 77499, 77500, 77501, 77503, 77504, 77505, 77506, 77507, 77509, 77511, 77512, 77513, 77514, 77515, 77517, 77518, 77519, 77520, 77521, 77522, 77523, 77524, 77525, 77526, 77528, 77533, 77534, 77535, 77539, 77543, 77544, 77545, 77547, 77548, 77549, 77551, 77553, 77554, 77555, 77556, 77557)) ORDER BY FIELD(e.entity_id,77491,77492,77493,77495,77496,77497,77498,77499,77500,77501,77503,77504,77505,77506,77507,77509,77511,77512,77513,77514,77515,77517,77518,77519,77520,77521,77522,77523,77524,77525,77526,77528,77533,77534,77535,77539,77543,77544,77545,77547,77548,77549,77551,77553,77554,77555,77556,77557) "
    1. 30 East 10th Street
      30 East 10th Street
      Listing Courtesy of CORE Group Marketing, LLC
    2. 61 West 62nd Street
      61 West 62nd Street
      Listing Courtesy of Fox Residential Group, Inc.
    3. 305 East 51st Street
      305 East 51st Street
      Listing Courtesy of CORE Group Marketing, LLC
    4. 200 Central Park South
      200 Central Park South
      Listing Courtesy of Warburg Realty Partnership, Ltd.
    5. 201 East 79th Street
      201 East 79th Street
      Listing Courtesy of Brown Harris Stevens Residential Sales LLC
    6. 875 Fifth Avenue
      875 Fifth Avenue
      Listing Courtesy of Warburg Realty Partnership, Ltd.
    7. 271 West 122nd Street
      271 West 122nd Street
      Listing Courtesy of CORE Group Marketing, LLC
    8. 118 East 1st Street
      118 East 1st Street
      Listing Courtesy of Douglas Elliman Real Estate
    9. 245 West 24th Street
      245 West 24th Street
      Listing Courtesy of Corcoran Group
    10. 340 East 64th Street
      340 East 64th Street
      Listing Courtesy of Sotheby's International Realty, Inc.
    11. 130 East 67th Street
      130 East 67th Street
      Listing Courtesy of Brown Harris Stevens Residential Sales LLC
    12. 300 East 54th Street
      300 East 54th Street
      Listing Courtesy of Brown Harris Stevens Residential Sales LLC
    13. 2 Columbus Avenue
      2 Columbus Avenue
      Listing Courtesy of Corcoran Group
    14. 15 William Street
      15 William Street
      Listing Courtesy of Corcoran Group
    15. 49 East 86th Street
      49 East 86th Street
      Listing Courtesy of Sotheby's International Realty, Inc.
    16. 136 East 79th Street
      136 East 79th Street
      Listing Courtesy of Sotheby's International Realty, Inc.
    17. 1 Central Park South
      1 Central Park South
      Listing Courtesy of CORE Group Marketing, LLC
    18. 213 West 23rd Street
      213 West 23rd Street
      Listing Courtesy of Sotheby's International Realty, Inc.
    19. 70 East 10th Street
      70 East 10th Street
      Listing Courtesy of Sotheby's International Realty, Inc.
    20. 110 West 86th Street
      110 West 86th Street
      Listing Courtesy of Compass
    21. 60 Gramercy Park North
      60 Gramercy Park North
      Listing Courtesy of Sotheby's International Realty, Inc.
    22. 153 East 57th Street
      153 East 57th Street
      Listing Courtesy of Sotheby's International Realty, Inc.
    23. 490 West End Avenue
      490 West End Avenue
      Listing Courtesy of Sotheby's International Realty, Inc.
    24. 320 East 42nd Street
      320 East 42nd Street
      Listing Courtesy of Douglas Elliman Real Estate
    25. 400 East 56th Street
      400 East 56th Street
      Listing Courtesy of Brown Harris Stevens Residential Sales LLC
    26. 360 East 89th Street
      360 East 89th Street
      Listing Courtesy of Sotheby's International Realty, Inc.
    27. 20 East 9th Street
      20 East 9th Street
      Listing Courtesy of Keller Williams NYC
    28. 885 Park Avenue
      885 Park Avenue
      Listing Courtesy of Sotheby's International Realty, Inc.
    29. 6 Fordham Hill Oval
      6 Fordham Hill Oval
      Listing Courtesy of Brown Harris Stevens Residential Sales LLC
    30. 750 Park Avenue
      750 Park Avenue
      Listing Courtesy of Sotheby's International Realty, Inc.
    31. 30 West 15th Street
      30 West 15th Street
      Listing Courtesy of Sotheby's International Realty, Inc.
    32. 48-50 44th Street
      48-50 44th Street
      Listing Courtesy of CORE Group Marketing, LLC
    33. 25 Central Park West
      25 Central Park West
      Listing Courtesy of DGSIR Realty
    34. 160 East 22nd Street
      160 East 22nd Street
      Listing Courtesy of Compass
    35. 432 Carlton Avenue
      432 Carlton Avenue
      Listing Courtesy of AP Realty Group NY LTD
    36. 30 Front Street
      30 Front Street
      Listing Courtesy of Sotheby's International Realty, Inc.
    37. 230 West 56th Street
      230 West 56th Street
      Listing Courtesy of Sotheby's International Realty, Inc.
    38. 623 Avenue H
      623 Avenue H
      Listing Courtesy of Corcoran Group
    39. 165 Lexington Avenue
      165 Lexington Avenue
      Listing Courtesy of Nest Seekers International
    40. 120 Central Park South
      120 Central Park South
      Listing Courtesy of Sotheby's International Realty, Inc.
    41. 120 Central Park South
      120 Central Park South
      Listing Courtesy of Sotheby's International Realty, Inc.
    42. 18 West 48th Street
      18 West 48th Street
      Listing Courtesy of Douglas Elliman Real Estate
    43. 225 East 86th Street
      225 East 86th Street
      Listing Courtesy of Sotheby's International Realty, Inc.
    44. 90-06 202nd Street
      90-06 202nd Street
      Listing Courtesy of Compass
    45. 255 West 108th Street
      255 West 108th Street
      Listing Courtesy of Nest Seekers International
    46. 161 East 110th Street
      161 East 110th Street
      Listing Courtesy of R New York
    47. 764 Saint Johns Place
      764 Saint Johns Place
      Listing Courtesy of Douglas Elliman Real Estate
    48. 59 John Street
      59 John Street
      Listing Courtesy of Nest Seekers International
    string(10) "<<<>>>5679"
    ( 97 to 144 of 768 )  
    © HELLER ORGANIZATION 2021 ALL RIGHTS RESERVED
    Equal Housing Opportunity - REBNY