• 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 (77438, 77439, 77440, 77441, 77443, 77445, 77446, 77447, 77448, 77449, 77450, 77451, 77452, 77453, 77454, 77455, 77456, 77458, 77459, 77460, 77461, 77462, 77464, 77465, 77466, 77467, 77468, 77469, 77470, 77471, 77472, 77473, 77475, 77476, 77477, 77478, 77479, 77480, 77481, 77482, 77483, 77484, 77485, 77486, 77487, 77488, 77489, 77490)) ORDER BY FIELD(e.entity_id,77438,77439,77440,77441,77443,77445,77446,77447,77448,77449,77450,77451,77452,77453,77454,77455,77456,77458,77459,77460,77461,77462,77464,77465,77466,77467,77468,77469,77470,77471,77472,77473,77475,77476,77477,77478,77479,77480,77481,77482,77483,77484,77485,77486,77487,77488,77489,77490) "
    1. 520 East 82nd Street
      520 East 82nd Street
      Listing Courtesy of Vandenberg -The Townhouse Experts
    2. 250 West 22nd Street
      250 West 22nd Street
      Listing Courtesy of Douglas Elliman Real Estate
    3. 10 Sullivan Street
      10 Sullivan Street
      Listing Courtesy of Sotheby's International Realty, Inc.
    4. 40 East 80th Street
      40 East 80th Street
      Listing Courtesy of Sotheby's International Realty, Inc.
    5. 400 East 56th Street
      400 East 56th Street
      Listing Courtesy of Sotheby's International Realty, Inc.
    6. 220 Madison Avenue
      220 Madison Avenue
      Listing Courtesy of Douglas Elliman Real Estate
    7. 138 East 36th Street
      138 East 36th Street
      Listing Courtesy of Christie's International Real Estate
    8. 447 West 18th Street
      447 West 18th Street
      Listing Courtesy of Corcoran Group
    9. 534 West 29th Street
      534 West 29th Street
      Listing Courtesy of CORE Group Marketing, LLC
    10. 534 West 29th Street
      534 West 29th Street
      Listing Courtesy of CORE Group Marketing, LLC
    11. 920 Fifth Avenue
      920 Fifth Avenue
      Listing Courtesy of Brown Harris Stevens Residential Sales LLC
    12. 176 East 77th Street
      176 East 77th Street
      Listing Courtesy of Brown Harris Stevens Residential Sales LLC
    13. 309 East 108th Street
      309 East 108th Street
      Listing Courtesy of Sotheby's International Realty, Inc.
    14. 900 Fifth Avenue
      900 Fifth Avenue
      Listing Courtesy of Douglas Elliman Real Estate
    15. 4 East 72nd Street
      4 East 72nd Street
      Listing Courtesy of Brown Harris Stevens Residential Sales LLC
    16. 49 East 86th Street
      49 East 86th Street
      Listing Courtesy of Fox Residential Group, Inc.
    17. 160 West 66th Street
      160 West 66th Street
      Listing Courtesy of Brown Harris Stevens Residential Sales LLC
    18. 159 Madison Avenue
      159 Madison Avenue
      Listing Courtesy of Douglas Elliman Real Estate
    19. 150 Charles Street
      150 Charles Street
      Listing Courtesy of Sotheby's International Realty, Inc.
    20. 132 East 35th Street
      132 East 35th Street
      Listing Courtesy of Brown Harris Stevens Residential Sales LLC
    21. 12 East 75th Street
      12 East 75th Street
      Listing Courtesy of Sotheby's International Realty, Inc.
    22. 360 East 88th Street
      360 East 88th Street
      Listing Courtesy of Sotheby's International Realty, Inc.
    23. 100 West 58th Street
      100 West 58th Street
      Listing Courtesy of Douglas Elliman Real Estate
    24. 150 East 73rd Street
      150 East 73rd Street
      Listing Courtesy of Corcoran Group
    25. 216 East 47th Street
      216 East 47th Street
      Listing Courtesy of Manhattan Boutique Real Estate Inc
    26. 137 East 36th Street
      137 East 36th Street
      Listing Courtesy of Manhattan Boutique Real Estate Inc
    27. 25-19 43rd Avenue
      25-19 43rd Avenue
      Listing Courtesy of CORE Group Marketing, LLC
    28. 305 East 51st Street
      305 East 51st Street
      Listing Courtesy of Sotheby's International Realty, Inc.
    29. 23 West 116th Street
      23 West 116th Street
      Listing Courtesy of Brown Harris Stevens Residential Sales LLC
    30. 70 West 45th Street
      70 West 45th Street
      Listing Courtesy of Serhant
    31. 70 West 45th Street
      70 West 45th Street
      Listing Courtesy of Serhant
    32. 6 Fordham hill oval
      6 Fordham hill oval
      Listing Courtesy of Brown Harris Stevens Residential Sales LLC
    33. 554 Broome Street
      554 Broome Street
      Listing Courtesy of Compass
    34. 20 West 77th Street
      20 West 77th Street
      Listing Courtesy of Warburg Realty Partnership, Ltd.
    35. 40 Leroy Street
      40 Leroy Street
      Listing Courtesy of Sotheby's International Realty, Inc.
    36. 368 Third Avenue
      368 Third Avenue
      Listing Courtesy of Brown Harris Stevens Residential Sales LLC
    37. 252 South Street
      252 South Street
      Listing Courtesy of Corcoran Group
    38. 250 East 49th Street
      250 East 49th Street
      Listing Courtesy of Sotheby's International Realty, Inc.
    39. 31-44 29th Street
      31-44 29th Street
      Listing Courtesy of Compass
    40. 45 East 82nd Street
      45 East 82nd Street
      Listing Courtesy of Warburg Realty Partnership, Ltd.
    41. 2109 Broadway
      2109 Broadway
      Listing Courtesy of Sotheby's International Realty, Inc.
    42. 561 Pacific Street
      561 Pacific Street
      Listing Courtesy of Serhant
    43. 1261 Madison Avenue
      1261 Madison Avenue
      Listing Courtesy of Sotheby's International Realty, Inc.
    44. 177 East 77th Street
      177 East 77th Street
      Listing Courtesy of Brown Harris Stevens Residential Sales LLC
    45. 22 East 93rd Street
      22 East 93rd Street
      Listing Courtesy of Sotheby's International Realty, Inc.
    46. 400 East 56th Street
      400 East 56th Street
      Listing Courtesy of Warburg Realty Partnership, Ltd.
    47. 109 West 89th Street
      109 West 89th Street
      Listing Courtesy of Sotheby's International Realty, Inc.
    48. 415 East 80th Street
      415 East 80th Street
      Listing Courtesy of Sotheby's International Realty, Inc.
    string(10) "<<<>>>5679"
    ( 49 to 96 of 768 )  
    © HELLER ORGANIZATION 2021 ALL RIGHTS RESERVED
    Equal Housing Opportunity - REBNY