• 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 (75523, 75524, 75525, 75526, 75527, 75529, 75531, 75532, 75533, 75534, 75535, 75536, 75537, 75542, 75543, 75544, 75545, 75546, 75547, 75549, 75550, 75552, 75553, 75554, 75556, 75559, 75560, 75561, 75562, 75565, 75566, 75567, 75568, 75569, 75571, 75572, 75574, 75575, 75576, 75577, 75580, 75581, 75583, 75584, 75587, 75588, 75589, 75590)) ORDER BY FIELD(e.entity_id,75523,75524,75525,75526,75527,75529,75531,75532,75533,75534,75535,75536,75537,75542,75543,75544,75545,75546,75547,75549,75550,75552,75553,75554,75556,75559,75560,75561,75562,75565,75566,75567,75568,75569,75571,75572,75574,75575,75576,75577,75580,75581,75583,75584,75587,75588,75589,75590) "
    1. 11 Hunts Lane
      11 Hunts Lane
      Listing Courtesy of Corcoran Group
    2. 300 West 55th Street
      300 West 55th Street
      Listing Courtesy of REAL New York
    3. 75 Orchard Street
      75 Orchard Street
      Listing Courtesy of REAL New York
    4. 555 10th Avenue
      555 10th Avenue
      Listing Courtesy of Extell Marketing Group LLC
    5. 108 Waverly Place
      108 Waverly Place
      Listing Courtesy of Brown Harris Stevens Residential Sales LLC
    6. 626 Lincoln Place
      626 Lincoln Place
      Listing Courtesy of Douglas Elliman Real Estate
    7. 165 Ludlow Street
      165 Ludlow Street
      Listing Courtesy of REAL New York
    8. 623 Halsey Street
      623 Halsey Street
      Listing Courtesy of REAL New York
    9. 8 Saint Marks Place
      8 Saint Marks Place
      Listing Courtesy of REAL New York
    10. 167 Ludlow Street
      167 Ludlow Street
      Listing Courtesy of REAL New York
    11. 101 West 12th Street
      101 West 12th Street
      Listing Courtesy of Brown Harris Stevens Residential Sales LLC
    12. 36-20 Steinway Street
      36-20 Steinway Street
      Listing Courtesy of Corcoran Group
    13. 601 West 137th Street
      601 West 137th Street
      Listing Courtesy of Douglas Elliman Real Estate
    14. 203 East 14th Street
      203 East 14th Street
      Listing Courtesy of REAL New York
    15. 167 East 33rd Street
      167 East 33rd Street
      Listing Courtesy of REAL New York
    16. 203 Spring Street
      203 Spring Street
      Listing Courtesy of REAL New York
    17. 485 Manhattan Avenue
      485 Manhattan Avenue
      Listing Courtesy of Corcoran Group
    18. 11-43 45th Avenue
      11-43 45th Avenue
      Listing Courtesy of Douglas Elliman Real Estate
    19. 332 East 9th Street
      332 East 9th Street
      Listing Courtesy of Mirador Real Estate LLC
    20. 31-57 31st Street
      31-57 31st Street
      Listing Courtesy of REAL New York
    21. 55 Greenwich Avenue
      55 Greenwich Avenue
      Listing Courtesy of REAL New York
    22. 355 West 51st Street
      355 West 51st Street
      Listing Courtesy of Corcoran Group
    23. 332 East 9th Street
      332 East 9th Street
      Listing Courtesy of Mirador Real Estate LLC
    24. 247 East 10th Street
      247 East 10th Street
      Listing Courtesy of Platinum Properties
    25. 68 Bradhurst Avenue
      68 Bradhurst Avenue
      Listing Courtesy of Compass
    26. 171 Chrystie Street
      171 Chrystie Street
      Listing Courtesy of REAL New York
    27. 316 West 14th Street
      316 West 14th Street
      Listing Courtesy of REAL New York
    28. 279 East 10th Street
      279 East 10th Street
      Listing Courtesy of REAL New York
    29. 171 Chrystie Street
      171 Chrystie Street
      Listing Courtesy of REAL New York
    30. 680 Fort Washington Ave
      680 Fort Washington Ave
      Listing Courtesy of Brown Harris Stevens Residential Sales LLC
    31. 340 East 23rd Street
      340 East 23rd Street
      Listing Courtesy of Douglas Elliman Real Estate
    32. 324 East 19th Street
      324 East 19th Street
      Listing Courtesy of Corcoran Group
    33. 147 Grand Street
      147 Grand Street
      Listing Courtesy of Platinum Properties
    34. 138 East 50th Street
      138 East 50th Street
      Listing Courtesy of Sotheby's International Realty, Inc.
    35. 237 East 88th Street
      237 East 88th Street
      Listing Courtesy of Sotheby's International Realty, Inc.
    36. 166 Second Avenue
      166 Second Avenue
      Listing Courtesy of BOND New York
    37. 123 Hope Street
      123 Hope Street
      Listing Courtesy of Corcoran Group
    38. 123 Hope Street
      123 Hope Street
      Listing Courtesy of Corcoran Group
    39. 247 North 7th Street
      247 North 7th Street
      Listing Courtesy of Corcoran Group
    40. 460 West 51st Street
      460 West 51st Street
      Listing Courtesy of Sotheby's International Realty, Inc.
    41. 415 East 54th Street
      415 East 54th Street
      Listing Courtesy of Sotheby's International Realty, Inc.
    42. 314 East 41st Street
      314 East 41st Street
      Listing Courtesy of City Connections Realty
    43. 350 Manhattan Avenue
      350 Manhattan Avenue
      Listing Courtesy of Bohemia Realty Group
    44. 124-136 East 117th Street
      124-136 East 117th Street
      Listing Courtesy of MNS
    45. 302 East 90 Street
      302 East 90 Street
      Listing Courtesy of BOND New York
    46. 425 East 65 Street
      425 East 65 Street
      Listing Courtesy of BOND New York
    47. 304 East 90th Street
      304 East 90th Street
      Listing Courtesy of BOND New York
    48. 246 West 22nd Street
      246 West 22nd Street
      Listing Courtesy of BOND New York
    string(10) "<<<>>>4466"
    ( 193 to 240 of 768 )  
    © HELLER ORGANIZATION 2021 ALL RIGHTS RESERVED
    Equal Housing Opportunity - REBNY