• 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 (59680, 59681, 59683, 59684, 59685, 59694, 59698, 59700, 59706, 59707, 59709, 59719, 59720, 59728, 59729, 59735, 59737, 59744, 59745, 59746, 59747, 59748, 59749, 59750, 59752, 59753, 59754, 59755, 59756, 59757, 59758, 59759, 59760, 59761, 59762, 59765, 59766, 59768, 59769, 59770, 59771, 59772, 59773, 59774, 59775, 59776, 59777, 59778)) ORDER BY FIELD(e.entity_id,59680,59681,59683,59684,59685,59694,59698,59700,59706,59707,59709,59719,59720,59728,59729,59735,59737,59744,59745,59746,59747,59748,59749,59750,59752,59753,59754,59755,59756,59757,59758,59759,59760,59761,59762,59765,59766,59768,59769,59770,59771,59772,59773,59774,59775,59776,59777,59778) "
    1. 1991 Broadway
      1991 Broadway
      Listing Courtesy of R New York
    2. 50 West 96th Street
      50 West 96th Street
      Listing Courtesy of Sotheby's International Realty, Inc.
    3. 225 East 74th Street
      225 East 74th Street
      Listing Courtesy of Douglas Elliman Real Estate
    4. 450 Washington Street
      450 Washington Street
      Listing Courtesy of Corcoran Group
    5. 50 West 30th Street
      50 West 30th Street
      Listing Courtesy of Corcoran Group
    6. 415 East 52nd Street
      415 East 52nd Street
      Listing Courtesy of Corcoran Group
    7. 20 River Terrace
      20 River Terrace
      Listing Courtesy of Corcoran Group
    8. 20 River Terrace
      20 River Terrace
      Listing Courtesy of Corcoran Group
    9. 300 West 30th Street
      300 West 30th Street
      Listing Courtesy of Corcoran Group
    10. 300 West 108th Street
      300 West 108th Street
      Listing Courtesy of Brown Harris Stevens Residential Sales LLC
    11. 1666 East 55th Street
      1666 East 55th Street
      Listing Courtesy of Elegran Real Estate and Development
    12. 300 West 122nd Street
      300 West 122nd Street
      Listing Courtesy of Douglas Elliman Real Estate
    13. 347 East 53rd Street
      347 East 53rd Street
      Listing Courtesy of Corcoran Group
    14. 71 Nassau Street
      71 Nassau Street
      Listing Courtesy of Compass
    15. 1 Clinton Street
      1 Clinton Street
      Listing Courtesy of Corcoran Group
    16. 248 Clifton Place
      248 Clifton Place
      Listing Courtesy of Corcoran Group
    17. 12 Pleasant Place
      12 Pleasant Place
      Listing Courtesy of Keller Williams Realty Empire
    18. 37-21 80th Street
      37-21 80th Street
      Listing Courtesy of Compass
    19. 100 Overlook Terrace
      100 Overlook Terrace
      Listing Courtesy of Brown Harris Stevens Residential Sales LLC
    20. 450 Washington Street
      450 Washington Street
      Listing Courtesy of Corcoran Group
    21. 450 Washington Street
      450 Washington Street
      Listing Courtesy of Corcoran Group
    22. 450 Washington Street
      450 Washington Street
      Listing Courtesy of Corcoran Group
    23. 150 Central Park South
      150 Central Park South
      Listing Courtesy of Compass
    24. 136 East 36th Street
      136 East 36th Street
      Listing Courtesy of Compass
    25. 450 Washington Street
      450 Washington Street
      Listing Courtesy of Corcoran Group
    26. 450 Washington Street
      450 Washington Street
      Listing Courtesy of Corcoran Group
    27. 450 Washington Street
      450 Washington Street
      Listing Courtesy of Corcoran Group
    28. 450 Washington Street
      450 Washington Street
      Listing Courtesy of Corcoran Group
    29. 300 West 122nd Street
      300 West 122nd Street
      Listing Courtesy of Douglas Elliman Real Estate
    30. 450 Washington Street
      450 Washington Street
      Listing Courtesy of Corcoran Group
    31. 450 Washington Street
      450 Washington Street
      Listing Courtesy of Corcoran Group
    32. 450 Washington Street
      450 Washington Street
      Listing Courtesy of Corcoran Group
    33. 450 Washington Street
      450 Washington Street
      Listing Courtesy of Corcoran Group
    34. 450 Washington Street
      450 Washington Street
      Listing Courtesy of Corcoran Group
    35. 450 Washington Street
      450 Washington Street
      Listing Courtesy of Corcoran Group
    36. 7 Lexington Avenue
      7 Lexington Avenue
      Listing Courtesy of Brown Harris Stevens Residential Sales LLC
    37. 505 West 47th Street
      505 West 47th Street
      Listing Courtesy of Brown Harris Stevens Residential Sales LLC
    38. 450 Washington Street
      450 Washington Street
      Listing Courtesy of Corcoran Group
    39. 450 Washington Street
      450 Washington Street
      Listing Courtesy of Corcoran Group
    40. 450 Washington Street
      450 Washington Street
      Listing Courtesy of Corcoran Group
    41. 225 East 57th Street
      225 East 57th Street
      Listing Courtesy of Sotheby's International Realty, Inc.
    42. 450 Washington Street
      450 Washington Street
      Listing Courtesy of Corcoran Group
    43. 450 Washington Street
      450 Washington Street
      Listing Courtesy of Corcoran Group
    44. 450 Washington Street
      450 Washington Street
      Listing Courtesy of Corcoran Group
    45. 450 Washington Street
      450 Washington Street
      Listing Courtesy of Corcoran Group
    46. 450 Washington Street
      450 Washington Street
      Listing Courtesy of Corcoran Group
    47. 450 Washington Street
      450 Washington Street
      Listing Courtesy of Corcoran Group
    48. 450 Washington Street
      450 Washington Street
      Listing Courtesy of Corcoran Group
    string(10) "<<<>>>5679"
    ( 49 to 96 of 768 )  
    © HELLER ORGANIZATION 2021 ALL RIGHTS RESERVED
    Equal Housing Opportunity - REBNY