• My Account
  • My Wish List
  • Sign In
  • Compare Products
  • Create an Account
Toggle Nav
Cart ()
Menu
Account

  • Rent

  • logo

    • Rent

    • 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 (59551, 59554, 59558, 59562, 59578, 59585, 59587, 59589, 59591, 59592, 59596, 59602, 59624, 59642, 59645, 59646, 59654, 59655, 59662, 59669, 59672, 59677, 59678, 59696, 59699, 59701, 59702, 59717, 59725, 59726, 59731, 59732, 59733, 59739, 59740, 59742, 59785, 59787, 59802, 59805, 59809, 59826, 59827, 59829, 59832, 59833, 59841, 59852)) ORDER BY FIELD(e.entity_id,59551,59554,59558,59562,59578,59585,59587,59589,59591,59592,59596,59602,59624,59642,59645,59646,59654,59655,59662,59669,59672,59677,59678,59696,59699,59701,59702,59717,59725,59726,59731,59732,59733,59739,59740,59742,59785,59787,59802,59805,59809,59826,59827,59829,59832,59833,59841,59852) "
    1. 252 South Street
      252 South Street
      Listing Courtesy of Extell Marketing Group LLC
    2. 139 Spring Street
      139 Spring Street
      Listing Courtesy of Compass
    3. 120 East 29th Street
      120 East 29th Street
      Listing Courtesy of Compass
    4. 415 Central Park West
      415 Central Park West
      Listing Courtesy of Compass
    5. 51 Seventh Avenue South
      51 Seventh Avenue South
      Listing Courtesy of Douglas Elliman Real Estate
    6. 1 Bank Street
      1 Bank Street
      Listing Courtesy of Douglas Elliman Real Estate
    7. 1955 First Avenue
      1955 First Avenue
      Listing Courtesy of BOND New York
    8. 341 East 9th Street
      341 East 9th Street
      Listing Courtesy of Compass
    9. 40 Broad Street
      40 Broad Street
      Listing Courtesy of Compass
    10. 244 West 103rd Street
      244 West 103rd Street
      Listing Courtesy of Compass
    11. 221 East 10th Street
      221 East 10th Street
      Listing Courtesy of Mirador Real Estate LLC
    12. 404 Park Avenue South
      404 Park Avenue South
      Listing Courtesy of Compass
    13. 200 East 66th Street
      200 East 66th Street
      Listing Courtesy of Brown Harris Stevens Residential Sales LLC
    14. 180 West End Avenue
      180 West End Avenue
      Listing Courtesy of Brown Harris Stevens Residential Sales LLC
    15. 354 East 91st Street
      354 East 91st Street
      Listing Courtesy of Serhant
    16. 92-27 160th Street
      92-27 160th Street
      Listing Courtesy of Corcoran Group
    17. 212 East 47th Street
      212 East 47th Street
      Listing Courtesy of Douglas Elliman Real Estate
    18. 108 Reade Street
      108 Reade Street
      Listing Courtesy of Douglas Elliman Real Estate
    19. 150 East 44th Street
      150 East 44th Street
      Listing Courtesy of Rose Associates, Inc.
    20. 188 East 64th Street
      188 East 64th Street
      Listing Courtesy of Brown Harris Stevens Residential Sales LLC
    21. 184 Prince Street
      184 Prince Street
      Listing Courtesy of Choice New York
    22. 158 Franklin Street
      158 Franklin Street
      Listing Courtesy of Douglas Elliman Real Estate
    23. 215 East 68th Street
      215 East 68th Street
      Listing Courtesy of Warburg Realty Partnership, Ltd.
    24. 2 North 6th Place
      2 North 6th Place
      Listing Courtesy of Corcoran Group
    25. 633 East 6th Street
      633 East 6th Street
      Listing Courtesy of BOND New York
    26. 46 West 85th Street
      46 West 85th Street
      Listing Courtesy of BOND New York
    27. 106 Conselyea Street
      106 Conselyea Street
      Listing Courtesy of Compass
    28. 104 West 70th Street
      104 West 70th Street
      Listing Courtesy of Brown Harris Stevens Residential Sales LLC
    29. 71 Nassau Street
      71 Nassau Street
      Listing Courtesy of Compass
    30. 828 EAST 46 STREET
      828 EAST 46 STREET
      Listing Courtesy of Highline Residential
    31. 721 Fifth Avenue
      721 Fifth Avenue
      Listing Courtesy of New York Living Solutions
    32. 130 Fulton Street
      130 Fulton Street
      Listing Courtesy of Brown Harris Stevens Residential Sales LLC
    33. 101 West 24th Street
      101 West 24th Street
      Listing Courtesy of Douglas Elliman Real Estate
    34. 149 East 62nd Street
      149 East 62nd Street
      Listing Courtesy of Compass
    35. 769 Ninth Avenue
      769 Ninth Avenue
      Listing Courtesy of Sotheby's International Realty, Inc.
    36. 462 Greenwich Street
      462 Greenwich Street
      Listing Courtesy of Douglas Elliman Real Estate
    37. 99 Bank Street
      99 Bank Street
      Listing Courtesy of Triumph Property Group
    38. 1952 First Avenue
      1952 First Avenue
      Listing Courtesy of Corcoran Group
    39. 135 Willow Street
      135 Willow Street
      Listing Courtesy of Prevu Real Estate LLC
    40. 58 Strong Place
      58 Strong Place
      Listing Courtesy of Corcoran Group
    41. 129 West 15th Street
      129 West 15th Street
      Listing Courtesy of Douglas Elliman Real Estate
    42. 204 West 10th Street
      204 West 10th Street
      Listing Courtesy of BOND New York
    43. 34-46 Vernon Boulevard
      34-46 Vernon Boulevard
      Listing Courtesy of Serhant
    44. 23 East 22nd Street
      23 East 22nd Street
      Listing Courtesy of Douglas Elliman Real Estate
    45. 269 West 261st Street
      269 West 261st Street
      Listing Courtesy of Corcoran Group
    46. 292 West 137th Street
      292 West 137th Street
      Listing Courtesy of Corcoran Group
    47. 60 West 23rd Street
      60 West 23rd Street
      Listing Courtesy of Mirador Real Estate LLC
    48. 626 First Avenue
      626 First Avenue
      Listing Courtesy of Compass
    string(10) "<<<>>>4472"
    ( 49 to 96 of 768 )  
    © HELLER ORGANIZATION 2021 ALL RIGHTS RESERVED
    Equal Housing Opportunity - REBNY