• 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 (76619, 76620, 76621, 76622, 76623, 76624, 76625, 76626, 76627, 76628, 76629, 76630, 76632, 76633, 76634, 76635, 76636, 76637, 76638, 76639, 76640, 76641, 76642, 76643, 76644, 76645, 76646, 76647, 76648, 76649, 76650, 76651, 76652, 76653, 76655, 76656, 76657, 76658, 76659, 76660, 76661, 76662, 76663, 76664, 76665, 76666, 76668, 76669)) ORDER BY FIELD(e.entity_id,76619,76620,76621,76622,76623,76624,76625,76626,76627,76628,76629,76630,76632,76633,76634,76635,76636,76637,76638,76639,76640,76641,76642,76643,76644,76645,76646,76647,76648,76649,76650,76651,76652,76653,76655,76656,76657,76658,76659,76660,76661,76662,76663,76664,76665,76666,76668,76669) "
    1. 230 East 79th Street
      230 East 79th Street
      Listing Courtesy of Corcoran Group
    2. 101 West 14th Street
      101 West 14th Street
      Listing Courtesy of Compass
    3. 870 Riverside Drive
      870 Riverside Drive
      Listing Courtesy of Compass
    4. 101 West 14th Street
      101 West 14th Street
      Listing Courtesy of Compass
    5. 101 West 14th Street
      101 West 14th Street
      Listing Courtesy of Compass
    6. 101 West 14th Street
      101 West 14th Street
      Listing Courtesy of Compass
    7. 177 East 79th Street
      177 East 79th Street
      Listing Courtesy of Corcoran Group
    8. 333 East 79th Street
      333 East 79th Street
      Listing Courtesy of Compass
    9. 2 Fifth Avenue
      2 Fifth Avenue
      Listing Courtesy of Compass
    10. 444 East 52nd Street
      444 East 52nd Street
      Listing Courtesy of Spire Group Inc.
    11. 2373 Broadway
      2373 Broadway
      Listing Courtesy of Compass
    12. 620 Broadway
      620 Broadway
      Listing Courtesy of Compass
    13. 333 Rector Place
      333 Rector Place
      Listing Courtesy of Compass
    14. 175 East 2nd Street
      175 East 2nd Street
      Listing Courtesy of Compass
    15. 67-40 Yellowstone Boulevard
      67-40 Yellowstone Boulevard
      Listing Courtesy of Compass
    16. 99 Spring Street
      99 Spring Street
      Listing Courtesy of Compass
    17. 360 Furman Street
      360 Furman Street
      Listing Courtesy of Compass
    18. 568 Grand Street
      568 Grand Street
      Listing Courtesy of LoHo Realty
    19. 11-16 Main Avenue
      11-16 Main Avenue
      Listing Courtesy of Compass
    20. 35-16 85th Street
      35-16 85th Street
      Listing Courtesy of Compass
    21. 34-20 79th Street
      34-20 79th Street
      Listing Courtesy of Compass
    22. 573 Grand Street
      573 Grand Street
      Listing Courtesy of Brown Harris Stevens Residential Sales LLC
    23. 10-50 Jackson Avenue
      10-50 Jackson Avenue
      Listing Courtesy of Compass
    24. 4 East 88th Street
      4 East 88th Street
      Listing Courtesy of Brown Harris Stevens Residential Sales LLC
    25. 20 West Street
      20 West Street
      Listing Courtesy of City Connections Realty
    26. 47 Mercer Street
      47 Mercer Street
      Listing Courtesy of Compass
    27. 1 Wall Street
      1 Wall Street
      Listing Courtesy of Compass
    28. 16 Sutton Place
      16 Sutton Place
      Listing Courtesy of Compass
    29. 82 3rd Place
      82 3rd Place
      Listing Courtesy of Compass
    30. 211 East 51st Street
      211 East 51st Street
      Listing Courtesy of Compass
    31. 80 Beekman Street
      80 Beekman Street
      Listing Courtesy of Compass
    32. 192 Lenox Avenue
      192 Lenox Avenue
      Listing Courtesy of Compass
    33. 35 Mount Morris Park West
      35 Mount Morris Park West
      Listing Courtesy of Compass
    34. 200 East End Avenue
      200 East End Avenue
      Listing Courtesy of Sotheby's International Realty, Inc.
    35. 44 West 96th Street
      44 West 96th Street
      Listing Courtesy of Compass
    36. 190 East 72nd Street
      190 East 72nd Street
      Listing Courtesy of Compass
    37. 105 West 13th Street
      105 West 13th Street
      Listing Courtesy of Compass
    38. 411 East 53rd Street
      411 East 53rd Street
      Listing Courtesy of Compass
    39. 140 West 69th Street
      140 West 69th Street
      Listing Courtesy of Compass
    40. 1050 Fifth Avenue
      1050 Fifth Avenue
      Listing Courtesy of Compass
    41. 153 Joralemon Street
      153 Joralemon Street
      Listing Courtesy of Compass
    42. 570 Grand Street
      570 Grand Street
      Listing Courtesy of Weichert Properties
    43. 15 West 53rd Street
      15 West 53rd Street
      Listing Courtesy of Brown Harris Stevens Residential Sales LLC
    44. 36 Balsam Place
      36 Balsam Place
      Listing Courtesy of Compass
    45. 415 East 52nd Street
      415 East 52nd Street
      Listing Courtesy of Compass
    46. 450 West 17th Street
      450 West 17th Street
      Listing Courtesy of Compass
    47. 1 Fifth Avenue
      1 Fifth Avenue
      Listing Courtesy of Compass
    48. 455 East 51st Street
      455 East 51st Street
      Listing Courtesy of Compass
    string(10) "<<<>>>5677"
    ( 193 to 240 of 768 )  
    © HELLER ORGANIZATION 2021 ALL RIGHTS RESERVED
    Equal Housing Opportunity - REBNY