meta_query='key:subdist__c;value:The Mission|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='375648' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15716
[post_author] => 4
[post_date] => 2018-11-02 19:54:31
[post_date_gmt] => 2018-11-02 19:54:31
[post_content] => Ground zero for gentrification arguments in almost every housing cycle. Flat streets, sunny weather, historical cultural institutions, and colorful street life. Welcome to the Mission, where hipsters zoom down Valencia on tomorrow's transport idea while humble housekeepers hustle hard with their heads down.
[post_title] => The Mission
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => the-mission
[to_ping] =>
[pinged] =>
[post_modified] => 2024-03-19 14:14:15
[post_modified_gmt] => 2024-03-19 21:14:15
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15716
[menu_order] => 0
[post_type] => community
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
[ancestors] => Array
(
)
[page_template] =>
[post_category] => Array
(
)
[tags_input] => Array
(
)
)
_yoast_indexnow_last_ping, 1712710508
ffd_listing_title, 601 Alabama Street #309, San Francisco, CA, 94110
ffd_mls_id, 424000540
ffd_salesforce_id, a0EUd000000lfvlMAA
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 34
address2__c, 601 Alabama Street #309, San Francisco, CA, 94110
pba__address_pb__c, 601 Alabama Street #309, San Francisco, CA, 94110
agent_only_remarks__c, please call or text 415-418-9086 with any questions'-Lockbox location please text Gina for the location and we can also show by private appointment if necessary. Escrow opened with WFG title Georgine Lonero on Portola, seller requests escrow to stay there. Call or text Gina at 415-418-9086 with any questions or concerns. Seller will pay one year of HOA dues at closing for the buyer Disclosures by disclosures io https://app.disclosures.io/link/601-Alabama-309-5z9cgjwt
appliances__c, Dishwasher;Microwave;Disposal;Built-In Gas Range;Built-In Gas Oven
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 2009
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2024-03-27
cooling__c, None
ffd_createddate, 2024-01-09T18:46:24.000+0000
days_on_market__c, 91
dom__c, 87
ffd_description_pb, Highest Floor Condo, architect Daniel Solomon designed building. Features bamboo flooring, master en-suite bedroom plus two more bedrooms with hallway bath. New lighting throughout. Newly painted cabinetry with granite countertop, serving bar, and stainless steel appliances and sink. One car assigned parking, Office nook in the master. Close to some of the hottest restaurants, cafes, and bars including Tartine Manufactory, Flour and Water, Trick Dog, Universal Cafe and more!
district__c, SF District 9
driveway_sidewalks__c, Gated,Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Bamboo;Carpet;Tile;Wood
hoa_fee_includes__c, Common Areas,Gas,Internet,Maintenance Exterior,Maintenance Grounds,Management,Trash,Water,Other
pba__hoafees__c, 944
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 601 Mosaica HOA
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Gas
ffd_lastmodifieddate, 2024-04-10T00:46:28.000+0000
pba__latitude_pb__c, 37.761034
pba__latitude_property__c, 37.761034
laundry_features__c, Washer Included;Dryer Included
listed_date__c, 2024-01-09
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Gina
pba__listing_agent_lastname__c, Gianopoulos
listing_agent_mls_id__c, 811292
ffd_listingagentname, Gina R Gianopoulos
listing_agent_number__c, 1050758
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, FOUN
listing_office_name__c, Founders Real Estate Svcs.
listing_office_number__c, 1084
pba__listingprice_pb__c, 1098800
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.411506
mls_id__c, 424000540
master_property__c, a0O1I000001ViMsUAK
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2024-01-09
original_price__c, 1198800
overall_days_on_market__c, -81822
parking_access__c, Independent
parking_features__c, Assigned
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2024-04-05
possible_bedrooms__c, 0
pba__pricechangedat__c, 2024-04-09T09:49:40.000+0000
price_per_square_foot__c, 760.84
pba__propertytype__c, Condominium
ListingId, a0EUd000000lfvlMAA
room_type__c, Office;Kitchen;Primary Bathroom
sale_date__c, 2024-04-08
sale_price__c, 1088000
selling_agent_mls_id__c, MLSL309908
selling_agent_number__c, 981202759
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Miles Ito, Broker
pba__status__c, Closed
pba__totalarea_pb__c, 1430
size__c, 1430
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Alabama
subdist__c, The Mission
ffd_name, 601 Alabama Street #309, San Francisco, CA, 94110
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 2009
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530717700-1.jpg