.we3-listing-page .gallery #slider-listing.flexslider .flex-direction-nav a{--wpr-bg-52dfec50-6243-438a-aae1-62013935769f: url('https://www.brownstoner.com/wp-content/plugins/we3-real-estate/js/flexslider/images/ss_arrows.png');}.we3-listing-page #carousel-listing.flexslider .flex-direction-nav a{--wpr-bg-17ed66f9-1476-450b-967e-6718d608140b: url('https://www.brownstoner.com/wp-content/plugins/we3-real-estate/js/flexslider/images/ss_arrows.png');}.we3-listing-page .article-info .est_mortgage.info-item{--wpr-bg-78af08bc-2cb2-4424-8183-fbe402f4199f: url('https://www.brownstoner.com/wp-content/plugins/we3-real-estate/modules/listings/images/interface/popup_bg.png');}.we3-listing-page .article-info .est_mortgage.info-item div{--wpr-bg-0057a1ef-d17a-417e-b0f8-9702898bf9d0: url('https://www.brownstoner.com/wp-content/plugins/we3-real-estate/modules/listings/images/icons/calc_icon.png');}.flex-direction-nav a{--wpr-bg-81f3b977-08dc-477b-8327-153e2a814db4: url('https://www.brownstoner.com/wp-content/plugins/we3-real-estate/js/flexslider/styles/images/bg_direction_nav.png');}.pswp__button,.pswp__button--arrow--left:before,.pswp__button--arrow--right:before{--wpr-bg-7c3191c6-f2df-4ff1-b8e4-983996a757e4: url('https://cdnjs.cloudflare.com/ajax/libs/photoswipe/4.1.3/default-skin/default-skin.png');}.pswp__preloader--active .pswp__preloader__icn{--wpr-bg-51d9ccee-b856-422a-9bb0-3411948f198f: url('https://cdnjs.cloudflare.com/ajax/libs/photoswipe/4.1.3/default-skin/preloader.gif');}.pswp--svg .pswp__button,.pswp--svg .pswp__button--arrow--left:before,.pswp--svg .pswp__button--arrow--right:before{--wpr-bg-ab3b081e-f548-47bb-9e86-93ca23f5e1c1: url('https://cdnjs.cloudflare.com/ajax/libs/photoswipe/4.1.3/default-skin/default-skin.svg');}.owl-item.loading{--wpr-bg-91d40f5d-5bcb-4116-b004-15e7787c0cc0: url('https://www.brownstoner.com/wp-content/plugins/blankslate-directory/assets/css/AjaxLoader.gif');}#blankslate-search-form #blankslate-what{--wpr-bg-d09933d5-cef1-4794-848c-94a5eb570124: url('https://www.brownstoner.com/wp-content/plugins/blankslate-directory/assets/img/search.png');}#blankslate-container div.social span.yelp{--wpr-bg-bf1e81e1-eb26-4776-ae56-5a4e8586979b: url('https://www.brownstoner.com/wp-content/plugins/blankslate-directory/assets/img/square-social/yelp67.png');}#blankslate-container div.social span.seamless{--wpr-bg-962bb13a-76c4-4b9e-82b1-267a50ab392c: url('https://www.brownstoner.com/wp-content/plugins/blankslate-directory/assets/img/square-social/seamless67.png');}#blankslate-container div.social span.foursquare{--wpr-bg-235e6a6d-d61b-4544-a155-adb818f4c898: url('https://www.brownstoner.com/wp-content/plugins/blankslate-directory/assets/img/square-social/foursquare67.png');}#blankslate-container div.social span.facebook{--wpr-bg-af96cf6e-58e4-4a2f-85e8-39654dd35517: url('https://www.brownstoner.com/wp-content/plugins/blankslate-directory/assets/img/square-social/facebook67.png');}#blankslate-container div.social span.opentable{--wpr-bg-556fca1c-0d91-4be5-8031-44ff993bc03c: url('https://www.brownstoner.com/wp-content/plugins/blankslate-directory/assets/img/square-social/opentable67.png');}#blankslate-container div.social span.google{--wpr-bg-51aae66d-71c1-4a1b-8893-6d8e69cab5b9: url('https://www.brownstoner.com/wp-content/plugins/blankslate-directory/assets/img/square-social/google67.png');}#blankslate-container div.social span.grubhub{--wpr-bg-c8a597ef-d506-4c4e-95ff-71f7e7a1a3b4: url('https://www.brownstoner.com/wp-content/plugins/blankslate-directory/assets/img/square-social/grubhub67.png');}#blankslate-container div.social span.instagram{--wpr-bg-0905b663-9bf4-42ed-82fe-99bb99886388: url('https://www.brownstoner.com/wp-content/plugins/blankslate-directory/assets/img/square-social/instagram67.png');}#blankslate-container div.social span.menupages{--wpr-bg-513ff85c-65cb-45e5-8260-05cd04a41cfc: url('https://www.brownstoner.com/wp-content/plugins/blankslate-directory/assets/img/square-social/menupages67.png');}#blankslate-container div.social span.pinterest{--wpr-bg-d64962f5-317e-4803-92f9-21281875352f: url('https://www.brownstoner.com/wp-content/plugins/blankslate-directory/assets/img/square-social/pinterest67.png');}#blankslate-container div.social span.tumblr{--wpr-bg-90030f22-232e-47f9-a894-f0a59db5c8f2: url('https://www.brownstoner.com/wp-content/plugins/blankslate-directory/assets/img/square-social/tumblr67.png');}#blankslate-container div.social span.twitter{--wpr-bg-c80edcf1-995b-466c-b936-0b6ae9a82e58: url('https://www.brownstoner.com/wp-content/plugins/blankslate-directory/assets/img/square-social/twitter67.png');}#blankslate-container div.social span.urbanspoon{--wpr-bg-29ea1619-0db4-49be-a5ea-30f7b3bed847: url('https://www.brownstoner.com/wp-content/plugins/blankslate-directory/assets/img/square-social/urbanspoon67.png');}#blankslate-container div.social span.youtube{--wpr-bg-25274ebf-9be8-4868-a163-369f1bb5334d: url('https://www.brownstoner.com/wp-content/plugins/blankslate-directory/assets/img/square-social/youtube67.png');}#blankslate-container div.social span.zagat{--wpr-bg-bf0be74d-1340-4a75-8832-70b1d9805489: url('https://www.brownstoner.com/wp-content/plugins/blankslate-directory/assets/img/square-social/zagat67.png');}.social-icon{--wpr-bg-e1d50970-ffa0-4b08-97a9-6f57c78bfbc6: url('https://www.brownstoner.com/wp-content/plugins/blankslate-directory/assets/img/sprite.png');}.signup-success--header{--wpr-bg-726075c9-222b-4eb9-a4e3-9e0b5bd5df13: url('https://www.brownstoner.com/wp-content/plugins/blankslate-directory/assets/img/new-join/BrownstonerJoinHeader.jpg');}i.blankslate-icon{--wpr-bg-50d13230-81b8-48a0-a971-cfc9c0b73e31: url('https://pbs.twimg.com/profile_images/449173857874628608/KOtObzXA_400x400.png');}img::after{--wpr-bg-6845415a-efa4-4d48-976d-4f8aa58971c8: url('https://www.brownstoner.com/wp-content/themes/digitalsilk/assets/_dist/images/favicon.svg');}.real-estate-container li.featured-buildings{--wpr-bg-76eca833-8695-488f-9443-f560c3cdc588: url('http://bstoner.wpengine.com/wp-content/uploads/2015/07/759387-building-wallpaper.jpg');}.we3-slide{--wpr-bg-2fe3376a-11f7-4314-a2f7-361c15407613: url('https://www.brownstoner.com/wp-content/uploads/2015/07/759387-building-wallpaper.jpg');}.ui-widget-content{--wpr-bg-40ab06b8-b2a2-4681-9af1-531b8d20c6cc: url('https://code.jquery.com/ui/1.11.2/themes/smoothness/images/ui-bg_flat_75_ffffff_40x100.png');}.ui-widget-header{--wpr-bg-80666c49-c248-4a88-9a4c-b31408d0c266: url('https://code.jquery.com/ui/1.11.2/themes/smoothness/images/ui-bg_highlight-soft_75_cccccc_1x100.png');}.ui-state-default,.ui-widget-content .ui-state-default,.ui-widget-header .ui-state-default{--wpr-bg-e229ccd1-e5ee-431a-8890-a1769ee3e9f5: url('https://code.jquery.com/ui/1.11.2/themes/smoothness/images/ui-bg_glass_75_e6e6e6_1x400.png');}.ui-state-hover,.ui-widget-content .ui-state-hover,.ui-widget-header .ui-state-hover,.ui-state-focus,.ui-widget-content .ui-state-focus,.ui-widget-header .ui-state-focus{--wpr-bg-a6472255-30b2-4d1e-b7ca-01899b369a2b: url('https://code.jquery.com/ui/1.11.2/themes/smoothness/images/ui-bg_glass_75_dadada_1x400.png');}.ui-state-active,.ui-widget-content .ui-state-active,.ui-widget-header .ui-state-active{--wpr-bg-89e981c6-fd8e-4235-9d69-bafb8dc0315b: url('https://code.jquery.com/ui/1.11.2/themes/smoothness/images/ui-bg_glass_65_ffffff_1x400.png');}.ui-state-highlight,.ui-widget-content .ui-state-highlight,.ui-widget-header .ui-state-highlight{--wpr-bg-ada53111-e11d-40f2-84c8-7825b5317de0: url('https://code.jquery.com/ui/1.11.2/themes/smoothness/images/ui-bg_glass_55_fbf9ee_1x400.png');}.ui-state-error,.ui-widget-content .ui-state-error,.ui-widget-header .ui-state-error{--wpr-bg-1994e269-4cb3-4ad5-b049-95cb5ebd79e6: url('https://code.jquery.com/ui/1.11.2/themes/smoothness/images/ui-bg_glass_95_fef1ec_1x400.png');}.ui-widget-overlay{--wpr-bg-9d04799c-af9f-470a-8a80-6febfa946624: url('https://code.jquery.com/ui/1.11.2/themes/smoothness/images/ui-bg_flat_0_aaaaaa_40x100.png');}.ui-widget-shadow{--wpr-bg-21afd683-a66c-4671-83c6-fa5ec192532a: url('https://code.jquery.com/ui/1.11.2/themes/smoothness/images/ui-bg_flat_0_aaaaaa_40x100.png');}.ui-icon,.ui-widget-content .ui-icon{--wpr-bg-468e9d57-724f-4324-babd-e5f0da5db7c9: url('https://code.jquery.com/ui/1.11.2/themes/smoothness/images/ui-icons_222222_256x240.png');}.ui-widget-header .ui-icon{--wpr-bg-5fcaf706-93e2-467d-91cd-9c597270c260: url('https://code.jquery.com/ui/1.11.2/themes/smoothness/images/ui-icons_222222_256x240.png');}.ui-state-default .ui-icon{--wpr-bg-17ff93b3-4a47-4cf8-a37a-35584fef4015: url('https://code.jquery.com/ui/1.11.2/themes/smoothness/images/ui-icons_888888_256x240.png');}.ui-state-hover .ui-icon,.ui-state-focus .ui-icon{--wpr-bg-775762a2-5c04-406a-87fc-1e3bccc5b0e6: url('https://code.jquery.com/ui/1.11.2/themes/smoothness/images/ui-icons_454545_256x240.png');}.ui-state-active .ui-icon{--wpr-bg-280d7fe7-d9bc-4cb8-a78b-b0d331c54bc4: url('https://code.jquery.com/ui/1.11.2/themes/smoothness/images/ui-icons_454545_256x240.png');}.ui-state-highlight .ui-icon{--wpr-bg-b2e267ab-4829-4112-a335-951b4ecc50da: url('https://code.jquery.com/ui/1.11.2/themes/smoothness/images/ui-icons_2e83ff_256x240.png');}.ui-state-error .ui-icon,.ui-state-error-text .ui-icon{--wpr-bg-be3cc91c-945f-4957-8496-022272b1c40f: url('https://code.jquery.com/ui/1.11.2/themes/smoothness/images/ui-icons_cd0a0a_256x240.png');}.rll-youtube-player .play{--wpr-bg-d1310a3c-3286-4883-94cc-43eb73649c57: url('https://www.brownstoner.com/wp-content/plugins/wp-rocket/assets/img/youtube.png');}

Search Listings

Search Listings

Price

Min

Max

$0

$50M+

Beds

Beds (Select all that apply)

Baths (Select all that apply)

Updated3/8/2018
Added1/22/2016

1254 150th st

Whitestone

Gallery 5 Photos

Active

No Longer Available

About this Property

Sports Bar Located In A Great Neighborhood, Nice Layout, Huge Party Room Upstairs, Stage, Games In The Back, Busy Area.

Details

Status:No Longer Available
ID:3yd-MLSLINY-2822220
Tax:$ 13283

Learn about this property's history, neighborhood, taxes, schools and more.

Marketproof building overview

Amenities

new construction

Location

Copyright © 2024 First Flag Realty Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.

$949,000

Tax:$13,283

0 BA

0BD

Is this your listing? Feature it

View listing on First Flag Realty Inc