• 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(2422) "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 (867, 73198, 78552, 78571, 78583, 59495, 59498, 59519, 59527, 59532, 59535, 59537, 59540, 59541, 59545, 59566, 59586, 59588, 59590, 59598, 59599, 59601, 59607, 59608, 59612, 59618, 59620, 59621, 59622, 59626, 59627, 59629, 59631, 59632, 59633, 59634, 59638, 59639, 59643, 59649, 59653, 59657, 59664, 59667, 59671, 59673, 59679, 59680)) ORDER BY FIELD(e.entity_id,867,73198,78552,78571,78583,59495,59498,59519,59527,59532,59535,59537,59540,59541,59545,59566,59586,59588,59590,59598,59599,59601,59607,59608,59612,59618,59620,59621,59622,59626,59627,59629,59631,59632,59633,59634,59638,59639,59643,59649,59653,59657,59664,59667,59671,59673,59679,59680) "
    1. EXCLUSIVE
      CONTRACT SIGNED
      VIDEO
      75 East End Avenue
      75 East End Avenue
       
    2. EXCLUSIVE
      CONTRACT SIGNED
      VIDEO
      11 Fifth Avenue, 6T
      11 Fifth Avenue
       
    3. EXCLUSIVE
      CONTRACT SIGNED
      45 East 30th Street, #5B
      43-45 East 30th Street
       
    4. EXCLUSIVE
      VIDEO
      100 West 18th Street
      100 West 18th Street
       
    5. EXCLUSIVE
      50 Gramercy Park North, #14A
      50 Gramercy Park North
       
    6. 1919 Colden Avenue
      1919 Colden Avenue
      Listing Courtesy of Douglas Elliman Real Estate
    7. 200 East 66th Street
      200 East 66th Street
      Listing Courtesy of Scrimale Realty LLC
    8. 151 Beach 96Th Street
      151 Beach 96Th Street
      Listing Courtesy of Corcoran Group
    9. 40 Mercer Street
      40 Mercer Street
      Listing Courtesy of Dot Realty NYC
    10. 18 Mercer Street
      18 Mercer Street
      Listing Courtesy of Corcoran Group
    11. 3 East 85th Street
      3 East 85th Street
      Listing Courtesy of Compass
    12. 380 Rector Place
      380 Rector Place
      Listing Courtesy of Douglas Elliman Real Estate
    13. 175 West 12th Street
      175 West 12th Street
      Listing Courtesy of Compass
    14. 245 West 14th Street
      245 West 14th Street
      Listing Courtesy of Douglas Elliman Real Estate
    15. 159 East 118th Street
      159 East 118th Street
      Listing Courtesy of Corcoran Group
    16. 101 Warren Street
      101 Warren Street
      Listing Courtesy of Douglas Elliman Real Estate
    17. 1205 Beverley Road
      1205 Beverley Road
      Listing Courtesy of Corcoran Group
    18. 200 East 36th Street
      200 East 36th Street
      Listing Courtesy of Next Stop NY
    19. 551 West 21st Street
      551 West 21st Street
      Listing Courtesy of Compass
    20. 303 East 57th Street
      303 East 57th Street
      Listing Courtesy of Next Stop NY
    21. 80 Riverside Boulevard
      80 Riverside Boulevard
      Listing Courtesy of Compass
    22. 135 Eastern Parkway
      135 Eastern Parkway
      Listing Courtesy of Corcoran Group
    23. 60 East 9th Street
      60 East 9th Street
      Listing Courtesy of Classic Marketing LLC
    24. 415 East 52nd Street
      415 East 52nd Street
      Listing Courtesy of Douglas Elliman Real Estate
    25. 136-18 Maple Avenue
      136-18 Maple Avenue
      Listing Courtesy of Global Real Estate Ventures Group
    26. 305 Second Avenue
      305 Second Avenue
      Listing Courtesy of Brown Harris Stevens Residential Sales LLC
    27. 319 West 18th Street
      319 West 18th Street
      Listing Courtesy of Casa Blanca Real Estate
    28. 284 Fifth Avenue
      284 Fifth Avenue
      Listing Courtesy of City Connections Realty
    29. 132 East 35th Street
      132 East 35th Street
      Listing Courtesy of Douglas Elliman Real Estate
    30. 64 East 111th Street
      64 East 111th Street
      Listing Courtesy of Compass
    31. 845 West End Avenue
      845 West End Avenue
      Listing Courtesy of Compass
    32. 575 Park Avenue
      575 Park Avenue
      Listing Courtesy of Brown Harris Stevens Residential Sales LLC
    33. 338 Berry Street
      338 Berry Street
      Listing Courtesy of Compass
    34. 10 West 66th Street
      10 West 66th Street
      Listing Courtesy of Compass
    35. 203 West 90th Street
      203 West 90th Street
      Listing Courtesy of Compass
    36. 345 Carroll Street
      345 Carroll Street
      Listing Courtesy of Sotheby's International Realty, Inc.
    37. 46-30 Center Boulevard
      46-30 Center Boulevard
      Listing Courtesy of Brown Harris Stevens Residential Sales LLC
    38. 39 Lispenard Street
      39 Lispenard Street
      Listing Courtesy of Brown Harris Stevens Residential Sales LLC
    39. 130 Bradhurst Avenue
      130 Bradhurst Avenue
      Listing Courtesy of The Agency
    40. 250 East 21st Street
      250 East 21st Street
      Listing Courtesy of Douglas Elliman Real Estate
    41. 130 West 30th Street
      130 West 30th Street
      Listing Courtesy of Reserve
    42. 76 Meserole Avenue
      76 Meserole Avenue
      Listing Courtesy of Douglas Elliman Real Estate
    43. 321 East 89th Street
      321 East 89th Street
      Listing Courtesy of Compass
    44. 2 Sutton Place South
      2 Sutton Place South
      Listing Courtesy of Compass
    45. 100 Ocean Parkway
      100 Ocean Parkway
      Listing Courtesy of Corcoran Group
    46. 205 East 78th Street
      205 East 78th Street
      Listing Courtesy of Compass
    47. 140 East 56th Street
      140 East 56th Street
      Listing Courtesy of Sotheby's International Realty, Inc.
    48. 1991 Broadway
      1991 Broadway
      Listing Courtesy of R New York
    string(10) "<<<>>>5679"
    ( 1 to 48 of 768 )  
    © HELLER ORGANIZATION 2021 ALL RIGHTS RESERVED
    Equal Housing Opportunity - REBNY