meta_query='key:subdist__c;value:North Beach|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='215038' 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, 1856 Powell Street #202, San Francisco, CA, 94133
ffd_mls_id, 506537
ffd_salesforce_id, a0E1I00000THo4UUAT
num_of_fireplaces__c, 0
num_of_rooms__c, 3
of_units__c, 6
address2__c, 1856 Powell Street #202, San Francisco, CA, 94133
pba__address_pb__c, 1856 Powell Street #202, San Francisco, CA, 94133
agent_only_remarks__c, All showings to be Covid-19 compliant with PEAD forms to be submitted prior to showing appointment. Full disclosures via Disclosures.io with home and pest inspection reports are available upon request. Contact Listing Agent for appointment and how offers will be handled. Pre-escrow open with Elisabeth Davis of Fidelity National (Market St.- Castro Office). The large patio is exclusive use to this unit- 220 sq feet! Property website is www.1856powell.com The Japanese Maple and 2 lanterns on the patio are not included in the sale.
appliances__c, Dishwasher;Gas Range;Disposal;Refrigerator;Freezer
bath_features__c, Tub w/Shower Over;Remodeled;Marble;Low-Flow Toilet(s);Radiant Heat
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 1
year_build_text__c, 1934
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-09-24T19:47:21.000+0000
days_on_market__c, 1028
dom__c, 7
ffd_description_pb, Welcome home to this charming North Beach condo with quintessential 1930's character & period details plus its own large, exclusive use private patio space (220 sq. feet!- not included in square footage calculations of the unit!) This well appointed and laid out 1 bed/1 bath condo has hardwood floors, good natural light, a formal dining area leading into a nice sized living room equipped with its own built in home office area, a beautifully renovated bathroom, 1 car side by side parking, and an additional storage closet. The private patio is flooded with natural light and beautiful plantings. This unit is part of an extremely well managed 6 unit HOA and is located in one of North Beach's best locales! All of the restaurants, nightlife, outdoor activities at Washington Square, public transportation, retail shops, and so much more are right outside your front door! This home is perfect as a primary residence, or even for an investment opportunity or a pied-a-terre. Truly a must see
district__c, SF District 8
entry_level__c, 0
external_listing__c, 1
pba__floor__c, 0
pba__floortype_pb__c, Linoleum;Tile;Wood
hoa_dues__c, 547.84
hoa_fee_includes__c, Maintenance Exterior,Trash,Heat,Water
pba__hoafees__c, 547
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 1856 Powell St. HOA
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Steam
ffd_lastmodifieddate, 2022-01-25T15:35:32.000+0000
pba__latitude_pb__c, 37.801903
pba__latitude_property__c, 37.801903
laundry_appliances__c, Washer/Dryer,In Basement
laundry_features__c, Washer/Dryer Included;In Basement
listed_date__c, 2020-08-13
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Eric
pba__listing_agent_lastname__c, Rahe
listing_agent_mls_id__c, 806789
ffd_listingagentname, Eric T Rahe
listing_agent_number__c, 166017619
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, VANG03
listing_office_name__c, Vanguard Properties
listing_office_number__c, 1228
pba__listingprice_pb__c, 899000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.1856powell.com
pba__longitude_pb__c, -122.410891
pba__lotsize_pb__c, 0
mls_id__c, 506537
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Dining Room
master_property__c, a0O1I000001ViSqUAK
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-09-24
original_price__c, 899000
overall_days_on_market__c, 111
parking_access__c, Side by Side
parking_features__c, Attached,Enclosed,Garage Door Opener,Interior Access,Side-by-Side,Garage
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2020-10-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1176.47
pba__propertytype__c, Condominium
id, a0E1I00000THo4UUAT
sale_date__c, 2020-10-22
sale_price__c, 900000
selling_agent_mls_id__c, 347395
selling_agent_name__c, Betty A. Taisch
selling_agent_number__c, 347395
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 765
size__c, 765
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Powell
subdist__c, North Beach
ffd_name, 1856 Powell Street #202, San Francisco, CA, 94133
transportation__c, 1 Block
unit_number__c, 202
view__c, Garden/Greenbelt
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1934
pba__postalcode_pb__c, 94133
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/370956-1.jpg
ListingId, a0E1I00000THo4UUAT