meta_query='key:subdist__c;value:North Beach|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='209529' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15721
[post_author] => 4
[post_date] => 2018-11-02 19:54:38
[post_date_gmt] => 2018-11-02 19:54:38
[post_content] => Marilyn Monroe married Joe DiMaggio in the neighborhood. The rest is history. Welcome to a neighborhood as old as San Francisco, with historic Italian roots, fragrant garlic feasts, and plenty of neighborhood haunts frequented by SF movers and martini-shakers. Here's to you, Herb!
[post_title] => North Beach
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => north-beach
[to_ping] =>
[pinged] =>
[post_modified] => 2018-11-02 19:54:38
[post_modified_gmt] => 2018-11-02 19:54:38
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15721
[menu_order] => 0
[post_type] => community
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
[ancestors] => Array
(
)
[page_template] =>
[post_category] => Array
(
)
[tags_input] => Array
(
)
)
ffd_listing_title 1731 Powell Street #205, San Francisco, CA, 94133
ffd_mls_id 492036
ffd_salesforce_id a0E1I00000Ka5yTUAR
num_of_fireplaces__c 0
num_of_rooms__c 0
of_units__c 19
address2__c 1731 Powell Street #205, San Francisco, CA, 94133
pba__address_pb__c 1731 Powell Street #205, San Francisco, CA, 94133
agent_only_remarks__c 0.5% BONUS if offer is in by Friday 11/15/19. Stunning 2-bedroom, 2-bathroom condominium in the heart of San Francisco's famed North Beach! For more information call or text Shannon Hooshmand at (925)393-2329! Link to disclosures: https://disclosures.io/link/1731-Powell-Street-ybmocydj
appliances__c Dishwasher;Gas Range;Microwave;Disposal;Refrigerator;Hood Over Range;Ice Maker;Freezer
architectural_style__c Contemporary;Craftsman;Art Deco
bath_features__c Tub w/Shower Over;Shower Stall(s);Tile;Low-Flow Toilet(s);Dual Flush Toilet;Bidet;Radiant Heat
pba__fullbathrooms_pb__c 2
pba__bedrooms_pb__c 2
year_build_text__c 2018
pba__city_pb__c San Francisco
pba__contingentdate__c 1800-01-01
cooling__c Central,Room Air
ffd_createddate 2019-10-29T19:47:53.000+0000
days_on_market__c 1087
dom__c 115
ffd_description_pb NEWLY BUILT! Designed by famed architect Robert Rudeen. The Immaculate Boutique 19 Unit Palace at Washington Square Stunning 2-bedroom, 2-bathroom condominium in the heart of San Francisco's famed North Beach. This unit does not have water views, but rather is for someone who wants a more private, quiet unit, with ample natural lighting, spacious floorplan, and separate pantry room from laundry room! This luxurious condominium comes with all Thermador appliances, heated flooring in all bathrooms, heated toilet with bidet in Master, 9-foot ceilings, spacious open floor plan, and a 470 square foot private patio. This newly constructed building has all the luxury amenities one could desire including a state of the art workout gym and an oversized shared resident rooftop deck with 2 stainless steal gas grills, 3 Fire Pits and ample outdoor seating.
district__c SF District 8
electric__c 220 Volts in Kitchen,220 Volts in Laundry
entry_level__c 0
external_listing__c 1
pba__floor__c 0
pba__floortype_pb__c Simulated Wood
hoa_dues__c 924.38
hoa_fee_includes__c Trash,Maintenance Grounds,Security
pba__hoafees__c 924
hoa__c Yes
pba__halfbathrooms_pb__c 0
pba__heatingtype_pb__c Hot Water;Central;Gas
ffd_lastmodifieddate 2022-01-12T15:25:30.000+0000
pba__latitude_pb__c 37.8006922
pba__latitude_property__c 37.8006922
laundry_appliances__c 220 Volt Wiring,In Closet
laundry_features__c Laundry Closet
listed_date__c 2019-10-29
pba__listing_agent_email__c shannon@luxegroup.com
pba__listing_agent_firstname__c Shannon
pba__listing_agent_lastname__c Hooshmand
listing_agent_mls_id__c 813706
ffd_listingagentname Shannon O Hooshmand
listing_agent_number__c 1062927
listing_co_agent_number__c 0
listing_co_office_number__c 0
listing_office_mls_id__c EMJCAP
listing_office_name__c EMJ Capital Realty Corp.
listing_office_number__c 27463
pba__listingprice_pb__c 1750000
pba__listingtype__c Sale
pba__longitude_pb__c -122.4112871
pba__lotsize_pb__c 0
mls_id__c 492036
main_level__c Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
master_property__c a0O1I000003CFEcUAO
monthly_parking_fees__c 0
monthlyrent__c 0
parkingspaces__c 1
on_market_date__c 2019-10-29
original_price__c 1995000
overall_days_on_market__c 366
parking_access__c Tandem
parking_features__c Enclosed,Interior Access,Tandem Garage,Garage
parking_type__c On Site - Assigned (Condo Only)
pba__pendingdate__c 2020-02-21
possible_bedrooms__c 0
pba__pricechangedat__c 1800-01-01T00:00:00.000+0000
price_per_square_foot__c 1331.22
pba__propertytype__c Condominium
id a0E1I00000Ka5yTUAR
roof__c Composition
room_type__c Laundry
sale_date__c 2020-03-17
sale_price__c 1680000
selling_agent_mls_id__c 806372
selling_agent_name__c Michael D. Tekulsky
selling_agent_number__c 164505236
selling_co_agent_mls_id__c 806373
selling_co_agent_name__c Ron Wong
selling_co_agent_number__c 164505277
selling_co_office_mls_id__c COMP41
selling_co_office_name__c Compass
selling_co_office_number__c 27887
selling_office_name__c Compass
pba__status__c Closed
pba__totalarea_pb__c 1262
size__c 1262
pba__state_pb__c CA
stories__c 0
pba__street_pb__c Powell
subdist__c North Beach
ffd_name 1731 Powell Street #205, San Francisco, CA, 94133
transportation__c 1 Block
unit_number__c 205
website_property_type__c Condominium
window_features__c Weather Stripped;Caulked/Sealed
pba__yearbuilt_pb__c 2018
pba__postalcode_pb__c 94133
ffd_media Array
ffd_media_tags Array
ffd_featured_image https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/357781-1.jpg
ListingId a0E1I00000Ka5yTUAR