• 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 (59779, 59780, 59782, 59783, 59788, 59791, 59792, 59793, 59803, 59806, 59810, 59811, 59812, 59813, 59814, 59830, 59839, 59840, 59843, 59845, 59853, 59856, 59857, 59858, 59881, 59885, 59888, 59891, 59900, 59905, 59908, 59917, 59926, 59928, 59943, 59947, 59955, 59957, 59962, 59969, 59980, 59983, 59996, 60001, 60011, 60014, 60015, 60023)) ORDER BY FIELD(e.entity_id,59779,59780,59782,59783,59788,59791,59792,59793,59803,59806,59810,59811,59812,59813,59814,59830,59839,59840,59843,59845,59853,59856,59857,59858,59881,59885,59888,59891,59900,59905,59908,59917,59926,59928,59943,59947,59955,59957,59962,59969,59980,59983,59996,60001,60011,60014,60015,60023) "
    1. 450 Washington Street
      450 Washington Street
      Listing Courtesy of Corcoran Group
    2. 450 Washington Street
      450 Washington Street
      Listing Courtesy of Corcoran Group
    3. 1600 Broadway
      1600 Broadway
      Listing Courtesy of Brown Harris Stevens Residential Sales LLC
    4. 40 Sutton Place
      40 Sutton Place
      Listing Courtesy of Mirador Real Estate LLC
    5. 875 West End Avenue
      875 West End Avenue
      Listing Courtesy of Corcoran Group
    6. 30 Riverside Boulevard
      30 Riverside Boulevard
      Listing Courtesy of Corcoran Group
    7. 150 East 69th Street
      150 East 69th Street
      Listing Courtesy of Brown Harris Stevens Residential Sales LLC
    8. 310 West 52nd Street
      310 West 52nd Street
      Listing Courtesy of Serhant
    9. 100 United Nations Plaza
      100 United Nations Plaza
      Listing Courtesy of Corcoran Group
    10. 58 Strong Place
      58 Strong Place
      Listing Courtesy of Corcoran Group
    11. 4113 Seventh Avenue
      4113 Seventh Avenue
      Listing Courtesy of Douglas Elliman Real Estate
    12. 15 William Street
      15 William Street
      Listing Courtesy of Douglas Elliman Real Estate
    13. 500 West 18th Street
      500 West 18th Street
      Listing Courtesy of Corcoran Group
    14. 500 West 18th Street
      500 West 18th Street
      Listing Courtesy of Corcoran Group
    15. 500 West 18th Street
      500 West 18th Street
      Listing Courtesy of Corcoran Group
    16. 876 Macon Street
      876 Macon Street
      Listing Courtesy of Corcoran Group
    17. 109-20 Queens Boulevard
      109-20 Queens Boulevard
      Listing Courtesy of Keller Williams NYC
    18. 53 West 11th Street
      53 West 11th Street
      Listing Courtesy of Compass
    19. 202 Seeley Street
      202 Seeley Street
      Listing Courtesy of Garfield Realty Corp
    20. 2-17 51st Avenue
      2-17 51st Avenue
      Listing Courtesy of Compass
    21. 333 East 79th Street
      333 East 79th Street
      Listing Courtesy of Compass
    22. 300 East 40th Street
      300 East 40th Street
      Listing Courtesy of Rose Associates, Inc.
    23. 212 West 95th Street
      212 West 95th Street
      Listing Courtesy of Reuveni Real Estate
    24. 1212 Fifth Avenue
      1212 Fifth Avenue
      Listing Courtesy of Nest Seekers International
    25. 547 West 47th Street
      547 West 47th Street
      Listing Courtesy of Corcoran Group
    26. 97 Crosby Street
      97 Crosby Street
      Listing Courtesy of Brown Harris Stevens Residential Sales LLC
    27. 135 Willow Street
      135 Willow Street
      Listing Courtesy of Digs Realty Group LLC
    28. 300 West 145th Street
      300 West 145th Street
      Listing Courtesy of Corcoran Group
    29. 305 East 24th Street
      305 East 24th Street
      Listing Courtesy of Corcoran Group
    30. 135 East 39th Street
      135 East 39th Street
      Listing Courtesy of CORE Group Marketing, LLC
    31. 87 Smith Street
      87 Smith Street
      Listing Courtesy of Douglas Elliman Real Estate
    32. 2 Fordham hill oval
      2 Fordham hill oval
      Listing Courtesy of Brown Harris Stevens Residential Sales LLC
    33. 123 Pierrepont Street
      123 Pierrepont Street
      Listing Courtesy of Corcoran Group
    34. 130 East 67th Street
      130 East 67th Street
      Listing Courtesy of Compass
    35. 650 East 6th Street
      650 East 6th Street
      Listing Courtesy of Douglas Elliman Real Estate
    36. 26 West 127th Street
      26 West 127th Street
      Listing Courtesy of Compass
    37. 111 Murray Street
      111 Murray Street
      Listing Courtesy of Douglas Elliman Real Estate
    38. 220 East 57th Street
      220 East 57th Street
      Listing Courtesy of Keller Williams NYC
    39. 18 Mercer Street
      18 Mercer Street
      Listing Courtesy of Compass
    40. 475 Park Avenue
      475 Park Avenue
      Listing Courtesy of Corcoran Group
    41. 10 West 66th Street
      10 West 66th Street
      Listing Courtesy of Compass
    42. 39 West 23rd Street
      39 West 23rd Street
      Listing Courtesy of Corcoran Group
    43. 225 Central Park West
      225 Central Park West
      Listing Courtesy of Douglas Elliman Real Estate
    44. 233 East 60th Street
      233 East 60th Street
      Listing Courtesy of R New York
    45. 88 Greenwich Street
      88 Greenwich Street
      Listing Courtesy of R New York
    46. 53 North Moore Street
      53 North Moore Street
      Listing Courtesy of Compass
    47. 575 Park Avenue
      575 Park Avenue
      Listing Courtesy of Corcoran Group
    48. 201 West 70th Street
      201 West 70th Street
      Listing Courtesy of Compass
    string(10) "<<<>>>5679"
    ( 97 to 144 of 768 )  
    © HELLER ORGANIZATION 2021 ALL RIGHTS RESERVED
    Equal Housing Opportunity - REBNY