meta_query='key:subdist__c;value:North Beach|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='212108' 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-11-18 22:38:07
[post_modified_gmt] => 2024-11-19 06:38:07
[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, 774 Green Street, San Francisco, CA, 94133
ffd_mls_id, 497565
ffd_salesforce_id, a0E1I00000SlZj7UAF
num_of_fireplaces__c, 0
num_of_rooms__c, 5
of_units__c, 3
address2__c, 774 Green Street, San Francisco, CA, 94133
pba__address_pb__c, 774 Green Street, San Francisco, CA, 94133
agent_only_remarks__c, Pre-Sale Escrow open w/ Bethe Battalio at Fidelity National Title. Please use SFAR Purchase Agreement. Lockbox appointment per SFAR regulations only and must be made in advance.
appliances__c, Gas Range
architectural_style__c, Edwardian
bath_features__c, Tub w/Shower Over;Split Bath
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1910
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2020-06-25
ffd_createddate, 2020-05-08T10:46:56.000+0000
days_on_market__c, 1698
dom__c, 62
ffd_description_pb, Beautiful Bay views! This gorgeous full floor condominium, in three-unit vintage 1910 building, is just steps to North Beach's fine dining and shopping. Classic Edwardian details, features sunny living room with fireplace showcasing original tiles and metal fireplace and built-in cabinetry. Spacious rooms featuring vintage wood railings and beautiful hardwood floors, split bath with shower over tub, parlor/dining room with built-in china cabinet, wainscoting and fireplace. Includes parking and storage. 3D virtual tour available!
district__c, SF District 8
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Gas Piped
pba__floor__c, 0
pba__floortype_pb__c, Tile;Wood
hoa_dues__c, 250
pba__hoafees__c, 250
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2022-01-25T15:21:33.000+0000
pba__latitude_pb__c, 37.799377
pba__latitude_property__c, 37.799377
laundry_appliances__c, Washer/Dryer,In Laundry Room
laundry_features__c, Inside Room;Washer/Dryer Included
listed_date__c, 2020-05-01
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Judson
pba__listing_agent_lastname__c, Cassels
listing_agent_mls_id__c, 810138
ffd_listingagentname, Judson Cassels
listing_agent_number__c, 1044920
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, VANG02
listing_office_name__c, Vanguard Properties
listing_office_number__c, 166013449
pba__listingprice_pb__c, 1395000
pba__listingtype__c, Sale
pba__listing_website__c, https://casselsrealty.com/774-green
pba__longitude_pb__c, -122.411916
pba__lotsize_pb__c, 0
mls_id__c, 497565
master_property__c, a0O1I000009q2ngUAA
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-05-08
original_price__c, 1455000
overall_days_on_market__c, 115
parking_access__c, Independent
parking_features__c, Garage
parking_type__c, On Site - Mapped (Condo Only)
pba__pendingdate__c, 2020-07-09
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1169.16
pba__propertytype__c, Condominium
id, a0E1I00000SlZj7UAF
sale_date__c, 2020-07-21
sale_price__c, 1327000
selling_agent_mls_id__c, 810512
selling_agent_name__c, Gabrielle F. Bunker
selling_agent_number__c, 1046582
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Redfin
pba__status__c, Closed
pba__totalarea_pb__c, 1135
size__c, 1135
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Green
subdist__c, North Beach
ffd_name, 774 Green Street, San Francisco, CA, 94133
view__c, Bay;Bay Bridge
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1910
pba__postalcode_pb__c, 94133
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/362594-1.jpg
ListingId, a0E1I00000SlZj7UAF
_yoast_indexnow_last_ping, 1735655807