Properties /

EXCEPTIONAL CONSTRUCTION IN LARCHMONT

15 Crescent Road | Larchmont, NY 10538, USA | $2,999,000

7 Beds
6 Baths
1 Half Ba
Garage

Exceptional new construction by premiere Westchester builder in an ideal Larchmont location. Walk to Murray Avenue School. 7 Bedrooms. 6.1 Baths. Spacious open floor plan with 9′ ceilings. The first floor features a Gourmet Eat In Kitchen with top of the line stainless steel appliances, Butler’s Pantry, center island & breakfast room that flows into the family room. Formal living room with coffered ceiling & fireplace. Formal Dining Room with tray ceilings. Entry foyer with main staircase and powder room. First floor Bedroom with en suite bath. Mudroom with access to 2 car garage. The second level features a Master Bedroom Suite with tray ceilings, two Walk In Closets, dressing area & spa bath. 4 additional family bedrooms, two with en suite baths, a hall bath, Laundry Room and back staircase complete second level. Spacious lower level with bedroom, bath, Rec Room and Exercise Room. Room for optional wine room or home theater. Custom millwork throughout. Still time to customize and select finishes.

Represented By: Platinum Drive Realty, Inc.

View On Map

Highlighted Properties

CALIFORNIA STYLE LIVING IN THE SUBURBS

230 Hillair Circle | White Plains, NY 10605
$1,070,000

SPECTACULAR SCARSDALE ESTATE ON 1.52 ACR

25 Mamaroneck Road | Scarsdale, NY 10583
$2,398,000

Represented By

Featured Location

Westchester County, NY, USA

Westchester County- great schools and natural beauty just minutes from NYC!

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)
  03189
  115-crescent-road-larchmont-ny-10538-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: 11 ms
Total Queries: 31 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` = 3189 AND `Property`.`archived` = '0' AND `Brokerage`.`archived` = '0' AND `Property`.`incomplete` = '0' LIMIT 1	1	1	1
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	1
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` = 237 AND `Logo`.`model` = 'Brokerage' AND `Logo`.`tag` = 'Logo'	1	1	0
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` = 237 AND `MainImage`.`model` = 'Brokerage' AND `MainImage`.`tag` = 'MainImage'	1	1	0
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` = 237 AND `ContactImage`.`model` = 'Brokerage' AND `ContactImage`.`tag` = 'ContactImage'	1	1	0
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` = 237 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` = 237 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` = 237 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` = 237 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` = (237) 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` = (237)	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` = (237)	4	4	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` = (3189) 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` = 3189 AND `UsersProperty`.`user_id` = `User`.`id`) ORDER BY `UsersProperty`.`sort_order` ASC	0	0	3	maybe slow
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` = 3189 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` = 3189 AND `PropertiesPropertyFeature`.`property_feature_id` = `PropertyFeature`.`id`)	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` = 4 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` = 3189 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` != 3189 AND `Property`.`brokerage_id` = 237 AND `Property`.`status` != 'Sold' AND `Property`.`incomplete` = '0' ORDER BY RAND() ASC LIMIT 2	2	2	2
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 (3192, 3553) ORDER BY `Image`.`order` ASC	20	20	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` IN (3192, 3553) 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 (3192, 3553) 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 (3192, 3553) 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 (3192, 3553) 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` = 237 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` = 237 AND `Property`.`incomplete` = '0' ORDER BY RAND() ASC LIMIT 4	4	4	2	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 (3186, 3191, 3178, 3187) ORDER BY `Image`.`order` ASC	23	23	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 (3186, 3191, 3178, 3187) AND `UsersProperty`.`user_id` = `User`.`id`) ORDER BY `UsersProperty`.`sort_order` ASC	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` IN (3186, 3191, 3178, 3187) 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 (3186, 3191, 3178, 3187) 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 (3186, 3191, 3178, 3187) AND `PropertiesTopic`.`topic_id` = `Topic`.`id`)	0	0	0

Query Explain:

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

====

Timer

Memory

Peak Memory Use 14.07 MB

Message	Memory use
Component initialization	3.09 MB
Controller action start	4.02 MB
Controller render start	6.76 MB
View render complete	7.28 MB

Timers

Total Request Time: 223 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	32.68
Event: Controller.initialize	4.23
Event: Controller.startup	1.19
Controller action	40.99
Event: Controller.beforeRender	15.07
» Processing toolbar data	14.97
Rendering View	95.99
» Event: View.beforeRender	0.27
» Rendering APP/View/Properties/view.ctp	3.25
» » Rendering APP/View/Elements/static_property_price.ctp	0.40
» » Rendering APP/View/Elements/property_features.ctp	0.23
» » 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	0.99
» » » Rendering APP/View/Elements/static_property_price.ctp #4	0.15
» » » Rendering APP/View/Elements/static_property_price.ctp #5	0.14
» » » Rendering APP/View/Elements/static_property_price.ctp #6	0.14
» » » Rendering APP/View/Elements/static_property_price.ctp #7	0.14
» » Rendering APP/View/Elements/sidebar/property_search.ctp	0.21
» Event: View.afterRender	0.01
» Event: View.beforeLayout	0.01
» Rendering APP/View/Layouts/front.ctp	91.74
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)
 id3186
 brokerage_id237
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id1064
 agent_2_id0
 agent_3_id0
 nameSTUNNING COLONIAL ON EXPANSIVE PROPERTY
 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)
 descriptionEnjoy beautiful views from this stunning new colonial! Impressive circular driveway leads to this grand custom built home on expansive .61 acre lot with potential room for a pool. Over 8000 square feet of ideal living space including grand foyer, open kitchen with double island, family room, dining room, Living room, plus 1st floor guest suite, study and dream mudroom with custom built cubbies that accesses the three car garage. The second floor boasts well proportioned rooms including a Master Suite with 2 over-sized walk in closets, 4 additional family bedrooms each with en suite bath, and a separate laundry room. The lower level includes an aupair suite with full bathroom and large rec room with 9 foot ceilings. Built by local builder with an exceptional attention to detail and finishes. Ideally located within walking distance to Quaker Ridge Elementary school and houses of worship! Home has a built in natural gas back up generator and comes pre wired for camera/security system and surround sound.
 address20 Meadow Road
 address_2
 cityScarsdale
 stateNY
 postal_code10583
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price4295000
 price_20
 price_usd4295000
 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)
 bedrooms7
 bedrooms_20
 bathrooms7
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1views
 icon_2garage
 icon_3
 icon_4
 icon_5
 icon_6
 website
 meta_titleSTUNNING COLONIAL ON EXPANSIVE PROPERTY | Scarsdale Real Estate | Platinum Drive Realty, Inc.
 meta_description20 Meadow Road is a property offered for sale in Scarsdale, NY, USA, presented by Platinum Drive Realty, Inc.
 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_fieldsagent_2_id, square_feet, square_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:02
 created2015-12-06 08:47:23
 uri/property-detail/3186/20-meadow-road-scarsdale-ny-10583-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3186/20-meadow-road-scarsdale-ny-10583-usa
 address_concat20 Meadow Road Scarsdale NY 10583 USA
 google_maps_query_string20+Meadow+Road++Scarsdale+NY+10583+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 4,295,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty7
 bathrooms_pretty7
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms7
 date_listed2015-12-06
 overridden_brokerage_namePlatinum Drive Realty, Inc.
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id237
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typeBasic
 max_properties8
 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(true)
 country_id0
 WOEID2361170
 timezoneUS/Eastern
 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
 namePlatinum Drive Realty, Inc.
 broker_of_record_name
 short_namePlatinum Drive Realty, Inc.
 usernameplatinumdriverealty
 passwordcf19692bb5fdde944ba4679ddfce5f7df0ee8592
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionPlatinum Drive Realty, Inc. is the exclusive representative for Leverage Global Partners in Westchester County, including Ardsley, Armonk, Bedford, Chappaqua, Eastchester, Edgemont, Harrison, Hastings, Irvington, Larchmont, Mamaroneck, New Rochelle, Pelham, Pound Ridge, Purchase, Rye, Rye Brook, Scarsdale, and White Plains, NY, USA. Platinum Drive Realty is a leading real estate firm in Westchester County, NY. The firm was founded by Westchester residents Zachary Harrison, Heather Harrison, and Heather's grandmother Sunny, who has been in the real estate business for over 50 years. We believe that real estate should be an enjoyable, rewarding, and first-rate experience. The role of a great real estate agent is much more than opening a door. From the moment of our first contact to negotiating a successful deal, Platinum Drive will take you to your real estate destination in style, with the highest level of personal and professional service. We serve a wide variety of clients, from first-time home buyers and sellers, to experienced homeowners, buyers, builders and investors. Whether you are moving in or out of Westchester, trading up or down, or buying a second home, we are here to meet your real estate needs. We are proud of the strong, lasting relationships we have built with our clients and our adherence to the highest ethical standards. Our agents bring great passion and knowledge to the markets we serve, an expansive network, cutting edge research and marketing strategies, and excellent negotiation skills to each transaction. In 2015 and 2014, Platinum Drive Realty was named the fastest growing real estate brokerage firm in New York State and one of the fastest growing private companies in American in a survey by Inc. Magazine. Platinum Drive is committed to giving back to the community. We participate in various charitable causes. Making a positive contribution to the community is an important part of our firm culture. We look forward to working with you to achieve great results together. Please contact us today at 914.725.7737 or [email protected] 
 communitiesWestchester county Ardsley Armonk Bedford Chappaqua Eastchester Edgemont Harrison Hastings Irvington Larchmont Mamaroneck New Rochelle Pelham Pound Ridge Purchase Rye Rye Brook Scarsdale White Plains
 websitehttp://www.platinumdr.com/
 address1082 Wilmot Road
 address_2
 cityScarsdale
 stateNY
 full_stateNew York
 countryUSA
 marketWestchester County
 market_2
 postal_code10583
 phoneZachary Cell: (917) 299-7832
 phone_2Heather Cell: (917) 299-7490
 phone_3Office: (914) 725-7737
 wide_contact_image(false)
 contact_nameZachary Harrison & Heather Harrison
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePresident/Licensed Real Estate Broker & Co-Founder/Licensed Real Estate Salesperson
 contact_dre_num
 contact_quoteWe invite you to contact us personally about Westchester County real estate.
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2[email protected]
 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_filename237.jpg
 logo_filename237.jpg
 contact_image_filename237.jpg
 all_properties_link_image_filename237.jpg
 all_properties_linkhttp://www.platinumdr.com/featured/
 video_embed_code
 contact_video_embed_code
 meta_titleWestchester County Real Estate | Platinum Drive Realty | Leverage Global Partners
 meta_descriptionPlatinum Drive Realty, Inc. is the exclusive representative for Leverage Global Partners in Westchester County, NY, including Ardsley, Armonk, Bedford, Chappaqua, Eastchester, Edgemont, Harrison, Hastings, Irvington, Larchmont, Mamaroneck, New Rochelle, Pelham, Pound Ridge, Purchase, Rye, Rye Brook, Scarsdale, and White Plains.
 meta_keywordsPlatinum Drive Realty, Inc., Leverage Global Partners, Westchester County real estate, New York real estate, Ardsley real estate, Armonk real estate, Bedford real estate, Chappaqua real estate, Eastchester real estate, Edgemont real estate, Harrison real estate, Hastings real estate, Irvington real estate, Larchmont real estate, Mamaroneck real estate, New Rochelle real estate, Pelham real estate, Pound Ridge real estate, Purchase real estate, Rye real estate, Rye Brook real estate, Scarsdale real estate, White Plains real estate
 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)
 created2015-11-23 12:37:07
 modified2016-04-08 16:34:31
 dre_num012345
 uri/brokerage-detail/237/platinum-drive-realty-inc
 website_shortwww.platinumdr.com
 name_with_locationPlatinum Drive Realty, Inc.
 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)
 id15390
 modelProperty
 model_id3186
 tagImage
 name30770.jpg
 typeimage/jpg
 size1618045
 uri/assets/15390.jpg
 order0
 created2016-04-07 16:52:02
 modified2016-04-07 16:52:02
 1(array)
 id15389
 modelProperty
 model_id3186
 tagImage
 name30771.jpg
 typeimage/jpg
 size689191
 uri/assets/15389.jpg
 order1
 created2016-04-07 16:52:02
 modified2016-04-07 16:52:02
 2(array)
 id15391
 modelProperty
 model_id3186
 tagImage
 name30772.jpg
 typeimage/jpg
 size727557
 uri/assets/15391.jpg
 order2
 created2016-04-07 16:52:02
 modified2016-04-07 16:52:02
 3(array)
 id15392
 modelProperty
 model_id3186
 tagImage
 name30773.jpg
 typeimage/jpg
 size823412
 uri/assets/15392.jpg
 order3
 created2016-04-07 16:52:02
 modified2016-04-07 16:52:02
 4(array)
 id15393
 modelProperty
 model_id3186
 tagImage
 name30774.jpg
 typeimage/jpg
 size595401
 uri/assets/15393.jpg
 order4
 created2016-04-07 16:52:02
 modified2016-04-07 16:52:02
 5(array)
 id15394
 modelProperty
 model_id3186
 tagImage
 name30775.jpg
 typeimage/jpg
 size872667
 uri/assets/15394.jpg
 order5
 created2016-04-07 16:52:02
 modified2016-04-07 16:52:02
 6(array)
 id15395
 modelProperty
 model_id3186
 tagImage
 name30776.jpg
 typeimage/jpg
 size648473
 uri/assets/15395.jpg
 order6
 created2016-04-07 16:52:02
 modified2016-04-07 16:52:02
 7(array)
 id15396
 modelProperty
 model_id3186
 tagImage
 name30777.jpg
 typeimage/jpg
 size817107
 uri/assets/15396.jpg
 order7
 created2016-04-07 16:52:02
 modified2016-04-07 16:52:02
 8(array)
 id15397
 modelProperty
 model_id3186
 tagImage
 name30778.jpg
 typeimage/jpg
 size620087
 uri/assets/15397.jpg
 order8
 created2016-04-07 16:52:02
 modified2016-04-07 16:52:02
 9(array)
 id15398
 modelProperty
 model_id3186
 tagImage
 name30779.jpg
 typeimage/jpg
 size2051017
 uri/assets/15398.jpg
 order9
 created2016-04-07 16:52:02
 modified2016-04-07 16:52:03
 User(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id14
 nameViews
 additional(false)
 created2016-04-07 14:04:55
 modified2016-04-07 14:04:55
 PropertiesPropertyFeature(array)
 id3144
 property_id3186
 property_feature_id14
 1(array)
 id4
 nameGarage
 additional(false)
 created2016-04-07 14:01:52
 modified2016-04-07 14:01:52
 PropertiesPropertyFeature(array)
 id3145
 property_id3186
 property_feature_id4
 Topic(empty)
 1(array)
 Property(array)
 id3191
 brokerage_id237
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id1064
 agent_2_id0
 agent_3_id0
 nameIMPRESSIVE COLLETTE BUILT BRICK COLONIAL
 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)
 descriptionImpressive Collette built Georgian brick colonial located in Murray Hill with incredible curb appeal and extraordinary landscaping with beautiful up lighting for grand nighttime presence. Stunning architectural details throughout including custom built ins, detailed moldings and archways, and beautiful hardwood floors. Ideal layout for gracious entertaining. There is a 3 car garage, a mudroom, back staircase, and perfectly level property with room for expansion. Upgraded mechanicals include new lower level AC/Heat (3 years old) and Hot water tank (2 years old).
 address28 Heathcote Road
 address_2
 cityScarsdale
 stateNY
 postal_code10583
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price2795000
 price_20
 price_usd2795000
 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)
 bedrooms6
 bedrooms_20
 bathrooms7
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1garage
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 website
 meta_titleIMPRESSIVE COLLETTE BUILT BRICK COLONIAL | Scarsdale Real Estate | Platinum Drive Realty, Inc.
 meta_description28 Heathcote Road is a property offered for sale in Scarsdale, NY, USA, presented by Platinum Drive Realty, Inc.
 meta_keywords
 bathrooms_partial2
 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_fieldsagent_2_id, square_feet, square_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
 created2015-12-06 10:40:38
 uri/property-detail/3191/28-heathcote-road-scarsdale-ny-10583-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3191/28-heathcote-road-scarsdale-ny-10583-usa
 address_concat28 Heathcote Road Scarsdale NY 10583 USA
 google_maps_query_string28+Heathcote+Road++Scarsdale+NY+10583+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 2,795,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty6
 bathrooms_pretty7
 bathrooms_partial_pretty2
 bathrooms_3_4_pretty0
 feed_full_bathrooms7
 date_listed2015-12-06
 overridden_brokerage_namePlatinum Drive Realty, Inc.
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id237
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typeBasic
 max_properties8
 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(true)
 country_id0
 WOEID2361170
 timezoneUS/Eastern
 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
 namePlatinum Drive Realty, Inc.
 broker_of_record_name
 short_namePlatinum Drive Realty, Inc.
 usernameplatinumdriverealty
 passwordcf19692bb5fdde944ba4679ddfce5f7df0ee8592
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionPlatinum Drive Realty, Inc. is the exclusive representative for Leverage Global Partners in Westchester County, including Ardsley, Armonk, Bedford, Chappaqua, Eastchester, Edgemont, Harrison, Hastings, Irvington, Larchmont, Mamaroneck, New Rochelle, Pelham, Pound Ridge, Purchase, Rye, Rye Brook, Scarsdale, and White Plains, NY, USA. Platinum Drive Realty is a leading real estate firm in Westchester County, NY. The firm was founded by Westchester residents Zachary Harrison, Heather Harrison, and Heather's grandmother Sunny, who has been in the real estate business for over 50 years. We believe that real estate should be an enjoyable, rewarding, and first-rate experience. The role of a great real estate agent is much more than opening a door. From the moment of our first contact to negotiating a successful deal, Platinum Drive will take you to your real estate destination in style, with the highest level of personal and professional service. We serve a wide variety of clients, from first-time home buyers and sellers, to experienced homeowners, buyers, builders and investors. Whether you are moving in or out of Westchester, trading up or down, or buying a second home, we are here to meet your real estate needs. We are proud of the strong, lasting relationships we have built with our clients and our adherence to the highest ethical standards. Our agents bring great passion and knowledge to the markets we serve, an expansive network, cutting edge research and marketing strategies, and excellent negotiation skills to each transaction. In 2015 and 2014, Platinum Drive Realty was named the fastest growing real estate brokerage firm in New York State and one of the fastest growing private companies in American in a survey by Inc. Magazine. Platinum Drive is committed to giving back to the community. We participate in various charitable causes. Making a positive contribution to the community is an important part of our firm culture. We look forward to working with you to achieve great results together. Please contact us today at 914.725.7737 or [email protected] 
 communitiesWestchester county Ardsley Armonk Bedford Chappaqua Eastchester Edgemont Harrison Hastings Irvington Larchmont Mamaroneck New Rochelle Pelham Pound Ridge Purchase Rye Rye Brook Scarsdale White Plains
 websitehttp://www.platinumdr.com/
 address1082 Wilmot Road
 address_2
 cityScarsdale
 stateNY
 full_stateNew York
 countryUSA
 marketWestchester County
 market_2
 postal_code10583
 phoneZachary Cell: (917) 299-7832
 phone_2Heather Cell: (917) 299-7490
 phone_3Office: (914) 725-7737
 wide_contact_image(false)
 contact_nameZachary Harrison & Heather Harrison
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePresident/Licensed Real Estate Broker & Co-Founder/Licensed Real Estate Salesperson
 contact_dre_num
 contact_quoteWe invite you to contact us personally about Westchester County real estate.
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2[email protected]
 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_filename237.jpg
 logo_filename237.jpg
 contact_image_filename237.jpg
 all_properties_link_image_filename237.jpg
 all_properties_linkhttp://www.platinumdr.com/featured/
 video_embed_code
 contact_video_embed_code
 meta_titleWestchester County Real Estate | Platinum Drive Realty | Leverage Global Partners
 meta_descriptionPlatinum Drive Realty, Inc. is the exclusive representative for Leverage Global Partners in Westchester County, NY, including Ardsley, Armonk, Bedford, Chappaqua, Eastchester, Edgemont, Harrison, Hastings, Irvington, Larchmont, Mamaroneck, New Rochelle, Pelham, Pound Ridge, Purchase, Rye, Rye Brook, Scarsdale, and White Plains.
 meta_keywordsPlatinum Drive Realty, Inc., Leverage Global Partners, Westchester County real estate, New York real estate, Ardsley real estate, Armonk real estate, Bedford real estate, Chappaqua real estate, Eastchester real estate, Edgemont real estate, Harrison real estate, Hastings real estate, Irvington real estate, Larchmont real estate, Mamaroneck real estate, New Rochelle real estate, Pelham real estate, Pound Ridge real estate, Purchase real estate, Rye real estate, Rye Brook real estate, Scarsdale real estate, White Plains real estate
 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)
 created2015-11-23 12:37:07
 modified2016-04-08 16:34:31
 dre_num012345
 uri/brokerage-detail/237/platinum-drive-realty-inc
 website_shortwww.platinumdr.com
 name_with_locationPlatinum Drive Realty, Inc.
 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)
 id18385
 modelProperty
 model_id3191
 tagImage
 name30780.jpg
 typeimage/jpg
 size1923550
 uri/assets/18385.jpg
 order0
 created2016-04-07 17:09:06
 modified2016-04-07 17:09:06
 1(array)
 id18386
 modelProperty
 model_id3191
 tagImage
 name30781.jpg
 typeimage/jpg
 size1283193
 uri/assets/18386.jpg
 order1
 created2016-04-07 17:09:06
 modified2016-04-07 17:09:06
 2(array)
 id18387
 modelProperty
 model_id3191
 tagImage
 name30782.jpg
 typeimage/jpg
 size1431965
 uri/assets/18387.jpg
 order2
 created2016-04-07 17:09:06
 modified2016-04-07 17:09:06
 3(array)
 id18388
 modelProperty
 model_id3191
 tagImage
 name30783.jpg
 typeimage/jpg
 size1420526
 uri/assets/18388.jpg
 order3
 created2016-04-07 17:09:06
 modified2016-04-07 17:09:06
 4(array)
 id18389
 modelProperty
 model_id3191
 tagImage
 name30784.jpg
 typeimage/jpg
 size1715999
 uri/assets/18389.jpg
 order4
 created2016-04-07 17:09:06
 modified2016-04-07 17:09:06
 5(array)
 id18390
 modelProperty
 model_id3191
 tagImage
 name30785.jpg
 typeimage/jpg
 size1339099
 uri/assets/18390.jpg
 order5
 created2016-04-07 17:09:06
 modified2016-04-07 17:09:06
 6(array)
 id18391
 modelProperty
 model_id3191
 tagImage
 name30786.jpg
 typeimage/jpg
 size1358053
 uri/assets/18391.jpg
 order6
 created2016-04-07 17:09:06
 modified2016-04-07 17:09:06
 7(array)
 id18392
 modelProperty
 model_id3191
 tagImage
 name30787.jpg
 typeimage/jpg
 size1365280
 uri/assets/18392.jpg
 order7
 created2016-04-07 17:09:06
 modified2016-04-07 17:09:06
 8(array)
 id18393
 modelProperty
 model_id3191
 tagImage
 name30788.jpg
 typeimage/jpg
 size1867023
 uri/assets/18393.jpg
 order8
 created2016-04-07 17:09:06
 modified2016-04-07 17:09:06
 9(array)
 id18394
 modelProperty
 model_id3191
 tagImage
 name30789.jpg
 typeimage/jpg
 size1999346
 uri/assets/18394.jpg
 order9
 created2016-04-07 17:09:06
 modified2016-04-07 17:09:06
 User(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id4
 nameGarage
 additional(false)
 created2016-04-07 14:01:52
 modified2016-04-07 14:01:52
 PropertiesPropertyFeature(array)
 id3873
 property_id3191
 property_feature_id4
 Topic(empty)
 2(array)
 Property(array)
 id3178
 brokerage_id237
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id1064
 agent_2_id0
 agent_3_id0
 nameElegant & Stately Custom Built Colonial
 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)
 descriptionElegant and stately new custom built colonial on almost 3/4 of an acre of incredible land with room for a pool. Over 9000 square feet of an amazing floor plan ideal for entertaining indoor and outdoors. There are three patios including a covered porch with outdoor fireplace and a three car garage that enters into a gracious mud room. There is also a library and second butler’s pantry on the first floor. The second floor has five bedrooms all en suite and a huge playroom with back staircase and laundry. The lower level can be anything you want with potential for a game room, wine storage, gym, playroom, maids’ room and full bath. This home is being built by one of Scarsdale’s finest custom home builders who will work with a buyer to make this home truly unique by customizing all interior finishes. This home is also ideally located close to five corners shopping, recreational facilities and houses of worship.
 address17 Harvest Drive
 address_2
 cityScarsdale
 stateNY
 postal_code10583
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price4995000
 price_20
 price_usd4995000
 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)
 bedrooms6
 bedrooms_20
 bathrooms7
 bathrooms_20
 no_beds_baths(false)
 square_feet9758
 square_meters
 acres7100
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size7100
 icon_1library
 icon_2sq-ft
 icon_3acreage
 icon_4garage
 icon_5gym
 icon_6
 websitehttp://www.platinumdr.com/properties/17-harvest-drive/
 meta_titleElegant & Stately Custom Built Colonial | Scarsdale Real Estate | Platinum Drive Realty, Inc.
 meta_description17 Harvest Drive is a property offered for sale in Scarsdale, NY, USA, presented by Platinum Drive Realty, Inc.
 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, 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-12-04 13:32:02
 uri/property-detail/3178/17-harvest-drive-scarsdale-ny-10583-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3178/17-harvest-drive-scarsdale-ny-10583-usa
 address_concat17 Harvest Drive Scarsdale NY 10583 USA
 google_maps_query_string17+Harvest+Drive++Scarsdale+NY+10583+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 4,995,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty6
 bathrooms_pretty7
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms7
 date_listed2015-12-04
 overridden_brokerage_namePlatinum Drive Realty, Inc.
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id237
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typeBasic
 max_properties8
 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(true)
 country_id0
 WOEID2361170
 timezoneUS/Eastern
 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
 namePlatinum Drive Realty, Inc.
 broker_of_record_name
 short_namePlatinum Drive Realty, Inc.
 usernameplatinumdriverealty
 passwordcf19692bb5fdde944ba4679ddfce5f7df0ee8592
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionPlatinum Drive Realty, Inc. is the exclusive representative for Leverage Global Partners in Westchester County, including Ardsley, Armonk, Bedford, Chappaqua, Eastchester, Edgemont, Harrison, Hastings, Irvington, Larchmont, Mamaroneck, New Rochelle, Pelham, Pound Ridge, Purchase, Rye, Rye Brook, Scarsdale, and White Plains, NY, USA. Platinum Drive Realty is a leading real estate firm in Westchester County, NY. The firm was founded by Westchester residents Zachary Harrison, Heather Harrison, and Heather's grandmother Sunny, who has been in the real estate business for over 50 years. We believe that real estate should be an enjoyable, rewarding, and first-rate experience. The role of a great real estate agent is much more than opening a door. From the moment of our first contact to negotiating a successful deal, Platinum Drive will take you to your real estate destination in style, with the highest level of personal and professional service. We serve a wide variety of clients, from first-time home buyers and sellers, to experienced homeowners, buyers, builders and investors. Whether you are moving in or out of Westchester, trading up or down, or buying a second home, we are here to meet your real estate needs. We are proud of the strong, lasting relationships we have built with our clients and our adherence to the highest ethical standards. Our agents bring great passion and knowledge to the markets we serve, an expansive network, cutting edge research and marketing strategies, and excellent negotiation skills to each transaction. In 2015 and 2014, Platinum Drive Realty was named the fastest growing real estate brokerage firm in New York State and one of the fastest growing private companies in American in a survey by Inc. Magazine. Platinum Drive is committed to giving back to the community. We participate in various charitable causes. Making a positive contribution to the community is an important part of our firm culture. We look forward to working with you to achieve great results together. Please contact us today at 914.725.7737 or [email protected] 
 communitiesWestchester county Ardsley Armonk Bedford Chappaqua Eastchester Edgemont Harrison Hastings Irvington Larchmont Mamaroneck New Rochelle Pelham Pound Ridge Purchase Rye Rye Brook Scarsdale White Plains
 websitehttp://www.platinumdr.com/
 address1082 Wilmot Road
 address_2
 cityScarsdale
 stateNY
 full_stateNew York
 countryUSA
 marketWestchester County
 market_2
 postal_code10583
 phoneZachary Cell: (917) 299-7832
 phone_2Heather Cell: (917) 299-7490
 phone_3Office: (914) 725-7737
 wide_contact_image(false)
 contact_nameZachary Harrison & Heather Harrison
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePresident/Licensed Real Estate Broker & Co-Founder/Licensed Real Estate Salesperson
 contact_dre_num
 contact_quoteWe invite you to contact us personally about Westchester County real estate.
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2[email protected]
 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_filename237.jpg
 logo_filename237.jpg
 contact_image_filename237.jpg
 all_properties_link_image_filename237.jpg
 all_properties_linkhttp://www.platinumdr.com/featured/
 video_embed_code
 contact_video_embed_code
 meta_titleWestchester County Real Estate | Platinum Drive Realty | Leverage Global Partners
 meta_descriptionPlatinum Drive Realty, Inc. is the exclusive representative for Leverage Global Partners in Westchester County, NY, including Ardsley, Armonk, Bedford, Chappaqua, Eastchester, Edgemont, Harrison, Hastings, Irvington, Larchmont, Mamaroneck, New Rochelle, Pelham, Pound Ridge, Purchase, Rye, Rye Brook, Scarsdale, and White Plains.
 meta_keywordsPlatinum Drive Realty, Inc., Leverage Global Partners, Westchester County real estate, New York real estate, Ardsley real estate, Armonk real estate, Bedford real estate, Chappaqua real estate, Eastchester real estate, Edgemont real estate, Harrison real estate, Hastings real estate, Irvington real estate, Larchmont real estate, Mamaroneck real estate, New Rochelle real estate, Pelham real estate, Pound Ridge real estate, Purchase real estate, Rye real estate, Rye Brook real estate, Scarsdale real estate, White Plains real estate
 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)
 created2015-11-23 12:37:07
 modified2016-04-08 16:34:31
 dre_num012345
 uri/brokerage-detail/237/platinum-drive-realty-inc
 website_shortwww.platinumdr.com
 name_with_locationPlatinum Drive Realty, Inc.
 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)
 id13866
 modelProperty
 model_id3178
 tagImage
 name30571.jpg
 typeimage/jpg
 size545465
 uri/assets/13866.jpg
 order0
 created2016-04-07 16:42:03
 modified2016-04-07 16:42:03
 1(array)
 id13867
 modelProperty
 model_id3178
 tagImage
 name30572.jpg
 typeimage/jpg
 size567037
 uri/assets/13867.jpg
 order1
 created2016-04-07 16:42:03
 modified2016-04-07 16:42:03
 User(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id4
 nameGarage
 additional(false)
 created2016-04-07 14:01:52
 modified2016-04-07 14:01:52
 PropertiesPropertyFeature(array)
 id2737
 property_id3178
 property_feature_id4
 1(array)
 id6
 nameGym
 additional(false)
 created2016-04-07 14:02:29
 modified2016-04-07 14:02:29
 PropertiesPropertyFeature(array)
 id2738
 property_id3178
 property_feature_id6
 Topic(empty)
 3(array)
 Property(array)
 id3187
 brokerage_id237
 created_by_user_id0
 order2
 multi_unit(false)
 agent_1_id1070
 agent_2_id0
 agent_3_id0
 nameELEGANT NEW CUSTOM BUILT COLONIAL
 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(true)
 large_featured(true)
 detail_page(true)
 descriptionOver 7000 square feet of an amazing floor plan ideal for entertaining indoor and outdoors. The first floor has a grand foyer, living room, dining room, family room, office and and state of the art chef’s kitchen with breakfast room overlooking the yard. There is also a 3 car attached garage that enters into a gracious mud room with second powder room. The second floor has a beautiful master suite with large master bath, 2 walk in closets and welcoming sitting room. There are 5 additional bedrooms (3 have ensuite baths and 2 have a shared bath) and a laundry room. This home is being built by one of Westchester’s finest home builders.
 address18 Sterling Road
 address_2
 cityArmonk
 stateNY
 postal_code10504
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price3990000
 price_20
 price_usd3990000
 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)
 bedrooms6
 bedrooms_20
 bathrooms5
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres2
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size2
 icon_1acreage
 icon_2garage
 icon_3balcony-terrace
 icon_4
 icon_5
 icon_6
 website
 meta_titleELEGANT NEW CUSTOM BUILT COLONIAL | Armonk Real Estate | Platinum Drive Realty, Inc.
 meta_description18 Sterling Road is a property offered for sale in Armonk, NY, USA, presented by Platinum Drive Realty, Inc.
 meta_keywords
 bathrooms_partial2
 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_fieldsagent_2_id, square_feet, square_meters, 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
 created2015-12-06 09:16:33
 uri/property-detail/3187/18-sterling-road-armonk-ny-10504-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3187/18-sterling-road-armonk-ny-10504-usa
 address_concat18 Sterling Road Armonk NY 10504 USA
 google_maps_query_string18+Sterling+Road++Armonk+NY+10504+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 3,990,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty6
 bathrooms_pretty5
 bathrooms_partial_pretty2
 bathrooms_3_4_pretty0
 feed_full_bathrooms5
 date_listed2015-12-06
 overridden_brokerage_namePlatinum Drive Realty, Inc.
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id237
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typeBasic
 max_properties8
 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(true)
 country_id0
 WOEID2361170
 timezoneUS/Eastern
 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
 namePlatinum Drive Realty, Inc.
 broker_of_record_name
 short_namePlatinum Drive Realty, Inc.
 usernameplatinumdriverealty
 passwordcf19692bb5fdde944ba4679ddfce5f7df0ee8592
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionPlatinum Drive Realty, Inc. is the exclusive representative for Leverage Global Partners in Westchester County, including Ardsley, Armonk, Bedford, Chappaqua, Eastchester, Edgemont, Harrison, Hastings, Irvington, Larchmont, Mamaroneck, New Rochelle, Pelham, Pound Ridge, Purchase, Rye, Rye Brook, Scarsdale, and White Plains, NY, USA. Platinum Drive Realty is a leading real estate firm in Westchester County, NY. The firm was founded by Westchester residents Zachary Harrison, Heather Harrison, and Heather's grandmother Sunny, who has been in the real estate business for over 50 years. We believe that real estate should be an enjoyable, rewarding, and first-rate experience. The role of a great real estate agent is much more than opening a door. From the moment of our first contact to negotiating a successful deal, Platinum Drive will take you to your real estate destination in style, with the highest level of personal and professional service. We serve a wide variety of clients, from first-time home buyers and sellers, to experienced homeowners, buyers, builders and investors. Whether you are moving in or out of Westchester, trading up or down, or buying a second home, we are here to meet your real estate needs. We are proud of the strong, lasting relationships we have built with our clients and our adherence to the highest ethical standards. Our agents bring great passion and knowledge to the markets we serve, an expansive network, cutting edge research and marketing strategies, and excellent negotiation skills to each transaction. In 2015 and 2014, Platinum Drive Realty was named the fastest growing real estate brokerage firm in New York State and one of the fastest growing private companies in American in a survey by Inc. Magazine. Platinum Drive is committed to giving back to the community. We participate in various charitable causes. Making a positive contribution to the community is an important part of our firm culture. We look forward to working with you to achieve great results together. Please contact us today at 914.725.7737 or [email protected] 
 communitiesWestchester county Ardsley Armonk Bedford Chappaqua Eastchester Edgemont Harrison Hastings Irvington Larchmont Mamaroneck New Rochelle Pelham Pound Ridge Purchase Rye Rye Brook Scarsdale White Plains
 websitehttp://www.platinumdr.com/
 address1082 Wilmot Road
 address_2
 cityScarsdale
 stateNY
 full_stateNew York
 countryUSA
 marketWestchester County
 market_2
 postal_code10583
 phoneZachary Cell: (917) 299-7832
 phone_2Heather Cell: (917) 299-7490
 phone_3Office: (914) 725-7737
 wide_contact_image(false)
 contact_nameZachary Harrison & Heather Harrison
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePresident/Licensed Real Estate Broker & Co-Founder/Licensed Real Estate Salesperson
 contact_dre_num
 contact_quoteWe invite you to contact us personally about Westchester County real estate.
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2[email protected]
 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_filename237.jpg
 logo_filename237.jpg
 contact_image_filename237.jpg
 all_properties_link_image_filename237.jpg
 all_properties_linkhttp://www.platinumdr.com/featured/
 video_embed_code
 contact_video_embed_code
 meta_titleWestchester County Real Estate | Platinum Drive Realty | Leverage Global Partners
 meta_descriptionPlatinum Drive Realty, Inc. is the exclusive representative for Leverage Global Partners in Westchester County, NY, including Ardsley, Armonk, Bedford, Chappaqua, Eastchester, Edgemont, Harrison, Hastings, Irvington, Larchmont, Mamaroneck, New Rochelle, Pelham, Pound Ridge, Purchase, Rye, Rye Brook, Scarsdale, and White Plains.
 meta_keywordsPlatinum Drive Realty, Inc., Leverage Global Partners, Westchester County real estate, New York real estate, Ardsley real estate, Armonk real estate, Bedford real estate, Chappaqua real estate, Eastchester real estate, Edgemont real estate, Harrison real estate, Hastings real estate, Irvington real estate, Larchmont real estate, Mamaroneck real estate, New Rochelle real estate, Pelham real estate, Pound Ridge real estate, Purchase real estate, Rye real estate, Rye Brook real estate, Scarsdale real estate, White Plains real estate
 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)
 created2015-11-23 12:37:07
 modified2016-04-08 16:34:31
 dre_num012345
 uri/brokerage-detail/237/platinum-drive-realty-inc
 website_shortwww.platinumdr.com
 name_with_locationPlatinum Drive Realty, Inc.
 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)
 id18375
 modelProperty
 model_id3187
 tagImage
 name30646.jpg
 typeimage/jpg
 size694688
 uri/assets/18375.jpg
 order0
 created2016-04-07 17:09:05
 modified2016-04-07 17:09:05
 User(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id4
 nameGarage
 additional(false)
 created2016-04-07 14:01:52
 modified2016-04-07 14:01:52
 PropertiesPropertyFeature(array)
 id3869
 property_id3187
 property_feature_id4
 1(array)
 id1
 nameBalcony/Terrace
 additional(false)
 created2016-04-07 14:00:26
 modified2016-04-07 14:00:26
 PropertiesPropertyFeature(array)
 id3870
 property_id3187
 property_feature_id1
 Topic(empty)
- sidebar_locations(array)
 0(array)
 Location(array)
 id164
 parent_id7
 brokerage_id237
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameWestchester County, NY, USA
 short_nameWestchester County, NY, USA
 group_index
 latitude41.122021
 longitude-73.794853
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_descriptionWestchester County- great schools and natural beauty just minutes from NYC!
 long_descriptionWestchester County has endless natural beauty and many of the best most public schools in the Nation. Southern Westchester borders NYC and has beautiful leafy towns along with exciting cities that offer great entertainment and dining options. Many towns border the Long Island Sound offering miles of shorelines and beaches. Northern Westchester has seemingly unlimited green space with farms, golf courses, lakes and rivers. The middle of the county has a blend of rural splendor with a splash of urban charm. Western Westchester bounds the Hudson River resulting in idyllic towns with picture perfect views. Come fall in love with Westchester!
 created2016-04-12 16:55:10
 modified2016-04-15 08:47:19
 timezoneAmerica/New_York
 population970000
 uri/locations/view/164/westchester-county-ny-usa
 tile_nameWestchester County, NY, USA
 Brokerage(array)
 id237
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typeBasic
 max_properties8
 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(true)
 country_id0
 WOEID2361170
 timezoneUS/Eastern
 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
 namePlatinum Drive Realty, Inc.
 broker_of_record_name
 short_namePlatinum Drive Realty, Inc.
 usernameplatinumdriverealty
 passwordcf19692bb5fdde944ba4679ddfce5f7df0ee8592
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionPlatinum Drive Realty, Inc. is the exclusive representative for Leverage Global Partners in Westchester County, including Ardsley, Armonk, Bedford, Chappaqua, Eastchester, Edgemont, Harrison, Hastings, Irvington, Larchmont, Mamaroneck, New Rochelle, Pelham, Pound Ridge, Purchase, Rye, Rye Brook, Scarsdale, and White Plains, NY, USA. Platinum Drive Realty is a leading real estate firm in Westchester County, NY. The firm was founded by Westchester residents Zachary Harrison, Heather Harrison, and Heather's grandmother Sunny, who has been in the real estate business for over 50 years. We believe that real estate should be an enjoyable, rewarding, and first-rate experience. The role of a great real estate agent is much more than opening a door. From the moment of our first contact to negotiating a successful deal, Platinum Drive will take you to your real estate destination in style, with the highest level of personal and professional service. We serve a wide variety of clients, from first-time home buyers and sellers, to experienced homeowners, buyers, builders and investors. Whether you are moving in or out of Westchester, trading up or down, or buying a second home, we are here to meet your real estate needs. We are proud of the strong, lasting relationships we have built with our clients and our adherence to the highest ethical standards. Our agents bring great passion and knowledge to the markets we serve, an expansive network, cutting edge research and marketing strategies, and excellent negotiation skills to each transaction. In 2015 and 2014, Platinum Drive Realty was named the fastest growing real estate brokerage firm in New York State and one of the fastest growing private companies in American in a survey by Inc. Magazine. Platinum Drive is committed to giving back to the community. We participate in various charitable causes. Making a positive contribution to the community is an important part of our firm culture. We look forward to working with you to achieve great results together. Please contact us today at 914.725.7737 or [email protected] 
 communitiesWestchester county Ardsley Armonk Bedford Chappaqua Eastchester Edgemont Harrison Hastings Irvington Larchmont Mamaroneck New Rochelle Pelham Pound Ridge Purchase Rye Rye Brook Scarsdale White Plains
 websitehttp://www.platinumdr.com/
 address1082 Wilmot Road
 address_2
 cityScarsdale
 stateNY
 full_stateNew York
 countryUSA
 marketWestchester County
 market_2
 postal_code10583
 phoneZachary Cell: (917) 299-7832
 phone_2Heather Cell: (917) 299-7490
 phone_3Office: (914) 725-7737
 wide_contact_image(false)
 contact_nameZachary Harrison & Heather Harrison
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePresident/Licensed Real Estate Broker & Co-Founder/Licensed Real Estate Salesperson
 contact_dre_num
 contact_quoteWe invite you to contact us personally about Westchester County real estate.
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2[email protected]
 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_filename237.jpg
 logo_filename237.jpg
 contact_image_filename237.jpg
 all_properties_link_image_filename237.jpg
 all_properties_linkhttp://www.platinumdr.com/featured/
 video_embed_code
 contact_video_embed_code
 meta_titleWestchester County Real Estate | Platinum Drive Realty | Leverage Global Partners
 meta_descriptionPlatinum Drive Realty, Inc. is the exclusive representative for Leverage Global Partners in Westchester County, NY, including Ardsley, Armonk, Bedford, Chappaqua, Eastchester, Edgemont, Harrison, Hastings, Irvington, Larchmont, Mamaroneck, New Rochelle, Pelham, Pound Ridge, Purchase, Rye, Rye Brook, Scarsdale, and White Plains.
 meta_keywordsPlatinum Drive Realty, Inc., Leverage Global Partners, Westchester County real estate, New York real estate, Ardsley real estate, Armonk real estate, Bedford real estate, Chappaqua real estate, Eastchester real estate, Edgemont real estate, Harrison real estate, Hastings real estate, Irvington real estate, Larchmont real estate, Mamaroneck real estate, New Rochelle real estate, Pelham real estate, Pound Ridge real estate, Purchase real estate, Rye real estate, Rye Brook real estate, Scarsdale real estate, White Plains real estate
 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)
 created2015-11-23 12:37:07
 modified2016-04-08 16:34:31
 dre_num012345
 uri/brokerage-detail/237/platinum-drive-realty-inc
 website_shortwww.platinumdr.com
 name_with_locationPlatinum Drive Realty, Inc.
 Image(array)
 id20724
 modelLocation
 model_id164
 tagImage
 nameScreen Shot 2016-04-12 at 4.55.31 PM.png
 typeimage/png
 size1081882
 uri/assets/20724.png
 order0
 created2016-04-12 16:55:55
 modified2016-04-15 08:47:19
- highlighted_properties(array)
 0(array)
 Property(array)
 id3192
 brokerage_id237
 created_by_user_id0
 order1
 multi_unit(false)
 agent_1_id1072
 agent_2_id0
 agent_3_id0
 nameCALIFORNIA STYLE LIVING IN THE SUBURBS
 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)
 descriptionThis home was completely renovated in 2012 and features a gracious entry foyer with an open concept floor plan that flows into the living room with fireplace and dining room with vaulted ceilings, recessed lighting and French doors to the garden. The brand new fully renovated and completely custom kitchen is bright and open to the family room with built-in book cases and doors out to the patio. The master suite includes two new walk-in closets, French doors to the backyard and a new 5-fixture master bathroom. Three more family bedrooms and two full baths and hardwood floors throughout completes this no step ranch. The full walk-out basement is completely renovated with a large family room, new cedar closet, laundry room, two more bedrooms/office and a full bathroom. Additional renovations include new high efficiency furnace, hot water heater, and A/C.
 address230 Hillair Circle
 address_2
 cityWhite Plains
 stateNY
 postal_code10605
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price1070000
 price_20
 price_usd1070000
 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)
 bedrooms4
 bedrooms_20
 bathrooms4
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1garage
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 website
 meta_titleCALIFORNIA STYLE LIVING IN THE SUBURBS | White Plains Real Estate | Platinum Drive Realty, Inc.
 meta_description230 Hillair Circle is a property offered for sale in White Plains, NY, USA, presented by Platinum Drive Realty, Inc.
 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_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
 created2015-12-06 13:22:21
 uri/property-detail/3192/230-hillair-circle-white-plains-ny-10605-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3192/230-hillair-circle-white-plains-ny-10605-usa
 address_concat230 Hillair Circle White Plains NY 10605 USA
 google_maps_query_string230+Hillair+Circle++White+Plains+NY+10605+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 1,070,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty4
 bathrooms_pretty4
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms4
 date_listed2015-12-06
 overridden_brokerage_namePlatinum Drive Realty, Inc.
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id237
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typeBasic
 max_properties8
 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(true)
 country_id0
 WOEID2361170
 timezoneUS/Eastern
 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
 namePlatinum Drive Realty, Inc.
 broker_of_record_name
 short_namePlatinum Drive Realty, Inc.
 usernameplatinumdriverealty
 passwordcf19692bb5fdde944ba4679ddfce5f7df0ee8592
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionPlatinum Drive Realty, Inc. is the exclusive representative for Leverage Global Partners in Westchester County, including Ardsley, Armonk, Bedford, Chappaqua, Eastchester, Edgemont, Harrison, Hastings, Irvington, Larchmont, Mamaroneck, New Rochelle, Pelham, Pound Ridge, Purchase, Rye, Rye Brook, Scarsdale, and White Plains, NY, USA. Platinum Drive Realty is a leading real estate firm in Westchester County, NY. The firm was founded by Westchester residents Zachary Harrison, Heather Harrison, and Heather's grandmother Sunny, who has been in the real estate business for over 50 years. We believe that real estate should be an enjoyable, rewarding, and first-rate experience. The role of a great real estate agent is much more than opening a door. From the moment of our first contact to negotiating a successful deal, Platinum Drive will take you to your real estate destination in style, with the highest level of personal and professional service. We serve a wide variety of clients, from first-time home buyers and sellers, to experienced homeowners, buyers, builders and investors. Whether you are moving in or out of Westchester, trading up or down, or buying a second home, we are here to meet your real estate needs. We are proud of the strong, lasting relationships we have built with our clients and our adherence to the highest ethical standards. Our agents bring great passion and knowledge to the markets we serve, an expansive network, cutting edge research and marketing strategies, and excellent negotiation skills to each transaction. In 2015 and 2014, Platinum Drive Realty was named the fastest growing real estate brokerage firm in New York State and one of the fastest growing private companies in American in a survey by Inc. Magazine. Platinum Drive is committed to giving back to the community. We participate in various charitable causes. Making a positive contribution to the community is an important part of our firm culture. We look forward to working with you to achieve great results together. Please contact us today at 914.725.7737 or [email protected] 
 communitiesWestchester county Ardsley Armonk Bedford Chappaqua Eastchester Edgemont Harrison Hastings Irvington Larchmont Mamaroneck New Rochelle Pelham Pound Ridge Purchase Rye Rye Brook Scarsdale White Plains
 websitehttp://www.platinumdr.com/
 address1082 Wilmot Road
 address_2
 cityScarsdale
 stateNY
 full_stateNew York
 countryUSA
 marketWestchester County
 market_2
 postal_code10583
 phoneZachary Cell: (917) 299-7832
 phone_2Heather Cell: (917) 299-7490
 phone_3Office: (914) 725-7737
 wide_contact_image(false)
 contact_nameZachary Harrison & Heather Harrison
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePresident/Licensed Real Estate Broker & Co-Founder/Licensed Real Estate Salesperson
 contact_dre_num
 contact_quoteWe invite you to contact us personally about Westchester County real estate.
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2[email protected]
 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_filename237.jpg
 logo_filename237.jpg
 contact_image_filename237.jpg
 all_properties_link_image_filename237.jpg
 all_properties_linkhttp://www.platinumdr.com/featured/
 video_embed_code
 contact_video_embed_code
 meta_titleWestchester County Real Estate | Platinum Drive Realty | Leverage Global Partners
 meta_descriptionPlatinum Drive Realty, Inc. is the exclusive representative for Leverage Global Partners in Westchester County, NY, including Ardsley, Armonk, Bedford, Chappaqua, Eastchester, Edgemont, Harrison, Hastings, Irvington, Larchmont, Mamaroneck, New Rochelle, Pelham, Pound Ridge, Purchase, Rye, Rye Brook, Scarsdale, and White Plains.
 meta_keywordsPlatinum Drive Realty, Inc., Leverage Global Partners, Westchester County real estate, New York real estate, Ardsley real estate, Armonk real estate, Bedford real estate, Chappaqua real estate, Eastchester real estate, Edgemont real estate, Harrison real estate, Hastings real estate, Irvington real estate, Larchmont real estate, Mamaroneck real estate, New Rochelle real estate, Pelham real estate, Pound Ridge real estate, Purchase real estate, Rye real estate, Rye Brook real estate, Scarsdale real estate, White Plains real estate
 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)
 created2015-11-23 12:37:07
 modified2016-04-08 16:34:31
 dre_num012345
 uri/brokerage-detail/237/platinum-drive-realty-inc
 website_shortwww.platinumdr.com
 name_with_locationPlatinum Drive Realty, Inc.
 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)
 id14843
 modelProperty
 model_id3192
 tagImage
 name30805.jpg
 typeimage/jpg
 size1845124
 uri/assets/14843.jpg
 order0
 created2016-04-07 16:48:04
 modified2016-04-07 16:48:04
 1(array)
 id14842
 modelProperty
 model_id3192
 tagImage
 name30656.jpg
 typeimage/jpg
 size476667
 uri/assets/14842.jpg
 order1
 created2016-04-07 16:48:04
 modified2016-04-07 16:48:04
 2(array)
 id14844
 modelProperty
 model_id3192
 tagImage
 name30806.jpg
 typeimage/jpg
 size884897
 uri/assets/14844.jpg
 order2
 created2016-04-07 16:48:04
 modified2016-04-07 16:48:04
 3(array)
 id14845
 modelProperty
 model_id3192
 tagImage
 name30807.jpg
 typeimage/jpg
 size1005965
 uri/assets/14845.jpg
 order3
 created2016-04-07 16:48:04
 modified2016-04-07 16:48:04
 4(array)
 id14846
 modelProperty
 model_id3192
 tagImage
 name30808.jpg
 typeimage/jpg
 size853972
 uri/assets/14846.jpg
 order4
 created2016-04-07 16:48:04
 modified2016-04-07 16:48:04
 5(array)
 id14847
 modelProperty
 model_id3192
 tagImage
 name30809.jpg
 typeimage/jpg
 size1142592
 uri/assets/14847.jpg
 order5
 created2016-04-07 16:48:04
 modified2016-04-07 16:48:04
 6(array)
 id14848
 modelProperty
 model_id3192
 tagImage
 name30810.jpg
 typeimage/jpg
 size1136738
 uri/assets/14848.jpg
 order6
 created2016-04-07 16:48:04
 modified2016-04-07 16:48:04
 7(array)
 id14849
 modelProperty
 model_id3192
 tagImage
 name30811.jpg
 typeimage/jpg
 size917762
 uri/assets/14849.jpg
 order7
 created2016-04-07 16:48:04
 modified2016-04-07 16:48:04
 8(array)
 id14850
 modelProperty
 model_id3192
 tagImage
 name30812.jpg
 typeimage/jpg
 size926907
 uri/assets/14850.jpg
 order8
 created2016-04-07 16:48:04
 modified2016-04-07 16:48:04
 9(array)
 id14851
 modelProperty
 model_id3192
 tagImage
 name30813.jpg
 typeimage/jpg
 size831816
 uri/assets/14851.jpg
 order9
 created2016-04-07 16:48:04
 modified2016-04-07 16:48:04
 User(array)
 0(array)
 id1178
 typeAgent
 brokerage_id237
 email[email protected]
 password7de6ddc54c26befa90532509fa2b41d0145c207c
 recover_hash
 first_nameSeth
 last_nameKeslow
 title
 dre_num
 phone917-626-9568
 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_nameSeth Keslow
 uri/agent-detail/1178/seth-keslow
 profile_complete(true)
 UsersProperty(array)
 id983
 user_id1178
 property_id3192
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id4
 nameGarage
 additional(false)
 created2016-04-07 14:01:52
 modified2016-04-07 14:01:52
 PropertiesPropertyFeature(array)
 id2982
 property_id3192
 property_feature_id4
 Topic(empty)
 1(array)
 Property(array)
 id3553
 brokerage_id237
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id1179
 agent_2_id1064
 agent_3_id0
 nameSPECTACULAR SCARSDALE ESTATE ON 1.52 ACR
 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)
 description This grand and bright Scarsdale Colonial is the perfect blend of elegance, luxury and beauty. Located on 1.52 acres of spectacular property, this home features a large circular driveway and beautiful pool surrounded by gorgeous landscaping. The 1st floor offers ample space perfect for entertaining and everyday gatherings, including a dramatic foyer, 9-ft high ceilings and huge Eat-In-Kitchen that opens to the family room. Enjoy the superb living room, formal dining room, private library, open sunroom, and large deck off the kitchen, which provides breathtaking views. The sweeping staircase to the 2nd floor takes you to a large Master Bedroom Suite with 2 large walk in closets and a luxurious master bath, plus a 2nd floor family room/office. There are 7 spacious bedrooms, plus 5.5 baths, and 4 fireplaces. The lower level features a playroom area and cabana bath. Move right in and enjoy the ultimate in privacy and serenity in this magnificent home ideally located within walking distance to the train, schools, and town!
 address25 Mamaroneck Road
 address_2
 cityScarsdale
 stateNY
 postal_code10583
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price2398000
 price_20
 price_usd2398000
 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)
 bedrooms7
 bedrooms_20
 bathrooms5
 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
 websitehttp://www.platinumdr.com/properties/25-mamaroneck-road/
 meta_titleSPECTACULAR SCARSDALE ESTATE ON 1.52 ACR | Scarsdale Real Estate | Platinum Drive Realty, Inc.
 meta_description25 Mamaroneck Road is a property offered for sale in Scarsdale, NY, USA, presented by Platinum Drive Realty, Inc.
 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_feet, square_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-03-04 13:09:04
 uri/property-detail/3553/25-mamaroneck-road-scarsdale-ny-10583-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3553/25-mamaroneck-road-scarsdale-ny-10583-usa
 address_concat25 Mamaroneck Road Scarsdale NY 10583 USA
 google_maps_query_string25+Mamaroneck+Road++Scarsdale+NY+10583+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 2,398,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty7
 bathrooms_pretty5
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms5
 date_listed2016-03-04
 overridden_brokerage_namePlatinum Drive Realty, Inc.
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id237
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typeBasic
 max_properties8
 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(true)
 country_id0
 WOEID2361170
 timezoneUS/Eastern
 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
 namePlatinum Drive Realty, Inc.
 broker_of_record_name
 short_namePlatinum Drive Realty, Inc.
 usernameplatinumdriverealty
 passwordcf19692bb5fdde944ba4679ddfce5f7df0ee8592
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionPlatinum Drive Realty, Inc. is the exclusive representative for Leverage Global Partners in Westchester County, including Ardsley, Armonk, Bedford, Chappaqua, Eastchester, Edgemont, Harrison, Hastings, Irvington, Larchmont, Mamaroneck, New Rochelle, Pelham, Pound Ridge, Purchase, Rye, Rye Brook, Scarsdale, and White Plains, NY, USA. Platinum Drive Realty is a leading real estate firm in Westchester County, NY. The firm was founded by Westchester residents Zachary Harrison, Heather Harrison, and Heather's grandmother Sunny, who has been in the real estate business for over 50 years. We believe that real estate should be an enjoyable, rewarding, and first-rate experience. The role of a great real estate agent is much more than opening a door. From the moment of our first contact to negotiating a successful deal, Platinum Drive will take you to your real estate destination in style, with the highest level of personal and professional service. We serve a wide variety of clients, from first-time home buyers and sellers, to experienced homeowners, buyers, builders and investors. Whether you are moving in or out of Westchester, trading up or down, or buying a second home, we are here to meet your real estate needs. We are proud of the strong, lasting relationships we have built with our clients and our adherence to the highest ethical standards. Our agents bring great passion and knowledge to the markets we serve, an expansive network, cutting edge research and marketing strategies, and excellent negotiation skills to each transaction. In 2015 and 2014, Platinum Drive Realty was named the fastest growing real estate brokerage firm in New York State and one of the fastest growing private companies in American in a survey by Inc. Magazine. Platinum Drive is committed to giving back to the community. We participate in various charitable causes. Making a positive contribution to the community is an important part of our firm culture. We look forward to working with you to achieve great results together. Please contact us today at 914.725.7737 or [email protected] 
 communitiesWestchester county Ardsley Armonk Bedford Chappaqua Eastchester Edgemont Harrison Hastings Irvington Larchmont Mamaroneck New Rochelle Pelham Pound Ridge Purchase Rye Rye Brook Scarsdale White Plains
 websitehttp://www.platinumdr.com/
 address1082 Wilmot Road
 address_2
 cityScarsdale
 stateNY
 full_stateNew York
 countryUSA
 marketWestchester County
 market_2
 postal_code10583
 phoneZachary Cell: (917) 299-7832
 phone_2Heather Cell: (917) 299-7490
 phone_3Office: (914) 725-7737
 wide_contact_image(false)
 contact_nameZachary Harrison & Heather Harrison
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePresident/Licensed Real Estate Broker & Co-Founder/Licensed Real Estate Salesperson
 contact_dre_num
 contact_quoteWe invite you to contact us personally about Westchester County real estate.
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2[email protected]
 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_filename237.jpg
 logo_filename237.jpg
 contact_image_filename237.jpg
 all_properties_link_image_filename237.jpg
 all_properties_linkhttp://www.platinumdr.com/featured/
 video_embed_code
 contact_video_embed_code
 meta_titleWestchester County Real Estate | Platinum Drive Realty | Leverage Global Partners
 meta_descriptionPlatinum Drive Realty, Inc. is the exclusive representative for Leverage Global Partners in Westchester County, NY, including Ardsley, Armonk, Bedford, Chappaqua, Eastchester, Edgemont, Harrison, Hastings, Irvington, Larchmont, Mamaroneck, New Rochelle, Pelham, Pound Ridge, Purchase, Rye, Rye Brook, Scarsdale, and White Plains.
 meta_keywordsPlatinum Drive Realty, Inc., Leverage Global Partners, Westchester County real estate, New York real estate, Ardsley real estate, Armonk real estate, Bedford real estate, Chappaqua real estate, Eastchester real estate, Edgemont real estate, Harrison real estate, Hastings real estate, Irvington real estate, Larchmont real estate, Mamaroneck real estate, New Rochelle real estate, Pelham real estate, Pound Ridge real estate, Purchase real estate, Rye real estate, Rye Brook real estate, Scarsdale real estate, White Plains real estate
 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)
 created2015-11-23 12:37:07
 modified2016-04-08 16:34:31
 dre_num012345
 uri/brokerage-detail/237/platinum-drive-realty-inc
 website_shortwww.platinumdr.com
 name_with_locationPlatinum Drive Realty, Inc.
 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)
 id19790
 modelProperty
 model_id3553
 tagImage
 name34551.jpg
 typeimage/jpg
 size1474781
 uri/assets/19790.jpg
 order0
 created2016-04-07 17:24:57
 modified2016-04-07 17:24:57
 1(array)
 id19792
 modelProperty
 model_id3553
 tagImage
 name34550.jpg
 typeimage/jpg
 size1144601
 uri/assets/19792.jpg
 order1
 created2016-04-07 17:24:57
 modified2016-04-07 17:24:57
 2(array)
 id19791
 modelProperty
 model_id3553
 tagImage
 name34552.jpg
 typeimage/jpg
 size880501
 uri/assets/19791.jpg
 order2
 created2016-04-07 17:24:57
 modified2016-04-07 17:24:57
 3(array)
 id19787
 modelProperty
 model_id3553
 tagImage
 name34553.jpg
 typeimage/jpg
 size983597
 uri/assets/19787.jpg
 order3
 created2016-04-07 17:24:57
 modified2016-04-07 17:24:57
 4(array)
 id19788
 modelProperty
 model_id3553
 tagImage
 name34554.jpg
 typeimage/jpg
 size1017394
 uri/assets/19788.jpg
 order4
 created2016-04-07 17:24:57
 modified2016-04-07 17:24:57
 5(array)
 id19789
 modelProperty
 model_id3553
 tagImage
 name34555.jpg
 typeimage/jpg
 size843091
 uri/assets/19789.jpg
 order5
 created2016-04-07 17:24:57
 modified2016-04-07 17:24:57
 6(array)
 id19786
 modelProperty
 model_id3553
 tagImage
 name34556.jpg
 typeimage/jpg
 size1671119
 uri/assets/19786.jpg
 order6
 created2016-04-07 17:24:57
 modified2016-04-07 17:24:57
 7(array)
 id19785
 modelProperty
 model_id3553
 tagImage
 name34557.jpg
 typeimage/jpg
 size844616
 uri/assets/19785.jpg
 order7
 created2016-04-07 17:24:57
 modified2016-04-07 17:24:57
 8(array)
 id19784
 modelProperty
 model_id3553
 tagImage
 name34558.jpg
 typeimage/jpg
 size793872
 uri/assets/19784.jpg
 order8
 created2016-04-07 17:24:57
 modified2016-04-07 17:24:57
 9(array)
 id19783
 modelProperty
 model_id3553
 tagImage
 name34559.jpg
 typeimage/jpg
 size1808525
 uri/assets/19783.jpg
 order9
 created2016-04-07 17:24:57
 modified2016-04-07 17:24:57
 User(array)
 0(array)
 id1242
 typeAgent
 brokerage_id237
 email[email protected]
 passwordf74ea11f97a0907bd992acef44be1d0f5e74e200
 recover_hash
 first_nameZachary
 last_nameHarrison
 title
 dre_num
 phone917.299.7832
 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_nameZachary Harrison
 uri/agent-detail/1242/zachary-harrison
 profile_complete(true)
 UsersProperty(array)
 id1069
 user_id1242
 property_id3553
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(empty)
 Topic(empty)
- custom_ga_event_properties(array)
 brokeragePlatinum Drive Realty, Inc., Scarsdale
- property(array)
 Property(array)
 id3189
 brokerage_id237
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id1071
 agent_2_id0
 agent_3_id0
 nameEXCEPTIONAL CONSTRUCTION IN LARCHMONT
 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 new construction by premiere Westchester builder in an ideal Larchmont location. Walk to Murray Avenue School. 7 Bedrooms. 6.1 Baths. Spacious open floor plan with 9′ ceilings. The first floor features a Gourmet Eat In Kitchen with top of the line stainless steel appliances, Butler’s Pantry, center island & breakfast room that flows into the family room. Formal living room with coffered ceiling & fireplace. Formal Dining Room with tray ceilings. Entry foyer with main staircase and powder room. First floor Bedroom with en suite bath. Mudroom with access to 2 car garage. The second level features a Master Bedroom Suite with tray ceilings, two Walk In Closets, dressing area & spa bath. 4 additional family bedrooms, two with en suite baths, a hall bath, Laundry Room and back staircase complete second level. Spacious lower level with bedroom, bath, Rec Room and Exercise Room. Room for optional wine room or home theater. Custom millwork throughout. Still time to customize and select finishes.
 address15 Crescent Road
 address_2
 cityLarchmont
 stateNY
 postal_code10538
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price2999000
 price_20
 price_usd2999000
 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)
 bedrooms7
 bedrooms_20
 bathrooms6
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1garage
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 website
 meta_titleEXCEPTIONAL CONSTRUCTION IN LARCHMONT | Larchmont Real Estate | Platinum Drive Realty, Inc.
 meta_description15 Crescent Road is a property offered for sale in Larchmont, NY, USA, presented by Platinum Drive Realty, Inc.
 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_fieldsagent_2_id, square_feet, square_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
 created2015-12-06 10:06:45
 uri/property-detail/3189/15-crescent-road-larchmont-ny-10538-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3189/15-crescent-road-larchmont-ny-10538-usa
 address_concat15 Crescent Road Larchmont NY 10538 USA
 google_maps_query_string15+Crescent+Road++Larchmont+NY+10538+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 2,999,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty7
 bathrooms_pretty6
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms6
 date_listed2015-12-06
 overridden_brokerage_namePlatinum Drive Realty, Inc.
 overridden_brokerage_logo_uri/assets/2923.jpg
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id237
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typeBasic
 max_properties8
 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(true)
 country_id0
 WOEID2361170
 timezoneUS/Eastern
 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
 namePlatinum Drive Realty, Inc.
 broker_of_record_name
 short_namePlatinum Drive Realty, Inc.
 usernameplatinumdriverealty
 passwordcf19692bb5fdde944ba4679ddfce5f7df0ee8592
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionPlatinum Drive Realty, Inc. is the exclusive representative for Leverage Global Partners in Westchester County, including Ardsley, Armonk, Bedford, Chappaqua, Eastchester, Edgemont, Harrison, Hastings, Irvington, Larchmont, Mamaroneck, New Rochelle, Pelham, Pound Ridge, Purchase, Rye, Rye Brook, Scarsdale, and White Plains, NY, USA. Platinum Drive Realty is a leading real estate firm in Westchester County, NY. The firm was founded by Westchester residents Zachary Harrison, Heather Harrison, and Heather's grandmother Sunny, who has been in the real estate business for over 50 years. We believe that real estate should be an enjoyable, rewarding, and first-rate experience. The role of a great real estate agent is much more than opening a door. From the moment of our first contact to negotiating a successful deal, Platinum Drive will take you to your real estate destination in style, with the highest level of personal and professional service. We serve a wide variety of clients, from first-time home buyers and sellers, to experienced homeowners, buyers, builders and investors. Whether you are moving in or out of Westchester, trading up or down, or buying a second home, we are here to meet your real estate needs. We are proud of the strong, lasting relationships we have built with our clients and our adherence to the highest ethical standards. Our agents bring great passion and knowledge to the markets we serve, an expansive network, cutting edge research and marketing strategies, and excellent negotiation skills to each transaction. In 2015 and 2014, Platinum Drive Realty was named the fastest growing real estate brokerage firm in New York State and one of the fastest growing private companies in American in a survey by Inc. Magazine. Platinum Drive is committed to giving back to the community. We participate in various charitable causes. Making a positive contribution to the community is an important part of our firm culture. We look forward to working with you to achieve great results together. Please contact us today at 914.725.7737 or [email protected] 
 communitiesWestchester county Ardsley Armonk Bedford Chappaqua Eastchester Edgemont Harrison Hastings Irvington Larchmont Mamaroneck New Rochelle Pelham Pound Ridge Purchase Rye Rye Brook Scarsdale White Plains
 websitehttp://www.platinumdr.com/
 address1082 Wilmot Road
 address_2
 cityScarsdale
 stateNY
 full_stateNew York
 countryUSA
 marketWestchester County
 market_2
 postal_code10583
 phoneZachary Cell: (917) 299-7832
 phone_2Heather Cell: (917) 299-7490
 phone_3Office: (914) 725-7737
 wide_contact_image(false)
 contact_nameZachary Harrison & Heather Harrison
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePresident/Licensed Real Estate Broker & Co-Founder/Licensed Real Estate Salesperson
 contact_dre_num
 contact_quoteWe invite you to contact us personally about Westchester County real estate.
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2[email protected]
 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_filename237.jpg
 logo_filename237.jpg
 contact_image_filename237.jpg
 all_properties_link_image_filename237.jpg
 all_properties_linkhttp://www.platinumdr.com/featured/
 video_embed_code
 contact_video_embed_code
 meta_titleWestchester County Real Estate | Platinum Drive Realty | Leverage Global Partners
 meta_descriptionPlatinum Drive Realty, Inc. is the exclusive representative for Leverage Global Partners in Westchester County, NY, including Ardsley, Armonk, Bedford, Chappaqua, Eastchester, Edgemont, Harrison, Hastings, Irvington, Larchmont, Mamaroneck, New Rochelle, Pelham, Pound Ridge, Purchase, Rye, Rye Brook, Scarsdale, and White Plains.
 meta_keywordsPlatinum Drive Realty, Inc., Leverage Global Partners, Westchester County real estate, New York real estate, Ardsley real estate, Armonk real estate, Bedford real estate, Chappaqua real estate, Eastchester real estate, Edgemont real estate, Harrison real estate, Hastings real estate, Irvington real estate, Larchmont real estate, Mamaroneck real estate, New Rochelle real estate, Pelham real estate, Pound Ridge real estate, Purchase real estate, Rye real estate, Rye Brook real estate, Scarsdale real estate, White Plains real estate
 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)
 created2015-11-23 12:37:07
 modified2016-04-08 16:34:31
 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)
 id2923
 modelBrokerage
 model_id237
 tagLogo
 name237.jpg
 typeimage/jpg
 size38546
 uri/assets/2923.jpg
 order0
 created2016-03-30 11:45:41
 modified2016-03-30 11:45:41
 MainImage(array)
 id2922
 modelBrokerage
 model_id237
 tagMainImage
 name237.jpg
 typeimage/jpg
 size3950316
 uri/assets/2922.jpg
 order0
 created2016-03-30 11:45:39
 modified2016-03-30 11:45:39
 ContactImage(array)
 id2924
 modelBrokerage
 model_id237
 tagContactImage
 name237.jpg
 typeimage/jpg
 size86670
 uri/assets/2924.jpg
 order0
 created2016-03-30 11:45:41
 modified2016-03-30 11:45:41
 ContactImage2(empty)
 ContactImage3(empty)
 BrokerOfRecordLogo(empty)
 MainArticle(empty)
 FeaturedImage(empty)
 Location(array)
 0(array)
 id164
 parent_id7
 brokerage_id237
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameWestchester County, NY, USA
 short_nameWestchester County, NY, USA
 group_index
 latitude41.122021
 longitude-73.794853
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_descriptionWestchester County- great schools and natural beauty just minutes from NYC!
 long_descriptionWestchester County has endless natural beauty and many of the best most public schools in the Nation. Southern Westchester borders NYC and has beautiful leafy towns along with exciting cities that offer great entertainment and dining options. Many towns border the Long Island Sound offering miles of shorelines and beaches. Northern Westchester has seemingly unlimited green space with farms, golf courses, lakes and rivers. The middle of the county has a blend of rural splendor with a splash of urban charm. Western Westchester bounds the Hudson River resulting in idyllic towns with picture perfect views. Come fall in love with Westchester!
 created2016-04-12 16:55:10
 modified2016-04-15 08:47:19
 timezoneAmerica/New_York
 population970000
 uri/locations/view/164/westchester-county-ny-usa
 tile_nameWestchester County, NY, USA
 User(array)
 0(array)
 id214
 typeBrokerageAdmin
 brokerage_id237
 email[email protected]
 passwordcf19692bb5fdde944ba4679ddfce5f7df0ee8592
 recover_hash
 first_name
 last_name
 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-12 08:32:25
 created2016-04-08 16:34:31
 notified(true)
 full_name
 uri/agent-detail/214/
 profile_complete(false)
 1(array)
 id1178
 typeAgent
 brokerage_id237
 email[email protected]
 password7de6ddc54c26befa90532509fa2b41d0145c207c
 recover_hash
 first_nameSeth
 last_nameKeslow
 title
 dre_num
 phone917-626-9568
 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_nameSeth Keslow
 uri/agent-detail/1178/seth-keslow
 profile_complete(true)
 2(array)
 id1179
 typeAgent
 brokerage_id237
 email[email protected]
 password8b99cfe4aee823b6d5c823548515ae63f0e3bec4
 recover_hash
 first_nameJordie
 last_nameWilk
 title
 dre_num
 phone914-200-8716
 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_nameJordie Wilk
 uri/agent-detail/1179/jordie-wilk
 profile_complete(true)
 3(array)
 id1242
 typeAgent
 brokerage_id237
 email[email protected]
 passwordf74ea11f97a0907bd992acef44be1d0f5e74e200
 recover_hash
 first_nameZachary
 last_nameHarrison
 title
 dre_num
 phone917.299.7832
 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_nameZachary Harrison
 uri/agent-detail/1242/zachary-harrison
 profile_complete(true)
 uri/brokerage-detail/237/platinum-drive-realty-inc
 website_shortwww.platinumdr.com
 name_with_locationPlatinum Drive Realty, Inc. - Westchester County, 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)
 id18378
 modelProperty
 model_id3189
 tagImage
 name30814.jpg
 typeimage/jpg
 size666198
 uri/assets/18378.jpg
 order0
 created2016-04-07 17:09:05
 modified2016-04-07 17:09:05
 1(array)
 id18376
 modelProperty
 model_id3189
 tagImage
 name30803.jpg
 typeimage/jpg
 size231428
 uri/assets/18376.jpg
 order1
 created2016-04-07 17:09:05
 modified2016-04-07 17:09:05
 2(array)
 id18382
 modelProperty
 model_id3189
 tagImage
 name30819.jpg
 typeimage/jpg
 size238470
 uri/assets/18382.jpg
 order2
 created2016-04-07 17:09:05
 modified2016-04-07 17:09:06
 3(array)
 id18381
 modelProperty
 model_id3189
 tagImage
 name30818.jpg
 typeimage/jpg
 size222005
 uri/assets/18381.jpg
 order3
 created2016-04-07 17:09:05
 modified2016-04-07 17:09:05
 4(array)
 id18383
 modelProperty
 model_id3189
 tagImage
 name30820.jpg
 typeimage/jpg
 size312333
 uri/assets/18383.jpg
 order4
 created2016-04-07 17:09:06
 modified2016-04-07 17:09:06
 5(array)
 id18380
 modelProperty
 model_id3189
 tagImage
 name30816.jpg
 typeimage/jpg
 size246243
 uri/assets/18380.jpg
 order5
 created2016-04-07 17:09:05
 modified2016-04-07 17:09:05
 6(array)
 id18377
 modelProperty
 model_id3189
 tagImage
 name30804.jpg
 typeimage/jpg
 size284013
 uri/assets/18377.jpg
 order6
 created2016-04-07 17:09:05
 modified2016-04-07 17:09:05
 7(array)
 id18379
 modelProperty
 model_id3189
 tagImage
 name30815.jpg
 typeimage/jpg
 size258935
 uri/assets/18379.jpg
 order7
 created2016-04-07 17:09:05
 modified2016-04-07 17:09:05
 User(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id4
 nameGarage
 additional(false)
 created2016-04-07 14:01:52
 modified2016-04-07 14:01:52
 PropertiesPropertyFeature(array)
 id3871
 property_id3189
 property_feature_id4
 Icon(array)
 id3553
 modelPropertyFeature
 model_id4
 tagIcon
 name132.png
 typeimage/png
 size2141
 uri/assets/3553.png
 order0
 created2016-04-07 14:01:51
 modified2016-04-07 14:01:52
 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)
 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/3189/15-crescent-road-larchmont-ny-10538-usa
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/property-detail/3189/15-crescent-road-larchmont-ny-10538-usa
Remote Port	14795
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	162.159.115.41
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	a09d3ce78e49e88e-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	aiofkEYxLgHaF9D4CCEgLQAAAEQ
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	aiofkEYxLgHaF9D4CCEgLQAAAEQ
Fcgi Role	RESPONDER
Php Self	/index.php
Request Time Float	1781145488.5867
Request Time	1781145488

====

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
====

EXCEPTIONAL CONSTRUCTION IN LARCHMONT

Represented By: Platinum Drive Realty, Inc.

Highlighted Properties

Share This

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 11 ms Total Queries: 31 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 11 ms
Total Queries: 31 queries