Properties /

Midtown East Gem

250 East 54th Street, 23D | New York, NY 10022, USA | $1,290,000

1 Bed
1 Bath
1 Half Ba
Washer Dryer
Balcony/Terrace

Move right into this chic, renovated 1-bedroom, 1.5-bath home with floor-to-ceiling windows, a balcony and partial river views as well as open city views in the heart of Midtown East. The pass-through kitchen has brand new stainless steel appliances and a washer/dryer.

The apartment has gorgeous marble floors in the foyer, kitchen and bathrooms, and beautiful oak herringbone hardwood floors in the living room and bedroom. The bathroom has a shower and Jacuzzi tub. Sunlight abounds throughout the apartment. This pet friendly, white glove, full-service condominium has a 24-hour doorman, concierge and on-site resident manager. Additional amenities include bike storage and central laundry. An Equinox fitness club is located in the building and SoulCycle East is next door on 54th Street.

Convenient to all transportation, restaurants, shopping and much more.

Represented By: CORE

corenyc.com | License #: 012345

Taruna Sharma
917-664-2343
Email

Main Office: 104 Fifth Avenue
New York, NY 10011
USA

More About Taruna

View On Map Property Website

Highlighted Properties

Boutique State-of-the-Art Condo in the West Village

385 West 12th Street, 3WEST | New York, NY 10014
$5,000,000

Gramercy Townhouse

243 East 17th Street | New York, NY 10003
$14,500,000

Represented By

Agent Contacts: Taruna Sharma 917-664-2343 | Email

Featured Location

New York, NY, USA

Related Property Listings

Property Search

Bedrooms

Baths

Minimum Price

Maximum Price

History
+
Request History
4 previous requests available
====
Session
+
Session
- 0(null)
====
Request
+
Request

Cake Params
- plugin(null)
- controllerproperties
- actionview
- named(empty)
- pass(array)
  03668
  1250-east-54th-street-23d-new-york-ny-10022-usa
- isAjax(false)
Post data

No post data.

Query string

No querystring data.

Cookie
- 0(empty)
Current Route
- keys(empty)
- options(empty)
- defaults(array)
  controllerproperties
  actionview
  plugin(null)
- template/property-detail/*
====

Sql Log

Sql Logs

default

Total Time: 22 ms
Total Queries: 35 queries

Query	Affected	Num. rows	Took (ms)	Actions
SELECT `Property`.`id`, `Property`.`brokerage_id`, `Property`.`created_by_user_id`, `Property`.`order`, `Property`.`multi_unit`, `Property`.`agent_1_id`, `Property`.`agent_2_id`, `Property`.`agent_3_id`, `Property`.`name`, `Property`.`incomplete`, `Property`.`archived`, `Property`.`last_archived`, `Property`.`auto_archived_from_mlsidx`, `Property`.`paid_featured`, `Property`.`featured`, `Property`.`homepage_featured`, `Property`.`brokerage_page_featured`, `Property`.`requested_homepage_featured_by_member`, `Property`.`homepage_featured_by_member`, `Property`.`dot_luxury_featured`, `Property`.`luxury_feed_featured`, `Property`.`force_luxury_feed_featured`, `Property`.`luxury_autofeed_imported`, `Property`.`luxury_feed_last_added_time`, `Property`.`luxury_feed_agent_user_id`, `Property`.`luxury_feed_locked_to_subscription_id`, `Property`.`luxury_feed_agent_purchase_date`, `Property`.`luxury_feed_agent_expiration_date`, `Property`.`digital_ad_summary_email_last_sent`, `Property`.`digital_ad_summary_price_changed`, `Property`.`wsj_detail_url`, `Property`.`ft_detail_url`, `Property`.`nyt_detail_url`, `Property`.`juwai_detail_url`, `Property`.`pgl_detail_url`, `Property`.`mg_detail_url`, `Property`.`mg_c_detail_url`, `Property`.`mg_s_detail_url`, `Property`.`bp_detail_url`, `Property`.`mw_detail_url`, `Property`.`nikkei_detail_url`, `Property`.`wapo_detail_url`, `Property`.`robb_detail_url`, `Property`.`medium_featured`, `Property`.`large_featured`, `Property`.`detail_page`, `Property`.`description`, `Property`.`address`, `Property`.`address_2`, `Property`.`city`, `Property`.`state`, `Property`.`postal_code`, `Property`.`country`, `Property`.`use_lat_lng_for_google_map`, `Property`.`currency`, `Property`.`price`, `Property`.`price_2`, `Property`.`price_usd`, `Property`.`price_usd_2`, `Property`.`status`, `Property`.`status_last_changed`, `Property`.`status_last_changed_price_only`, `Property`.`lease_period`, `Property`.`price_upon_request`, `Property`.`bedrooms`, `Property`.`bedrooms_2`, `Property`.`bathrooms`, `Property`.`bathrooms_2`, `Property`.`no_beds_baths`, `Property`.`square_feet`, `Property`.`square_meters`, `Property`.`acres`, `Property`.`interior_unit`, `Property`.`interior_size`, `Property`.`lot_unit`, `Property`.`lot_size`, `Property`.`icon_1`, `Property`.`icon_2`, `Property`.`icon_3`, `Property`.`icon_4`, `Property`.`icon_5`, `Property`.`icon_6`, `Property`.`website`, `Property`.`meta_title`, `Property`.`meta_description`, `Property`.`meta_keywords`, `Property`.`bathrooms_partial`, `Property`.`bathrooms_partial_2`, `Property`.`bathrooms_3_4`, `Property`.`bathrooms_3_4_2`, `Property`.`year_built`, `Property`.`virtual_tour`, `Property`.`video_tour`, `Property`.`digital_brochure`, `Property`.`video_tour_embed_code`, `Property`.`digital_brochure_embed_code`, `Property`.`mls_num`, `Property`.`wsj_property_type`, `Property`.`nyt_property_type`, `Property`.`nyt_popular_features`, `Property`.`propgolux_property_type`, `Property`.`juwai_property_type`, `Property`.`juwai_category`, `Property`.`propgolux_property_style`, `Property`.`wapo_property_type`, `Property`.`robb_property_type`, `Property`.`propgolux_location_id_override`, `Property`.`open_house_1_start`, `Property`.`open_house_1_end_time`, `Property`.`latitude`, `Property`.`longitude`, `Property`.`invalid_required_fields`, `Property`.`invalid_optional_fields`, `Property`.`went_live_today`, `Property`.`converted`, `Property`.`invalid`, `Property`.`mlsidx_full_address`, `Property`.`mlsidx_date_listed`, `Property`.`mls_market`, `Property`.`primary_property_category_id`, `Property`.`realstaq_initial_image_sync`, `Property`.`digital_ad_listing_urls_automated`, `Property`.`modified`, `Property`.`created`, `PrimaryPropertyCategory`.`id`, `PrimaryPropertyCategory`.`name`, `PrimaryPropertyCategory`.`created`, `PrimaryPropertyCategory`.`modified`, `Brokerage`.`id`, `Brokerage`.`account_executive_id`, `Brokerage`.`archived`, `Brokerage`.`type`, `Brokerage`.`hide_from_frontend`, `Brokerage`.`agent_brokerage_data_override`, `Brokerage`.`featured_development`, `Brokerage`.`membership_type`, `Brokerage`.`max_properties`, `Brokerage`.`max_homepage_featured_by_member_properties`, `Brokerage`.`featured_properties_sort_method`, `Brokerage`.`lux_feed_mode`, `Brokerage`.`max_luxury_feed_properties`, `Brokerage`.`membership_luxury_feed_properties`, `Brokerage`.`can_participate_in_lux_feed_while_archived`, `Brokerage`.`full_training_video_access`, `Brokerage`.`country_id`, `Brokerage`.`WOEID`, `Brokerage`.`timezone`, `Brokerage`.`luxury_feed_enrollment_mode`, `Brokerage`.`luxury_feed_include_mlsidx_minimum_price`, `Brokerage`.`luxury_feed_include_leverage_minimum_price`, `Brokerage`.`digital_ad_contacts`, `Brokerage`.`add_agents_to_grr_auto_recipients`, `Brokerage`.`mlsidx_id`, `Brokerage`.`mlsidx_lux_autofeed`, `Brokerage`.`mlsidx_lux_autofeed_minimum_price`, `Brokerage`.`mlsidx_logo_url`, `Brokerage`.`mlsidx_disclaimer`, `Brokerage`.`name`, `Brokerage`.`broker_of_record_name`, `Brokerage`.`short_name`, `Brokerage`.`username`, `Brokerage`.`password`, `Brokerage`.`password_reset_hash`, `Brokerage`.`monthly_invoice_amount`, `Brokerage`.`monthly_invoice_start_date`, `Brokerage`.`monthly_invoice_end_date`, `Brokerage`.`contract_filename`, `Brokerage`.`active`, `Brokerage`.`lead_in`, `Brokerage`.`short_description`, `Brokerage`.`description`, `Brokerage`.`communities`, `Brokerage`.`website`, `Brokerage`.`address`, `Brokerage`.`address_2`, `Brokerage`.`city`, `Brokerage`.`state`, `Brokerage`.`full_state`, `Brokerage`.`country`, `Brokerage`.`market`, `Brokerage`.`market_2`, `Brokerage`.`postal_code`, `Brokerage`.`phone`, `Brokerage`.`phone_2`, `Brokerage`.`phone_3`, `Brokerage`.`wide_contact_image`, `Brokerage`.`contact_name`, `Brokerage`.`contact_profile_link`, `Brokerage`.`contact_big_profile_link`, `Brokerage`.`contact_big_profile_link_text`, `Brokerage`.`contact_title`, `Brokerage`.`contact_dre_num`, `Brokerage`.`contact_quote`, `Brokerage`.`contact_email`, `Brokerage`.`contact_facebook`, `Brokerage`.`contact_twitter`, `Brokerage`.`contact_instagram`, `Brokerage`.`contact_pinterest`, `Brokerage`.`contact_linkedin`, `Brokerage`.`contact_youtube`, `Brokerage`.`contact_phone`, `Brokerage`.`contact_email_2`, `Brokerage`.`contact_2_facebook`, `Brokerage`.`contact_2_twitter`, `Brokerage`.`contact_2_instagram`, `Brokerage`.`contact_2_pinterest`, `Brokerage`.`contact_2_linkedin`, `Brokerage`.`contact_2_youtube`, `Brokerage`.`contact_phone_2`, `Brokerage`.`contact_website`, `Brokerage`.`contact_name_2`, `Brokerage`.`contact_profile_link_2`, `Brokerage`.`contact_big_profile_link_2`, `Brokerage`.`contact_big_profile_link_text_2`, `Brokerage`.`contact_title_2`, `Brokerage`.`contact_dre_num_2`, `Brokerage`.`contact_email_3`, `Brokerage`.`contact_name_3`, `Brokerage`.`contact_title_3`, `Brokerage`.`contact_dre_num_3`, `Brokerage`.`contact_phone_3`, `Brokerage`.`contact_3_facebook`, `Brokerage`.`contact_3_twitter`, `Brokerage`.`contact_3_instagram`, `Brokerage`.`contact_3_pinterest`, `Brokerage`.`contact_3_linkedin`, `Brokerage`.`contact_3_youtube`, `Brokerage`.`image_filename`, `Brokerage`.`logo_filename`, `Brokerage`.`contact_image_filename`, `Brokerage`.`all_properties_link_image_filename`, `Brokerage`.`all_properties_link`, `Brokerage`.`video_embed_code`, `Brokerage`.`contact_video_embed_code`, `Brokerage`.`meta_title`, `Brokerage`.`meta_description`, `Brokerage`.`meta_keywords`, `Brokerage`.`login_message_counter`, `Brokerage`.`stats_module_1_type`, `Brokerage`.`stats_module_1_value`, `Brokerage`.`stats_module_2_type`, `Brokerage`.`stats_module_2_value`, `Brokerage`.`stats_module_3_type`, `Brokerage`.`stats_module_3_value`, `Brokerage`.`last_activity_email_sent`, `Brokerage`.`converted`, `Brokerage`.`created`, `Brokerage`.`modified`, `Brokerage`.`dre_num`, `StripeSubscription`.`id`, `StripeSubscription`.`brokerage_id`, `StripeSubscription`.`user_id`, `StripeSubscription`.`property_id`, `StripeSubscription`.`type`, `StripeSubscription`.`stripe_id`, `StripeSubscription`.`stripe_customer_id`, `StripeSubscription`.`stripe_checkout_email`, `StripeSubscription`.`stripe_promotion_code`, `StripeSubscription`.`stripe_promotion_code_id`, `StripeSubscription`.`stripe_coupon_code_id`, `StripeSubscription`.`status`, `StripeSubscription`.`current_period_end`, `StripeSubscription`.`cancel_at_period_end`, `StripeSubscription`.`ended`, `StripeSubscription`.`last_change`, `StripeSubscription`.`last_activity_email_sent`, `StripeSubscription`.`created`, `StripeSubscription`.`modified`, `GlobalReachReport`.`id`, `GlobalReachReport`.`property_id`, `GlobalReachReport`.`wsj_desktop`, `GlobalReachReport`.`wsj_mobile`, `GlobalReachReport`.`wsj_expires`, `GlobalReachReport`.`wsj_capture_started`, `GlobalReachReport`.`mg_desktop`, `GlobalReachReport`.`mg_mobile`, `GlobalReachReport`.`mg_expires`, `GlobalReachReport`.`mg_capture_started`, `GlobalReachReport`.`bp_desktop`, `GlobalReachReport`.`bp_mobile`, `GlobalReachReport`.`bp_expires`, `GlobalReachReport`.`gp_capture_started`, `GlobalReachReport`.`mw_desktop`, `GlobalReachReport`.`mw_mobile`, `GlobalReachReport`.`mw_expires`, `GlobalReachReport`.`mw_capture_started`, `GlobalReachReport`.`ft_desktop`, `GlobalReachReport`.`ft_mobile`, `GlobalReachReport`.`ft_expires`, `GlobalReachReport`.`ft_capture_started`, `GlobalReachReport`.`nikkei_desktop`, `GlobalReachReport`.`nikkei_mobile`, `GlobalReachReport`.`nikkei_expires`, `GlobalReachReport`.`nikkei_capture_started`, `GlobalReachReport`.`pgl_desktop`, `GlobalReachReport`.`pgl_mobile`, `GlobalReachReport`.`pgl_expires`, `GlobalReachReport`.`pgl_capture_started`, `GlobalReachReport`.`robb_desktop`, `GlobalReachReport`.`robb_mobile`, `GlobalReachReport`.`robb_expires`, `GlobalReachReport`.`robb_capture_started`, `GlobalReachReport`.`juwai_desktop`, `GlobalReachReport`.`juwai_mobile`, `GlobalReachReport`.`juwai_expires`, `GlobalReachReport`.`juwai_capture_started`, `GlobalReachReport`.`leverage_desktop`, `GlobalReachReport`.`leverage_mobile`, `GlobalReachReport`.`leverage_expires`, `GlobalReachReport`.`leverage_capture_started`, `GlobalReachReport`.`created`, `GlobalReachReport`.`modified` FROM `leveragere_staging2`.`properties` AS `Property` LEFT JOIN `leveragere_staging2`.`property_categories` AS `PrimaryPropertyCategory` ON (`Property`.`primary_property_category_id` = `PrimaryPropertyCategory`.`id`) LEFT JOIN `leveragere_staging2`.`brokerages` AS `Brokerage` ON (`Property`.`brokerage_id` = `Brokerage`.`id`) LEFT JOIN `leveragere_staging2`.`stripe_subscriptions` AS `StripeSubscription` ON (`StripeSubscription`.`property_id` = `Property`.`id` AND `StripeSubscription`.`status` = 'active') LEFT JOIN `leveragere_staging2`.`global_reach_reports` AS `GlobalReachReport` ON (`GlobalReachReport`.`property_id` = `Property`.`id`) WHERE `Property`.`id` = 3668 AND `Property`.`archived` = '0' AND `Brokerage`.`archived` = '0' AND `Property`.`incomplete` = '0' LIMIT 1	1	1	2	maybe slow
SELECT `AccountExecutive`.`id`, `AccountExecutive`.`type`, `AccountExecutive`.`brokerage_id`, `AccountExecutive`.`email`, `AccountExecutive`.`password`, `AccountExecutive`.`recover_hash`, `AccountExecutive`.`first_name`, `AccountExecutive`.`last_name`, `AccountExecutive`.`title`, `AccountExecutive`.`dre_num`, `AccountExecutive`.`phone`, `AccountExecutive`.`max_luxury_feed_properties`, `AccountExecutive`.`headshot_filename`, `AccountExecutive`.`bio`, `AccountExecutive`.`brokerage_name_override`, `AccountExecutive`.`stripe_customer_id`, `AccountExecutive`.`digital_ad_first_free_month_coupon`, `AccountExecutive`.`modified`, `AccountExecutive`.`created`, `AccountExecutive`.`notified`, (CONCAT(`AccountExecutive`.`first_name`, " ", `AccountExecutive`.`last_name`)) AS `AccountExecutive__full_name` FROM `leveragere_staging2`.`users` AS `AccountExecutive` WHERE `AccountExecutive`.`id` = 235	1	1	0
SELECT `Logo`.`id`, `Logo`.`model`, `Logo`.`model_id`, `Logo`.`tag`, `Logo`.`name`, `Logo`.`type`, `Logo`.`size`, `Logo`.`uri`, `Logo`.`order`, `Logo`.`created`, `Logo`.`modified` FROM `leveragere_staging2`.`assets` AS `Logo` WHERE `Logo`.`model_id` = 16 AND `Logo`.`model` = 'Brokerage' AND `Logo`.`tag` = 'Logo'	1	1	3	maybe slow
SELECT `MainImage`.`id`, `MainImage`.`model`, `MainImage`.`model_id`, `MainImage`.`tag`, `MainImage`.`name`, `MainImage`.`type`, `MainImage`.`size`, `MainImage`.`uri`, `MainImage`.`order`, `MainImage`.`created`, `MainImage`.`modified` FROM `leveragere_staging2`.`assets` AS `MainImage` WHERE `MainImage`.`model_id` = 16 AND `MainImage`.`model` = 'Brokerage' AND `MainImage`.`tag` = 'MainImage'	1	1	2	maybe slow
SELECT `ContactImage`.`id`, `ContactImage`.`model`, `ContactImage`.`model_id`, `ContactImage`.`tag`, `ContactImage`.`name`, `ContactImage`.`type`, `ContactImage`.`size`, `ContactImage`.`uri`, `ContactImage`.`order`, `ContactImage`.`created`, `ContactImage`.`modified` FROM `leveragere_staging2`.`assets` AS `ContactImage` WHERE `ContactImage`.`model_id` = 16 AND `ContactImage`.`model` = 'Brokerage' AND `ContactImage`.`tag` = 'ContactImage'	1	1	4	maybe slow
SELECT `ContactImage2`.`id`, `ContactImage2`.`model`, `ContactImage2`.`model_id`, `ContactImage2`.`tag`, `ContactImage2`.`name`, `ContactImage2`.`type`, `ContactImage2`.`size`, `ContactImage2`.`uri`, `ContactImage2`.`order`, `ContactImage2`.`created`, `ContactImage2`.`modified` FROM `leveragere_staging2`.`assets` AS `ContactImage2` WHERE `ContactImage2`.`model_id` = 16 AND `ContactImage2`.`model` = 'Brokerage' AND `ContactImage2`.`tag` = 'ContactImage2'	0	0	0
SELECT `ContactImage3`.`id`, `ContactImage3`.`model`, `ContactImage3`.`model_id`, `ContactImage3`.`tag`, `ContactImage3`.`name`, `ContactImage3`.`type`, `ContactImage3`.`size`, `ContactImage3`.`uri`, `ContactImage3`.`order`, `ContactImage3`.`created`, `ContactImage3`.`modified` FROM `leveragere_staging2`.`assets` AS `ContactImage3` WHERE `ContactImage3`.`model_id` = 16 AND `ContactImage3`.`model` = 'Brokerage' AND `ContactImage3`.`tag` = 'ContactImage3'	0	0	0
SELECT `BrokerOfRecordLogo`.`id`, `BrokerOfRecordLogo`.`model`, `BrokerOfRecordLogo`.`model_id`, `BrokerOfRecordLogo`.`tag`, `BrokerOfRecordLogo`.`name`, `BrokerOfRecordLogo`.`type`, `BrokerOfRecordLogo`.`size`, `BrokerOfRecordLogo`.`uri`, `BrokerOfRecordLogo`.`order`, `BrokerOfRecordLogo`.`created`, `BrokerOfRecordLogo`.`modified` FROM `leveragere_staging2`.`assets` AS `BrokerOfRecordLogo` WHERE `BrokerOfRecordLogo`.`model_id` = 16 AND `BrokerOfRecordLogo`.`model` = 'Brokerage' AND `BrokerOfRecordLogo`.`tag` = 'BrokerOfRecordLogo'	0	0	0
SELECT `MainArticle`.`id`, `MainArticle`.`model`, `MainArticle`.`model_id`, `MainArticle`.`archived`, `MainArticle`.`medium_featured`, `MainArticle`.`large_featured`, `MainArticle`.`title`, `MainArticle`.`author`, `MainArticle`.`date`, `MainArticle`.`lead_in`, `MainArticle`.`body`, `MainArticle`.`vimeo_id`, `MainArticle`.`created`, `MainArticle`.`modified` FROM `leveragere_staging2`.`articles` AS `MainArticle` WHERE `MainArticle`.`model_id` = 16 AND `MainArticle`.`model` = 'Brokerage'	0	0	0
SELECT `FeaturedImage`.`id`, `FeaturedImage`.`model`, `FeaturedImage`.`model_id`, `FeaturedImage`.`tag`, `FeaturedImage`.`name`, `FeaturedImage`.`type`, `FeaturedImage`.`size`, `FeaturedImage`.`uri`, `FeaturedImage`.`order`, `FeaturedImage`.`created`, `FeaturedImage`.`modified` FROM `leveragere_staging2`.`assets` AS `FeaturedImage` WHERE `FeaturedImage`.`model` = 'Brokerage' AND `FeaturedImage`.`tag` = 'FeaturedImage' AND `FeaturedImage`.`model_id` = (16) ORDER BY `FeaturedImage`.`order` ASC	0	0	0
SELECT `Location`.`id`, `Location`.`parent_id`, `Location`.`brokerage_id`, `Location`.`type`, `Location`.`archived`, `Location`.`use_as_topic`, `Location`.`name`, `Location`.`short_name`, `Location`.`group_index`, `Location`.`latitude`, `Location`.`longitude`, `Location`.`country_code`, `Location`.`north`, `Location`.`south`, `Location`.`east`, `Location`.`west`, `Location`.`zoom`, `Location`.`short_description`, `Location`.`long_description`, `Location`.`created`, `Location`.`modified`, `Location`.`timezone`, `Location`.`population` FROM `leveragere_staging2`.`locations` AS `Location` WHERE `Location`.`brokerage_id` = (16)	1	1	0
SELECT `User`.`id`, `User`.`type`, `User`.`brokerage_id`, `User`.`email`, `User`.`password`, `User`.`recover_hash`, `User`.`first_name`, `User`.`last_name`, `User`.`title`, `User`.`dre_num`, `User`.`phone`, `User`.`max_luxury_feed_properties`, `User`.`headshot_filename`, `User`.`bio`, `User`.`brokerage_name_override`, `User`.`stripe_customer_id`, `User`.`digital_ad_first_free_month_coupon`, `User`.`modified`, `User`.`created`, `User`.`notified`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name` FROM `leveragere_staging2`.`users` AS `User` WHERE `User`.`brokerage_id` = (16)	32	32	0
SELECT `Image`.`id`, `Image`.`model`, `Image`.`model_id`, `Image`.`tag`, `Image`.`name`, `Image`.`type`, `Image`.`size`, `Image`.`uri`, `Image`.`order`, `Image`.`created`, `Image`.`modified` FROM `leveragere_staging2`.`assets` AS `Image` WHERE `Image`.`model` = 'Property' AND `Image`.`tag` = 'Image' AND `Image`.`model_id` = (3668) ORDER BY `Image`.`order` ASC	8	8	0
SELECT `User`.`id`, `User`.`type`, `User`.`brokerage_id`, `User`.`email`, `User`.`password`, `User`.`recover_hash`, `User`.`first_name`, `User`.`last_name`, `User`.`title`, `User`.`dre_num`, `User`.`phone`, `User`.`max_luxury_feed_properties`, `User`.`headshot_filename`, `User`.`bio`, `User`.`brokerage_name_override`, `User`.`stripe_customer_id`, `User`.`digital_ad_first_free_month_coupon`, `User`.`modified`, `User`.`created`, `User`.`notified`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, `UsersProperty`.`id`, `UsersProperty`.`user_id`, `UsersProperty`.`property_id`, `UsersProperty`.`sort_order` FROM `leveragere_staging2`.`users` AS `User` JOIN `leveragere_staging2`.`users_properties` AS `UsersProperty` ON (`UsersProperty`.`property_id` = 3668 AND `UsersProperty`.`user_id` = `User`.`id`) ORDER BY `UsersProperty`.`sort_order` ASC	1	1	1
SELECT `Brokerage`.`id`, `Brokerage`.`account_executive_id`, `Brokerage`.`archived`, `Brokerage`.`type`, `Brokerage`.`hide_from_frontend`, `Brokerage`.`agent_brokerage_data_override`, `Brokerage`.`featured_development`, `Brokerage`.`membership_type`, `Brokerage`.`max_properties`, `Brokerage`.`max_homepage_featured_by_member_properties`, `Brokerage`.`featured_properties_sort_method`, `Brokerage`.`lux_feed_mode`, `Brokerage`.`max_luxury_feed_properties`, `Brokerage`.`membership_luxury_feed_properties`, `Brokerage`.`can_participate_in_lux_feed_while_archived`, `Brokerage`.`full_training_video_access`, `Brokerage`.`country_id`, `Brokerage`.`WOEID`, `Brokerage`.`timezone`, `Brokerage`.`luxury_feed_enrollment_mode`, `Brokerage`.`luxury_feed_include_mlsidx_minimum_price`, `Brokerage`.`luxury_feed_include_leverage_minimum_price`, `Brokerage`.`digital_ad_contacts`, `Brokerage`.`add_agents_to_grr_auto_recipients`, `Brokerage`.`mlsidx_id`, `Brokerage`.`mlsidx_lux_autofeed`, `Brokerage`.`mlsidx_lux_autofeed_minimum_price`, `Brokerage`.`mlsidx_logo_url`, `Brokerage`.`mlsidx_disclaimer`, `Brokerage`.`name`, `Brokerage`.`broker_of_record_name`, `Brokerage`.`short_name`, `Brokerage`.`username`, `Brokerage`.`password`, `Brokerage`.`password_reset_hash`, `Brokerage`.`monthly_invoice_amount`, `Brokerage`.`monthly_invoice_start_date`, `Brokerage`.`monthly_invoice_end_date`, `Brokerage`.`contract_filename`, `Brokerage`.`active`, `Brokerage`.`lead_in`, `Brokerage`.`short_description`, `Brokerage`.`description`, `Brokerage`.`communities`, `Brokerage`.`website`, `Brokerage`.`address`, `Brokerage`.`address_2`, `Brokerage`.`city`, `Brokerage`.`state`, `Brokerage`.`full_state`, `Brokerage`.`country`, `Brokerage`.`market`, `Brokerage`.`market_2`, `Brokerage`.`postal_code`, `Brokerage`.`phone`, `Brokerage`.`phone_2`, `Brokerage`.`phone_3`, `Brokerage`.`wide_contact_image`, `Brokerage`.`contact_name`, `Brokerage`.`contact_profile_link`, `Brokerage`.`contact_big_profile_link`, `Brokerage`.`contact_big_profile_link_text`, `Brokerage`.`contact_title`, `Brokerage`.`contact_dre_num`, `Brokerage`.`contact_quote`, `Brokerage`.`contact_email`, `Brokerage`.`contact_facebook`, `Brokerage`.`contact_twitter`, `Brokerage`.`contact_instagram`, `Brokerage`.`contact_pinterest`, `Brokerage`.`contact_linkedin`, `Brokerage`.`contact_youtube`, `Brokerage`.`contact_phone`, `Brokerage`.`contact_email_2`, `Brokerage`.`contact_2_facebook`, `Brokerage`.`contact_2_twitter`, `Brokerage`.`contact_2_instagram`, `Brokerage`.`contact_2_pinterest`, `Brokerage`.`contact_2_linkedin`, `Brokerage`.`contact_2_youtube`, `Brokerage`.`contact_phone_2`, `Brokerage`.`contact_website`, `Brokerage`.`contact_name_2`, `Brokerage`.`contact_profile_link_2`, `Brokerage`.`contact_big_profile_link_2`, `Brokerage`.`contact_big_profile_link_text_2`, `Brokerage`.`contact_title_2`, `Brokerage`.`contact_dre_num_2`, `Brokerage`.`contact_email_3`, `Brokerage`.`contact_name_3`, `Brokerage`.`contact_title_3`, `Brokerage`.`contact_dre_num_3`, `Brokerage`.`contact_phone_3`, `Brokerage`.`contact_3_facebook`, `Brokerage`.`contact_3_twitter`, `Brokerage`.`contact_3_instagram`, `Brokerage`.`contact_3_pinterest`, `Brokerage`.`contact_3_linkedin`, `Brokerage`.`contact_3_youtube`, `Brokerage`.`image_filename`, `Brokerage`.`logo_filename`, `Brokerage`.`contact_image_filename`, `Brokerage`.`all_properties_link_image_filename`, `Brokerage`.`all_properties_link`, `Brokerage`.`video_embed_code`, `Brokerage`.`contact_video_embed_code`, `Brokerage`.`meta_title`, `Brokerage`.`meta_description`, `Brokerage`.`meta_keywords`, `Brokerage`.`login_message_counter`, `Brokerage`.`stats_module_1_type`, `Brokerage`.`stats_module_1_value`, `Brokerage`.`stats_module_2_type`, `Brokerage`.`stats_module_2_value`, `Brokerage`.`stats_module_3_type`, `Brokerage`.`stats_module_3_value`, `Brokerage`.`last_activity_email_sent`, `Brokerage`.`converted`, `Brokerage`.`created`, `Brokerage`.`modified`, `Brokerage`.`dre_num` FROM `leveragere_staging2`.`brokerages` AS `Brokerage` WHERE `Brokerage`.`id` = 16	1	1	1
SELECT `Image`.`id`, `Image`.`model`, `Image`.`model_id`, `Image`.`tag`, `Image`.`name`, `Image`.`type`, `Image`.`size`, `Image`.`uri`, `Image`.`order`, `Image`.`created`, `Image`.`modified` FROM `leveragere_staging2`.`assets` AS `Image` WHERE `Image`.`model_id` = 1260 AND `Image`.`model` = 'User' AND `Image`.`tag` = 'Image'	0	0	0
SELECT `BrokerageLogoOverride`.`id`, `BrokerageLogoOverride`.`model`, `BrokerageLogoOverride`.`model_id`, `BrokerageLogoOverride`.`tag`, `BrokerageLogoOverride`.`name`, `BrokerageLogoOverride`.`type`, `BrokerageLogoOverride`.`size`, `BrokerageLogoOverride`.`uri`, `BrokerageLogoOverride`.`order`, `BrokerageLogoOverride`.`created`, `BrokerageLogoOverride`.`modified` FROM `leveragere_staging2`.`assets` AS `BrokerageLogoOverride` WHERE `BrokerageLogoOverride`.`model_id` = 1260 AND `BrokerageLogoOverride`.`model` = 'User' AND `BrokerageLogoOverride`.`tag` = 'BrokerageLogoOverride'	0	0	0
SELECT `SecondaryPropertyCategory`.`id`, `SecondaryPropertyCategory`.`name`, `SecondaryPropertyCategory`.`created`, `SecondaryPropertyCategory`.`modified`, `PropertiesSecondaryPropertyCategory`.`id`, `PropertiesSecondaryPropertyCategory`.`property_id`, `PropertiesSecondaryPropertyCategory`.`property_category_id`, `PropertiesSecondaryPropertyCategory`.`created`, `PropertiesSecondaryPropertyCategory`.`modified` FROM `leveragere_staging2`.`property_categories` AS `SecondaryPropertyCategory` JOIN `leveragere_staging2`.`properties_secondary_property_categories` AS `PropertiesSecondaryPropertyCategory` ON (`PropertiesSecondaryPropertyCategory`.`property_id` = 3668 AND `PropertiesSecondaryPropertyCategory`.`property_category_id` = `SecondaryPropertyCategory`.`id`)	0	0	0
SELECT `PropertyFeature`.`id`, `PropertyFeature`.`name`, `PropertyFeature`.`additional`, `PropertyFeature`.`created`, `PropertyFeature`.`modified`, `PropertiesPropertyFeature`.`id`, `PropertiesPropertyFeature`.`property_id`, `PropertiesPropertyFeature`.`property_feature_id` FROM `leveragere_staging2`.`property_features` AS `PropertyFeature` JOIN `leveragere_staging2`.`properties_property_features` AS `PropertiesPropertyFeature` ON (`PropertiesPropertyFeature`.`property_id` = 3668 AND `PropertiesPropertyFeature`.`property_feature_id` = `PropertyFeature`.`id`)	2	2	0
SELECT `Icon`.`id`, `Icon`.`model`, `Icon`.`model_id`, `Icon`.`tag`, `Icon`.`name`, `Icon`.`type`, `Icon`.`size`, `Icon`.`uri`, `Icon`.`order`, `Icon`.`created`, `Icon`.`modified` FROM `leveragere_staging2`.`assets` AS `Icon` WHERE `Icon`.`model_id` = 16 AND `Icon`.`model` = 'PropertyFeature' AND `Icon`.`tag` = 'Icon'	1	1	0
SELECT `Icon`.`id`, `Icon`.`model`, `Icon`.`model_id`, `Icon`.`tag`, `Icon`.`name`, `Icon`.`type`, `Icon`.`size`, `Icon`.`uri`, `Icon`.`order`, `Icon`.`created`, `Icon`.`modified` FROM `leveragere_staging2`.`assets` AS `Icon` WHERE `Icon`.`model_id` = 1 AND `Icon`.`model` = 'PropertyFeature' AND `Icon`.`tag` = 'Icon'	1	1	0
SELECT `Topic`.`id`, `Topic`.`name`, `Topic`.`created`, `Topic`.`modified`, `PropertiesTopic`.`id`, `PropertiesTopic`.`property_id`, `PropertiesTopic`.`topic_id` FROM `leveragere_staging2`.`topics` AS `Topic` JOIN `leveragere_staging2`.`properties_topics` AS `PropertiesTopic` ON (`PropertiesTopic`.`property_id` = 3668 AND `PropertiesTopic`.`topic_id` = `Topic`.`id`)	0	0	0
SELECT `Property`.`id`, `Property`.`brokerage_id`, `Property`.`created_by_user_id`, `Property`.`order`, `Property`.`multi_unit`, `Property`.`agent_1_id`, `Property`.`agent_2_id`, `Property`.`agent_3_id`, `Property`.`name`, `Property`.`incomplete`, `Property`.`archived`, `Property`.`last_archived`, `Property`.`auto_archived_from_mlsidx`, `Property`.`paid_featured`, `Property`.`featured`, `Property`.`homepage_featured`, `Property`.`brokerage_page_featured`, `Property`.`requested_homepage_featured_by_member`, `Property`.`homepage_featured_by_member`, `Property`.`dot_luxury_featured`, `Property`.`luxury_feed_featured`, `Property`.`force_luxury_feed_featured`, `Property`.`luxury_autofeed_imported`, `Property`.`luxury_feed_last_added_time`, `Property`.`luxury_feed_agent_user_id`, `Property`.`luxury_feed_locked_to_subscription_id`, `Property`.`luxury_feed_agent_purchase_date`, `Property`.`luxury_feed_agent_expiration_date`, `Property`.`digital_ad_summary_email_last_sent`, `Property`.`digital_ad_summary_price_changed`, `Property`.`wsj_detail_url`, `Property`.`ft_detail_url`, `Property`.`nyt_detail_url`, `Property`.`juwai_detail_url`, `Property`.`pgl_detail_url`, `Property`.`mg_detail_url`, `Property`.`mg_c_detail_url`, `Property`.`mg_s_detail_url`, `Property`.`bp_detail_url`, `Property`.`mw_detail_url`, `Property`.`nikkei_detail_url`, `Property`.`wapo_detail_url`, `Property`.`robb_detail_url`, `Property`.`medium_featured`, `Property`.`large_featured`, `Property`.`detail_page`, `Property`.`description`, `Property`.`address`, `Property`.`address_2`, `Property`.`city`, `Property`.`state`, `Property`.`postal_code`, `Property`.`country`, `Property`.`use_lat_lng_for_google_map`, `Property`.`currency`, `Property`.`price`, `Property`.`price_2`, `Property`.`price_usd`, `Property`.`price_usd_2`, `Property`.`status`, `Property`.`status_last_changed`, `Property`.`status_last_changed_price_only`, `Property`.`lease_period`, `Property`.`price_upon_request`, `Property`.`bedrooms`, `Property`.`bedrooms_2`, `Property`.`bathrooms`, `Property`.`bathrooms_2`, `Property`.`no_beds_baths`, `Property`.`square_feet`, `Property`.`square_meters`, `Property`.`acres`, `Property`.`interior_unit`, `Property`.`interior_size`, `Property`.`lot_unit`, `Property`.`lot_size`, `Property`.`icon_1`, `Property`.`icon_2`, `Property`.`icon_3`, `Property`.`icon_4`, `Property`.`icon_5`, `Property`.`icon_6`, `Property`.`website`, `Property`.`meta_title`, `Property`.`meta_description`, `Property`.`meta_keywords`, `Property`.`bathrooms_partial`, `Property`.`bathrooms_partial_2`, `Property`.`bathrooms_3_4`, `Property`.`bathrooms_3_4_2`, `Property`.`year_built`, `Property`.`virtual_tour`, `Property`.`video_tour`, `Property`.`digital_brochure`, `Property`.`video_tour_embed_code`, `Property`.`digital_brochure_embed_code`, `Property`.`mls_num`, `Property`.`wsj_property_type`, `Property`.`nyt_property_type`, `Property`.`nyt_popular_features`, `Property`.`propgolux_property_type`, `Property`.`juwai_property_type`, `Property`.`juwai_category`, `Property`.`propgolux_property_style`, `Property`.`wapo_property_type`, `Property`.`robb_property_type`, `Property`.`propgolux_location_id_override`, `Property`.`open_house_1_start`, `Property`.`open_house_1_end_time`, `Property`.`latitude`, `Property`.`longitude`, `Property`.`invalid_required_fields`, `Property`.`invalid_optional_fields`, `Property`.`went_live_today`, `Property`.`converted`, `Property`.`invalid`, `Property`.`mlsidx_full_address`, `Property`.`mlsidx_date_listed`, `Property`.`mls_market`, `Property`.`primary_property_category_id`, `Property`.`realstaq_initial_image_sync`, `Property`.`digital_ad_listing_urls_automated`, `Property`.`modified`, `Property`.`created`, `PrimaryPropertyCategory`.`id`, `PrimaryPropertyCategory`.`name`, `PrimaryPropertyCategory`.`created`, `PrimaryPropertyCategory`.`modified`, `Brokerage`.`id`, `Brokerage`.`account_executive_id`, `Brokerage`.`archived`, `Brokerage`.`type`, `Brokerage`.`hide_from_frontend`, `Brokerage`.`agent_brokerage_data_override`, `Brokerage`.`featured_development`, `Brokerage`.`membership_type`, `Brokerage`.`max_properties`, `Brokerage`.`max_homepage_featured_by_member_properties`, `Brokerage`.`featured_properties_sort_method`, `Brokerage`.`lux_feed_mode`, `Brokerage`.`max_luxury_feed_properties`, `Brokerage`.`membership_luxury_feed_properties`, `Brokerage`.`can_participate_in_lux_feed_while_archived`, `Brokerage`.`full_training_video_access`, `Brokerage`.`country_id`, `Brokerage`.`WOEID`, `Brokerage`.`timezone`, `Brokerage`.`luxury_feed_enrollment_mode`, `Brokerage`.`luxury_feed_include_mlsidx_minimum_price`, `Brokerage`.`luxury_feed_include_leverage_minimum_price`, `Brokerage`.`digital_ad_contacts`, `Brokerage`.`add_agents_to_grr_auto_recipients`, `Brokerage`.`mlsidx_id`, `Brokerage`.`mlsidx_lux_autofeed`, `Brokerage`.`mlsidx_lux_autofeed_minimum_price`, `Brokerage`.`mlsidx_logo_url`, `Brokerage`.`mlsidx_disclaimer`, `Brokerage`.`name`, `Brokerage`.`broker_of_record_name`, `Brokerage`.`short_name`, `Brokerage`.`username`, `Brokerage`.`password`, `Brokerage`.`password_reset_hash`, `Brokerage`.`monthly_invoice_amount`, `Brokerage`.`monthly_invoice_start_date`, `Brokerage`.`monthly_invoice_end_date`, `Brokerage`.`contract_filename`, `Brokerage`.`active`, `Brokerage`.`lead_in`, `Brokerage`.`short_description`, `Brokerage`.`description`, `Brokerage`.`communities`, `Brokerage`.`website`, `Brokerage`.`address`, `Brokerage`.`address_2`, `Brokerage`.`city`, `Brokerage`.`state`, `Brokerage`.`full_state`, `Brokerage`.`country`, `Brokerage`.`market`, `Brokerage`.`market_2`, `Brokerage`.`postal_code`, `Brokerage`.`phone`, `Brokerage`.`phone_2`, `Brokerage`.`phone_3`, `Brokerage`.`wide_contact_image`, `Brokerage`.`contact_name`, `Brokerage`.`contact_profile_link`, `Brokerage`.`contact_big_profile_link`, `Brokerage`.`contact_big_profile_link_text`, `Brokerage`.`contact_title`, `Brokerage`.`contact_dre_num`, `Brokerage`.`contact_quote`, `Brokerage`.`contact_email`, `Brokerage`.`contact_facebook`, `Brokerage`.`contact_twitter`, `Brokerage`.`contact_instagram`, `Brokerage`.`contact_pinterest`, `Brokerage`.`contact_linkedin`, `Brokerage`.`contact_youtube`, `Brokerage`.`contact_phone`, `Brokerage`.`contact_email_2`, `Brokerage`.`contact_2_facebook`, `Brokerage`.`contact_2_twitter`, `Brokerage`.`contact_2_instagram`, `Brokerage`.`contact_2_pinterest`, `Brokerage`.`contact_2_linkedin`, `Brokerage`.`contact_2_youtube`, `Brokerage`.`contact_phone_2`, `Brokerage`.`contact_website`, `Brokerage`.`contact_name_2`, `Brokerage`.`contact_profile_link_2`, `Brokerage`.`contact_big_profile_link_2`, `Brokerage`.`contact_big_profile_link_text_2`, `Brokerage`.`contact_title_2`, `Brokerage`.`contact_dre_num_2`, `Brokerage`.`contact_email_3`, `Brokerage`.`contact_name_3`, `Brokerage`.`contact_title_3`, `Brokerage`.`contact_dre_num_3`, `Brokerage`.`contact_phone_3`, `Brokerage`.`contact_3_facebook`, `Brokerage`.`contact_3_twitter`, `Brokerage`.`contact_3_instagram`, `Brokerage`.`contact_3_pinterest`, `Brokerage`.`contact_3_linkedin`, `Brokerage`.`contact_3_youtube`, `Brokerage`.`image_filename`, `Brokerage`.`logo_filename`, `Brokerage`.`contact_image_filename`, `Brokerage`.`all_properties_link_image_filename`, `Brokerage`.`all_properties_link`, `Brokerage`.`video_embed_code`, `Brokerage`.`contact_video_embed_code`, `Brokerage`.`meta_title`, `Brokerage`.`meta_description`, `Brokerage`.`meta_keywords`, `Brokerage`.`login_message_counter`, `Brokerage`.`stats_module_1_type`, `Brokerage`.`stats_module_1_value`, `Brokerage`.`stats_module_2_type`, `Brokerage`.`stats_module_2_value`, `Brokerage`.`stats_module_3_type`, `Brokerage`.`stats_module_3_value`, `Brokerage`.`last_activity_email_sent`, `Brokerage`.`converted`, `Brokerage`.`created`, `Brokerage`.`modified`, `Brokerage`.`dre_num`, `StripeSubscription`.`id`, `StripeSubscription`.`brokerage_id`, `StripeSubscription`.`user_id`, `StripeSubscription`.`property_id`, `StripeSubscription`.`type`, `StripeSubscription`.`stripe_id`, `StripeSubscription`.`stripe_customer_id`, `StripeSubscription`.`stripe_checkout_email`, `StripeSubscription`.`stripe_promotion_code`, `StripeSubscription`.`stripe_promotion_code_id`, `StripeSubscription`.`stripe_coupon_code_id`, `StripeSubscription`.`status`, `StripeSubscription`.`current_period_end`, `StripeSubscription`.`cancel_at_period_end`, `StripeSubscription`.`ended`, `StripeSubscription`.`last_change`, `StripeSubscription`.`last_activity_email_sent`, `StripeSubscription`.`created`, `StripeSubscription`.`modified`, `GlobalReachReport`.`id`, `GlobalReachReport`.`property_id`, `GlobalReachReport`.`wsj_desktop`, `GlobalReachReport`.`wsj_mobile`, `GlobalReachReport`.`wsj_expires`, `GlobalReachReport`.`wsj_capture_started`, `GlobalReachReport`.`mg_desktop`, `GlobalReachReport`.`mg_mobile`, `GlobalReachReport`.`mg_expires`, `GlobalReachReport`.`mg_capture_started`, `GlobalReachReport`.`bp_desktop`, `GlobalReachReport`.`bp_mobile`, `GlobalReachReport`.`bp_expires`, `GlobalReachReport`.`gp_capture_started`, `GlobalReachReport`.`mw_desktop`, `GlobalReachReport`.`mw_mobile`, `GlobalReachReport`.`mw_expires`, `GlobalReachReport`.`mw_capture_started`, `GlobalReachReport`.`ft_desktop`, `GlobalReachReport`.`ft_mobile`, `GlobalReachReport`.`ft_expires`, `GlobalReachReport`.`ft_capture_started`, `GlobalReachReport`.`nikkei_desktop`, `GlobalReachReport`.`nikkei_mobile`, `GlobalReachReport`.`nikkei_expires`, `GlobalReachReport`.`nikkei_capture_started`, `GlobalReachReport`.`pgl_desktop`, `GlobalReachReport`.`pgl_mobile`, `GlobalReachReport`.`pgl_expires`, `GlobalReachReport`.`pgl_capture_started`, `GlobalReachReport`.`robb_desktop`, `GlobalReachReport`.`robb_mobile`, `GlobalReachReport`.`robb_expires`, `GlobalReachReport`.`robb_capture_started`, `GlobalReachReport`.`juwai_desktop`, `GlobalReachReport`.`juwai_mobile`, `GlobalReachReport`.`juwai_expires`, `GlobalReachReport`.`juwai_capture_started`, `GlobalReachReport`.`leverage_desktop`, `GlobalReachReport`.`leverage_mobile`, `GlobalReachReport`.`leverage_expires`, `GlobalReachReport`.`leverage_capture_started`, `GlobalReachReport`.`created`, `GlobalReachReport`.`modified` FROM `leveragere_staging2`.`properties` AS `Property` LEFT JOIN `leveragere_staging2`.`property_categories` AS `PrimaryPropertyCategory` ON (`Property`.`primary_property_category_id` = `PrimaryPropertyCategory`.`id`) LEFT JOIN `leveragere_staging2`.`brokerages` AS `Brokerage` ON (`Property`.`brokerage_id` = `Brokerage`.`id`) LEFT JOIN `leveragere_staging2`.`stripe_subscriptions` AS `StripeSubscription` ON (`StripeSubscription`.`property_id` = `Property`.`id` AND `StripeSubscription`.`status` = 'active') LEFT JOIN `leveragere_staging2`.`global_reach_reports` AS `GlobalReachReport` ON (`GlobalReachReport`.`property_id` = `Property`.`id`) WHERE `Property`.`archived` = '0' AND `Brokerage`.`archived` = '0' AND `Property`.`id` != 3668 AND `Property`.`brokerage_id` = 16 AND `Property`.`status` != 'Sold' AND `Property`.`incomplete` = '0' ORDER BY RAND() ASC LIMIT 2	2	2	3	maybe slow
SELECT `Image`.`id`, `Image`.`model`, `Image`.`model_id`, `Image`.`tag`, `Image`.`name`, `Image`.`type`, `Image`.`size`, `Image`.`uri`, `Image`.`order`, `Image`.`created`, `Image`.`modified` FROM `leveragere_staging2`.`assets` AS `Image` WHERE `Image`.`model` = 'Property' AND `Image`.`tag` = 'Image' AND `Image`.`model_id` IN (3754, 2990) ORDER BY `Image`.`order` ASC	30	30	1
SELECT `User`.`id`, `User`.`type`, `User`.`brokerage_id`, `User`.`email`, `User`.`password`, `User`.`recover_hash`, `User`.`first_name`, `User`.`last_name`, `User`.`title`, `User`.`dre_num`, `User`.`phone`, `User`.`max_luxury_feed_properties`, `User`.`headshot_filename`, `User`.`bio`, `User`.`brokerage_name_override`, `User`.`stripe_customer_id`, `User`.`digital_ad_first_free_month_coupon`, `User`.`modified`, `User`.`created`, `User`.`notified`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, `UsersProperty`.`id`, `UsersProperty`.`user_id`, `UsersProperty`.`property_id`, `UsersProperty`.`sort_order` FROM `leveragere_staging2`.`users` AS `User` JOIN `leveragere_staging2`.`users_properties` AS `UsersProperty` ON (`UsersProperty`.`property_id` IN (3754, 2990) AND `UsersProperty`.`user_id` = `User`.`id`) ORDER BY `UsersProperty`.`sort_order` ASC	2	2	0
SELECT `SecondaryPropertyCategory`.`id`, `SecondaryPropertyCategory`.`name`, `SecondaryPropertyCategory`.`created`, `SecondaryPropertyCategory`.`modified`, `PropertiesSecondaryPropertyCategory`.`id`, `PropertiesSecondaryPropertyCategory`.`property_id`, `PropertiesSecondaryPropertyCategory`.`property_category_id`, `PropertiesSecondaryPropertyCategory`.`created`, `PropertiesSecondaryPropertyCategory`.`modified` FROM `leveragere_staging2`.`property_categories` AS `SecondaryPropertyCategory` JOIN `leveragere_staging2`.`properties_secondary_property_categories` AS `PropertiesSecondaryPropertyCategory` ON (`PropertiesSecondaryPropertyCategory`.`property_id` IN (3754, 2990) AND `PropertiesSecondaryPropertyCategory`.`property_category_id` = `SecondaryPropertyCategory`.`id`)	0	0	0
SELECT `PropertyFeature`.`id`, `PropertyFeature`.`name`, `PropertyFeature`.`additional`, `PropertyFeature`.`created`, `PropertyFeature`.`modified`, `PropertiesPropertyFeature`.`id`, `PropertiesPropertyFeature`.`property_id`, `PropertiesPropertyFeature`.`property_feature_id` FROM `leveragere_staging2`.`property_features` AS `PropertyFeature` JOIN `leveragere_staging2`.`properties_property_features` AS `PropertiesPropertyFeature` ON (`PropertiesPropertyFeature`.`property_id` IN (3754, 2990) AND `PropertiesPropertyFeature`.`property_feature_id` = `PropertyFeature`.`id`)	1	1	0
SELECT `Topic`.`id`, `Topic`.`name`, `Topic`.`created`, `Topic`.`modified`, `PropertiesTopic`.`id`, `PropertiesTopic`.`property_id`, `PropertiesTopic`.`topic_id` FROM `leveragere_staging2`.`topics` AS `Topic` JOIN `leveragere_staging2`.`properties_topics` AS `PropertiesTopic` ON (`PropertiesTopic`.`property_id` IN (3754, 2990) AND `PropertiesTopic`.`topic_id` = `Topic`.`id`)	0	0	0
SELECT `Location`.`id`, `Location`.`parent_id`, `Location`.`brokerage_id`, `Location`.`type`, `Location`.`archived`, `Location`.`use_as_topic`, `Location`.`name`, `Location`.`short_name`, `Location`.`group_index`, `Location`.`latitude`, `Location`.`longitude`, `Location`.`country_code`, `Location`.`north`, `Location`.`south`, `Location`.`east`, `Location`.`west`, `Location`.`zoom`, `Location`.`short_description`, `Location`.`long_description`, `Location`.`created`, `Location`.`modified`, `Location`.`timezone`, `Location`.`population`, `Brokerage`.`id`, `Brokerage`.`account_executive_id`, `Brokerage`.`archived`, `Brokerage`.`type`, `Brokerage`.`hide_from_frontend`, `Brokerage`.`agent_brokerage_data_override`, `Brokerage`.`featured_development`, `Brokerage`.`membership_type`, `Brokerage`.`max_properties`, `Brokerage`.`max_homepage_featured_by_member_properties`, `Brokerage`.`featured_properties_sort_method`, `Brokerage`.`lux_feed_mode`, `Brokerage`.`max_luxury_feed_properties`, `Brokerage`.`membership_luxury_feed_properties`, `Brokerage`.`can_participate_in_lux_feed_while_archived`, `Brokerage`.`full_training_video_access`, `Brokerage`.`country_id`, `Brokerage`.`WOEID`, `Brokerage`.`timezone`, `Brokerage`.`luxury_feed_enrollment_mode`, `Brokerage`.`luxury_feed_include_mlsidx_minimum_price`, `Brokerage`.`luxury_feed_include_leverage_minimum_price`, `Brokerage`.`digital_ad_contacts`, `Brokerage`.`add_agents_to_grr_auto_recipients`, `Brokerage`.`mlsidx_id`, `Brokerage`.`mlsidx_lux_autofeed`, `Brokerage`.`mlsidx_lux_autofeed_minimum_price`, `Brokerage`.`mlsidx_logo_url`, `Brokerage`.`mlsidx_disclaimer`, `Brokerage`.`name`, `Brokerage`.`broker_of_record_name`, `Brokerage`.`short_name`, `Brokerage`.`username`, `Brokerage`.`password`, `Brokerage`.`password_reset_hash`, `Brokerage`.`monthly_invoice_amount`, `Brokerage`.`monthly_invoice_start_date`, `Brokerage`.`monthly_invoice_end_date`, `Brokerage`.`contract_filename`, `Brokerage`.`active`, `Brokerage`.`lead_in`, `Brokerage`.`short_description`, `Brokerage`.`description`, `Brokerage`.`communities`, `Brokerage`.`website`, `Brokerage`.`address`, `Brokerage`.`address_2`, `Brokerage`.`city`, `Brokerage`.`state`, `Brokerage`.`full_state`, `Brokerage`.`country`, `Brokerage`.`market`, `Brokerage`.`market_2`, `Brokerage`.`postal_code`, `Brokerage`.`phone`, `Brokerage`.`phone_2`, `Brokerage`.`phone_3`, `Brokerage`.`wide_contact_image`, `Brokerage`.`contact_name`, `Brokerage`.`contact_profile_link`, `Brokerage`.`contact_big_profile_link`, `Brokerage`.`contact_big_profile_link_text`, `Brokerage`.`contact_title`, `Brokerage`.`contact_dre_num`, `Brokerage`.`contact_quote`, `Brokerage`.`contact_email`, `Brokerage`.`contact_facebook`, `Brokerage`.`contact_twitter`, `Brokerage`.`contact_instagram`, `Brokerage`.`contact_pinterest`, `Brokerage`.`contact_linkedin`, `Brokerage`.`contact_youtube`, `Brokerage`.`contact_phone`, `Brokerage`.`contact_email_2`, `Brokerage`.`contact_2_facebook`, `Brokerage`.`contact_2_twitter`, `Brokerage`.`contact_2_instagram`, `Brokerage`.`contact_2_pinterest`, `Brokerage`.`contact_2_linkedin`, `Brokerage`.`contact_2_youtube`, `Brokerage`.`contact_phone_2`, `Brokerage`.`contact_website`, `Brokerage`.`contact_name_2`, `Brokerage`.`contact_profile_link_2`, `Brokerage`.`contact_big_profile_link_2`, `Brokerage`.`contact_big_profile_link_text_2`, `Brokerage`.`contact_title_2`, `Brokerage`.`contact_dre_num_2`, `Brokerage`.`contact_email_3`, `Brokerage`.`contact_name_3`, `Brokerage`.`contact_title_3`, `Brokerage`.`contact_dre_num_3`, `Brokerage`.`contact_phone_3`, `Brokerage`.`contact_3_facebook`, `Brokerage`.`contact_3_twitter`, `Brokerage`.`contact_3_instagram`, `Brokerage`.`contact_3_pinterest`, `Brokerage`.`contact_3_linkedin`, `Brokerage`.`contact_3_youtube`, `Brokerage`.`image_filename`, `Brokerage`.`logo_filename`, `Brokerage`.`contact_image_filename`, `Brokerage`.`all_properties_link_image_filename`, `Brokerage`.`all_properties_link`, `Brokerage`.`video_embed_code`, `Brokerage`.`contact_video_embed_code`, `Brokerage`.`meta_title`, `Brokerage`.`meta_description`, `Brokerage`.`meta_keywords`, `Brokerage`.`login_message_counter`, `Brokerage`.`stats_module_1_type`, `Brokerage`.`stats_module_1_value`, `Brokerage`.`stats_module_2_type`, `Brokerage`.`stats_module_2_value`, `Brokerage`.`stats_module_3_type`, `Brokerage`.`stats_module_3_value`, `Brokerage`.`last_activity_email_sent`, `Brokerage`.`converted`, `Brokerage`.`created`, `Brokerage`.`modified`, `Brokerage`.`dre_num`, `Image`.`id`, `Image`.`model`, `Image`.`model_id`, `Image`.`tag`, `Image`.`name`, `Image`.`type`, `Image`.`size`, `Image`.`uri`, `Image`.`order`, `Image`.`created`, `Image`.`modified` FROM `leveragere_staging2`.`locations` AS `Location` LEFT JOIN `leveragere_staging2`.`brokerages` AS `Brokerage` ON (`Location`.`brokerage_id` = `Brokerage`.`id`) LEFT JOIN `leveragere_staging2`.`assets` AS `Image` ON (`Image`.`model_id` = `Location`.`id` AND `Image`.`model` = 'Location' AND `Image`.`tag` = 'Image') WHERE `Location`.`archived` = '0' AND `Location`.`brokerage_id` = 16 LIMIT 1	1	1	1
SELECT `Property`.`id`, `Property`.`brokerage_id`, `Property`.`created_by_user_id`, `Property`.`order`, `Property`.`multi_unit`, `Property`.`agent_1_id`, `Property`.`agent_2_id`, `Property`.`agent_3_id`, `Property`.`name`, `Property`.`incomplete`, `Property`.`archived`, `Property`.`last_archived`, `Property`.`auto_archived_from_mlsidx`, `Property`.`paid_featured`, `Property`.`featured`, `Property`.`homepage_featured`, `Property`.`brokerage_page_featured`, `Property`.`requested_homepage_featured_by_member`, `Property`.`homepage_featured_by_member`, `Property`.`dot_luxury_featured`, `Property`.`luxury_feed_featured`, `Property`.`force_luxury_feed_featured`, `Property`.`luxury_autofeed_imported`, `Property`.`luxury_feed_last_added_time`, `Property`.`luxury_feed_agent_user_id`, `Property`.`luxury_feed_locked_to_subscription_id`, `Property`.`luxury_feed_agent_purchase_date`, `Property`.`luxury_feed_agent_expiration_date`, `Property`.`digital_ad_summary_email_last_sent`, `Property`.`digital_ad_summary_price_changed`, `Property`.`wsj_detail_url`, `Property`.`ft_detail_url`, `Property`.`nyt_detail_url`, `Property`.`juwai_detail_url`, `Property`.`pgl_detail_url`, `Property`.`mg_detail_url`, `Property`.`mg_c_detail_url`, `Property`.`mg_s_detail_url`, `Property`.`bp_detail_url`, `Property`.`mw_detail_url`, `Property`.`nikkei_detail_url`, `Property`.`wapo_detail_url`, `Property`.`robb_detail_url`, `Property`.`medium_featured`, `Property`.`large_featured`, `Property`.`detail_page`, `Property`.`description`, `Property`.`address`, `Property`.`address_2`, `Property`.`city`, `Property`.`state`, `Property`.`postal_code`, `Property`.`country`, `Property`.`use_lat_lng_for_google_map`, `Property`.`currency`, `Property`.`price`, `Property`.`price_2`, `Property`.`price_usd`, `Property`.`price_usd_2`, `Property`.`status`, `Property`.`status_last_changed`, `Property`.`status_last_changed_price_only`, `Property`.`lease_period`, `Property`.`price_upon_request`, `Property`.`bedrooms`, `Property`.`bedrooms_2`, `Property`.`bathrooms`, `Property`.`bathrooms_2`, `Property`.`no_beds_baths`, `Property`.`square_feet`, `Property`.`square_meters`, `Property`.`acres`, `Property`.`interior_unit`, `Property`.`interior_size`, `Property`.`lot_unit`, `Property`.`lot_size`, `Property`.`icon_1`, `Property`.`icon_2`, `Property`.`icon_3`, `Property`.`icon_4`, `Property`.`icon_5`, `Property`.`icon_6`, `Property`.`website`, `Property`.`meta_title`, `Property`.`meta_description`, `Property`.`meta_keywords`, `Property`.`bathrooms_partial`, `Property`.`bathrooms_partial_2`, `Property`.`bathrooms_3_4`, `Property`.`bathrooms_3_4_2`, `Property`.`year_built`, `Property`.`virtual_tour`, `Property`.`video_tour`, `Property`.`digital_brochure`, `Property`.`video_tour_embed_code`, `Property`.`digital_brochure_embed_code`, `Property`.`mls_num`, `Property`.`wsj_property_type`, `Property`.`nyt_property_type`, `Property`.`nyt_popular_features`, `Property`.`propgolux_property_type`, `Property`.`juwai_property_type`, `Property`.`juwai_category`, `Property`.`propgolux_property_style`, `Property`.`wapo_property_type`, `Property`.`robb_property_type`, `Property`.`propgolux_location_id_override`, `Property`.`open_house_1_start`, `Property`.`open_house_1_end_time`, `Property`.`latitude`, `Property`.`longitude`, `Property`.`invalid_required_fields`, `Property`.`invalid_optional_fields`, `Property`.`went_live_today`, `Property`.`converted`, `Property`.`invalid`, `Property`.`mlsidx_full_address`, `Property`.`mlsidx_date_listed`, `Property`.`mls_market`, `Property`.`primary_property_category_id`, `Property`.`realstaq_initial_image_sync`, `Property`.`digital_ad_listing_urls_automated`, `Property`.`modified`, `Property`.`created`, `PrimaryPropertyCategory`.`id`, `PrimaryPropertyCategory`.`name`, `PrimaryPropertyCategory`.`created`, `PrimaryPropertyCategory`.`modified`, `Brokerage`.`id`, `Brokerage`.`account_executive_id`, `Brokerage`.`archived`, `Brokerage`.`type`, `Brokerage`.`hide_from_frontend`, `Brokerage`.`agent_brokerage_data_override`, `Brokerage`.`featured_development`, `Brokerage`.`membership_type`, `Brokerage`.`max_properties`, `Brokerage`.`max_homepage_featured_by_member_properties`, `Brokerage`.`featured_properties_sort_method`, `Brokerage`.`lux_feed_mode`, `Brokerage`.`max_luxury_feed_properties`, `Brokerage`.`membership_luxury_feed_properties`, `Brokerage`.`can_participate_in_lux_feed_while_archived`, `Brokerage`.`full_training_video_access`, `Brokerage`.`country_id`, `Brokerage`.`WOEID`, `Brokerage`.`timezone`, `Brokerage`.`luxury_feed_enrollment_mode`, `Brokerage`.`luxury_feed_include_mlsidx_minimum_price`, `Brokerage`.`luxury_feed_include_leverage_minimum_price`, `Brokerage`.`digital_ad_contacts`, `Brokerage`.`add_agents_to_grr_auto_recipients`, `Brokerage`.`mlsidx_id`, `Brokerage`.`mlsidx_lux_autofeed`, `Brokerage`.`mlsidx_lux_autofeed_minimum_price`, `Brokerage`.`mlsidx_logo_url`, `Brokerage`.`mlsidx_disclaimer`, `Brokerage`.`name`, `Brokerage`.`broker_of_record_name`, `Brokerage`.`short_name`, `Brokerage`.`username`, `Brokerage`.`password`, `Brokerage`.`password_reset_hash`, `Brokerage`.`monthly_invoice_amount`, `Brokerage`.`monthly_invoice_start_date`, `Brokerage`.`monthly_invoice_end_date`, `Brokerage`.`contract_filename`, `Brokerage`.`active`, `Brokerage`.`lead_in`, `Brokerage`.`short_description`, `Brokerage`.`description`, `Brokerage`.`communities`, `Brokerage`.`website`, `Brokerage`.`address`, `Brokerage`.`address_2`, `Brokerage`.`city`, `Brokerage`.`state`, `Brokerage`.`full_state`, `Brokerage`.`country`, `Brokerage`.`market`, `Brokerage`.`market_2`, `Brokerage`.`postal_code`, `Brokerage`.`phone`, `Brokerage`.`phone_2`, `Brokerage`.`phone_3`, `Brokerage`.`wide_contact_image`, `Brokerage`.`contact_name`, `Brokerage`.`contact_profile_link`, `Brokerage`.`contact_big_profile_link`, `Brokerage`.`contact_big_profile_link_text`, `Brokerage`.`contact_title`, `Brokerage`.`contact_dre_num`, `Brokerage`.`contact_quote`, `Brokerage`.`contact_email`, `Brokerage`.`contact_facebook`, `Brokerage`.`contact_twitter`, `Brokerage`.`contact_instagram`, `Brokerage`.`contact_pinterest`, `Brokerage`.`contact_linkedin`, `Brokerage`.`contact_youtube`, `Brokerage`.`contact_phone`, `Brokerage`.`contact_email_2`, `Brokerage`.`contact_2_facebook`, `Brokerage`.`contact_2_twitter`, `Brokerage`.`contact_2_instagram`, `Brokerage`.`contact_2_pinterest`, `Brokerage`.`contact_2_linkedin`, `Brokerage`.`contact_2_youtube`, `Brokerage`.`contact_phone_2`, `Brokerage`.`contact_website`, `Brokerage`.`contact_name_2`, `Brokerage`.`contact_profile_link_2`, `Brokerage`.`contact_big_profile_link_2`, `Brokerage`.`contact_big_profile_link_text_2`, `Brokerage`.`contact_title_2`, `Brokerage`.`contact_dre_num_2`, `Brokerage`.`contact_email_3`, `Brokerage`.`contact_name_3`, `Brokerage`.`contact_title_3`, `Brokerage`.`contact_dre_num_3`, `Brokerage`.`contact_phone_3`, `Brokerage`.`contact_3_facebook`, `Brokerage`.`contact_3_twitter`, `Brokerage`.`contact_3_instagram`, `Brokerage`.`contact_3_pinterest`, `Brokerage`.`contact_3_linkedin`, `Brokerage`.`contact_3_youtube`, `Brokerage`.`image_filename`, `Brokerage`.`logo_filename`, `Brokerage`.`contact_image_filename`, `Brokerage`.`all_properties_link_image_filename`, `Brokerage`.`all_properties_link`, `Brokerage`.`video_embed_code`, `Brokerage`.`contact_video_embed_code`, `Brokerage`.`meta_title`, `Brokerage`.`meta_description`, `Brokerage`.`meta_keywords`, `Brokerage`.`login_message_counter`, `Brokerage`.`stats_module_1_type`, `Brokerage`.`stats_module_1_value`, `Brokerage`.`stats_module_2_type`, `Brokerage`.`stats_module_2_value`, `Brokerage`.`stats_module_3_type`, `Brokerage`.`stats_module_3_value`, `Brokerage`.`last_activity_email_sent`, `Brokerage`.`converted`, `Brokerage`.`created`, `Brokerage`.`modified`, `Brokerage`.`dre_num`, `StripeSubscription`.`id`, `StripeSubscription`.`brokerage_id`, `StripeSubscription`.`user_id`, `StripeSubscription`.`property_id`, `StripeSubscription`.`type`, `StripeSubscription`.`stripe_id`, `StripeSubscription`.`stripe_customer_id`, `StripeSubscription`.`stripe_checkout_email`, `StripeSubscription`.`stripe_promotion_code`, `StripeSubscription`.`stripe_promotion_code_id`, `StripeSubscription`.`stripe_coupon_code_id`, `StripeSubscription`.`status`, `StripeSubscription`.`current_period_end`, `StripeSubscription`.`cancel_at_period_end`, `StripeSubscription`.`ended`, `StripeSubscription`.`last_change`, `StripeSubscription`.`last_activity_email_sent`, `StripeSubscription`.`created`, `StripeSubscription`.`modified`, `GlobalReachReport`.`id`, `GlobalReachReport`.`property_id`, `GlobalReachReport`.`wsj_desktop`, `GlobalReachReport`.`wsj_mobile`, `GlobalReachReport`.`wsj_expires`, `GlobalReachReport`.`wsj_capture_started`, `GlobalReachReport`.`mg_desktop`, `GlobalReachReport`.`mg_mobile`, `GlobalReachReport`.`mg_expires`, `GlobalReachReport`.`mg_capture_started`, `GlobalReachReport`.`bp_desktop`, `GlobalReachReport`.`bp_mobile`, `GlobalReachReport`.`bp_expires`, `GlobalReachReport`.`gp_capture_started`, `GlobalReachReport`.`mw_desktop`, `GlobalReachReport`.`mw_mobile`, `GlobalReachReport`.`mw_expires`, `GlobalReachReport`.`mw_capture_started`, `GlobalReachReport`.`ft_desktop`, `GlobalReachReport`.`ft_mobile`, `GlobalReachReport`.`ft_expires`, `GlobalReachReport`.`ft_capture_started`, `GlobalReachReport`.`nikkei_desktop`, `GlobalReachReport`.`nikkei_mobile`, `GlobalReachReport`.`nikkei_expires`, `GlobalReachReport`.`nikkei_capture_started`, `GlobalReachReport`.`pgl_desktop`, `GlobalReachReport`.`pgl_mobile`, `GlobalReachReport`.`pgl_expires`, `GlobalReachReport`.`pgl_capture_started`, `GlobalReachReport`.`robb_desktop`, `GlobalReachReport`.`robb_mobile`, `GlobalReachReport`.`robb_expires`, `GlobalReachReport`.`robb_capture_started`, `GlobalReachReport`.`juwai_desktop`, `GlobalReachReport`.`juwai_mobile`, `GlobalReachReport`.`juwai_expires`, `GlobalReachReport`.`juwai_capture_started`, `GlobalReachReport`.`leverage_desktop`, `GlobalReachReport`.`leverage_mobile`, `GlobalReachReport`.`leverage_expires`, `GlobalReachReport`.`leverage_capture_started`, `GlobalReachReport`.`created`, `GlobalReachReport`.`modified` FROM `leveragere_staging2`.`properties` AS `Property` LEFT JOIN `leveragere_staging2`.`property_categories` AS `PrimaryPropertyCategory` ON (`Property`.`primary_property_category_id` = `PrimaryPropertyCategory`.`id`) LEFT JOIN `leveragere_staging2`.`brokerages` AS `Brokerage` ON (`Property`.`brokerage_id` = `Brokerage`.`id`) LEFT JOIN `leveragere_staging2`.`stripe_subscriptions` AS `StripeSubscription` ON (`StripeSubscription`.`property_id` = `Property`.`id` AND `StripeSubscription`.`status` = 'active') LEFT JOIN `leveragere_staging2`.`global_reach_reports` AS `GlobalReachReport` ON (`GlobalReachReport`.`property_id` = `Property`.`id`) WHERE `Property`.`archived` = '0' AND `Brokerage`.`archived` = '0' AND `Property`.`brokerage_id` = 16 AND `Property`.`incomplete` = '0' ORDER BY RAND() ASC LIMIT 4	4	4	3	maybe slow
SELECT `Image`.`id`, `Image`.`model`, `Image`.`model_id`, `Image`.`tag`, `Image`.`name`, `Image`.`type`, `Image`.`size`, `Image`.`uri`, `Image`.`order`, `Image`.`created`, `Image`.`modified` FROM `leveragere_staging2`.`assets` AS `Image` WHERE `Image`.`model` = 'Property' AND `Image`.`tag` = 'Image' AND `Image`.`model_id` IN (3668, 3670, 3669, 3460) ORDER BY `Image`.`order` ASC	33	33	1
SELECT `User`.`id`, `User`.`type`, `User`.`brokerage_id`, `User`.`email`, `User`.`password`, `User`.`recover_hash`, `User`.`first_name`, `User`.`last_name`, `User`.`title`, `User`.`dre_num`, `User`.`phone`, `User`.`max_luxury_feed_properties`, `User`.`headshot_filename`, `User`.`bio`, `User`.`brokerage_name_override`, `User`.`stripe_customer_id`, `User`.`digital_ad_first_free_month_coupon`, `User`.`modified`, `User`.`created`, `User`.`notified`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, `UsersProperty`.`id`, `UsersProperty`.`user_id`, `UsersProperty`.`property_id`, `UsersProperty`.`sort_order` FROM `leveragere_staging2`.`users` AS `User` JOIN `leveragere_staging2`.`users_properties` AS `UsersProperty` ON (`UsersProperty`.`property_id` IN (3668, 3670, 3669, 3460) AND `UsersProperty`.`user_id` = `User`.`id`) ORDER BY `UsersProperty`.`sort_order` ASC	5	5	0
SELECT `SecondaryPropertyCategory`.`id`, `SecondaryPropertyCategory`.`name`, `SecondaryPropertyCategory`.`created`, `SecondaryPropertyCategory`.`modified`, `PropertiesSecondaryPropertyCategory`.`id`, `PropertiesSecondaryPropertyCategory`.`property_id`, `PropertiesSecondaryPropertyCategory`.`property_category_id`, `PropertiesSecondaryPropertyCategory`.`created`, `PropertiesSecondaryPropertyCategory`.`modified` FROM `leveragere_staging2`.`property_categories` AS `SecondaryPropertyCategory` JOIN `leveragere_staging2`.`properties_secondary_property_categories` AS `PropertiesSecondaryPropertyCategory` ON (`PropertiesSecondaryPropertyCategory`.`property_id` IN (3668, 3670, 3669, 3460) AND `PropertiesSecondaryPropertyCategory`.`property_category_id` = `SecondaryPropertyCategory`.`id`)	0	0	0
SELECT `PropertyFeature`.`id`, `PropertyFeature`.`name`, `PropertyFeature`.`additional`, `PropertyFeature`.`created`, `PropertyFeature`.`modified`, `PropertiesPropertyFeature`.`id`, `PropertiesPropertyFeature`.`property_id`, `PropertiesPropertyFeature`.`property_feature_id` FROM `leveragere_staging2`.`property_features` AS `PropertyFeature` JOIN `leveragere_staging2`.`properties_property_features` AS `PropertiesPropertyFeature` ON (`PropertiesPropertyFeature`.`property_id` IN (3668, 3670, 3669, 3460) AND `PropertiesPropertyFeature`.`property_feature_id` = `PropertyFeature`.`id`)	7	7	0
SELECT `Topic`.`id`, `Topic`.`name`, `Topic`.`created`, `Topic`.`modified`, `PropertiesTopic`.`id`, `PropertiesTopic`.`property_id`, `PropertiesTopic`.`topic_id` FROM `leveragere_staging2`.`topics` AS `Topic` JOIN `leveragere_staging2`.`properties_topics` AS `PropertiesTopic` ON (`PropertiesTopic`.`property_id` IN (3668, 3670, 3669, 3460) AND `PropertiesTopic`.`topic_id` = `Topic`.`id`)	1	1	0

Query Explain:

Click an "Explain" link above, to see the query explanation.

====

Timer

Memory

Peak Memory Use 14.39 MB

Message	Memory use
Component initialization	3.09 MB
Controller action start	4.02 MB
Controller render start	6.96 MB
View render complete	7.48 MB

Timers

Total Request Time: 346 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	99.47
Event: Controller.initialize	6.42
Event: Controller.startup	1.62
Controller action	77.07
Event: Controller.beforeRender	23.03
» Processing toolbar data	22.93
Rendering View	81.56
» Event: View.beforeRender	0.28
» Rendering APP/View/Properties/view.ctp	4.08
» » Rendering APP/View/Elements/static_property_price.ctp	0.42
» » Rendering APP/View/Elements/property_features.ctp	0.28
» » Rendering APP/View/Elements/static_property_price.ctp #2	0.16
» » Rendering APP/View/Elements/static_property_price.ctp #3	0.14
» » Rendering APP/View/Elements/sidebar/location_list.ctp	0.15
» » Rendering APP/View/Elements/sidebar/property_list.ctp	1.49
» » » Rendering APP/View/Elements/static_property_price.ctp #4	0.22
» » » Rendering APP/View/Elements/static_property_price.ctp #5	0.22
» » » Rendering APP/View/Elements/static_property_price.ctp #6	0.24
» » » Rendering APP/View/Elements/static_property_price.ctp #7	0.21
» » Rendering APP/View/Elements/sidebar/property_search.ctp	0.30
» Event: View.afterRender	0.01
» Event: View.beforeLayout	0.01
» Rendering APP/View/Layouts/front.ctp	76.31
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- sidebar_properties(array)
 0(array)
 Property(array)
 id3668
 brokerage_id16
 created_by_user_id0
 order7
 multi_unit(false)
 agent_1_id1207
 agent_2_id0
 agent_3_id0
 nameMidtown East Gem
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(true)
 homepage_featured(false)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(false)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(false)
 detail_page(true)
 descriptionMove right into this chic, renovated 1-bedroom, 1.5-bath home with floor-to-ceiling windows, a balcony and partial river views as well as open city views in the heart of Midtown East. The pass-through kitchen has brand new stainless steel appliances and a washer/dryer. The apartment has gorgeous marble floors in the foyer, kitchen and bathrooms, and beautiful oak herringbone hardwood floors in the living room and bedroom. The bathroom has a shower and Jacuzzi tub. Sunlight abounds throughout the apartment. This pet friendly, white glove, full-service condominium has a 24-hour doorman, concierge and on-site resident manager. Additional amenities include bike storage and central laundry. An Equinox fitness club is located in the building and SoulCycle East is next door on 54th Street. Convenient to all transportation, restaurants, shopping and much more.
 address250 East 54th Street, 23D
 address_2
 cityNew York
 stateNY
 postal_code10022
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price1290000
 price_20
 price_usd1290000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms1
 bedrooms_20
 bathrooms1
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1washer-dryer
 icon_2balcony-terrace
 icon_3
 icon_4
 icon_5
 icon_6
 websitehttp://corenyc.com/250-east-54th-street-23d
 meta_titleMidtown East Gem | New York Real Estate | CORE
 meta_description250 East 54th Street, 23D is a property offered for sale in New York, NY, USA, presented by CORE
 meta_keywords
 bathrooms_partial1
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude0.000000
 longitude0.000000
 invalid_required_fields
 invalid_optional_fieldsagent_2_id, square_feet, square_meters, acres, hectares, virtual_tour, video_tour
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:02
 created2016-04-01 08:22:42
 uri/property-detail/3668/250-east-54th-street-23d-new-york-ny-10022-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3668/250-east-54th-street-23d-new-york-ny-10022-usa
 address_concat250 East 54th Street, 23D New York NY 10022 USA
 google_maps_query_string250+East+54th+Street%2C+23D++New+York+NY+10022+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 1,290,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty1
 bathrooms_pretty1
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms1
 date_listed2016-04-01
 overridden_brokerage_nameCORE
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id16
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties20
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id1
 WOEID12589342
 timezone
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameCORE
 broker_of_record_name
 short_nameCORE
 usernameCORENYC
 password6bbc31e8f00594b7e3433f0a9c0cd7334bff73ae
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionCORE is the exclusive representative for Leverage Global Partners in New York City, New York, USA. CORE is the leading, full-service, boutique real estate brokerage specializing in the marketing of premiere residential properties. Headquartered in New York City, CORE was founded by CEO Shaun Osher and Jack Cayre, who envisioned a dynamic boutique brokerage based on integrity, informed by expertise and driven by innovation. CORE offers comprehensive real estate solutions for buyers, sellers, landlords, investors and developers. The firm is powered by an integrated team of accomplished professionals with extensive expertise in all aspects of real estate transactions. Thanks to a unique marketing approach, CORE ensures that its clients earn the highest market-driven prices. Our agents educate and shepherd buyers, sellers and landlords through the sales or leasing process. And we partner closely with developers, from the earliest stages of a project through closing; partnerships, which boast a proven, profitable track record. Within the past 8 years, CORE has marketed more than 30 new development properties and is the #1 brokerage in its class.
 communitiesManhattan Chelsea New York City Tribeca Midtown
 websitehttp://corenyc.com/
 address104 Fifth Avenue
 address_2
 cityNew York
 stateNY
 full_stateNew York
 countryUSA
 marketNew York
 market_2
 postal_code10011
 phone(212) 726-0778
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameShaun Osher
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-shaun-osher-founder-and-ceo-of-core/
 contact_big_profile_link_text
 contact_titleFounder and CEO
 contact_dre_num
 contact_quoteI invite you to contact me personally about New York City real estate.
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename16.jpg
 logo_filename16.jpg
 contact_image_filename16.jpg
 all_properties_link_image_filename16.jpg
 all_properties_linkhttp://corenyc.com/listings
 video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/cxxGtpBt-qzxAOUo0.js"></script>
 contact_video_embed_code
 meta_titleNew York City Real Estate | CORE | Leverage Global Partners
 meta_descriptionCORE is Leverage Global Partners' exclusive representative in New York City, NY, USA.
 meta_keywordsnew york city real estate, manhattan real estate, shaun osher, CORE, leverage global partners
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-04-01 15:35:47
 modified2019-10-29 20:06:57
 dre_num012345
 uri/brokerage-detail/16/core
 website_shortcorenyc.com
 name_with_locationCORE
 StripeSubscription(array)
 id(null)
 brokerage_id(null)
 user_id(null)
 property_id(null)
 type(null)
 stripe_id(null)
 stripe_customer_id(null)
 stripe_checkout_email(null)
 stripe_promotion_code(null)
 stripe_promotion_code_id(null)
 stripe_coupon_code_id(null)
 status(null)
 current_period_end(null)
 cancel_at_period_end(null)
 ended(null)
 last_change(null)
 last_activity_email_sent(null)
 created(null)
 modified(null)
 GlobalReachReport(array)
 id(null)
 property_id(null)
 wsj_desktop(null)
 wsj_mobile(null)
 wsj_expires(null)
 wsj_capture_started(null)
 mg_desktop(null)
 mg_mobile(null)
 mg_expires(null)
 mg_capture_started(null)
 bp_desktop(null)
 bp_mobile(null)
 bp_expires(null)
 gp_capture_started(null)
 mw_desktop(null)
 mw_mobile(null)
 mw_expires(null)
 mw_capture_started(null)
 ft_desktop(null)
 ft_mobile(null)
 ft_expires(null)
 ft_capture_started(null)
 nikkei_desktop(null)
 nikkei_mobile(null)
 nikkei_expires(null)
 nikkei_capture_started(null)
 pgl_desktop(null)
 pgl_mobile(null)
 pgl_expires(null)
 pgl_capture_started(null)
 robb_desktop(null)
 robb_mobile(null)
 robb_expires(null)
 robb_capture_started(null)
 juwai_desktop(null)
 juwai_mobile(null)
 juwai_expires(null)
 juwai_capture_started(null)
 leverage_desktop(null)
 leverage_mobile(null)
 leverage_expires(null)
 leverage_capture_started(null)
 created(null)
 modified(null)
 wsj_available(false)
 wsj_expired(true)
 wsj_desktop_proxy_screenshot(null)
 wsj_mobile_proxy_screenshot(null)
 mg_available(false)
 mg_expired(true)
 mg_desktop_proxy_screenshot(null)
 mg_mobile_proxy_screenshot(null)
 bp_available(false)
 bp_expired(true)
 bp_desktop_proxy_screenshot(null)
 bp_mobile_proxy_screenshot(null)
 mw_available(false)
 mw_expired(true)
 mw_desktop_proxy_screenshot(null)
 mw_mobile_proxy_screenshot(null)
 nikkei_available(false)
 nikkei_expired(true)
 nikkei_desktop_proxy_screenshot(null)
 nikkei_mobile_proxy_screenshot(null)
 pgl_available(false)
 pgl_expired(true)
 pgl_desktop_proxy_screenshot(null)
 pgl_mobile_proxy_screenshot(null)
 robb_available(false)
 robb_expired(true)
 robb_desktop_proxy_screenshot(null)
 robb_mobile_proxy_screenshot(null)
 juwai_available(false)
 juwai_expired(true)
 juwai_desktop_proxy_screenshot(null)
 juwai_mobile_proxy_screenshot(null)
 capture_processing(false)
 capture_error(empty)
 Image(array)
 0(array)
 id16960
 modelProperty
 model_id3668
 tagImage
 name35638.jpg
 typeimage/jpg
 size1238297
 uri/assets/16960.jpg
 order2835
 created2016-04-07 17:01:04
 modified2016-04-07 17:01:04
 1(array)
 id16961
 modelProperty
 model_id3668
 tagImage
 name35639.jpg
 typeimage/jpg
 size1479319
 uri/assets/16961.jpg
 order2836
 created2016-04-07 17:01:04
 modified2016-04-07 17:01:04
 2(array)
 id16962
 modelProperty
 model_id3668
 tagImage
 name35640.jpg
 typeimage/jpg
 size795266
 uri/assets/16962.jpg
 order2837
 created2016-04-07 17:01:04
 modified2016-04-07 17:01:04
 3(array)
 id16963
 modelProperty
 model_id3668
 tagImage
 name35641.jpg
 typeimage/jpg
 size1280506
 uri/assets/16963.jpg
 order2838
 created2016-04-07 17:01:04
 modified2016-04-07 17:01:04
 4(array)
 id16964
 modelProperty
 model_id3668
 tagImage
 name35642.jpg
 typeimage/jpg
 size1528680
 uri/assets/16964.jpg
 order2839
 created2016-04-07 17:01:04
 modified2016-04-07 17:01:04
 5(array)
 id16965
 modelProperty
 model_id3668
 tagImage
 name35643.jpg
 typeimage/jpg
 size1418080
 uri/assets/16965.jpg
 order2840
 created2016-04-07 17:01:04
 modified2016-04-07 17:01:05
 6(array)
 id16966
 modelProperty
 model_id3668
 tagImage
 name35644.jpg
 typeimage/jpg
 size862952
 uri/assets/16966.jpg
 order2841
 created2016-04-07 17:01:05
 modified2016-04-07 17:01:05
 7(array)
 id16967
 modelProperty
 model_id3668
 tagImage
 name35645.jpg
 typeimage/jpg
 size1048576
 uri/assets/16967.jpg
 order2842
 created2016-04-07 17:01:05
 modified2016-04-07 17:01:05
 User(array)
 0(array)
 id1260
 typeAgent
 brokerage_id16
 email[email protected]
 password5f5c318d9522ae839069d651653f3ab018e2d9c0
 recover_hash
 first_nameTaruna
 last_nameSharma
 title
 dre_num
 phone917-664-2343
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:24:00
 created2017-08-07 15:24:00
 notified(false)
 full_nameTaruna Sharma
 uri/agent-detail/1260/taruna-sharma
 profile_complete(true)
 UsersProperty(array)
 id1089
 user_id1260
 property_id3668
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id16
 nameWasher Dryer
 additional(false)
 created2016-04-07 14:05:42
 modified2016-04-07 14:05:42
 PropertiesPropertyFeature(array)
 id3534
 property_id3668
 property_feature_id16
 1(array)
 id1
 nameBalcony/Terrace
 additional(false)
 created2016-04-07 14:00:26
 modified2016-04-07 14:00:26
 PropertiesPropertyFeature(array)
 id3535
 property_id3668
 property_feature_id1
 Topic(empty)
 1(array)
 Property(array)
 id3670
 brokerage_id16
 created_by_user_id0
 order3
 multi_unit(false)
 agent_1_id361
 agent_2_id0
 agent_3_id0
 nameChelsea Penthouse
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(true)
 homepage_featured(false)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(false)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(true)
 detail_page(true)
 descriptionA truly unique offering of the highest order, Penthouse H at 456 West 19th Street marries over 2,800 square feet of grand living space with an additional 1,200 square feet of private outdoor terraces designed by the masterful Cary Tamarkin. Wrapped in continuous ribbons of steel windows boasting western and northern exposures, this stunning duplex offers 3 bedrooms, 3.5 bathrooms and views of the Hudson River and High Line Park. Ideal for the sophisticated homeowner who appreciates the duality of indoor/outdoor living, the double-height living room's 20-foot ceilings are the perfect canvas to display art and light. Granting direct access to the main level's massive fully irrigated wrap-around terrace, the grand living room features floor-to-ceiling, multi-paned casement windows and a gas-burning fireplace. Thoughtfully designed, the kitchen is open to the gracious dining room and is complete with Corian surfaces, custom-painted Baltic birch cabinetry, Vola fixtures, and Miele and Sub-Zero appliances. The kitchen and dining room also offer two additional points of access to the terrace. Upstairs, the corner master suite with charming breakfast terrace features a separate windowed dressing room, several custom-designed closets and iconic views of the Empire State Building. The decadent windowed en-suite bathroom is outfitted with a glass enclosed steam shower and Zuma soaking tub. Additional features include 2 bedrooms with en-suite baths, a powder room for guests, multi-zoned central air conditioning, 10-foot wide planked white oak floors, washer/dryer and a full home automation system with climate, music, fireplace, blinds and light control. Located in West Chelsea, amenities at 456 West 19th Street consist of a full-time doorman, architecturally designed common garden, private storage room for each apartment, as well as access to the finest neighboring galleries, shops, restaurants, hotels and parks.
 address456 West 19th Street, PENTHOUSEH
 address_2
 cityNew York
 stateNY
 postal_code10011
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price11450000
 price_20
 price_usd11450000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms3
 bedrooms_20
 bathrooms3
 bathrooms_20
 no_beds_baths(false)
 square_feet2829
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1balcony-terrace
 icon_2washer-dryer
 icon_3sq-ft
 icon_4
 icon_5
 icon_6
 websitehttp://corenyc.com/456-west-19th-street-penthouseh
 meta_titleChelsea Penthouse | New York Real Estate | CORE
 meta_description456 West 19th Street, PENTHOUSEH is a property offered for sale in New York, NY, USA, presented by CORE
 meta_keywords
 bathrooms_partial1
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude0.000000
 longitude0.000000
 invalid_required_fields
 invalid_optional_fieldsagent_2_id, square_meters, acres, hectares, virtual_tour, video_tour
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:03
 created2016-04-01 08:30:51
 uri/property-detail/3670/456-west-19th-street-penthouseh-new-york-ny-10011-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3670/456-west-19th-street-penthouseh-new-york-ny-10011-usa
 address_concat456 West 19th Street, PENTHOUSEH New York NY 10011 USA
 google_maps_query_string456+West+19th+Street%2C+PENTHOUSEH++New+York+NY+10011+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 11,450,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty3
 bathrooms_pretty3
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms3
 date_listed2016-04-01
 overridden_brokerage_nameCORE
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id16
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties20
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id1
 WOEID12589342
 timezone
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameCORE
 broker_of_record_name
 short_nameCORE
 usernameCORENYC
 password6bbc31e8f00594b7e3433f0a9c0cd7334bff73ae
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionCORE is the exclusive representative for Leverage Global Partners in New York City, New York, USA. CORE is the leading, full-service, boutique real estate brokerage specializing in the marketing of premiere residential properties. Headquartered in New York City, CORE was founded by CEO Shaun Osher and Jack Cayre, who envisioned a dynamic boutique brokerage based on integrity, informed by expertise and driven by innovation. CORE offers comprehensive real estate solutions for buyers, sellers, landlords, investors and developers. The firm is powered by an integrated team of accomplished professionals with extensive expertise in all aspects of real estate transactions. Thanks to a unique marketing approach, CORE ensures that its clients earn the highest market-driven prices. Our agents educate and shepherd buyers, sellers and landlords through the sales or leasing process. And we partner closely with developers, from the earliest stages of a project through closing; partnerships, which boast a proven, profitable track record. Within the past 8 years, CORE has marketed more than 30 new development properties and is the #1 brokerage in its class.
 communitiesManhattan Chelsea New York City Tribeca Midtown
 websitehttp://corenyc.com/
 address104 Fifth Avenue
 address_2
 cityNew York
 stateNY
 full_stateNew York
 countryUSA
 marketNew York
 market_2
 postal_code10011
 phone(212) 726-0778
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameShaun Osher
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-shaun-osher-founder-and-ceo-of-core/
 contact_big_profile_link_text
 contact_titleFounder and CEO
 contact_dre_num
 contact_quoteI invite you to contact me personally about New York City real estate.
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename16.jpg
 logo_filename16.jpg
 contact_image_filename16.jpg
 all_properties_link_image_filename16.jpg
 all_properties_linkhttp://corenyc.com/listings
 video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/cxxGtpBt-qzxAOUo0.js"></script>
 contact_video_embed_code
 meta_titleNew York City Real Estate | CORE | Leverage Global Partners
 meta_descriptionCORE is Leverage Global Partners' exclusive representative in New York City, NY, USA.
 meta_keywordsnew york city real estate, manhattan real estate, shaun osher, CORE, leverage global partners
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-04-01 15:35:47
 modified2019-10-29 20:06:57
 dre_num012345
 uri/brokerage-detail/16/core
 website_shortcorenyc.com
 name_with_locationCORE
 StripeSubscription(array)
 id(null)
 brokerage_id(null)
 user_id(null)
 property_id(null)
 type(null)
 stripe_id(null)
 stripe_customer_id(null)
 stripe_checkout_email(null)
 stripe_promotion_code(null)
 stripe_promotion_code_id(null)
 stripe_coupon_code_id(null)
 status(null)
 current_period_end(null)
 cancel_at_period_end(null)
 ended(null)
 last_change(null)
 last_activity_email_sent(null)
 created(null)
 modified(null)
 GlobalReachReport(array)
 id(null)
 property_id(null)
 wsj_desktop(null)
 wsj_mobile(null)
 wsj_expires(null)
 wsj_capture_started(null)
 mg_desktop(null)
 mg_mobile(null)
 mg_expires(null)
 mg_capture_started(null)
 bp_desktop(null)
 bp_mobile(null)
 bp_expires(null)
 gp_capture_started(null)
 mw_desktop(null)
 mw_mobile(null)
 mw_expires(null)
 mw_capture_started(null)
 ft_desktop(null)
 ft_mobile(null)
 ft_expires(null)
 ft_capture_started(null)
 nikkei_desktop(null)
 nikkei_mobile(null)
 nikkei_expires(null)
 nikkei_capture_started(null)
 pgl_desktop(null)
 pgl_mobile(null)
 pgl_expires(null)
 pgl_capture_started(null)
 robb_desktop(null)
 robb_mobile(null)
 robb_expires(null)
 robb_capture_started(null)
 juwai_desktop(null)
 juwai_mobile(null)
 juwai_expires(null)
 juwai_capture_started(null)
 leverage_desktop(null)
 leverage_mobile(null)
 leverage_expires(null)
 leverage_capture_started(null)
 created(null)
 modified(null)
 wsj_available(false)
 wsj_expired(true)
 wsj_desktop_proxy_screenshot(null)
 wsj_mobile_proxy_screenshot(null)
 mg_available(false)
 mg_expired(true)
 mg_desktop_proxy_screenshot(null)
 mg_mobile_proxy_screenshot(null)
 bp_available(false)
 bp_expired(true)
 bp_desktop_proxy_screenshot(null)
 bp_mobile_proxy_screenshot(null)
 mw_available(false)
 mw_expired(true)
 mw_desktop_proxy_screenshot(null)
 mw_mobile_proxy_screenshot(null)
 nikkei_available(false)
 nikkei_expired(true)
 nikkei_desktop_proxy_screenshot(null)
 nikkei_mobile_proxy_screenshot(null)
 pgl_available(false)
 pgl_expired(true)
 pgl_desktop_proxy_screenshot(null)
 pgl_mobile_proxy_screenshot(null)
 robb_available(false)
 robb_expired(true)
 robb_desktop_proxy_screenshot(null)
 robb_mobile_proxy_screenshot(null)
 juwai_available(false)
 juwai_expired(true)
 juwai_desktop_proxy_screenshot(null)
 juwai_mobile_proxy_screenshot(null)
 capture_processing(false)
 capture_error(empty)
 Image(array)
 0(array)
 id20362
 modelProperty
 model_id3670
 tagImage
 name35656.jpg
 typeimage/jpg
 size1543428
 uri/assets/20362.jpg
 order2835
 created2016-04-07 17:29:19
 modified2016-04-07 17:29:20
 1(array)
 id20363
 modelProperty
 model_id3670
 tagImage
 name35657.jpg
 typeimage/jpg
 size1325327
 uri/assets/20363.jpg
 order2836
 created2016-04-07 17:29:20
 modified2016-04-07 17:29:20
 2(array)
 id20364
 modelProperty
 model_id3670
 tagImage
 name35658.jpg
 typeimage/jpg
 size1245042
 uri/assets/20364.jpg
 order2837
 created2016-04-07 17:29:20
 modified2016-04-07 17:29:20
 3(array)
 id20365
 modelProperty
 model_id3670
 tagImage
 name35659.jpg
 typeimage/jpg
 size1230300
 uri/assets/20365.jpg
 order2838
 created2016-04-07 17:29:20
 modified2016-04-07 17:29:20
 4(array)
 id20366
 modelProperty
 model_id3670
 tagImage
 name35660.jpg
 typeimage/jpg
 size977512
 uri/assets/20366.jpg
 order2839
 created2016-04-07 17:29:20
 modified2016-04-07 17:29:20
 5(array)
 id20367
 modelProperty
 model_id3670
 tagImage
 name35661.jpg
 typeimage/jpg
 size1048576
 uri/assets/20367.jpg
 order2840
 created2016-04-07 17:29:20
 modified2016-04-07 17:29:20
 User(array)
 0(array)
 id569
 typeAgent
 brokerage_id16
 email[email protected]
 password68fa57f5587d222d5087649ea9648c1a88b861a2
 recover_hash
 first_nameEmily
 last_nameBeare
 title
 dre_num
 phone917-678-4359
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:08
 created2017-08-07 15:23:08
 notified(false)
 full_nameEmily Beare
 uri/agent-detail/569/emily-beare
 profile_complete(true)
 UsersProperty(array)
 id369
 user_id569
 property_id3670
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id1
 nameBalcony/Terrace
 additional(false)
 created2016-04-07 14:00:26
 modified2016-04-07 14:00:26
 PropertiesPropertyFeature(array)
 id4304
 property_id3670
 property_feature_id1
 1(array)
 id16
 nameWasher Dryer
 additional(false)
 created2016-04-07 14:05:42
 modified2016-04-07 14:05:42
 PropertiesPropertyFeature(array)
 id4305
 property_id3670
 property_feature_id16
 Topic(array)
 0(array)
 id5
 nameUrban Life
 created2016-02-25 11:25:00
 modified2016-02-25 11:36:03
 tile_nameUrban Life
 PropertiesTopic(array)
 id25
 property_id3670
 topic_id5
 2(array)
 Property(array)
 id3669
 brokerage_id16
 created_by_user_id0
 order6
 multi_unit(false)
 agent_1_id361
 agent_2_id0
 agent_3_id0
 nameFull-floor Dream Home
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(true)
 homepage_featured(false)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(false)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(false)
 detail_page(true)
 descriptionBe a part of history at 199 Mott Street. Tucked away in charming Nolita, this full-floor dream home is the last opportunity to own a sponsor unit in downtown's chicest LEED-Gold Certified sustainable boutique condominium. Spread out amongst 2,900 SF of interior space are 3 bedrooms and 3 bathrooms, in addition to 1,500 SF of private outdoor space. Enter the home's expansive entertaining space, where the living room offers direct access to the terrace, in addition to the kitchen and dining room. The well-planned kitchen is outfitted with SieMatic custom cabinetry, Imperial Danby marble countertops and backsplash, LeFroy Brooks fixtures, as well as Bertazzoni, Liebherr and Miele appliances. Overlooking the terrace is the Master Suite, with generously proportioned bedroom, bathroom and walk-in closet. Only 11 residences share the unique quality of life presented at 199 Mott Street. Building amenities include full-time doorman and concierge service, private storage, keyed elevator access, bicycle storage and a shared landscaped roof terrace.
 address199 Mott Street, 2
 address_2
 cityNew York
 stateNY
 postal_code10012
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price7250000
 price_20
 price_usd7250000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms3
 bedrooms_20
 bathrooms3
 bathrooms_20
 no_beds_baths(false)
 square_feet2907
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1balcony-terrace
 icon_2washer-dryer
 icon_3sq-ft
 icon_4
 icon_5
 icon_6
 websitehttp://corenyc.com/199-mott-street-2
 meta_titleFull-floor Dream Home | New York Real Estate | CORE
 meta_description199 Mott Street, 2 is a property offered for sale in New York, NY, USA, presented by CORE
 meta_keywords
 bathrooms_partial0
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude0.000000
 longitude0.000000
 invalid_required_fields
 invalid_optional_fieldsagent_2_id, bathrooms_partial, square_meters, acres, hectares, virtual_tour, video_tour
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:03
 created2016-04-01 08:27:26
 uri/property-detail/3669/199-mott-street-2-new-york-ny-10012-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3669/199-mott-street-2-new-york-ny-10012-usa
 address_concat199 Mott Street, 2 New York NY 10012 USA
 google_maps_query_string199+Mott+Street%2C+2++New+York+NY+10012+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 7,250,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty3
 bathrooms_pretty3
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms3
 date_listed2016-04-01
 overridden_brokerage_nameCORE
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id16
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties20
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id1
 WOEID12589342
 timezone
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameCORE
 broker_of_record_name
 short_nameCORE
 usernameCORENYC
 password6bbc31e8f00594b7e3433f0a9c0cd7334bff73ae
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionCORE is the exclusive representative for Leverage Global Partners in New York City, New York, USA. CORE is the leading, full-service, boutique real estate brokerage specializing in the marketing of premiere residential properties. Headquartered in New York City, CORE was founded by CEO Shaun Osher and Jack Cayre, who envisioned a dynamic boutique brokerage based on integrity, informed by expertise and driven by innovation. CORE offers comprehensive real estate solutions for buyers, sellers, landlords, investors and developers. The firm is powered by an integrated team of accomplished professionals with extensive expertise in all aspects of real estate transactions. Thanks to a unique marketing approach, CORE ensures that its clients earn the highest market-driven prices. Our agents educate and shepherd buyers, sellers and landlords through the sales or leasing process. And we partner closely with developers, from the earliest stages of a project through closing; partnerships, which boast a proven, profitable track record. Within the past 8 years, CORE has marketed more than 30 new development properties and is the #1 brokerage in its class.
 communitiesManhattan Chelsea New York City Tribeca Midtown
 websitehttp://corenyc.com/
 address104 Fifth Avenue
 address_2
 cityNew York
 stateNY
 full_stateNew York
 countryUSA
 marketNew York
 market_2
 postal_code10011
 phone(212) 726-0778
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameShaun Osher
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-shaun-osher-founder-and-ceo-of-core/
 contact_big_profile_link_text
 contact_titleFounder and CEO
 contact_dre_num
 contact_quoteI invite you to contact me personally about New York City real estate.
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename16.jpg
 logo_filename16.jpg
 contact_image_filename16.jpg
 all_properties_link_image_filename16.jpg
 all_properties_linkhttp://corenyc.com/listings
 video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/cxxGtpBt-qzxAOUo0.js"></script>
 contact_video_embed_code
 meta_titleNew York City Real Estate | CORE | Leverage Global Partners
 meta_descriptionCORE is Leverage Global Partners' exclusive representative in New York City, NY, USA.
 meta_keywordsnew york city real estate, manhattan real estate, shaun osher, CORE, leverage global partners
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-04-01 15:35:47
 modified2019-10-29 20:06:57
 dre_num012345
 uri/brokerage-detail/16/core
 website_shortcorenyc.com
 name_with_locationCORE
 StripeSubscription(array)
 id(null)
 brokerage_id(null)
 user_id(null)
 property_id(null)
 type(null)
 stripe_id(null)
 stripe_customer_id(null)
 stripe_checkout_email(null)
 stripe_promotion_code(null)
 stripe_promotion_code_id(null)
 stripe_coupon_code_id(null)
 status(null)
 current_period_end(null)
 cancel_at_period_end(null)
 ended(null)
 last_change(null)
 last_activity_email_sent(null)
 created(null)
 modified(null)
 GlobalReachReport(array)
 id(null)
 property_id(null)
 wsj_desktop(null)
 wsj_mobile(null)
 wsj_expires(null)
 wsj_capture_started(null)
 mg_desktop(null)
 mg_mobile(null)
 mg_expires(null)
 mg_capture_started(null)
 bp_desktop(null)
 bp_mobile(null)
 bp_expires(null)
 gp_capture_started(null)
 mw_desktop(null)
 mw_mobile(null)
 mw_expires(null)
 mw_capture_started(null)
 ft_desktop(null)
 ft_mobile(null)
 ft_expires(null)
 ft_capture_started(null)
 nikkei_desktop(null)
 nikkei_mobile(null)
 nikkei_expires(null)
 nikkei_capture_started(null)
 pgl_desktop(null)
 pgl_mobile(null)
 pgl_expires(null)
 pgl_capture_started(null)
 robb_desktop(null)
 robb_mobile(null)
 robb_expires(null)
 robb_capture_started(null)
 juwai_desktop(null)
 juwai_mobile(null)
 juwai_expires(null)
 juwai_capture_started(null)
 leverage_desktop(null)
 leverage_mobile(null)
 leverage_expires(null)
 leverage_capture_started(null)
 created(null)
 modified(null)
 wsj_available(false)
 wsj_expired(true)
 wsj_desktop_proxy_screenshot(null)
 wsj_mobile_proxy_screenshot(null)
 mg_available(false)
 mg_expired(true)
 mg_desktop_proxy_screenshot(null)
 mg_mobile_proxy_screenshot(null)
 bp_available(false)
 bp_expired(true)
 bp_desktop_proxy_screenshot(null)
 bp_mobile_proxy_screenshot(null)
 mw_available(false)
 mw_expired(true)
 mw_desktop_proxy_screenshot(null)
 mw_mobile_proxy_screenshot(null)
 nikkei_available(false)
 nikkei_expired(true)
 nikkei_desktop_proxy_screenshot(null)
 nikkei_mobile_proxy_screenshot(null)
 pgl_available(false)
 pgl_expired(true)
 pgl_desktop_proxy_screenshot(null)
 pgl_mobile_proxy_screenshot(null)
 robb_available(false)
 robb_expired(true)
 robb_desktop_proxy_screenshot(null)
 robb_mobile_proxy_screenshot(null)
 juwai_available(false)
 juwai_expired(true)
 juwai_desktop_proxy_screenshot(null)
 juwai_mobile_proxy_screenshot(null)
 capture_processing(false)
 capture_error(empty)
 Image(array)
 0(array)
 id20352
 modelProperty
 model_id3669
 tagImage
 name35646.jpg
 typeimage/jpg
 size1025413
 uri/assets/20352.jpg
 order2835
 created2016-04-07 17:29:19
 modified2016-04-07 17:29:19
 1(array)
 id20353
 modelProperty
 model_id3669
 tagImage
 name35647.jpg
 typeimage/jpg
 size1148060
 uri/assets/20353.jpg
 order2836
 created2016-04-07 17:29:19
 modified2016-04-07 17:29:19
 2(array)
 id20354
 modelProperty
 model_id3669
 tagImage
 name35648.jpg
 typeimage/jpg
 size1017178
 uri/assets/20354.jpg
 order2837
 created2016-04-07 17:29:19
 modified2016-04-07 17:29:19
 3(array)
 id20355
 modelProperty
 model_id3669
 tagImage
 name35649.jpg
 typeimage/jpg
 size1223054
 uri/assets/20355.jpg
 order2838
 created2016-04-07 17:29:19
 modified2016-04-07 17:29:19
 4(array)
 id20356
 modelProperty
 model_id3669
 tagImage
 name35650.jpg
 typeimage/jpg
 size903794
 uri/assets/20356.jpg
 order2839
 created2016-04-07 17:29:19
 modified2016-04-07 17:29:19
 5(array)
 id20357
 modelProperty
 model_id3669
 tagImage
 name35651.jpg
 typeimage/jpg
 size986876
 uri/assets/20357.jpg
 order2840
 created2016-04-07 17:29:19
 modified2016-04-07 17:29:19
 6(array)
 id20358
 modelProperty
 model_id3669
 tagImage
 name35652.jpg
 typeimage/jpg
 size1110004
 uri/assets/20358.jpg
 order2841
 created2016-04-07 17:29:19
 modified2016-04-07 17:29:19
 7(array)
 id20359
 modelProperty
 model_id3669
 tagImage
 name35653.jpg
 typeimage/jpg
 size1787955
 uri/assets/20359.jpg
 order2842
 created2016-04-07 17:29:19
 modified2016-04-07 17:29:19
 8(array)
 id20360
 modelProperty
 model_id3669
 tagImage
 name35654.jpg
 typeimage/jpg
 size1577872
 uri/assets/20360.jpg
 order2843
 created2016-04-07 17:29:19
 modified2016-04-07 17:29:19
 9(array)
 id20361
 modelProperty
 model_id3669
 tagImage
 name35655.jpg
 typeimage/jpg
 size1610472
 uri/assets/20361.jpg
 order2844
 created2016-04-07 17:29:19
 modified2016-04-07 17:29:19
 User(array)
 0(array)
 id569
 typeAgent
 brokerage_id16
 email[email protected]
 password68fa57f5587d222d5087649ea9648c1a88b861a2
 recover_hash
 first_nameEmily
 last_nameBeare
 title
 dre_num
 phone917-678-4359
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:08
 created2017-08-07 15:23:08
 notified(false)
 full_nameEmily Beare
 uri/agent-detail/569/emily-beare
 profile_complete(true)
 UsersProperty(array)
 id368
 user_id569
 property_id3669
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id1
 nameBalcony/Terrace
 additional(false)
 created2016-04-07 14:00:26
 modified2016-04-07 14:00:26
 PropertiesPropertyFeature(array)
 id4302
 property_id3669
 property_feature_id1
 1(array)
 id16
 nameWasher Dryer
 additional(false)
 created2016-04-07 14:05:42
 modified2016-04-07 14:05:42
 PropertiesPropertyFeature(array)
 id4303
 property_id3669
 property_feature_id16
 Topic(empty)
 3(array)
 Property(array)
 id3460
 brokerage_id16
 created_by_user_id0
 order1
 multi_unit(false)
 agent_1_id841
 agent_2_id1156
 agent_3_id0
 nameTribeca Loft
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(true)
 homepage_featured(true)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(false)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(true)
 detail_page(true)
 descriptionLocated in the heart of Tribeca on one of its most renowned streets, 140 Franklin Street is widely regarded as the finest loft building in Manhattan and apartment 5B embodies the highest level of refined loft living possible. Featuring 11-foot high ceilings, dramatic arched windows, original columns, wide plank Brazilian floors, industrial doors and an astounding 82-foot wide living room, this 6,226-square-foot apartment has unrivaled scale and volume allowing for the most generous of residential floor plans and separation of living spaces. The sprawling floor plan splits the master suite from the guest bedrooms for greater privacy and there is still ample space for staff rooms, a fitness room and a study/library or more bedrooms if needed. Enhancing this enviable open plan, quintessential loft features and esteemed address is the finessed talents of the incomparable French architect, Thierry Despont, whose contributions to the apartment's architecture and interior design have elevated it beyond its peers. Each space in the apartment has been artfully considered and curated to maximize comfort, function and design aesthetics: from a brilliant billiards area in the midst of the massive living room, to intimate parlor sitting areas, a grand dining area across from the stainless steel Varenna kitchen and the most elegant of offices set in front of one of the grand arched windows off the master bedroom. This is, quite simply, the kind of loft that everyone imagines and desires, yet never finds. 140 Franklin Street is a boutique, 12-unit, full-service condominium with 24-hour doorman service.
 address140 Franklin Street, 5B
 address_2
 cityNew York
 stateNY
 postal_code10013
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price24950000
 price_20
 price_usd24950000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms5
 bedrooms_20
 bathrooms7
 bathrooms_20
 no_beds_baths(false)
 square_feet6226
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1sq-ft
 icon_2washer-dryer
 icon_3
 icon_4
 icon_5
 icon_6
 websitehttp://corenyc.com/140-franklin-street-5b
 meta_titleTribeca Loft | New York Real Estate | CORE
 meta_description140 Franklin Street, 5B is a property offered for sale in New York , NY, USA, presented by CORE
 meta_keywords
 bathrooms_partial1
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude0.000000
 longitude0.000000
 invalid_required_fieldslatitude, longitude
 invalid_optional_fieldssquare_meters, acres, hectares, year_built, virtual_tour, video_tour, wsj_property_type, nyt_property_type, propgolux_property_type, propgolux_property_style
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:03
 created2016-02-19 12:53:01
 uri/property-detail/3460/140-franklin-street-5b-new-york-ny-10013-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3460/140-franklin-street-5b-new-york-ny-10013-usa
 address_concat140 Franklin Street, 5B New York NY 10013 USA
 google_maps_query_string140+Franklin+Street%2C+5B++New+York++NY+10013+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 24,950,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty5
 bathrooms_pretty7
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms7
 date_listed2016-02-19
 overridden_brokerage_nameCORE
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id16
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties20
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id1
 WOEID12589342
 timezone
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameCORE
 broker_of_record_name
 short_nameCORE
 usernameCORENYC
 password6bbc31e8f00594b7e3433f0a9c0cd7334bff73ae
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionCORE is the exclusive representative for Leverage Global Partners in New York City, New York, USA. CORE is the leading, full-service, boutique real estate brokerage specializing in the marketing of premiere residential properties. Headquartered in New York City, CORE was founded by CEO Shaun Osher and Jack Cayre, who envisioned a dynamic boutique brokerage based on integrity, informed by expertise and driven by innovation. CORE offers comprehensive real estate solutions for buyers, sellers, landlords, investors and developers. The firm is powered by an integrated team of accomplished professionals with extensive expertise in all aspects of real estate transactions. Thanks to a unique marketing approach, CORE ensures that its clients earn the highest market-driven prices. Our agents educate and shepherd buyers, sellers and landlords through the sales or leasing process. And we partner closely with developers, from the earliest stages of a project through closing; partnerships, which boast a proven, profitable track record. Within the past 8 years, CORE has marketed more than 30 new development properties and is the #1 brokerage in its class.
 communitiesManhattan Chelsea New York City Tribeca Midtown
 websitehttp://corenyc.com/
 address104 Fifth Avenue
 address_2
 cityNew York
 stateNY
 full_stateNew York
 countryUSA
 marketNew York
 market_2
 postal_code10011
 phone(212) 726-0778
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameShaun Osher
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-shaun-osher-founder-and-ceo-of-core/
 contact_big_profile_link_text
 contact_titleFounder and CEO
 contact_dre_num
 contact_quoteI invite you to contact me personally about New York City real estate.
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename16.jpg
 logo_filename16.jpg
 contact_image_filename16.jpg
 all_properties_link_image_filename16.jpg
 all_properties_linkhttp://corenyc.com/listings
 video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/cxxGtpBt-qzxAOUo0.js"></script>
 contact_video_embed_code
 meta_titleNew York City Real Estate | CORE | Leverage Global Partners
 meta_descriptionCORE is Leverage Global Partners' exclusive representative in New York City, NY, USA.
 meta_keywordsnew york city real estate, manhattan real estate, shaun osher, CORE, leverage global partners
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-04-01 15:35:47
 modified2019-10-29 20:06:57
 dre_num012345
 uri/brokerage-detail/16/core
 website_shortcorenyc.com
 name_with_locationCORE
 StripeSubscription(array)
 id(null)
 brokerage_id(null)
 user_id(null)
 property_id(null)
 type(null)
 stripe_id(null)
 stripe_customer_id(null)
 stripe_checkout_email(null)
 stripe_promotion_code(null)
 stripe_promotion_code_id(null)
 stripe_coupon_code_id(null)
 status(null)
 current_period_end(null)
 cancel_at_period_end(null)
 ended(null)
 last_change(null)
 last_activity_email_sent(null)
 created(null)
 modified(null)
 GlobalReachReport(array)
 id(null)
 property_id(null)
 wsj_desktop(null)
 wsj_mobile(null)
 wsj_expires(null)
 wsj_capture_started(null)
 mg_desktop(null)
 mg_mobile(null)
 mg_expires(null)
 mg_capture_started(null)
 bp_desktop(null)
 bp_mobile(null)
 bp_expires(null)
 gp_capture_started(null)
 mw_desktop(null)
 mw_mobile(null)
 mw_expires(null)
 mw_capture_started(null)
 ft_desktop(null)
 ft_mobile(null)
 ft_expires(null)
 ft_capture_started(null)
 nikkei_desktop(null)
 nikkei_mobile(null)
 nikkei_expires(null)
 nikkei_capture_started(null)
 pgl_desktop(null)
 pgl_mobile(null)
 pgl_expires(null)
 pgl_capture_started(null)
 robb_desktop(null)
 robb_mobile(null)
 robb_expires(null)
 robb_capture_started(null)
 juwai_desktop(null)
 juwai_mobile(null)
 juwai_expires(null)
 juwai_capture_started(null)
 leverage_desktop(null)
 leverage_mobile(null)
 leverage_expires(null)
 leverage_capture_started(null)
 created(null)
 modified(null)
 wsj_available(false)
 wsj_expired(true)
 wsj_desktop_proxy_screenshot(null)
 wsj_mobile_proxy_screenshot(null)
 mg_available(false)
 mg_expired(true)
 mg_desktop_proxy_screenshot(null)
 mg_mobile_proxy_screenshot(null)
 bp_available(false)
 bp_expired(true)
 bp_desktop_proxy_screenshot(null)
 bp_mobile_proxy_screenshot(null)
 mw_available(false)
 mw_expired(true)
 mw_desktop_proxy_screenshot(null)
 mw_mobile_proxy_screenshot(null)
 nikkei_available(false)
 nikkei_expired(true)
 nikkei_desktop_proxy_screenshot(null)
 nikkei_mobile_proxy_screenshot(null)
 pgl_available(false)
 pgl_expired(true)
 pgl_desktop_proxy_screenshot(null)
 pgl_mobile_proxy_screenshot(null)
 robb_available(false)
 robb_expired(true)
 robb_desktop_proxy_screenshot(null)
 robb_mobile_proxy_screenshot(null)
 juwai_available(false)
 juwai_expired(true)
 juwai_desktop_proxy_screenshot(null)
 juwai_mobile_proxy_screenshot(null)
 capture_processing(false)
 capture_error(empty)
 Image(array)
 0(array)
 id18323
 modelProperty
 model_id3460
 tagImage
 name33570.jpg
 typeimage/jpg
 size1414151
 uri/assets/18323.jpg
 order0
 created2016-04-07 17:09:04
 modified2016-04-07 17:09:04
 1(array)
 id18320
 modelProperty
 model_id3460
 tagImage
 name33567.jpg
 typeimage/jpg
 size1767421
 uri/assets/18320.jpg
 order1
 created2016-04-07 17:09:04
 modified2016-04-07 17:09:04
 2(array)
 id18322
 modelProperty
 model_id3460
 tagImage
 name33569.jpg
 typeimage/jpg
 size1508377
 uri/assets/18322.jpg
 order2
 created2016-04-07 17:09:04
 modified2016-04-07 17:09:04
 3(array)
 id18321
 modelProperty
 model_id3460
 tagImage
 name33568.jpg
 typeimage/jpg
 size1757896
 uri/assets/18321.jpg
 order3
 created2016-04-07 17:09:04
 modified2016-04-07 17:09:04
 4(array)
 id18324
 modelProperty
 model_id3460
 tagImage
 name33571.jpg
 typeimage/jpg
 size1272126
 uri/assets/18324.jpg
 order4
 created2016-04-07 17:09:04
 modified2016-04-07 17:09:04
 5(array)
 id18325
 modelProperty
 model_id3460
 tagImage
 name33572.jpg
 typeimage/jpg
 size1379223
 uri/assets/18325.jpg
 order5
 created2016-04-07 17:09:04
 modified2016-04-07 17:09:04
 6(array)
 id18326
 modelProperty
 model_id3460
 tagImage
 name33573.jpg
 typeimage/jpg
 size1544175
 uri/assets/18326.jpg
 order6
 created2016-04-07 17:09:04
 modified2016-04-07 17:09:04
 7(array)
 id18327
 modelProperty
 model_id3460
 tagImage
 name33574.jpg
 typeimage/jpg
 size1599154
 uri/assets/18327.jpg
 order7
 created2016-04-07 17:09:04
 modified2016-04-07 17:09:04
 8(array)
 id18328
 modelProperty
 model_id3460
 tagImage
 name33575.jpg
 typeimage/jpg
 size1738387
 uri/assets/18328.jpg
 order8
 created2016-04-07 17:09:04
 modified2016-04-07 17:09:04
 User(array)
 0(array)
 id570
 typeAgent
 brokerage_id16
 email[email protected]
 password92307bb2cbfcaed1ee0f1e88f420f1e8413475e8
 recover_hash
 first_nameJim
 last_nameSt. Andre
 title
 dre_num
 phone212-612-9602
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:08
 created2017-08-07 15:23:08
 notified(false)
 full_nameJim St. Andre
 uri/agent-detail/570/jim-st-andre
 profile_complete(true)
 UsersProperty(array)
 id373
 user_id570
 property_id3460
 sort_order0
 1(array)
 id1225
 typeAgent
 brokerage_id16
 email[email protected]
 password87496669c62aebe87fe6a345f74eb621465581a8
 recover_hash
 first_nameShaun
 last_nameOsher
 title
 dre_num
 phone212-726-0778
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:59
 created2017-08-07 15:23:59
 notified(false)
 full_nameShaun Osher
 uri/agent-detail/1225/shaun-osher
 profile_complete(true)
 UsersProperty(array)
 id1053
 user_id1225
 property_id3460
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id16
 nameWasher Dryer
 additional(false)
 created2016-04-07 14:05:42
 modified2016-04-07 14:05:42
 PropertiesPropertyFeature(array)
 id3859
 property_id3460
 property_feature_id16
 Topic(empty)
- sidebar_locations(array)
 0(array)
 Location(array)
 id154
 parent_id7
 brokerage_id16
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameNew York, NY, USA
 short_nameNew York, NY, USA
 group_index
 latitude40.712784
 longitude-74.005943
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore information coming soon!
 created2016-04-12 15:32:31
 modified2016-04-12 15:35:21
 timezoneAmerica/New_York
 population8400000
 uri/locations/view/154/new-york-ny-usa
 tile_nameNew York, NY, USA
 Brokerage(array)
 id16
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties20
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id1
 WOEID12589342
 timezone
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameCORE
 broker_of_record_name
 short_nameCORE
 usernameCORENYC
 password6bbc31e8f00594b7e3433f0a9c0cd7334bff73ae
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionCORE is the exclusive representative for Leverage Global Partners in New York City, New York, USA. CORE is the leading, full-service, boutique real estate brokerage specializing in the marketing of premiere residential properties. Headquartered in New York City, CORE was founded by CEO Shaun Osher and Jack Cayre, who envisioned a dynamic boutique brokerage based on integrity, informed by expertise and driven by innovation. CORE offers comprehensive real estate solutions for buyers, sellers, landlords, investors and developers. The firm is powered by an integrated team of accomplished professionals with extensive expertise in all aspects of real estate transactions. Thanks to a unique marketing approach, CORE ensures that its clients earn the highest market-driven prices. Our agents educate and shepherd buyers, sellers and landlords through the sales or leasing process. And we partner closely with developers, from the earliest stages of a project through closing; partnerships, which boast a proven, profitable track record. Within the past 8 years, CORE has marketed more than 30 new development properties and is the #1 brokerage in its class.
 communitiesManhattan Chelsea New York City Tribeca Midtown
 websitehttp://corenyc.com/
 address104 Fifth Avenue
 address_2
 cityNew York
 stateNY
 full_stateNew York
 countryUSA
 marketNew York
 market_2
 postal_code10011
 phone(212) 726-0778
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameShaun Osher
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-shaun-osher-founder-and-ceo-of-core/
 contact_big_profile_link_text
 contact_titleFounder and CEO
 contact_dre_num
 contact_quoteI invite you to contact me personally about New York City real estate.
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename16.jpg
 logo_filename16.jpg
 contact_image_filename16.jpg
 all_properties_link_image_filename16.jpg
 all_properties_linkhttp://corenyc.com/listings
 video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/cxxGtpBt-qzxAOUo0.js"></script>
 contact_video_embed_code
 meta_titleNew York City Real Estate | CORE | Leverage Global Partners
 meta_descriptionCORE is Leverage Global Partners' exclusive representative in New York City, NY, USA.
 meta_keywordsnew york city real estate, manhattan real estate, shaun osher, CORE, leverage global partners
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-04-01 15:35:47
 modified2019-10-29 20:06:57
 dre_num012345
 uri/brokerage-detail/16/core
 website_shortcorenyc.com
 name_with_locationCORE
 Image(array)
 id20711
 modelLocation
 model_id154
 tagImage
 nameScreen Shot 2016-04-12 at 3.34.19 PM.png
 typeimage/png
 size660485
 uri/assets/20711.png
 order0
 created2016-04-12 15:35:16
 modified2016-04-12 15:35:21
- highlighted_properties(array)
 0(array)
 Property(array)
 id3754
 brokerage_id16
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id0
 agent_2_id0
 agent_3_id0
 nameBoutique State-of-the-Art Condo in the West Village
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(false)
 homepage_featured(false)
 brokerage_page_featured(false)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(true)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time2019-10-29 20:09:29
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent2019-10-31 20:45:16
 digital_ad_summary_price_changed(false)
 wsj_detail_urlhttps://realestate.wsj.com/newyork/2204846-385-west-12th-street-10014?mod=search&pos=7&page=1&
 ft_detail_urlhttps://propertylistings.ft.com/homes/2755194
 nyt_detail_urlhttps://www.nytimes.com/real-estate/usa/ny/new-york/west-village/homes-for-sale/385-west-12th-street/1106-PRCH-2762625
 juwai_detail_urlhttps://www.juwai.com/50318262.htm
 pgl_detail_urlhttps://www.propgoluxury.com/en/homes/2755194
 mg_detail_urlhttps://www.mansionglobal.com/newyork/2204846-385-west-12th-street-10014?mod=search&pos=6&page=1&&region=na,us
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(false)
 detail_page(false)
 description385 West 12th Street, a boutique and state-of-the-art condominium in the West Village, boasts this magnificent 3-bedroom, 2.5-bathroom apartment. It is meticulously designed to the highest standard and spans 2,711SF. A private elevator landing opens to the heart of the home. Upon entering, the thoughtful layout leads left to the living areas and additional bedrooms, ensuring privacy to the master suite which is to the right. A powder room is cleverly tucked opposite the landing, perfect for guests. The sitting room is anchored by a gas fireplace and leads to the light-filled living room. Separating the living and dining areas is discreet storage. Treetops and the cobblestoned street can be seen through the massive, floor-to-ceiling window that frames the dining room. Overlooking the dining room is an oversized chefâs kitchen; ideal for both large events, and intimate, countertop eating. It boasts custom white lacquered oak cabinetry complimented by the marble countertops and backsplash. Itâs equipped with top-of-the-line Miele and Gaggenau appliances, Franke sinks/faucets and wine fridge. The spacious master suite features a generous terrace, walk-in closet and stunning five-piece bathroom. The bathroom is outfitted in Italian marble with a deep-soaking tub, glass-enclosed shower, and radiant floor heating. A media room, home office, two additional bedrooms, an additional full bathroom and washer/dryer complete the home. Additional features include Control 4- fully integrated home automation. Completed in 2010, 385 West 12th Street is a boutique condominium with only 12 units among 7 stories. Amenities offer the perfect balance of leisure and entertainment and feature a recently renovated and beautifully landscaped rooftop with a 55-foot swimming pool, Jacuzzi, outdoor shower, two gas grills and dining space. Direct views of the Hudson River, the West Village, and Empire State Building, with views to the north crown the rooftop. Additional building amenities include a 24-hour doorman/concierge, millwork club locker in the lobby, bike storage, and cellar storage room.
 address385 West 12th Street
 address_23WEST
 cityNew York
 stateNY
 postal_code10014
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price5000000
 price_20
 price_usd5000000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms0
 bedrooms_20
 bathrooms0
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 website
 meta_title
 meta_description
 meta_keywords
 bathrooms_partial0
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built2004
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num123456
 wsj_property_typecondominium
 nyt_property_type5
 nyt_popular_features
 propgolux_property_type2
 juwai_property_typeApartments/Condo
 juwai_categoryresidential
 propgolux_property_style25
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude40.737713
 longitude-74.008759
 invalid_required_fields
 invalid_optional_fields
 went_live_today(false)
 converted(false)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2019-10-31 20:45:16
 created2019-10-29 20:06:20
 uri/property-detail/3754/385-west-12th-street-3west-new-york-ny-10014-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3754/385-west-12th-street-3west-new-york-ny-10014-usa
 address_concat385 West 12th Street 3WEST New York NY 10014 USA
 google_maps_query_string385+West+12th+Street+3WEST+New+York+NY+10014+USA
 luxury_ad_enrolled_prettyYES
 price_prettyUSD 5,000,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty0
 bathrooms_pretty0
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms0
 date_listed2019-10-29
 overridden_brokerage_nameCORE
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id16
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties20
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id1
 WOEID12589342
 timezone
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameCORE
 broker_of_record_name
 short_nameCORE
 usernameCORENYC
 password6bbc31e8f00594b7e3433f0a9c0cd7334bff73ae
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionCORE is the exclusive representative for Leverage Global Partners in New York City, New York, USA. CORE is the leading, full-service, boutique real estate brokerage specializing in the marketing of premiere residential properties. Headquartered in New York City, CORE was founded by CEO Shaun Osher and Jack Cayre, who envisioned a dynamic boutique brokerage based on integrity, informed by expertise and driven by innovation. CORE offers comprehensive real estate solutions for buyers, sellers, landlords, investors and developers. The firm is powered by an integrated team of accomplished professionals with extensive expertise in all aspects of real estate transactions. Thanks to a unique marketing approach, CORE ensures that its clients earn the highest market-driven prices. Our agents educate and shepherd buyers, sellers and landlords through the sales or leasing process. And we partner closely with developers, from the earliest stages of a project through closing; partnerships, which boast a proven, profitable track record. Within the past 8 years, CORE has marketed more than 30 new development properties and is the #1 brokerage in its class.
 communitiesManhattan Chelsea New York City Tribeca Midtown
 websitehttp://corenyc.com/
 address104 Fifth Avenue
 address_2
 cityNew York
 stateNY
 full_stateNew York
 countryUSA
 marketNew York
 market_2
 postal_code10011
 phone(212) 726-0778
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameShaun Osher
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-shaun-osher-founder-and-ceo-of-core/
 contact_big_profile_link_text
 contact_titleFounder and CEO
 contact_dre_num
 contact_quoteI invite you to contact me personally about New York City real estate.
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename16.jpg
 logo_filename16.jpg
 contact_image_filename16.jpg
 all_properties_link_image_filename16.jpg
 all_properties_linkhttp://corenyc.com/listings
 video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/cxxGtpBt-qzxAOUo0.js"></script>
 contact_video_embed_code
 meta_titleNew York City Real Estate | CORE | Leverage Global Partners
 meta_descriptionCORE is Leverage Global Partners' exclusive representative in New York City, NY, USA.
 meta_keywordsnew york city real estate, manhattan real estate, shaun osher, CORE, leverage global partners
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-04-01 15:35:47
 modified2019-10-29 20:06:57
 dre_num012345
 uri/brokerage-detail/16/core
 website_shortcorenyc.com
 name_with_locationCORE
 StripeSubscription(array)
 id(null)
 brokerage_id(null)
 user_id(null)
 property_id(null)
 type(null)
 stripe_id(null)
 stripe_customer_id(null)
 stripe_checkout_email(null)
 stripe_promotion_code(null)
 stripe_promotion_code_id(null)
 stripe_coupon_code_id(null)
 status(null)
 current_period_end(null)
 cancel_at_period_end(null)
 ended(null)
 last_change(null)
 last_activity_email_sent(null)
 created(null)
 modified(null)
 GlobalReachReport(array)
 id(null)
 property_id(null)
 wsj_desktop(null)
 wsj_mobile(null)
 wsj_expires(null)
 wsj_capture_started(null)
 mg_desktop(null)
 mg_mobile(null)
 mg_expires(null)
 mg_capture_started(null)
 bp_desktop(null)
 bp_mobile(null)
 bp_expires(null)
 gp_capture_started(null)
 mw_desktop(null)
 mw_mobile(null)
 mw_expires(null)
 mw_capture_started(null)
 ft_desktop(null)
 ft_mobile(null)
 ft_expires(null)
 ft_capture_started(null)
 nikkei_desktop(null)
 nikkei_mobile(null)
 nikkei_expires(null)
 nikkei_capture_started(null)
 pgl_desktop(null)
 pgl_mobile(null)
 pgl_expires(null)
 pgl_capture_started(null)
 robb_desktop(null)
 robb_mobile(null)
 robb_expires(null)
 robb_capture_started(null)
 juwai_desktop(null)
 juwai_mobile(null)
 juwai_expires(null)
 juwai_capture_started(null)
 leverage_desktop(null)
 leverage_mobile(null)
 leverage_expires(null)
 leverage_capture_started(null)
 created(null)
 modified(null)
 wsj_available(false)
 wsj_expired(true)
 wsj_desktop_proxy_screenshot(null)
 wsj_mobile_proxy_screenshot(null)
 mg_available(false)
 mg_expired(true)
 mg_desktop_proxy_screenshot(null)
 mg_mobile_proxy_screenshot(null)
 bp_available(false)
 bp_expired(true)
 bp_desktop_proxy_screenshot(null)
 bp_mobile_proxy_screenshot(null)
 mw_available(false)
 mw_expired(true)
 mw_desktop_proxy_screenshot(null)
 mw_mobile_proxy_screenshot(null)
 nikkei_available(false)
 nikkei_expired(true)
 nikkei_desktop_proxy_screenshot(null)
 nikkei_mobile_proxy_screenshot(null)
 pgl_available(false)
 pgl_expired(true)
 pgl_desktop_proxy_screenshot(null)
 pgl_mobile_proxy_screenshot(null)
 robb_available(false)
 robb_expired(true)
 robb_desktop_proxy_screenshot(null)
 robb_mobile_proxy_screenshot(null)
 juwai_available(false)
 juwai_expired(true)
 juwai_desktop_proxy_screenshot(null)
 juwai_mobile_proxy_screenshot(null)
 capture_processing(false)
 capture_error(empty)
 Image(array)
 0(array)
 id23063
 modelProperty
 model_id3754
 tagImage
 namePI-1tfv6b4i17.jpg
 typeimage/jpeg
 size1392149
 uri/assets/23063.jpg
 order0
 created2019-10-29 20:06:00
 modified2019-10-29 20:06:20
 1(array)
 id23071
 modelProperty
 model_id3754
 tagImage
 namePI-1tia0th4t2.jpg
 typeimage/jpeg
 size745950
 uri/assets/23071.jpg
 order1
 created2019-10-29 20:06:02
 modified2019-10-29 20:06:20
 2(array)
 id23061
 modelProperty
 model_id3754
 tagImage
 namePI-1tfv6ad5r0.jpg
 typeimage/jpeg
 size953561
 uri/assets/23061.jpg
 order2
 created2019-10-29 20:06:00
 modified2019-10-29 20:06:20
 3(array)
 id23062
 modelProperty
 model_id3754
 tagImage
 namePI-1tfv5v65vv.jpg
 typeimage/jpeg
 size1120705
 uri/assets/23062.jpg
 order3
 created2019-10-29 20:06:00
 modified2019-10-29 20:06:20
 4(array)
 id23064
 modelProperty
 model_id3754
 tagImage
 namePI-1tfv5ud7qf.jpg
 typeimage/jpeg
 size819805
 uri/assets/23064.jpg
 order4
 created2019-10-29 20:06:00
 modified2019-10-29 20:06:20
 5(array)
 id23065
 modelProperty
 model_id3754
 tagImage
 namePI-1tfv5u6hao.jpg
 typeimage/jpeg
 size1354457
 uri/assets/23065.jpg
 order5
 created2019-10-29 20:06:00
 modified2019-10-29 20:06:20
 6(array)
 id23066
 modelProperty
 model_id3754
 tagImage
 namePI-1tfv6c8c2k.jpg
 typeimage/jpeg
 size667117
 uri/assets/23066.jpg
 order6
 created2019-10-29 20:06:00
 modified2019-10-29 20:06:20
 7(array)
 id23067
 modelProperty
 model_id3754
 tagImage
 namePI-1tfv62hm1n.jpg
 typeimage/jpeg
 size1142542
 uri/assets/23067.jpg
 order7
 created2019-10-29 20:06:01
 modified2019-10-29 20:06:20
 8(array)
 id23068
 modelProperty
 model_id3754
 tagImage
 namePI-1tfv60kn0g.jpg
 typeimage/jpeg
 size900053
 uri/assets/23068.jpg
 order8
 created2019-10-29 20:06:01
 modified2019-10-29 20:06:20
 9(array)
 id23069
 modelProperty
 model_id3754
 tagImage
 namePI-1tia0rna64.jpg
 typeimage/jpeg
 size667255
 uri/assets/23069.jpg
 order9
 created2019-10-29 20:06:01
 modified2019-10-29 20:06:20
 10(array)
 id23070
 modelProperty
 model_id3754
 tagImage
 namePI-1tfv64a3ih.jpg
 typeimage/jpeg
 size1295530
 uri/assets/23070.jpg
 order10
 created2019-10-29 20:06:01
 modified2019-10-29 20:06:20
 11(array)
 id23072
 modelProperty
 model_id3754
 tagImage
 namePI-1tia0uv5i1.jpg
 typeimage/jpeg
 size816357
 uri/assets/23072.jpg
 order11
 created2019-10-29 20:06:02
 modified2019-10-29 20:06:20
 12(array)
 id23073
 modelProperty
 model_id3754
 tagImage
 namePI-1tfv64q2c3.jpg
 typeimage/jpeg
 size1246171
 uri/assets/23073.jpg
 order12
 created2019-10-29 20:06:02
 modified2019-10-29 20:06:20
 13(array)
 id23074
 modelProperty
 model_id3754
 tagImage
 namePI-1tlejtukfi.jpg
 typeimage/jpeg
 size1296375
 uri/assets/23074.jpg
 order13
 created2019-10-29 20:06:02
 modified2019-10-29 20:06:20
 14(array)
 id23075
 modelProperty
 model_id3754
 tagImage
 namePI-1tlek8ckib.jpg
 typeimage/jpeg
 size821336
 uri/assets/23075.jpg
 order14
 created2019-10-29 20:06:02
 modified2019-10-29 20:06:20
 15(array)
 id23076
 modelProperty
 model_id3754
 tagImage
 namePI-1tlek3e9dr.jpg
 typeimage/jpeg
 size1122053
 uri/assets/23076.jpg
 order15
 created2019-10-29 20:06:02
 modified2019-10-29 20:06:20
 16(array)
 id23077
 modelProperty
 model_id3754
 tagImage
 namePI-1tlek0qvrl.jpg
 typeimage/jpeg
 size1277836
 uri/assets/23077.jpg
 order16
 created2019-10-29 20:06:03
 modified2019-10-29 20:06:20
 17(array)
 id23078
 modelProperty
 model_id3754
 tagImage
 namePI-1tlek8f4uk.jpg
 typeimage/jpeg
 size955578
 uri/assets/23078.jpg
 order17
 created2019-10-29 20:06:03
 modified2019-10-29 20:06:20
 18(array)
 id23079
 modelProperty
 model_id3754
 tagImage
 namePI-1tlek8p84e.jpg
 typeimage/jpeg
 size900653
 uri/assets/23079.jpg
 order18
 created2019-10-29 20:06:03
 modified2019-10-29 20:06:20
 19(array)
 id23080
 modelProperty
 model_id3754
 tagImage
 namePI-1tfv5smv25.jpg
 typeimage/jpeg
 size1276220
 uri/assets/23080.jpg
 order19
 created2019-10-29 20:06:10
 modified2019-10-29 20:06:20
 User(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(empty)
 Topic(empty)
 1(array)
 Property(array)
 id2990
 brokerage_id16
 created_by_user_id0
 order2
 multi_unit(false)
 agent_1_id361
 agent_2_id838
 agent_3_id0
 nameGramercy Townhouse
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(true)
 homepage_featured(true)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(false)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(false)
 detail_page(true)
 descriptionExceptional 28-foot wide, elevator, Anglo-Italianate townhouse on Stuyvesant Square Park. The elegant building has a three bay facade, round-arched doors and windows, a lovely foliate patterned cast-iron balcony that runs the width of the edifice and a paneled cornice. The five-story, 6,494-square-foot house was built for Thomas Morton in the 1850's and currently includes a four-story owner's residence and two one-bedroom units that can easily be converted back into a single family home. The stately owner's unit has five bedrooms, five full baths and two half baths. Beautifully renovated, the house has 16-foot ceilings on the parlor floor, a grand winding staircase, five fireplaces, arched doorways, skylights and original moldings. The Clive Christian eat-in kitchen has limestone countertops, high-end appliances, a separate office and direct access to the charming garden. Additionally there is a formal dining room, music room, media room and a front garden. The master is en-suite with a private terrace and a walk-in closet. 243 offers lovely south facing park views of the historic square. Heating, air and plumbing have all been updated and the building has a sprinkler system and two washer/dryers. The home is located in the Stuyvesant Square Historic District.
 address243 East 17th Street
 address_2
 cityNew York
 stateNY
 postal_code10003
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price14500000
 price_20
 price_usd14500000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms5
 bedrooms_20
 bathrooms6
 bathrooms_20
 no_beds_baths(false)
 square_feet6494
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1sq-ft
 icon_2balcony-terrace
 icon_3
 icon_4
 icon_5
 icon_6
 websitehttp://corenyc.com/243-east-17th-street
 meta_titleGramercy Townhouse | New York Real Estate | CORE
 meta_description243 East 17th Street is a property offered for sale in New York, NY, USA, presented by CORE
 meta_keywords
 bathrooms_partial0
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude0.000000
 longitude0.000000
 invalid_required_fields
 invalid_optional_fieldsbathrooms_partial, square_meters, acres, hectares, virtual_tour, video_tour
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:02
 created2015-11-02 09:05:59
 uri/property-detail/2990/243-east-17th-street-new-york-ny-10003-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/2990/243-east-17th-street-new-york-ny-10003-usa
 address_concat243 East 17th Street New York NY 10003 USA
 google_maps_query_string243+East+17th+Street++New+York+NY+10003+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 14,500,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty5
 bathrooms_pretty6
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms6
 date_listed2015-11-02
 overridden_brokerage_nameCORE
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id16
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties20
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id1
 WOEID12589342
 timezone
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameCORE
 broker_of_record_name
 short_nameCORE
 usernameCORENYC
 password6bbc31e8f00594b7e3433f0a9c0cd7334bff73ae
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionCORE is the exclusive representative for Leverage Global Partners in New York City, New York, USA. CORE is the leading, full-service, boutique real estate brokerage specializing in the marketing of premiere residential properties. Headquartered in New York City, CORE was founded by CEO Shaun Osher and Jack Cayre, who envisioned a dynamic boutique brokerage based on integrity, informed by expertise and driven by innovation. CORE offers comprehensive real estate solutions for buyers, sellers, landlords, investors and developers. The firm is powered by an integrated team of accomplished professionals with extensive expertise in all aspects of real estate transactions. Thanks to a unique marketing approach, CORE ensures that its clients earn the highest market-driven prices. Our agents educate and shepherd buyers, sellers and landlords through the sales or leasing process. And we partner closely with developers, from the earliest stages of a project through closing; partnerships, which boast a proven, profitable track record. Within the past 8 years, CORE has marketed more than 30 new development properties and is the #1 brokerage in its class.
 communitiesManhattan Chelsea New York City Tribeca Midtown
 websitehttp://corenyc.com/
 address104 Fifth Avenue
 address_2
 cityNew York
 stateNY
 full_stateNew York
 countryUSA
 marketNew York
 market_2
 postal_code10011
 phone(212) 726-0778
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameShaun Osher
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-shaun-osher-founder-and-ceo-of-core/
 contact_big_profile_link_text
 contact_titleFounder and CEO
 contact_dre_num
 contact_quoteI invite you to contact me personally about New York City real estate.
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename16.jpg
 logo_filename16.jpg
 contact_image_filename16.jpg
 all_properties_link_image_filename16.jpg
 all_properties_linkhttp://corenyc.com/listings
 video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/cxxGtpBt-qzxAOUo0.js"></script>
 contact_video_embed_code
 meta_titleNew York City Real Estate | CORE | Leverage Global Partners
 meta_descriptionCORE is Leverage Global Partners' exclusive representative in New York City, NY, USA.
 meta_keywordsnew york city real estate, manhattan real estate, shaun osher, CORE, leverage global partners
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-04-01 15:35:47
 modified2019-10-29 20:06:57
 dre_num012345
 uri/brokerage-detail/16/core
 website_shortcorenyc.com
 name_with_locationCORE
 StripeSubscription(array)
 id(null)
 brokerage_id(null)
 user_id(null)
 property_id(null)
 type(null)
 stripe_id(null)
 stripe_customer_id(null)
 stripe_checkout_email(null)
 stripe_promotion_code(null)
 stripe_promotion_code_id(null)
 stripe_coupon_code_id(null)
 status(null)
 current_period_end(null)
 cancel_at_period_end(null)
 ended(null)
 last_change(null)
 last_activity_email_sent(null)
 created(null)
 modified(null)
 GlobalReachReport(array)
 id(null)
 property_id(null)
 wsj_desktop(null)
 wsj_mobile(null)
 wsj_expires(null)
 wsj_capture_started(null)
 mg_desktop(null)
 mg_mobile(null)
 mg_expires(null)
 mg_capture_started(null)
 bp_desktop(null)
 bp_mobile(null)
 bp_expires(null)
 gp_capture_started(null)
 mw_desktop(null)
 mw_mobile(null)
 mw_expires(null)
 mw_capture_started(null)
 ft_desktop(null)
 ft_mobile(null)
 ft_expires(null)
 ft_capture_started(null)
 nikkei_desktop(null)
 nikkei_mobile(null)
 nikkei_expires(null)
 nikkei_capture_started(null)
 pgl_desktop(null)
 pgl_mobile(null)
 pgl_expires(null)
 pgl_capture_started(null)
 robb_desktop(null)
 robb_mobile(null)
 robb_expires(null)
 robb_capture_started(null)
 juwai_desktop(null)
 juwai_mobile(null)
 juwai_expires(null)
 juwai_capture_started(null)
 leverage_desktop(null)
 leverage_mobile(null)
 leverage_expires(null)
 leverage_capture_started(null)
 created(null)
 modified(null)
 wsj_available(false)
 wsj_expired(true)
 wsj_desktop_proxy_screenshot(null)
 wsj_mobile_proxy_screenshot(null)
 mg_available(false)
 mg_expired(true)
 mg_desktop_proxy_screenshot(null)
 mg_mobile_proxy_screenshot(null)
 bp_available(false)
 bp_expired(true)
 bp_desktop_proxy_screenshot(null)
 bp_mobile_proxy_screenshot(null)
 mw_available(false)
 mw_expired(true)
 mw_desktop_proxy_screenshot(null)
 mw_mobile_proxy_screenshot(null)
 nikkei_available(false)
 nikkei_expired(true)
 nikkei_desktop_proxy_screenshot(null)
 nikkei_mobile_proxy_screenshot(null)
 pgl_available(false)
 pgl_expired(true)
 pgl_desktop_proxy_screenshot(null)
 pgl_mobile_proxy_screenshot(null)
 robb_available(false)
 robb_expired(true)
 robb_desktop_proxy_screenshot(null)
 robb_mobile_proxy_screenshot(null)
 juwai_available(false)
 juwai_expired(true)
 juwai_desktop_proxy_screenshot(null)
 juwai_mobile_proxy_screenshot(null)
 capture_processing(false)
 capture_error(empty)
 Image(array)
 0(array)
 id16973
 modelProperty
 model_id2990
 tagImage
 name28620.jpg
 typeimage/jpg
 size1357653
 uri/assets/16973.jpg
 order1942
 created2016-04-07 17:01:05
 modified2016-04-07 17:01:05
 1(array)
 id16974
 modelProperty
 model_id2990
 tagImage
 name28621.jpg
 typeimage/jpg
 size1314708
 uri/assets/16974.jpg
 order1943
 created2016-04-07 17:01:05
 modified2016-04-07 17:01:05
 2(array)
 id16975
 modelProperty
 model_id2990
 tagImage
 name28622.jpg
 typeimage/jpg
 size1298012
 uri/assets/16975.jpg
 order1944
 created2016-04-07 17:01:05
 modified2016-04-07 17:01:05
 3(array)
 id16976
 modelProperty
 model_id2990
 tagImage
 name28623.jpg
 typeimage/jpg
 size1334159
 uri/assets/16976.jpg
 order1945
 created2016-04-07 17:01:05
 modified2016-04-07 17:01:05
 4(array)
 id16977
 modelProperty
 model_id2990
 tagImage
 name28624.jpg
 typeimage/jpg
 size1442474
 uri/assets/16977.jpg
 order1946
 created2016-04-07 17:01:05
 modified2016-04-07 17:01:05
 5(array)
 id16978
 modelProperty
 model_id2990
 tagImage
 name28625.jpg
 typeimage/jpg
 size1187404
 uri/assets/16978.jpg
 order1947
 created2016-04-07 17:01:05
 modified2016-04-07 17:01:05
 6(array)
 id16979
 modelProperty
 model_id2990
 tagImage
 name28626.jpg
 typeimage/jpg
 size1193496
 uri/assets/16979.jpg
 order1948
 created2016-04-07 17:01:05
 modified2016-04-07 17:01:05
 7(array)
 id16980
 modelProperty
 model_id2990
 tagImage
 name28627.jpg
 typeimage/jpg
 size986437
 uri/assets/16980.jpg
 order1949
 created2016-04-07 17:01:05
 modified2016-04-07 17:01:05
 8(array)
 id16981
 modelProperty
 model_id2990
 tagImage
 name28628.jpg
 typeimage/jpg
 size1863665
 uri/assets/16981.jpg
 order1950
 created2016-04-07 17:01:05
 modified2016-04-07 17:01:05
 9(array)
 id16982
 modelProperty
 model_id2990
 tagImage
 name28629.jpg
 typeimage/jpg
 size1249166
 uri/assets/16982.jpg
 order1951
 created2016-04-07 17:01:05
 modified2016-04-07 17:01:05
 User(array)
 0(array)
 id569
 typeAgent
 brokerage_id16
 email[email protected]
 password68fa57f5587d222d5087649ea9648c1a88b861a2
 recover_hash
 first_nameEmily
 last_nameBeare
 title
 dre_num
 phone917-678-4359
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:08
 created2017-08-07 15:23:08
 notified(false)
 full_nameEmily Beare
 uri/agent-detail/569/emily-beare
 profile_complete(true)
 UsersProperty(array)
 id367
 user_id569
 property_id2990
 sort_order0
 1(array)
 id1018
 typeAgent
 brokerage_id16
 email[email protected]
 passworde776967b861f4ac0e70bbf11372002380a3f41de
 recover_hash
 first_namePatrick V
 last_nameLilly
 title
 dre_num
 phone212-612-9681
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:48
 created2017-08-07 15:23:48
 notified(false)
 full_namePatrick V Lilly
 uri/agent-detail/1018/patrick-v-lilly
 profile_complete(true)
 UsersProperty(array)
 id780
 user_id1018
 property_id2990
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id1
 nameBalcony/Terrace
 additional(false)
 created2016-04-07 14:00:26
 modified2016-04-07 14:00:26
 PropertiesPropertyFeature(array)
 id3537
 property_id2990
 property_feature_id1
 Topic(empty)
- custom_ga_event_properties(array)
 brokerageCORE, New York
- property(array)
 Property(array)
 id3668
 brokerage_id16
 created_by_user_id0
 order7
 multi_unit(false)
 agent_1_id1207
 agent_2_id0
 agent_3_id0
 nameMidtown East Gem
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(true)
 homepage_featured(false)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(false)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(false)
 detail_page(true)
 descriptionMove right into this chic, renovated 1-bedroom, 1.5-bath home with floor-to-ceiling windows, a balcony and partial river views as well as open city views in the heart of Midtown East. The pass-through kitchen has brand new stainless steel appliances and a washer/dryer. The apartment has gorgeous marble floors in the foyer, kitchen and bathrooms, and beautiful oak herringbone hardwood floors in the living room and bedroom. The bathroom has a shower and Jacuzzi tub. Sunlight abounds throughout the apartment. This pet friendly, white glove, full-service condominium has a 24-hour doorman, concierge and on-site resident manager. Additional amenities include bike storage and central laundry. An Equinox fitness club is located in the building and SoulCycle East is next door on 54th Street. Convenient to all transportation, restaurants, shopping and much more.
 address250 East 54th Street, 23D
 address_2
 cityNew York
 stateNY
 postal_code10022
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price1290000
 price_20
 price_usd1290000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms1
 bedrooms_20
 bathrooms1
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1washer-dryer
 icon_2balcony-terrace
 icon_3
 icon_4
 icon_5
 icon_6
 websitehttp://corenyc.com/250-east-54th-street-23d
 meta_titleMidtown East Gem | New York Real Estate | CORE
 meta_description250 East 54th Street, 23D is a property offered for sale in New York, NY, USA, presented by CORE
 meta_keywords
 bathrooms_partial1
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude0.000000
 longitude0.000000
 invalid_required_fields
 invalid_optional_fieldsagent_2_id, square_feet, square_meters, acres, hectares, virtual_tour, video_tour
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:02
 created2016-04-01 08:22:42
 uri/property-detail/3668/250-east-54th-street-23d-new-york-ny-10022-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3668/250-east-54th-street-23d-new-york-ny-10022-usa
 address_concat250 East 54th Street, 23D New York NY 10022 USA
 google_maps_query_string250+East+54th+Street%2C+23D++New+York+NY+10022+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 1,290,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty1
 bathrooms_pretty1
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms1
 date_listed2016-04-01
 overridden_brokerage_nameCORE
 overridden_brokerage_logo_uri/assets/2245.jpg
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id16
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties20
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id1
 WOEID12589342
 timezone
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameCORE
 broker_of_record_name
 short_nameCORE
 usernameCORENYC
 password6bbc31e8f00594b7e3433f0a9c0cd7334bff73ae
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionCORE is the exclusive representative for Leverage Global Partners in New York City, New York, USA. CORE is the leading, full-service, boutique real estate brokerage specializing in the marketing of premiere residential properties. Headquartered in New York City, CORE was founded by CEO Shaun Osher and Jack Cayre, who envisioned a dynamic boutique brokerage based on integrity, informed by expertise and driven by innovation. CORE offers comprehensive real estate solutions for buyers, sellers, landlords, investors and developers. The firm is powered by an integrated team of accomplished professionals with extensive expertise in all aspects of real estate transactions. Thanks to a unique marketing approach, CORE ensures that its clients earn the highest market-driven prices. Our agents educate and shepherd buyers, sellers and landlords through the sales or leasing process. And we partner closely with developers, from the earliest stages of a project through closing; partnerships, which boast a proven, profitable track record. Within the past 8 years, CORE has marketed more than 30 new development properties and is the #1 brokerage in its class.
 communitiesManhattan Chelsea New York City Tribeca Midtown
 websitehttp://corenyc.com/
 address104 Fifth Avenue
 address_2
 cityNew York
 stateNY
 full_stateNew York
 countryUSA
 marketNew York
 market_2
 postal_code10011
 phone(212) 726-0778
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameShaun Osher
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-shaun-osher-founder-and-ceo-of-core/
 contact_big_profile_link_text
 contact_titleFounder and CEO
 contact_dre_num
 contact_quoteI invite you to contact me personally about New York City real estate.
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename16.jpg
 logo_filename16.jpg
 contact_image_filename16.jpg
 all_properties_link_image_filename16.jpg
 all_properties_linkhttp://corenyc.com/listings
 video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/cxxGtpBt-qzxAOUo0.js"></script>
 contact_video_embed_code
 meta_titleNew York City Real Estate | CORE | Leverage Global Partners
 meta_descriptionCORE is Leverage Global Partners' exclusive representative in New York City, NY, USA.
 meta_keywordsnew york city real estate, manhattan real estate, shaun osher, CORE, leverage global partners
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-04-01 15:35:47
 modified2019-10-29 20:06:57
 dre_num012345
 AccountExecutive(array)
 id235
 typeAccountExecutive
 brokerage_id0
 email[email protected]
 passworde5cc5a96287695cf8b7cace1463b1699895dcf92
 recover_hash
 first_nameAlec
 last_nameMegerdichian
 title
 dre_num
 phone
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2020-12-23 09:21:42
 created2016-04-14 15:40:35
 notified(false)
 full_nameAlec Megerdichian
 uri/agent-detail/235/alec-megerdichian
 profile_complete(true)
 Logo(array)
 id2245
 modelBrokerage
 model_id16
 tagLogo
 name16.jpg
 typeimage/jpg
 size10457
 uri/assets/2245.jpg
 order0
 created2016-03-30 11:35:51
 modified2019-10-29 20:06:57
 MainImage(array)
 id2244
 modelBrokerage
 model_id16
 tagMainImage
 name16.jpg
 typeimage/jpg
 size522519
 uri/assets/2244.jpg
 order0
 created2016-03-30 11:35:51
 modified2019-10-29 20:06:57
 ContactImage(array)
 id2246
 modelBrokerage
 model_id16
 tagContactImage
 name16.jpg
 typeimage/jpg
 size247341
 uri/assets/2246.jpg
 order0
 created2016-03-30 11:35:51
 modified2019-10-29 20:06:57
 ContactImage2(empty)
 ContactImage3(empty)
 BrokerOfRecordLogo(empty)
 MainArticle(empty)
 FeaturedImage(empty)
 Location(array)
 0(array)
 id154
 parent_id7
 brokerage_id16
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameNew York, NY, USA
 short_nameNew York, NY, USA
 group_index
 latitude40.712784
 longitude-74.005943
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore information coming soon!
 created2016-04-12 15:32:31
 modified2016-04-12 15:35:21
 timezoneAmerica/New_York
 population8400000
 uri/locations/view/154/new-york-ny-usa
 tile_nameNew York, NY, USA
 User(array)
 0(array)
 id65
 typeBrokerageAdmin
 brokerage_id16
 email[email protected]
 password6bbc31e8f00594b7e3433f0a9c0cd7334bff73ae
 recover_hash
 first_nameShaun
 last_nameOsher
 title
 dre_num
 phone
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2016-04-14 09:58:53
 created2016-04-08 16:33:22
 notified(true)
 full_nameShaun Osher
 uri/agent-detail/65/shaun-osher
 profile_complete(true)
 1(array)
 id225
 typeBrokerageAdmin
 brokerage_id16
 email[email protected]
 password0701ff6c9b0b96e14d0159b3c96ffbf4a22c30d0
 recover_hash
 first_nameVanessa
 last_nameLippman
 title
 dre_num
 phone
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2016-04-14 10:06:51
 created2016-04-14 10:06:51
 notified(false)
 full_nameVanessa Lippman
 uri/agent-detail/225/vanessa-lippman
 profile_complete(true)
 2(array)
 id495
 typeAgent
 brokerage_id16
 email[email protected]
 password1b91e70378043d734396ba7ffc5ffa187712c83c
 recover_hash
 first_nameHENRY
 last_nameHERSHKOWITZ
 title
 dre_num
 phone646-780-5260
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:01
 created2017-08-07 15:23:01
 notified(false)
 full_nameHENRY HERSHKOWITZ
 uri/agent-detail/495/henry-hershkowitz
 profile_complete(true)
 3(array)
 id569
 typeAgent
 brokerage_id16
 email[email protected]
 password68fa57f5587d222d5087649ea9648c1a88b861a2
 recover_hash
 first_nameEmily
 last_nameBeare
 title
 dre_num
 phone917-678-4359
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:08
 created2017-08-07 15:23:08
 notified(false)
 full_nameEmily Beare
 uri/agent-detail/569/emily-beare
 profile_complete(true)
 4(array)
 id570
 typeAgent
 brokerage_id16
 email[email protected]
 password92307bb2cbfcaed1ee0f1e88f420f1e8413475e8
 recover_hash
 first_nameJim
 last_nameSt. Andre
 title
 dre_num
 phone212-612-9602
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:08
 created2017-08-07 15:23:08
 notified(false)
 full_nameJim St. Andre
 uri/agent-detail/570/jim-st-andre
 profile_complete(true)
 5(array)
 id571
 typeAgent
 brokerage_id16
 email[email protected]
 passworda66a173fee001b9bc32234b8b126cf9b22bcae78
 recover_hash
 first_nameLisa
 last_nameGraham
 title
 dre_num
 phone212-500-2103
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:08
 created2017-08-07 15:23:08
 notified(false)
 full_nameLisa Graham
 uri/agent-detail/571/lisa-graham
 profile_complete(true)
 6(array)
 id572
 typeAgent
 brokerage_id16
 email[email protected]
 password2bee561b39762dccad19bcbc16bd91e0ecff7164
 recover_hash
 first_nameSteve
 last_nameSnider
 title
 dre_num
 phone952-250-4893
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:08
 created2017-08-07 15:23:08
 notified(false)
 full_nameSteve Snider
 uri/agent-detail/572/steve-snider
 profile_complete(true)
 7(array)
 id573
 typeAgent
 brokerage_id16
 email[email protected]
 password810dcf80768918b6cbc538404bc24db76911ad6b
 recover_hash
 first_nameHEATHER L
 last_nameMCDONOUGH
 title
 dre_num
 phone646-780-5261
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:08
 created2017-08-07 15:23:08
 notified(false)
 full_nameHEATHER L MCDONOUGH
 uri/agent-detail/573/heather-l-mcdonough
 profile_complete(true)
 8(array)
 id574
 typeAgent
 brokerage_id16
 email[email protected]
 password1f5d311efaa0fe5808b969581bebefea8f1338f9
 recover_hash
 first_nameMatthew
 last_nameChook
 title
 dre_num
 phone917-597-6967
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:08
 created2017-08-07 15:23:08
 notified(false)
 full_nameMatthew Chook
 uri/agent-detail/574/matthew-chook
 profile_complete(true)
 9(array)
 id748
 typeAgent
 brokerage_id16
 email[email protected]
 password72ca24c5479abb3609825092e047b1a4753fafa9
 recover_hash
 first_nameTim
 last_nameCrowley
 title
 dre_num
 phone212-726-0763
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:19
 created2017-08-07 15:23:19
 notified(false)
 full_nameTim Crowley
 uri/agent-detail/748/tim-crowley
 profile_complete(true)
 10(array)
 id749
 typeAgent
 brokerage_id16
 email[email protected]
 password50d82d3d8e4e32f8e4f3779a3aa00c36762698bb
 recover_hash
 first_nameTom
 last_namePostilio
 title
 dre_num
 phone2127260783
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:19
 created2017-08-07 15:23:19
 notified(false)
 full_nameTom Postilio
 uri/agent-detail/749/tom-postilio
 profile_complete(true)
 11(array)
 id750
 typeAgent
 brokerage_id16
 email[email protected]
 password3f1818067e5cdf20f2444f6cea72cfc707b2dc90
 recover_hash
 first_nameMickey
 last_nameConlon
 title
 dre_num
 phone212-612-9623
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:19
 created2017-08-07 15:23:19
 notified(false)
 full_nameMickey Conlon
 uri/agent-detail/750/mickey-conlon
 profile_complete(true)
 12(array)
 id751
 typeAgent
 brokerage_id16
 email[email protected]
 password8562d8a4aafb77b63b93253086643f2d8cb2e92d
 recover_hash
 first_nameDoron
 last_nameZwickel
 title
 dre_num
 phone2126129607
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:19
 created2017-08-07 15:23:19
 notified(false)
 full_nameDoron Zwickel
 uri/agent-detail/751/doron-zwickel
 profile_complete(true)
 13(array)
 id870
 typeAgent
 brokerage_id16
 email[email protected]
 passworde8f15d0e98ef47aa6fc8d7f0acedee0ad6a8c25a
 recover_hash
 first_nameMichael
 last_nameRubin
 title
 dre_num
 phone347-880-0349
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:42
 created2017-08-07 15:23:42
 notified(false)
 full_nameMichael Rubin
 uri/agent-detail/870/michael-rubin
 profile_complete(true)
 14(array)
 id949
 typeAgent
 brokerage_id16
 email[email protected]
 passworddfac3cabb1bbc4c9f38eaf685de0527e4d35ac37
 recover_hash
 first_nameKatja
 last_nameKnupfer
 title
 dre_num
 phone646-786-6720
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:45
 created2017-08-07 15:23:45
 notified(false)
 full_nameKatja Knupfer
 uri/agent-detail/949/katja-knupfer
 profile_complete(true)
 15(array)
 id950
 typeAgent
 brokerage_id16
 email[email protected]
 password3efcf1d0b4d46349eb7cbd6d3230b63f704a69c6
 recover_hash
 first_nameBen
 last_nameJacobs
 title
 dre_num
 phone212-612-9682
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:46
 created2017-08-07 15:23:46
 notified(false)
 full_nameBen Jacobs
 uri/agent-detail/950/ben-jacobs
 profile_complete(true)
 16(array)
 id1017
 typeAgent
 brokerage_id16
 email[email protected]
 password895db27375ae23e9960c2739af1af52b47b27871
 recover_hash
 first_nameCassie
 last_nameDAgata
 title
 dre_num
 phone212-612-9697
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:48
 created2017-08-07 15:23:48
 notified(false)
 full_nameCassie DAgata
 uri/agent-detail/1017/cassie-dagata
 profile_complete(true)
 17(array)
 id1018
 typeAgent
 brokerage_id16
 email[email protected]
 passworde776967b861f4ac0e70bbf11372002380a3f41de
 recover_hash
 first_namePatrick V
 last_nameLilly
 title
 dre_num
 phone212-612-9681
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:48
 created2017-08-07 15:23:48
 notified(false)
 full_namePatrick V Lilly
 uri/agent-detail/1018/patrick-v-lilly
 profile_complete(true)
 18(array)
 id1019
 typeAgent
 brokerage_id16
 email[email protected]
 password1072a6ab6fe69de3832e3851157899faab65243c
 recover_hash
 first_nameAlyssa
 last_nameSoto Brody
 title
 dre_num
 phone212-612-9653
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:48
 created2017-08-07 15:23:48
 notified(false)
 full_nameAlyssa Soto Brody
 uri/agent-detail/1019/alyssa-soto-brody
 profile_complete(true)
 19(array)
 id1020
 typeAgent
 brokerage_id16
 email[email protected]
 password2c5e4724f01ac9f6b20f11efd5094ff93ed6a16a
 recover_hash
 first_nameMcKenzie
 last_nameFoster
 title
 dre_num
 phone212-612-9684
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:49
 created2017-08-07 15:23:49
 notified(false)
 full_nameMcKenzie Foster
 uri/agent-detail/1020/mckenzie-foster
 profile_complete(true)
 20(array)
 id1021
 typeAgent
 brokerage_id16
 email[email protected]
 password6cd95e39c26c219ec6030cd429f90bb4254338a5
 recover_hash
 first_nameChristian
 last_nameRogers
 title
 dre_num
 phone917-270-4119
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:49
 created2017-08-07 15:23:49
 notified(false)
 full_nameChristian Rogers
 uri/agent-detail/1021/christian-rogers
 profile_complete(true)
 21(array)
 id1090
 typeAgent
 brokerage_id16
 email[email protected]
 password9a6420072dcb659c5938aaae06f146d85509883f
 recover_hash
 first_nameDavid
 last_nameBeare
 title
 dre_num
 phone212-726-0743
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:53
 created2017-08-07 15:23:53
 notified(false)
 full_nameDavid Beare
 uri/agent-detail/1090/david-beare
 profile_complete(true)
 22(array)
 id1091
 typeAgent
 brokerage_id16
 email[email protected]
 passwordb5f7d8a62e00a368b52de4016744121eb7665d78
 recover_hash
 first_nameJason
 last_nameWalker
 title
 dre_num
 phone212-500-2122
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:53
 created2017-08-07 15:23:53
 notified(false)
 full_nameJason Walker
 uri/agent-detail/1091/jason-walker
 profile_complete(true)
 23(array)
 id1092
 typeAgent
 brokerage_id16
 email[email protected]
 password257d7598a3ab314ca06c8e33e409e67893405086
 recover_hash
 first_nameAdrian
 last_nameNoriega
 title
 dre_num
 phone646-279-6104
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:53
 created2017-08-07 15:23:53
 notified(false)
 full_nameAdrian Noriega
 uri/agent-detail/1092/adrian-noriega
 profile_complete(true)
 24(array)
 id1093
 typeAgent
 brokerage_id16
 email[email protected]
 password8b7b3835f698007e6a657f8b07c524fbbc65d760
 recover_hash
 first_nameBrett
 last_nameCaspi
 title
 dre_num
 phone516-633-6106
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:53
 created2017-08-07 15:23:53
 notified(false)
 full_nameBrett Caspi
 uri/agent-detail/1093/brett-caspi
 profile_complete(true)
 25(array)
 id1130
 typeAgent
 brokerage_id16
 email[email protected]
 passwordb9cf0f2cfe3e1fba6346afddce8986e31adc3041
 recover_hash
 first_nameSean
 last_nameAttebury
 title
 dre_num
 phone917-597-6370
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:55
 created2017-08-07 15:23:55
 notified(false)
 full_nameSean Attebury
 uri/agent-detail/1130/sean-attebury
 profile_complete(true)
 26(array)
 id1131
 typeAgent
 brokerage_id16
 email[email protected]
 passwordc7e1e7bcc2bb2d8733b1267551335c5274f23a3e
 recover_hash
 first_nameMartin
 last_nameEiden
 title
 dre_num
 phone212-612-9695
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:55
 created2017-08-07 15:23:55
 notified(false)
 full_nameMartin Eiden
 uri/agent-detail/1131/martin-eiden
 profile_complete(true)
 27(array)
 id1132
 typeAgent
 brokerage_id16
 email[email protected]
 password8883d920101c659f6ba33ff25a01fb1823c7b5eb
 recover_hash
 first_nameElizabeth
 last_nameBeare
 title
 dre_num
 phone2126129696
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:55
 created2017-08-07 15:23:55
 notified(false)
 full_nameElizabeth Beare
 uri/agent-detail/1132/elizabeth-beare
 profile_complete(true)
 28(array)
 id1172
 typeAgent
 brokerage_id16
 email[email protected]
 passwordf548852de0a66f8a2b028fdccd69f9742261ddca
 recover_hash
 first_nameCleo
 last_nameVauban
 title
 dre_num
 phone212-612-9668
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:56
 created2017-08-07 15:23:56
 notified(false)
 full_nameCleo Vauban
 uri/agent-detail/1172/cleo-vauban
 profile_complete(true)
 29(array)
 id1225
 typeAgent
 brokerage_id16
 email[email protected]
 password87496669c62aebe87fe6a345f74eb621465581a8
 recover_hash
 first_nameShaun
 last_nameOsher
 title
 dre_num
 phone212-726-0778
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:59
 created2017-08-07 15:23:59
 notified(false)
 full_nameShaun Osher
 uri/agent-detail/1225/shaun-osher
 profile_complete(true)
 30(array)
 id1260
 typeAgent
 brokerage_id16
 email[email protected]
 password5f5c318d9522ae839069d651653f3ab018e2d9c0
 recover_hash
 first_nameTaruna
 last_nameSharma
 title
 dre_num
 phone917-664-2343
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:24:00
 created2017-08-07 15:24:00
 notified(false)
 full_nameTaruna Sharma
 uri/agent-detail/1260/taruna-sharma
 profile_complete(true)
 31(array)
 id1296
 typeBrokerageAdmin
 brokerage_id16
 email[email protected]
 password5b3d98678923130b42f1a9ea996c024268a27826
 recover_hash
 first_nameEric
 last_nameStaging
 title
 dre_num
 phone
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2025-06-25 17:12:51
 created2025-06-25 17:12:51
 notified(false)
 full_nameEric Staging
 uri/agent-detail/1296/eric-staging
 profile_complete(true)
 uri/brokerage-detail/16/core
 website_shortcorenyc.com
 name_with_locationCORE - New York, NY, USA
 StripeSubscription(array)
 id(null)
 brokerage_id(null)
 user_id(null)
 property_id(null)
 type(null)
 stripe_id(null)
 stripe_customer_id(null)
 stripe_checkout_email(null)
 stripe_promotion_code(null)
 stripe_promotion_code_id(null)
 stripe_coupon_code_id(null)
 status(null)
 current_period_end(null)
 cancel_at_period_end(null)
 ended(null)
 last_change(null)
 last_activity_email_sent(null)
 created(null)
 modified(null)
 GlobalReachReport(array)
 id(null)
 property_id(null)
 wsj_desktop(null)
 wsj_mobile(null)
 wsj_expires(null)
 wsj_capture_started(null)
 mg_desktop(null)
 mg_mobile(null)
 mg_expires(null)
 mg_capture_started(null)
 bp_desktop(null)
 bp_mobile(null)
 bp_expires(null)
 gp_capture_started(null)
 mw_desktop(null)
 mw_mobile(null)
 mw_expires(null)
 mw_capture_started(null)
 ft_desktop(null)
 ft_mobile(null)
 ft_expires(null)
 ft_capture_started(null)
 nikkei_desktop(null)
 nikkei_mobile(null)
 nikkei_expires(null)
 nikkei_capture_started(null)
 pgl_desktop(null)
 pgl_mobile(null)
 pgl_expires(null)
 pgl_capture_started(null)
 robb_desktop(null)
 robb_mobile(null)
 robb_expires(null)
 robb_capture_started(null)
 juwai_desktop(null)
 juwai_mobile(null)
 juwai_expires(null)
 juwai_capture_started(null)
 leverage_desktop(null)
 leverage_mobile(null)
 leverage_expires(null)
 leverage_capture_started(null)
 created(null)
 modified(null)
 wsj_available(false)
 wsj_expired(true)
 wsj_desktop_proxy_screenshot(null)
 wsj_mobile_proxy_screenshot(null)
 mg_available(false)
 mg_expired(true)
 mg_desktop_proxy_screenshot(null)
 mg_mobile_proxy_screenshot(null)
 bp_available(false)
 bp_expired(true)
 bp_desktop_proxy_screenshot(null)
 bp_mobile_proxy_screenshot(null)
 mw_available(false)
 mw_expired(true)
 mw_desktop_proxy_screenshot(null)
 mw_mobile_proxy_screenshot(null)
 nikkei_available(false)
 nikkei_expired(true)
 nikkei_desktop_proxy_screenshot(null)
 nikkei_mobile_proxy_screenshot(null)
 pgl_available(false)
 pgl_expired(true)
 pgl_desktop_proxy_screenshot(null)
 pgl_mobile_proxy_screenshot(null)
 robb_available(false)
 robb_expired(true)
 robb_desktop_proxy_screenshot(null)
 robb_mobile_proxy_screenshot(null)
 juwai_available(false)
 juwai_expired(true)
 juwai_desktop_proxy_screenshot(null)
 juwai_mobile_proxy_screenshot(null)
 capture_processing(false)
 capture_error(empty)
 Image(array)
 0(array)
 id16960
 modelProperty
 model_id3668
 tagImage
 name35638.jpg
 typeimage/jpg
 size1238297
 uri/assets/16960.jpg
 order2835
 created2016-04-07 17:01:04
 modified2016-04-07 17:01:04
 1(array)
 id16961
 modelProperty
 model_id3668
 tagImage
 name35639.jpg
 typeimage/jpg
 size1479319
 uri/assets/16961.jpg
 order2836
 created2016-04-07 17:01:04
 modified2016-04-07 17:01:04
 2(array)
 id16962
 modelProperty
 model_id3668
 tagImage
 name35640.jpg
 typeimage/jpg
 size795266
 uri/assets/16962.jpg
 order2837
 created2016-04-07 17:01:04
 modified2016-04-07 17:01:04
 3(array)
 id16963
 modelProperty
 model_id3668
 tagImage
 name35641.jpg
 typeimage/jpg
 size1280506
 uri/assets/16963.jpg
 order2838
 created2016-04-07 17:01:04
 modified2016-04-07 17:01:04
 4(array)
 id16964
 modelProperty
 model_id3668
 tagImage
 name35642.jpg
 typeimage/jpg
 size1528680
 uri/assets/16964.jpg
 order2839
 created2016-04-07 17:01:04
 modified2016-04-07 17:01:04
 5(array)
 id16965
 modelProperty
 model_id3668
 tagImage
 name35643.jpg
 typeimage/jpg
 size1418080
 uri/assets/16965.jpg
 order2840
 created2016-04-07 17:01:04
 modified2016-04-07 17:01:05
 6(array)
 id16966
 modelProperty
 model_id3668
 tagImage
 name35644.jpg
 typeimage/jpg
 size862952
 uri/assets/16966.jpg
 order2841
 created2016-04-07 17:01:05
 modified2016-04-07 17:01:05
 7(array)
 id16967
 modelProperty
 model_id3668
 tagImage
 name35645.jpg
 typeimage/jpg
 size1048576
 uri/assets/16967.jpg
 order2842
 created2016-04-07 17:01:05
 modified2016-04-07 17:01:05
 User(array)
 0(array)
 id1260
 typeAgent
 brokerage_id16
 email[email protected]
 password5f5c318d9522ae839069d651653f3ab018e2d9c0
 recover_hash
 first_nameTaruna
 last_nameSharma
 title
 dre_num
 phone917-664-2343
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:24:00
 created2017-08-07 15:24:00
 notified(false)
 full_nameTaruna Sharma
 uri/agent-detail/1260/taruna-sharma
 profile_complete(true)
 UsersProperty(array)
 id1089
 user_id1260
 property_id3668
 sort_order0
 Brokerage(array)
 id16
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties20
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id1
 WOEID12589342
 timezone
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameCORE
 broker_of_record_name
 short_nameCORE
 usernameCORENYC
 password6bbc31e8f00594b7e3433f0a9c0cd7334bff73ae
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionCORE is the exclusive representative for Leverage Global Partners in New York City, New York, USA. CORE is the leading, full-service, boutique real estate brokerage specializing in the marketing of premiere residential properties. Headquartered in New York City, CORE was founded by CEO Shaun Osher and Jack Cayre, who envisioned a dynamic boutique brokerage based on integrity, informed by expertise and driven by innovation. CORE offers comprehensive real estate solutions for buyers, sellers, landlords, investors and developers. The firm is powered by an integrated team of accomplished professionals with extensive expertise in all aspects of real estate transactions. Thanks to a unique marketing approach, CORE ensures that its clients earn the highest market-driven prices. Our agents educate and shepherd buyers, sellers and landlords through the sales or leasing process. And we partner closely with developers, from the earliest stages of a project through closing; partnerships, which boast a proven, profitable track record. Within the past 8 years, CORE has marketed more than 30 new development properties and is the #1 brokerage in its class.
 communitiesManhattan Chelsea New York City Tribeca Midtown
 websitehttp://corenyc.com/
 address104 Fifth Avenue
 address_2
 cityNew York
 stateNY
 full_stateNew York
 countryUSA
 marketNew York
 market_2
 postal_code10011
 phone(212) 726-0778
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameShaun Osher
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-shaun-osher-founder-and-ceo-of-core/
 contact_big_profile_link_text
 contact_titleFounder and CEO
 contact_dre_num
 contact_quoteI invite you to contact me personally about New York City real estate.
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename16.jpg
 logo_filename16.jpg
 contact_image_filename16.jpg
 all_properties_link_image_filename16.jpg
 all_properties_linkhttp://corenyc.com/listings
 video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/cxxGtpBt-qzxAOUo0.js"></script>
 contact_video_embed_code
 meta_titleNew York City Real Estate | CORE | Leverage Global Partners
 meta_descriptionCORE is Leverage Global Partners' exclusive representative in New York City, NY, USA.
 meta_keywordsnew york city real estate, manhattan real estate, shaun osher, CORE, leverage global partners
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-04-01 15:35:47
 modified2019-10-29 20:06:57
 dre_num012345
 uri/brokerage-detail/16/core
 website_shortcorenyc.com
 name_with_locationCORE
 Image(empty)
 BrokerageLogoOverride(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id16
 nameWasher Dryer
 additional(false)
 created2016-04-07 14:05:42
 modified2016-04-07 14:05:42
 PropertiesPropertyFeature(array)
 id3534
 property_id3668
 property_feature_id16
 Icon(array)
 id3565
 modelPropertyFeature
 model_id16
 tagIcon
 name144.png
 typeimage/png
 size2080
 uri/assets/3565.png
 order0
 created2016-04-07 14:05:40
 modified2016-04-07 14:05:43
 1(array)
 id1
 nameBalcony/Terrace
 additional(false)
 created2016-04-07 14:00:26
 modified2016-04-07 14:00:26
 PropertiesPropertyFeature(array)
 id3535
 property_id3668
 property_feature_id1
 Icon(array)
 id3550
 modelPropertyFeature
 model_id1
 tagIcon
 name129.png
 typeimage/png
 size2147
 uri/assets/3550.png
 order0
 created2016-04-07 14:00:24
 modified2016-04-07 14:00:26
 Topic(empty)
- membership_subscription_temp_allowed_login(null)
- newsletter_member_types(array)
 Leverage Member: AgentLeverage Member: Agent
 Leverage Member: Broker or ManagementLeverage Member: Broker or Management
 Non-MemberNon-Member
- $request->data(empty)
- $this->validationErrors(array)
 Subscription(empty)
 Property(empty)
 User(empty)
 PropertyFeature(empty)
 SecondaryPropertyCategory(empty)
 Topic(empty)
 PrimaryPropertyCategory(empty)
 Brokerage(empty)
 StripeSubscription(empty)
 GlobalReachReport(empty)
 AccountExecutive(empty)
 Logo(empty)
 MainImage(empty)
 ContactImage(empty)
 ContactImage2(empty)
 ContactImage3(empty)
 BrokerOfRecordLogo(empty)
 MainArticle(empty)
 Location(empty)
 FeaturedImage(empty)
 Image(empty)
 UsersProperty(empty)
 BrokerageLogoOverride(empty)
 PropertiesSecondaryPropertyCategory(empty)
 PropertiesPropertyFeature(empty)
 Icon(empty)
 PropertiesTopic(empty)
- Loaded Helpers(array)
 0Permission
 1Number
 2SimpleGraph
 3DebugTimer
 4Toolbar
 5Session
 6Text
 7Flash
 8HtmlToolbar
 9Html
 10Form
====

Environment

App Constants

Constant	Value
CONFIG	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/Config/
GOOGLE_MAPS_PUBLIC_API_KEY	AIzaSyCD2zmgSzOEN-7tNHYSmGXL0MyWtMlHND4
GOOGLE_MAPS_PRIVATE_API_KEY	AIzaSyCIXpqYsaZp4_suK7IWeqUTIEbS_hMkoXs
RECAPTCHA_V2_SITE_KEY	6Lfs_EoUAAAAAKe8XSwR8p7AEMOLWB96veSLjRDv
RECAPTCHA_V2_SECRET_KEY	6Lfs_EoUAAAAAIo2vzNYILL-YwBaRxvTpjuemmKZ
PROTOCOL	https://
WEB_ENV	staging2
WEB_BASE_URL	https://staging2.leveragere.com
PROP_EMAIL_RECIPIENT	[email protected]
STRIPE_ISSUES_EMAIL_RECIPIENT	[email protected]
STRIPE_ENV	test
STRIPE_PK	pk_test_fIc7eHMfMVAhnrld2Vk2DDpG
STRIPE_SK	sk_test_D4NvWbVo5Fe04IJM0AItMKIR
SHELL_LAUNCHER	/opt/plesk/php/7.4/bin/php /var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/Console/cake.php

CakePHP Constants

Constant	Value
APP	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/
APP_DIR	app
APPLIBS	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/Lib/
CACHE	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/tmp/cache/
CAKE	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/lib/Cake/
CAKE_CORE_INCLUDE_PATH	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/lib
CORE_PATH	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/lib/
CAKE_VERSION	2.10.19
CSS	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot/css/
CSS_URL	css/
DS	/
FULL_BASE_URL	https://staging2.leveragere.com
IMAGES	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot/img/
IMAGES_URL	img/
JS	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot/js/
JS_URL	js/
LOGS	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/tmp/logs/
ROOT	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs
TESTS	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/Test/
TMP	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/tmp/
VENDORS	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/vendors/
WEBROOT_DIR	webroot
WWW_ROOT	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot/

PHP Environment

Environment Variable	Value
Php Version	7.4.33
User	leveragere
Home	/var/www/vhosts/leveragere.com
Script Name	/index.php
Request Uri	/property-detail/3668/250-east-54th-street-23d-new-york-ny-10022-usa
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/property-detail/3668/250-east-54th-street-23d-new-york-ny-10022-usa
Remote Port	14403
Script Filename	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot/index.php
Server Admin	root@localhost
Context Document Root	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot
Context Prefix
Request Scheme	https
Document Root	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot
Remote Addr	104.23.197.115
Server Port	443
Server Addr	172.24.32.44
Server Name	staging2.leveragere.com
Server Software	Apache
Server Signature
Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
Http Host	staging2.leveragere.com
Http Connection	Keep-Alive
Http X Forwarded Proto	https
Http Cf Visitor	{"scheme":"https"}
Http Cf Ipcountry	US
Http Cf Connecting Ip	216.73.216.172
Http Cdn Loop	cloudflare; loops=1
Http User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])
Http Accept Encoding	gzip, br
Http Accept	/
Http Cf Ray	a09e11767ea81709-CMH
Http X Forwarded For	216.73.216.172
Proxy-nokeepalive	1
Ssl Tls Sni	staging2.leveragere.com
Https	on
Passenger Download Native Support Binary	0
Passenger Compile Native Support Binary	0
Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Unique Id	aipBk1LEEfcqtnCHo5U6cQAAAAA
Redirect Status	200
Redirect Ssl Tls Sni	staging2.leveragere.com
Redirect Https	on
Redirect Passenger Download Native Support Binary	0
Redirect Passenger Compile Native Support Binary	0
Redirect Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Redirect Unique Id	aipBk1LEEfcqtnCHo5U6cQAAAAA
Fcgi Role	RESPONDER
Php Self	/index.php
Request Time Float	1781154195.0674
Request Time	1781154195

====

Include
+
Included Files

Include Paths
- 0/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/lib
- 2/opt/plesk/php/7.4/share/pear
- 3-> /var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/lib/Cake/
Included Files
- core(array)
  Behavior(array)
  0CORE/Model/Behavior/ContainableBehavior.php
  Cache(array)
  0CORE/Cache/Cache.php
  1CORE/Cache/Engine/FileEngine.php
  2CORE/Cache/CacheEngine.php
  Component(array)
  0CORE/Controller/Component/AuthComponent.php
  1CORE/Controller/Component/SessionComponent.php
  2CORE/Controller/Component/CookieComponent.php
  3CORE/Controller/Component/RequestHandlerComponent.php
  4CORE/Controller/Component/Auth/FormAuthenticate.php
  5CORE/Controller/Component/Auth/BaseAuthenticate.php
  Config(array)
  0CORE/Config/routes.php
  1CORE/Config/config.php
  Controller(array)
  0CORE/Controller/Controller.php
  1CORE/Controller/ComponentCollection.php
  2CORE/Controller/Component.php
  Datasource(array)
  0CORE/Model/Datasource/CakeSession.php
  1CORE/Model/Datasource/Database/Mysql.php
  2CORE/Model/Datasource/DboSource.php
  3CORE/Model/Datasource/DataSource.php
  Error(array)
  0CORE/Error/exceptions.php
  1CORE/Error/ErrorHandler.php
  I18n(array)
  0CORE/I18n/I18n.php
  1CORE/I18n/L10n.php
  Log(array)
  0CORE/Log/CakeLog.php
  1CORE/Log/LogEngineCollection.php
  2CORE/Log/Engine/FileLog.php
  3CORE/Log/Engine/BaseLog.php
  4CORE/Log/CakeLogInterface.php
  Model(array)
  0CORE/Model/Model.php
  1CORE/Model/BehaviorCollection.php
  2CORE/Model/ModelBehavior.php
  3CORE/Model/ConnectionManager.php
  Network(array)
  0CORE/Network/CakeRequest.php
  1CORE/Network/CakeResponse.php
  Other(array)
  0CORE/bootstrap.php
  1CORE/basics.php
  2CORE/Core/App.php
  3CORE/Core/Configure.php
  4CORE/Core/CakePlugin.php
  5CORE/Event/CakeEventListener.php
  6CORE/Event/CakeEvent.php
  7CORE/Event/CakeEventManager.php
  8CORE/Core/CakeObject.php
  Routing(array)
  0CORE/Routing/Dispatcher.php
  1CORE/Routing/Filter/AssetDispatcher.php
  2CORE/Routing/DispatcherFilter.php
  3CORE/Routing/Filter/CacheDispatcher.php
  4CORE/Routing/Router.php
  5CORE/Routing/Route/CakeRoute.php
  6CORE/Routing/Route/RedirectRoute.php
  7CORE/Routing/Route/PluginShortRoute.php
  Utility(array)
  0CORE/Utility/Hash.php
  1CORE/Utility/Inflector.php
  2CORE/Utility/ObjectCollection.php
  3CORE/Utility/Debugger.php
  4CORE/Utility/CakeText.php
  5CORE/Utility/ClassRegistry.php
  View(array)
  0CORE/View/HelperCollection.php
- app(array)
  Component(array)
  0APP/Controller/Component/PermissionComponent.php
  1APP/Controller/Component/ExploreComponent.php
  2APP/Controller/Component/PropertyEmailComponent.php
  Config(array)
  0APP/Config/core.php
  1APP/Config/bootstrap.php
  2APP/Config/routes.php
  3APP/Config/database.php
  Controller(array)
  0APP/Controller/PropertiesController.php
  1APP/Controller/AppController.php
  Model(array)
  0APP/Model/Subscription.php
  1APP/Model/AppModel.php
  2APP/Model/Property.php
  3APP/Model/User.php
  4APP/Model/PropertyFeature.php
  5APP/Model/PropertyCategory.php
  6APP/Model/Topic.php
  7APP/Model/Brokerage.php
  8APP/Model/StripeSubscription.php
  9APP/Model/GlobalReachReport.php
  10APP/Model/Asset.php
  11APP/Model/Article.php
  12APP/Model/Location.php
  Other(array)
  0APP/webroot/index.php
  1APP/Vendor/permissions.php
- plugins(array)
  DebugKit(array)
  Component(array)
  0DebugKit/Controller/Component/ToolbarComponent.php
  Plugin(array)
  0DebugKit/Lib/DebugMemory.php
  1DebugKit/Lib/Panel/HistoryPanel.php
  2DebugKit/Lib/DebugPanel.php
  3DebugKit/Lib/Panel/SessionPanel.php
  4DebugKit/Lib/Panel/RequestPanel.php
  5DebugKit/Lib/Panel/SqlLogPanel.php
  6DebugKit/Lib/Panel/TimerPanel.php
  7DebugKit/Lib/Panel/LogPanel.php
  8DebugKit/Lib/Log/Engine/DebugKitLog.php
  9DebugKit/Lib/Panel/VariablesPanel.php
  10DebugKit/Lib/Panel/EnvironmentPanel.php
  11DebugKit/Lib/Panel/IncludePanel.php
  12DebugKit/Lib/DebugTimer.php
====

Midtown East Gem

Represented By: CORE

corenyc.com | License #: 012345

Highlighted Properties

Share This

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 22 ms Total Queries: 35 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 22 ms
Total Queries: 35 queries