• 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(2422) "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 (73198, 867, 78552, 78571, 78583, 77393, 77394, 77395, 77396, 77397, 77398, 77399, 77400, 77401, 77402, 77403, 77404, 77405, 77406, 77407, 77409, 77410, 77411, 77412, 77413, 77414, 77415, 77416, 77417, 77418, 77419, 77420, 77421, 77422, 77423, 77424, 77426, 77427, 77428, 77429, 77430, 77431, 77432, 77433, 77434, 77435, 77436, 77437)) ORDER BY FIELD(e.entity_id,73198,867,78552,78571,78583,77393,77394,77395,77396,77397,77398,77399,77400,77401,77402,77403,77404,77405,77406,77407,77409,77410,77411,77412,77413,77414,77415,77416,77417,77418,77419,77420,77421,77422,77423,77424,77426,77427,77428,77429,77430,77431,77432,77433,77434,77435,77436,77437) "
    1. EXCLUSIVE
      CONTRACT SIGNED
      VIDEO
      11 Fifth Avenue, 6T
      11 Fifth Avenue
       
    2. EXCLUSIVE
      VIDEO
      75 East End Avenue
      75 East End Avenue
       
    3. EXCLUSIVE
      CONTRACT SIGNED
      45 East 30th Street, #5B
      43-45 East 30th Street
       
    4. EXCLUSIVE
      CONTRACT SIGNED
      VIDEO
      100 West 18th Street
      100 West 18th Street
       
    5. EXCLUSIVE
      50 Gramercy Park North, #14A
      50 Gramercy Park North
       
    6. 111 West 56th Street
      111 West 56th Street
      Listing Courtesy of Douglas Elliman Real Estate
    7. 111 West 56th Street
      111 West 56th Street
      Listing Courtesy of Douglas Elliman Real Estate
    8. 111 West 56th Street
      111 West 56th Street
      Listing Courtesy of Douglas Elliman Real Estate
    9. 111 West 56th Street
      111 West 56th Street
      Listing Courtesy of Douglas Elliman Real Estate
    10. 111 West 56th Street
      111 West 56th Street
      Listing Courtesy of Douglas Elliman Real Estate
    11. 111 West 56th Street
      111 West 56th Street
      Listing Courtesy of Douglas Elliman Real Estate
    12. 111 West 56th Street
      111 West 56th Street
      Listing Courtesy of Douglas Elliman Real Estate
    13. 111 West 56th Street
      111 West 56th Street
      Listing Courtesy of Douglas Elliman Real Estate
    14. 111 West 56th Street
      111 West 56th Street
      Listing Courtesy of Douglas Elliman Real Estate
    15. 111 West 56th Street
      111 West 56th Street
      Listing Courtesy of Douglas Elliman Real Estate
    16. 308 East 38th Street
      308 East 38th Street
      Listing Courtesy of Compass
    17. 1060 Park Avenue
      1060 Park Avenue
      Listing Courtesy of Douglas Elliman Real Estate
    18. 40 East 84th Street
      40 East 84th Street
      Listing Courtesy of Douglas Elliman Real Estate
    19. 30 East 65th Street
      30 East 65th Street
      Listing Courtesy of Serhant
    20. 322 West 57th Street
      322 West 57th Street
      Listing Courtesy of Douglas Elliman Real Estate
    21. 941 Park Avenue
      941 Park Avenue
      Listing Courtesy of Christie's International Real Estate
    22. 368 Third Avenue
      368 Third Avenue
      Listing Courtesy of Brown Harris Stevens Residential Sales LLC
    23. 67-23 Burns Street
      67-23 Burns Street
      Listing Courtesy of Douglas Elliman Real Estate
    24. 183 Mcguinness Boulevard
      183 Mcguinness Boulevard
      Listing Courtesy of Serhant
    25. 363 East 76th Street
      363 East 76th Street
      Listing Courtesy of Compass
    26. 321 West 110th Street
      321 West 110th Street
      Listing Courtesy of Compass
    27. 415 Main Street
      415 Main Street
      Listing Courtesy of Sotheby's International Realty, Inc.
    28. 353 East 72nd Street
      353 East 72nd Street
      Listing Courtesy of Sotheby's International Realty, Inc.
    29. 1050 Park Avenue
      1050 Park Avenue
      Listing Courtesy of Sotheby's International Realty, Inc.
    30. 323 West 11th Street
      323 West 11th Street
      Listing Courtesy of Compass
    31. 269 West 87th Street
      269 West 87th Street
      Listing Courtesy of Douglas Elliman Real Estate
    32. 49 West 96th Street
      49 West 96th Street
      Listing Courtesy of Corcoran Group
    33. 30 Main Street
      30 Main Street
      Listing Courtesy of Brown Harris Stevens Residential Sales LLC
    34. 570 Park Avenue
      570 Park Avenue
      Listing Courtesy of Warburg Realty Partnership, Ltd.
    35. 80 Riverside Boulevard
      80 Riverside Boulevard
      Listing Courtesy of Nest Seekers International
    36. 1020 Park Avenue
      1020 Park Avenue
      Listing Courtesy of Brown Harris Stevens Residential Sales LLC
    37. 240 East 35th Street
      240 East 35th Street
      Listing Courtesy of Serhant
    38. 465 Park Avenue
      465 Park Avenue
      Listing Courtesy of Douglas Elliman Real Estate
    39. 140 Fifth Avenue
      140 Fifth Avenue
      Listing Courtesy of Sotheby's International Realty, Inc.
    40. 371 Van Brunt Street
      371 Van Brunt Street
      Listing Courtesy of Engel & Volkers Brownstone Brooklyn
    41. 320 East 72nd Street
      320 East 72nd Street
      Listing Courtesy of Sotheby's International Realty, Inc.
    42. 1040 Fifth Avenue
      1040 Fifth Avenue
      Listing Courtesy of Sotheby's International Realty, Inc.
    43. 40-50 East 10th Street
      40-50 East 10th Street
      Listing Courtesy of Compass
    44. 2351 Adam Clayton Powell
      2351 Adam Clayton Powell
      Listing Courtesy of Brown Harris Stevens Residential Sales LLC
    45. 2351 Adam Clayton Powell
      2351 Adam Clayton Powell
      Listing Courtesy of Brown Harris Stevens Residential Sales LLC
    46. 13 West 127th Street
      13 West 127th Street
      Listing Courtesy of Brown Harris Stevens Residential Sales LLC
    47. 555 West End Avenue
      555 West End Avenue
      Listing Courtesy of Sotheby's International Realty, Inc.
    48. 164 Kent Avenue
      164 Kent Avenue
      Listing Courtesy of Compass
    string(10) "<<<>>>5679"
    ( 1 to 48 of 768 )  
    © HELLER ORGANIZATION 2021 ALL RIGHTS RESERVED
    Equal Housing Opportunity - REBNY