• 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 (77540, 77541, 77542, 77546, 77550, 77552, 77560, 77562, 77568, 77569, 77583, 77594, 77600, 77603, 77608, 77610, 77613, 77617, 77620, 77621, 77629, 77630, 77634, 77657, 77667, 77676, 77677, 77685, 77690, 77691, 77694, 77743, 77842, 76903, 76906, 76907, 76908, 76909, 76910, 76912, 76913, 76914, 76915, 76918, 76920, 76921, 76922, 76923)) ORDER BY FIELD(e.entity_id,77540,77541,77542,77546,77550,77552,77560,77562,77568,77569,77583,77594,77600,77603,77608,77610,77613,77617,77620,77621,77629,77630,77634,77657,77667,77676,77677,77685,77690,77691,77694,77743,77842,76903,76906,76907,76908,76909,76910,76912,76913,76914,76915,76918,76920,76921,76922,76923) "
    1. 15 Central Park West
      15 Central Park West
      Listing Courtesy of Compass
    2. 2098 Frederick Douglass Boulevard
      2098 Frederick Douglass Boulevard
      Listing Courtesy of Compass
    3. 8 West 108th Street
      8 West 108th Street
      Listing Courtesy of Bohemia Realty Group
    4. 455 West 19th Street
      455 West 19th Street
      Listing Courtesy of Corcoran Group
    5. 471 Washington Street
      471 Washington Street
      Listing Courtesy of Sotheby's International Realty, Inc.
    6. 510 Fairview Avenue
      510 Fairview Avenue
      Listing Courtesy of Brown Harris Stevens Residential Sales LLC
    7. 1330 Fifth Avenue
      1330 Fifth Avenue
      Listing Courtesy of Christie's International Real Estate
    8. 54 Montgomery Place
      54 Montgomery Place
      Listing Courtesy of Compass
    9. 252 West 30th Street
      252 West 30th Street
      Listing Courtesy of Sotheby's International Realty, Inc.
    10. 125 Barrow Street
      125 Barrow Street
      Listing Courtesy of The Lion Real Estate
    11. 80 New York Avenue
      80 New York Avenue
      Listing Courtesy of VORO NYC
    12. 50 Gramercy Park North
      50 Gramercy Park North
      Listing Courtesy of Heller Organization, The
    13. 571 Ocean Parkway
      571 Ocean Parkway
      Listing Courtesy of Corcoran Group
    14. 160 Central Park South
      160 Central Park South
      Listing Courtesy of Sotheby's International Realty, Inc.
    15. 1 Main Street
      1 Main Street
      Listing Courtesy of Sotheby's International Realty, Inc.
    16. 456 West 19th Street
      456 West 19th Street
      Listing Courtesy of Douglas Elliman Real Estate
    17. 205 West 57th Street
      205 West 57th Street
      Listing Courtesy of Sotheby's International Realty, Inc.
    18. 160 West 66th Street
      160 West 66th Street
      Listing Courtesy of Brown Harris Stevens Residential Sales LLC
    19. 555 10th Avenue
      555 10th Avenue
      Listing Courtesy of Extell Marketing Group LLC
    20. 215 West 88th Street
      215 West 88th Street
      Listing Courtesy of Douglas Elliman Real Estate
    21. 100 Riverside Boulevard
      100 Riverside Boulevard
      Listing Courtesy of Corcoran Group
    22. 303 East 57th Street
      303 East 57th Street
      Listing Courtesy of Sotheby's International Realty, Inc.
    23. 282 South 5th Street
      282 South 5th Street
      Listing Courtesy of Compass
    24. 300 West 109th Street
      300 West 109th Street
      Listing Courtesy of Douglas Elliman Real Estate
    25. 20 East 68th Street
      20 East 68th Street
      Listing Courtesy of Corcoran Group
    26. 4 East 89th Street
      4 East 89th Street
      Listing Courtesy of Corcoran Group
    27. 4 East 89th Street
      4 East 89th Street
      Listing Courtesy of Corcoran Group
    28. 300 East 23rd Street
      300 East 23rd Street
      Listing Courtesy of Sotheby's International Realty, Inc.
    29. 16 West 76th Street
      16 West 76th Street
      Listing Courtesy of Douglas Elliman Real Estate
    30. 54 West 76th Street
      54 West 76th Street
      Listing Courtesy of Douglas Elliman Real Estate
    31. 109 East 38th Street
      109 East 38th Street
      Listing Courtesy of Douglas Elliman Real Estate
    32. 1965 Broadway
      1965 Broadway
      Listing Courtesy of Douglas Elliman Real Estate
    33. 144 West 82nd Street
      144 West 82nd Street
      Listing Courtesy of Douglas Elliman Real Estate
    34. 111 Murray Street
      111 Murray Street
      Listing Courtesy of Douglas Elliman Real Estate
    35. 445 Fifth Avenue
      445 Fifth Avenue
      Listing Courtesy of R S N Y Realty LLC
    36. 100 Barclay Street
      100 Barclay Street
      Listing Courtesy of Douglas Elliman Real Estate
    37. 20 Pine Street
      20 Pine Street
      Listing Courtesy of Douglas Elliman Real Estate
    38. 145 West 55th Street
      145 West 55th Street
      Listing Courtesy of BOND New York
    39. 266 Wyckoff Avenue
      266 Wyckoff Avenue
      Listing Courtesy of Living Real Estate Group
    40. 214 North 11th Street
      214 North 11th Street
      Listing Courtesy of Compass
    41. 999 Clarkson Avenue
      999 Clarkson Avenue
      Listing Courtesy of Corcoran Group
    42. 141 East 3rd Street
      141 East 3rd Street
      Listing Courtesy of Compass
    43. 290 Third Avenue
      290 Third Avenue
      Listing Courtesy of Mirador Real Estate LLC
    44. 308 Eckford Street
      308 Eckford Street
      Listing Courtesy of Corcoran Group
    45. 710 Fulton Street
      710 Fulton Street
      Listing Courtesy of Compass
    46. 2754 Frederick Douglass Boulevard
      2754 Frederick Douglass Boulevard
      Listing Courtesy of Compass
    47. 52 Spring Street
      52 Spring Street
      Listing Courtesy of Corcoran Group
    48. 176 Woodward Avenue
      176 Woodward Avenue
      Listing Courtesy of Corcoran Group
    string(10) "<<<>>>4469"
    ( 49 to 96 of 768 )  
    © HELLER ORGANIZATION 2021 ALL RIGHTS RESERVED
    Equal Housing Opportunity - REBNY