meta_query='key:subdist__c;value:North Beach|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='210553' 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] => 2024-03-19 14:42:39
[post_modified_gmt] => 2024-03-19 21:42:39
[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 #401, San Francisco, CA, 94133
ffd_mls_id, 497995
ffd_salesforce_id, a0E1I00000Slc66UAB
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 19
address2__c, 1731 Powell Street #401, San Francisco, CA, 94133
pba__address_pb__c, 1731 Powell Street #401, San Francisco, CA, 94133
agent_only_remarks__c, Stunning 2-bedroom, 2-bathroom condominium in the heart of San Francisco's famed North Beach! For more information call or text Guadalupe at (415)740-5663! 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;Self/Cont Clean Oven
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, 2020-05-11T18:52:25.000+0000
days_on_market__c, 1164
dom__c, 3
ffd_description_pb, NEWLY BUILT! Designed by famed architect Robert Rudeen. This stunning 2-bedroom, 2-bathroom condominium is right in the heart of the sunny side of San Francisco's infamous North Beach. This unit has the best of ALL worlds! You get direct views to Alcatraz/water from BOTH bedrooms AND the living room! This unit comes with stackable washer dryer hook ups, all Thermador appliances, heated flooring in all full bathrooms, heated toilet with bidet in Master, 9-foot ceilings, and a 60 square foot balcony. This beautiful 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! Come take a look
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, 833.54
hoa_fee_includes__c, Trash,Maintenance Grounds,Security
pba__hoafees__c, 833
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Hot Water;Central;Gas
ffd_lastmodifieddate, 2022-01-12T15:31:39.000+0000
pba__latitude_pb__c, 37.800683
pba__latitude_property__c, 37.800683
laundry_appliances__c, 220 Volt Wiring,In Closet
laundry_features__c, Laundry Closet
listed_date__c, 2020-05-11
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Guadalupe
pba__listing_agent_lastname__c, Schmitt
listing_agent_mls_id__c, 223837
ffd_listingagentname, Guadalupe Schmitt
listing_agent_number__c, 223837
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, CASA
listing_office_name__c, Casa Blanca Real Estate
listing_office_number__c, 794
pba__listingprice_pb__c, 2200000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.411288
pba__lotsize_pb__c, 0
mls_id__c, 497995
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, 2020-05-11
original_price__c, 2200000
overall_days_on_market__c, 184
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-05-14
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1803.28
pba__propertytype__c, Condominium
id, a0E1I00000Slc66UAB
roof__c, Composition
sale_date__c, 2020-06-01
sale_price__c, 2200000
selling_agent_mls_id__c, 666666
selling_agent_name__c, Non Member Sales
selling_agent_number__c, 666666
selling_co_agent_mls_id__c, 666666
selling_co_agent_name__c, Non Member Sales
selling_co_agent_number__c, 666666
selling_co_office_mls_id__c, NMSS
selling_co_office_name__c, NONE
selling_co_office_number__c, 2691
selling_office_name__c, NONE
pba__status__c, Closed
pba__totalarea_pb__c, 1220
size__c, 1220
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Powell
subdist__c, North Beach
ffd_name, 1731 Powell Street #401, San Francisco, CA, 94133
transportation__c, 1 Block
unit_number__c, 401
view__c, Ocean;City Lights;Bay;Water;San Francisco
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/362986-1.jpg
ListingId, a0E1I00000Slc66UAB