• 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 (60313, 60316, 60324, 60331, 60341, 60342, 60351, 60354, 60356, 60357, 60377, 60385, 60387, 60388, 60389, 60403, 60412, 60413, 60422, 60428, 60443, 60445, 60452, 60461, 60465, 60486, 60494, 60497, 60499, 60502, 60510, 60520, 60521, 60522, 60532, 60534, 60540, 60548, 60551, 60562, 60563, 60564, 60565, 60567, 60572, 60580, 60583, 60585)) ORDER BY FIELD(e.entity_id,60313,60316,60324,60331,60341,60342,60351,60354,60356,60357,60377,60385,60387,60388,60389,60403,60412,60413,60422,60428,60443,60445,60452,60461,60465,60486,60494,60497,60499,60502,60510,60520,60521,60522,60532,60534,60540,60548,60551,60562,60563,60564,60565,60567,60572,60580,60583,60585) "
    1. 65 West 87th Street
      65 West 87th Street
      Listing Courtesy of Brown Harris Stevens Residential Sales LLC
    2. 150 West End Avenue
      150 West End Avenue
      Listing Courtesy of Compass
    3. 400 East 56th Street
      400 East 56th Street
      Listing Courtesy of Corcoran Group
    4. 66 Reade St
      66 Reade St
      Listing Courtesy of REAL New York
    5. 301 East 63rd Street
      301 East 63rd Street
      Listing Courtesy of Brown Harris Stevens Residential Sales LLC
    6. 100 West 93rd Street
      100 West 93rd Street
      Listing Courtesy of Douglas Elliman Real Estate
    7. 377 Rector Place
      377 Rector Place
      Listing Courtesy of Douglas Elliman Real Estate
    8. 1449 Dean Street
      1449 Dean Street
      Listing Courtesy of Brown Harris Stevens Residential Sales LLC
    9. 365 BRIDGE STREET
      365 BRIDGE STREET
      Listing Courtesy of Brown Harris Stevens Residential Sales LLC
    10. 108 Leonard Street
      108 Leonard Street
      Listing Courtesy of R New York
    11. 229 East 14th Street
      229 East 14th Street
      Listing Courtesy of Corcoran Group
    12. 1001 Fifth Avenue
      1001 Fifth Avenue
      Listing Courtesy of Corcoran Group
    13. 547 West 47th Street
      547 West 47th Street
      Listing Courtesy of Corcoran Group
    14. 467 Tompkins Avenue
      467 Tompkins Avenue
      Listing Courtesy of Corcoran Group
    15. 467 Tompkins Avenue
      467 Tompkins Avenue
      Listing Courtesy of Corcoran Group
    16. 100 Barclay Street
      100 Barclay Street
      Listing Courtesy of Compass
    17. 121 Pacific Street
      121 Pacific Street
      Listing Courtesy of Corcoran Group
    18. 61A Summit Street
      61A Summit Street
      Listing Courtesy of MNS
    19. 2166 Bronx Park East
      2166 Bronx Park East
      Listing Courtesy of Corcoran Group
    20. 440 East 57th Street
      440 East 57th Street
      Listing Courtesy of REAL New York
    21. 20 Ingram Street
      20 Ingram Street
      Listing Courtesy of DGSIR Realty
    22. 30-46 87th Street
      30-46 87th Street
      Listing Courtesy of Corcoran Group
    23. 444 East 52nd Street
      444 East 52nd Street
      Listing Courtesy of Sotheby's International Realty, Inc.
    24. 3065 Sedgwick Avenue
      3065 Sedgwick Avenue
      Listing Courtesy of Compass
    25. 120 East 87th Street
      120 East 87th Street
      Listing Courtesy of Douglas Elliman Real Estate
    26. 383 Prospect Avenue
      383 Prospect Avenue
      Listing Courtesy of Corcoran Group
    27. 614 3rd Street
      614 3rd Street
      Listing Courtesy of Compass
    28. 201 East 17th Street
      201 East 17th Street
      Listing Courtesy of Compass
    29. 207 East 57th Street
      207 East 57th Street
      Listing Courtesy of Douglas Elliman Real Estate
    30. 30 East 31st Street
      30 East 31st Street
      Listing Courtesy of Reuveni Real Estate
    31. 533 East 12th Street
      533 East 12th Street
      Listing Courtesy of REAL New York
    32. 231 West 21st Street
      231 West 21st Street
      Listing Courtesy of Buchbinder & Warren Realty Group LLC
    33. 333 East 119th Street
      333 East 119th Street
      Listing Courtesy of Compass
    34. 200 East 69th Street
      200 East 69th Street
      Listing Courtesy of Peter-Ashe
    35. 5601 Riverdale Avenue
      5601 Riverdale Avenue
      Listing Courtesy of Brown Harris Stevens Residential Sales LLC
    36. 233 West 99th Street
      233 West 99th Street
      Listing Courtesy of Douglas Elliman Real Estate
    37. 460 West 51st Street
      460 West 51st Street
      Listing Courtesy of Sotheby's International Realty, Inc.
    38. 465 West 57th Street
      465 West 57th Street
      Listing Courtesy of Corcoran Group
    39. 9111 Colonial Road
      9111 Colonial Road
      Listing Courtesy of Brown Harris Stevens Residential Sales LLC
    40. 4 Fordham hill Oval
      4 Fordham hill Oval
      Listing Courtesy of Brown Harris Stevens Residential Sales LLC
    41. 1655 Flatbush Avenue
      1655 Flatbush Avenue
      Listing Courtesy of Brown Harris Stevens Residential Sales LLC
    42. 42 Wooster Street
      42 Wooster Street
      Listing Courtesy of Sotheby's International Realty, Inc.
    43. 183 Mcguinness Boulevard
      183 Mcguinness Boulevard
      Listing Courtesy of Serhant
    44. 401 95th Street
      401 95th Street
      Listing Courtesy of Compass
    45. 179 East 94th Street
      179 East 94th Street
      Listing Courtesy of Compass
    46. 25 Broad Street
      25 Broad Street
      Listing Courtesy of Corcoran Group
    47. 845 United Nations Plaza
      845 United Nations Plaza
      Listing Courtesy of Compass
    48. 480 Park Avenue
      480 Park Avenue
      Listing Courtesy of Corcoran Group
    string(10) "<<<>>>5679"
    ( 193 to 240 of 768 )  
    © HELLER ORGANIZATION 2021 ALL RIGHTS RESERVED
    Equal Housing Opportunity - REBNY